Automated LTL Accessorial Charge Audit
Every morning, WebRun pulls newly received LTL freight invoices from QuickBooks, cross-references each accessorial charge line against the carrier tariff and accessorial schedule in SMC3, flags any charge that exceeds the published rate or was not applicable to the shipment, and logs a dispute worklist to Google Sheets for your billing team to review.
How do I automatically audit LTL accessorial charges against carrier tariffs to catch overbilling?
WebRun pulls new LTL freight invoices from QuickBooks every morning, compares every accessorial charge line against the carrier tariff and accessorial schedule in SMC3 BatchMark, and logs a ranked dispute worklist to Google Sheets so your billing team knows exactly which charges to contest, with the tariff evidence already surfaced for each one.
- Billing errors are caught before payment on every invoice processed
- Dispute worklist is ranked by overbill amount so high-value recoveries are addressed first
- Tariff evidence from SMC3 is surfaced alongside each flag so disputes are defensible
Built for LTL shippers · billing teams · 3PLs · freight auditors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
quickbooks.intuit.comin a real browser with your saved login - no setup, no API keys. -
1
QuickBooks - pull newly received LTL freight invoices
- Open QuickBooks and pull LTL freight invoices received since the last run
- Extract the line-level charges including base rate, fuel surcharge, and accessorial charges
- Capture the carrier, PRO number, origin, destination, and freight class for each invoice
Done when Every new freight invoice is captured with its full charge breakdown.
-
2
SMC3 - cross-reference accessorial charges against carrier tariffs
smc3.com
WebRun opens SMC3 to cross-reference accessorial charges against carrier tariffs. - Look up the applicable carrier tariff for each invoice in SMC3 BatchMark
- Compare each accessorial charge on the invoice against the published tariff rate for that carrier
- Flag any charge that exceeds the tariff, applies to an ineligible shipment type, or is duplicated
Done when Every flagged accessorial discrepancy is identified with the correct tariff amount and the overbilled amount.
-
3
Google Sheets - log dispute worklist for billing team review
google.com
WebRun opens Google Sheets to log dispute worklist for billing team review. - Open the accessorial dispute worklist in Google Sheets
- Append each flagged charge with invoice number, carrier, charge type, billed amount, tariff amount, and overbill delta
- Sort the worklist by overbill amount so the highest-value disputes are addressed first
Done when The dispute worklist is updated and sorted, ready for the billing team's morning review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it submit disputes to carriers automatically?
No. WebRun builds the dispute worklist and surfaces the tariff evidence. Your billing team reviews each flagged charge and decides whether to dispute before any carrier contact is made.
Which accessorial charges does it audit?
It audits any charge that appears on the invoice line, including fuel surcharges, liftgate, inside delivery, residential delivery, reweigh, reclass, and limited access fees, comparing each against the carrier tariff in SMC3.
What if a charge is legitimately higher than the standard tariff?
Any charge covered by a negotiated contract rate rather than the published tariff can be excluded from the audit by adding the contract terms to the configuration. WebRun only flags charges with no tariff or contract basis.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.