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

Payment total not matching selected rows

QB is showing $624,581.54 value for payments. I've exported the reconciliation grid to excel, hit sum and it reports $606,294.35, much closer to the expected amount. how can QB get a different number? in 20 years of using online edition, i've never run into this. i have even merged bank and QB reports, color coded and compared. the data is in sync, but the payments total at the top is still wrong, so i can't complete the reconciliation process.
Solved
Best answer May 13, 2020

Best Answers
davidaztj
Level 1

Payment total not matching selected rows

The HTML was not displaying checked rows calculated in totals towards the bottom of the page. resetting dates refreshed the screen. could be related to chrome zoom was set to 90% and then reset as well.

View solution in original post

2 Comments 2
Candice C
QuickBooks Team

Payment total not matching selected rows

Good Evening, @davidaztj

 

I see how this can put a halt in running your business. It's my priority that you're able to finish your reconciliation. Your payments section of your reconcile can be off because of missing payments that you haven't selected, haven't entered, or transactions that you don't need to choose.

 

The easiest way to find the issue is by narrowing your search and eliminate what you know is correct. Physically mark the transactions on your bank statement that match QuickBooks. You now know that these aren't the source of the problem because they are correct. Now you need to either enter a transaction that isn't in QuickBooks or find the ones that aren't on the bank statement. You may have missed a transaction on a past reconciliation, or created duplicates by mistake. Here's an article that can help you out: 

 

 

If you still see a difference in the payments section, I recommend contacting our Customer Support Team. They'll be able to look over your account and transactions by a screen share to help resolve the issue. 

 

Should you need further assistance, don't hesitate to ask. I'm only a post away. Wishing you continued success!

davidaztj
Level 1

Payment total not matching selected rows

The HTML was not displaying checked rows calculated in totals towards the bottom of the page. resetting dates refreshed the screen. could be related to chrome zoom was set to 90% and then reset as well.

Need to get in touch?

Contact us