Overdraft cost from dated transactions · Calculation guide

Measure overdraft interest on each negative closing balance.

Calculation guide

Apply same-day movements before interest. Dates are inclusive, using actual days/365 and constant simple interest. The flat daily fee applies on negative closing days only. No capitalization.

cost = Σ max(0, −closing balance) × APR / 36500 + fee × negative days

Inputs

First day

Enter the calendar date in the date field.

Last day

Enter the calendar date in the date field.

Opening balance before first day

Example entry 100 (in the selected currency).

Annual overdraft interest

Example entry 36.5 %. Allowed range 0 to 100.

Fee per negative day

Example entry 1 (in the selected currency).

Posting date

Enter the calendar date in the date field.

Signed amount (+ in, − out)

Example entry -200 (in the selected currency).

Worked example

InputValue
First day2026-01-01
Last day2026-01-10
Opening balance before first day100
Annual overdraft interest36.5%
Fee per negative day1

Dated transactions

Posting dateSigned amount (+ in, − out)
2026-01-02-200
2026-01-05120
ResultValue
Total overdraft cost3.3
Interest0.3
Days overdrawn3 days

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening balance before first day100110Total overdraft cost3.33.27
Annual overdraft interest36.5%40.5%Total overdraft cost3.33.332877
Fee per negative day12Total overdraft cost3.36.3
Posting date (row 1)2026-01-022026-01-03Total overdraft cost3.32.2
Signed amount (+ in, − out) (row 1)-200-180Total overdraft cost3.33.24
Overdraft cost from dated transactions →