Inventory Reconciliation for a Florida Distributor: A Checklist for Overseas Headquarters

An auditable reconciliation connects 3PL snapshots, the inventory subledger, the general ledger and open exceptions at month-end. Explore international accounting in Florida →

A distributor's warehouse report says one thing, the enterprise resource planning (ERP) system says another, and the general ledger shows a third balance. For an overseas headquarters, the problem is not simply that the numbers differ. It is that nobody can explain which inventory the Florida company owns, where it is, what it cost, and which differences remain unresolved at month-end.

A dependable inventory reconciliation connects three records: physical or third-party logistics (3PL) quantities, the inventory subledger, and the general ledger. It also accounts for goods in transit, transactions near the cutoff date, and the evidence supporting inventory costs. The objective is not to force three totals to match; it is to document why they match—or why they do not—and make the remaining risks visible to management.

This checklist is designed for finance leaders at a Florida distribution subsidiary and for controllers at its foreign parent company. It builds on ASCG Florida's broader guide to financial controls for importers and distributors, but concentrates on the monthly reconciliation workflow, the exception log, and the reporting pack headquarters should receive.

What an inventory reconciliation must establish

A monthly inventory figure needs more than a count of boxes. The finance team should be able to support five questions:

1. Existence and quantity: What units were on hand at the cutoff, by SKU, location, and condition? How reliable are the counts or perpetual records?
2. Ownership: Which units belong to the Florida entity, including any owned goods in transit or stock held by a 3PL? Which units are consigned or held for someone else?
3. Completeness and cutoff: Were receipts, shipments, returns, and transfers recorded in the correct period?
4. Valuation: Does the inventory balance reflect the applicable financial-reporting policy, including supported acquisition costs and any required valuation adjustments?
5. Accountability: Who investigated each exception, who approved any journal entry, and what remains open for headquarters to decide?

The answers serve different purposes. Physical counts support quantities and condition, but not necessarily ownership or cost. The ERP provides movement history, but its records can be late or incomplete. The general ledger records accounting value, but a balanced account alone does not prove that the underlying goods exist.

The five records to reconcile—not three disconnected exports

Choose one cutoff timestamp for the reconciliation and retain the time zone. A 3PL export generated at 5 p.m. and an ERP export generated at midnight do not represent the same population unless movements in between are reconstructed.

Step 1 — Define what belongs in the Florida company's inventory

Create a scope register before comparing balances. List owned warehouses, 3PL sites, in-transit shipments, returns awaiting inspection, damaged goods, and any goods located with customers or vendors. Separately identify consignment and other goods that the company handles but may not own.

For goods in transit, do not assume that a shipping term alone settles the accounting question. Finance should evaluate contracts, transfer-of-control or title evidence, shipping documents, the applicable accounting policy and any facts that require specialist interpretation. If the parent company supplies the goods, confirm whether the shipment represents a sale, an intercompany transfer or another arrangement; do not infer ownership solely from which company issued the invoice.

Deliverable: one population file with a named owner and a rule for including or excluding each category.

Step 2 — Normalize the data before looking for shortages

Use a consistent SKU master and units of measure. A carton of 12 pieces in the warehouse system cannot be compared directly with 12 individual pieces in the ERP. Map location names, status codes, lot or serial details where relevant, and the distinction between usable, quarantined, returned and damaged inventory.

Freeze the original exports as evidence. Put corrections into a separate reconciliation schedule rather than overwriting the source files. If the warehouse and ERP disagree over SKU identifiers, maintain a documented conversion table with its own reviewer and effective date.

Deliverable: a SKU-and-location comparison using the same unit, status and cutoff.

Step 3 — Reconcile physical/3PL quantities to the ERP

Compare available evidence for physical quantities against the ERP's on-hand balances. Depending on the company's control design, that evidence may include periodic physical counts, risk-based cycle counts, independent count results and 3PL reports. A monthly reconciliation should not be presented as proof that every SKU was physically counted that month.

Investigate exceptions in a repeatable order:

• Timing: Was a receipt, shipment or transfer recorded after the warehouse snapshot but attributable to the cutoff period?
• Units and locations: Is the difference caused by a pack-size conversion, wrong bin, or movement between locations?
• Restrictions: Are damaged, quarantined or returned goods included in one system but excluded from another?
• Unexplained quantities: If the difference remains after documented corrections, assign it for investigation rather than posting a plug.

Require warehouse evidence for quantity adjustments and separate authorization for accounting adjustments. The people who count, approve and post should be separated where practicable; smaller teams can use compensating review controls.

Step 4 — Perform a movement roll-forward around month-end

The inventory snapshot is only a point in time. A roll-forward ties it to the reporting date:

