QuickBooks HelpQuickBooksHelpIntuit

Fix issues for accounts you've reconciled in the past in QuickBooks Online

SOLVEDby QuickBooks57Updated 2 weeks ago

Learn what to review so you can start reconciling.

Each time you start reconciling an account, you review the beginning balance in QuickBooks. It's the amount in the account at the beginning of the time period you're reviewing. Think of it as a checkpoint. It lets you know if you're starting with accurate numbers.

The beginning balance amount should match what's on your bank statement for the same start day. If it doesn't, don’t worry. QuickBooks lets you know what changes you might need to make. Here's how to fix beginning balance issues so you can start reconciling.

Tip: If you've never reconciled this account before, don't follow these steps. Here's what to review for the first time you reconcile an account. Or, if you're new to the entire process, start with our reconciliation guide.
  • Someone entered an incorrect opening balance when they created the account in QuickBooks.
  • Someone added transactions that are older than the opening balance, but didn't edit the original opening balance entry to reflect the change.
  • Someone edited, deleted, moved, or unreconciled an already reconciled transaction. This changes the ending balance of your last reconciliation, which impacts the beginning balance of the next one.
  • Someone manually reconciled a transaction, so it didn't show up on the next reconciliation.

Step 1: Review the original opening balance

The opening balance is the starting point for accounts in QuickBooks. If it’s incorrect, it affects all following reconciliations.

Make sure your opening balance is correct before checking your beginning balance. Then move on to Step 2.

Step 2: Check your bank statement

Make sure you're reconciling the correct account for the correct month:

  1. In QuickBooks, go to Bookkeeping and select Reconcile (Take me there).
  2. Review the account you selected in the Account dropdown menu.

If you have multiple accounts at the same bank, or more than one account of the same type, make sure you're reconciling the right one.

Step 3: Match and categorise downloaded transactions

If your account is connected to online banking, match and categorise all of your downloaded transactions before you start reconciling. You need to categorise everything to get your final correct beginning balance.

Step 4: Review any discrepancy reports

If anyone makes a change that affects your beginning balance, you'll get a message before you start reconciling.

  1. Select the We can help you fix it link to open your discrepancy report.
  2. Review the Change Type in the discrepancy report. Use it to decide if and how to make changes.
  3. Before editing anything, talk with whoever made the changes - they may be intentional.

Once you know you need to make corrections, review each transaction in the report one at a time:

  1. Review the Change Type column. This tells you what changed. 
  2. If you want to see the historical changes made to the transaction, select View.
  3. Please refer the scenarios below to assess edits based on the Change Type column:

This means someone edited a reconciled transaction or moved it to another account. To fix it:

  1. Select the transaction to expand the view.
  2. Select Edit to open the form.
  3. Adjust the total or change the account as needed.
  4. Select Save and close.

This means someone unreconciled the transaction. To reconcile it again:

  1. Select the transaction to expand the view.
  2. Select the box in the tick column until you see an R. This manually reconciles the transaction.
  3. Select Save.

This means someone has already reconciled the transaction by accident. To remove it and add it to your next reconciliation:

  1. Select the transaction to expand the view.
  2. Select the box in the tick column until it's blank or you see a C. This removes the transaction from the reconciliation.
  3. Select Save.

This means someone deleted the transaction. If this was an accident, recreate the transaction exactly as it appears on your discrepancy report:

  1. Select + New.
  2. Select the correct form (invoice, sales receipt, expense, etc).
  3. Fill out the form and select Save and close.
  4. Go to Bookkeeping and select Chart of accounts (Take me there).
  5. Find the bank or credit card account that you put the transaction into and select Account history.
  6. Find the recreated transaction and select it to expand the view.
  7. Select the box in the tick column until you see an R. This manually reconciles the transaction.
  8. Select Save. The deleted transaction may still be on the list, but the discrepancy difference should change and it won't affect your reconciliation.

After you review everything on the discrepancy report, the Total Discrepancy Difference on the report should be A$0.00. Check the beginning balance again in QuickBooks. It should match the beginning balance on your bank statement. Select Resume reconciling to continue reconciling.

Next steps: Start reconciling

Once you know your beginning balance is correct, you can start reconciling. If you see issues in the middle of your reconciliation, here's what you should review.

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

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.