This article covers how to troubleshoot an account reconciliation in QuickBooks Online when your opening balance is correct. For troubleshooting steps when your opening balance is NOT correct, see My reconcile opening balance is wrong. How do I make it match my statement?.

To start, select the reconcile issue you are experiencing:


Is your opening balance correct, but you still have unreconciled historical transactions in your register?

Let's say your opening balance is correct but you have some old unreconciled transactions in QuickBooks Online which have already appeared on your bank statement in the past. If the opening balance matches, then one or more of these old transactions have already been accounted for (they have been duplicated and marked with an R).

Here's how to deal with this situation:

  1. Select the Gear icon at the top, then Reconcile. Take note of the opening balance.
  2. Select the Gear icon at the top, then Chart of Accounts.
  3. Highlight the account in question.
  4. In the Action column, select the drop-down arrow and choose Run Report.
  5. Select Customize.
  6. Set the Transaction Date to All Dates.
  7. Apply the following filters:

    If you are using QuickBooks Online Plus or Essentials:

    1. In the Rows/Columns section, select Change Columns.
    2. Check the Last Modified box.
    3. In the Filter section, check the Cleared box then choose Reconciled from the drop-down arrow to the right.

    If you are using QuickBooks Online Simple Start/EasyStart: Go to the Sort By field and select Clr.

  8. Select Run report.

If the QuickReport shows any transactions that say Adjust or Adjustments in the Memo column and have a letter R in the Clr column, they can be considered possible culprits. Adjustments are made because previous reconciles did not balance. When the adjustment is put in, it is taking the place of an actual transaction that was either missing or duplicated.

If there are no adjustments, once the historical transactions have all been resolved and the report is correctly reflecting the opening balance, you should be able to continue your reconciliation.

Back to top

 

What if my opening and ending balances are correct but the reconcile still doesn't match?

When reconciling in QuickBooks Online, you're required to enter the ending balance, which comes from the bank statement. It's imperative that this balance is entered accurately.

If your opening balance and ending balance are correct and the difference does not equal 0, then the error lies in the transactions that have been check-marked.

Go through and double-check the following:

  • If you see a corresponding transaction on both reports, cross them off and move to the next transaction.
  • If the report from QuickBooks Online has a transaction that is not on the statement from the bank, select the letter R in the register to remove it.
  • If the report from QuickBooks Online has a transaction that is on the statement from the bank but the amount is different, edit the transaction to reflect the correct amount.
  • If the statement from the bank has a transaction that is not on the report in QuickBooks Online, check the register for the transaction.
    • If you find the transaction, place a letter R on it then save.
    • If the didn't fin the transaction, add it to the register and place a letter R on it then save.
  • If the adjustments add up to the amount of the outstanding historical transactions, you can delete the adjustments and manually reconcile the historical transactions in the register. To manually reconcile a transaction, select Edit from the register and add the letter R in the check mark column.
 

Note: Accounts connected to online banking have additional features to assist with reconciliation.

  • In addition to the transaction date column, we now have the cleared date column. Cleared date comes from the bank and represents the date the transaction cleared the bank
  • Automatically alert user when they have transaction date and transaction cleared date discrepancies. This is helpful for two scenarios:
    • Transaction has a manually entered transaction date within the statement period, but it cleared after the statement end date. We now automatically uncheck these transactions.
    • Transaction has a manually entered transaction date after the statement period, but it cleared prior to the statement end date. With this date discrepancy, the problem transaction is hidden from view because it is dated after the statement end date. We present the user with an alert to Show Hidden Transaction.
  • If the account is currently connected to online banking but the transaction did not originate from the bank, or have a match from the bank, it will not have a date within the cleared date column and the automation detailed above does not apply.

If the transactions are all correctly check marked, and the ending balance is correct, then the opening balance has to be incorrect. If this is the case, see My reconcile opening balance is wrong. How do I make it match my statement?.

Back to top

2910