Summary

The Target Allocation Statement report is a useful tool for agencies implementing Allocation Billing. The report uses prior usage and a target allocation percent to provide the account holder with an allowed usage statement for the upcoming year.

Step by Step

1Open theTarget Allocation Statementreport window (UB Reports - Allocation Billing Target Allocation Statement).

2Configure the report.

• Check the toggle next to eachRouteyou would like to include in the report.
  • By default, all routes will be selected. You can check the toggle next to the field title to select or deselect all the displayed routes. This applies to all of the following toggle fields as well.
  • Routes are created and maintained on the Route Maintenance window (UB Maintenance Route).
• Check the toggle next to eachCycleyou would like to include in the report.
  • Cycles are created and maintained on the Cycle Code Maintenance window (UB Maintenance Cycle Code).
• Check the toggle next to eachClassyou would like to include in the report.
  • Classes are created and maintained on the Class Maintenance window (UB Maintenance Class).
• Check the toggle next to eachAccount Statusyou would like to include in the report.
  • The account status is specified on the UB Account Maintenance window (UB Maintenance Account Account tab Account Status drop-down menu).
• TheStart Period,Start Year,End Period, andEnd Yearfields are used to set the start and end dates for the prior consumption history that will be used when calculating the allocation amount for each period.
  • These are required fields and the range is limited to 12 periods.
• TheAllocation Percentfield is used to specify the percentage of prior consumption that will be used for current allocation amount.
  • For example, entering "85" in this field will set the allocation amount at 85% of the prior consumption history for each period.
• TheAccount Numberfield is used to generate the statement for a single UB account. Click the field search button to select the account.
• TheMessage TopandMessage Bottomdrop-down fields are used to add a statement messages that will display above or below the target allocation amounts.
  • The drop-down fields will display any statement messages set up to be attached to Target Allocation. If the field is left blank, no message will be displayed.
  • Statement Messages are created and maintained on the Statement Message Maintenance screen (UBMaintenance Statement Message).
• The report will include account holder's name and address, the usage, allocation percent, and current allocation for each billing period, and top and bottom messages if present. Each account included in the report will be displayed on a separate page.

3Print the report.

• Once the required report settings have been specified, click the Print buttonto 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 iconnext 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 clickSUBMIT.
• 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.