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.
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 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/2020 and 12/31/2020, a check with a check date of 11/15/2020 but a clear date of 12/28/2020 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 uncleared checks on the report. The uncleared checks and deposits will display “Uncleared” 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.
3 Print the report.
- Once the required report settings have been specified, click the Print button to print your report.
- Click the options arrow on the right side of the Print button to see other print options.
- Select Send PDF to Job Viewer to print the report in the default Springbrook format.
- Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
- Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
- Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
- Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
- Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
- Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.
- The Balance as of field that displays for each bank account on the report is the balance before the transactions are applied. For example, if the report is filtered by 12/01/2020 to 12/31/2020 and there are transactions on 12/01/2020, the transactions on 12/01/2020 will not be included in the Balance as of 12/01/2020 field.