I can add some insights into why the Trial balance doesn't match with P&L and Balance Sheet report, James UK.

The trial balance summarises the debit and credit balances of each account on your chart of accounts during a period of time.

Often the expectation is that the Profit and Loss report will reflect payments. But, that isn't usually the case when the income or expense is recognised.

Here are some factors you want to consider:

• When you receive payment from a customer, that only affects Accounts Receivable and your bank account.
• If you pay a bill, that only affects Accounts Payable and your bank account. These are all balance sheet accounts, which don't reflect on your Profit and Loss report.
• To recognise revenue for received payments, you need an invoice created for that customer. This goes for your suppliers too. To recognise the expense from bill payments there must be a bill.
• If you don’t use our invoice/receive payments entry system, but instead record deposits, those should show as long as the deposit is affecting an income account.
• If you just record the cheques written or cash disbursements made, those will show as long as an expense account is listed on the transaction.
• If only balance sheet accounts are listed on these transactions, they will not show.

On the other hand, you may notice that your Balance Sheet report doesn't match your other reports even after making sure that all the filters are the same. There a few reasons why this occurs such as:

• Your Balance Sheet report is a cumulative report that carries a beginning balance.
• In other reports, the date range you set only applies to net income and the specific account you select within the report. (Example: If you have $50 of sales tax in March and $60 in April, the Balance Sheet will show $110 for the sales tax liability account.)
• If the date range for the report is April, it will still show the cumulative total of $110. However, if you select $110, its transaction detail report shows a beginning balance of $50 and then a $60 transaction for April.
• Lastly, the Sales by Item report will be limited to the date range you set. If you set the report date for April, then it will truly reflect only April and show the $60 only.

You can customise these reports and export them to Excel. Then, compare data from there.

Don' hesitate to leave a comment below if you need additional information. I'm always around to help you.