Stock - Manufactured Stock

Shows everything your store made in-house during the period you choose: every batch produced, the recipe ingredients it used, what it cost, and how much of it was discarded afterwards. Use it to check that batches are being recorded properly and to see what your prep really costs.

Updated Mon 2 Nov 2026

Running the report

Open Reports and choose Manufactured stock under Stock.

Pick your Select a start date and end date. Choose a single manufactured item if you only want to look at one, and pick your Select your stock costing model.

Run the report. You see every posted batch in the period, newest last, followed by a summary of the stock created and the stock used.

TipYou can also open this report from a link inside the Gross Profit, Stock Variance and Stock Item Audit reports. It then opens for the exact period (or item) you were looking at there.

Report options

Select a start date

The first day to include. The default is today. The report starts at your store's close-of-trade time on that day.

end date

The last day to include. The default is today. The report runs until your store's close-of-trade time on the day after this date, so the whole trading day is covered.

Manufactured stock item filter

Choose which manufactured item to look at. Only items that are set up as manufactured items, and that are not archived, are listed, in alphabetical order with the item code in brackets where it has one.

All Manufactured Items

Burger Sauce (BSAUCE)

Pizza Dough (PDOUGH)

Select your stock costing model

Decides which cost is used for every value on the report. The list shows your brand's method and, only when your store has chosen a different one, your store's method as well. The first entry is the default.

Brand's method (FIFO - First in First Out)

Store's method (WAC - Weighted Average Cost)

Good to knowSwitching the costing model changes the values only. The batches, quantities and discards stay exactly the same.

The report at a glance

BOB'S BURGERS | BOB'S BURGERS TIMES SQUARE

Manufactured stock report

Mon 26 Oct 2026 00:00 to Sun 01 Nov 2026 23:59

The dates show the trading days covered. If your store closes its trading day after midnight, the end time shows that close-of-trade time on the following day and an asterisk (*) points to a note about trading days in the footer. A batch counts on the date and time it was made, not the time it was posted.

Batch details: every posted batch, with its recipe ingredients and cost.
Stock created and stock used: a summary page of what was made and what went into it.
Archived batch alert: a red note when batches in the period were archived.

Below the header a Selected parameters panel repeats the item you chose (MANUFACTURED ITEMS) and the costing model (STOCK COSTING MODEL), so a printed copy always shows how it was run.

Batch details

Batches are listed in the order they were made. Each one starts with the item's name, then the batch's own details, the ingredients it used and a total.

Burger Sauce - kg 1			# Batches	Yield / batch	Qty made	Value
Batch ref: BS-0028	Made at date time: Wed 28 Oct 2026 at 08:30		2.000	5.000	10.000	245.00
Posted by: Sam	Posted at date time: Wed 28 Oct 2026 at 09:05
Notes: Weekly sauce prep
Recipe ingredient - UoM 2	Qty used	Cost	Burger Sauce unit price: 3		24.50	per kg
Mayonnaise - kg	5.000	125.00
Tomato Sauce - kg	3.000	54.00
Pickle Relish - kg	2.000	66.00
Total cost: 4		245.00	You discarded 0.500, at a value of R12.25. Click here to open the discards report. 5

1 Item heading and batch figures

The item's name and unit of measure sit at the top. On the batch line, # Batches is how many batches were made, Yield / batch is how much each batch produces and Qty made is the total produced. Value is what that stock is worth under the costing model you chose. When the same item is made more than once in the period, each batch gets its own block, in time order, so the item heading can repeat.

2 Recipe ingredients

Every ingredient the batch used, with the quantity and its cost. Underlined ingredient names are click-through links that open the Stock Item Audit report for that ingredient.

3 Unit price

The value divided by the quantity made: what one unit of your manufactured item cost you. If a batch has no quantity recorded, the unit price shows 0.

4 Total cost

The cost of all the ingredients in the batch, added up.

5 Discards

Shown only for batches that have had some of their stock discarded. It adds up every discard recorded against that batch, with the quantity and the value. Click it to open the Discards report. Batches with no discards show nothing here.

Batch ref: The reference captured when the batch was recorded.
Posted by: The person who posted the batch. It shows Unknown if that person can no longer be found.
Notes: Any note typed when the batch was recorded.

