Sarah Chen
Manufacturing Operations Consultant | 8 Years
Sarah specializes in production workflow optimization and inventory systems for electronics and contract manufacturers. She has helped 30+ manufacturing teams transition off spreadsheets and into modern inventory systems.
Ask five people in a manufacturing business what "inventory value" was at the end of last month, and you might get five different numbers — one from a live dashboard checked at a random moment, one from a spreadsheet someone updated three weeks ago, one from memory. Nstock's Monthly Inventory Report exists to make that question have exactly one answer.
What It Actually Calculates
The Monthly Inventory Report is a frozen, point-in-time ending inventory value for each closed month, generated automatically on the 1st of the following month once the prior month is finalized. Each row shows one closed period, broken into:
- Raw Materials value — the total cost of raw material lots on hand at the instant the month closed.
- Finished Goods value — the total cost of finished product on hand at that same instant.
- Total value — the sum of the two.
It uses the same cost basis as Nstock's live Inventory Valuation view — recorded lot cost, with no labor or overhead absorption baked into finished goods — but where the live view changes every time inventory moves, the Monthly Report is locked the moment it's generated. It won't drift if someone adjusts a lot, corrects a count, or receives a late shipment after the fact — it reflects exactly what was true at the last instant of that month, permanently. Each closed month's row can also expand to show a brand and warehouse breakdown of that same value — see Finance Reports by Brand and Warehouse for how that segmentation works.
Why It Freezes Instead of Staying Live
A live valuation number is genuinely useful for day-to-day decisions — it tells you what's on hand right now. It's a poor fit for closing the books, because "right now" keeps moving. If your accountant pulls a valuation number on the 3rd and your bookkeeper pulls one on the 9th, they won't match, even if nothing looks obviously wrong — inventory simply moved in between.
The Monthly Report solves this by freezing. Once the report generates for a closed month, that number is the number for that month, permanently. Anyone who needs last month's ending inventory value — finance, an auditor, a lender — gets the same figure regardless of when they ask.
Why a Finance or Ops Person Would Check It
- Closing the books. It's the exact figure that should land on the balance sheet as ending inventory for a closed period — no reconciliation needed between "what operations says" and "what the books say," because it's the same number.
- Feeding automated postings. If you've connected Nstock to QuickBooks, the monthly inventory journal entry is built from this same frozen snapshot — it's the number that gets posted, not a separate estimate.
- Trend-spotting. Because each closed month has its own permanent row, you can scan several months side by side and see whether raw materials or finished goods value is creeping up or down — a slow build in finished goods value, for instance, often means production is outpacing sales.
- Feeding turnover calculations. Nstock's Inventory Turnover Ratio report uses the closest available Monthly Report to the start and end of whatever period you're measuring — the more months of history you have, the more accurate that ratio gets.
Watch for This
A finished goods value that keeps climbing month over month while raw materials value stays flat or falls is worth investigating before it becomes a cash problem. It usually means you're producing faster than you're selling — inventory is quietly building on the shelf, tying up cash that already went out the door to buy raw materials, with no offsetting sale yet to show for it. Caught early from a couple of Monthly Reports side by side, it's a production-planning conversation. Caught late, it's a write-off conversation — see the Inventory Aging Report for how to spot the same problem from a different angle, by how long stock has actually been sitting rather than just its total value.
What It Doesn't Include
The Monthly Report covers on-hand raw materials and finished goods only — it doesn't include the value of materials currently consumed into active production batches (see WIP Valuation Explained for where that value sits instead), and it doesn't include future spend you've committed to but haven't received yet (see Open Purchase Commitments). Between the three reports, you get a complete picture: what's on the shelf, what's mid-production, and what's coming.
Frequently Asked Questions
When does the first report generate?
Automatically, on the 1st of the month following your first fully closed month in Nstock. Until then, use the live Inventory Valuation view for a real-time snapshot — it just won't be frozen.
Can I export it?
Yes, as a CSV with period, raw materials value, finished goods value, and total value columns — useful for handing straight to a bookkeeper or pasting into a working file.
What cost basis does it use for finished goods?
Recorded lot cost only — no labor or overhead absorption. If your finished goods costing needs to reflect labor and overhead for external reporting, treat this as the materials-cost component of that larger number, not the whole of it.
Does correcting an inventory count after the month closes update a past report?
No. Once a month's report is generated, it stays frozen at what was true at that instant — that's the entire point. A later correction affects the current live valuation and future months' reports, not the historical one.
Next Steps
The Monthly Inventory Report is the foundation several other finance reports build on — turnover, and (indirectly) the picture aging and WIP fill in around it. If you're syncing to QuickBooks, this is also the number behind your monthly journal entry; see QuickBooks Online Integration: Sync Inventory Value to Your Books for how that connects, or How to Connect QuickBooks Online to Nstock if you haven't set it up yet. For the cost-basis decision behind the number itself, read FIFO vs. Average Cost for Manufacturers.
Start your free trial → — already have an account? Log in and find your Monthly Inventory Report under Reports → Finance.
— Sarah Chen, Manufacturing Operations Consultant