Personal service business administration

Freelancer invoice collection aging calculator

Signed day offsets are supplied from contractual due dates; due today is current. Disputes, credit notes and interest are excluded.

Your numbers

Use the units shown. Results update as you change valid inputs.

YOUR RESULT

Signed day offsets are supplied from contractual due dates; due today is current. Disputes, credit notes and interest are excluded.

THE NUMBERS, EXPLAINED

How to use this calculator.

Signed day offsets are supplied from contractual due dates; due today is current. Disputes, credit notes and interest are excluded.

Start with your inputs

Enter invoice face values (currency), receipts allocated to invoices (currency), days overdue at report date. Keep amounts in the units shown on each field. The example is a starting point, not a recommended value.

InputExample value
Invoice face values (currency)100,200,300,400
Receipts allocated to invoices (currency)0,50,100,0
Days overdue at report date-5,15,45,100

A worked example

With the example inputs above, not yet due balance (currency) is 100. Change the inputs to explore your own scenario.

All results for the example inputs above
ResultExample answer
Not yet due balance (currency)100
1–30 days overdue balance150
31–90 days overdue balance200
Over 90 days overdue balance400
Total outstanding (currency)850

How this is calculated

Not yet due balance (currency)

Include invoices due today or later.

1–30 days overdue balance

Sum unpaid balances in the first overdue band.

31–90 days overdue balance

Sum unpaid balances in the middle band.

Over 90 days overdue balance

Sum unpaid balances beyond ninety days.

Total outstanding (currency)

Add all invoice balances after allocated receipts.

Symbols and units
a
Invoice face values (currency)
b
Receipts allocated to invoices (currency)
c
Days overdue at report date

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions and limits

Signed day offsets are supplied from contractual due dates; due today is current. Disputes, credit notes and interest are excluded.

Calculations use the values you enter. Blank or invalid inputs show an error instead of silently substituting zero. Results are displayed to useful precision; calculations retain the underlying numeric precision.

Questions about this tool

What does the result tell me?

Not yet due balance (currency); 1–30 days overdue balance; 31–90 days overdue balance; Over 90 days overdue balance; Total outstanding (currency). The result applies to the method and inputs described above. Check the units and assumptions before using it in a decision.

Why might another calculator differ?

Differences in units, rounding, timing or model definitions can produce different answers. Compare the input definitions and the method, rather than only the final number. For this tool: Signed day offsets are supplied from contractual due dates; due today is current. Disputes, credit notes and interest are excluded.

Are my inputs stored or sent to AI?

Calculations on this page happen in your browser. The separate AI question finder sends its submitted conversation to OpenAI; these calculator fields are not sent. Favourites and recent tool names are stored locally. A shared link contains the inputs you choose to include.

Further reading

OpenStax: Describe and Identify Cost Drivers ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Review status

Software example and browser checks are recorded in our quality report. No external expert review is claimed. Created with coding assistance; calculations run as ordinary browser code.

Read the quality report →