About the pale grey zerosQuantities show three decimals. The trailing zeros are shaded light grey on purpose: they keep the decimal points, units, tens, hundreds and thousands lined up in a column so figures are easy to compare, without cluttering the page.

Stock created and stock used

The last page adds everything up under the heading Net stock movement: Stock created on the left and Stock used on the right.

Stock created			Stock used
Item	Qty	Value	Item	Qty	Cost
Burger Sauce - kg	15.000	367.50	Cake Flour - kg	-8.000	-96.00
Pizza Dough - kg	12.000	200.00	Mayonnaise - kg	-7.500	-187.50
			Olive Oil - l	-0.800	-64.00
			Pickle Relish - kg	-3.000	-99.00
			Tomato Sauce - kg	-4.500	-81.00
			Yeast - kg	-0.200	-40.00
Total:		567.50	Total:		-567.50

Stock created lists each manufactured item with the total quantity made and its value. Stock used lists each ingredient with the total quantity used and its cost, shown with a minus sign because it leaves your stock. Both lists count every posted batch in the period and leave out archived batches.

Archived batch alert

If any batches made in the period were archived, a red Alert: lists how many batches of each item were archived, followed by a reminder that archived and unposted manufacturing activities are left out of this report and are not included in the variance and gross profit calculations. Archived batches do not appear in the batch details or in the stock created and stock used totals.

Watch the video

A short walkthrough of the Manufactured stock report and how to read it.

Can't see the video? Watch it on YouTube.

Frequently asked questions

A batch I made is not on the report. Why?

Check four things. The batch must be posted: batches that were never posted are left out. It must not be archived: archived batches are listed in the red alert but not in the details. Its Made at date time must fall inside your dates (the report goes by when the batch was made, not when it was posted). And if you chose a single item in Manufactured stock item filter, only that item is shown.

Why does the same item appear several times?

Batches are listed in the order they were made, and each batch gets its own heading. If you made Burger Sauce on Monday, Pizza Dough on Tuesday and Burger Sauce again on Wednesday, you see the Burger Sauce heading twice. The last page adds each item up into one line.

Why is the batch Value not exactly the same as the Total cost?

They should normally agree, because a batch is valued at what went into it. A small difference can come from rounding to the cent, or from ingredient costs being recalculated after the batch was posted.

Why do my values change when I pick a different costing model?

Each costing model (FIFO, WAC and LC) values the same stock differently. Only the money figures change; quantities, batches and discards are identical.

Why do I only see a discard line on some batches?

The discard line only appears for batches that have had stock discarded from them. It adds up every discard recorded against that batch, whenever the discard happened. To see the individual discards, click the line to open the Discards report.

Why is the person shown as Unknown?

The batch was posted by someone who can no longer be found in your system. The batch itself, its ingredients and its value are still counted in full.

Which time zone and trading day does the report use?

Your store's local time and its close-of-trade time. A trading day that closes after midnight includes the early hours of the next calendar day. A batch made exactly at the closing time counts towards the next trading day, so it is never counted twice on two reports.

Glossary

Archived batch: A batch that was recorded and then archived. It is mentioned in the red alert but left out of the totals.
Batch: One recorded manufacturing run of an item, with its recipe ingredients.
Batch ref: The reference captured when a batch was recorded.
Costing model: The method used to value stock: FIFO (first in, first out), WAC (weighted average cost) or LC (last cost).
Discard: Stock thrown away or written off after it was made, recorded in the Discards report.
Made at date time: When the batch was made. This is the time the report uses to decide whether the batch falls in your period.
Manufactured item: A stock item that you make in-house from other stock items using a recipe.
Net stock movement: The summary page showing the stock created and the stock used.
Posted: A batch that has been completed and recorded in your stock. Only posted batches are reported.
Posted at date time: When the batch was posted.
Qty made: The total quantity a batch produced.
Qty used: The quantity of an ingredient that went into a batch.
Recipe ingredient: A stock item used to make a manufactured item.
Trading day: Your store's business day, from its close-of-trade time to the next close-of-trade time.
Unit price: The value of a batch divided by the quantity made: the cost of one unit of the manufactured item.
Value: What the stock made in a batch is worth under the costing model you chose.
Yield / batch: How much one batch is expected to produce.