# Opening Balances When Switching to Xero

- Author: SimpleBankConvert (https://simplebankconvert.com)
- Published: 2026-10-17
- Category: Switching accounting software
- Canonical: https://simplebankconvert.com/blog/opening-balances-when-switching-to-xero

> How to enter opening balances when switching to Xero: conversion balances, bank account balances and open invoices so later imports start right.
Opening balances when switching to Xero are the figures from your old books on the day before your conversion date: each bank and card balance, what customers owe, what you owe suppliers and the equity that balances them. Enter them as Xero's conversion balances, add each open invoice and bill, and prove the bank figures with the first statement import.

## What Xero conversion balances are and the date they belong to

Conversion balances are Xero's name for opening balances: a snapshot of every balance sheet account at the moment your old system stops and Xero starts. The conversion date is the first day you record transactions in Xero. The balances themselves belong to the end of the day before it, so a November 1 conversion uses October 31 figures.

Pick a month start for the conversion date, and ideally a year start. Your bank prints a balance at each month end, your old system can close a month cleanly, and your accountant can tie the figures to a set of finished accounts.

### Which accounts get a balance

Only balance sheet accounts carry a conversion balance: bank accounts, credit cards, loans, receivables, payables, sales tax owed, fixed assets and equity. Income and expense accounts start at zero in Xero. If the conversion date falls mid-year, this year's profit so far goes into equity as part of the balance, which is one reason a year-start date keeps things simpler.

### Converted file or fresh start

Xero's page on [converting from QuickBooks](https://www.xero.com/us/accounting-software/convert-from-quickbooks/) describes a fresh-start option in which you enter your business's account balances directly from your most recent tax return. If you use Xero's automated conversion instead, the balances come with the converted data, and your job shifts from entering them to checking them.

## Pulling a trial balance from the old system for Xero

A trial balance is a report listing every account with its debit or credit balance on one date. It is the best source for conversion balances, because it already sorts figures into debits and credits. Run it in your old software as of the day before the conversion date, once that month is fully entered and reconciled.

Where to find it depends on what you are leaving:

- **QuickBooks Online:** run the Trial Balance report for the date, then save it. Intuit's guide to [exporting reports, lists and more](https://quickbooks.intuit.com/learn-support/en-us/help-articles/export-reports-lists-and-more/00/261915) covers saving reports as Excel files.
- **Zoho Books, Wave, FreshBooks and others:** most have a trial balance or balance sheet report. Moving out of Zoho Books into a different program follows similar steps, as [switching from Zoho Books to QuickBooks](/blog/switch-from-zoho-books-to-quickbooks) shows for that route.
- **A spreadsheet or a shoebox:** you will build the trial balance yourself from statements, invoice lists and your last tax return, usually with an accountant.

Save the report as a file and keep it with your records. It is the document anyone will ask for if a figure is questioned later.

## Which bank figure is the Xero opening balance: statement or ledger?

The opening balance in Xero is the ledger balance, meaning the bank account's balance in your books, not the number printed on the statement. The two match only when every check, card payment and deposit had cleared by the cut-off. When something had not cleared, the ledger and statement differ, and the difference is exactly the uncleared items.

This confuses many people because the statement number feels more trustworthy. It is, for proving the books. But the balance sheet shows what the business owns after its own payments, and a check you have written is already spent even if the payee has not cashed it.

If your old books were reconciled at the cut-off, you can prove the ledger figure from the reconciliation report: statement balance, less uncleared payments, plus uncleared deposits, equals the ledger.

## Uncleared checks and deposits in a Xero bank opening balance

Uncleared items are payments and deposits recorded in your old books before the conversion date that the bank had not processed by then. They need entering in Xero as individual transactions dated before the conversion date. When each one finally appears on the bank statement, Xero has a matching transaction to reconcile it to.

### A worked adjustment

The figures are an example for a conversion on November 1.

| Item | Amount | Effect on ledger |
| --- | --- | --- |
| Bank statement balance, Oct 31 | 18,240.00 | Starting point |
| Check 2051 to landlord, written Oct 30, not cleared | -2,400.00 | Lowers the ledger |
| Check 2052 to supplier, written Oct 31, not cleared | -615.50 | Lowers the ledger |
| Customer deposit made Oct 31, credited Nov 2 | +1,100.00 | Raises the ledger |
| Ledger balance, Oct 31 | 16,324.50 | Xero conversion balance |

The conversion balance for the account is 16,324.50. The two checks and the deposit are entered as separate transactions dated October 30 and 31, so they wait in Xero as unreconciled. In early November, when the bank shows check 2051 clearing, you match it to the October 30 entry rather than creating a new expense.

### A common slip

The usual mistake is entering the statement balance, 18,240.00, as the conversion balance. Xero's article on [the accounting behind conversion balances](https://central.xero.com/0/article/The-accounting-behind-Xero-conversion-balances) explains that Xero posts its conversion journal so each account equals the balance you enter, taking into account transactions already dated before the conversion date. So even with the uncleared items entered, the account would sit at 18,240.00, which is 1,915.50 too high: the two checks less the deposit. Enter the ledger balance, and add the uncleared items as separate transactions.

## Open invoices and bills behind Xero's receivable and payable balances

Receivables and payables in Xero need the individual invoices and bills behind them, not only totals. A customer who owed you on the conversion date will pay after it, and Xero can only record that payment against an invoice it holds. Enter each open invoice and bill with its original date, number and remaining amount.

Take the lists from your old system's aged receivables and aged payables reports as of the day before the conversion date. Their totals must equal the receivable and payable lines on the trial balance. If they do not, the old books have an unapplied payment or a stray journal that needs fixing before you convert, not after.

For partly paid invoices, enter only the unpaid part. A 2,000.00 invoice with 500.00 received before the cut-off becomes a 1,500.00 open invoice in Xero, with a note of the original amount in the description so the customer's statement makes sense.

Once they are in, run Xero's own aged receivables and aged payables reports for the day before the conversion date. Their totals should equal the aging reports you took from the old system, invoice for invoice. A customer who appears in one list and not the other is the quickest clue to a missed entry.

Credit notes and supplier credits need the same care. An unused credit a customer held at the cut-off is money you owe them, so enter it as a credit note dated before the conversion date and it can be applied to their next invoice.

## Do Xero opening balances need to balance to zero?

Yes. Total debits must equal total credits, as on any trial balance. Assets usually sit on the debit side; liabilities and equity sit on the credit side. If the two sides differ, a figure is missing or entered on the wrong side, and posting the gap to a suspense or equity line only hides the problem.

### An example conversion balance sheet

These figures are illustrative, for a small business converting on November 1.

| Account | Debit | Credit |
| --- | --- | --- |
| Business checking (ledger) | 16,324.50 | |
| Savings | 9,000.00 | |
| Accounts receivable | 7,850.00 | |
| Equipment | 4,200.00 | |
| Business credit card | | 1,934.20 |
| Accounts payable | | 2,640.00 |
| Sales tax payable | | 512.30 |
| Owner's equity and retained earnings | | 32,288.00 |
| **Totals** | **37,374.50** | **37,374.50** |

An overdrawn bank account goes on the credit side. A card with a credit balance, because you overpaid it, goes on the debit side. Those two reversals cause most of the mismatches people run into.

If you are moving between Intuit products rather than into Xero, the balance logic is the same but the screens differ; [moving from QuickBooks Self-Employed to QuickBooks Online](/blog/quickbooks-self-employed-to-quickbooks-online) covers what transfers there.

## Testing Xero opening balances with the first statement import

The first bank statement after the conversion date is the test. Import or feed in November's lines, reconcile them, and check that Xero's closing bank balance for November 30 equals the statement's closing balance. If it does, the conversion balance and the uncleared items were right. If it does not, the difference points to the item that went wrong.

### Reading the difference

- **Off by an uncleared check's amount:** that check was counted twice, or never entered.
- **Off by a round figure:** a conversion balance was typed with a digit wrong.
- **Off by the whole October activity:** the conversion balance was taken from the wrong month.

### When the first month arrives as a PDF

If the bank feed is not connected yet, November has to come in as a statement file, and the bank may offer only a PDF. SimpleBankConvert is being built to turn that PDF into a CSV in the layout Xero's statement import expects; the [get started page](/get-started) has the early access sign-up. Whatever tool makes the file, it should prove the statement's own opening and closing balances before you import, the check described in [what to look for in a PDF to QBO converter](/blog/pdf-to-qbo-converter).

Once November reconciles, every later month builds on a balance you have proven.