Inventory Costing Methods

Knowledge Base · Inventory and Manufacturing

Applies to: All Supported Versions  |  Platform: Desktop & Cloud

Understanding how inventory costs are calculated is essential for accurate financial reporting and informed business decisions. Different inventory costing methods can significantly impact your cost of goods sold (COGS), gross profit, and taxable income.

This article provides an overview of the three inventory costing methods used in Connected:

1. First-In First-Out (FIFO)
2. Weighted Average
3. Specific Costing (extension of FIFO for Lot/Serial Controlled items only)

ARTICLE CONTENTS

1. FIFO (First In First Out)
2. Weighted Average
3. Specific Costing (FIFO Extension for Lot/Serial Control)
4. Costing Example
5. Related Articles

1. FIFO (First In First Out)

FIFO (First-In, First-Out) is the default inventory costing method in Connected. Under this approach, inventory is costed and depleted in the exact order it was received — meaning the oldest costs are applied first to outgoing items. This method closely mirrors the natural flow of inventory for many businesses, especially those handling perishable or time-sensitive goods.

FIFO provides a more precise view of your current inventory value, since it avoids cost blending and instead reflects actual purchase costs.

2. Weighted Average

The Weighted Average costing method blends the total cost of inventory with the total quantity available, resulting in a single "Average Cost" that is applied to all units. Rather than tracking the cost of individual items, this method smooths out cost variations by calculating an average every time inventory is received.

This method is best suited for businesses where inventory costs remain relatively stable over time.

3. Specific Costing (FIFO Extension for Lot/Serial Control)

Specific Costing is used exclusively for inventory items tracked by Lot or Serial numbers, allowing each unit to retain its exact purchase cost. While it follows the same structure as FIFO, it differs by letting specific items (and cost) be chosen for each transaction (Sales/Movement).

This method is ideal for high-value or regulated inventory where precise cost tracking is essential. It provides maximum transparency and control, especially useful when managing returns, warranties, or compliance requirements.

4. Costing Example

The following is a costing example that shows the movement in and out of inventory, using the different costing methods. In each case, the total cost on the invoice is much different, depending on the method used.

Inventory Received - Same Inventory Received with Different Costing Method Application Shown Below in the Invoice #125652 example

Invoice #125652  |  Date: 03/27/25  |  Qty 6 

5. Related Articles

• Handling Unexpected Inventory Cost Increases
• Inventory: Inventory Valuation Report
• Inventory Stock Adjustments
• Inventory Count Sheets and Inventory Adjustments
• Allocating Labor and/or Overhead to Manufactured Parts
• Manufacture - Custom Workflow Staging List