How to Track Food Inventory Without Expensive Software
Most small food businesses do not need a £200-a-month ERP system to manage their ingredients. What they do need is a reliable, consistent method that matches the size and complexity of their operation — whether that is a paper sheet on a clipboard, a Google Sheets tracker on their phone, or lightweight purpose-built software. This guide covers all the options, honestly, so you can pick what fits and get started today.
Why food inventory tracking matters
Ask most small food business owners where their money goes, and they will give you a rough answer about ingredients. Ask them to be precise — what did you spend on flour last month, how much did you waste, how much did you over-order — and the answer becomes much vaguer. That vagueness is where money disappears.
Running out of a key ingredient mid-production is the most visible problem. You either stop production, send someone out to pay retail prices, or substitute an ingredient and compromise the product. Any of these outcomes costs you time, money, or quality — and they can all be traced back to not knowing your stock levels before production began.
Over-ordering is the less visible problem but often the more expensive one. If you always order more than you need to avoid running out, you carry excess stock that ties up cash, takes up storage space, and — for perishable ingredients — eventually goes to waste. Many small food businesses run on thin margins precisely because they have developed a habit of over-ordering as a substitute for actually knowing what they need.
There is also a recipe costing dimension. You cannot know your true food cost per unit unless you know what ingredients went into that unit — not just what the recipe says should have gone in, but what was actually used. If your flour usage is higher than the recipe predicts, either the recipe is wrong, someone is over-portioning, or you are losing flour to waste. Without tracking, you cannot know which — and you cannot fix it.
Finally, inventory tracking is the foundation of ordering intelligently. When you know how much of each ingredient you typically use per week, and what your current stock level is, your orders become precise rather than approximate. You stop buying the same ingredient twice in a week because you forgot what was in the storeroom. You stop letting expensive vanilla extract go out of date because you ordered twice as much as you needed.
What inventory tracking actually involves
Before picking a method, it helps to understand what inventory management actually consists of. There are three core activities, and any system — paper or software — must address all three.
Counting stock means knowing what you currently have on hand. You count the physical quantities of each ingredient in your storeroom, fridge, and freezer. This gives you a snapshot of current stock levels. Without counting, everything else is guesswork.
Recording usage means tracking what goes out of stock — what you actually used in production, and what was wasted. This is where most simple systems break down, because recording usage requires someone to actively note what they use, not just what they start and end with. Without usage data, you can count stock but you cannot understand why it went up or down.
Ordering is the output of the first two activities. When you know your current stock and your typical weekly usage, you can calculate what you need to order to reach your target stock level before your next delivery.
Beyond these three activities, inventory systems differ on a key dimension: whether they are periodic or perpetual. A periodic inventory system involves counting stock at fixed intervals — once a week, once a month — and not tracking usage between counts. A perpetual inventory system tracks every transaction — every delivery in, every ingredient used — to maintain a running real-time stock count.
For most small food businesses, a weekly periodic system is the right starting point. A perpetual system requires recording every ingredient use, which is impractical without software automation. A periodic weekly count, done consistently, gives you enough data to order intelligently and spot trends. Once your operation grows or you have software that can automate stock deductions when you log production batches, shifting to a perpetual approach becomes worthwhile.
Method 1: The paper stock sheet
The simplest possible inventory system is a printed or handwritten sheet on a clipboard — one row per ingredient, columns for the count at the start of the week and the count at the end. Nothing else is required to get started.
A basic paper stock sheet has these columns: ingredient name, unit of measure, opening stock (Monday), closing stock (Friday or Sunday), variance (the difference — what was used or wasted this week), and a reorder flag column where you circle or tick items that need ordering. You can add a minimum stock column to make the reorder decision automatic: if closing stock drops below minimum, you order.
The appeal of a paper sheet is frictionlessness. There is nothing to log into, nothing to update, no battery to run out. If your storeroom has a clipboard on the wall, you can count stock in five minutes by walking the shelves and writing numbers. The sheet accumulates over weeks, giving you a handwritten record of usage history that is surprisingly useful for spotting patterns.
The limitations are equally clear. A paper sheet does not automatically calculate your order quantities — you have to do the maths yourself. It does not link to your recipes, so there is no way to automatically deduct ingredients when you bake a batch. It is not shareable — if two people are using the storeroom, whoever forgets to update the sheet will leave the record inaccurate. And there is no search, no history accessible from your phone, and no way to generate a report for your accountant.
Paper stock sheets work well for very small operations with fewer than 20 ingredients, a single person managing the stock, and a simple weekly production rhythm. They are also a good starting point when you are setting up stock tracking for the first time — the discipline of counting and recording on paper establishes habits that transfer directly to a spreadsheet or software later.
Method 2: Google Sheets inventory tracker
Google Sheets is the step up from paper that most small food businesses reach for first, and for good reason. It is free, accessible from a phone or tablet in the kitchen, shareable with anyone who needs to view or update stock, and capable of performing the calculations that a paper sheet cannot.
Setting up a Google Sheets inventory tracker takes one to two hours. The structure that works best for a small food business has these columns: ingredient name, unit, current stock, minimum stock, reorder point (the stock level at which you place an order — usually slightly above minimum to account for lead time), supplier, cost per unit, and total value (current stock multiplied by cost per unit, calculated automatically). An additional column for last updated date is useful for catching stale data.
The most useful feature to add is conditional formatting. Set a rule that highlights any row in amber when current stock drops below reorder point, and in red when it drops below minimum stock. Then your weekly stock count involves nothing more than updating the current stock column — the sheet tells you instantly which items need attention.
You can extend the basic sheet with a delivery log tab (recording deliveries in and updating the current stock column), a waste log tab (recording waste events — more on this below), and a weekly snapshot tab that captures a copy of the current stock count each week, giving you a historical record you can review to spot usage patterns.
The limitations of a Google Sheets tracker are real. Like a paper sheet, it must be updated manually — if someone forgets to update the sheet after using an ingredient, the data becomes inaccurate. It does not link to your recipes, so producing a batch does not automatically deduct ingredients from stock. And as your ingredient list grows past 40–50 items, the manual update burden grows with it. Multiple people updating the same sheet simultaneously can cause data conflicts. For a business with two or more people accessing the storeroom regularly, a spreadsheet starts to show its limitations faster than you might expect.
Method 3: A simple recipe-linked spreadsheet
A step beyond the basic stock tracker is a spreadsheet that links your recipes to your ingredient database. This is more complex to set up but gives you a running picture of theoretical ingredient usage — useful for catching variances between what you should have used and what actually disappeared.
The structure involves two tabs: one for your ingredient stock (as described above), and one for your recipes. Each recipe row lists the ingredients used and their quantities per batch. When you produce a batch, you note it in a production log and the spreadsheet automatically deducts the ingredient quantities from your stock tab using VLOOKUP or SUMIF formulas.
In practice, this approach works for businesses with a small, stable recipe list and the patience to build and maintain the formulas. For a bakery producing the same five or six products each week, a recipe-linked spreadsheet can function as a lightweight perpetual inventory system — keeping the stock tab current as you log production rather than requiring a manual update for every ingredient used.
Where this breaks down is the moment things get complicated. Sub-recipes — a pastry cream used in three different products, a spice blend used across multiple recipes — require nested lookups that are difficult to maintain. Recipe changes require updating the recipe tab and checking that all the formula references still work. And the system still requires someone to manually log each production batch. If that discipline slips for even a day or two, the stock data becomes unreliable and the whole edifice loses its value.
Think of the recipe-linked spreadsheet as a bridge between basic tracking and purpose-built software. It is worth building if you are comfortable with spreadsheet formulas and have a stable recipe set. If your recipes change frequently or you have more than 20–25 recipes, the maintenance burden quickly outweighs the benefit — and that is when software starts to make sense.
Method 4: Lightweight software (not as expensive as you think)
The phrase "inventory software" conjures images of enterprise ERPs — six-figure implementations, dedicated IT staff, months of setup, and monthly costs that would fund a part-time employee. That is not the kind of software being discussed here.
Lightweight food business software designed for small operators starts from around £19 per month and takes hours, not weeks, to set up. The key capability that distinguishes it from a spreadsheet is the link between your recipe database and your inventory: when you log a production batch, the system automatically deducts the correct quantity of each ingredient from your stock count. You stop manually updating stock after every bake.
When evaluating lightweight software for inventory tracking, look for four things. First, an ingredient database that stores your ingredients with units, costs, suppliers, and stock levels. Second, recipe linkage — the ability to build recipes from your ingredient database so that production logging automatically updates stock. Third, low-stock alerts — the system should notify you when any ingredient drops below your minimum stock level, without you having to check manually. Fourth, a purchase order or reorder workflow that helps you generate orders based on current stock and usage patterns.
FoodCore's kitchen management software covers all of these at the £19–55/month price point. The Essentials plan handles up to 50 recipes with full ingredient tracking; the Core plan removes the recipe limit and adds order tracking. Both plans link recipe costs to ingredient prices, so your recipe costing updates automatically when supplier prices change. You can start a 7-day free trial at signup.foodcore.io with no card required — enough time to build your ingredient database, enter a few recipes, and see whether the workflow fits your kitchen.
The FIFO principle: why stock rotation matters for accuracy and safety
Any discussion of food inventory tracking needs to include FIFO — First In, First Out — because it is the principle that makes inventory tracking useful in practice, not just on paper.
FIFO means using the oldest stock first. New deliveries go to the back of the shelf or freezer; existing stock stays at the front and is used first. This is not just common sense — it is the operational discipline that keeps your stock accurate and your food safe.
Implementing FIFO in a small kitchen requires two habits: labelling and placement. Every delivery should be labelled with its delivery date — a simple sticky label or date stamp is sufficient. When storing the delivery, place new stock behind existing stock. When pulling stock for production, always take from the front. These habits take a few weeks to become automatic and then require almost no conscious effort to maintain.
Date-labelled stock also makes stock counts faster and more accurate. When you count stock at the end of the week, you can see immediately whether any items are approaching their use-by date and plan to use them first in the coming week's production. Without date labels, you are guessing — and that guessing often results in discovering expired stock at the back of a shelf that could have been used if it had been noticed sooner.
The weekly stock take routine
Whatever method you use — paper, spreadsheet, or software — the weekly stock take is the discipline that makes it work. Without a regular, consistent count, any inventory system becomes a theoretical exercise.
The best time for a weekly stock take depends on your production schedule. Most small food businesses find that counting stock at the end of the last production day of the week (Friday afternoon, for example) or first thing on the first production day of the following week (Monday morning, before any production begins) works best. The goal is to count at a consistent time when stock is at a predictable point in the production cycle — not mid-week when deliveries may have arrived but not been used yet, and not right before a delivery when levels are at their lowest.
For a small operation with fewer than 50 ingredients, a weekly stock take should take no more than 20–30 minutes if the storage areas are well-organised. Walk your storeroom, fridge, and freezer with your clipboard or phone, count each ingredient, and record the number. That is it. If a stock take is taking longer than 30 minutes, the problem is usually organisational — ingredients stored in multiple locations, unlabelled stock, or a disorganised storeroom — rather than a problem with the tracking method itself.
After counting, compare this week's closing stock to last week's. The difference, adjusted for any deliveries received during the week, tells you how much of each ingredient you used. Compare that to your recipe-level usage (what the recipe says you should have used, multiplied by the number of batches produced). If actual usage significantly exceeds theoretical usage, you have a variance to investigate — over-portioning, waste, theft, or a recipe that does not reflect what is actually being made.
Discipline is the only thing that makes a weekly stock take valuable. Doing it fifty weeks a year, consistently, at the same time, is worth more than any particular method or tool. The data accumulates into usage patterns, seasonal trends, and a record of what your business actually consumes — information that is genuinely useful for ordering, pricing, and planning.
Tracking ingredient waste separately
A stock take tells you what you started with and what you ended with. It does not tell you what happened in between — whether the reduction in flour stock was from production, waste, or an uncounted delivery. To understand your waste, you need a waste log.
A waste log is a simple record: date, ingredient, quantity wasted, reason, and estimated cost. The reason categories that matter most for a small food business are spoilage (the ingredient expired or deteriorated before you could use it), trim waste (preparation waste — carrot peelings, pastry offcuts, the heel of a bread loaf), overproduction waste (you made more of a product than sold and had to discard it), and failed batches (a batch that did not meet quality standards and could not be sold).
Review your waste log monthly, not daily. The goal is to identify patterns. If you are consistently wasting the same ingredient — say, fresh cream or berries — you are almost certainly over-ordering it. If a particular failed batch category keeps appearing, there is a production quality issue worth addressing. If trim waste from a specific ingredient is high, there may be a more efficient preparation method or a way to use that waste in another product.
The waste log does not need to be elaborate. A notebook in the kitchen with a pen on a string is sufficient. The important thing is that recording waste becomes a habit — something that happens immediately when an ingredient is discarded, not at the end of the week when the details have been forgotten. Even an imprecise waste log, maintained consistently, will reveal insights that a stock take alone cannot provide.
When simple methods break down
Paper sheets and spreadsheets are the right starting point for most small food businesses. But there are predictable points at which they stop working well enough to be worth persisting with.
The first signal is when updating the tracker falls behind. If the spreadsheet is not being updated daily, the stock data is unreliable — and unreliable data is worse than no data, because it gives you false confidence. When you notice that the spreadsheet is routinely three or four days out of date, that is not a discipline problem to solve with more effort — it is a signal that the manual process is too burdensome for your operation and a more automated system is needed.
The second signal is when multiple people need to update the same stock record. A paper sheet cannot handle concurrent users. A shared Google Sheet can, but it is clumsy — two people trying to update the same row at the same time will create conflicts. Software designed for multi-user access handles this cleanly.
The third signal is when your ingredient list grows past 40–50 items. Below that threshold, a spreadsheet is manageable. Above it, the manual update burden becomes significant and errors accumulate. If your weekly stock take is taking over an hour, the method has outgrown your operation.
The fourth signal is when recipe changes make manual tracking impossible. If you are regularly updating recipes — tweaking ingredient quantities, substituting suppliers, adding new products — keeping a recipe-linked spreadsheet accurate requires constant maintenance that most small operators cannot sustain. Software that stores recipes and automatically links them to inventory makes recipe changes trivial: update the recipe once, and all future production logs use the new quantities.
Recipe costing versus inventory tracking
These two disciplines are related but distinct, and confusing them leads to gaps in both. Recipe costing is about what a recipe should use — the theoretical ingredient quantities per unit, at what cost, giving you a theoretical cost per unit produced. Inventory tracking is about what you actually used — the real ingredient consumption across a period, including waste, over-portioning, and losses that never made it into a finished product.
The gap between theoretical usage (from recipe costing) and actual usage (from inventory tracking) is your variance. Variance is one of the most important metrics in a small food business because it tells you whether your recipe costs are accurate, whether portioning is consistent, and where waste is occurring. A business with no variance measurement is operating with unknown food costs — the recipe might say the croissant costs £0.42 to produce, but if actual ingredient consumption per croissant is 20% higher than the recipe predicts, the real cost is closer to £0.50, and the business is pricing and planning based on a fiction.
This is why the best inventory tracking systems for food businesses are also recipe-linked. When producing a batch, you log it against the relevant recipe, and the system calculates both the theoretical ingredient usage (from the recipe) and updates the actual stock (which you count at the end of the period). The comparison between the two reveals variance. See our guide on what bakery management software you actually need for more on how recipe costing and inventory tracking work together in practice.
Comparison: inventory tracking methods at a glance
Getting started: a practical first step
The best system is the one you will actually use. If you have never tracked inventory before, do not start by building a complex recipe-linked spreadsheet. Start with a paper sheet — or a single-tab Google Sheet — covering your top 15–20 ingredients by spend. Count them this week. Count them again next week. See what changed. That simple act of weekly counting, done consistently, will immediately reveal things about your business that you did not know: which ingredients you are burning through faster than expected, which are sitting untouched, where you might be over-ordering.
Once the habit is established, expand the ingredient list, add reorder flags, and consider adding a waste log tab. When the manual maintenance starts to feel burdensome — when you find yourself avoiding the update because it takes too long — that is the right moment to evaluate software. Not before. The discipline of tracking comes first; the tool that makes it easier comes second.
When you are ready to look at software, start with FoodCore's free trial at signup.foodcore.io. You can import your ingredient list, build your recipes, and see your stock linked to your production workflow within a few hours. The comparison between manual methods and a properly integrated system will be immediately obvious. For a broader look at what kitchen software can do for a small food business, see our guide on kitchen management software.
Frequently asked questions
Do small food businesses need inventory software?
Not necessarily — many small food businesses manage inventory adequately with a paper sheet or a simple Google Sheets tracker. The question is not whether you need software, but whether your current method is causing you problems: running out of ingredients unexpectedly, over-ordering and wasting money, or spending too long each week manually updating stock records. If any of those are happening, lightweight software (from £19/month) will quickly pay for itself. If your operation is small enough that a paper sheet takes 15 minutes a week and works reliably, that may be sufficient for now.
What is the best free food inventory spreadsheet?
A simple Google Sheets template with columns for ingredient name, unit, current stock, minimum stock, reorder point, supplier, and cost per unit — with conditional formatting to highlight low stock items in red — is usually the most effective free option. Google Sheets has the advantage of being accessible from a phone in the kitchen. The limitation is that it must be updated manually and does not link to your recipes, so you cannot automatically deduct stock when you produce a batch. For a bakery with fewer than 20–30 ingredients, this is a perfectly workable starting point.
How often should I do a stock take for a small bakery?
Weekly is the right frequency for most small bakeries — typically at the end of the working week or first thing Monday morning before production begins. A weekly stock take for a small operation (under 50 ingredients) should take no more than 20–30 minutes. The key discipline is doing it at the same time each week and recording results consistently. Monthly stock takes are too infrequent — you will run out of things between counts and not have the data to spot usage patterns.
What is FIFO and why does it matter for food businesses?
FIFO stands for First In, First Out — a stock rotation principle where the oldest stock is used before newer stock. In a food business, FIFO is essential for two reasons: food safety (older stock is more likely to be near or past its use-by date) and allergen accuracy (if a supplier changes the allergen profile of an ingredient, older stock has the old profile). Implementing FIFO in a small kitchen simply means storing new deliveries behind existing stock and always taking from the front. Date-labelling all stock makes this easier to enforce.
How do I track ingredient waste in a small kitchen?
Keep a separate waste log — a simple notebook or spreadsheet column — and record: date, ingredient, amount wasted, and reason (spoilage, overproduction, failed batch, trim waste). Review the log monthly. The goal is not to create admin work but to identify patterns: if you are consistently wasting the same ingredient, you are probably ordering too much of it, using it inefficiently, or not rotating stock correctly. Even a rough waste log will reveal insights that a stock take alone cannot.
At what point should I switch from spreadsheets to software for inventory?
The tipping point for most small food businesses is when one of the following happens: your ingredient list grows past 40–50 items (manual updates become unreliable), multiple people need to access and update stock records simultaneously, you want stock deductions to happen automatically when you log production, or you are making consistent errors (running out, over-ordering) despite keeping the spreadsheet updated. At that point, the time and money saved by lightweight software typically outweigh the cost within one or two months.
How does recipe costing software help with inventory tracking?
Recipe costing software and inventory tracking are complementary. Recipe costing tells you what ingredients a recipe theoretically uses (and what they cost). When you link that to inventory tracking, producing a batch automatically deducts the required ingredients from your stock count — you don't have to update stock manually every time you bake. FoodCore links your recipe ingredient database to your stock levels, so your inventory count stays current as you produce. The difference between theoretical usage and actual usage (your variance) also reveals waste and over-portioning.
Further resources
FoodCore is kitchen management software built for small UK food businesses. We handle recipe costing, Natasha's Law labels, allergen matrices and order tracking.
Start free trial →