Parcel Audit / Reconciliation
From audit finding to realized carrier credit
A controlled status path for finance and operations—from the first signal through review to a carrier credit that has actually been issued.
Written by
Elias Aral
Founder, MarginMine
Core thesis
Audit opportunity is not a financial outcome. Only an evidenced carrier credit closes the control loop and can be treated as realized.
Status chain / CR-0426
Potential and outcome stay separate.
Audit signal
€6,200
Reviewed
€4,800
Submitted
€4,800
Credited
€4,800
1. Keep four amounts deliberately separate
An audit works with at least four different amounts: invoice population, machine-identified opportunity, reviewed and submission-ready value, and credits actually issued. These values must not merge in language or dashboards.
Opportunity is a work queue. It may include duplicates, already corrected lines, missing events or cases below an agreed threshold. Expert review determines which value can be submitted with complete evidence.
- Invoice population
- potential variance
- submission-ready finding
- realized credit
2. Every status needs an entry condition
A case does not become confirmed because somebody clicks a button. Each transition needs a definition: sources complete, rate version unambiguous, recalculation reproducible and previous credits checked.
Submission additionally requires a complete evidence pack and accountable approval. The carrier response becomes its own event: accepted, partially accepted, rejected, question raised or undecided. That keeps the exact status of each amount visible.
- Timestamp
- responsible actor or rule
- linked evidence
- rejection reason
3. Reconcile credit notes at line level
A credit note may combine claims, contain only a partial amount or appear as an offset on a later invoice. Reconciliation should therefore not rely on total amount alone. It needs credit reference, issue date, currency, affected case IDs and amount.
Partial acceptance remains a separate outcome. The submitted amount is not overwritten; the case receives a realized amount and any outstanding remainder. This protects reporting from retrospective inflation.
NoteA carrier email agreeing with a claim is not a realized credit until financially effective evidence exists.
4. Outcome-linked fees need an auditable basis
If compensation depends on realized credits, the agreement must define acceptable evidence, partial credits, tax, currency conversion and claims already in progress.
Every fee line should link directly to its credit note and underlying audit findings. Customer, service provider and accounting can then reproduce the same value without interpreting theoretical savings.
- Measurement date
- original currency
- known-case exclusions
- partial-credit treatment
5. Report what did not realize
A defensible close-out report explains how many cases were discarded, open, rejected, partially accepted or credited. Reasons and processing time matter as much as the largest number.
Recurring rejection reasons improve the next run. They may expose a missing source, a mis-modeled rate rule or an unsuitable threshold. Reconciliation is therefore feedback for the data model and control logic.
- Signal-to-finding conversion
- realization ratio
- time by carrier
- rejection reasons
Sources & further reading
Primary sources instead of invented authority.
Carrier material changes. A real audit must always use the specific agreement and documents effective on the service date.
