Matching Bank balance with balance in Quickbooks

Let me help ease your worries, @EazyFreightPaul.

I can share some resources about the differences between QuickBook's balance and bank balance.

Here are the possible reasons your bank balance and QuickBooks balance are not the same.

• New transactions for a connected account
  • Make sure to add or match all transactions before running your report.
• Outstanding transactions
  • To fix this, sort out your QuickBooks Online bank register by date and compare it with your bank statement.
• Credit card (liability) account
  • Compare your credit card statement with the QuickBooks balance. Verify if the Balance column is showing a positive amount.
• Duplicate transactions
  • The system automatically locates duplicate transactions and matches them. However, there are times the system can’t locate any similarities in the details of the transactions. You can manually match the transactions.
• Edited or deleted transactions
  • You can run the Audit log to verify the details of the edited or deleted transactions.

Feel free to visit us here in the Community and let us know how it works on your end. I‘m always here to help you in making sure your transactions are accurate and reconciled.

Thank you for your reply @Maybelle_S 

I understand the below and am confident that the discrepancy lies with "Outstanding Transactions" that have been excluded.

As mentioned in my question:- Any transactions that appeared in the new tax year but were related to an invoice for the previous tax year have been excluded as the payments were recorded on my previous Accounts software.

My question is more related to the correct way of handling this:

Would it be acceptable to make 1 purchase invoice and 1 sales invoice to cover the total amounts for the excluded transactions and tag the excluded invoices to the relevant invoices?

Ie if there was 10 sales transactions totaling £10k... make one sales invoice for £10k and tag all exempt sales transactions to this one invoice?