Utility Management

Balance Utility Management accounts to the General Ledger.

In this Topic

Utility Management
1. Balance cash clearing account - Utility Management
1. Balance accounts receivable accounts - Utility Management
1. Balance customer deposits - Utility Management
1. Troubleshooting
  1. How does the Utility Billing Transaction Summary Report tie to the General Ledger?

Balance cash clearing account - Utility Management

At the end of each month, the Utility cash clearing account balance should be zero.

Do this...

1. Review the Utility cash clearing account balance.

Use General Ledger Inquiry or print a General Ledger Detail report for the Utility cash clearing account.
Review the Utility cash clearing ending balance.

2. STOP if the Utility cash clearing ending balance is zero.

3. CONTINUE if the Utility cash clearing ending balance is NOT zero.

4. Compare the Utility Management Transaction Summary report to the Credit Amount by date on the Detail Ledger to identify the problem.

The source of the Credit (-) column on the General Ledger Detail report is daily totals from the CR (Cash Receipts) journal.
The source of the Debit (+) column on the Utility Management Transaction Summary report is daily totals from the UM (Utility Management) journal.

6. Print the Utility Management Transaction Register for payments and the Cash Receipting Receipt Register.

7. Use the Cash Receipting Receipt Register to find the transaction, use the date identified in Step 5, that was not updated to the General Ledger or Utility Management application.

Tip! If you choose the Detail Ledger, start with a zero-balance and work forward. Check for a recent journal entry with an incorrect entry. Now, make the corresponding journal entry in Accounts Payable or General Ledger.

The cash clearing account is balanced.

Balance accounts receivable accounts - Utility Management

Balance the Accounts Receivable account balances in the General Ledger to the Utility Management Accounts Receivable by Service report at the end of each month.

Do this...

1. Review the ending balance for each accounts receivable account in the General Ledger.

Launch General Ledger Inquiry, or print Report by Category.
If the ending balances in General Ledger Inquiry match the ending balances on the Report by Category, you are DONE.

2. CONTINUE if the ending balances DO NOT match.

Compare the General Ledger Detail report to the General Ledger Update Summary report to identify out of balance amounts.
Tip! Here is one method you can use to verify accounts and updated amounts. Delete the UM journal from the General Ledger application. Next, rerun the Update General Ledger routine from the Utility Management application to update Utility Management amounts to the General Ledger. Watch for errors, warnings for invalid GL accounts, and verify account numbers for GL override accounts. Finally, check the previous month's balance to ensure you are still in balance.

Balance customer deposits - Utility Management

Balance the customer deposit liability account balances in the General Ledger to the Utility Management Open Deposit report at the end of each month.

Do this...

1. Review the General Ledger Customer Deposit account balance.

Use General Ledger Inquiry or print the General Ledger Detail report for each account.
Compare the customer account balance to the Customer Open Deposit report.

2. STOP if the balances match.

3. CONTINUE if the balances DO NOT match.

4. Search the Deposit report for new deposits.

5. Compare the Utility Management Refunds/Applied report to the General Ledger Detail report.

The source of the Credit side of the General Ledger Detail report is deposits applied and deposits refunded.
The source of the Debit side of the General Ledger Detail report is new deposits posted from the Cash Receipting system. The New Deposits report will match the debit side of the entry if deposits were entered correctly in the Utility Management system.

Tip! Make sure the General Ledger beginning balance matches the previous month's Open Deposit report.

The customer deposits are balanced.

Troubleshooting

How does the Utility Billing Transaction Summary Report tie to the General Ledger?

The Utility Billing Transaction Summary Report shows the receipts and payments by date; the values on the report should match the values posted, by date, to the Utility Cash Clearing Account from Cash Receipting.