Open calculator ↗

Documentary collection versus open account cost · Calculation guide

Compare bank charges and expected uncollectible exposure for the same invoice.

Calculation guide

Enter loss percentages after recoveries for each method.

saving = oaFee-dcFee+face*(oaLoss-dcLoss)/100

Inputs

Invoice amount

Example entry 100000.0 (in the selected currency).

Collection fees

Example entry 600.0 (in the selected currency).

Open-account fees

Example entry 100.0 (in the selected currency).

Collection expected loss (%)

Example entry 1.0 %. Allowed range 0 to 100.

Open-account expected loss (%)

Example entry 2.0 %. Allowed range 0 to 100.

Worked example

InputValue
Invoice amount100,000
Collection fees600
Open-account fees100
Collection expected loss (%)1%
Open-account expected loss (%)2%
ResultValue
Expected saving from documentary collection500

Calculation steps

Expected saving from documentary collection = ((Open-account fees − Collection fees) + ((Invoice amount × (Open-account expected loss (%) − Collection expected loss (%))) ÷ 100))

((100 − 600) + ((100,000 × (2 − 1)) ÷ 100)) = 500

Interpreting the result

A positive saving favors documentary collection after both fees and expected loss.

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Invoice amount100,000110,000Expected saving from documentary collection500600
Collection fees600660Expected saving from documentary collection500440
Open-account fees100110Expected saving from documentary collection500510
Collection expected loss (%)1%2%Expected saving from documentary collection500-500
Open-account expected loss (%)2%3%Expected saving from documentary collection5001,500
Documentary collection versus open account cost →

Sources