cancel
Showing results for 
Search instead for 
Did you mean: 
akbetty
Level 1

Bank reconciliation

I am using QB desktop and am current on my bank reconciliation. I use the Bank - Reconcile tab to do this and its at 0.00.  However, when I open the reconciliation page there are  around a dozen checks showing up in the checks and payments tabs going back to May of 2023 that are showing as uncleared. I have checked and these are not duplicates. Is there any way to clear these out so that I dont see them on this screen. Since my balance is at zero on the last reconciliation, I do not understand how these previously cleared checks are now showing back up. Thanks

1 Comment 1
Eman_E
QuickBooks Team

Bank reconciliation

Let me share information about transactions that are showing from the reconciliation page, @akbetty 

 

Transactions that you have previously reconciled could occasionally appear unreconciled. This could be due to a few factors:

 

  • Someone undid the last reconciliation.
  • Someone changed the reconciled transactions.
  • Cleared transactions were unchecked (uncleared) in the account register.
  • Funds were transferred from a previously reconciled bank account to a sub-account.
  • Company file conversions can cause issues (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) (US only).
  • The transactions were never reconciled in the company file. This might be because the file was restored from a backup, which can overwrite data and reconciliations.

 

If someone undid and unchecked your entries, you can perform a mini reconciliation to rectify them. Keep in mind that this "mini reconciliation" method uses an "off-cycle" reconciliation date to make a correction. This assumes you know the ending balance from the most recent reconciliation.

 

Here's how:

 

  1. Go to the Banking menu and select Reconcile.
  2. Select the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
  5. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
  6. Make sure the Difference field shows $0.00.
  7. When everything looks good, select Reconcile Now.

 

You can also use the Audit trail feature to check your account history. This report provides information about who created, modified, or deleted a particular transaction and when it occurred.To learn more about reconciliation workflows and fixes, I recommend checking out this article: Learn the reconcile workflow in QuickBooks.

 

Fill me in if you have more questions about reconciling bank accounts in QuickBooks. I'm always here to help. Take care always.

Need to get in touch?

Contact us