Coca-ColaFreight Reconciliation Engine

Reconciliation Workbench Automation Engine

Cairo Plant

CAI-02 · Cairo, Egypt · Middle East & Africa · Site lead Omar Hassan

Invoices at this warehouse/plant

Customer invoiceCarrier invoiceSO / FOCustomer billedCarrier billedVarianceStatus
CINV-70242

Redline Manufacturing

AF-51207SO-884133 · FO-994133$3,180.00$3,600.00Awaiting audit
CINV-70247

Delta Paper Group

IB-61550SO-884112 · FO-994112$1,645.00$1,850.00Debit note proposed
CINV-70248

Orchard Distribution

LE-18876SO-884125 · FO-994125$1,314.00$1,312.00No change
CINV-70251

Redline Manufacturing

AF-51340SO-884170 · FO-994170$3,180.00$3,492.00Exception — Step 9
CINV-70252

Orchard Distribution

LE-18920SO-884174 · FO-994174$1,240.00$1,425.00Posted to SAP
CINV-70253

Delta Paper Group

IB-61604SO-884178 · FO-994178$1,598.00$1,595.00Awaiting audit

Performance by reason code

Each exception type, the person it routes to at CAI-02, and the invoices assigned to them.

RC-02Detention / demurrage charge

Carrier is billing waiting time beyond the contracted free time.

Roberto SalinasDock Manager · responds in 12h
1assigned$420.00at stake cleared0%
Customer invoiceSO / FOVarianceApproval oddsStatus
CINV-70242

Altair Freight

SO-884133 · FO-99413388%autoAwaiting auditOpen

RC-06Weight / class reclassification

Carrier re-weighed or re-classed the shipment above our scale ticket.

Roberto SalinasDock Manager · responds in 16h
1assigned$312.00at stake cleared0%
Customer invoiceSO / FOVarianceApproval oddsStatus
CINV-70251

Altair Freight

SO-884170 · FO-99417074%Exception — Step 9Open

RC-01Rate variance vs contract

Billed linehaul does not match the contracted tariff on the rate card.

Dev ShankarProcurement Head · responds in 24h
1assigned$205.00at stake cleared100%
Customer invoiceSO / FOVarianceApproval oddsStatus
CINV-70247

Ironbridge Haulage

SO-884112 · FO-99411298%autoDebit note proposedOpen

RC-08Peak / seasonal surcharge

Surcharge applied outside the contracted peak-season window.

Dev ShankarProcurement Head · responds in 24h
1assigned$185.00at stake cleared100%
Customer invoiceSO / FOVarianceApproval oddsStatus
CINV-70252

Lakeshore Express

SO-884174 · FO-99417495%autoPosted to SAPOpen

RC-00Within tolerance — no exception

Both bills agree inside the tolerance band; nothing to route.

Nina KowalskiAccounts Payable Controller · responds in 0h
2assigned$0.00at stake cleared50%
Customer invoiceSO / FOVarianceApproval oddsStatus
CINV-70248

Lakeshore Express

SO-884125 · FO-99412598%autoNo changeOpen
CINV-70253

Ironbridge Haulage

SO-884178 · FO-99417898%autoAwaiting auditOpen

Carrier breakdown

CarrierInvoicesAbsolute varianceCapital saved
Altair Freight2$732.00$0.00
Ironbridge Haulage2$208.00$205.00
Lakeshore Express2$187.00$185.00

Carrier claims from this site

  • CD-4488 · Altair Freight

    Carrier reviewing

    Weight / freight class reclassification · $312.00 · carrier invoice AF-51340

  • CD-4490 · Lakeshore Express

    Credit issued

    Peak season surcharge outside contract window · $185.00 · carrier invoice LE-18920

How these numbers are calculated

  • Invoices reconciled — invoices audited, free of open disputes and with a true-up outcome, divided by total invoices.
  • No-audit-needed invoices — invoices where customer billed and carrier billed agree within ±$5.00, so no manual audit is required.
  • Capital saved — carrier over-billing removed at audit or dispute, plus freight under-billed to customers and recovered through delta bills.
  • Open items: 3 invoice(s) still in the pipeline, 1 awaiting SAP posting, 1 posted.