UB> Reports> Balance by AR Account

Balance by AR Account Report

Summary

The Balance by AR Account Report will display the balance of accounts receivable GL accounts attached to fee codes and service rates. Only committed transactions will be included in the balances that display on the report and the transactions that are included on the report can be filtered by journal entry date.

Accounts receivable GL accounts are attached to fee codes using the Fee Code Maintenance window (UB> Maintenance> Fee Code> AR Account field), and attached to service rates using the Service Rate Maintenance window (UB> Maintenance> Service Rate> Select a service> Select a service rate> Select a revision> General tab> AR Account field).

Generate the AR Totals by Cycle Report (AR> Reports> AR Totals by Cycle) if you would like to print the AR balance by billing cycle. The transactions that display on the report cannot be filtered by date.

Click here for information on Fee Code Maintenance.

Click here for information on Service Rate Maintenance.

Click here for information on the Jobs Viewer window.

Step by Step

1 Open the Balance by AR Account window (UB> Reports> Balance by AR Account).

2 Configure the report.

The AR Account field is used to filter the report by a specific general ledger account. Click the Search button or enter a GL account number to filter the report.

General ledger accounts are created by fiscal year using the Chart of Accounts Maintenance window (GL> Maintenance> Chart of Accounts> Select a fiscal year).

The Balance Date field is used to filter the transactions that display on the report.

The Balance Date field will filter the transactions that display on the report by journal entry date. Uncommitted transactions will not display on the report or be included in the balances.

The Report Detail drop-down menu is used to select the information that will display on the report.

Select Total by GL Account if the report should display a single line item for each GL account included on the report.

This is the simplest version of the report.

Select Show Rate Detail if the report should display the AR balance of each service rate and fee code attached the AR GL account. The report will display a line item for each fee code or service rate attached to the AR account and will display the balance generated by each.
Select Show Account Detail if the report should display the AR balance of each service rate or fee code attached to the AR GL account, and the balance of the UB customer accounts. The report will display a line item for each service rate or fee code attached to the AR GL account, and will also display a line item for each UB customer account with a balance on those fee codes or service rates.

This is the most detailed version of the report. It displays all of the information that displays on the previous two reports.

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. Hover over the Info icon to view the parameters on the previous report.
- This section will display the last ten times the report was generated.