cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Abbas Shah
Level 1

Bank Difference

Hello

 

I don't use QB much for clients however I have just taken on a new client who uses it.  There is quite a large difference between the QB balance and the statement balance.

 

Without going through every single banking transaction to see if everything has been recorded properly, how do I resolve this issue within QB?

 

QB balance is approx £19k and the statement balance £35k

Solved
Best answer December 12, 2022

Accepted Solutions
GeorgiaC
QuickBooks Team

Bank Difference

Hi Abbas Shah, you can use the reconciliation tool (Cog > Reconcile) or run the report history for the account to view all transactions posting to this (Cog > Chart of accounts > Click the drop-down beside the account > Run report) :woman_technologist:

View solution in original post

7 REPLIES 7
Ashleigh1
QuickBooks Team

Bank Difference

Hello Abbas Shah, 

 

Welcome to the Community page, 

 

So it could be a few things to why the balances are different,  In QuickBooks balance is the total of all transactions recorded to the bank account in QuickBooks Whilst bank balance is the actual bank balance pulled up through bank feed connection. 

 

Reasons why In QB balance is different from the bank balance is:

1 . Missing transactions that needs to be recorded

2. Duplicate transactions

3. No opening balance created for the bank account

 

To fix the difference customer needs to get a copy of his bank statement and compare it with the recorded transactions in the bank account inside QuickBooks. Compare the transactions in your actual bank statement and the transactions recorded in QBO

 

 

 

Abbas Shah
Level 1

Bank Difference

Thank you for the reply.  How do I get a list of all the bank transactions inside Quickbooks?  Client wants to go back to 2018 when it was set up.

 

Regards

Abbas

GeorgiaC
QuickBooks Team

Bank Difference

Hi Abbas, you can either import the transactions using a CSV downloaded from the bank, or enter an opening balance as of a specific date and begin recording from there. :)

Abbas Shah
Level 1

Bank Difference

Apologies, I meant how do I get a list of all the bank transactions that have been recorded within Quickbooks?  

GeorgiaC
QuickBooks Team

Bank Difference

To get this for a specific account, navigate to the Chart of Accounts and select "Run Report" on the action drop-down > set the date to "All dates" > run report. From here, you can use the icons on the top-right of the report to export or print. 

Abbas Shah
Level 1

Bank Difference

Hello

 

I have previous run a report that has shown me all the account history including manually added items and bank transactions on one report.  This has allowed me to identify duplicate items on the accounts so i can try and match the quickbooks balance to the bank.

 

How do i download this report?

GeorgiaC
QuickBooks Team

Bank Difference

Hi Abbas Shah, you can use the reconciliation tool (Cog > Reconcile) or run the report history for the account to view all transactions posting to this (Cog > Chart of accounts > Click the drop-down beside the account > Run report) :woman_technologist:

Need to get in touch?

Contact us