Banking reports

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.

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 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 - 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.