Payment reconciliation

Invoice Payment Cycle Calculator: Mean, Median & Weighted Days

How many days did your invoices take to be fully paid? Enter three issue dates, confirmed full-payment dates and amounts to compare the mean, median and amount-weighted payment time. Use the worked example and free calculation record below to check the arithmetic. This is a selected paid sample, not a due-date, overdue-aging or portfolio DSO calculation.

Preparing your calculator with today’s date…

Check the arithmetic

For a fully paid invoice, subtract its issue date from the date full payment is confirmed. Count elapsed calendar days: September 1 to September 11 is 10 days; payment on the issue date is zero. Use one stated business date basis when translating receipt timestamps into dates. The calculator compares calendar dates without adding a day for the starting date.

Original example checked November 13, 2026. All invoices, receipts and amounts below are fictional. They match the calculator’s starting values and describe a selected paid sample, not customer performance or a market benchmark.

Three invoices, three ways to summarize payment time

The sample contains three fully cash-paid USD invoices issued September 1, using original invoice totals on the same amount basis. It has no credits, write-offs or refunds. Read the dates and amounts below into the calculator to reproduce the results.

Calendar days from issue to confirmed full payment. Amount × days supplies the weighted numerator.
InvoiceIssuedFully paidAmount (USD)DaysAmount × days
INV-4412026-09-012026-09-111,0001010,000
INV-4422026-09-012026-09-211,0002020,000
INV-4432026-09-012026-10-013,0003090,000
Arithmetic mean · equal invoice weights
(10 + 20 + 30) ÷ 3 = 20.00 days
Median · middle sorted duration
10, 20, 30 → 20 days
Amount-weighted mean
(10,000 + 20,000 + 90,000) ÷ 5,000 = 24.00 days

The USD 3,000 invoice supplies 60% of the amount weight, so its 30-day duration pulls the weighted mean above the equal-weight mean. No measure is automatically the right target. Preserve the sample definition and keep full precision until the final display; the calculator displays means to two decimals.

Download calculation record (.txt)

Free editable text with this worked example, formulas and blank calculation fields. No signup. Save your custom inputs with Copy result or Download result in the calculator above.

A first installment is not full payment

INV-443 totals USD 3,000. A confirmed USD 1,000 receipt on September 11 leaves USD 2,000 outstanding. A confirmed USD 2,000 receipt on October 1 clears it. Its completed payment cycle is 30 days, using October 1. Using the first receipt would incorrectly report 10 days for this full-payment measure.

A credit or write-off can close an amount without receiving that money. Label and investigate those cases separately instead of silently mixing them into a fully cash-paid sample.

Keep the unpaid fourth invoice visible

Suppose INV-444 was also issued September 1 for USD 2,000, with an agreed October 1 due date, and remains unpaid at an October 5 snapshot. It has no full-payment date, so it stays outside this calculator. Entering zero would invent a same-day payment and lower the mean.

Retain it in an open-invoice aging review. The three paid invoices can look faster while unresolved work remains outside the sample. This summary cannot represent the whole portfolio or prove why a payment took longer.

Calculation notes

How the result is calculated

Elapsed days = full-payment date − issue date, using UTC calendar dates; same-day payment is zero. Mean gives all three invoices equal weight; median is the middle sorted duration. Amount-weighted mean = sum(duration × invoice amount) ÷ total amounts. It describes this paid sample only, excludes unpaid invoices, and is not a DSO or overdue-day calculation.

Formulas and examples reviewed November 13, 2026. Illustrative figures; no tax or contractual determination.

One larger invoice changes the weighted measure

Durations of 10, 20 and 30 days give a 20-day mean and median. Amounts USD 1,000, 1,000 and 3,000 give a 24-day amount-weighted mean. This is a fictional selected sample, not a benchmark.

The same issue and payment date

Three invoices paid on their issue dates have zero elapsed days. That does not imply every outstanding invoice is paid promptly; those invoices are outside this sample.

Questions about this calculation

Is this days sales outstanding?

No. A portfolio DSO measure uses receivables and sales over a defined period. This tool uses three completed invoice cycles, so it cannot represent the unpaid portfolio.

Should the first installment be the paid date?

No. Use the date full payment is confirmed for this measurement. If credits, write-offs or refunds affected closure, review and label that case separately rather than treating it as an ordinary fully cash-paid invoice.

How to use it

1

Enter three issue dates and evidence-backed full-payment dates.

2

Enter each invoice's positive amount on the same currency and amount basis.

3

Compare the sample measures and retain its inclusion criteria.

Related workflows

Move from the quick answer into the rest of the invoice system.