Migrating your accounts to Xero can make your finance operation faster, more connected and easier to manage. But moving data from one accounting system to another does not automatically mean that your new Xero file is accurate.
A migration can look successful on the surface while still containing missing transactions, incorrect opening balances, duplicated data, unreconciled accounts or VAT errors.
That is why a Xero migration audit checklist is so important.
Before you rely on your Xero reports for management decisions, VAT returns, cash-flow planning or year-end accounts, you need to establish whether the migrated data is complete, accurate and properly reconciled.
In this guide, we explain what to check after a Xero migration, the most common migration issues to look for, and how to determine whether your Xero accounts can be trusted.
What Is a Xero Migration Audit?
A Xero migration audit is a structured review of your Xero accounting data after moving from another accounting system or financial platform.
The purpose is not simply to check whether data has transferred. It is to determine whether the information in Xero agrees with your source system, supporting records and bank balances.
A proper post-migration review can include:
- Opening balances
- Bank accounts
- Bank reconciliation
- Sales invoices
- Purchase bills
- Accounts receivable
- Accounts payable
- VAT records
- Chart of accounts
- Profit and Loss reports
- Balance Sheet reports
- Fixed assets
- Loans and liabilities
- Tracking categories
- Historical transactions
- Connected applications
- Duplicate or missing transactions
The exact checks required depend on the source accounting system, the migration method, the amount of historical data transferred and the requirements of the business.
The important point is simple:
Data being visible in Xero does not necessarily mean the data is correct.
Why Should You Audit Your Xero Data After Migration?
A migration usually involves extracting data from one system, transforming or mapping it, and importing it into another.
Every stage creates opportunities for errors.
For example, an account in your old system may have been mapped to the wrong Xero account. Historical transactions may not have been transferred. Opening balances may have been entered incorrectly. VAT codes may have changed. Bank transactions may have been duplicated.
Some errors are obvious. Others only become apparent when you compare reports.
This is why businesses should not wait until year-end to discover that their migrated accounts contain problems.
A post-migration audit gives you an opportunity to identify and correct issues while the migration is still fresh and the source data is available.
It can also help you:
- Improve confidence in your financial reports
- Reduce the risk of incorrect VAT reporting
- Identify unreconciled transactions
- Confirm opening balances
- Prevent duplicate transactions
- Check historical data
- Validate customer and supplier balances
- Ensure integrations are working correctly
- Establish a reliable starting point for ongoing bookkeeping
Think of it as a quality-control stage between “the migration is complete” and “we can trust the numbers.”
Xero Migration Audit Checklist
Use the following checklist as a practical starting point for reviewing your migrated Xero accounts.
1. Check the Opening Balances
Opening balances are one of the most important areas to review after a migration.
Your Xero opening balances should agree with the closing balances from the previous accounting system for the same migration date.
Pay particular attention to:
- Bank accounts
- Accounts receivable
- Accounts payable
- VAT or tax balances
- Loans
- Fixed assets
- Accumulated depreciation
- Equity
- Retained earnings
- Other balance sheet accounts
Do not simply check the total balance sheet.
Review individual accounts where possible.
If the previous system showed a bank balance of £25,000 at the migration date but Xero starts with £23,500, you need to understand why.
An unexplained opening-balance difference can affect every report produced after the migration.
Internal link suggestion: Link “opening balances” to your Xero migration service or a dedicated guide explaining how opening balances are handled during accounting software migration.
2. Verify Your Bank Account Balances
Bank accounts are often one of the easiest places to identify migration problems.
Compare the balances in Xero with:
- Your bank statements
- The previous accounting system
- The migration cut-off date
- Your bookkeeping records
The balance should make sense at the exact point where the migration took place.
Also check whether transactions immediately before or after the migration date have been handled correctly.
A common problem is a gap or overlap between the source system and Xero.
For example, if transactions from 1 January to 31 December were imported but the opening balance was also calculated using those transactions, the account could effectively include the same activity twice.
3. Review Bank Reconciliations
Having transactions in a bank account is not the same as having a reconciled bank account.
Review the reconciliation status of each bank account in Xero.
Look for:
- Unreconciled transactions
- Duplicate transactions
- Incorrect matches
- Missing transactions
- Transactions assigned to the wrong accounts
- Incorrect dates
- Unusual adjustments
If you have a large backlog of unreconciled transactions after migration, do not simply mark everything as reconciled to make the account appear clean.
Investigate the underlying differences first.
A bank reconciliation should provide evidence that the accounting records agree with the actual bank activity.
4. Check the Chart of Accounts
The chart of accounts determines how transactions are classified and how your financial reports are presented.
During a migration, account mappings may not always transfer exactly as expected.
Review whether:
- Revenue accounts are correctly classified
- Cost of sales accounts are correct
- Expense accounts are mapped properly
- Asset accounts are correctly identified
- Liability accounts are correctly classified
- Equity accounts are correct
- VAT control accounts are appropriate
- Unused or duplicate accounts have been identified
You should also check whether the Xero chart of accounts still supports the way your business wants to report its finances.
Migration is often an opportunity to clean up an unnecessarily complicated chart of accounts, but changes should be made carefully so that historical reporting remains understandable.
Internal link suggestion: Add an internal link to your finance transformation or Xero setup service when discussing chart-of-accounts optimisation.
5. Compare Accounts Receivable
If your business sells on credit, accounts receivable needs careful attention.
Compare outstanding customer balances in Xero against the previous accounting system.
Check:
- Outstanding invoices
- Invoice dates
- Invoice amounts
- Credit notes
- Customer balances
- Overdue invoices
- Payments allocated to invoices
The total accounts receivable balance in Xero should be explainable in relation to the source system.
Do not overlook individual customer accounts.
A total balance can appear correct even when individual customer balances are wrong.
That can create problems for credit control and customer statements later.
6. Review Accounts Payable
Perform the same exercise for supplier balances.
Compare your Xero accounts payable balance with the previous system and supporting records.
Review:
- Outstanding bills
- Supplier credits
- Payments
- Due dates
- Supplier balances
- Duplicate bills
- Missing bills
If supplier balances do not agree, identify whether the difference comes from missing transactions, duplicated transactions, payment allocation or opening balances.
7. Verify VAT and Tax Data
VAT deserves particular attention after a migration.
Incorrect VAT codes or historical VAT treatment can affect both accounting reports and tax returns.
Review:
- VAT rates
- VAT codes
- VAT control accounts
- Historical VAT transactions
- VAT returns
- VAT payments
- VAT refunds
- Reverse-charge transactions where applicable
- Transactions around the migration date
If you are migrating during an active VAT period, establish exactly how transactions have been treated on either side of the migration cut-off.
Do not assume that a VAT return being accepted means the underlying accounting data is necessarily correct.
If you identify a historical VAT issue, obtain appropriate advice before making adjustments.
8. Compare Profit and Loss Reports
One of the most useful Xero migration audit techniques is to compare reports from the old and new systems.
Run comparable Profit and Loss reports for an appropriate period.
Compare:
- Revenue
- Cost of sales
- Gross profit
- Operating expenses
- Other income
- Other expenses
- Net profit
If there are material differences, investigate them.
Differences can arise from:
- Incorrect account mapping
- Missing transactions
- Duplicate transactions
- Different accounting periods
- Incorrect transaction dates
- VAT treatment
- Reclassification
- Opening-balance issues
Not every difference means the migration is wrong, but every significant unexplained difference deserves investigation.
9. Compare the Balance Sheet
The Balance Sheet is another critical part of your Xero migration audit.
Compare the Xero Balance Sheet with the source system at the migration date and at relevant subsequent dates.
Pay close attention to:
- Cash and bank accounts
- Accounts receivable
- Accounts payable
- VAT
- Fixed assets
- Loans
- Other liabilities
- Equity
- Retained earnings
A Balance Sheet that does not agree with the source system should not simply be accepted without investigation.
The Balance Sheet often exposes problems that may not be obvious from individual transactions.
10. Look for Duplicate or Missing Transactions
Data duplication is one of the most common issues worth checking during a migration.
Search for transactions that may have been imported more than once.
Potential warning signs include:
- Duplicate bank transactions
- Duplicate invoices
- Duplicate bills
- Repeated journal entries
- Duplicate payments
- Repeated opening balances
At the same time, look for missing transactions.
Compare transaction totals and account activity between the source system and Xero.
If you migrated only selected historical data, document exactly what was and was not transferred.
This prevents someone from later assuming that Xero contains a complete historical record when it does not.
11. Check Tracking Categories
Tracking categories can be essential for businesses that report by:
- Department
- Location
- Project
- Business unit
- Product line
If tracking information was used in the old system, verify that the relevant information is available and correctly represented in Xero.
Without accurate tracking information, your overall Profit and Loss may look correct while management reports by department or project are unreliable.
This is particularly important for businesses that rely on Xero for management reporting rather than basic bookkeeping.
12. Review Customer, Supplier and Contact Data
Migration reviews should not focus only on accounting balances.
Review your contact data as well.
Check for:
- Duplicate contacts
- Incorrect names
- Missing contact records
- Incorrect email addresses
- Duplicate customer accounts
- Duplicate suppliers
- Incorrect invoice settings
- Incorrect tax treatment
Cleaning up duplicate contacts early can prevent future bookkeeping problems.
13. Check Fixed Assets and Depreciation
If your business has fixed assets, review them separately.
Check:
- Asset balances
- Acquisition dates
- Cost
- Accumulated depreciation
- Depreciation methods
- Current book values
- Asset categories
A migration that gets everyday transactions right can still produce incorrect financial statements if fixed assets have not been transferred correctly.
Compare the fixed asset register in Xero with your previous records.
Where necessary, have your accountant confirm the appropriate treatment.
14. Review Loans and Other Liabilities
Loans are another area where migration errors can be hidden.
Review:
- Loan opening balances
- Repayments
- Interest
- Current versus long-term portions
- Related journal entries
The balance shown in Xero should be supported by your loan statements and accounting records.
15. Test Your Xero Integrations
Many businesses connect Xero with other applications.
These might include:
- Payment platforms
- Ecommerce systems
- Payroll applications
- Expense management tools
- Point-of-sale systems
- Inventory platforms
- Banking feeds
After migration, verify that these integrations are configured correctly.
Check whether new transactions are entering Xero as expected and whether they are being coded correctly.
An accounting file can be accurate on migration day but become inaccurate later if an integration is incorrectly configured.
Common Xero Migration Problems to Watch For
While every migration is different, several problems appear repeatedly.
Incorrect opening balances
The starting figures in Xero do not agree with the closing figures from the previous system.
Missing historical data
Some transactions, invoices, bills or journals have not been transferred.
Duplicate transactions
The same activity has been imported more than once.
Incorrect account mapping
Transactions have been assigned to the wrong accounts.
Unreconciled bank accounts
Bank transactions have transferred but have not been properly matched or reconciled.
Incorrect VAT treatment
Transactions have been assigned inappropriate VAT codes or historical VAT information has not been handled correctly.
Customer and supplier discrepancies
Individual balances do not agree with the previous system.
Reporting differences
The Xero Profit and Loss or Balance Sheet differs significantly from the source system without a documented explanation.
Integration problems
Connected applications continue to send incorrect, duplicated or incomplete data after migration.
These problems are precisely why a migration should have a proper review stage.
What to Do If Your Xero Numbers Don’t Match
Finding a discrepancy does not necessarily mean the entire migration has failed.
The important thing is to investigate the difference systematically.
Start by identifying where the difference occurs.
For example, if the Balance Sheet differs by £5,000, determine which account or accounts create the difference.
Then establish the source of the discrepancy.
Ask:
- Is the transaction missing?
- Has it been duplicated?
- Was it mapped to the wrong account?
- Is the transaction dated differently?
- Is the opening balance incorrect?
- Was VAT treated differently?
- Was the transaction intentionally excluded from the migration?
Once the cause is identified, document the correction.
Then rerun the relevant reports and confirm that the adjustment has resolved the difference.
Avoid making unexplained journal entries simply to force two systems to agree.
A reconciliation should explain why the numbers agree, not just make them appear to agree.
When Should You Get a Xero Migration Review?
A professional Xero migration audit can be particularly valuable if:
- You recently migrated from another accounting system
- Your opening balances do not agree
- Bank accounts are showing unexplained differences
- You have a large number of unreconciled transactions
- Your Profit and Loss does not match the previous system
- Customer or supplier balances look incorrect
- You are unsure whether historical transactions migrated correctly
- VAT reporting is causing concern
- You inherited a Xero file from another bookkeeper
- Several integrations are connected to Xero
- You are preparing for year-end
- You need confidence in your management reports
It can also be useful when a migration was completed quickly without a formal reconciliation or post-migration quality check.
How Ecloud Experts Can Help
A Xero migration should be more than a technical data transfer.
It should leave you with a finance system that you can confidently use for bookkeeping, reporting and decision-making.
At eCloud Experts, we help businesses review, clean up and optimise their accounting data so they can get more value from Xero.
Our support can include reviewing migrated data, identifying discrepancies, checking reconciliations, reviewing account mappings and helping resolve issues that affect the reliability of your financial reports.
If your Xero file has already been migrated but you are not completely confident in the numbers, you do not necessarily need to start again.
A structured Xero migration audit can help establish what is correct, what needs attention and what should be fixed.
Your Xero Numbers Should Be Trusted — Not Assumed
Completing a migration is an important milestone, but it is not the end of the process.
The real test is whether your new Xero environment produces financial information that is complete, accurate, reconciled and understandable.
Use this Xero migration audit checklist to review the critical areas:
- Opening balances
- Bank accounts
- Bank reconciliation
- Accounts receivable
- Accounts payable
- VAT
- Chart of accounts
- Profit and Loss
- Balance Sheet
- Historical transactions
- Tracking categories
- Fixed assets
- Liabilities
- Integrations
The earlier you identify migration issues, the easier they are generally to investigate and resolve.
Ready to Check Your Xero Migration?
If you have recently moved to Xero and are unsure whether your numbers are correct, eCloud Experts can help you review the data and identify areas that need attention.
Don’t wait until your next VAT return, management meeting or year-end accounts to discover a migration problem.
Request a Xero migration review today and get greater confidence in your numbers.
Frequently Asked Questions
What is a Xero migration audit checklist?
A Xero migration audit checklist is a structured set of checks used to verify the accuracy and completeness of financial data after migrating to Xero.
It typically covers opening balances, bank accounts, reconciliations, invoices, bills, VAT, account mappings, financial reports, historical transactions and integrations.
How do I check if my Xero migration was successful?
Start by comparing key balances and reports in Xero with your previous accounting system.
Check opening balances, bank accounts, accounts receivable, accounts payable, VAT, Profit and Loss and Balance Sheet figures. Then investigate any material differences.
A successful migration should produce data that is explainable and supported by your underlying records.
What should I check after migrating to Xero?
At a minimum, check:
- Opening balances
- Bank balances
- Bank reconciliation
- Customer balances
- Supplier balances
- VAT
- Chart of accounts
- Profit and Loss
- Balance Sheet
- Missing or duplicate transactions
- Fixed assets
- Loans
- Tracking categories
- Connected applications
The exact scope depends on your business and the data migrated.
Why don’t my Xero balances match my old accounting software?
There can be several reasons.
The migration may have excluded certain transactions, duplicated data, used different account mappings, calculated opening balances differently or applied different VAT treatment.
First identify the specific account creating the difference rather than making a general adjustment to force the totals to match.
How long does a Xero migration audit take?
There is no single timeframe.
A small business with limited historical data may require a relatively straightforward review, while a business with several years of transactions, multiple entities, complex VAT requirements or numerous integrations may require a much more detailed audit.
The scope should be based on the volume and complexity of the migration.
Should I audit Xero immediately after migration?
Yes, reviewing the file soon after migration is generally preferable.
The source system, migration mappings and migration documentation are easier to reference while the project is still fresh.
Early checks can also prevent incorrect data from being carried forward into future bookkeeping and reporting.
Can Xero migration errors be fixed?
In many cases, yes.
The appropriate correction depends on the cause of the issue. Some problems can be resolved through reconciliation or correcting transaction classifications, while others may require adjustments to opening balances, imports or migration mappings.
The key is to identify the underlying cause before making corrections.
Do I need to migrate all historical transactions to Xero?
Not necessarily.
The appropriate amount of historical data depends on your reporting requirements, business needs, compliance considerations and migration strategy.
If you do not migrate all historical transactions, document what remains in the previous system so that there is a clear audit trail.
What is the difference between Xero migration and Xero cleanup?
A Xero migration moves accounting data from one system into Xero.
A Xero cleanup identifies and corrects issues within an existing Xero file, such as unreconciled transactions, incorrect classifications, duplicate entries or historical bookkeeping problems.
Sometimes a business needs both: migration followed by cleanup and optimisation.
Why use a professional Xero migration audit service?
A professional review can provide an independent assessment of whether the migrated data is accurate and usable.
It can also identify issues that may not be obvious from a quick review of the Xero dashboard.
For businesses relying on Xero for VAT reporting, management accounts, cash-flow decisions or year-end reporting, confidence in the underlying data is essential.
