How do you audit freight and 3PL spend in Acumatica?

Executive Summary

Acumatica gives an AP team a clean, searchable record of every freight and 3PL invoice: vendor, amount, GL code, PO reference. It does not tell them whether that amount is correct against the carrier contract. The system matches invoice to purchase order and receipt.

It does not match invoice to rate card, fuel surcharge schedule, or accessorial tariff, because none of those documents exist inside Acumatica as structured data.

The mechanism behind freight drift is straightforward. Contract terms sit in PDFs and carrier portals. Invoices sit in Acumatica.

Nothing connects the two automatically. A fuel surcharge percentage that should reset when diesel prices move keeps running at a stale value. An accessorial charge appears for a service the contract never authorized.

Both pass three-way matching because the PO and receipt line up. Neither gets checked against the contract, because Acumatica has no field for the contract.

What changes it is building the missing layer, either as a retrospective audit that pulls AP history out of Acumatica and tests it against the actual carrier agreements, or as a forward control that checks each freight invoice before it posts. Both start with the same export and the same rate card. The choice is about when the check happens, not whether one exists.

1. What data do you need to pull out of Acumatica first?

Start with the AP Bills and Adjustments inquiry filtered to freight and 3PL vendors, exported with vendor ID, invoice date, invoice amount, PO reference, and GL sub-account. Pull the linked purchase order and receipt lines for each bill. Also export the carrier remittance detail if Acumatica stores accessorial line items separately rather than as a single freight total, since that line-level detail is what a rate card actually tests against.

A single freight total per invoice is not enough to audit. If Acumatica has posted the bill as one lump sum, the accessorial charges, fuel surcharge, and base rate are already merged before anyone can test them separately. Check whether your AP clerks are keying freight bills as a single line or breaking them out at entry.

If they are single-lined, the carrier's own invoice PDF or EDI feed becomes the real source document, not the Acumatica bill. Pull both. The GL entry tells you what was paid and when. The carrier's line-level detail tells you what was actually charged for.

Export at least 12 months of history. A shorter window misses the surcharge resets and contract renewal dates that explain most of what looks like drift but is actually a stale reference table.

2. How do you match a freight invoice to the actual carrier contract?

Line up each invoice's lane, weight break, and accessorial code against the carrier's current rate card and fuel surcharge table, not against last year's version or the number the AP clerk remembers. Build a reference table outside Acumatica with the contracted rate per lane, the surcharge index and reset frequency, and the approved accessorial list, then run every invoice line against it before or after payment.

The rate card is the control document. Acumatica has no place to store it, so it has to live somewhere else: a spreadsheet, a rules engine, or a third-party matching tool, kept current every time the carrier contract renews.

Fuel surcharge is the line most likely to drift because it is meant to move. The US Bureau of Labor Statistics Producer Price Index for gasoline (series WPU0571) showed an index value of 319.584 in August 2026, up 46.5% year over year, read September 25, 2026. A surcharge tied to a diesel or fuel index should track a move like that.

If the invoiced surcharge percentage has not changed while the underlying index has, the carrier is charging an old rate.

Accessorial charges are the second line to check: liftgate, residential delivery, redelivery, detention. Each should appear only where the contract allows it, at the rate the contract states.

3. Which freight rate benchmarks should you check against?

There is no ValueXPA-published benchmark for what a given lane or accessorial should cost, so use published index data to sanity-check the direction of a rate, not its exact dollar value. The relevant series are the BLS Producer Price Index for truck transportation of freight and for general freight trucking, both of which show the scale of rate movement a carrier contract should account for.

These figures are from the US Bureau of Labor Statistics, read September 25, 2026. They describe market-wide movement, not what any single carrier should charge your company. A rate that moved far outside this range is worth a question to the carrier. A rate that moved in line with it may simply reflect the market, even if the dollar amount feels high.

Use the index as a first filter, not a verdict. The contract itself, not the index, sets the number that determines whether an invoice is correct. The index tells you whether a change is plausible before you go looking for the clause that should explain it.

Published freight cost index movement, for checking whether a contract rate change tracks the market or drifted on its own.

4. What are the most common freight drift types in a mid-market ERP?

Four mechanisms recur across ERPs that were not built to store carrier contracts: a fuel surcharge that fails to reset when the index moves, an accessorial charge applied outside the approved list, a minimum charge clause billed when actual weight already cleared the minimum, and a rebate or volume tier that was earned but never credited back to the account.

None of these are unique to Acumatica. They recur because the contract clause that would prevent each one lives outside every ERP's data model, not because of anything specific to this system.

Each mechanism is worth checking on its own terms rather than ranking them against each other. A company's own contract mix, not a general pattern, determines which of these shows up in its freight spend and how large it is.

