cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit
2151 helpful votes

Fix beginning balance issues during your first reconciliation in QuickBooks Online

Learn how to review your opening balance if you see issues the first time you reconcile an account.

If this is your first time reconciling an account and the beginning balance is off, don't worry. The issue is probably something very basic: the opening balance. This is the account's starting point. It tells QuickBooks when you want to start tracking transactions. The opening balance in QuickBooks needs to match the balance of your real-life bank account for whatever day you pick.

If you correct your opening balance, it also fixes your beginning balance. Here's how to fix opening balance issues so you can start reconciling.

New to reconciling? Start with our reconcile guide.
  • Someone entered an incorrect opening balance when you created the account in QuickBooks.
  • Someone adds transactions that are older than the opening balance and doesn't edit the original entry to reflect the change.
  • When you connect your accounts, QuickBooks enters the opening balance for you. Missing or duplicate transactions may affect the opening balance.

Step 1: Review the opening balance entry in QuickBooks

Double-check what you entered for the opening balance. Sometimes the opening balance doesn't include transactions that were still pending when you made the account.

  1. If you recently entered older transactions that come before your opening balance, here's how to reconcile them. Then continue with these steps.
  2. Go to the Accounting menu. Then select Chart of Accounts.
  3. Find the account on the list.
  4. Select View register to get more details.
  5. Search for the opening balance entry. It should have “Opening Balance Equity” in the Payee Account column and “Opening Balance” in the Memo column.Review
  6. Make a note of the date and balance.If you forgot to enter an opening balance but you're already tracking transactions in the account, don't worry. Here's how to enter an opening balance manually so your accounts stay balanced.

 

Step 2: Compare the balance to your real-life account

  1. Sign in to your bank's website, or find your bank statement.
  2. Set your account so you can see the balance for the day you set as your opening balance date in QuickBooks.
  3. Compare the balance on your bank records to what you entered as the opening balance in QuickBooks.

If the amounts match, you entered the opening balance correctly. Move on to Step 3.

If the opening balance in QuickBooks doesn't match your bank records, edit it:

  1. Select the opening balance entry to expand the view.
  2. In the Deposit column, edit the balance so it matches your bank records.Edit
  3. Select Save. Then select Yes if QuickBooks asks you to confirm.

If you're reconciling an account for the first time, your opening balance entry will be already reconciled. No other transactions should be reconciled.

  1. Go to the Accounting menu. Then select Chart of Accounts.
  2. Find the account on the list.
  3. Select View register to get more details.
  4. Scroll through the list until you find the opening balance entry. It should have an R in the checkmark column.Check
  5. Review the rest of the list. There should be a C or blank box in the checkmark column.

If there's an R on any other transactions, select the box in the checkmark column. Keep selecting it until you see a C or blank box. Then select Save.

Next steps: Start reconciling again

Once you know your opening balance is correct, you can start reconciling again. If you still see a message saying your beginning balance is off, here are other things you can review.

If you’ve followed everything in our reconcile guide but still have questions, connect with your bookkeeper. They can help get your reconciliations back on track.

Your books done right - guaranteed (US-only).

Get a QuickBooks-certified bookkeeper to categorize transactions and reconcile your bank statements every month so your books are always 100% accurate. Learn more about QuickBooks Live Bookkeeping.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us