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).
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.
- Press CTRL+A to highlight all of the billing cycles in the field. Press SPACE to check or uncheck the highlighted toggles.
- 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 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.
- 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> Batch column).
3 Print the report.
- Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
- Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
- Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
- Click the Print icon drop-down menu and 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 the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).