Banking reports

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.

You can view the following banking reports from the Banking report group (go to the Banking command centre and click the Reports button).

If you need a refresher on running reports, see displaying a report. Or if you want to change the look and content of a report, see customising reports.

Cheques and Deposits

Bank Register report - This report displays all cheques, withdrawals and deposits made using the selected cheque account within a specified period. A running account balance is displayed. This report only displays transactions entered in windows your user ID allows access to.
Report Tips:
- You can run this report for all of your cash and cheque accounts each month. Enter the required date range in the Report Customisation window and keep the report with your monthly financial reports.
- If your cash accounts are numbered similarly except for the last digit (for example, 1-1101, 1-1102, 1-1103, etc.), you can enter 1-110* in the Selected field of the Report Customisation window to display the Bank Register report for all your cash accounts at once.
View transaction source
Click in any field to open the transaction journal source window.
- GJ - General Journal Entry window
- CD - Spend Money, Pay Employees (Plus and Premier, Australia only) or Pay Supplier window
- CR - Prepare Bank Deposit or Receive Payments window
- SJ - Sales window
- PJ - Purchases window
- IJ - inventory Adjustment, Build Items or Auto-Build Items windows.
Bank Deposit Slip report - This report displays transactions deposited to selected cheque accounts within a period. If this report is printed when recording a Prepare Bank Deposit transaction, the report displays the current transaction only.

View transaction source
Click ID No., Payment Method or Amount, this will open the Prepare Bank Deposits window
Undeposited Funds report - This report displays all transactions posted to the Undeposited Funds account during the specified period.
View transaction source
- When you click BSB Code, Account No. or Account Name, the Banking Information window opens.
- Click ID No. to display the Edit Accounts window.
- Click Amount or Journal Number for a line item to display the Receive Payments window.
- Click Journal Number for deposit or click a deposit Date to display the Prepare Bank Deposit window.
Electronic Payments Register report - This report displays every processed electronic payment for the selected cheque account within the specified date range.
If this report is printed when recording a Prepare Electronic Payments transaction, the report displays the current transaction only.
View transaction source
Click the transaction to open the Transaction Journal source window.
- CD - Spend Money or Pay Supplier window
- CR - Receive Payments window
Unprocessed Electronic Payments report - This report displays all Spend Money, Pay Employees (Plus and Premier, Australia only) and Pay Bills transactions that were grouped with electronic payments, but which have not yet been processed in the Prepare Electronic Payments window.
View transaction source
Click any field to open the Transaction Journal window for the transaction type.
- CD - Spend Money, Pay Employees (Plus and Premier, Australia only), or Pay Supplier window
- CR - Receive Payments window
Reconciliation Report - This report displays a reconciliation summary and a list of outstanding cheques and deposits for the selected cheque accounts.
You can display and print a reconciliation report for any account that has been reconciled using the Reconcile Accounts window.
You can print the Reconciliation Report:
- from the Index to Reports window
- by clicking Print in the Reconcile Accounts window
- by clicking Print Report after you have reconciled an account.
View transaction source
Click on a report field to open the Transaction Journal source window for the transaction.
- GJ - General Journal Entry window
- CD - Spend Money, Pay Employees (Plus and Premier, Australia only) or Pay Supplier window
- CR - Prepare Bank Deposit or Receive Payments window
Statement of Cash Flow report - This report displays changes in cash and cash flow equivalents over the specified period. Learn more about this report.
View transaction source
Click any field to open the transaction window.

Transaction Journals

Cash Disbursements Journal report - This report displays the journal entries for all transactions entered in the Spend Money, Settle Returns & Credits, Pay Employees (Plus and Premier, Australia only), or Pay Bills windows within the selected period.
- This report only displays transactions entered in windows that your user ID allows access to.
  View transaction source
  Click any field to open the Transaction Journal window for the transaction type.
- GJ - General Journal Entry window
- CD - Spend Money, Pay Employees (Plus and Premier, Australia only) or Pay Supplier window
- PJ - Purchases window
Cash Receipts Journal report - This journal displays all transactions entered in the Receive Money, Settle Returns & Debits and Receive Payments windows.
This report only displays transactions entered in windows that your user ID allows access to.
View transaction source
Click any field to open the Transaction Journal source window.
- GJ - General Journal Entry window
- CR - Prepare Bank Deposit or Receive Payments window
- SJ - Sales window

Recurring Transactions

Recurring Cheques report - This report displays the names of recurring cheque transactions, the dates they were last recorded, their frequencies and the dates they are next due to be recorded.
View transaction source
Click any field to open the transaction source window.
Recurring Deposits report - This report displays the names of recurring deposit transactions, the dates they were last recorded, their frequencies and the dates they are next due to be recorded.
View transaction source
Click any field to open the transaction source window.

To Do List

To Do List - Recurring Banking Transactions report - This report displays a list of recurring cheques, deposits and General journal entries from the To Do List window.
If you use recurring transactions, you can run this report to check that you’ve recorded all the recurring entries for the month.
To do this, enter the month-end date in the As Of Date field in the Report Customisation window. When you review the report, look at the Last Posted Date to see if each recurring transaction was posted during the month.
If you can’t find the transaction, check the Trial Balance report before entering it, as another user may have posted it without using the recurring transaction feature.
View transaction source
Click any field to open the To Do List window and display the transaction details.
Recurring Transfer Money Entries report - This report displays the names of all recurring General Journal entries, the date they were last posted, the frequency of posting, and the next date on which the transaction will be due.
Click any field to open the transaction window.

Other report groups