UB> Reports> Deposit Balances
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 a Show Refunded Deposits toggle 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).
Related Links
Click here for an overview on deposits.
Click here for information on the Deposit Transactions Report.
Click here for information on the Jobs Viewer window.
Click here for information on the View Reports window.
Step by Step
1 Open the Deposit Balances window (UB> Reports> Deposit Balances).
- 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.
- Filter the transactions included in the deposit balances on the report using the Balance as of and Date Type drop-down menu.
- The report will display the balance on deposits as of the date entered in the Balance as of field. The transactions included in the deposit balance will be filtered by this date.
- The Date Type drop-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.
- 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.
- The Account Status field 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).
- The Total By drop-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 the Show Refunded Deposits toggle if you would like to include refunded deposits on the report.
- Refunded deposits will be totaled separately on 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 here for information on the Jobs Viewer window.- 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). Click here for information on the View Reports window.