Skip to main content
B
Boswell
January 14, 2021
Question

Trial Balance not matching bank statement at year end

  • January 14, 2021
  • 1 reply
  • 0 views

My accountant has produced a trial balance for my accounts at the year end 2019_20 and this should correspond to the balance in the bank on this date as shown by the bank statements, BUT it doesn't and has varied quite considerably.  I have already tried the following already

1.  Reconciled up to date and quickbooks matches with bank on todays date

2. There are no unreconciled transactions.

3.  I do have a habit of spotting errors after reconciliation periods which I change and then reconcile these s part of the next months using the incorrect start balance but correct statement balance. I haven't rolled back reconciliations.

Any help appreciated Quickbooks helpline weren't able to help me.  Hoping some of you experienced QB users will be able to. Thanks

1 reply

C
CharleneMaeF
January 14, 2021

I'm here to help you sort this out, Boswell.

 

If all your reconciled transactions are correct, I recommend checking your foreign transactions. This could be the reason your Trial balance report does not match with your bank statement.

 

  1. Go to the Accounting menu. 
  2. Select Chart of Accounts.
  3. Locate the account, click on Account history.
  4. Check your foreign transactions.

 

Additionally, I've added an article that'll guide you personalising your reports in QuickBooks Online: Customise Reports.

 

Don't hesitate to leave a comment below if you have other questions about generating financial reports in QuickBooks. I'm always here to help.

Terms & ConditionsAccessibility statement