# 3PL Invoice Audit Trail: What to Keep and Log

What records should I keep from each 3PL invoice audit so that my finance team, or an outside auditor, can trace every charge, dispute and credit?

A 3PL invoice audit trail is a file, kept by billing period, that lets anyone retrace your checks: the dated [rate card](/guides/glossary/rate-card) version used, each invoice and detail file as received, your own order, receipt and inventory records as pulled, and a log of every variance, over or under, with its evidence, decision, dispute and [credit](/guides/glossary/credit-memo).

## Why finance needs more than "we checked it"

Without a record from the invoice review, finance can only book what the invoice says. Once the person who checked it is away or has left, nobody can show why a line was disputed, which project was approved or whether a promised credit arrived. Credits and corrections can also land on a later invoice than the work they relate to, so the link has to be written down.

Billing errors can come from process rather than bad faith, and the same file gives your 3PL the evidence behind each question you raise.

## What an audit trail is, and what it isn't

In software, an audit trail is an event log ("a chronological record of system activities" in NIST's glossary[1]); in an accounts payable (AP) system it shows who entered, changed, approved or paid a record, and when. This article means the evidence file behind your own review of the 3PL's bill, which feeds your AP system's record.

Your invoice audit is your own check of a vendor's bill, not a financial-statement audit. An outside auditor reviewing your financial statements may ask how you check and approve vendor bills, including your 3PL's. Controls such as segregation of duties are covered in Internal controls over 3PL billing and inventory.

A useful test comes from the standard for public-company auditors, which doesn't govern brands: an experienced auditor "having no previous connection with the engagement" should be able to understand the work, its evidence and conclusions, and who did it and when (PCAOB AS 1215, paragraph.06)[2]. For a 3PL file, that means complete, traceable line by line and dated by whoever checked, with originals unedited.

## What to keep for each billing period

Keep the three record sets that [How to audit a 3PL invoice, step by step](/guides/what-is-a-3pl-invoice-audit) works from (what you agreed, what you were billed and what happened), plus approvals, the 3PL's written answers and your log.

| Record | Why finance or an auditor needs it | Where it comes from, and a tip |
| --- | --- | --- |
| Contract, statement of work (SOW), every dated rate card version, amendments and rate-change notices | Shows which rate applied. A new rate usually applies to work done on or after its effective date (for storage, the period or count date that starts after it; for monthly fees, the next month); check your contract's rule | Keep superseded versions, and the signed amendment or, where the contract allows changes on notice, the notice |
| Every invoice, credit note and corrected or reissued invoice, plus each detail file as received | Shows the period is complete. The PDF and detail file can disagree, and neither wins by default | The 3PL's billing contact or portal. Record the invoice date and the date you received each file |
| Your own records as pulled: order and returns exports, purchase orders (POs), inbound [ASN](/guides/glossary/asn-advance-shipping-notice)s (the notices sent before a shipment arrives) and receipts, inventory records for your storage count, product weights and dimensions | The independent side of each check | Match them to how your contract counts storage: a snapshot on a set day; daily on-hand for a daily average, peak or proration; receipt dates for receipt plus each period after. Add carrier invoices if you ship on your own carrier account, and freight (LTL/FTL) invoices for B2B |
| Approvals and work orders for [special projects](/guides/glossary/special-projects), hourly labor and one-off work | Shows a non-routine line was authorized | In the form the contract's approval rule names. If it names none, the 3PL may bill on request, so ask for a written-approval rule |
| The 3PL's written answers (count day, rate version loaded) | Settles questions the contract leaves open | Save the email to the period folder |

A 3PL report that agrees with the 3PL's invoice proves the arithmetic, not the charge, so the file needs your own record beside it; where you have none, log the check as a tie-out (two of the 3PL's own records agreeing). For which detail files to request, see [The supporting detail files you should always request](/guides/3pl-invoice-backup-supporting-detail-files).

Portal views and exports can change after you check them: orders get edited or cancelled, inventory gets adjusted after counts, and some 3PLs regenerate or stop showing older detail files. Save each file you checked under a name with the period and the date you pulled it, and point evidence at that file and row, not at a live portal view or an inbox search. A saved file can be tested later; auditors likewise test the accuracy and completeness of system-produced reports, or the controls over them (PCAOB AS 1105, paragraph.10)[2].

## The variance log: one row per finding

The variance log has one row for each line where the billed amount differs from what you expected, in either direction:

Variance = billed amount − expected amount (positive is an overcharge, negative an undercharge)

Each row records:

