Audit carrier invoices against the rate cons before anything gets paid
Margin rarely vanishes in one bad load; it leaks through detention nobody approved, lumper charges with no receipt, and the same load number invoiced twice. Agent FM audits the week's carrier invoices against their rate cons before anything gets paid: every mismatch flagged with the difference in dollars, clean invoices logged to the payables sheet, the disputes gathered on their own tab. It pays and approves nothing; flags only, the checkbook stays yours. The audit that never quite happened when Fridays got busy now happens every week, and the leaks get caught while they are still line items.
Audit this week's carrier invoices [where, e.g. the AP label in Gmail] against their rate confirmations in the loads sheet.
Flag every mismatch: a rate different from the con, lumper or detention charges with no approval noted, duplicate invoices for the same load number.
Log clean invoices in the payables sheet and put the mismatches on a flags tab with the difference in dollars. Don't pay or approve anything, flags only. Tell me the counts and the total in dispute.