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 than the transactions QuickBooks automatically downloads when they first connect their online bank accounts. If you do, you'll need to edit your opening balance. There are a few ways to handle this and we'll show you both options.

New to reconciling? Start with our reconcile guide.

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.

Note: It's much easier to add older transactions before you reconcile an account for the first time. If you've already reconciled the account a few times, you can still add older transactions. However, you may need help from your accountant.

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 the Accounts menu. Then select Chart of Accounts.
  2. Find and open the account.
  3. Search the account register for the opening balance entry. It should be labelled Opening Balance Equity with “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.