Skip to main content
K
kpturner
April 13, 2020
Solved

Bank Balance in Quickbooks does not match actual bank balance or reconciled balance

  • April 13, 2020
  • 1 reply
  • 0 views

I have just decided to migrate from Xero to Quickbooks and spent the last day or so migrating stuff over.  
When I connected to my Santander Business Account it downloaded transactions back to 2nd April 2019 but I wanted to import everything since the business started in Nov 2017.  I therefore imported all the other transactions off a spreadsheet.  I then went through the laborious task of matching everything up and when I did the bank balance was quite a bit different to the QuickBooks balance. 

It looks like, when I did the original bank feed import an opening balance record was created and then of course I added a load of transactions before that date via the spreadsheet import.  So - this is simple I thought - I just deleted that opening balance record.

Unfortunately things still don't match up.  My Quickbooks Balance is correct and matches my actual bank balance and all transactions are reconciled.  Everything is perfect apart from the fact that Quickbooks thinks my Bank Balance is £44.61 different to what it actually is.  How can I correct that?  I cannot find anything that allows me to edit and correct the bank balance.

I do not have an incorrect opening balance - in fact I don't have one at all.  I have been through the articles on the subject that ramble on about creating a journal entry but that seems to make no difference at all. In fact it talks about referencing an "Opening Balance Equity" account which doesn't exist in my Chart of Accounts.  Where does this balance come from?  If I get an update from my bank feed it doesn't change.

I am really stumped......I may have to go back to Xero with my tail between my legs.
 

Best answer by payment after leaving

Aha - I think I have worked it out.     The "incorrect" figure seems to be coming from my Santander feed. 

There are two balances: 
1) The current bank balance - this is the one I expect to see and this is the one that Xero displays 
2) Balance including pending: This is your balance including any payments due to come out of your account. 

Xero displays balance 1) which is good.
QBO displays Balance 2) which is not good. 

That means the bank balance will never (or hardly ever) match the QBO reconciled balance




Hi kpturner

 

If there are pending transactions showing in you actual online account these will noit be displayed in QuickBooks and will result in the imbalance in the accounts.

1 reply

C
Catherine_B
April 14, 2020

Hello there, kpturner. 

 

Yes, you're right to clear off the bank balance we can create a Journal Entry. We can also create a deposit affecting the Opening Balance Equity account. 

 

Let's create the account first. Here's how:

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Click New at the upper-right. 
  3. Select Equity > Opening Balance Equity > enter a name. 
  4. Click Save and Close. 

To create a deposit, just click the +New button and select Bank deposit. Enter the bank account and date. From the Received From field, select the Opening Balance Equity account. Fill out the rest of the details. Click Save and close. 

 

For more details, you can check out these articles: What to do if you didn't enter an opening balance in QuickBooks Online. 

 

Let me know if you need more help. Take care!

K
kpturnerAuthor
April 14, 2020

Thank you for you reply.  I tried this but it didn't seem to make any difference at all.

Just to make sure we are on the same page, my balance in QBO is correct and matches my "actual" bank account balance if I look at my Santander online account.  The figure that is wrong is the figure you see in the Banking option where it shows your account (x'd out) - That says "£21,457.37 Bank Balance Updated moments ago" and *that* is the wrong amount. There is a pencil button to edit account info, and on that popup the balance is correct.  I have attached a screenshot.  The £21,463.13 balance in Quickbooks is correct. I just ran an update from my bank feed and it retrieved two more transactions but the £21,457.37 figure did not change. The only thing that changes was the QBO balance which, once I added the transactions, is still correct.

Moving on to your proposed solution, it turns out I did have an Opening Balance Equity account but it was called "Retained profit balance forward account".  When I created a deposit as described you didn't say what the value should be so, as I want the account to start at zero (it does anyway) I entered zero.  The data I entered was the date the account was opened - 5th Nov 2017.

This makes no difference to the incorrect bank balance figure.   Even if I enter an arbitrary amount (i.e. £10) the only balance that it alters is the Quickbooks Balance.  I don't want to alter that because it is correct.

So my original question remains - where does £21,457.37 come from and how does one correct it?  Getting updates from my bank makes no difference at all.  Adding an opening balance of zero makes no difference either.


K
kpturnerAuthor
April 14, 2020

Aha - I think I have worked it out.     The "incorrect" figure seems to be coming from my Santander feed. 

There are two balances: 
1) The current bank balance - this is the one I expect to see and this is the one that Xero displays 
2) Balance including pending: This is your balance including any payments due to come out of your account. 

Xero displays balance 1) which is good.
QBO displays Balance 2) which is not good. 

That means the bank balance will never (or hardly ever) match the QBO reconciled balance



Terms & ConditionsAccessibility statement