Skip to main content
July 17, 2022
Question

Reconciliation. Beginning balance matches, income and expense totals match but end balance doesn't equal 0. What did I do wrong

  • July 17, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

July 17, 2022

I've got some tips on how you can reconcile your account with ease, @kris-mfandk-com.

 

In reconciling your account, make sure to match your QuickBooks transactions with the ones on your bank statement. This way, you'll get a zero difference between the ending balance in QBO and your bank statement.

 

Here are some of the reasons for ending balance issues:

 

  • An incorrect ending balance is entered at the start of the reconciliation.
  • Duplicate or missing transactions in QBO.
  • Uncleared bank transactions were entered into QBO.

 

Follow these steps to fix the discrepancies in your balances:

 

Step 1: You'll have to verify the opening and the beginning balances. This helps ensure you're reconciling with accurate numbers.

 

Step 2: If the balances are correct, it's time to check if the ending balance is entered correctly. Here's how:

 

  1. When reconciling an account, click on Edit info in the Reconciliation window.
  2. Verify the Ending balance and Ending date.
  3. Review your bank statement. Make changes if needed.
  4. Once done, click on Save.

Please read this module and follow steps 3 to 7 to completely reconcile your account: Fix issues at the end of reconciliation in QuickBooks Online.

 

I'm also adding this future help article about handling reconciliation reports in QBO: How do I view, print, or export a reconciliation report?.

 

Fill me in if you need extra help with banking or QuickBooks. It's my pleasure to be of help any time. Stay safe!