Partial Payments Using Accounting Priority
To book holding amounts based on a priority, each holding distribution code must be assigned an Accounting Priority. When a partial payment is posted, only part of the holding amount will be transferred to the payable amount (proportional to the amount of receivables reduced by the payment). When the holding amount consists of various holding distribution codes with different accounting priorities, the amount to transfer is allocated as follows:
• Holding distribution codes associated with the oldest debt are settled first
• Within the same debt age, holding distribution codes with a higher accounting priority are booked first. If more than one distribution code shares the same priority, the settlement is distributed among them in proportion to the holding account balance
The above logic is handled by the payment segment FT creation algorithm C1-FTGL-PSAC. As an example of how these rules apply, let's assume an implementation practices cash accounting; i.e. revenue, taxes and other third party liabilities are not recognized until payment is received. Also assume the following distribution codes have been configured:
Holding Distribution Code | Description | Cash Accounting Distribution Code | Accounting Priority |
HLD-LPC | Late Payment Charge | R-MISC | 10 |
HLD-RGEN | Revenue - Generation Charge | R-GEN | 20 |
HLD-RDIS | Revenue - Distribution Charge | R-DIST | 30 |
HLD-RTRN | Revenue - Transmission Charge | R-TRAN | 30 |
HLD-THRD | 3 rd Party Charges | R-THRD | 40 |
HLD-VAT | VAT | A/P-VAT | 90 |
Assume a customer has an outstanding third party charge with an arrears date of 2/Jan/2009:
Event | GL Accounting | SA's Payoff Balance | Holding Balances |
HLD-LPC | HLD-RGEN | HLD-RDIS | HLD-RTRN | HLD-THRD | HLD-VAT |
Unpaid Amount | A/R 50 HLD-HRD <45> HLD-VAT <5> | 50 | 0 | 0 | 0 | 0 | (45) | (5) |
A bill is created for a customer and the result of the bill's financial transactions (an LPC adjustment in the amount of 10 and a bill segment in the amount of 127) include the following FT GL lines (both financial transactions have an arrears date of 15/Jan/2009):
Event | GL Accounting | SA's Payoff Balance | Holding Balances |
HLD-LPC | HLD-RGEN | HLD-RDIS | HLD-RTRN | HLD-THRD | HLD-VAT |
Bill segment created | A/R 127 HLD-RGEN <15> HLD-RDIS <20> HLD-RTRN <55> HLD-THRD <10> HLD-VAT <27> | 177 | 0 | (15) | (20) | (55) | (55) | (32) |
Adjustment created | A/R 10 HLD-LPC <10> | 187 | (10) | (15) | (20) | (55) | (55) | (32) |
No payment is received prior to the next bill. The result of the next bill's financial transaction (a bill segment in the amount of 100) includes the following FT GL lines (this financial transaction has an arrears date of 16/Feb/2009):
Event | GL Accounting | SA's Payoff Balance | Holding Balances |
HLD-LPC | HLD-RGEN | HLD-RDIS | HLD-RTRN | HLD-THRD | HLD-VAT |
Bill segment created | A/R 100 HLD-RGEN <15> HLD- RDIS <20> HLD- RTRN <45> HLD- THRD <10> HLD-VAT <10> | 287 | (10) | (30) | (40) | (100) | (65) | (42) |
The following shows the result if a customer makes a payment on 20/Feb/2009. At payment time we'll build a table of holding amounts by accounting priority and debt age as follows:
Distribution Code & Priority | HLD-LPC (10) | HLD-RGEN (20) | HLD-RDIS (30) | HLD- RTRN (30) | HLD-THRD (40) | HLD- VAT (90) |
Debt Age |
4 days old | | (15) | (20) | (45) | (10) | (10) |
36 days old | (10) | (15) | (20) | (55) | (10) | (27) |
49 days old | | | | | (45) | (5) |
Parent topic