Skip to main content
J
johnmillstead-gm
July 28, 2022
Solved

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

  • July 28, 2022
  • 2 replies
  • 0 views
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
Best answer by Rustler

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

2 replies

Rustler
RustlerAnswer
July 28, 2022

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

J
johnmillstead-gmAuthor
July 30, 2022

Yep, that was it. User error 101!

Thanks!

K
KCAMPBELL09
February 18, 2023

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!

A
Archie_B
February 18, 2023

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!

K
KCAMPBELL09
February 20, 2023

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!

Terms & ConditionsAccessibility statement