How Landed Cost Distribution Works
Landed cost distribution begins when a company receives purchased goods and identifies the additional expenses associated with acquiring them. The accounting team gathers supporting documents, determines which costs belong to the shipment, and allocates those costs to the appropriate inventory items according to the applicable system functionality and company policy.
For example, a distributor may receive a shipment of products accompanied by a supplier invoice and a separate freight bill. The supplier invoice records the goods' purchase price, while the freight bill represents another cost of obtaining the inventory. Allocating the eligible freight expense across the received items gives the company a more complete view of inventory cost.
Common allocation bases include item value, quantity, weight, or volume. The appropriate basis depends on the nature of the expense. Weight may be appropriate for freight charges driven by shipment mass, while item value may suit charges calculated as a percentage of merchandise value. Users should confirm which allocation bases Sage 100 supports in their specific configuration.
Calculating Landed Cost Distribution
A practical allocation method distributes a shipment-level expense according to each item's share of the selected allocation base. When allocating freight by item value, the calculation is:
Item's allocated freight = Total freight cost × (Item purchase value ÷ Total purchase value)
Suppose a shipment contains two inventory items. Item A has a purchase value of $6,000, and Item B has a purchase value of $4,000. The total purchase value is $10,000, and the freight charge is $500.
- Item A: $500 × ($6,000 ÷ $10,000) = $300.
- Item B: $500 × ($4,000 ÷ $10,000) = $200.
The allocated freight totals $500, matching the original charge. Item A's landed cost becomes $6,300, and Item B's becomes $4,200, assuming freight is the only additional eligible cost and all amounts relate to the same shipment. This example illustrates value-based allocation; a different basis may be more appropriate when costs depend on weight, volume, or quantity.
Key Records and Accounting Considerations
Reliable landed cost distribution depends on accurate purchase orders, receiving records, vendor invoices, and additional expense documents. Teams should link each charge to the shipment or receipt it relates to and confirm that the allocated amount agrees with supporting documentation.
- Purchase order and receipt: Identify the items and quantities acquired.
- Supplier invoice: Establishes the merchandise cost and the supplier's billed amount.
- Freight and duty documents: Support additional charges eligible for allocation.
- Allocation basis: Defines how shared costs are assigned across inventory items.
- Inventory and general ledger records: Support reconciliation between the costs recorded in the system and the accounting balances.
Landed cost distribution should follow the company's accounting policy and applicable accounting standards. The treatment of freight, duties, handling charges, and other expenses depends on the circumstances and whether the costs qualify for inclusion in inventory. Finance teams should also confirm how Sage 100 handles posting, adjustments, and any differences between estimated and final charges.
How Distribution Supports Purchasing and Financial Reporting
Accurate landed costs help businesses evaluate supplier offers, set selling prices, assess product profitability, and understand inventory investment. A product with a low supplier price may have a higher final cost after freight and other eligible charges. Reviewing the full cost helps buyers compare alternatives on a consistent basis.
Clear purchase order controls establish who can authorize orders, how supplier terms are recorded, and how received quantities are verified. The guide Purpose of Purchase Order Process: Business Outcomes Guide examines how purchase orders, approvals, and procurement controls support spend visibility. Likewise, Spotting Vendor Payment Term Deviations Before They Cost You addresses the importance of comparing actual supplier invoices and payment timing with agreed terms, which helps finance teams plan cash outflows.
Businesses extending finance workflows around an ERP should also understand Cloud ERP for Wholesale Distribution: 2025 Deep-Dive Guide, which discusses ERP capabilities in wholesale distribution. Where separate finance applications are involved, Sage Intacct Integration describes the connection between Sage Intacct and other systems; it is distinct from Sage 100 and should not be treated as a native Sage 100 feature.
Automation and Controls for Cost Allocation
Technology can support the collection, review, and reconciliation of landed cost information. The Hyperbots Platform supports company-specific configurations across ERP integrations, workflows, roles, and general ledger structures. Its Process Specific Capabilities address finance workflows with process-oriented AI, while Ready to Deploy Capabilities describe prebuilt agents and ERP connectors that can be configured for relevant finance tasks.
Self Learning Capabilities describe how AI workflows can adapt from human feedback, and Human in the Loop emphasizes review and approval when transactions require additional judgment. These concepts are relevant when a business designs controls for validating freight invoices, checking allocation evidence, and routing exceptions to the appropriate finance team.
Before introducing automation, businesses should define the allocation rules, approval thresholds, and reconciliation requirements. Maximize Finance ROI with AI Automation Insights explores ways to measure the financial and operational outcomes of finance automation. The relevant measures may include processing time, allocation accuracy, reconciliation effort, and the timeliness of inventory cost updates.
Within accounts payable, Invoice Distribution describes how invoice amounts are assigned across relevant accounting destinations. Although invoice distribution and landed cost distribution are related through accounting workflows, they are not interchangeable: landed cost distribution specifically allocates eligible acquisition costs to inventory or received goods.
Best Practices for Accurate Landed Cost Distribution
Finance and inventory teams can improve consistency by establishing a documented procedure for identifying eligible costs, selecting allocation bases, and reviewing the resulting values.
- Match additional charges to the correct purchase receipt or shipment.
- Choose allocation methods that reflect the reason the expense was incurred.
- Reconcile allocated amounts to the original freight, duty, and handling documents.
- Review cost adjustments when final invoices differ from initial estimates.
- Maintain an audit trail of source documents, allocation decisions, and approvals.
- Reconcile inventory valuation and general ledger balances after posting.
These practices help ensure that inventory costs remain traceable and that purchasing, inventory management, and financial reporting teams use consistent information.
Summary
Sage 100 Landed Cost Distribution allocates eligible acquisition expenses across purchased inventory so businesses can understand the full cost of receiving goods. Accurate source documents, appropriate allocation methods, consistent approval procedures, and regular reconciliations support dependable inventory valuation and profitability analysis. Because available functionality varies by Sage 100 version and configuration, companies should verify their system's specific capabilities and follow their established accounting policies when distributing landed costs.