Opening quantity + valid receipts − valid shipments ± supported transfers/adjustments = expected closing quantity.

Use movement logs, timestamps, signed receiving records, shipping confirmations, credit notes and return receipts. Test transactions immediately before and after period-end, particularly when an overseas group closes on a different calendar or in another time zone.

A cutoff exception is not automatically an inventory loss. First determine whether the transaction belongs in the current period and then whether an accounting correction is justified.

Step 5 — Tie the inventory subledger and goods in transit to the general ledger

Once the population is established, compare the value of the inventory subledger plus owned in-transit inventory not already included in that subledger against the relevant general-ledger inventory accounts. Avoid counting the same in-transit goods twice. Examine receiving-clearing accounts and the posting of inventory receipts, shipments, returns and landed-cost accruals.

For each gap, determine whether it is caused by an unposted receipt, a cost update, an incorrectly classified journal entry, a missing shipment accrual, an unsupported adjustment or an extract-date mismatch. Any correction must follow the company's accounting policy and journal-entry approval workflow. A balancing entry that cannot be traced to an underlying transaction is not a completed reconciliation.

Step 6 — Review import documents and landed costs

Florida distributors importing merchandise may have inventory-related amounts recorded across supplier invoices, logistics invoices, customs broker statements and accounting accruals. Keep a traceable shipment reference so the finance team can follow a product from the purchase order through receipt and assigned cost.

The accounting treatment depends on the reporting framework and the entity's policies. For example, IAS 2 describes inventory cost as including purchase costs and other costs incurred in bringing inventory to its present location and condition, subject to the standard's rules. A Florida company reporting under U.S. GAAP and a parent reporting under IFRS may need an explicit reporting bridge; the reconciliation should not silently apply IFRS rules to the local U.S. books.

Maintain a supported, reviewed schedule of freight, duties, brokerage and handling costs. Identify which amounts are inventory costs under the applicable policy, which are period expenses, which are accrued but not yet invoiced, and which have already been included in supplier prices. This helps prevent both omitted costs and double capitalization.

For imported shipments, preserve the customs entry and commercial-invoice evidence needed by the responsible import and tax advisers. U.S. Customs and Border Protection describes documentation and recordkeeping requirements for customs entry records. The accounting reconciliation does not replace customs classification, tax or transfer-pricing analysis.

Step 7 — Assess condition, aging and valuation separately

A perfectly matched quantity can still have the wrong accounting value. Ask the warehouse for evidence of damaged, obsolete, slow-moving, expired (where relevant) or otherwise restricted goods. Connect that evidence to the inventory valuation policy and review any necessary estimates with the appropriate accounting specialist.

Under IAS 2, inventory is generally measured at the lower of cost and net realizable value. Do not assume that this IFRS formulation automatically describes every U.S. GAAP or tax valuation rule. Headquarters should receive the bridge between the Florida entity's books and any parent-reporting adjustments that are genuinely required.

Step 8 — Log exceptions instead of hiding them in the closing balance

Use an exception register that finance, operations and headquarters can read without reopening every source file:

Materiality and escalation thresholds should be set by the business, not copied from an arbitrary example. The register should distinguish corrected, explained but still open, unexplained, and approved for adjustment. Headquarters may accept a report with disclosed exceptions, but it should not be told the inventory is fully reconciled when material gaps remain.

Worked example: two differences, two different responses

The following numbers are fictional and are designed to show the reconciliation logic, not to prescribe journal entries.

A. Quantity difference for one SKU. At the September 30 cutoff, the ERP shows 1,200 units of SKU FL-101, while the Miami 3PL reports 1,170 units. The gross difference is 30 units. A dispatch record establishes that 20 units physically shipped before cutoff but were posted to the ERP the following day. Once that supported timing correction is reflected, expected ERP quantity becomes 1,180 units. The remaining 10-unit gap, with an illustrative $40 unit cost, represents $400 requiring investigation. Finance should not post an inventory-loss entry merely to eliminate the difference.

B. Value difference for the full inventory population. Suppose the on-hand inventory subledger totals $247,600, and the separately maintained schedule shows $18,000 of inventory in transit owned by the Florida company and not already included in that subledger. Their combined supported value is $265,600. The general ledger inventory balance is $264,600, a $1,000 shortfall relative to the supporting schedules. Investigation identifies a $1,000 supported receipt included in the subledger but not posted to the correct ledger account. If the documentation, cutoff and accounting treatment support the entry, an authorized posting can resolve that value tie-out.

The lessons are different. Correcting the $1,000 general-ledger difference does not prove that FL-101 exists in the expected quantity. Explaining the 20-unit cutoff issue does not authorize writing off the other 10 units. Each exception needs its own evidence, decision and close status.

