Reconcile supplier goods in transit by matching ownership-transfer postings to the inbound shipment lines and physical receipts that resolve them. Start with the accounting cutoff, then prove which owned quantities remain outside the warehouse. A list of containers marked In Transit is not a financial reconciliation.
This process concerns supplier inbound shipments and the related external inventory-in-transit balance. Transfers between company warehouses need a separate transfer-order reconciliation. Keeping those populations distinct prevents different ownership and transaction flows from being mixed into one unexplained total.
Record the subsidiary, accounting book where applicable, currency basis, posting period, and cutoff date. Identify the relevant in-transit account and the supported transaction types that affect it in the account configuration.
NetSuite creates an External Inventory In Transit account when Inbound Shipment Management is enabled. Ownership transfer and receiving are separate events. Review the actual GL impact and related records for representative shipments to establish the population you need, rather than assuming every logistics record posts to that account.
Keep logistics status, accounting ownership, and physical receipt as separate columns. A shipment can be moving without an ownership posting, or partly received while an owned balance remains. Those conditions can be valid if supported and reconciled.
Use a stable combination of inbound shipment, purchase-order line, item, and owning entity. Add vendor, external shipment reference, quantity and unit, ownership transaction, ownership date and period, receiving location, receipt references, and unresolved quantity.
For monetary review, retain transaction currency and the relevant accounting value separately. Do not add several currencies into one total or multiply all quantities by a single current item cost. The reconciliation should follow posted values and approved accounting treatment.
Keep freight and other landed-cost elements identifiable. The supplier-item value and later cost allocations can follow different timing. A reviewer should be able to explain the composition of the balance without assuming that every amount has the same quantity relationship.
First, reconcile the financial population: opening balance, ownership-related increases, receipt-related clearing, and any separately approved corrections or other supported movements. Compare the rollforward with the ending GL balance for the same scope.
Second, reconcile the quantity population: units supported by ownership evidence, units physically received, and the remaining units by shipment line. Investigate any ownership quantity exceeding the documented shipment or any receipt that appears twice.
Third, reconcile the logistics population: goods still moving, arrived but awaiting recording, diverted, damaged, or reported missing. Every unresolved financial line should have a credible operational explanation and an accountable owner.
A matching total is insufficient when unrelated differences offset. Preserve line-level exceptions even if their combined monetary value is zero.
Assume an approved ownership posting covers 100 units at a simplified value of $25 each, with no currency or landed-cost complications. The initial in-transit value is $2,500. By the cutoff, supported receipts cover 70 units and clear $1,750 in this illustrative model.
The expected remaining quantity is 30 units and the expected remaining value is $750. Logistics confirms 25 units are still moving and five are under a carrier shortage investigation. The balance has an explanation, but the five-unit exception still requires a decision.
Now suppose the register reports $1,000 remaining while the GL reports $750. Do not post a $250 journal to make them match. Inspect whether a ten-unit receipt was omitted from the register, duplicated in another report, posted in a different period, or valued differently.
The simplified arithmetic establishes an expected bridge. Actual account postings, currencies, rates, and cost allocations must be reviewed by the responsible accountant. The example does not prescribe a universal journal-entry pattern.
An ownership transaction without a matching shipment-line reference needs immediate investigation. Check the selected purchase-order line, item, quantity, location, and external document. Similar item descriptions are not reliable matching keys.
If the shipment was later diverted, inspect how the supported correction affected existing records. A location edited in an external spreadsheet does not update the accounting trail. Retain the original and revised destination evidence and identify the approved transaction route.
Look for duplicate processing after a failed or uncertain submission. Verify completed records before retrying. A job marked failed may still require investigation of individual line results; the process owner should establish what actually posted.
Confirm that the receipt belongs to the relevant inbound shipment and purchase-order line. Check quantity, units, date, period, subsidiary, and related ownership records. A receipt elsewhere in the account can explain physical stock without resolving the intended in-transit line.
Inspect partial and short receipts. If goods are genuinely missing, the receiving team should record the accepted quantity and preserve the shortage. Closing a shipment operationally is not a substitute for the approved accounting resolution of an owned balance.
Review reversed or corrected receipts, especially near month-end. A later correction may change the evidence available after the original reconciliation. Preserve the review version and identify which period's conclusion needs reconsideration.
Create separate exception categories for expected transit, arrival awaiting receipt entry, unconfirmed ownership evidence, unmatched receipt, disputed shortage, and financial-value difference. Each category needs a different owner and next action.
An arrived-but-unrecorded delivery is primarily a receiving cutoff issue. A carrier-confirmed loss may require a claim and accounting assessment. A currency difference belongs with finance. Labeling all three as aged inventory hides the next step.
Set review intervals based on actual routes and business consequence. An international shipment taking several weeks may be normal, while a domestic delivery marked arrived yesterday may already need attention. Use expected milestones rather than an arbitrary universal aging threshold.
Before posting a correction, document the cause, affected records, proposed transaction, legitimate date, expected quantity effect, and expected financial effect. Obtain the responsible accountant's approval for accounts, periods, currency treatment, and any closed-period consequences.
Avoid unsupported clearing journals that leave the operational subledger unresolved. A journal can alter the GL without fixing a missing receipt or duplicate ownership quantity. If a journal is appropriate under policy, explain how the remaining operational record will be reconciled.
After processing, rerun the same population and verify both line detail and totals. Keep a reconciliation sign-off with unresolved items, owners, expected resolution dates, and materiality review. Do not mark an item complete because its container disappeared from a logistics dashboard.
Capture stable shipment-line identifiers at the start, require evidence before ownership processing, and record actual receiving promptly. Give logistics and finance a shared exception vocabulary while preserving their different responsibilities.
Sample recent closed shipments to verify that every owned quantity has a supported final disposition. Use recurring exceptions to improve the entry process rather than adding manual spreadsheet patches indefinitely.
CuriousRubik's NetSuite support services can be approached with the register, GL rollforward, and unmatched examples. The useful outcome is an explainable supplier in-transit balance with approved exception treatment.
No. Logistics status does not establish the posted ownership value or receipt clearing. Match the relevant posting records and shipment lines for the same subsidiary, book, currency basis, and accounting cutoff.
Keep them in a separate reconciliation population. Internal transfers and supplier inbound shipments use different transaction and ownership flows. Combine only through an explicitly designed summary that preserves each population's detail.
Partial quantities, unmatched receipts, date or period differences, corrections, or value components can leave a balance. Trace the actual related records and GL impact before deciding whether it is timing or an error.
It may change the GL while leaving the operational problem intact. Finance must approve any journal and explain how the shipment-line quantity and supporting transactions will also be resolved. Do not use a journal as an unexplained plug.
Retain the ownership posting, shipment-line identity, remaining quantity and value, latest logistics evidence, exception reason, accountable owner, and expected resolution. Finance should assess any material valuation or period-cutoff implications.