I put the monthly total income of invoices from quickbooks into a spreadsheet, but at the end of the tax year, the totals are different. Can anyone tell me why?

Hi, Sarah. You can view a specific month, such as September 2025, by utilizing the Custom date range feature within your reports. This allows you to pull accurate figures, as it uses the exact data prepared for your tax return.

To do this, follow these steps:

1. Select Reports from the left-hand menu.
2. Find the Profit and Loss report.
3. Use the date dropdown to select Custom and enter your dates (e.g., 01/09/2025 to 30/09/2025).
4. Click View to see your total income for that month.

To get the specific list you need for that comparison, go to the Transactions menu and choose a Custom date range to filter for that specific month. This is more effective than just checking your spreadsheet because it reveals "hidden" issues, like an accidental date change or a business payment marked as "Personal", which would cause the transaction to be excluded from your report totals.

To avoid manual typing errors moving forward, customise your reports or transactions and click the Download icon on the page. This allows you to export your data directly into an Excel or spreadsheet file, ensuring your records always remain an exact match of your QuickBooks data.

Please don't hesitate to leave us a response if you have other questions or concerns.