Convert QuickBooks to Xero for a Client 2026
Convert QuickBooks records to Xero with a controlled client handover. Check transfer limits, opening balances and the first reconciled reporting period.
- Published
- Updated
To convert QuickBooks to Xero, select a method that supports the client’s exact edition, preserve the source records and reconcile the new ledger before switching daily work.
A conversion can move accounting transactions without moving every supporting record. Keep payroll history, attachments and the original audit evidence in the handover, even when the new trial balance agrees.
Confirm the Source and Supported Conversion
Identify whether the client uses QuickBooks Online or Desktop, the country edition and the company file being moved. Record the required history and payroll arrangement before choosing the conversion service or creating the destination organisation.
Match the Edition to the Method
Jet Convert’s supported-file list includes Australian QuickBooks Online editions and Australian QuickBooks Version 2012/2013. Its Desktop Pro, Premier and Enterprise Windows entries are supported for the United States, with Australia marked unsupported.
A QuickBooks Desktop to Xero conversion therefore needs the actual version and country, not a general promise to convert QuickBooks. Jet Convert’s Desktop conditions also exclude multi-currency, multiple locations and advanced inventory. A US Desktop procedure does not establish support for an Australian file.
For supported QuickBooks Online records, Jet Convert documents access to the source organisation and conversion into Xero. Its regular service creates a new Xero organisation. An existing empty organisation follows a separate procedure, so identify that destination before starting.
For a manual opening-balance handover, use Xero’s conversion balances and supporting unpaid invoices and bills. Historical reports remain in the source archive unless separately imported. An Excel report export is useful evidence, but it is not a complete transaction migration.
Record two boundaries when historical transactions are included: the start of converted history and the point when staff switch daily work to Xero. They need not be the same. Use the converter’s selected history range when comparing historical reports.
Separate Transferable Data From Retained Evidence
| Record | Documented conversion treatment | Handover action |
|---|---|---|
| Invoices, bills and payments | Jet Convert documents transaction history within the selected scope | Reconcile outstanding items and review payment allocation |
| Chart of accounts and contacts | Included in Jet Convert’s documented conversion scope | Check account types, tax settings and duplicate contacts |
| Payroll | Setup and opening balances can transfer; detailed pay runs and payslips do not | Retain source payroll history and review employee balances |
| Attachments and audit logs | Jet Convert lists these as excluded | Preserve a separate archive linked to the original records |
| Bank reconciliation | Treatment depends on the converted transactions and their source status | Retain the source reconciliation and compare it before new processing |
| Bank rules and fixed asset register | Jet Convert lists these as excluded | Rebuild rules and retain or separately establish the asset register |
Jet Convert also excludes recurring transaction setups and custom reports. Assign someone to recreate the recurring invoices and report formats the client uses. Keep the existing schedules as evidence until their replacements work.
Payroll needs a separate decision about reporting through Single Touch Payroll (STP). Imported opening balances do not prove that employee reporting has transferred correctly. Retain the source reporting status and document which system will report each period.
Export, Convert and Reconcile
Freeze a reviewed source file before conversion, then compare Xero against that same version. Changes made during the transfer can make two individually correct reports disagree because they describe different records.
Prepare and Transfer the Records
- Agree on the cutover with the client. Finish coding and reconciliation to the agreed point, resolve known errors and record work that remains outstanding.
- Save the source trial balance and detailed reports. Include aged receivables and payables, bank reconciliations, tax reports and payroll balances for the same reporting boundaries.
- Preserve the source evidence. For Desktop, retain a backup that can be opened with the required software. For Online, retain exports and supporting documents, with access available throughout acceptance.
- Start the supported conversion. Use Jet Convert’s source-specific upload or access procedure, select the required history and confirm the Xero destination. Keep the conversion request and selected scope.
- Review the delivered organisation and its Action Checklist. Accept the subscriber invitation through the nominated client account, arrange staff access and reconcile before routine processing begins.
Intuit’s QuickBooks Online export instructions use Settings, then Export data. Select the report period and required Reports and Lists, then choose Export to Excel. Export supporting data separately where that function does not include it.
For an Online conversion, Jet Convert documents an accountant-access invitation from QuickBooks. Use its Australian access procedure for the client’s account. Give access through named users and keep a record of when conversion access is removed.
Reconcile a Fictional Client File
Assume a fictional client’s closing trial balance contains the following amounts. These are accounting balances, including the outstanding invoice and bill amounts, rather than a quoted conversion result.
| Account | Debit | Credit |
|---|---|---|
| Bank | $25,000 | |
| Accounts receivable | $11,000 | |
| Inventory | $8,000 | |
| Fixed assets, net | $20,000 | |
| Accounts payable | $7,700 | |
| GST payable | $2,300 | |
| Payroll liabilities | $4,000 | |
| Loan | $20,000 | |
| Equity | $30,000 | |
| Total | $64,000 | $64,000 |
Compare each Xero balance with this approved source total using the same period, accounting basis and account mapping. Equal debit and credit totals alone are insufficient. An incorrect account mapping can leave the trial balance balanced while changing reported profit or liabilities.
The receivables balance consists of unpaid invoices of $6,600 and $4,400. Payables consist of unpaid bills of $4,400 and $3,300. Confirm each item’s remaining balance and payment history, as well as the total.
For a manual balances conversion, Xero’s unpaid-invoice and bill procedure supports the receivables and payables conversion balances. Enter only the remaining balance of a part-paid item. When a converter already creates these records, reconcile them before adding anything else.
Reconcile the bank ledger to the bank statement and outstanding items. Save Xero’s initial bank reconciliation report before processing new transactions. Jet Convert explains that reconciliation reports change as further work occurs, so retain the compared versions.
Match the goods and services tax (GST) balance and report detail to the source records and lodged business activity statements. Review tax-code mappings and transactions spanning the cutover. A matching GST control-account balance does not establish that the next activity statement includes the correct transactions.
For payroll, compare employee year-to-date earnings, withholding and superannuation balances. Review leave and pay templates before the first pay run. Jet Convert’s Australian QuickBooks notes identify tax-setting updates for working holiday makers and study and training support loans.
Keep payroll discrepancies separate from accounting journals. A journal that fixes the payroll liability account does not correct an employee’s STP record. Follow the applicable payroll-switching procedure before reporting from Xero, with a retained record of the chosen treatment.
Complete the First Reporting Period
Reconcile the first reporting period to prove that the client can operate correctly in Xero. The opening comparison establishes the starting position. The next reconciliation exposes duplicated receipts, missing statement lines and incorrect recurring work.
Check Bank Feeds and Opening Items
Record the first statement line delivered by each bank feed. Compare that boundary with converted transactions and any bank-statement import. Import only missing statement lines, using the bank statement to identify gaps and overlaps.
A bank statement line and its matching accounting transaction can both be legitimate records. Match an existing converted receipt to the statement line instead of creating another receipt. Two accounting entries for the same receipt would overstate cash.
In the fictional file, the client next receives the $6,600 invoice payment and pays the $3,300 supplier bill. With no other movements, bank cash becomes $28,300. Receivables fall to $4,400 and payables fall to $4,400.
Those payments settle existing invoices and bills. Entering another sale or expense would duplicate the original accounting. Check the payment allocation and assess GST reporting under the client’s accounting basis separately.
Review bank rules and recurring invoices after recreating them. Confirm that supplier details, invoice numbering and user permissions fit the client’s work. Complete the first bank reconciliation and review the period’s tax and payroll reports against the supporting records.
Sign Off Before Retiring QuickBooks
Keep the reviewed source exports, converted reports and account mapping together. Record every conversion exception, its resolution and the reviewer’s sign-off. Name who owns the next bank reconciliation, activity statement and payroll reporting step.
If an opening balance differs, pause affected processing and trace the difference through the mapping and source records. Give the converter the affected account or transaction and both reports. Keep the source available while the corrected result is reconciled.
Intuit’s post-cancellation data guidance gives paid QuickBooks Online subscriptions one year of read-only access after cancellation. That period is not a long-term records archive. Export and preserve the required evidence before cancelling.
Retire the old daily workflow once opening balances agree, the first period reconciles and the client’s reporting responsibilities are assigned. Remove temporary conversion access after acceptance while preserving the records needed to explain both sides of the handover.
One client form. One finished return.
Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.
Made for Australian accounting firms