Match delivered shipments, carrier invoices, and existing accruals to explain the remaining liability.
Where this helps
Month-end freight expense is difficult to reconcile when shipments are delivered but carrier bills arrive later. Duplicate accruals and missing accessorials can distort the apparent cost of a lane or plant.
What Rectangle connects
Join TMS delivery status and contracted charges to ERP invoices, posted accruals, and credit notes using stable shipment references. Separate invoiced shipments, uninvoiced deliveries, and shipments with unresolved charges. Keep estimate methodology and currency consistent across the close.
Match shipments to bills 120 delivered shipments · 100 invoiced · 20 uninvoiced
- Uninvoiced estimate: $18,600
- Existing accruals on those same 20 shipments: $12,400
- Potential additional accrual: $6,200.
A closer look
Match delivered shipments, carrier invoices, and existing accruals to explain the remaining liability.
Explain rate differences The $2,100 finalized variance comes from detention and fuel.
| Cost driver | Difference |
|---|---|
| Detention | $1,500 |
| Fuel | $600 |
| Total | $2,100 |
The 100 invoiced shipments were estimated at $92,000 and billed at $94,100. Keep this separate from the proposed $6,200 additional accrual on 20 uninvoiced shipments; three accessorial estimates still need confirmation.
From answer to action
Finance gets a reconciliation tied to each shipment, with proposed accruals and reversals for review. The assistant can prepare a journal support file through a connected accounting or spreadsheet tool. Posting remains part of the organization’s controlled close process.
Prepare the close support Proposed additional accrual: $6,200, subject to finance review
- $2,100 invoiced variance explained separately.
- 3 accessorial estimates require owner confirmation.
- Journal support prepared · no ledger entry posted.
Explain the gap between estimated and invoiced freight with a traceable month-end schedule.
