The banking reports give you full or summarised information about bank transactions and categorisations, where money comes from within your business, and the results of reconciling your accounts against your banks’ records.
You can access the banking reports via the Reporting menu > Reports > Banking reports. The reports and their functions are listed below.
Banking activity—shows all deposits and withdrawals for your selected bank or credit card categories, along with a running balance. This includes transactions you’ve recorded and transactions from your bank feed and imported statements.
Banking transactions—shows deposits and withdrawals from bank feeds or imported statements, plus a running category balance. These are the same transactions that appear on the bank transaction page.
Reconciliation—shows a detailed or summary report for each bank reconciliation completed on your categories.
Coding—lists transactions and their allocation status. This is a valuable resource if you or your accounting advisor as it provides a list of transactions to be allocated.
Statement of cash flow—shows how your cash position has changed over a period of time, the amount of cash earned from profit, where you received additional cash, and where your cash was spent.
Available reports are based on your plan
If there's a report listed here that you need, go to My Account to upgrade your plan (click your business name > My Account > Manage my product).
To run a banking activity report
Go to the Reporting menu and choose Reports.
Click to open the Banking activity report.
Filter the report as required:
Choose a date range to report on.
Choose the source transactions to include in the report.
Choose the categories to include in the report.
Click Report options for additional filters.
To run a banking transactions report
Go to the Reporting menu and choose Reports.
Click to open the Banking transactions report.
Filter the report as required:
Choose a date range to report on.
Choose the source transactions to include in the report.
Choose the categories to include in the report.
Click Report options for additional filters.
To run a banking reconciliation report
Go to the Reporting menu and choose Reports.
Click to open the Banking reconciliation report. The report displays a list of the available reconciliation reports for each category you reconcile.
Choose a Bank statement date and/or click Categories to choose specific accounts to filter the list.
Click Report options for additional filters.
Click the dropdown arrow to view details of a reconciliation.
To run a coding report
Go to the Reporting menu and choose Reports.
Click to open the Coding report.
Filter the report as required.
Choose a date range.
Choose the categories to include in the report.
(optional) Select the option Include allocated transactions.
Click Report options for additional filters.
To run a statement of cash flow report
Here's how to generate the report. To learn more, see Statement of cash flow report.
Go to the Reporting menu and choose Reports.
Click to open the Statement of cash flow report.
Choose a date range to report on.
Click Report options for additional filters.
View the report details.
Click the dropdown arrow to view details of your operating, investing and financing activities.
Click a category's Net balance to see the associated transactions.
Exporting, saving and printing
You can export your report as an Excel spreadsheet or PDF by clicking Export. Note that you must enable editing of the spreadsheet from within Excel. If editing is disabled, the spreadsheet will not display the totals calculated in the report.
When exporting PDFs, you can also choose which style template you want to use. When the PDF displays, you can save it.
When viewing a report, click View and print to display the report as a PDF in a new browser tab, where you can save or print it.