cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
secretarywasps-g
Level 1

How do I fix being over in my reconciling my statement with Quickbooks?

I have a $7.00 dollar difference in my Quickbooks to my bank statement
1 Comment 1
DivinaMercy_N
Moderator

How do I fix being over in my reconciling my statement with Quickbooks?

Let's fix this difference so you can get back to working order, @secretarywasps-g. Follow along below to get this done right away.

 

First off, allow me to discuss some details about why QuickBooks and bank balance don't match. I've outlined the reasons below:

 

  • An incorrect opening balance is entered when creating the QuickBooks Online (QBO) account. 
  • There are transactions added that are older than the opening balance but didn't update the original opening balance entry to reflect the change.
  • The reconciled transaction was edited, deleted, moved, or unreconciled. This will affect the ending balance of your last reconciliation, which change the beginning balance of the next one.
  • A transaction is manually reconciled so it didn't show up on the next reconciliation.

 

To resolve this, refer to the steps below:

 

  1. You have to make sure that the opening balance is correct because it affects all following reconciliations.
  2. Once done, you'll now need to ensure that you're reconciling the correct account for the correct month or date.
  3. Next is to match and categorise all of your downloaded transactions before you start the reconciliation. This will help you get your final correct beginning balance.
  4. After that, review your discrepancy report to decide if you need to make changes. Simply click the We can help you fix it link to open it. recon.JPG

 

For additional information, feel free to visit this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Once everything is fine, you're now ready to reconcile your account.

 

When the process is finished, QBO will automatically generate a report for that session. You can use this as your reference to avoid mistakes in doing future reconciliations.

 

Making sure your issues are resolved is my top priority. Just in case you have a follow-up question about the steps I've provided above or any QBO concerns, please leave a reply below. I'd be glad to lend a hand again. Have a blissful weekday.