Ettix guides · Freight billing

How to audit freight short payments

Match your freight invoices against broker remittance rows and identify the amounts that need a second look.

Audit 10 invoices free

Download the sample files

• Sample freight invoices CSV
• Sample broker remittances CSV
• Excel worksheet and worked example

Use invoice numbers to match rows

Start with an invoice number and add the load number where available. A load number can identify a payment when the invoice number is missing. Review rows with conflicting IDs or several possible invoices separately.

Add up payments and document deductions

Group separate payments for the same invoice. Check the source before counting a repeated row. Record a fee only if the remittance documents it. Where the statement shows an agreed Quick Pay deduction, note the amount and verify it against your terms. Check other charges against the supporting paperwork before requesting a correction.

Worked example

Invoice INV-101 shows $2,400. The remittance shows $2,250 paid and a $50 documented fee. That accounts for $2,300 and leaves $100 to review. A remittance with no matching invoice and an invoice with no matching remittance need separate checks.

Try FreightPayDiff with the sample files.

See Ryder's carrier payment resources for an example of how a payer reports payment reductions and TQL's carrier FAQs for an example of documented Quick Pay terms.