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

Bank Reconciliation Report

I am using QB Pro.  I have 3 companies created.  On the newest one I noticed a difference in the bank reconciliation report.  I have reconciled 4 months successfully.  But on the reconciliation reports the cleared transactions list contains items that were cleared from all the prior reconciliations plus the new ones cleared on the current month.  The same is true for deposits.  That does not happen on any of my other companies.  Can anybody help explain this and how to fix it?  Thank you.

2 Comments 2
FDLguy
Level 1

Bank Reconciliation Report

This is an update to my original post.  It is in the Uncleared list that the prior cleared items appear along with the current cleared items.  The prior cleared items have a X to show they have cleared previously.

MaryLandT
Moderator

Bank Reconciliation Report

Let me help fix your reconciled accounts and share an idea of why you're getting this issue, FDLguy.

 

There may be times when transactions you already reconciled show up as unreconciled. Here are a few reasons why:

 

  • Someone changed or deleted the reconciled transactions.
  • Cleared transactions were unchecked (uncleared) in the account register.
  • Someone undid the last reconciliation.
  • Funds were transferred from a previously reconciled bank account to a sub-account.

 

You can perform a mini reconciliation in QuickBooks Desktop (QBDT) to create changes in your reconciled accounts. This special method uses an "off-cycle" reconciliation date to make a correction. This also assumes you know the ending balance from the most recent reconciliation. Get this information before you start.

 

To fix transactions in a bank account, follow these steps:

 

  1. Go to the Banking menu and select Reconcile.
  2. Choose the bank account with the transactions you need to reconcile.
  3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." Please take note that when you enter an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation and select Continue.
  5. From 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.

 

If you're using a credit card account, follow these steps to clear your transactions: How to fix transactions in a credit card account.

 

I'm always right here if you have other questions with QBDT. Just add the details of your concerns about the reconciliation report and I'll help you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us