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.
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 AR Account field label 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.
- Select Total by GL Account if the report should display a single line item for each GL account included on the report.
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).