Reconcile transactions that are older than your opening balance in QuickBooks Online

Learn how to review and edit your opening balance if you recently added older transactions to your account.

The opening balance tells QuickBooks when you want to start tracking transactions in an account. It summarises all of your older transactions up to that point.

Later on, you may want to add transactions that are older than the opening balance. Some users need more transactions than QuickBooks automatically downloads when they first connect their online bank accounts. If you do, you'll need to adjust your opening balance. There are a few ways to handle this, and we'll show you both options.

Track older transactions the easy way

Since your opening balance summarises all of your older transactions, you don't have to enter them at all. They're already in QuickBooks. You can simply leave your opening balance alone and start tracking new transactions going forward.

Track all the details for older transactions

If you decide you need your older transactions, you have to edit the opening balance and the date. This resets the starting point for the account so QuickBooks doesn't count transactions twice.

Step 1: Enter older transactions

If your account is connected to online banking, download the transactions from your bank and import them manually.

You can also enter individual transactions as sales receipts or expenses.

Step 2: Edit your opening balance

1. Go to Transactions and select Chart of accounts (Take me there).
2. Find and open the account.
3. Search the account history for the opening balance entry. It should be labelled Opening Balance Equity with the text Opening Balance in the Memo column.
4. Sign in to your bank’s website. Set your account so you can see the balance for the new date you want to use for the opening balance in QuickBooks.
5. Go back to QuickBooks. Select your opening balance entry.
6. Edit the opening balance so the date and amount match your bank records for the day you choose.

This sets a new opening balance for the account. Since the new opening balance matches your bank records, everything is balanced.

Reconcile the account

Now that your opening balance is fixed, you're ready to start reconciling.

If you run into problems during your first reconciliation, don't worry. Here's how to fix issues the first time you reconcile an account.

Or, if you've already reconciled the account in the past, here's how to fix those issues.