- Invoice number and date, and the line.
- Billed quantity, rate and amount.
- Expected quantity, rate and amount, and where each came from.
- The counting basis the expected quantity assumes: per order or per package; per unit, line or SKU; units or occupied locations; a count day or a daily average; per each or per carton, with any per-SKU minimum.
- The variance and its direction.
- Evidence: the saved file name and row.
- Status: overcharge, undercharge, legitimate item outside your order data, or question.
- Who checked it and the date, the decision and the next action.

We see undercharges as well as overcharges in the invoices we review, so log both with the same evidence (the FAQ covers why). For variances that aren't errors, see Not every variance is an overcharge: undercharges, manual items and special projects.

## Decisions, disputes and credits: closing each line

Record a decision for each logged line, with who approved it: pay as billed, accept as legitimate, dispute or hold as a question. A disputed or open line closes only on a credit, a corrected invoice or an explanation you accept, not on a promise. For a dispute, record the date sent, the date the window closes, the 3PL's acknowledgment and answer, and the outcome. A 30-day dispute window is common; 14 days is short. The window usually starts when the invoice carrying the charge lands, not when the work happened; check what your contract says.

For a credit, record its form, number, amount and where it landed, such as the invoice that carries it. A credit can arrive as a negative line on a later invoice, a separate credit note, or a credit to your account balance[3], or as a refund. A credit on fees that count toward your [monthly minimum](/guides/glossary/monthly-minimum), landing in a month you're under it, is worth nothing if it's applied before the shortfall is calculated. Unless your contract sets the order, ask for it to be applied after, and record which order was used. Record the fix you asked for (a rate-table update for a wrong rate, or a billing-rule fix for a scope, quantity, category or mapping error). For a recurring charge, keep the line open until the next invoice of the same type bills it correctly. For a one-off charge, such as a duplicate line or a single project, close on the credit and watch the next invoice for the same kind of error.

Record what you paid and when. If your 3PL charges a card, drafts your bank account or draws on a prepaid balance when it invoices, there's nothing to withhold, so the dispute record carries the whole claim. See [Tracking disputes and credits to closure](/guides/track-3pl-disputes-and-credits) for the tracker and [Short-paying vs. paying in full and disputing](/guides/short-pay-disputed-3pl-invoice) for whether to withhold.

## What to hand finance each period

Send finance a one-page summary each period and keep the variance log behind it, so anyone can open a line and see its evidence. The summary lists:

- Invoices received, by number, date and total.
- The amount checked and approved.
- The amount disputed, and the amount under question.
- Credits expected and credits received, each with where it landed. Include every expected credit, whatever its source (billing dispute, service-level (SLA) credit, damage or loss claim, carrier refund), labeled by kind.
- Undercharges logged that may be billed later.
- Charges or credits on this period's invoices that relate to a different activity period.

Finance decides how to accrue and book each of these; see Booking 3PL credits and disputed amounts and Accruing 3PL costs when invoices arrive late. Approval routing and limits belong in your approval workflow, not this file.

## How to organize the file and how long to keep it

Name one owner for the file and a backup. Keep one folder per billing period, with each invoice's files under its number. Keep originals read-only and work in copies; date anything added later and note who added it and why, as AS 1215 requires of auditors[2].

As of October 2026, the IRS says to keep records supporting a US federal income tax return until its period of limitations runs out, counted from when the return was filed: generally 3 years; 6 years if you leave out income over 25% of the gross income shown; 7 years for a worthless-securities or bad-debt claim[5]. Employment tax records are kept at least 4 years after the tax is due or paid, whichever is later[5]. Insurers or creditors may require longer[5]. Keep each period's file at least through your contract term plus any look-back or audit-rights period, and longer if your accountant says your tax records need it. Ask your accountant for your retention policy, and see Your data rights and keeping your own history for saving 3PL data before your access ends.

## Worked example: one month's audit trail (illustrative)

The illustrative month from the step-by-step audit (rates are not benchmarks) has a $7,791 warehouse invoice with $509 in overcharges, $225 in project hours under question and a $24 receiving undercharge. Three of its log rows:

| Line | Billed | Expected (basis; source) | Variance | Status; evidence |
| --- | --- | --- | --- | --- |
| Inserts | 4,000 × $0.15 = $600.00 | 2,000 × $0.15 = $300.00 (per insert, one per shipped order; order export as pulled) | +$300.00 | Overcharge; export rows and the rate card's insert line |
| Special projects | 6 hrs × $45 = $270.00 | 1 hr × $45 = $45.00 (per hour; approval file) | +$225.00 | Question; approval on file for 1 of 6 hours |
| Receiving | 6 × $12 = $72.00 | 8 × $12 = $96.00 (per pallet; your receipt records) | −$24.00 | Undercharge; receipt records show 8 pallets |

