← Ledgerline Reconciliation Get this done for your shipment
Fictional company & shipment — work-sample only, no real client data
Ledgerline Reconciliation Prepared by Nova Ridge LLC · novaridgellc1@gmail.com
Deliverable Import-Procedure Reconciliation ($199 tier) Prepared for Harbor & Vine Wine Imports LLC Report date September 4, 2026

Import-Procedure Paperwork Reconciliation

Shipment: Domaine LeClair (Bordeaux, France) → Port of Newark, NJ · Container MSCU7741205 · Invoice #INV-20456

1 Summary

Four source documents — commercial invoice, packing list, bill of lading, and customs entry — were cross-checked against each other and against the landed-cost ledger recorded by the bookkeeping team. Two material discrepancies were found: a 12-case quantity mismatch between the packing list and the bill of lading, and a customs valuation error that understated the dutiable value by $700.00. Neither is necessarily fraud or negligence — both are common friction points between freight, customs brokerage, and bookkeeping — but both carry real financial and compliance exposure and should be resolved before this purchase order is closed.

2 Document-to-Document Cross-Check

FieldCommercial invoicePacking listBill of ladingCustoms entry (7501)
Case count840840828 ⚠828 ⚠
Bottles per case1212
Gross weight9,660 kg9,660 kg9,660 kg
Declared value$35,700.00$35,000.00 ⚠
Duty rate applied6.3%
Duty paid$2,205.00

⚠ marks a value that does not agree with the invoice and packing list, detailed in Section 3.

3 Discrepancies Found

Case count mismatch — 12 cases (144 bottles)

What was found: The commercial invoice and packing list both state 840 cases were shipped; the bill of lading and the customs entry both state 828 cases were received/declared. Gross weight matches across all four documents at 9,660 kg, which is consistent with 840 cases — the weight figure was likely carried forward from the original packing list rather than re-measured at the port, so it doesn't independently confirm either count.

Recommendation: Contact the freight forwarder to confirm the actual loaded/received quantity and obtain either an amended bill of lading or a short-shipment report before this purchase order is marked fully received in inventory. If 828 is correct, the invoice should be disputed with the supplier for the 12-case shortfall ($510.00 at invoice unit price); if 840 is correct, the BOL and customs entry need to be corrected.

Customs valuation error — $700.00 understated

What was found: The customs entry (CBP Form 7501) declares a dutiable value of $35,000.00, but the commercial invoice value is $35,700.00 — a $700.00 undervaluation. This is a compliance exposure regardless of which direction the error benefits the importer: U.S. Customs requires the entered value to match the invoice (transaction value), and undervaluation — even unintentional — can result in penalties, interest, and increased audit scrutiny on future shipments if it's discovered in a CBP review rather than self-reported.

Recommendation: File a Post Summary Correction (PSC) with the customs broker to amend the entered value to $35,700.00. At the filed duty rate of 6.3%, this increases duty owed by $44.10 ($700.00 × 6.3%), payable on PSC acceptance. This is a small, manageable correction now; the exposure grows if it's caught later during a CBP focused assessment.

4 Landed-Cost Reconciliation

Line itemPer bookkeeping ledgerPer source documentsVariance
Goods (commercial invoice)$35,700.00$35,700.00
Freight$2,850.00$2,850.00
Insurance$180.00$180.00
Duty discrepancy$2,268.00$2,205.00 (as filed)($63.00)
Customs broker fee$450.00$450.00
Total landed cost (as currently filed)$41,448.00$41,385.00($63.00)
Total landed cost (if PSC filed at correct $35,700 value)$41,429.10+$44.10 vs. as-filed

Duty recorded incorrectly in the ledger — $63.00 overstated

What was found: Bookkeeping recorded duty expense of $2,268.00, but the customs entry shows $2,205.00 was actually paid (6.3% × the filed value of $35,000.00) — a $63.00 overstatement, most likely a transposition when the duty line was keyed in from the broker's invoice.

Recommendation: Correct the ledger down by $63.00 now, then apply a further +$44.10 adjustment once the Post Summary Correction in Section 3 is accepted, bringing recorded duty to the correct $2,249.10 (6.3% × $35,700.00).

5 Corrected Paperwork Checklist

  • Confirm actual case count with the freight forwarder; obtain an amended bill of lading or a signed short-shipment report for the 12-case (144-bottle) difference.
  • File a Post Summary Correction with the customs broker to amend the dutiable value from $35,000.00 to $35,700.00.
  • Pay the resulting duty differential of $44.10 upon PSC acceptance.
  • Correct the landed-cost ledger: reduce recorded duty from $2,268.00 to $2,205.00 now, then increase to $2,249.10 once the PSC is accepted.
  • Resolve the case-count discrepancy in inventory receiving records before closing the purchase order — either a supplier credit for a genuine shortfall, or a correction to the BOL/customs entry if the full 840 cases actually arrived.
  • Retain all four source documents plus this reconciliation memo together in the shipment file as the audit trail for this correction.