During the batch billing process, a bill summary is prepared. In conjunction with the bill summary, a general ledger distribution summary is also prepared. The totals on the bill summary should always match the total on the general ledger distribution, with one exception. If the system is organized such that the revenue is booked on a cash basis, and at least one account has a negative bill, the general ledger will not match the bill summary. The following is an explanation of this situation.
For purposes of example, assume that the bill summary includes two accounts. The first account is billed a total of $100 and the second account is to receive a credit for a prior reading error in the amount of $10.
The system can be set up on either a cash or accrual basis. The following table illustrates the difference.
Accounting Basis |
Service |
Cash Account |
Receivables Account |
Revenue Account |
Accrual |
Residential Water |
1010 |
1210 |
4010 |
Cash Basis |
Residential Water |
1010 |
4010 |
4010 |
If the system is set up on an accrual basis, the bill summary and general ledger would appears as follows. The bill summary receivables account and revenue account all have the same balance.
|
Bill Summary |
Receivables (1210) |
Revenue Account(4010) |
Customer 1 |
100.00 |
100.00 |
-100.00 |
Customer 2 |
-10.00 |
-10.00 |
10.00 |
Total |
90.00 |
90.00 |
-90.00 |
If the system is set up on a cash basis, the bill summary and general ledger will not have the same balance because the system is debiting and crediting the same account. The difference between the bill summary total and the GL distribution total is always double the actual credit charge(s).
|
Bill Summary |
Receivables (4010) |
Revenue Account(4010) |
Customer 1 |
100.00 |
100.00 |
-100.00 |
Customer 2 |
-10.00 |
10.00 |
-10.00 |
Total |
90.00 |
110.00 |
-110.00 |
Account 4010 Total |
0.00 |