The month-1 summary to finance reads: billed $7,791.00; checked and approved $7,057.00; disputed $509.00, a credit expected; under question $225.00; undercharge logged $24.00, which may be billed later.

In month 2 of this illustration, in which fees are above any monthly minimum, the 3PL issues a $509.00 credit that references the month-1 invoice. It produces a signed approval for 2 of the 5 open hours, so 3 hours are credited: 3 × $45 = $135.00. It also bills the 2 missing receiving pallets: 2 × $12 = $24.00. These are illustrative outcomes, not a claim about how disputes resolve.

Net cost of month-1 activity = $7,791.00 − $509.00 − $135.00 + $24.00 = $7,171.00

That ties to the original expected amount plus the newly approved hours: $7,081.00 + (2 × $45) = $7,171.00. The $644.00 in credits and the $24.00 charge sit on the month-2 invoice but relate to month-1 activity, so the log records the link for finance; see Matching 3PL invoices to periods and activity.

## What a reliable audit trail looks like

A reliable file lets someone who didn't do the audit check it without asking you:

- They can recompute any line from the saved files.
- Every rate traces to a dated rate card version, amendment or notice.
- Every variance has saved evidence, a direction and a status.
- Every credit traces from its dispute or claim to where it landed.
- The period summary ties to the invoices finance paid.
- An error that was fixed and then came back shows up in the log.

## Common mistakes and red flags

These mistakes break the trail:

- **Keeping only the summary PDF** and not the detail file.
- **Overwriting the rate card** when it changes.
- **Pointing evidence at a live portal view** or an inbox search.
- **Logging only overcharges.**
- **Closing a dispute on a promise** rather than on the credit itself.
- **Keeping the checks in one person's head** or personal folder.
- **Finance and ops keeping different lists of credits.**

These deserve a question:

- **A credit with no reference to the invoice or line it corrects.** In the invoices we review, some credits arrive as a single amount that doesn't say which invoice or orders it covers. It may be a bundled goodwill or SLA credit, an account-balance credit, or from an invoicing system that doesn't print references, so ask what it covers. Some countries require printed credit notes to reference the original invoice[6].
- **A corrected invoice that doesn't say what it replaces.** It can be a reissue, a split or a billing-system change; treat it as a question, not a duplicate or an addition.
- **Detail files that stop arriving.** A portal change or a new billing contact can cause it; ask for the files, since the dispute window usually still runs from the invoice.

## Questions to ask your 3PL

Copy these into an email to your 3PL.

1. Will you send detail files with every invoice, how long do they stay in your portal, and will you export past periods on request?
2. Which rate card version is loaded in your billing system for us, and from what effective date?
3. Will each credit name the invoice and line it corrects?
4. Will a corrected or reissued invoice name the invoice it replaces?
5. Will you acknowledge disputes in writing, and who is our billing contact?
6. Does our contract give us a right to audit your billing records? The IWLA standard terms (rev. January 2026) give the customer no general one[4].

## Checklist: the monthly audit file

- Contract and every current and superseded rate card version on file
- Every invoice, credit note and detail file saved as received, with the date received
- Your own exports saved as pulled, named with the pull date
- Approvals and work orders filed for non-routine lines
- Variance log complete in both directions, with evidence on every row
- Disputes logged with the date sent and the date the window closes
- Credits matched to the invoice or account where they landed
- Period summary sent to finance, with the variance log behind it
- Owner and backup named
- Retention period confirmed with your accountant

## FAQ

### How long should I keep 3PL invoices and audit records?

For US federal income tax, the IRS's general period is 3 years from filing, with longer periods in specific cases[5]; its seven-year period applies only to worthless-securities or bad-debt claims. Seven years is also how long a public-company auditor must keep its own audit documentation[2]. Keep each period's file at least through your contract term plus any look-back or audit-rights period. Ask your accountant.

### Should I log undercharges?

Yes, with the same evidence as overcharges. Don't count them as savings: a 3PL can bill missed work on a later invoice, and the dispute window then runs from the invoice that bills it.

### Do I need software, or will a spreadsheet do?

A spreadsheet works; for tax records the IRS accepts "any recordkeeping system suited to your business that clearly shows your income and expenses"[7]. Use tabs for rate card versions, invoice lines, expected quantities, the log and the summary. When it stops being practical depends on volume and the number of invoices and 3PLs; see Tools of the trade: spreadsheets, BI, portals and audit tools.

### Who should own the audit trail, ops or finance?

Give the file one named owner, usually whoever runs the check, with a backup, and have finance receive the summary. See Finance and the 3PL: invoice approval, accruals and budgets.
