On-hand inventory at landed cost in Sage Intacct. The working-capital line on the balance sheet.
At a glance
Total on-hand inventory valued at the costing method configured on the Sage Intacct Inventory Item record (Average, Standard, FIFO, or LIFO depending on the Inventory Control or Inventory Management module the merchant has licensed). The working-capital line on the consolidated Balance Sheet across every entity in the Multi-Entity Console, with each unit dimension-tagged so the same total can be cut by Department, Location, Project, Item, Class, Customer, or Vendor without re-querying.
| What it counts | SUM(InventoryItem.QuantityOnHand × InventoryItem.UnitCost) for stocked items at every Warehouse / Location across every entity the connected API user can see. Sage Intacct’s Inventory Control module exposes per-item costing through the INVENTORY_TOTAL GL account class and the INVTOTAL smart event; the card respects the costing method configured per item. |
| Costing method | Sage Intacct supports Average, Standard, FIFO, and LIFO costing per item. Card uses whatever the Inventory Item record’s COSTMETHOD field dictates. Most US mid-market distributors run Average; manufacturers and lot-tracked goods often run FIFO or Standard. |
| Tax treatment | n/a, inventory is held at cost, no tax. |
| Shipping | Inbound landed cost included if the merchant uses Intacct’s Inventory Control landed-cost allocation (freight, duty, broker fees rolled into unit cost via Inventory Adjustment with the Landed Cost feature enabled). Without landed cost allocation, the card reflects supplier invoice cost only. |
| In-transit | Configurable. Stock received against a Purchase Order but not yet posted into a physical Warehouse appears in Transit Locations only when the merchant uses Intacct’s Inter-Entity Transfer or Goods-in-Transit workflows. |
| Drop-ship | Excluded. Drop-ship inventory is owned by the supplier in Intacct’s Order Entry drop-ship workflow, never hits the merchant’s Balance Sheet. |
| Currency | Multi-Entity Console: each entity holds inventory in its base currency, summed in reporting currency at the configured FX cadence (transaction-date, period-end, or period-average per the Currency Configuration). Single-entity accounts: native currency, no translation. |
| Entity scope | Card respects the dashboard entity filter. Default rolls across every entity the API user (Sender ID + User ID + password) can see. |
| Dimensional cut | Headline number; click any Intacct dimension chip in the Nerve Centre to drill: Department, Location, Project, Item, Class, Customer, Vendor, Employee. The Location dimension typically maps 1:1 to Intacct Warehouses on a distribution account. |
| Time window | RT |
| Alert trigger | None at headline; the Inventory Aging and Dead Stock Value cards carry alerts. |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your Sage data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US B2B distributor running Sage Intacct Multi-Entity Console with two regional entities (East Coast Distribution Inc, USD; West Coast Distribution Inc, USD) and a small Canadian fulfillment sub (CAD). Annual revenue ~$60M, mostly Net-30 wholesale through BigCommerce B2B and Adobe Commerce wholesale portal. Snapshot 14 Apr 26. Reporting currency USD. Costing method: Average across both US entities, FIFO on the lot-tracked Canadian sub.| Location (Intacct) | Entity | Items | Total value (USD) | Costing |
|---|---|---|---|---|
| Warehouse-NJ-Edison | East Coast | 6,840 | $11,420,000 | Average |
| Warehouse-NJ-Newark | East Coast | 2,180 | $3,140,000 | Average |
| Warehouse-CA-Ontario | West Coast | 5,920 | $9,860,000 | Average |
| Warehouse-WA-Kent | West Coast | 1,640 | $2,810,000 | Average |
| Warehouse-ON-Mississauga | Canadian sub | 1,840 | $1,920,000 | FIFO |
| In-transit (Goods in Transit, ocean) | East Coast | 720 | $1,180,000 | Average |
| Total Inventory Value | 19,140 | $30,330,000 |
- **60M revenue base it represents roughly 6 months of stock at full sell-through, materially above the 3 to 4 months a healthy mid-market distributor targets. The first conversation with the Implementation Partner is whether the costing method is producing a clean read or whether Standard-costing variances on the West Coast entity are bloating the headline; on this account the East Coast Average-cost basis is closer to economic reality. The second conversation is where the 6-month buffer came from. On most accounts it is a 2024-2025 supply-chain build that no merchandiser has unwound; the Controller cuts the same number by
Item.LastReceiptDateagainst the Inventory Aging card and the picture sharpens. - The Location dimension is the killer cut on Intacct. Five Warehouses across three entities, each surfaced as its own Location dimension on the GL detail. The same $30.33M can be re-cut in one click: by Department (East Coast Sales, West Coast Sales, Canadian Operations), by Project (capital-asset projects that have inventory carried as project stock), or by Class (brand or business-unit segmentation). NetSuite’s Class / Department / Location segmentation supports this conceptually but Intacct’s eight first-class dimensions tag every transaction line by default and query without saved-search engineering. For a Finance Controller who lives in Intacct daily, this is the headline difference; a Vortex IQ Implementation Partner conversation usually centres on how much of the dimension model the merchant has built out.
- In-transit at $1.18M is goods in containers en route from Asia. Stock received against a PO under Intacct’s Goods in Transit workflow but not yet posted into a physical Warehouse. The dollars sit on the consolidated Balance Sheet under Inventory but are not sellable yet. Most distribution accounts run a 4 to 8% in-transit ratio depending on container lead times; this account at 3.9% is on the leaner side. The number matters for treasury planning because in-transit dollars are committed cash that has not yet generated a Sales Order line.
- The East/West split (60/40 by dollar value) matches the geographic sales mix. When this ratio drifts, fulfilment lag follows: a 70/30 inventory split against a 50/50 sales split means West Coast customers are getting longer ship times because the East Coast warehouse is shipping into West Coast territory. Pair this card with the Open Order Value cut by Location dimension to confirm. On this account the Operations Manager has been chasing a quiet 2-week ship-time creep on West Coast B2B accounts; the inventory split-vs-demand split makes the cause visible.
- **The Canadian sub’s FIFO costing on 30.33M total because the GL aggregates dollar-cost regardless of underlying lot detail.
Sibling cards merchants should reference together
| Card | Why pair it with Total Inventory Value |
|---|---|
| Inventory Aging | Age buckets. Old stock is bad stock; the same total decomposed by days-on-hand. |
| Dead Stock Value | The hard-cut bad slice. Cuts the headline total to the cohort that has not moved in 180 days. |
| Inventory Carrying Cost | The annualised expense of holding the on-hand pool, typically 18 to 28% of inventory value. |
| Inventory Turnover Ratio | Health metric. COGS divided by average inventory; this card is the denominator. |
| Top SKUs by Inventory Value | Concentration. Pareto cut showing the SKUs that own the headline. |
| Low Stock Alerts | Forward fulfilment risk on items running thin. |
| Average Landed Cost per Unit | Cost trend. Whether the per-unit cost basis is rising. |
| OOS with Open Order Demand | Cross-channel mirror: this card is the on-hand pool, that card surfaces the demand the pool cannot fulfil. |
Reconciling against the vendor’s own dashboard
Where to look in Sage Intacct: The native Sage Intacct views to run side by side with this card:Reports → Inventory Control → Inventory Valuation Summary (the canonical valuation report at intacct.com) Reports → Inventory Control → Item Stock Status (real-time on-hand by Warehouse / Location) Reports → Financial → Balance Sheet (Inventory line, dimension-aware roll-up) Reports → Financial → Trial Balance with Dimensions (per-account, dimension-pivoted) Interactive Custom Report (ICR) built on the Inventory data source filtered to stocked items, summed onThe Inventory Valuation Summary is the gold-standard tie-out at intacct.com. The Balance Sheet Inventory line should match this card to within rounding when the entity scope and snapshot date are aligned. Most Implementation Partners build a saved ICR called something like “Inventory Tie-out, Consolidated” that reproduces the card’s logic against Intacct’s GL Detail; once built, it becomes the monthly month-end reconciliation report. Common reconciliation pitfalls:QuantityOnHand × UnitCost, pivoted by Location and Department dimensions Smart EventINVTOTALfor live on-hand snapshots (Inventory Control module only)
- Costing method mid-period change: if the merchant flips an item’s
COSTMETHODfrom Standard to Average mid-period, the card recomputes from the new basis at the next snapshot, while a historical Inventory Valuation Summary used the old basis. The headline can move 2 to 5% on a single item that bridges the change. - Per-entity Currency Configuration: Multi-Entity Console accounts: each entity’s inventory translates to reporting currency at the entity’s configured FX cadence (transaction-date, period-end, or period-average). A Balance Sheet run at the Top Level entity uses period-end FX, the card uses current-day FX; differences typically under 2%.
- In-transit inclusion: the Inventory Valuation Summary by default includes Goods in Transit if the merchant uses the Inventory Control Goods-in-Transit feature; the Balance Sheet inventory line includes them too. If the merchant uses Order Entry’s Inter-Entity Transfer workflow without Goods in Transit, the in-transit dollars sit in a clearing account and the card excludes them.
| Reason | Direction | Why |
|---|---|---|
| Costing method config change | Either | An item flipped from Standard to Average mid-period recomputes at the new basis. Card shows current; the Summary shows historical. |
| In-transit inclusion | Card may differ | Intacct’s Goods in Transit feature must be enabled for in-transit to appear in both the Summary and this card. If the merchant ships through Inter-Entity Transfer without GIT, the dollars sit in a clearing account that neither shows. |
| Multi-Entity Console eliminations | Card lower at Top Level | Inter-co inventory transfers eliminate at the Top Level entity. Per-entity views do not eliminate. |
| FX cadence per entity | Small | Each entity’s Currency Configuration sets translation cadence. Mismatch between the card’s snapshot and a one-off Balance Sheet read produces small differences. |
| Manufacturing WIP | Either | Intacct does not have a native manufacturing module; merchants using a third-party manufacturing connector (e.g. MRPeasy or Katana) carry WIP in a separate GL account. The card respects whatever Intacct tracks as Inventory; manufacturing WIP outside Intacct’s books is invisible. |
| Negative on-hand | Card excludes | Items posted into negative quantity (sale fulfilled before receipt processed) are treated as zero by the card; the Summary may show negative dollars. Once the receipt posts, both align. |
| Damaged / quarantine Locations | Either | Stock moved to a Location flagged Not Available for Sale is included if the Inventory record still tracks it as on-hand. Some Controllers prefer to exclude; the field map can carve this out. |
| Lot-tracked items on FIFO | Card matches | FIFO costing layers each lot at receipt cost; both the Summary and the card aggregate to the same dollar total. The diagnostic difference is at the lot level, not the headline. |
| Custom GL account mapping | Either | If the Chart of Accounts maps Inventory to a non-standard account (anything outside the 1300-1399 Inventory range, or a custom account class), confirm the field map captures it. |
| Card | Relationship | Why |
|---|---|---|
| shopify.inventory_value | Different definition | Shopify’s variant-level cost is a single static field that rarely tracks landed cost. Use Intacct as the source of truth for working-capital reporting; Shopify’s cost is the on-platform display value. |
| bigcommerce.inventory_value | Same caveat | BigCommerce variant cost is per-variant, landed cost rarely reflected. |
| adobe_commerce.inventory_value | Different definition | Adobe Commerce Multi-Source Inventory shows on-hand by source (warehouse), often pulled from Intacct via a connector; the Intacct number is the ground truth. |
| Inventory Sync Drift | Diagnostic pair | Cross-connector card surfaces SKUs where Intacct on-hand and commerce-platform on-hand have drifted apart, the leading indicator that this card and the commerce-platform inventory views will disagree. |
Known limitations / merchant FAQs
What’s a healthy inventory ratio? Wholesale distribution: 3 to 4 months of COGS. Apparel and fashion: 3 to 5 months. Industrial distribution: 4 to 8 months (longer cycles are normal). Food and beverage non-perishable: 1 to 2 months. SaaS and services-led businesses on Intacct: typically less than $500K of inventory total because the product is intangible, so this card is not load-bearing. Compare to your own 12-month rolling baseline first; absolute ratios mislead across categories. Average vs FIFO vs Standard, which is “right”? Whatever your accounting policy says. Sage Intacct supports all four (Average, Standard, FIFO, LIFO). The card uses whatever each Inventory Item record’sCOSTMETHOD field dictates. Average is the most common across mid-market commerce on Intacct; FIFO is preferred for lot-tracked perishables and regulated goods; Standard is common for distribution where a periodic standard-cost roll is part of the close cadence. The Implementation Partner usually picked the method on day one based on tax and audit policy.
Sage Intacct vs NetSuite on this metric, what’s different?
Arithmetic is identical: on-hand quantity times unit cost, summed across locations and entities. Where Intacct shines is the dimensional cut: the same headline can be sliced by Department, Location, Project, Item, Class, Customer, Vendor, or Employee in one click because every inventory transaction is dimension-tagged at posting. NetSuite has Class / Department / Location segmentation, but Intacct’s eight first-class dimensions tag every line by default and query without saved-search engineering. For a Finance team that lives in dimensions, this is the daily difference. For pure stock-on-hand reporting the answer is identical.
Sage Intacct vs Sage 50 / 100 / 200 / X3 on this metric?
Different products. This connector targets Sage Intacct only (US mid-market cloud financials with dimensional accounting). Sage 50 and Sage 100 are SMB desktop products with a much simpler costing model, no Multi-Entity Console, and no first-class dimensions. Sage 200 is a UK / EU SMB product. Sage X3 is a different mid-market ERP with deeper manufacturing and process-industry support. The arithmetic is conceptually similar across all of them but the API, dimensions, and reconciliation paths differ. If you are running Sage 50 / 100 / 200 / X3, reach out about connector availability.
Multi-Entity Console: how does FX work on this card?
Each entity holds its inventory in its own base currency. The consolidation translates to the Top Level reporting currency (typically USD on a US-headquartered account) at the configured cadence per entity. The Currency Configuration in Intacct sets cadence per entity: transaction-date for goods movement, period-end for Balance Sheet revaluation, period-average for Income Statement translation. Inventory uses period-end by default; the card snapshots at current-day FX which is closest to economic reality. Differences typically under 2% in normal market conditions, larger if FX has moved sharply between the snapshot day and the most recent period-end revaluation.
REST vs XML API, does it matter for this card?
No effect on the number. Sage Intacct exposes inventory through both APIs. The XML API (the long-standing Smart Events and List queries) is the workhorse for bulk inventory reads and runs faster on large item catalogues; the REST API is preferred for single-item reads and webhooks. Vortex IQ’s connector uses XML for the bulk valuation read (typically a single query against INVENTORY_TOTAL) and REST for incremental refresh on item changes. Freshness on the card is typically 5 to 15 minutes from the most recent Intacct transaction.
Why is Total Inventory rising while sales are flat?
Three usual causes on a US distribution account: (1) over-ordering from suppliers, often a 2024-2025 supply-chain build that nobody has unwound; (2) demand drop on previously-fast SKUs, which surfaces on Inventory Aging as a bulge in the 91-180 bucket; (3) longer lead times causing safety stock to balloon, particularly on overseas Asian sources where 90-day lead times have become structural. Drill via Inventory Aging and Dead Stock Value.
Manufacturing WIP, included?
Excluded by default. Sage Intacct does not have a native manufacturing module; merchants running production carry WIP through a third-party connector (MRPeasy, Katana, Fishbowl) or a custom Inventory Control workflow. The card includes whatever Intacct’s Inventory Item records track as on-hand at any Location. WIP held outside Intacct (inside the manufacturing system) does not appear in this card; the merchant runs a separate WIP report there.
Lot and serial-numbered items, do they read differently?
Yes if the costing method is FIFO or LIFO. Each lot or serial carries its receipt cost as a separate cost layer; the card aggregates to the dollar total. For Average-cost items the lot detail is invisible at the card level. Lot-level views are valuable for perishables, pharma, food, and regulated cosmetics where lot traceability is a compliance requirement; the card surfaces the headline, the lot detail lives in Intacct’s Inventory Item record drill-down.
Stock revaluation impact?
Intacct’s Inventory Adjustment workflow can revalue stock through the Inventory Control module’s price-update or recosting features. After a revaluation the card respects the new basis; the historical period’s value (locked in a closed period) stays at the original basis. Auditors expect to see revaluation entries during year-end review; the card surfaces the post-revaluation total and the Margin Erosion Alerts card flags any per-SKU margin movements that revaluation caused.
Multi-Entity Console: per-entity vs consolidated view, which to use?
Both. The consolidated Top Level view is the boardroom and audit number. Per-entity views are operational: a Controller managing the West Coast entity wants to see West Coast inventory separately, the Operations Manager managing the Canadian sub wants the Canadian-only cut. The card respects the dashboard entity filter; the same query produces both views and the Implementation Partner usually pins both as separate Nerve Centre tabs.
Vendor-managed inventory (VMI), does it count?
Depends on title. If the supplier holds title until consumption (true VMI), the stock is not on the merchant’s Balance Sheet and not in this card; Intacct typically tracks it on a memo Location flagged “VMI, not owned”. If the merchant holds title from receipt (consigned-in), the stock is on-hand and the card includes it. Confirm with the auditor and the Implementation Partner; the field map respects whichever convention is configured.
Implementation Partner role on this metric?
Most Sage Intacct merchants are paired with an Intacct-certified Implementation Partner (often a regional accounting firm or VAR). The Partner typically owns the Inventory Control module setup, the Chart of Accounts mapping for the 1300-1399 Inventory range, the dimension structure on Inventory Items, and the saved ICR library. If this card returns a different number from the Partner’s monthly board pack, the cause is almost always (1) a costing method change captured by one side and not the other, (2) a Goods-in-Transit configuration discrepancy, or (3) a per-entity FX cadence mismatch. Vortex IQ’s field map is the place to align; the Partner is the right person to invite into the conversation.