UB> Reports> Deposit Transactions

Deposit Transactions Report

 

Summary

 

The Deposit Transactions Report displays the deposit and/or interest transactions filtered by billing cycle, journal entry date, transaction date and fee code. The transactions included on the report can be totaled by UB customer account or batch number.

 

If you would like a report that displays the deposit balances, generate a Deposit Balances Report (UB> Reports> Deposit Balances).

 

Related Links

 

Click here for an overview of Deposits.

Click here for information on the Deposit Balances Report.

Click here for information on the Jobs Viewer window.

 

Step by Step

 

1     Open the Deposit Transactions window (UB> Reports> Deposit Transactions).

 

2     Configure the report. 

 

  • The Billing Cycle field is used to select the customer accounts you would like to include on the report. Only customer accounts attached to the selected billing cycles will be included on the report.
    • Click the toggle next to the field title to select all of the billing cycles in the field.
  • Enter a date range to filter the report by journal entry date or transaction date. You must filter the report by one or the other.
    • The Journal Entry Begin and Journal Entry End fields are used to filter the deposit transactions that display on the report by the journal entry date. You must enter a date range in the journal entry or transaction date fields.
      • If you would like to filter the deposit transactions by transaction date, enter a date range in the Transaction Date Begin and Transaction Date End fields.
    • The Transaction Date Begin and Transaction Date End fields are used to filter the transactions that display on the report by the transaction date of the deposit transaction. You must enter a date range in the journal entry or transaction date fields.
  • The Fee Code field is used to select the deposit fee codes that will be included on the report. Only fee codes set up as deposit fee codes will display in the Fee Code field.
    • Fee codes are set up as deposit fee codes using the Fee Code Maintenance window (UB> Maintenance> Fee Code> Deposit toggle).
  • The Deposit Detail field is used to select the type of transactions that will be included on the report. You must check one of the toggles in this field.
    • Check the Deposit toggle if you would like the creation of the deposit to display on the report.
    • Check the Interest toggle if you would like interest transactions associated with the deposit amount to be included on the report.
      • Interest can be factored on deposit amounts using the Adjustments and Fees palette (UB> Adjustments and Fees> Factor Deposit Interest), or it can be factored when the deposit is refunded using the Generate step of the Refunds process (UB> Refunds> Generate> Factor Interest toggle).
    • Check the Refund toggle if you would like transactions associated with deposit refunds to be included in the report.
      • Refunds on deposits are processed using the Refunds process (UB> Refunds).
  • The Total By drop-down menu is used to select how the report will total.
    • Select Account to total the transactions on the report by UB customer account.
    • Select Batch to total the transactions on the report by batch number.
      • You can view the batch number attached to a deposit transaction using the Account Master Maintenance window (UB> Maintenance> Account> History tab> Account History sub-tab> Batch column).

 

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 PDF to print the report in the default Springbrook PDF format.
    • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
    • Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
    • Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
  • Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
    • Enter a Date and Time to generate the report and click SUBMIT.
  • 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.