A costing method is an organization's strategy for collecting cost data to accurately determine the total cost and cost per unit of a finished product, whether it's a physical good or a service. The inventory costing method you choose in NetSuite plays a crucial role in how item costs are calculated. For instance, it impacts how NetSuite handles inventory cost calculations when the same item is purchased at different prices over time.
NetSuite offers several inventory costing methods, including:
Note: LIFO is not available in the NetSuite Australia (AU) edition.
Expanding a business often brings new challenges, especially when integrating additional subsidiaries with existing systems. One of our clients, a technology company, recently faced such a scenario. They had been successfully managing inventory costs using the standard average cost method across multiple subsidiaries. However, the introduction of a new subsidiary required a more nuanced approach. Specifically, they needed a single weighted average cost for each item, grouped by location within this new subsidiary—a need that deviated from their existing configurations and business practices. This case study explores how we addressed this requirement using Oracle NetSuite's group average costing method.
When managing inventory in NetSuite, the default costing method is the average costing method, which calculates costs by dividing the total units available during a specific period by the sum of the beginning inventory cost and the cost of additional inventory. However, there are some key aspects to keep in mind:
First, once a costing method is chosen during the creation of an item master, it becomes permanent and cannot be changed. Additionally, if inventory levels dip into the negative, NetSuite automatically uses the last purchase price as the costing method.
To better understand how different costing methods can impact inventory valuation, let’s explore a simple example:
Imagine it's Monday, and you've purchased 20 calculators at ₹10 each, adding them to your inventory. The next day, you buy another 20 calculators, but this time at ₹15 each. On Wednesday, you sell 5 calculators to a customer. How these calculators are recorded depends on the costing method:
It's also crucial to distinguish between average cost and group average cost. For example, if you purchase Item A from two different locations—Location X at ₹100 and Location Y at ₹200—the impact on inventory varies depending on the method:
This differentiation highlights how NetSuite's costing methods can significantly influence your inventory valuation strategy.
To meet the client's requirement of a single weighted average cost per item grouped by location within the new subsidiary, we implemented NetSuite's group average costing method. This configuration involves three main steps:
When using Multi-Location Inventory combined with Group Average Costing, it's important to regularly process account adjustments to maintain consistent item costs within costing groups. This ensures that location balance sheets accurately reflect group average cost items. By balancing location costing group accounts, NetSuite adjusts individual location inventory values to align with the group average cost.
The "Balance Location Costing Group Accounts" page enables you to periodically adjust location inventory accounts to match group average costs. This ensures that the inventory account balances are correctly aligned with the location quantity multiplied by the group average cost.
To keep location accounts consistent, NetSuite analyzes transactions at each location within a costing group and posts the necessary account variances. This process helps to balance accounts across all locations, taking rounding into consideration.
As shown in the accompanying diagram, without making these adjustments, costs across different locations may not align.
Refer to the image provided above for the following key details:
Note: When a transaction affects the inventory costing of a Group Average Cost item, NetSuite calculates an average cost across all locations within the costing group. This calculated group average cost is then applied uniformly to the item across all locations.
In the diagram, each location records the item at a different receiving cost:
For each specific location, the total in the inventory asset account is based on the location’s receiving cost, calculated by multiplying the receiving cost by the quantity received. This specific inventory asset cost may not match the group average cost, meaning the inventory value at a location may differ from the value calculated using the group average cost (location quantity multiplied by group average cost).
It’s important to note that the average cost can vary between locations and may differ from the Group Average Cost. NetSuite calculates the average cost as the account value divided by the quantity.
By using the Balance Location Costing Group Accounts page, you can make general ledger adjustments to ensure accounts are balanced across all locations.
Key Insights from the above diagram:
The Balance Location Costing Group Accounts page allows you to adjust inventory at the end of a selected period, such as at the close of a financial period. You can also perform these adjustments more frequently, such as on a weekly basis, to keep account balances up-to-date.
By implementing this approach, our client successfully integrated a new subsidiary into their existing NetSuite environment, maintaining accurate and consistent inventory costing across all locations. This case study demonstrates the flexibility and effectiveness of Oracle NetSuite's inventory costing methods in meeting complex business needs.
Oracle NetSuite offers robust capabilities for calculating weighted average costs in a location-specific manner, enhancing accuracy.
The system supports both configurations at the item level across the same or different subsidiaries, allowing for customized costing methods per location. This feature provides flexibility which is valuable for businesses with multiple subsidiaries requiring tailored costing methods.
We understand that this feature may be of interest to many organizations. Our team has extensive experienced in Oracle NetSuite implementation and can help you configure the system to meet your specific needs.