Summary

The Outstanding Transactions Report is the most flexible report in the Bank Reconciliation module because it displays a listing of all transactions in the module.

The Outstanding Transactions Report will include cleared checks and deposits if the Include cleared checks toggle is checked. The transactions in an open Clear Transactions batch (BR> Clear Transactions) are not cleared until they have been committed using the Commit step.

Step by Step

1     Open the Outstanding Transactions window (BR> Reports> Outstanding Transactions).

2     Configure the report.

• Select the bank accounts you would like to include in the report in the Bank Accounts field. Only transactions on selected bank accounts will display on the report. You can also click the SELECT ALL or DESELCT ALL buttons to select/deselect all the displayed bank accounts.
  • Bank accounts are created using the Bank Account Maintenance window (SS> Maintenance> Bank Account).
• Enter a date range in the Check Date From and Check Date To fields to filter the transactions that display on the report by check date.
  • Deposits will be included on the report if All or Deposits is selected in the Transaction Type drop-down menu. If you include deposits on the report, the deposit date will be used as the check date.
    • The deposit date is entered on deposits created in the Receipt Deposits process during the Select Batches step (BR> Receipt Deposits> Select Batches> Deposit Date field). The deposit date is entered on deposits created in the Enter Deposits window in the Deposit Date field (BR> Utilities> Enter Deposits> Deposit Date field).
• Enter a check number in the Check Number From and Check Number To fields to filter the checks that display on the report by check number. Deposits do not have check numbers, so the values entered in these fields will not affect the deposits that display on the report.
• Select the type of transactions you would like to include in the report in the Transaction Type drop-down menu.
  • Select All if you would like to include deposits and checks on the report.
  • Select Checks if you would like to include only checks on the report.
  • Select Deposits if only deposits created in the Receipt Deposits or Enter Deposits window (BR> Utilities> Enter Deposits) should display on the report.
    • If you select Deposits, the Check Number From and Check Number To fields will have no function since deposits do not have check numbers.
• Select the modules that created the checks you would like to include on the report in the System field. For example, if you would like to generate a report on Payroll checks, check the Payroll toggle.
  • Check the Accounts Payable toggle if you would like to include checks made out to Accounts Payable vendors.
  • Check the Bank Reconciliation toggle if you would like to include checks generated using the Check Maintenance window (BR> Utilities> Enter Checks).
    • Even though checks created using the Check Maintenance window are attached to either an employee or AP vendor, the checks will not display the report if you don't check the Bank Reconciliation toggle.
  • Check the Payroll toggle if you would like to include checks made to employees.
• Select the voided checks you would like to include on the report in the Void Checks drop-down menu. Voided checks will display exactly the same way as non-voided checks on the report.
  • Select Exclude void checks to exclude all voided checks from the report.
  • Select Show all void checks to include all voided checks on the report.
  • Select Use commit date for voids to include all outstanding voided checks with a commit date within the date range entered in the Check Date From and Check Date To fields.
  • Select Use Journal Entry date for voids to include all outstanding voided checks with a journal entry date within the date range entered in the Check Date From and Check Date To fields.
• Select the level of detail you would like to include on the report in the Report Type drop-down menu.
  • Select Detail to include the individual transaction information on the report. This option will display the information attached to each check and deposit included on the report.
  • Select Summary if you would only like the report to display a total of the transactions included on the report for each bank account. Individual checks and deposits will not display on the report, but they will be totaled and display with the bank account attached to each transaction.
• Check the Include bank accounts without activity toggle to include accounts that were inactive during the specified date range.
  • This toggle will only be active if Summary is selected in the Report Type drop-down menu.
• Check the Include cleared checks toggle if you would like to include cleared checks on the report. The transactions in an open Clear Transactions batch (BR> Clear Transactions) are not cleared until they have been committed using the Commit step.
  • Checks are cleared using the Clear Transactions process (BR> Clear Transactions).

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.