Skip to main content
September 29, 2024
Question

My bank balance on quick books doesn’t match my actual bank account balance. There are no tasks to complete or expenses to categorize or anything.

  • September 29, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

MsNorthPND18
September 30, 2024

I will provide some details to help you understand what occurred with your account. The QuickBooks balance reflects the total amount of transactions entered or added to the register, while the bank balance is the data provided by your bank.

 

Past incorrect reconciliations might lead to a mismatch. I recommend reviewing the earlier reconciliations to find any errors. After you spot the problems, you can correct them as needed.

 

  • Outstanding Checks - An outstanding check is one that a company has written but the bank has not processed yet. If there are outstanding checks in your QuickBooks account that are still pending, your QuickBooks balance will be higher than your real bank balance because those checks haven't reduced your bank funds yet.
  • Duplicate Transactions - If you mistakenly enter a transaction more than once or download the same transaction two times, it can lead to an inflated QuickBooks balance. Duplicate transactions may make your account balance appear higher, creating a difference between your QuickBooks balance and your bank balance.
  • Editing or Deleted/Missing transactions - If a transaction has been changed, removed, or is not present in your QuickBooks account, it may lead to a difference between your QuickBooks balance and your bank balance.
  • Credit Card and Liability Accounts - These accounts affect your records differently than bank or asset accounts. As a result, the Bank Balance column for these accounts is usually negative. Focus on the Balance column to ensure it is accurate and positive.

 

By investigating these variables, you can resolve why QuickBooks balance and bank balance do not match and make the necessary adjustments to ensure they match in the future.

 

In addition, I suggest checking your client's bank account every month to make sure the balances match. You can find a step-by-step guide on how to do this here: Reconcile workflow in QuickBooks.

 

If you have more questions about your bank balance and QuickBooks balance, feel free to leave a comment below.