Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forÂ
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! Go to Solution.
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:
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
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
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. :)
Apologies, I meant how do I get a list of all the bank transactions that have been recorded within Quickbooks?
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.
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?
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:
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.