QuickBooks HelpQuickBooksHelpIntuit

Fix issues the first time you reconcile an account in QuickBooks Online

by Intuit3 Updated 1 week ago

If you're reconciling an account for the first time in QuickBooks Online and the beginning balance is incorrect, it’s often due to an incorrect opening balance. This guide walks you through how to review, compare, and correct that balance so you can start reconciling your account for the first time. Correcting the opening balance should also fix your beginning balance issues.

Tip: If the account was already reconciled, here’s a different list of things to review. Or, if you're new to the entire process, start with our reconciliation guide.

Prerequisites:

Double-check the opening balance for the account you're reconciling. Sometimes, the opening balance doesn't include transactions that were still pending when you created the account. The opening balance is the balance of your bank account on the day you choose to start tracking transactions.

Note: If you recently entered older transactions dated before your opening balance, here's how to reconcile them. Then continue with these steps.

Step 1: Review the opening balance in QuickBooks

When you create a new account in QuickBooks, you pick a day to start tracking transactions. You enter the balance of your real-life bank account for whatever day you choose. This starting point is the opening balance. We recommend setting the opening balance at the beginning of a bank statement. This makes your first reconciliation much easier.

Follow this link to complete the steps in product Open this link in a new window

  1. If you recently entered older transactions dated before your opening balance, here's how to reconcile them. Then continue with these steps.
  2. Find the account on the list.
  3. Select Account history.
  4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Payee Account column and "Opening Balance" in the Memo column.
  5. Take note of the date and balance.
    Screenshot 2022-04-28 at 3.29.04 PM.png

Note: If you forgot to enter an opening balance, here's how to manually enter an opening balance later.

Step 2: Compare the opening balance with your real-life account

Now you know the date and amount of the opening balance in QuickBooks. Check it against your bank records:

  1. Sign in to your bank's website, or find your bank statement.
  2. Check the account's balance for the same day as the opening balance in QuickBooks.
  3. Compare the two balances.
  4. If the balances match
    • You entered the opening balance correctly. Move on to Step 3.
  5. If your balance doesn't match your bank records, correct it:
    • In QuickBooks, select the opening balance entry to expand the view.
    • In the Deposit column, edit the balance so it matches your bank records.
    • Select Save.
  1. In QuickBooks, select the opening balance entry to expand the view.
  2. In the Deposit column, edit the balance so it matches your bank records.
  3. Select Save.

Step 3: Review your account history

When you reconcile an account for the first time, the opening balance is the only entry that is reconciled. No other transactions should be reconciled. To check:

Follow this link to complete the steps in product Open this link in a new window


Next steps: Start reconciling the account

Once you know your opening balance is correct, you can start reconciling. If you see a message about an incorrect beginning balance when you start, here are other things you can review.

If you’ve followed everything in our reconciliation guide but still have questions, connect with your bookkeeper.