cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Checking account reconciliation difference error - register matches account statements and balances perfectly

I'm having the strangest issue. I was happily reconciling my checking account for 2018, got all the way through to August with no reconciliation differences. I went back to do something else in QB, went back to reconciliation and it says my beginning balance for January 2018 is wrong. I entered a reconciliation adjustment and then my checking is off by that exact amount. Removed the reconciliation adjustment and get the same difference message. 

 

With the adjustment removed, I delved into the register and the balances are 100% correct, no difference at all with the bank.  I can't finish reconciling until this is fixed. No non-reconciled transactions in the register. 

 

I've been going around and around in circles trying to figure this out. Never seen this before. 

4 Comments
Highlighted
Level 15

Checking account reconciliation difference error - register matches account statements and balances perfectly

Your Jan balance should not even be part of "reconciled through to August" because Sept starts with how Aug ended. If you changed a transaction and/or affected the status for a transaction already reconciled, such as checking a Check to a credit card charge, then you simply ignore the beginning balance; you know you affected it because you affected a Status of a Cleared transaction. Your goal always is the ending balance of the statement date, that is the point of reference to the statement. So, ignore the beginning balance, use the statement for Sept, use the ending balance, reconcile to that, and mark as cleared anything you know the bank already processed, even if that is a prior dated transaction, And remove your "adjustment" because that was never a good solution. You should still get to a difference of 0. You never force a reconciliation that isn't at a difference of 0.

Highlighted
Level 1

Checking account reconciliation difference error - register matches account statements and balances perfectly

Let me clarify here. QB is saying that I have a difference when I reconcile even though there is no difference. My statement balance perfectly matches my register balance on the matched dates. 

 

So I can't reconcile because QB thinks there is a difference to be corrected even though there is none. All transactions have been reconciled. Doesn't matter what month I'm looking at. So something is askew here and I'm not sure what it is. If I choose "finish" I have to do account for the difference. The only option is to have QB add an adjustment, but the adjustment is incorrect because there should be NO adjustment. 

Highlighted
Level 1

Checking account reconciliation difference error - register matches account statements and balances perfectly

Let me clarify here. QB is saying that I have a difference when I reconcile even though there is no difference. My statement balance perfectly matches my register balance on the matched dates.

So I can't reconcile because QB thinks there is a difference to be corrected even though there is none and it wants me to account for it. 

 

All transactions have been reconciled. Doesn't matter what month I'm looking at. So something is askew here and I'm not sure what it is.

Highlighted
Moderator

Checking account reconciliation difference error - register matches account statements and balances perfectly

A warm welcome to the Community, ggulley.

Let's get your reconciliation corrected.

 

Let's go through some basic troubleshooting steps starting with opening a private browser. This helps us determine if the error is caused by the browser cache or not. 


Here's how to open a private window in different browsers:

  • Google Chrome: press Ctrl + Shift + N.
  • Mozilla Firefox: press Ctrl + Shift + P.
  • Internet Explorer: press Ctrl + Shift + P.
  • Safari: press Command + Shift + N.

If you're able to reconcile your account using the private browser, let's go back to your regular browser and clear its cache.

 

You may find this article helpful: How to resolve reconciliation differences.

 

Also, if you need additional help, you reach out to our QuickBooks Online Support. Agents have the necessary tools, like screen-sharing to get you back up and running.

 

You can always come back to the Community if anything may arise while working in QuickBooks Online. I'd be glad to help.

Need to get in touch?

Contact us