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)