Cross-verifying transactions to ensure fair and accurate billing in your supply chain.
In the complex world of freight and logistics, maintaining perfect alignment between payment records and freight logs is a constant challenge. Discrepancies can lead to significant financial losses, strained partnerships, and operational inefficiencies. The CNFANS Spreadsheet
Mismatches between what a freight log shows and what a payment system records typically stem from:
This process transforms your spreadsheet into a powerful reconciliation tool.
Create a master spreadsheet with the following columns from both your Payment LogFreight Log:
| Key Identifier | Freight Log Data | Payment Log Data |
|---|---|---|
| PRO Number / Shipment ID | Origin/Destination, Weight, Dimensions | Invoice Number, Invoice Date |
| Carrier Name | Services Requested (Accessorials) | Billed Amount, Payment Status |
| Shipment Date | Quoted Rate | Approved Amount |
Use spreadsheet formulas to automate comparisons. Key checks include:
=IF(Payment_Amount < Quoted_Rate, "CHECK", "OK")
=IF(ISNA(VLOOKUP(Shipment_ID, Payment_Range, 1, FALSE)), "Missing Payment", "Found")
=IF(Billed_Weight Logged_Weight * 1.02, "Weight Discrepancy", "OK")
Apply rules to highlight anomalies instantly:
Add columns to document findings and actions: