Freight Settlement & Claims
Planned, tendered, invoiced, and what is still open
Freight AccruedJMD 24.8M
TRN-2608-041 accrued at JMD 185,000
Invoice VariancesJMD 486K
▼ INV-041 is JMD 17,500 of that
Open Claims14
CLM-041 is in investigation
Shipment → Order → Product → Customer
Shipment→Order→Product→Customer
Freight accrual
Accrued cost matches the tender, JMD 185,000. CC-MFG-KIN is the cost centre. Nothing is posted.
0 selected
| Shipment | Order | Customer | Product | Carrier | Rated Cost | Accrued Cost | Currency | Status | |
|---|---|---|---|---|---|---|---|---|---|
| TRN-2608-041 | SO-2608-1182 | Kingston Industrial Supplies | Parish Switch Kit | Caribbean Freight Services | JMD 185,000 | JMD 185,000 | JMD | Accrued | |
| TRN-30101 | SO-8101 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 8,250 | JMD 8,250 | JMD | Allocated | |
| TRN-30102 | SO-8102 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 8,500 | JMD 8,500 | JMD | Settled | |
| TRN-30103 | SO-8103 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 8,750 | JMD 8,750 | JMD | Adjusted | |
| TRN-30104 | SO-8104 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 9,000 | JMD 9,000 | JMD | Accrued | |
| TRN-30105 | SO-8105 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 9,250 | JMD 9,250 | JMD | Allocated | |
| TRN-30106 | SO-8106 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 9,500 | JMD 9,500 | JMD | Settled | |
| TRN-30107 | SO-8107 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 9,750 | JMD 9,750 | JMD | Adjusted | |
| TRN-30108 | SO-8108 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 10,000 | JMD 10,000 | JMD | Accrued | |
| TRN-30109 | SO-8109 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 10,250 | JMD 10,250 | JMD | Allocated | |
| TRN-30110 | SO-8110 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 10,500 | JMD 10,500 | JMD | Settled | |
| TRN-30111 | SO-8111 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 10,750 | JMD 10,750 | JMD | Adjusted | |
| TRN-30112 | SO-8112 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 11,000 | JMD 11,000 | JMD | Accrued | |
| TRN-30113 | SO-8113 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 11,250 | JMD 11,250 | JMD | Allocated | |
| TRN-30114 | SO-8114 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 11,500 | JMD 11,500 | JMD | Settled | |
| TRN-30115 | SO-8115 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 11,750 | JMD 11,750 | JMD | Adjusted | |
| TRN-30116 | SO-8116 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 12,000 | JMD 12,000 | JMD | Accrued | |
| TRN-30117 | SO-8117 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 12,250 | JMD 12,250 | JMD | Allocated | |
| TRN-30118 | SO-8118 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 12,500 | JMD 12,500 | JMD | Settled | |
| TRN-30119 | SO-8119 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 12,750 | JMD 12,750 | JMD | Adjusted | |
| TRN-30120 | SO-8120 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 13,000 | JMD 13,000 | JMD | Accrued | |
| TRN-30121 | SO-8121 | Parish Schools Board | SIM Starter Pack | Caribbean Freight Services | JMD 13,250 | JMD 13,250 | JMD | Allocated | |
| TRN-30122 | SO-8122 | Parish Schools Board | SIM Starter Pack | Blue Harbour Freight | JMD 13,500 | JMD 13,500 | JMD | Settled | |
| TRN-30123 | SO-8123 | Parish Schools Board | SIM Starter Pack | Coral Coastal | JMD 13,750 | JMD 13,750 | JMD | Adjusted |
No records match this filter.
Dispute automatically raised
Tendered JMD 185,000. Invoiced JMD 202,500. Variance JMD 17,500. Tolerance JMD 5,000. INV-041 stays disputed. The chart rounds invoiced to JMD 203k.
Planned
JMD 185,000
Tendered
JMD 185,000
Invoiced
JMD 202,500
Settled
Open
Dispute on INV-041
Freight audit
INV-118 is the USD ocean invoice and is the one that can be marked settled. INV-041 is not settled.
0 selected
| Invoice ID | Carrier | Shipment | Rated Cost | Tendered Cost | Invoiced Cost | Variance | Tolerance | Disposition | Status | |
|---|---|---|---|---|---|---|---|---|---|---|
| INV-041 | Caribbean Freight Services | TRN-2608-041 | JMD 185,000 | JMD 185,000 | JMD 202,500 | JMD 17,500 | JMD 5,000 | Dispute | Disputed | |
| INV-220 | Blue Harbour Freight | TRN-2208 | JMD 54,000 | JMD 54,000 | JMD 55,200 | JMD 1,200 | JMD 2,000 | Pay | Within Tolerance | |
| INV-118 | Coral Coastal | TRN-1188 | USD 640 | USD 640 | USD 640 | USD 0 | USD 20 | Pay | Approved | |
| INV-703 | Caribbean Freight Services | TRN-31103 | JMD 10,900 | JMD 10,900 | JMD 10,900 | JMD 0 | JMD 2,000 | Pay | Approved | |
| INV-704 | Parish Line Haul | TRN-31104 | JMD 11,200 | JMD 11,200 | JMD 11,200 | JMD 0 | JMD 2,000 | Pay | Settled | |
| INV-705 | Ridge Road Carriers | TRN-31105 | JMD 11,500 | JMD 11,500 | JMD 11,500 | JMD 0 | JMD 2,000 | Pay | Matched | |
| INV-706 | Caribbean Freight Services | TRN-31106 | JMD 11,800 | JMD 11,800 | JMD 11,800 | JMD 0 | JMD 2,000 | Pay | Within Tolerance | |
| INV-707 | Parish Line Haul | TRN-31107 | JMD 12,100 | JMD 12,100 | JMD 12,100 | JMD 0 | JMD 2,000 | Pay | Disputed | |
| INV-708 | Ridge Road Carriers | TRN-31108 | JMD 12,400 | JMD 12,400 | JMD 12,400 | JMD 0 | JMD 2,000 | Pay | Approved | |
| INV-709 | Caribbean Freight Services | TRN-31109 | JMD 12,700 | JMD 12,700 | JMD 12,700 | JMD 0 | JMD 2,000 | Pay | Settled | |
| INV-710 | Parish Line Haul | TRN-31110 | JMD 13,000 | JMD 13,000 | JMD 13,000 | JMD 0 | JMD 2,000 | Pay | Matched | |
| INV-711 | Ridge Road Carriers | TRN-31111 | JMD 13,300 | JMD 13,300 | JMD 13,300 | JMD 0 | JMD 2,000 | Pay | Within Tolerance | |
| INV-712 | Caribbean Freight Services | TRN-31112 | JMD 13,600 | JMD 13,600 | JMD 13,600 | JMD 0 | JMD 2,000 | Pay | Disputed | |
| INV-713 | Parish Line Haul | TRN-31113 | JMD 13,900 | JMD 13,900 | JMD 13,900 | JMD 0 | JMD 2,000 | Pay | Approved | |
| INV-714 | Ridge Road Carriers | TRN-31114 | JMD 14,200 | JMD 14,200 | JMD 14,200 | JMD 0 | JMD 2,000 | Pay | Settled | |
| INV-715 | Caribbean Freight Services | TRN-31115 | JMD 14,500 | JMD 14,500 | JMD 14,500 | JMD 0 | JMD 2,000 | Pay | Matched | |
| INV-716 | Parish Line Haul | TRN-31116 | JMD 14,800 | JMD 14,800 | JMD 14,800 | JMD 0 | JMD 2,000 | Pay | Within Tolerance | |
| INV-717 | Ridge Road Carriers | TRN-31117 | JMD 15,100 | JMD 15,100 | JMD 15,100 | JMD 0 | JMD 2,000 | Pay | Disputed | |
| INV-718 | Caribbean Freight Services | TRN-31118 | JMD 15,400 | JMD 15,400 | JMD 15,400 | JMD 0 | JMD 2,000 | Pay | Approved | |
| INV-719 | Parish Line Haul | TRN-31119 | JMD 15,700 | JMD 15,700 | JMD 15,700 | JMD 0 | JMD 2,000 | Pay | Settled | |
| INV-720 | Ridge Road Carriers | TRN-31120 | JMD 16,000 | JMD 16,000 | JMD 16,000 | JMD 0 | JMD 2,000 | Pay | Matched | |
| INV-721 | Caribbean Freight Services | TRN-31121 | JMD 16,300 | JMD 16,300 | JMD 16,300 | JMD 0 | JMD 2,000 | Pay | Within Tolerance | |
| INV-722 | Parish Line Haul | TRN-31122 | JMD 16,600 | JMD 16,600 | JMD 16,600 | JMD 0 | JMD 2,000 | Pay | Disputed | |
| INV-723 | Ridge Road Carriers | TRN-31123 | JMD 16,900 | JMD 16,900 | JMD 16,900 | JMD 0 | JMD 2,000 | Pay | Approved |
No records match this filter.
Claims
CLM-041 is the two damaged units on POD-041, JMD 48,000, recovery from the carrier.
0 selected
| Claim ID | Shipment | Type | Carrier | Receipt Discrepancy | Amount | Recovery Source | Status | |
|---|---|---|---|---|---|---|---|---|
| CLM-041 | TRN-2608-041 | Damage | Caribbean Freight Services | 2 units short of a clean POD | JMD 48,000 | Carrier | Investigation | |
| CLM-201 | TRN-32101 | Damage | Coral Coastal | 1 carton short | JMD 6,400 | Supplier | Investigation | |
| CLM-202 | TRN-32102 | Loss | Parish Line Haul | Crushed carton | JMD 6,800 | Pending Review | Submitted | |
| CLM-203 | TRN-32103 | Damage | Blue Harbour Freight | 1 carton short | JMD 7,200 | Carrier | Recovered | |
| CLM-204 | TRN-32104 | Loss | Coral Coastal | Crushed carton | JMD 7,600 | Supplier | Closed | |
| CLM-205 | TRN-32105 | Damage | Parish Line Haul | 1 carton short | JMD 8,000 | Pending Review | Open | |
| CLM-206 | TRN-32106 | Loss | Blue Harbour Freight | Crushed carton | JMD 8,400 | Carrier | Investigation | |
| CLM-207 | TRN-32107 | Damage | Coral Coastal | 1 carton short | JMD 8,800 | Supplier | Submitted | |
| CLM-208 | TRN-32108 | Loss | Parish Line Haul | Crushed carton | JMD 9,200 | Pending Review | Recovered | |
| CLM-209 | TRN-32109 | Damage | Blue Harbour Freight | 1 carton short | JMD 9,600 | Carrier | Closed | |
| CLM-210 | TRN-32110 | Loss | Coral Coastal | Crushed carton | JMD 10,000 | Supplier | Open | |
| CLM-211 | TRN-32111 | Damage | Parish Line Haul | 1 carton short | JMD 10,400 | Pending Review | Investigation | |
| CLM-212 | TRN-32112 | Loss | Blue Harbour Freight | Crushed carton | JMD 10,800 | Carrier | Submitted | |
| CLM-213 | TRN-32113 | Damage | Coral Coastal | 1 carton short | JMD 11,200 | Supplier | Recovered | |
| CLM-214 | TRN-32114 | Loss | Parish Line Haul | Crushed carton | JMD 11,600 | Pending Review | Closed | |
| CLM-215 | TRN-32115 | Damage | Blue Harbour Freight | 1 carton short | JMD 12,000 | Carrier | Open | |
| CLM-216 | TRN-32116 | Loss | Coral Coastal | Crushed carton | JMD 12,400 | Supplier | Investigation | |
| CLM-217 | TRN-32117 | Damage | Parish Line Haul | 1 carton short | JMD 12,800 | Pending Review | Submitted | |
| CLM-218 | TRN-32118 | Loss | Blue Harbour Freight | Crushed carton | JMD 13,200 | Carrier | Recovered | |
| CLM-219 | TRN-32119 | Damage | Coral Coastal | 1 carton short | JMD 13,600 | Supplier | Closed |
No records match this filter.
Freight cost to margin
Freight cost→Order→Product→Customer→Margin
Landed cost
Weight basis. JMD 9,250 per unit is the stored margin line on product costing.
0 selected
| Shipment | Product | Order | Customer | Freight Cost | Allocated Cost | Allocation Basis | Margin Impact | |
|---|---|---|---|---|---|---|---|---|
| TRN-2608-041 | Parish Switch Kit | SO-2608-1182 | Kingston Industrial Supplies | JMD 185,000 | JMD 185,000 | Weight | JMD 9,250 / unit | |
| TRN-33101 | SIM Starter Pack | SO-8201 | Parish Schools Board | JMD 4,200 | JMD 4,200 | Volume | Stored | |
| TRN-33102 | SIM Starter Pack | SO-8202 | Parish Schools Board | JMD 4,400 | JMD 4,400 | Quantity | Stored | |
| TRN-33103 | SIM Starter Pack | SO-8203 | Parish Schools Board | JMD 4,600 | JMD 4,600 | Value | Stored | |
| TRN-33104 | SIM Starter Pack | SO-8204 | Parish Schools Board | JMD 4,800 | JMD 4,800 | Weight | Stored | |
| TRN-33105 | SIM Starter Pack | SO-8205 | Parish Schools Board | JMD 5,000 | JMD 5,000 | Volume | Stored | |
| TRN-33106 | SIM Starter Pack | SO-8206 | Parish Schools Board | JMD 5,200 | JMD 5,200 | Quantity | Stored | |
| TRN-33107 | SIM Starter Pack | SO-8207 | Parish Schools Board | JMD 5,400 | JMD 5,400 | Value | Stored | |
| TRN-33108 | SIM Starter Pack | SO-8208 | Parish Schools Board | JMD 5,600 | JMD 5,600 | Weight | Stored | |
| TRN-33109 | SIM Starter Pack | SO-8209 | Parish Schools Board | JMD 5,800 | JMD 5,800 | Volume | Stored | |
| TRN-33110 | SIM Starter Pack | SO-8210 | Parish Schools Board | JMD 6,000 | JMD 6,000 | Quantity | Stored | |
| TRN-33111 | SIM Starter Pack | SO-8211 | Parish Schools Board | JMD 6,200 | JMD 6,200 | Value | Stored | |
| TRN-33112 | SIM Starter Pack | SO-8212 | Parish Schools Board | JMD 6,400 | JMD 6,400 | Weight | Stored | |
| TRN-33113 | SIM Starter Pack | SO-8213 | Parish Schools Board | JMD 6,600 | JMD 6,600 | Volume | Stored | |
| TRN-33114 | SIM Starter Pack | SO-8214 | Parish Schools Board | JMD 6,800 | JMD 6,800 | Quantity | Stored | |
| TRN-33115 | SIM Starter Pack | SO-8215 | Parish Schools Board | JMD 7,000 | JMD 7,000 | Value | Stored |
No records match this filter.
New Claim
1 · Shipment2 · Amount3 · Review
Review only. CLM-4490 is added as Open. Nothing is recovered.
Raise dispute
INV-220 will show as Disputed. The carrier invoice is not changed.
Mark settled
INV-118 will show as Settled. Nothing is posted to Finance.
Submit claim
CLM-041 will show as Submitted. The carrier is not contacted.