cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

If the bank balance is wrong, how can I fix it?

My end of month balance is not reflecting on the preceding month starting balance. This is leading to incorrect bank reconciliation. When the bank expenses are filtered together, they are correct but tend to be wrong when filter on a monthly basis. 

Solved
Best answer 09-26-2019

Accepted Solutions
QuickBooks Team

Welcome to the Community space, bfreeman. Let's get to th...

Welcome to the Community space, bfreeman.

Let's get to the bottom of this and make sure you're able to correct the bank balance, then finish reconciling. 

Are you seeing a zero amount starting balance when doing a reconciliation? If so, the inability to match the beginning balance in QuickBooks Online with your bank statement is called beginning balance discrepancy. 

There are several different reasons why it occurs on your company file. You can check out the What causes a beginning balance discrepancy? section of this article to learn more about them:

Why doesn't my QuickBooks Online beginning balance match my statement?

To fix this, you need to perform a single reconcile using the ending balance of your last reconciled bank statement. Make sure not to enter any interests or fees prior to saving the data. 

  1. Go to the Gear icon, then Reconcile.
  2. From the Reconcile screen, verify that the beginning balance is zero ($0).
  3. Enter the Ending balance of the last reconciled bank statement.
  4. Click OK
  5. Once you see the list of transactions and balances to be reconciled, look at the difference and see if the number is zero. 
  6. If it is, choose Reconcile Now.
  7. If the difference is not zero, pick Unmark All and place a check in Hide transaction after the statement End date.
  8. Choose Mark All and use the reconciliation report from QuickBooks Online to remove the check from transactions that were not cleared as of the last reconcile.
  9. Click Reconcile Now.

Here's an article with the detailed steps:

My reconcile opening balance is wrong. How do I make it match my statement?

That's it! You should now be able to correct the bank balance. 

Don't hesitate to let me know if you have other concerns. I'll be around.

View solution in original post

1 Comment
QuickBooks Team

Welcome to the Community space, bfreeman. Let's get to th...

Welcome to the Community space, bfreeman.

Let's get to the bottom of this and make sure you're able to correct the bank balance, then finish reconciling. 

Are you seeing a zero amount starting balance when doing a reconciliation? If so, the inability to match the beginning balance in QuickBooks Online with your bank statement is called beginning balance discrepancy. 

There are several different reasons why it occurs on your company file. You can check out the What causes a beginning balance discrepancy? section of this article to learn more about them:

Why doesn't my QuickBooks Online beginning balance match my statement?

To fix this, you need to perform a single reconcile using the ending balance of your last reconciled bank statement. Make sure not to enter any interests or fees prior to saving the data. 

  1. Go to the Gear icon, then Reconcile.
  2. From the Reconcile screen, verify that the beginning balance is zero ($0).
  3. Enter the Ending balance of the last reconciled bank statement.
  4. Click OK
  5. Once you see the list of transactions and balances to be reconciled, look at the difference and see if the number is zero. 
  6. If it is, choose Reconcile Now.
  7. If the difference is not zero, pick Unmark All and place a check in Hide transaction after the statement End date.
  8. Choose Mark All and use the reconciliation report from QuickBooks Online to remove the check from transactions that were not cleared as of the last reconcile.
  9. Click Reconcile Now.

Here's an article with the detailed steps:

My reconcile opening balance is wrong. How do I make it match my statement?

That's it! You should now be able to correct the bank balance. 

Don't hesitate to let me know if you have other concerns. I'll be around.

View solution in original post