Child support arrears with dated payments and interest · Calculation guide

Accrue simple Actual/365 fixed interest on unpaid principal before each event, add charges, then pay accrued interest first and principal second.

Calculation guide

Overpayments require separate credit accounting.

I += outstanding principal × annual rate × days / 365. Allocate payment to interest, then principal.

Inputs

Opening date

Enter the calendar date in the date field.

Valuation date

Enter the calendar date in the date field.

Opening unpaid principal

Example entry 1000 (in the selected currency).

Annual simple interest (%)

Example entry 10 %. Allowed range 0 to 100.

Effective date

Enter the calendar date in the date field.

New principal due

Example entry 0 (in the selected currency).

Payment received

Example entry 200 (in the selected currency).

Worked example

InputValue
Opening date2025-01-01
Valuation date2026-01-01
Opening unpaid principal1,000
Annual simple interest (%)10%

Dated charges and payments

Effective dateNew principal duePayment received
2026-01-010200
ResultValue
Closing arrears including interest900
Unpaid principal900
Unpaid simple interest0

Interpreting the result

A payment smaller than accrued interest leaves the principal unchanged. Future interest continues to accrue on that principal.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening date2025-01-012025-01-02Closing arrears including interest900899.726027
Valuation date2026-01-012026-01-02Closing arrears including interest900900.246575
Opening unpaid principal1,0001,100Closing arrears including interest9001,010
Annual simple interest (%)10%11%Closing arrears including interest900910
Effective date (row 1)2026-01-012025-12-31Closing arrears including interest900899.972528
New principal due (row 1)01Closing arrears including interest900901
Payment received (row 1)200220Closing arrears including interest900880
Child support arrears with dated payments and interest →

Sources