Picture this. You have been selling your hot sauce DTC out of your garage for 18 months. You know your product, you know your customers, and you have been tracking everything in a notebook and a Google Sheet that you update whenever you remember to. It has worked fine. Then a buyer from a regional grocery chain emails you. They want 200 units every four weeks. You also have your Shopify store running, a farmers market every Saturday, and a handful of restaurant accounts you have been building. You sit down to figure out whether you can actually fulfill all of this, and you realize you have no idea how much finished product you have on hand, how much of your key ingredient is left in the walk-in, or whether your next production run is scheduled before the first wholesale order ships.
That moment, right there, is when inventory management stops being a nice-to-have and becomes the thing standing between you and growth. This guide is written for founders in exactly that position. You do not need enterprise software. You do not need a warehouse management system. You need a clear, honest framework for what to track, how to track it, and when to upgrade your tools.
What Inventory Management Actually Means for a Small Food Brand
Most founders hear "inventory management" and immediately think of software, barcodes, and warehouse shelves with labels on everything. That is not what this is about, at least not yet. Inventory management, at its core, is simply knowing three things at any given moment: what you have, what you need to make, and when to reorder your ingredients. That is it. Everything else, the software, the lot numbers, the automated reorder points, is just infrastructure built on top of those three answers.
When you are under $1M in revenue, the goal is not to build a perfect system. The goal is to build a system that is accurate enough to make good decisions. Can you confirm a 200-unit wholesale order without overselling your DTC channel? Can you tell your co-packer how many cases to produce next week? Can you call your ingredient supplier and know exactly how many pounds of your main ingredient you need to order? If you can answer those questions confidently, your inventory management is working. If you cannot, it does not matter how many other things you are doing well.
The other thing worth saying upfront: inventory management is a habit before it is a system. The best spreadsheet in the world does not help you if you update it once a week and ship orders in between. The discipline of recording what comes in and what goes out, every time, is the foundation. The tools just make that discipline easier to maintain.
Inventory management is not about software. It is about knowing what you have, what you need to make, and when to reorder. Build the habit of recording every movement first. The tools come second.
The 3 Things Every Food Brand Needs to Track from Day One
You can build a very complicated inventory system, but if you are just starting out, focus on three things. Get these right and you will be ahead of most small food brands.
The first is finished goods on hand. This is the count of sellable, packaged units you have right now, broken down by SKU. Not what you made last month. Not what you expect to have after your next production run. What is physically in your possession today, ready to ship. This number needs to update every time you produce a batch and every time you fulfill an order. If you are selling across multiple channels, DTC, wholesale, and farmers market, you need one unified finished goods count, not a separate number for each channel. Running three separate counts is how you end up overselling.
The second is raw materials on hand. This is the quantity of each ingredient and packaging component you currently have in stock. For a simple food brand with five ingredients and two packaging components, this is seven line items. You update this number when you receive a new shipment from a supplier and when you consume materials in a production run. The reason this matters is that your finished goods number is only useful if you also know whether you can make more. Knowing you have 50 units on hand is not very helpful if you do not know whether you have enough ingredients to produce another 200.
The third is your production schedule. This is a simple log of planned and completed production runs: the date, the SKU, the quantity planned, the quantity actually produced, and the ingredients consumed. This is the bridge between your raw materials and your finished goods. Without it, you are always guessing at the relationship between what you have in storage and what you can ship.
Track three things from day one: finished goods on hand by SKU, raw materials on hand by ingredient, and your production schedule. Every other inventory metric is built on top of these three.
The Google Sheets Approach: What a Functional Inventory Spreadsheet Looks Like
A Google Sheet can absolutely run inventory for a food brand under $1M, as long as it is structured correctly and updated consistently. The mistake most founders make is building one giant tab with everything on it, which becomes impossible to maintain and easy to break. Instead, build a workbook with four dedicated tabs and keep each one focused.
Tab one is your Finished Goods Inventory. Columns should include SKU name, SKU code, current units on hand, units reserved for confirmed orders, units available to promise, and a notes field. The "available to promise" column is a formula: units on hand minus units reserved. This is the number you quote to buyers. Update this tab every time you complete a production run and every time you ship an order.
Tab two is your Raw Materials Inventory. Columns should include ingredient or component name, unit of measure (pounds, ounces, cases, rolls), quantity on hand, reorder point, preferred supplier, and last purchase price. The reorder point is the quantity at which you need to place a new order to avoid running out before the next shipment arrives. Calculate this based on how much you use per production run and how long your supplier takes to deliver. Update this tab every time you receive a shipment and every time you complete a production run.
Tab three is your Production Log. Each row is one production run. Columns should include date, SKU produced, batch number, planned quantity, actual quantity produced, and a column for each major ingredient showing how much was consumed. This tab is your record of what happened in production. It is also how you catch yield problems: if you planned to produce 200 units and only got 185, that variance needs an explanation.
Tab four is your Order Log. Each row is one order. Columns should include order date, channel (DTC, wholesale, farmers market), customer or account name, SKU, quantity ordered, quantity shipped, ship date, and status. This tab is how you make sure nothing falls through the cracks when you have orders coming in from multiple channels at once.
The update cadence matters as much as the structure. Commit to updating the spreadsheet at the point of each transaction. When a shipment of ingredients arrives, open the spreadsheet and update raw materials before you put the boxes away. When you finish a production run, log it before you move on. When you ship an order, mark it shipped. Two minutes of discipline at each transaction saves two hours of reconciliation at the end of the week.
| Tab | What It Tracks | When to Update |
|---|---|---|
| Finished Goods Inventory | Units on hand by SKU, reserved vs. available | After every production run and every shipment |
| Raw Materials Inventory | Ingredient quantities, reorder points, supplier info | After every inbound shipment and every production run |
| Production Log | Batch records, planned vs. actual yield, ingredients consumed | After every production run |
| Order Log | All orders across all channels, status, ship dates | When orders are placed and when they ship |
A four-tab Google Sheet covering finished goods, raw materials, production, and orders is enough to run a food brand under $1M. The structure matters less than the discipline of updating it at the point of every transaction.
When the Spreadsheet Breaks: 5 Signs You Have Outgrown Manual Tracking
Spreadsheets are not the enemy. They are a perfectly reasonable tool for a brand at an early stage. But there is a point at which the spreadsheet stops being an asset and starts being a liability. Here are the five signs that you have crossed that line. For a deeper look at this topic, see our full guide on signs your food brand has outgrown spreadsheets.
The first sign is that you have had a stockout or an overpromise in the last 90 days. If you have confirmed an order you could not fulfill, or run out of a SKU you did not know was low, your inventory data is not accurate enough to run your business on. That is not a discipline problem, it is a systems problem. The spreadsheet is not giving you the visibility you need.
The second sign is that you are spending more than two hours a week reconciling inventory. If you are manually cross-referencing your Shopify orders against your spreadsheet, then checking that against your production log, then calling your co-packer to confirm what they have on hand, you are doing the work that software should be doing for you.
The third sign is that you have more than three SKUs or more than two sales channels. Complexity multiplies quickly. Three SKUs across three channels is nine inventory positions to track. Add a second production location and you are at eighteen. Spreadsheets do not scale with complexity the way purpose-built software does.
The fourth sign is that you cannot calculate your actual COGS per unit without a significant manual effort. If you do not know what it cost you to produce the last batch, you do not know whether your pricing is working. Inventory and COGS are tightly linked, and a spreadsheet that tracks units but not costs is only doing half the job.
The fifth sign is that you are about to bring on a second person who needs access to the same inventory data. Shared Google Sheets with multiple editors are a recipe for version conflicts and overwritten data. The moment inventory becomes a team function, you need a system that handles concurrent access properly.
Ready to move beyond spreadsheets?
Guidance is built for food brands under $5M who need real inventory visibility without the complexity of an ERP. See how it works in 20 minutes.
Book a Free DemoWhat to Look for in Your First Inventory Software
When you are ready to move off spreadsheets, the temptation is to look for the most feature-rich system you can find. Resist that instinct. For a brand under $1M, the right software is the simplest software that covers your actual needs. A system with 200 features you will never use is not more valuable than a system with 20 features you will use every day. For a detailed comparison of your options, see our guide on ERP vs. inventory software for food brands.
Simplicity is the first criterion. Can you onboard yourself in a day? Can a part-time employee figure it out without a training manual? If the answer to either question is no, the software is too complex for where you are right now. You will spend more time managing the system than running your business.
Lot tracking is a non-negotiable. This is the one feature you should not compromise on, even at the smallest scale. Lot tracking means the software assigns a unique identifier to each batch of ingredients you receive and each production run you complete, and links those identifiers through to the finished goods you ship. If you ever need to run a recall, lot tracking is the difference between pulling 200 specific units and pulling your entire inventory. Most retail buyers will eventually require it as a condition of doing business with you. Build the habit now.
COGS calculation matters more than most founders realize at the early stage. If your inventory software can tell you what it cost to produce each batch, you can make real pricing decisions. If it only tracks units, you are still doing the cost math in a separate spreadsheet, which defeats part of the purpose of upgrading.
Co-packer support is worth checking even if you are not using a co-packer today. Many small brands move to a co-packer as they scale, and switching inventory systems mid-growth is painful. A system that handles co-packer production, including tracking materials sent to the co-packer and finished goods received back, will save you a significant amount of manual work when that transition happens.
When evaluating your first inventory software, prioritize simplicity, lot tracking, COGS calculation, and co-packer support. Features you will not use are not a benefit. They are friction.
Manual Workflow vs. Guidance Workflow: Preparing for a Wholesale Reorder
Here is what the same task looks like depending on whether you are running a spreadsheet or purpose-built software. The task: your wholesale buyer just confirmed their next 200-unit reorder, shipping in three weeks. You need to confirm you can fulfill it, figure out whether you need to run production, and check whether you need to order ingredients.
You open your finished goods tab and check the current count. You have 80 units on hand. You need 200. You open your order log to check whether any of those 80 are already reserved for DTC orders. You find 22 units reserved, leaving 58 available. You need to produce at least 142 more units, probably 160 to have a small buffer.
You open your raw materials tab to check ingredient quantities. You have enough of most ingredients, but your primary ingredient is low. You check your production log to calculate how much of that ingredient you use per batch. You do the math manually and determine you need to order more before you can run production. You email your supplier and wait for a response on lead time.
You open your production log and try to find an open date in the next two weeks. You realize you do not have a production calendar in the spreadsheet, so you check your personal calendar. You find a window, but you are not sure whether your co-packer is available. You send them an email. You now have two open email threads and a spreadsheet with numbers that will be wrong the moment anyone places a DTC order before you update it again.
Total time: 45 to 90 minutes, with follow-up required. Risk of error: high, especially if the spreadsheet was not updated after the last production run.
You open Guidance and navigate to the wholesale order. The system shows you current finished goods on hand, units already allocated to other orders, and your available-to-promise quantity in real time. You can see immediately that you need to produce 142 units to fulfill the order with a buffer.
You click through to production planning. Guidance shows you the bill of materials for the SKU and checks your current raw material quantities against what you need for the production run. It flags that your primary ingredient is below the required quantity and shows you the reorder quantity based on your supplier lead time. You submit a purchase order directly from the interface.
You schedule the production run in Guidance, which automatically reserves the required raw materials and updates your available-to-promise for all other channels. Your co-packer receives a production order notification. The wholesale order status updates to "production scheduled."
Total time: 8 to 12 minutes. Every channel sees the updated inventory position immediately. No email threads, no manual math, no risk of a stale spreadsheet causing an oversell.
The Most Common Inventory Mistakes Small Food Brands Make in Their First Two Years
Most inventory problems at the small brand stage are not complicated. They are the same handful of mistakes made over and over. Knowing what they are is most of the battle.
The most common mistake is tracking finished goods but not raw materials. Founders focus on what they can sell and forget to track what they need to make more. This leads to production delays because an ingredient ran out, which leads to stockouts, which leads to missed orders. Track both, always.
The second most common mistake is running separate inventory counts for each sales channel. Your Shopify inventory, your wholesale allocation, and your farmers market stock are not three separate inventories. They are one inventory with three demand streams. If you manage them separately, you will oversell. Manage one unified inventory and allocate from it.
The third mistake is not accounting for yield loss in production. If you plan to produce 200 units and your process has a 5% yield loss, you will actually produce 190. If you ordered ingredients for exactly 200 units, you are short. Build your expected yield loss into your production planning and your ingredient ordering. Over time, track your actual yield against your expected yield. A widening gap is an early warning sign of a process problem or an ingredient quality issue.
The fourth mistake is waiting until month-end to reconcile inventory. By the time you find the discrepancy, you cannot trace it back to a specific transaction. Reconcile continuously. Every transaction updates the record. If something does not add up, you find out the same day, not 30 days later.
The fifth mistake is not having a reorder point for each ingredient. A reorder point is the quantity at which you need to place a new order to avoid running out before the next delivery arrives. Without it, you are reordering based on gut feel, which means you will sometimes order too late and sometimes carry too much inventory. Calculate a reorder point for each ingredient based on your usage rate and your supplier lead time. Check it every time you update your raw materials inventory.
The five most common inventory mistakes are: tracking finished goods but not raw materials, running separate counts per channel, ignoring yield loss, waiting until month-end to reconcile, and not setting reorder points. Fix these five things and you will be ahead of most brands at your stage.
Frequently Asked Questions
Do I need inventory software if I am under $1M in revenue?
Not necessarily. A well-structured Google Sheet can handle inventory for a brand doing under $500K with one or two SKUs and a single sales channel. The moment you add a wholesale account, a second SKU, or a co-packer, the manual approach starts to break down. The real question is not revenue, it is complexity. If you are spending more than two hours a week reconciling inventory or you have had a stockout or an overpromise in the last 90 days, it is time to look at purpose-built software.
What is the difference between finished goods inventory and raw material inventory?
Finished goods are units that are packaged, labeled, and ready to ship. Raw materials are the ingredients and packaging components you have on hand before production. Both matter. If you only track finished goods, you will not know whether you can run another production batch until you physically check your storage. Tracking both lets you plan production before you run out of finished goods rather than after.
How do I handle inventory for a product I make at a co-packer?
Co-packer inventory is one of the hardest things to track manually. You need to know how much raw material you have sent to the co-packer, how much finished product they have produced, how much is sitting in their warehouse, and how much has been shipped to you or directly to a customer. At minimum, build a co-packer tab in your spreadsheet that tracks inbound shipments, production runs, and outbound shipments separately. Better yet, use software that has a co-packer module so you are not relying on email threads and PDF reports to know your inventory position.
What is lot tracking and do I need it as a small brand?
Lot tracking means assigning a unique identifier to each batch of ingredients you receive and each production run you complete, then linking those identifiers through to the finished goods you ship. It sounds like overkill when you are small, but it is the only way to run a targeted recall if you ever need to. If a contaminated ingredient lot affects 200 units, lot tracking tells you exactly which customers received those units. Without it, you are recalling everything. Most retailers and distributors will eventually require lot tracking as a condition of doing business with you.
How often should I update my inventory records?
Every time something moves. Every inbound shipment of ingredients, every production run, every outbound order. If you batch your updates to once a week, your inventory numbers are wrong for six out of seven days. That is fine when you are tiny and selling DTC only. It stops being fine the moment you have a wholesale buyer expecting a confirmed order quantity. Build the habit of updating inventory at the point of each transaction, even if that means a quick note on your phone that you enter later the same day.
Build the inventory foundation your brand needs to grow.
Guidance is purpose-built for food brands under $5M. Lot tracking, COGS calculation, co-packer support, and real-time inventory visibility, without the complexity of an ERP.
See Guidance in Action