Skip to main content
February 7, 2021
Question

QuickBooks reconcile isn't calculating right. Why?

  • February 7, 2021
  • 1 reply
  • 0 views
QuickBooks says my ending payments total is $13,131.54, with 53 total payments. My hand calculations (multiple) and my bank all say it should be $13,164.54 with 53 payments. I have gone over them with a fine tooth comb and they are all exactly how they are on my bank statement. Everything points to them adding up to what my calculations and the banks. QuickBooks says otherwise and I can't finish reconciling until the problem is found. It says that I'm missing a $36.00 charge in order to balance out correctly and it doesn't exist. Why are QuickBooks calculations off by so much?

1 reply

JenoP
February 7, 2021

Hi there, tcpowdercoating2.

 

Thanks for letting us know in advanced that you already reviewed each transaction. There are times that too much cached can cause incorrect numbers when reconciling or performing a task in QBO.

 

I'll recommend some steps that can resolve some of the most common banking errors in QBSE.

 

Start by using an incognito/private browsing session or a different browser. Here are some of keyboard shortcuts to quickly open an incognito session: 

 

  • Ctrl Shift N  for Google Chrome
  • Ctrl Shift P  for Firefox
  • Control Option +if you're using Safari
  • Ctrl Shift P for Microsoft Edge

Once done, go back to the Reconciliation page and check if the ending balance or total payment amount is already the same with your bank statement. 

 

If the numbers are the same, go back to the regular browsing session and follow the steps in this article: Clear Cache And Cookies To Fix Issues When Using QuickBooks Online.

 

I'd also like to share this article for additional reference: Fix Issues For Accounts You've Reconciled In The Past In QuickBooks Online.

 

Please don't hesitate to reply or send another question if you need more help.