Advisor Overdue Invoice Collection Calculator

Developed and maintained by ProWorkstack · Development and review process

Compare possible collections from overdue invoices, then deduct admin costs and the reserve you choose to set aside.

Read the step-by-step guide →

Developed and reviewed by the ProWorkstack editorial team.

Your inputs

Calculations run in your browser. No account required.

USD
Unpaid invoice value after credits and payments, for the invoices you are reviewing. Exclude future installments.
%
USD
%

Your results

Enter your inputs and select Calculate.

How this calculator works

Expected collections = overdue balance × collection percentage. The reserve base is collections minus admin cost, with a minimum of zero. Apply your reserve percentage to that base. The remainder is available after the reserve; any loss where admin cost exceeds collections needs separate review.

Worked example

An overdue 5,000 balance at 80% collection gives 4,000 gross payments received. Less 150 administration leaves 3,850. A verified scenario reserve of 25% allocates 962.50, leaving 2,887.50.

Assumptions

Start with the unpaid balance after confirmed credits and payments. The collection percentage is your scenario, not a predicted probability. Admin costs are deducted before applying your reserve percentage. The defaults are examples, not benchmarks.

Interpreting your results

This sends no reminders and determines no tax obligation, collection rights or late fees. The reserve percentage is user supplied. If collection costs exceed payments received, the economic loss must be considered separately; the allocation base is floored at zero.
Calculation formulas
gross
balance*collect/100
net
MAX(gross-cost,0)
held
net*reserve/100
Expected payments after admin costs and reserve
net-held
Money to set aside
held
Expected payments before costs
gross
Invoice amount outside your collection estimate
balance-gross

Frequently asked questions

Which invoice balance should I use?

Use the agreed due date and check disputes, credits and payments received posted after your cutoff. Exclude future installments. A collection percentage is a scenario assumption, not a probability assigned by this tool.

How should I interpret the main result?

Expected collections after admin costs and your reserve. If costs exceed collections, this allocation is zero; review the economic loss separately.

Maintained by ProWorkstack editorial team · Last reviewed: 2026-10-06 · Development and review process

Related tools