For finance teams at CPG companies, the end of the month often means a frantic scramble. You’re tasked with stitching together data from spreadsheets, warehouse systems, and sales platforms just to figure out your inventory's true value. This process is slow, manual, and guarantees you’re always looking backward. But this delay is a system problem, not a business necessity. We’ll explore how to connect your operations directly to your financials, allowing you to manage your inventory financial asset with continuous clarity and move beyond the outdated cycle of month-end reconciliation.
At any given moment, a significant portion of an inventory-based business’s capital is tied up in its physical stock. It’s on the balance sheet, it affects margins, and it determines working capital and cash flow. By every practical definition, inventory is a financial asset, yet most systems treat it like a logistics problem.
Unlike other financial assets, whose value is closely tracked in real time, inventory's value becomes visible only after everything’s been reconciled and translated into financial terms. This baked-in visibility gap leads to delayed decisions, mispriced products, and a woefully inefficient use of working capital.
To be sure, inventory is more operationally complex than cash or receivables, but that inherent complexity is what makes real-time visibility more important, not less. Inventory value constantly changes throughout its lifecycle: A purchase order establishes a good’s expected cost; freight, duties, and fees reshape that cost as it moves through the supply chain; and warehouse receipts determine when inventory becomes available. When value is continuously shaped (and reshaped) by ongoing events, any delay in visibility means leaders are operating on an outdated picture of the business.
We’ve accepted this periodic-based approach because it emerged in a previous technological era, when surfacing the real-time value of physical goods in a complex system was completely infeasible. But fast forward to today, and new innovations have opened the door to a granular, contemporaneous understanding of a long-obscured part of the business. What follows is a closer look at where the traditional model breaks down, how technology is shifting expectations, and what treating inventory as a true financial asset looks like in practice.
How systems break inventory’s financial reality
In most organizations, data that defines inventory value is scattered across multiple systems: ERP systems record financial outcomes, but typically only after transactions are finalized. WMS systems track physical movement, but not its financial implications. Ecommerce platforms capture sales. Freight invoices arrive days (or sometimes weeks) later. Purchase orders often live in spreadsheets.
Each system captures a piece of the story. None captures the whole. The result is fragmentation, where costs arrive asynchronously, data is stored in different formats, and finance teams are left to stitch everything together at the end of the month. This disparate approach leads to a familiar set of problems: delayed visibility, manual reconciliation, and financial truth that’s assembled rather than observed.
The consequences of this piecemeal approach can extend beyond accounting. Margins are often unclear until weeks after the underlying activity occurs. Inventory valuation lags behind reality. Working capital decisions are made based on numbers that are already outdated. Leaders are effectively managing one of their most important assets without ever seeing it clearly.
This problem persists because most financial systems were built as separate, specialized systems, each responsible for a different part of the process, with manual workflows acting as the bridge between them. Over time, that model became normalized. In other words, the architecture itself assumed delay.
If the problem is rooted in how systems are designed, then the solution isn’t to make reconciliation faster; it’s to rethink the model entirely.
BLOG: Why Month-End Close Shouldn’t Exist (At Least Not Like This)
Treating your inventory as a real-time financial asset
A shift to real-time insights for physical goods has become possible thanks to a suite of modern innovations. Namely:
- Event-driven architectures make it possible to capture operational changes as they occur.
- Real-time data pipelines and streaming infrastructure ensure that events are processed immediately rather than in batches.
- Cloud-native systems provide the scalability needed to continuously recompute inventory value as new data arrives.
- Modern data models allow operational and financial data to live in the same system instead of being fragmented across multiple tools.
Together, these technologies are moving us from delayed reconciliation to continuous financial visibility, where inventory value is always current and directly tied to what’s happening in the business.
In this new model, financial data is no longer calculated at the end of some arbitrary period. It evolves continuously as the business operates, with every operational event immediately reflected in clear financial terms. The result is a fundamentally different paradigm where financial reality is always current and, perhaps most importantly, leaders can respond to what’s happening in the business right now, not what was. This isn’t a mere accounting improvement; it’s a decision-making advantage.
A recent episode of the BlueOcean by StartOps podcast previewed the future of inventory management
The future of inventory management is now
This is exactly why we built Mandrel. Not to make month-end close faster or reconciliation more efficient, but to eliminate the need to reconstruct financial reality in the first place. Traditional systems assume delay, fragmentation, and manual translation between operations and finance. Mandrel is designed around a different assumption: that financial reality should be visible as the business operates.
By capturing operational events as they happen and continuously translating them into financial outcomes, Mandrel allows inventory to be treated as what it actually is: a living financial asset. Value is always current. Margins are always visible. And decisions can be made with confidence in the moment, not weeks after the fact.
This isn’t just a better way to manage inventory. It’s a fundamentally different way to run an inventory-based business.
Understanding inventory's role on the balance sheet
Before we can manage inventory effectively, we need to understand its financial identity. On your company's balance sheet, inventory is listed as a "current asset." This classification is important because it defines inventory as something your business owns that is expected to be converted into cash within one year. It’s not just a collection of boxes on a shelf; it’s a significant financial resource that directly impacts your company’s liquidity and overall health. Thinking of inventory this way shifts the perspective from a purely operational challenge to a critical financial one, where every unit holds tangible value and potential profit.
Inventory as a current asset
So, what exactly makes inventory a current asset? The term "current" in accounting refers to assets that are expected to be sold, used, or exhausted through normal business operations within one operating cycle, which is typically a year. Your inventory fits this description perfectly because the entire point of holding it is to sell it to customers for revenue. Until that sale happens, the money you spent to acquire or produce those goods remains locked up in the inventory itself, sitting on your balance sheet as a value you own, just like cash in the bank or accounts receivable.
How inventory becomes an expense: The cost of goods sold (COGS)
Here’s where things get interesting. Inventory doesn’t stay an asset forever. The moment you sell a product, its cost undergoes a transformation. It moves off the balance sheet (where it was an asset) and onto the income statement, where it becomes an expense known as the Cost of Goods Sold (COGS). This is a critical accounting event because it’s the point where you officially recognize the cost associated with generating revenue. Getting this timing and value right is fundamental to accurate financial reporting, as COGS is the primary determinant of your gross profit and, ultimately, your net income.
The COGS formula explained
To calculate COGS for a specific period, you use a straightforward formula: Starting Inventory + Purchases – Ending Inventory. Let’s break that down. You begin with the value of inventory you had at the start of the period. Then, you add the cost of any new inventory you purchased or produced. Finally, you subtract the value of the inventory you have left at the end of the period. The result is the total cost of the specific goods you sold during that time. This calculation is the backbone of your income statement.
The financial impact of inventory valuation
The method you choose to value your inventory isn't just an administrative detail—it has a direct and significant impact on your financial statements. Different valuation methods, like FIFO or LIFO, can change the calculated value of your COGS and ending inventory. This, in turn, affects your reported gross profit, net income, and the total asset value on your balance sheet. For example, during a period of rising costs, one method might make your company look more profitable, while another could offer tax advantages. Choosing the right method and applying it consistently is crucial for accurate and reliable financial reporting.
Your inventory is an asset, no matter where it's stored
A common point of confusion for modern CPG brands is how to account for inventory that isn't physically in their possession. Whether your products are stored in a third-party logistics (3PL) warehouse, sitting in an Amazon FBA center, or in transit between locations, they are still your asset. As long as you retain ownership of the goods, their value belongs on your balance sheet. This is why having a centralized system that can track inventory across multiple locations is non-negotiable for getting an accurate, real-time picture of your company’s assets.
The different types of inventory you manage
When we talk about "inventory," it’s easy to picture a warehouse full of finished products ready to ship. But for many businesses, especially those that manufacture their own goods, inventory is a more complex category. It exists in several different stages, and each stage represents a different level of investment and proximity to a final sale. Understanding these distinctions is key because each type of inventory carries different financial implications and requires a unique management approach. Properly classifying your inventory helps you track costs more accurately and provides a clearer view of where your capital is being used in the production cycle.
Inventory for sale
This is the broadest category, encompassing all the goods you hold that are intended to be sold to customers. It represents the entire journey of a product from its most basic components to the final item a customer receives. For a CPG brand, this could include everything from bulk ingredients to packaged and labeled goods sitting on a pallet. Tracking these different stages separately is essential for understanding your production costs, identifying bottlenecks, and managing your supply chain efficiently. Each sub-category within this group has its own unique characteristics and role in your operations.
Raw materials
Raw materials are the foundational components used to create your products. Think of them as the ingredients in a recipe. For a coffee company, this would be unroasted coffee beans, sugar, and packaging materials. For a skincare brand, it might be shea butter, essential oils, and glass jars. These materials have been purchased but have not yet entered the production process. Their value on the balance sheet includes the purchase price plus any costs incurred to get them to your facility, like freight and import duties.
Work-in-progress (WIP)
Work-in-progress (or WIP) inventory consists of raw materials that have begun the transformation into finished goods but are not yet complete. This is the "in-between" stage. For our coffee company, WIP would be beans that have been roasted but not yet ground or packaged. For the skincare brand, it might be a batch of lotion that has been mixed but not yet poured into individual bottles. The value of WIP inventory includes the cost of the raw materials plus any labor and overhead costs that have been applied during production so far.
Finished goods
Finished goods are the final products that are complete and ready for sale. These are the items your customers see and buy. Following our examples, this would be the packaged bags of coffee or the bottled and labeled skincare products sitting in your warehouse. The value of finished goods represents the total accumulated cost of raw materials, labor, and overhead that went into producing them. This is the final value of the inventory asset before it is sold and becomes Cost of Goods Sold.
Internal inventory assets
Beyond the products you sell, businesses also hold inventory for internal use. This category, often called MRO (Maintenance, Repair, and Operating) supplies, includes items that are necessary for running your business but are not sold to customers. Examples include shipping boxes, cleaning supplies, machine lubricants, and office supplies. While they don't generate revenue directly, they are still assets that need to be tracked and managed, as their costs can add up and impact your overall profitability.
How to value your inventory asset
Once you know what inventory you have, the next step is to assign a dollar value to it. This process, known as inventory valuation, is essential for calculating COGS and determining the value of your ending inventory on the balance sheet. The challenge is that the cost to purchase or produce inventory often changes over time. If you bought the same item at three different prices during a quarter, which cost do you use when one of them sells? Accountants have developed several methods to address this, and the one you choose can have a real impact on your financial statements.
First-in, first-out (FIFO)
The First-In, First-Out (FIFO) method operates on a simple, logical assumption: the first inventory items you purchase are the first ones you sell. This mirrors the physical flow of goods for many businesses, especially those dealing with perishable items. During periods of rising prices, FIFO results in a lower COGS (because you're expensing the older, cheaper costs first) and a higher net income. Consequently, your ending inventory on the balance sheet is valued at the most recent, higher costs, which can present a stronger financial position.
Last-in, first-out (LIFO)
Last-In, First-Out (LIFO) is the opposite of FIFO. It assumes that the most recently acquired inventory items are the first ones to be sold. This method doesn't always match the actual physical flow of goods, but it can be useful for financial reporting. In an inflationary environment, LIFO matches the most recent, higher costs against current revenues, which results in a higher COGS and lower reported net income. The primary benefit here is a potential reduction in income tax liability. It's worth noting that LIFO is permitted under U.S. GAAP but is banned by International Financial Reporting Standards (IFRS).
Weighted average cost
If FIFO and LIFO represent two extremes, the weighted average cost (WAC) method finds a middle ground. This approach smooths out price fluctuations by calculating the average cost of all similar items in inventory and applying that average cost to both COGS and ending inventory. To find the WAC, you divide the total cost of all goods available for sale by the total number of units. This method is simpler to apply than FIFO or LIFO and provides a valuation that isn't skewed by unusually high or low prices from a specific purchase.
Systems and controls for accurate inventory management
Treating inventory as a financial asset is one thing; ensuring its value is accurate is another. Without robust systems and internal controls, your balance sheet could be based on guesswork. Strong inventory management relies on two pillars: a reliable tracking system to record movements and strong processes to prevent loss and ensure data integrity. These controls are your defense against errors, theft, and damage, and they are fundamental to producing financial reports that you and your stakeholders can trust. Ultimately, the goal is to create a system where your recorded inventory perfectly matches your physical stock at all times.
Choosing an inventory tracking system
The foundation of any good control system is the tool you use to track inventory. This is your central source of truth for what you own, where it is, and how much it's worth. The right system provides the visibility needed to make smart purchasing, pricing, and sales decisions. For growing businesses, the choice of tracking system is a critical one, often marking the transition from reactive problem-solving to proactive, data-driven management. The options range from simple manual methods to sophisticated, automated software platforms.
Manual methods: Pen-and-paper and spreadsheets
When a business is just starting out, it’s common to track inventory manually using a simple spreadsheet or even a physical ledger. These methods are inexpensive and easy to set up. However, they are also prone to human error, provide no real-time updates, and become incredibly cumbersome as your business grows. Relying on spreadsheets for something as critical as your largest asset is a risky proposition. A single typo or formula error can throw off your financial statements and lead to poor decisions based on faulty data.
Automated systems: Inventory management software
As a business scales, it becomes essential to adopt an automated system. Inventory management software, or even better, an AI-native ERP, is designed to handle complexity and eliminate manual errors. These systems can track inventory in real time across multiple locations, automate purchase orders, and integrate directly with your sales channels and accounting software. The best platforms go a step further by unifying operational events with financial data, providing a continuously updated, SKU-level view of your inventory's true value without the need for end-of-month reconciliation.
Essential internal controls for inventory
Beyond your tracking system, you need a set of procedures—known as internal controls—to protect your inventory asset and ensure the accuracy of your records. These are the practical, on-the-ground rules and processes that govern how inventory is handled, counted, and recorded. Strong controls reduce the risk of shrinkage (loss due to theft, fraud, or error) and help you maintain confidence in your financial data. According to guidelines from Cornell University, an accurate physical inventory is critical because it directly impacts reported profits and the overall picture of financial health.
Physical security and access control
The most basic control is securing your physical inventory. This means storing products in a locked, controlled-access area, like a warehouse or stockroom. Limiting access to authorized personnel helps prevent theft and reduces the chance of items being misplaced or damaged. For high-value items, you might implement additional security measures like surveillance cameras or more stringent access logs. It’s a simple but highly effective way to protect one of your company’s most valuable assets.
Reconciling records with physical and cycle counts
Your inventory system is only as good as the data in it. To ensure accuracy, you must regularly compare your system records to what’s actually on your shelves. This is done through physical inventory counts. A full physical count, often done annually, involves counting every single item you have in stock. A more modern and less disruptive approach is cycle counting, where you count small, specific sections of your inventory on a rotating, continuous basis. This helps you spot and correct discrepancies much faster.
Ensuring accuracy with a three-way match process
A crucial accounting control for inventory is the three-way match. This process is used to verify a vendor invoice before paying it. It involves matching three documents: the purchase order (what you ordered), the receiving report or packing slip (what you received), and the vendor invoice (what you were billed for). If all three documents align, you can confidently pay the invoice, knowing you’re paying the right price for the goods you actually received. Automating this process can save countless hours and prevent costly payment errors.
What to do with inventory discrepancies
No matter how good your controls are, discrepancies will occasionally happen. You might find more or less stock on the shelf than your system indicates. When this occurs, the first step is to investigate the cause. Was it a receiving error, a misplaced item, or a potential theft? Once you understand the reason, you need to make an inventory adjustment in your system to reflect the physical reality. This adjustment will typically result in a write-off that hits your income statement as an expense, directly impacting your profitability.
The financial risks and metrics of holding inventory
While inventory is an asset, it’s not a risk-free one. In fact, it’s one of the riskiest assets a company can hold. Every dollar tied up in inventory is a dollar that can’t be used for other business activities, like marketing or product development. Furthermore, inventory is susceptible to a host of problems, from becoming obsolete to being lost or damaged. Managing these risks effectively requires a deep understanding of not just the costs, but also the key performance indicators (KPIs) that tell you how efficiently you’re managing this critical asset.
The hidden costs of holding inventory
The cost of inventory goes far beyond its initial purchase price. There are numerous "holding costs" or "carrying costs" associated with every item you keep in stock. These include the cost of the capital tied up in the inventory, storage costs for warehouse space, insurance to protect against loss, labor costs for handling and managing the stock, and taxes. These hidden costs can add up quickly, eating into your margins if inventory sits for too long. A common estimate is that holding costs can represent 20-30% of your inventory's value annually.
Protecting your asset from obsolescence and shrinkage
Two of the biggest financial risks associated with inventory are obsolescence and shrinkage. Obsolescence occurs when an item becomes unsellable, perhaps because it’s expired, out of season, or replaced by a newer model. This often requires a significant write-down, turning a valuable asset into a total loss. Shrinkage refers to the loss of inventory due to theft, damage, or administrative errors. Both risks directly reduce your inventory asset's value and hurt your bottom line, making proactive management and strong controls essential.
Key metrics for measuring inventory performance
To manage inventory effectively, you need to measure your performance. A few key metrics can give you powerful insights into how well you are converting your inventory into cash. These KPIs help you identify trends, spot potential problems, and make more informed decisions about purchasing and sales strategies. Regularly tracking these numbers is fundamental to maintaining a healthy cash flow and maximizing the return on your inventory investment. They tell the story of how efficiently your business is operating.
Inventory turnover
The inventory turnover ratio is a primary measure of inventory management efficiency. It calculates how many times your company sells and replaces its inventory over a specific period. You can find it by dividing your Cost of Goods Sold by your average inventory. A higher turnover ratio is generally better, as it indicates you are selling products quickly and not tying up too much capital in stagnant stock. A low turnover, on the other hand, can signal weak sales or over-purchasing.
Days inventory outstanding (DIO)
Days Inventory Outstanding (DIO) is another critical metric that reframes the turnover ratio into a more intuitive number: the average number of days it takes to sell your entire inventory. It’s calculated by dividing your average inventory by your Cost of Goods Sold and multiplying the result by 365. A lower DIO is preferable, as it means your cash is converting from inventory back to cash more quickly. Tracking DIO helps you manage cash flow and avoid the risks associated with holding inventory for too long.
Moving from static records to real-time intelligence
The traditional approach to inventory accounting is like trying to manage your business by looking at last month's photos. You only see where you've been, not where you are right now. This baked-in delay means critical decisions about pricing, purchasing, and working capital are based on outdated information. The shift to real-time intelligence changes this entirely. Instead of waiting for a month-end close to reconcile everything, you get a continuous, live view of your inventory's financial value. Every movement and cost adjustment is reflected as it happens, transforming inventory from a static number on a report into a dynamic, understandable financial asset.
Connecting inventory data to financial workflows
This real-time view is possible when you stop treating operational and financial data as separate streams. In most companies, inventory data is fragmented across a WMS, an ecommerce platform, and various spreadsheets, while financial outcomes live in the ERP. The magic happens when you connect these dots automatically. A modern, AI-native ERP acts as a unified system where an operational event—like a warehouse receiving a shipment—instantly triggers the corresponding financial workflow. This eliminates the manual work of stitching data together and ensures that your financial reality is always in sync with your physical operations, giving you an accurate, up-to-the-minute picture of your margins and asset value.
Related articles
- Why Month-End Close Shouldn’t Exist (At Least Not Like This)
- What “AI-Native ERP” Actually Means (And What It Doesn’t)
- Spreadsheets, IMS, or ERP? The Architecture Question Most Brands Miss
- SKU-Level Economics: What Your Gross Margin Isn’t Telling You
- Landed Costs: Not Just Another Financial Metric
Frequently asked questions
Why can't my current ERP system give me a real-time view of my inventory's value? Most traditional ERP systems were designed to be systems of record, not real-time processors. They are great at logging financial outcomes after a transaction is complete, but they weren't built to continuously pull in and make sense of operational data as it happens. The information that determines your inventory's true value, like freight invoices, warehouse receipts, and purchase orders, often lives in separate systems or spreadsheets. Your ERP only sees the final numbers after your team manually pieces everything together.
Is "real-time" inventory management just about getting reports faster? Not at all. It's less about the speed of reporting and more about the quality of your decision-making. When you operate on data that's weeks old, you're always reacting to the past. A real-time view allows you to be proactive. You can adjust pricing based on the actual landed cost of your most recent shipment, not an estimate from last quarter. You can manage cash flow with a precise understanding of your assets today, not what they were a month ago. It shifts inventory management from a reactive accounting task to a strategic, in-the-moment business function.
How does treating inventory as a financial asset actually improve my company's profitability? It gives you a true, SKU-level understanding of your margins as they evolve. When you know the exact landed cost of every item the moment it's received, you can price your products more intelligently and protect your margins from unexpected fees. This approach also helps you avoid tying up precious cash in slow-moving stock because you can identify trends much faster. By reducing the risk of obsolescence and minimizing hidden holding costs, you directly impact your bottom line.
My business is growing, but we still use spreadsheets. When is the right time to switch to an automated system? The best time to switch is the moment your spreadsheets start creating more problems than they solve. A few warning signs are when you consistently find errors in your counts, when your team spends days reconciling data for the month-end close, or when you make purchasing decisions based on a "gut feeling" because the real data is too difficult to assemble. The risk of one significant formula error in a spreadsheet can easily lead to a costly mistake that would have more than paid for a proper system.
What's the first practical step I can take to start treating my inventory more like a financial asset? A great place to start is by improving your internal controls and measurement. You can implement a cycle counting program, where you regularly count small, specific sections of your inventory instead of doing one massive annual count. This is far less disruptive and helps you catch and correct discrepancies much faster. At the same time, begin diligently tracking key metrics like inventory turnover and days inventory outstanding (DIO). This will give you a clear baseline for your inventory's financial performance and highlight areas for improvement.
Key Takeaways
- View inventory as a core financial asset: Stop treating inventory as just a logistical challenge. Recognizing it as a primary financial asset on your balance sheet changes how you make decisions about working capital, pricing, and profitability.
- Connect operations to financials in real time: The delay in understanding your inventory's value is caused by fragmented systems. By using a unified platform that translates operational events into financial data as they happen, you can eliminate the need for month-end reconciliation.
- Protect your asset with controls and KPIs: Safeguard your inventory's value through practical controls like physical counts and the three-way match process. Then, measure your efficiency by tracking key performance indicators like inventory turnover and DIO to ensure your capital is working for you.