• Stale fuel surcharge: The surcharge percentage stops tracking its stated index and keeps running at whatever value was last manually updated in the carrier's billing system.
• Unauthorized accessorial: A liftgate, redelivery, or residential fee appears on an invoice for a shipment the contract does not classify as eligible for that charge.
• Minimum charge misapplication: The invoice bills the contract minimum even where the shipment's actual weight or distance already exceeded it, so the minimum should not have applied.
• Unclaimed volume rebate: A rebate tied to a quarterly or annual volume tier goes uncredited because nothing in the AP workflow tracks cumulative volume against the tier threshold.

5. Should you build this audit in-house or bring in outside review?

An in-house build needs someone who can read the carrier contracts closely enough to construct a working rate card, and the time to test 12 to 18 months of invoice history line by line. Where that capacity exists, build it. Where it does not, an outside diagnostic performs the same matching in a fixed 2 to 4 week engagement and hands back a prioritized list of what to fix and what to reclaim.

The work is the same either way: extract the AP history, build the rate card, run the match, document the exceptions. What differs is who has the time and the contract-reading skill to do it without pulling an AP lead off their regular close cycle.

An outside diagnostic exists for exactly this gap. It combines the AP recovery review, the contract compliance check, and the indirect spend audit in one fixed-scope engagement, across ValueXPA diagnostics, with the client retaining 100% of what gets recovered rather than paying a share of it to the firm that found it.

See build-vs-buy-can-you-do-contract-to-invoice-matching-in for the fuller case on the in-house option, and diagnostic-or-software-what-to-buy-first for the sequencing question once you decide the audit needs a permanent home.

6. How do you stop the same freight drift from recurring after the audit?

A one-time audit recovers what already leaked but does nothing about the next invoice cycle unless the rate card, surcharge index, and accessorial list get checked into a forward control that runs before or immediately after each bill posts. Acumatica can hold the GL and vendor record indefinitely; it cannot hold the contract logic, so that logic has to live in a system built to test every invoice against it going forward.

Two things keep drift from returning. First, the rate card has to update every time a carrier contract renews, not once at audit time and then never again. A rate card that goes stale for a year reproduces exactly the problem the audit fixed.

Second, someone or something has to check every invoice, not a sample. A quarterly spot-check catches large errors and misses the small recurring ones that add up over a year, because a $40 accessorial error repeated across 200 invoices a month is invisible to a sampling approach and material in aggregate.

For companies running QuickBooks Enterprise or NetSuite instead of Acumatica, the same freight and 3PL control gap exists; see freight-and-3pl-controls-in-quickbooks-enterprise and freight-and-3pl-controls-in-netsuite for how it plays out in those systems.

For the wider pattern this sits inside, start with the margin drift guide.

7. Frequently Asked Questions (People Also Ask)

Does Acumatica do three-way matching on freight invoices?

Yes, for purchase order, receipt, and invoice. That confirms the goods or service were ordered and received. It does not confirm the price charged matches the carrier's contracted rate, because the contract itself is not data Acumatica holds.

Can Acumatica store a carrier's fuel surcharge schedule?

Not as structured, enforceable data. A surcharge table can be pasted into a note or attached as a PDF, but nothing in Acumatica tests an incoming invoice's surcharge line against it automatically.

What counts as an accessorial charge in freight billing?

A fee added on top of the base freight rate for a specific service: liftgate delivery, residential delivery, redelivery after a failed attempt, detention time, or inside delivery. Each should be listed in the carrier contract with its own rate and eligibility condition.

How far back should a freight audit look in Acumatica?

At least 12 to 18 months, across ValueXPA diagnostics, since that window is long enough to catch a surcharge that went stale after a contract renewal or an index reset that never made it into the carrier's billing.

Is a freight audit the same as an AP automation tool?

No. AP automation checks that a bill matches its PO and stays within approval rules going forward. It does not interpret a carrier contract's rate card or surcharge clause, since that logic sits in a PDF outside the ERP the automation tool was configured against.

What does a minimum charge clause actually protect against?

It sets a floor invoice amount so a carrier is paid for handling a shipment even when the billed weight or distance falls below a threshold. Drift occurs when the minimum is applied to a shipment that already exceeded it.

Do NetSuite and QuickBooks have the same freight audit gap as Acumatica?

Yes. None of the mid-market ERPs store a carrier's rate card, surcharge index, or accessorial list as enforceable data, so the same audit approach applies regardless of which system posts the AP entry.

Can you recover money from freight overbilling that already happened?

Often, yes, through credit memos, rebills, or rebate claims the carrier owes once the discrepancy is documented against the contract. The client retains 100% of whatever is recovered in a ValueXPA engagement, rather than sharing it with a contingency-fee recovery firm.

How is a freight audit different from a general AP recovery audit?

A general AP recovery audit looks for duplicate payments and overbilling across all vendor categories. A freight-specific audit adds the rate card, surcharge index, and accessorial matching that freight and 3PL invoices need and that a generic duplicate-payment scan will not catch.

What is the first step if we want to run this audit ourselves?

Export 12 months of freight AP history from Acumatica with vendor, invoice amount, PO reference, and GL code, then request the current rate card and fuel surcharge schedule from each carrier so you have something to test the invoices against.