Free tool
Broker days-to-pay calculator
Who pays you slowly? Paste one line per invoice with a label, the invoice date and the payment date. The tool works out days to pay for each label, in your browser, from your own data.
Result
Runs in your browser. Nothing you type is sent anywhere. Example numbers are invented (EXAMPLE VALUES). This is a calculator, not financial, tax or legal advice.
The formulas
days to pay = payment date - invoice date average = sum of days / paid invoices median = middle value (mean of the two middle values if even) 90th percentile = value at rank ceil(0.9 x n) of the sorted days over 30 days = paid invoices with days to pay above 30
Unpaid invoices are counted on their own and never averaged in, so a broker that has not paid at all cannot make itself look fast. The label is whatever you type, so use the name you know the customer by. Nothing is stored.
How to use the result
- Compare the 90th percentile, not just the average. Averages hide the bad invoices.
- Check whether late payers are late on every invoice or only on ones with a dispute or missing paperwork.
- Check the unpaid column. An invoice older than the slowest paid one deserves a call.
- With fewer than five paid invoices per label, treat the numbers as a first look, not a pattern.
For the next step, see the invoice aging tool and the invoice aging guide.
Worked example EXAMPLE VALUES
A friction index on invented brokers
This is how an audit report could weigh more than pay speed. Brokers A to H and every figure are invented. Sort and filter the table, switch columns on and off, change the weights, move the diesel scenario and open a broker to see what drives its index. It describes only the carrier's own data, not any real broker, and it is not a rating.
Loading the example table...
Broker detail
Choose a broker in the table. The detail follows your weights and the diesel scenario.
Loading...
What this example is not. It is not a broker rating, not a live freight-rate tool and not a prediction of delays. Scenario outputs show arithmetic on invented numbers. Diesel uses the latest EIA weekly regional average from a dated snapshot.
Questions
Why no named brokers?
We do not rate or name brokers. This site uses Broker A, B and C in examples. In your own report, brokers appear under the names in your own file.
Is my data uploaded?
No. The tool runs in your browser. Close the tab and it is gone.
Can I get this across 20 loads without typing?
Yes, that is part of the free audit: payment speed by broker from your file.
Formula table
| Quantity | Formula | Note |
|---|---|---|
| Days to pay | payment date - invoice date | Per paid invoice. |
| Average | sum of days / paid invoices | Paid invoices only. |
| Median | middle value | Less swayed by one outlier. |
| 90th percentile | nearest rank | How slow the slow ones are. |
What this means for you
The average hides the slow tail, so look at the 90th percentile and the unpaid count too. A broker that pays most invoices fast but leaves some for 60 days is a cash-planning problem the average will not show.
Related tools
See what your last 20 loads show.
One short form. We reply by email with the next step, and a one-page report follows. Free, no obligation.
Mon-Fri, 9:00 a.m.-5:00 p.m. Eastern Time (Raleigh, NC). Voicemail is answered the next business day.