Freight invoice audit
Calculates the expected cost of each shipment from the contracted rate card and separates approved charges from disputed charges
How it works
-
Upload a completed audit
The shipment-level comparison and the approved and disputed charges returned to the carrier
-
Add the audit inputs
The carrier invoice, the shipment manifest for the same period, the contracted rate card, and the accessorial mapping
-
Skipper learns the audit rules
How billable weight maps to a weight band, how carrier, service, and zone select a rate, which accessorials the contract permits, and the tolerance below which a variance is accepted
-
Upload the new carrier invoice
Skipper recalculates every shipment, separates overcharges from undercharges, and shows the expected amount for each disputed line
Input files
- carrier_invoice_202X-07.xlsx Billed base charge, accessorial code, and total for each shipment
- shipment_manifest_202X-07.xlsx Shipments as tendered, with carrier, service, origin, destination, zone, and weight
- contracted_rate_card.xlsx Negotiated base rates by carrier, service, zone, and weight band
- accessorial_mapping.xlsx Contract rate for each accessorial code the carrier may bill
Output workbook
freight_audit_202X-07.xlsx
- Summary Billed and expected amounts, total overcharges, and the amount in dispute
- Freight Audit Weight band, expected base and accessorial charges, billed amounts, and variance by shipment
- Approved Charges The amount payable on each invoice line, with the disputed amount separated
- Checks Reconciliation of approved and disputed amounts to the carrier invoice total