Month-end inventory reconciliation checklist

Use this as a repeatable control, not a once-a-year cleanup exercise:

• [ ] Confirm reporting date, time zone, responsible entity and warehouse/3PL locations.
• [ ] Obtain unedited warehouse/3PL, ERP subledger and general-ledger extracts.
• [ ] Normalize SKUs, units of measure, locations and inventory status codes.
• [ ] Identify consigned stock, customer-owned stock and other exclusions.
• [ ] Support in-transit ownership and avoid double-counting in the ledger tie-out.
• [ ] Compare physical/cycle-count or 3PL evidence with perpetual inventory records.
• [ ] Investigate negative stock, material variances and unusual inventory movements.
• [ ] Test receipts, shipments, transfers and returns around month-end cutoff.
• [ ] Reconcile inventory subledger, in-transit schedule and GL inventory accounts.
• [ ] Trace applicable landed costs and accruals to shipment and invoice evidence.
• [ ] Flag damaged, aged, obsolete or restricted inventory for valuation review.
• [ ] Record each unresolved exception with value, owner, evidence and deadline.
• [ ] Obtain review and approval for journal entries; retain the original support.
• [ ] Issue a concise headquarters summary showing reconciled balances and open risks.

The one-page inventory pack overseas headquarters should receive

Headquarters does not need every transaction log in the first email. It needs a decision-ready summary with a traceable evidence folder behind it:

Agree with the overseas controller how the Florida operation will map inventory categories, currencies, intercompany stock purchases and management-reporting adjustments. The parent should be able to distinguish local-book corrections from group-reporting reclassifications. For the broader reporting context, see Month-End Close for a Foreign-Owned Florida Subsidiary.

Common mistakes that make an apparently balanced inventory report unreliable

Treating a 3PL total as a full ownership statement. A warehouse can count goods it holds without establishing who owns them. Use contracts and transaction evidence.

Treating all timing differences as losses. Fix the cutoff analysis first; an unexplained residual is a separate problem.

Reclassifying landed costs merely to improve gross margin. Costs require policy-based treatment and supporting documents, not a desired outcome.

Posting a plug to the inventory account. A ledger tie-out with no supporting movement may conceal missing goods or incomplete source data.

Sending headquarters a green status with unresolved exceptions. Present the remaining amounts, their owners and whether management has approved the required accounting treatment.

Frequently asked questions

Does a Florida distributor have to count every SKU physically each month?

Not necessarily. The appropriate counting approach depends on the company's system, risks, reporting requirements and professional obligations. A monthly reconciliation may rely on perpetual records and a designed cycle-count program, supplemented by physical counts as appropriate. It should accurately describe what was counted and what evidence was used; it should not imply complete physical verification when that did not occur.

Should goods in transit always be included in the Florida subsidiary's inventory?

No. Inclusion depends on the underlying facts and the applicable accounting policy, including rights or ownership and the timing of the relevant transaction. Shipping documents are evidence to evaluate, not a substitute for reviewing the terms and the transaction.

What if headquarters reports under IFRS but the Florida company keeps U.S. books?

Maintain a documented reporting bridge. Start with the Florida entity's approved accounting balances, identify genuine differences in classification or valuation under the group's policies, and obtain professional review for adjustments. Do not overwrite local-book records simply to reproduce the parent's format.

Turn the reconciliation into a management control

A monthly reconciliation should tell management what stock is supported, what is not, and who is responsible for the difference. When warehouse operations, ERP movements, costs and the general ledger are joined by evidence and a documented close calendar, overseas headquarters can review Florida inventory without reconstructing it from scratch.

If your Florida subsidiary or distribution operation needs a stronger connection between inventory records, monthly close and parent-company reporting, explore ASCG Florida's international business accounting and reporting service or discuss the current finance process with ASCG Florida. A useful starting point is a sample month-end inventory bridge, including its open exceptions and supporting reports.

Sources and further reading

• IFRS Foundation — IAS 2 Inventories: international inventory costing and valuation principles. Applicability depends on the reporting framework.
• Internal Revenue Service — Publication 538, Accounting Periods and Methods: U.S. tax-accounting inventory concepts and distinctions; refer to current developments and entity-specific advice.
• Internal Revenue Service — About Form 1125-A, Cost of Goods Sold: federal cost-of-goods-sold reporting for applicable entity filers.
• U.S. Customs and Border Protection — Entry Summary Record-Keeping: customs entry document retention background.

Editorial review date: October 19, 2026. This guide is operational information, not a substitute for entity-specific accounting, audit, customs or tax advice. An ASCG-designated professional should review it before publication.