Calculated Accounts for Usage Credit Submeters
Issue: I have “deduct” water submeters on cooling towers, irrigation, boiler make-up water feeds and other water end uses that are not connected to the sanitary sewer. I read these submeters and submit the data to the sewer authority where the usage is deducted from the master water meter in order to determine billable sewer volume. What’s the best way to set up EnergyCAP to track and report on my credits?
Solution: Create a series of submeter accounts that is separate from your primary organization accounting structure. Then set up Calculated Account submeters. Follow the procedure below:
- From the Account Manager (Accounting > Accounts), create a new cost center for water submeters.
- Under that cost center, create calculated accounts (see Calculated Accounts topic). Each calculated account represents one water submeter.
(In this example, the cost calculation is irrelevant. A dummy water rate was created and assigned to the calculated account(s).
- For each water account that has more than one deduct submeter, create a Meter Group (Group Manager-Setup/Groups) and assign all of the deduct meters to the account group. The purpose of each group is to facilitate the use of the BL28 report to provide the total deduct consumption per group.
- Create one meter reading route in Route Manager and assign the deduct submeters to it. Each month, enter the meter readings in the route:
- Calculate bills each month after entering the submeter readings.
- A bill will be created for each submeter each month.
- Use Billing Report BL07 for a detailed report (one bill on one page).
NOTE: Because this bill was created internally by EnergyCAP (as opposed to an incoming bill from a vendor), the bill is internally coded as a “to customer” bill. It will not appear on reports unless you set the Status Filter as shown below:
- Report BL28 will show totals by Meter Group (note that units of measure are shown in “common units” which in this case is MGal (1,000 gal).
