Free tool · beta · no account needed
3PL Invoice Audit
Check the invoice from your third-party logistics provider against what you agreed and what actually happened. The audit reads the provider's own invoice export, your rate card and your operational records — in their own layouts — runs only the checks that this evidence supports, and shows every flagged line with the evidence behind it.
What you can check, with which files
| Files | Checks |
|---|---|
| The invoice export only (required) | Quantity × rate against each line amount; possible duplicate lines; lines adding up to the stated invoice total, with credits, tax and rounding; missing or malformed values and mixed currencies. |
| + your rate card (optional) | Billed rates against the contract rate effective on the service date, in the same unit and currency, with minimums and volume tiers; charges that are not in the rate card; charges that need contract interpretation. |
| + an operational export (optional) | Invoice references found in your order, shipment, receipt or return records; billed quantities against your quantities when the units agree. |
How it works
| Step | What happens |
|---|---|
| 1. Invoice | Choose the detailed invoice (.xlsx or .csv). Columns are recognised by meaning — Svc Code, Shipment #, Billable Units, Ext. Amount — and you confirm them. Two columns that could mean the same thing are asked about, not guessed. |
| 2–3. Rate card and records | Optional. Add them to widen the checks, or continue without them. |
| 4. Checks and questions | Which checks can run with your files and why others cannot; only the questions the files cannot answer (currency, date order, how tiers apply). |
| 5. Findings and report | A review queue with filters, every line with its outcome, invoice totals, coverage, a draft query to edit, and the Excel evidence report. |
What a finding means
- Verified calculation mismatch: the invoice contradicts itself (quantity × rate, or the stated total).
- Contract-rate difference, quantity mismatch, possible duplicate, unsupported reference: a potential difference to review with the provider, with the evidence used.
- Unknown fee code, missing data, needs more evidence: the files are not enough to decide.
- No discrepancy detected by the checks performed: the checks that could run found nothing. It is not proof that the line is correct.
Differences are reasons to review, not proof of overbilling and not guaranteed savings. The tool never contacts your provider: the draft query is text for you to check and send yourself.
What you get
- Excel report: Dashboard, Summary with audit coverage, Findings (billed, expected, difference, evidence, next action, review status), Reconciliation of the stated totals, every invoice line with its outcome, the rate card and records as read, Method, Data quality and a Draft query.
- Your original files are read in your browser and never changed or uploaded.
Beta limits
- Reads Excel (.xlsx) and CSV exports. PDF and scanned invoices, provider APIs and automatic monthly imports are not supported yet.
- Contract terms that are not in your rate card are not known to the tool; quantities in different units and amounts in different currencies are never converted.
- Tested on synthetic data; reports checked in LibreOffice, not yet in Microsoft Excel.
Free to use, no account needed
Open the tool and try it with invented sample files first. Your files are read in your browser and are not uploaded. The tool is in beta and has been checked on synthetic data: compare its results with what you know. Privacy