Summary
The Deposit Balances Report displays the deposit balance on UB customer accounts. The report can be filtered by billing cycle, deposit fee code and customer account status (Active, Delete, Final, etc.). The report also includes aShow Refunded Depositstoggle in order to include refunded deposits on the report.
If you would like a report that displays a list of deposit transactions including interest, generate a Deposit Transactions Report (UB Reports Deposit Transactions Report).
Step by Step
1Open theDeposit Balanceswindow (UB Reports Deposit Balances).
2Configure the report.
- TheBilling Cyclefield 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.
- Filter the transactions included in the deposit balances on the report using theBalance as ofandDate Typedrop-down menu.
- The report will display the balance on deposits as of the date entered in theBalance as offield. The transactions included in the deposit balance will be filtered by this date.
- TheDate Typedrop-down menu is used to select the type of date that will be used by the Balance as of field.
- You can view the journal entry date, post date or transaction date of a transaction using the History tab of the Account Master Maintenance window (UB Maintenance Account History tab).
- The post date of a transaction is the date the batch is committed.
- TheFee Codefield 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.
- TheAccount Statusfield is used to select the status of the customer accounts that will be included in the report.
- You can view the status of a UB customer account on the Account Master Maintenance window (UB Maintenance Account Account tab Account sub-tab Account Status field).
- TheTotal Bydrop-down menu is used to select how the report will total.
- Select Cycle to total the deposit balances in the report by billing cycle.
- Select Fee Code to total the deposit balances on the report by fee code.
- Check theShow Refunded Depositstoggle if you would like to include refunded deposits on the report.
- Refunded deposits will be totaled separately on the report.
3Print 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 iconnext 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. Hover over the Info icon to view the parameters on the previous report.
- This section will display the last three times the report was generated.