Handling Open Invoices and Bills During Your QuickBooks Desktop to Xero Migration

Migrating accounting systems is not just a technical exercise. It directly affects cash flow, reporting accuracy, and daily operations. One of the most common pain points during a QuickBooks Desktop to Xero conversion is handling open invoices and unpaid bills. If these are not managed carefully, you risk mismatched balances, confused clients and suppliers, and unreliable financial reports from day one in Xero.

The good news is that with a clear process, you can complete the conversion while keeping your receivables and payables clean, accurate, and fully traceable. This guide walks you through the two main approaches, the most common mistakes, and the steps that make the difference between a clean transition and months of cleanup.

Why Open Invoices and Bills Are the Highest-Risk Part of Any Conversion

Open invoices and unpaid bills are not static historical data. They represent active financial obligations that affect accounts receivable, accounts payable, cash flow forecasting, and tax reporting. During a QBD Migration to XERO, these transactions must carry forward seamlessly — the same amounts, the same dates, the same tax rates.

Get this wrong and you face duplicate invoices, misapplied payments, AR/AP aging reports that do not reconcile, and opening balance discrepancies that can take hours of correcting entries to resolve.

Two Approaches — Choose Based on Your Volume

Option 1: Recreate Open Invoices and Bills in Xero

This is the recommended approach for most businesses. It gives you full invoice-level visibility in Xero from day one.

You export all unpaid invoices and outstanding bills from QuickBooks Desktop, migrate your customers, suppliers, and chart of accounts first, then recreate only the open transactions in Xero using their original issue dates. Payments that come in after the cutover are applied in Xero naturally, keeping your reports clean.

Consider a firm managing this conversion mid-month with 18 unpaid customer invoices and 7 outstanding vendor bills. Rather than importing years of historical data, they recreate only these 25 transactions in Xero. The result is a clean AR and AP sub-ledger from day one, with no historical clutter.

Option 2: Post Summary Balances

For businesses with very high transaction volumes and limited need for invoice-level reporting in Xero, an alternative is to post summary opening balance entries for AR and AP. Individual invoices remain accessible in QuickBooks Desktop as a read-only historical reference.

The trade-off is real: you lose invoice-level collections tracking in Xero, which can complicate client follow-up and vendor management. For most service-based businesses and SMBs, Option 1 produces cleaner, more useful books.

Step-by-Step: How to Handle the Conversion Correctly

Step 1: Lock Down Your QuickBooks Desktop File

Before setting a cutover date, confirm that all bank accounts are fully reconciled up to that date, your AR and AP aging reports are accurate, and you have stopped posting new transactions. Any entry made after you begin the conversion will need to be manually reconciled against your Xero opening position.

Step 2: Choose a Cutover Date

This date determines what stays in QuickBooks Desktop as historical reference and what begins in Xero as live accounting. Every open invoice and unpaid bill as of this date must be accounted for in Xero. Document this date clearly — it becomes the baseline for every balance validation that follows.

Step 3: Export Open Transactions

From QuickBooks Desktop, export your open invoices including customer name, invoice date, due date, amount, and applicable tax, and your unpaid bills including supplier name, bill date, and outstanding balance. This export is your conversion blueprint and your validation benchmark.

Step 4: Migrate Contacts and Chart of Accounts First

Before entering a single invoice, your customers, suppliers, and chart of accounts must exist in Xero with correct mappings. Posting transactions to accounts that do not exist or are misclassified creates errors that are difficult to unwind later.

Step 5: Recreate Open Transactions in Xero

Enter each open invoice and unpaid bill using the original issue dates. Apply the same tax rates that were in use in QuickBooks Desktop, and confirm whether those rates should be entered tax-inclusive or tax-exclusive in Xero — these settings do not always match between systems. Verify your totals before proceeding.

Step 6: Validate Your Balances

After entry, compare your Xero accounts receivable total, accounts payable total, and individual customer and supplier balances against your QuickBooks Desktop reports as of the cutover date. These must match exactly. Any discrepancy here signals an error that needs to be corrected before you go live.

Handling Partial Payments

For invoices where a partial payment was made in QuickBooks Desktop before the cutover, recreate the invoice in Xero showing only the remaining balance. Payment history stays in QuickBooks Desktop as your historical record. This avoids importing transactions that have no further action required and keeps your new Xero environment focused on what actually needs to happen next.

Tax Accuracy During a Conversion

Tax settings deserve specific attention. Confirm that your tax rates in Xero match what was in use in QuickBooks Desktop, and verify that your tax control account balances are correct after entry. In Canada, this means confirming your GST/HST positions. In Australia, confirm your GST settings align with ATO reporting requirements. Incorrect tax handling creates compliance issues that compound over time and are far more difficult to fix after the fact.

Hypothetical Example: Year-End Conversion for a Retail Business

Consider a retail company converting from QuickBooks Desktop to Xero at year-end with 120 unpaid customer invoices and 45 outstanding vendor bills. They recreate only open transactions, verify AR and AP aging reports against their QuickBooks Desktop baseline, and map tax codes carefully. The result is zero balance discrepancies, a smooth collections process, and accurate opening financial statements in Xero from the first day of trading. This outcome is achievable when the process is followed correctly — it is not guaranteed without the validation step.

What Not to Do

The most common conversion mistakes are importing all historical invoices instead of just open ones, mixing summary opening balances with individual invoice recreation (which makes reconciliation nearly impossible), continuing to post transactions in QuickBooks Desktop while the conversion is in progress, and skipping the balance validation step entirely. Each of these creates rework that costs far more time than the careful approach would have.

Before You Go Live

Confirm that your AR and AP balances match your QuickBooks Desktop reports exactly on the cutover date, that all open invoices and bills are visible and correct in Xero, and that you have tested at least one payment and one bill settlement in Xero before the full team starts using it. Lock your QuickBooks Desktop file as a read-only historical reference.

A Conversion Done Right Protects Your Books Long-Term

Handling open invoices and bills correctly is one of the most important parts of any QuickBooks to Xero conversion. Done well, it gives you clean books, reliable reporting, and a smooth transition from day one. Done poorly, it creates months of correcting entries and client confusion.

WOW BookSwitch specializes in exactly this work. Our conversion process validates your trial balance, balance sheet, and profit and loss against your QuickBooks Desktop source data before you ever go live in Xero — so discrepancies are caught and corrected, not inherited.

Related #HashTags:

#QuickBooksToXEROMigration #QBDMigrationToXERO #QuickBooksToXEROConversion #QuickBooksDesktopToXEROConversion #XeroAccounting #AccountingMigration #CloudAccounting #SMBAccounting