QuickBooksHelp
Intuit

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

Learn how to review your beginning balance and look for issues for accounts you haven't reconciled before.

If you're reconciling an account for the first time and the beginning balance is off, don't worry. Most beginning balance issues are caused by an incorrect opening balance. This is the account's starting point you set when you first created it in QuickBooks.

Correcting the opening balance should also fix your beginning balance issues. Here's what to review so you can start reconciling your account for the first time.

Tip: If you've reconciled the account in the past, don't follow these steps. Here's what to review for accounts you've already reconciled. Or, if you're new to the entire process, start with our reconciliation guide.

Step 1: Review the opening balance in QuickBooks

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.

  1. If you recently entered older transactions dated before your opening balance, here's how to reconcile them. Then continue with these steps.
  2. Go to Bookkeeping or Accounting, then select Chart of accounts (Take me there).
  3. Find the account on the list.
  4. Select View register.
  5. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
    Review
  6. Take note of the date and balance.

Important: Forgot to enter an opening balance? That's OK. You can enter them later on. Here's how to manually enter an opening balance so your accounts stay balanced.

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.

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

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

  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.
    Edit
  3. Select Save.

Step 3: Review your account register

When you reconcile an account for the first time, there's only one entry that's already reconciled-the opening balance entry.

No other transactions should be reconciled. To check:

  1. Go to Bookkeeping or Accounting, then select Chart of accounts (Take me there).
  2. Find the account on the list.
  3. Select View register to get more details.
  4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
  5. Review the checkmark column. There should have an R in the box.
    Check
  6. Check the rest of the transactions on the list. There should be a C or blank box in the checkmark column.
  7. If there's an R on any other transactions, select the transaction to expand the view.
  8. Select box in the checkmark column. Keep selecting it until the box is blank. Then select Save.

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. They can help get back on track.

Your books done right - guaranteed.

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.