Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
johnmillstead-gm
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

I reconciled January - April.  I am working on May.  The Opening/closing balance match. The number of Payments, number of deposits and cleared balance are incorrect.  

I downloaded the register to Excel, the bank transactions to Excel and compared the two.  Both match - including the number of transactions.  The closing balance for both equals the opening balance on the June statement.  I can't move forward. 

Any idea what is causing this?  The reconcile header shows 268 more payments and 11 more deposits.

Any changes will throw off the balance and subsequent statements.

Thanks for having a look!

John
Solved
Best answer July 28, 2022

Best Answers
Rustler
Level 15

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

I would check the date range, the bank only shows up to a certain date, be sure your download has the same date range

View solution in original post

10 Comments 10
Rustler
Level 15

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

I would check the date range, the bank only shows up to a certain date, be sure your download has the same date range

johnmillstead-gm
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

Yep, that was it. User error 101!

Thanks!

KCAMPBELL09
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

I have the same issue. Date range is correct. If I go to expenses - ALL - the figure and number of transactions is correct. Same for register - no duplicate items are listed. I have physically checked off my bank statement. All transactions are in QBO, but QBO still shows a several thousand dollar and 15+ transaction discrepancy. Please help!

Archie_B
QuickBooks Team

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

Hi there, KCAMPBELL09.

 

I'm here to share some information and help you go through your reconciliation issues in QuickBooks Online.

 

Have you also tried checking your Undeposited Funds account? This account holds every payment before you record a deposit.

Since you've already gone over all of your expenses, it's possible that there are still payments that need to be deposited into your bank account which could explain the discrepancy. That said, if you need to make a deposit and learn more about the Undeposited Funds account, check out this link: Record and make bank deposits in QuickBooks Online.

 

I'm also adding these articles to help you fix issues for the first time, or at the end of your reconciliation:

 

 

Let me know how it goes or if you still need further assistance regarding your reconciliation. I'll be checking your response in this thread. Take care and enjoy a wonderful day!

KCAMPBELL09
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

No, it's not undeposited funds. The details at the top of the reconciliation page -- beginning balance - # payments + # deposits < these numbers are wrong. The number of payments and number of deposits listed are double or more than what is on my actual bank statements. But there are no other transactions for me to check on the reconciliation page. I am stuck!

Tori B
QuickBooks Team

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

Thanks for getting back to us, @KCAMPBELL09.

 

Since the date range is correct and the funds aren't in your Undeposited funds account, let's do a bit of browser troubleshooting. It sounds like the cache of your browser could be corrupted. Web browsers collect cache to save time when loading repetitive data and images. Over time these files can become outdated and corrupted, causing issues like incorrect balances. 

 

You can use the keyboard shortcuts below to open a private/incognito window. Using a private/incognito window will play the same role as having cleared cache. 

 

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+
  • Safari: Command+Shift+N

 

Once you're in a private window, take a look at your reconciliation again. If the balances are correct, then your main browser may have too much historical data which causes this kind of behavior, as I mentioned above. To ensure this doesn't happen again, it's a good idea to clear the cache of the browser you're using. The following article contains additional insight, as well as steps for the supported browsers: Clear cache and cookies to fix issues when using QuickBooks Online.

 

Let me know if you continue to have issues with your balances. I'm here if you have any other questions or concerns. Take care! 

KCAMPBELL09
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

Still showing an incorrect number of transactions in an incognito window. I crawled through all my charts of accounts again. Nothing is duplicated though that is what it is looking like on the reconciliation page. Is there an expert with whom I can work one-on-one?

KCAMPBELL09
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

Wow. I am an idiot. It was checking transactions from 4 years ago somehow. I think I'm on the right track - finally!!!

sheready0822
Level 1

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

I have this same issue.  I've read the resolutions and I tried the incognito browser and cleared my cache and I'm still seeing 10 payments when there are only 6 and I did not check any transactions that are not in the current month/year.  My previous month ending balance checks out and I have made sure all my transactions for the current month have cleared and added to my chart of accounts.  Any other advice or suggestions on how to fix this issue?

Erika_K
QuickBooks Team

Reconciliation: Number of payments, number of deposits, and cleared balance incorrect.

I appreciate your time for following the steps provided above, sheready. 

 

Since all possible resolutions have been performed but still have the same result, I recommend contacting the QuickBooks Online (QBO) support team. They have the necessary resources to check this through screen sharing.  

   

Here's how:   

 

  1. Sign in to your QuickBooks Online company.
  2. Select Help (?).
  3. Choose either tab to get started:
  • Assistant: Get quick, personalized answers. Click a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human
  • Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
    • Start a chat with a support expert. 
    • Get a callback from the next available expert.

 

 To see when they are available, check their support hours.  

 

The Community space is available for any queries about payment management concerns. Take care always! 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us