BR> Reports> Bank Activity Report

Bank Activity Report

Summary

The Bank Activity Report displays the balance and activity of a selected bank during a date range. Each bank account attached to the banks included on the report will be totaled separately. The report will display a beginning and ending balance, the transactions on the bank account, and the clear date of each transaction. The report will display both checks and deposits.

Click here for information on the View Reports window.

Click here for information on the Report Publisher.

Step by Step

1 Open the Bank Activity window (BR> Reports> Bank Activity).

2 Configure the report.

Select a bank account from the Bank drop-down menu or select All to include all banks accounts in the report.

The Bank drop-down menu will display all banks that have been created in the Bank Maintenance window (SS> Maintenance> Bank).

The Bank Account field is used in conjunction with the Bank drop-down menu. Select a Bank Account from the drop-down menu to filter the report by a specific bank account attached to the bank selected in the Bank drop-down menu. Select All if you would like to include all of the bank accounts attached to the bank selected in the Bank field.
- Bank accounts are created using the Bank Account Maintenance window (SS> Maintenance> Bank Account). Banks are attached to a bank account in the Bank Code field on the Bank Account Maintenance window.
The Date From and Date To fields are used to select the activity that will display on the report. If the check date or clear date of a transaction falls within the date range entered in these fields, the transaction will be included on the report.

For example, if the report is filtered by 12/01/2019 and 12/31/2019, a check with a check date of 11/15/2019 but a clear date of 12/28/2019 will be included on the report because the clear date occurs during the date range.
The check date of a deposit is the deposit date set when the deposit was created (BR> Receipt Deposits> Deposit Date field, or BR> Utilities> Enter Deposits> Deposit Date field).
The clear date of a transaction is set during the Commit step of the Clear Transactions process (BR> Clear Transactions> Commit> Clear Date field).

Check the Page break by bank code toggle if you would like to each bank included on the report to display on a separate page.
Check the Page break by account toggle if you would like each bank account to display on a separate page.
Check the Show uncleared Items toggle to include un-cleared checks on the report. The un-cleared checks and deposits will display “Un-cleared” in the Date Cleared column of the report, and will be grouped together at the bottom of the report.
Check the Use historical data for specified date range to include any check that was uncleared by the Date To as long as it does not have a void date before or equal to the Date To date.
- This toggle is only active if the Show uncleared items toggle is checked.