Kyle Moloney
Procurement & Operations | 10+ Years
Kyle has spent over a decade managing procurement and operations for manufacturing companies ranging from small food producers to mid-size contract manufacturers. He now writes about practical inventory management, supply chain, and production operations.
A single "total inventory value" number is useful for a quick check-in, but it hides the question most multi-brand or multi-site manufacturers actually need answered: value of *what*, sitting *where*. Nstock's finance reports now answer both — a Finished Goods by Brand breakdown, and an optional Warehouse filter, on the reports that carry inventory valuation.
Finished Goods by Brand
If your company manufactures under more than one brand — private label plus your own line, or several product lines with separate identities — a single blended finished goods number can't tell you which brand is actually carrying the inventory investment. Nstock's Inventory Valuation report now includes a Finished Goods by Brand table alongside the usual Raw Materials / Finished Goods / Total breakdown.
This uses the Brand field on each finished good's Master Product — an optional field you can set per product. Every finished good lot with a matching SKU rolls up into its product's brand; anything without a brand set is grouped separately as "Unbranded / Not Set" rather than silently dropped from the total, so the numbers still reconcile even before every product has a brand assigned.
Filtering by Warehouse
For companies running more than one physical location, Nstock's raw material and finished goods lots already carry a Warehouse field. The Inventory Valuation report now surfaces every warehouse in use as a filter — pick one, and the whole report (raw materials, finished goods, and the brand breakdown) recalculates scoped to just that location. Leave it on "All Warehouses" and nothing changes from before.
This is genuinely optional, matching how the feature was built: a single-location manufacturer will never see the warehouse filter do anything interesting, and a multi-site manufacturer gets a way to answer "how much is tied up at the East Coast facility specifically?" without exporting raw data and filtering it by hand.
Both, on the Monthly Report Too
The same two breakdowns are captured on the Monthly Inventory Report — the frozen, point-in-time snapshot generated automatically for every closed month. Each row in that report can now expand to show the brand and warehouse breakdown for that specific month, not just the live valuation. That means a brand or location trend isn't just something you can check today — it's preserved permanently, month over month, the same way the rest of the Monthly Report is.
Snapshots generated before this feature shipped won't have a breakdown to show (there's nothing to expand), but every month going forward will.
Why This Matters for Finance
- Brand-level P&L accuracy. If different brands are tracked separately for profitability, a blended finished-goods number understates or overstates any single brand's true carrying cost. The brand breakdown gives finance the real per-brand figure without a manual SKU-by-SKU sort.
- Site-level cash tied up. For companies with more than one warehouse, knowing how much value sits at each location matters for decisions like consolidating a facility, negotiating site-specific insurance, or deciding where to prioritize a cycle count.
- Catching an imbalance early. A brand whose finished goods value is climbing much faster than its sales would suggest — or a warehouse quietly accumulating far more value than its throughput justifies — is exactly the kind of thing a blended total hides and a segmented report surfaces immediately.
Watch for This
If a "Unbranded / Not Set" line in the brand breakdown is larger than any real brand's line, it usually means Brand isn't being set consistently when new finished goods are added — worth a quick pass through Master Products to fill it in, since every unbranded lot is invisible to brand-level reporting until then.
Frequently Asked Questions
Do I have to set a Brand or Warehouse to use these reports?
No. Both fields are optional. Without them, the reports work exactly as before — a single blended total, no warehouse filter shown.
Does this affect the numbers reported anywhere else, like COGS or QuickBooks?
No. This is a display breakdown of the same valuation figures already being calculated — it doesn't change the total, and it doesn't change what gets posted through the QuickBooks integration.
Can I filter by warehouse on reports other than Inventory Valuation?
Not yet — the warehouse filter currently lives on the Inventory Valuation report, with the same breakdown carried through to the Monthly Inventory Report's historical snapshots.
Next Steps
Set the Brand field on your finished goods Master Products and the Warehouse field on your inventory lots if you haven't already, then check the Inventory Valuation tab under Reports → Finance to see the breakdowns. For the bigger picture on what the Monthly Report captures each month, read Monthly Inventory Report Explained.
Start your free trial → — already have an account? Log in and find these breakdowns under Reports → Finance → Inventory Valuation.
— Kyle Moloney, Procurement & Operations