I have a difference between my actual bank balance and the amount in quickbooks of $269.68. I’m pulling my hair out trying to find it in my bank feeds. Any ideas?

Hi there, info985.

Bank balance difference can be caused by edited, deleted, moved, or unreconciled a transaction that was on a previous reconciliation. This can also happen if new transactions are not yet cleared or downloaded from your bank. 

Follow the recommended troubleshooting steps in this article on how you can resolve the balance issue: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

The Community is always here if you need anything else. 

Mine too, but the difference is a whopping $23K, growing by the week, despite receiving payments correctly. Both QB and my bookkeeper cannot fix this. I am going nuts wasting hours researching how to get Bank Balance and In QB to balance again as it did once upon a time. Any advice please!

Mine too, but the difference is a whopping $23K, growing by the week, despite receiving payments correctly. Both QB and my bookkeeper cannot fix this. I am going nuts wasting hours researching how to get Bank Balance and In QB to balance again as it did once upon a time. Any advice please!

 Hi 123146086079, 

The balance in QuickBooks will reflect any transactions that have been added to the account even if they were not fed through from a bank feed. If you are able to reconcile without any issues it may be worth checking the accounts for transactions that are not reconciled and removing them, if that suits.

• To do this navigate to the Chart of Accounts and locate your Bank Account
• Select Account History 
• Above the Date column you will see a Filter option
• Set the Reconcile Status to Not Reconciled and Apply
• Review these transactions for any possible duplicates etc 

If you complete the above steps and are still seeing a discrepancy please contact us on 1800 046 038 so one of our support representatives can assist you further. 

-Rebecca 

Thanks Rebecca,

I have done that and do not see any duplicates. However I have had a hunch that QB is somehow doubling the payments received and has a bug in the banking page. I have raised a ticket with support chat, after 6 days they still have not upscaled the ticket to IT as requested to fix the bug. At one stage they balanced, then after a bug fix on my receive payments page, an $11K difference appeared, then a  $23K difference, getting bigger by the day despite payments being received correctly by myself.

I'm sorry to hear you're still seeing a discrepancy but it sounds like our engineers are actively working on it. As we're not able to take any identification from you via the Community page, please call our Support team if you have any account specific questions or examples that may help us resolve this for you. 

-Rebecca