Charity Bake Sale Stock List Excel - Free Template

1. Open the Stock List sheet, shown as image 1, and overwrite the fictional sample entries with your own event stock. Keep a different Item ID for every bake line.
2. Enter the bake item, category, baker or donor, collection point, date baked and best-before date. Complete the allergen and dietary-label fields exactly as supplied by the baker.
3. Add the Quantity Made and Suggested Price (£) for each item. For example, enter 24 slices at £2.50 where every slice is intended to have the same price.
4. During the sale, update Quantity Sold promptly as portions are sold. Do not type over Quantity Remaining, Total Sales, Expected Sales Value or Status because these are calculated cells.
5. Check the Status column before placing items on sale. It identifies Available, Low stock, Sold out and Do not sell according to the remaining quantity and best-before date.
6. Review the Dashboard in image 2 after updating the stock list. Use the category rows to compare quantities made, quantities sold, sales raised and sell-through percentages.
7. Read the Instructions sheet before the event and keep a separate cash reconciliation if your charity uses one. The workbook sales figures show gross sales values, not event costs or other deductions.

A school PTA, village hall committee, sports club or local charity volunteer can use this workbook when donated food begins arriving before a sale. The key moment is not only the event day: you need the Stock List when a volunteer collects 24 Victoria sponge slices from one baker and 30 brownies from another, often at different collection points.

The file gives each bake one record instead of treating a whole table of mixed food as anonymous stock. That matters when two donors both provide cupcakes, but only one batch has a particular dietary label or a shorter best-before date.

Before the doors open

Assign an Item ID as each donation is received. BS-001 might be 24 Victoria sponge slices at £2.50 each, while BS-002 might be 30 brownies at £1.50 each; the expected values are £60.00 and £45.00 respectively.

Enter the baker or donor, town or collection point, date baked, best-before date, allergens and dietary label before stock reaches the display. The strongest approach is to make one volunteer responsible for checking that every physical tray has a matching Stock List line, rather than asking cash-table volunteers to reconstruct details later.

At a busy fundraising table

A cash-table volunteer can update Quantity Sold in batches during a rush, provided the count is based on actual portions leaving the table. If 18 of the 24 Victoria sponge slices have sold, the workbook calculates six remaining and £45.00 in sales for that line.

The Status field then provides an immediate stock cue: six remaining is Available, while three or fewer is Low stock. This lets the event lead decide whether to move another tray forward without relying on verbal estimates from several volunteers.

After collection of proceeds

The treasurer or organiser can use the Dashboard as a quick handover view. Its category section lists Cake, Traybake, Cupcake, Pastry, Biscuits and Savoury Bake, allowing a committee to see which type sold most strongly without manually adding individual lines.

For a one-afternoon event, keep the workbook as the item and sales record, then retain any separate cash count alongside it. The sales figures are useful for reviewing the event, but they are gross funds raised before costs, reimbursements or platform fees.

The Stock List separates information you type from information Excel calculates. You enter columns A to K and M, plus Notes in Q; Quantity Remaining in L, Total Sales in N, Expected Sales Value in O and Status in P are formula-driven outputs.

This is the right design for a bake sale because the two quantities are entered once and reused consistently. Do not replace formulas with manual figures: a line with 30 made and 30 sold should calculate zero remaining, £45.00 sales at £1.50, and Sold out without a second calculation.

Line-by-line quantity and value formulas

Quantity Remaining uses J minus K: Quantity Made less Quantity Sold. Total Sales uses Quantity Sold multiplied by Suggested Price, while Expected Sales Value uses Quantity Made multiplied by the same price.

For example, a tray of 16 cupcakes priced at £1.25 each has an expected value of £20.00. If 11 sell, Total Sales becomes £13.75 and Quantity Remaining becomes five; these outputs change as soon as you revise Quantity Sold.

Status is based on two checks

The Status formula uses IF and checks conditions in a specific order. Zero remaining produces Sold out; otherwise, a best-before date earlier than today produces Do not sell; otherwise, three or fewer remaining produces Low stock; all other lines show Available.

That order is a sensible technical choice because it stops an empty line being presented as stock to remove. However, it also means your best-before date must be entered as a real Excel date in DD/MM/YYYY format, not as a note such as “Friday”.

Dashboard reference limits to review

The Dashboard category formulas use SUMIF over Stock List rows 2 to 11. Its headline formula examples reference row 13 of the Stock List, rather than a visible whole-range sum in the manifest.

For that reason, test the Dashboard carefully after adding your own records, particularly if you use more than 10 item lines. The dependable source record is the individual Stock List line; extend or check the Dashboard formulas before relying on its totals for a final handover.

A final handover often starts with the dispatch record, so it is worth checking that the line items and totals still match the source stock entries before anything leaves the warehouse.

The most expensive errors at a charity bake sale usually start with a mismatch between what is on the table and what is in the Stock List. A volunteer may write “brownies” on a paper sign while the workbook has two separate brownie lines with different donors, prices or allergen information.

Keep separate lines when the underlying item details differ. Combining 12 £1.50 brownies with 12 £2.00 brownies into one 24-item line at £1.50 understates the expected value by £6.00 and makes the final sale figure unreliable.

Typing into calculation columns

Quantity Remaining, Total Sales, Expected Sales Value and Status are not fields for manual stock-taking. If a volunteer types “4” into Quantity Remaining instead of changing Quantity Sold, the relationship between made, sold and remaining is broken and the sales value may no longer agree with the physical tray.

Use the two input quantities as the source of truth. For example, if 20 portions were made and four remain, enter 16 in Quantity Sold; Excel then derives four remaining and calculates the monetary total from the set price.

Incomplete food descriptions

Leaving Allergens blank because a donor says a cake is “standard” creates an unresolved item at the point of sale. The Instructions sheet directs you to record details exactly as supplied rather than guessing, which is the correct operational stance for this workbook.

Notes can hold handling information that does not fit a main field, such as “Custard cream filling — keep cool”. Do not substitute Notes for the dedicated allergen, dietary-label or best-before columns, because volunteers need those facts in consistent locations.

Trusting an untested summary

The Dashboard category calculations shown in the manifest cover rows 2 to 11, and the headline examples pull values from row 13. If you enter 14 bake lines, the category view may not include every line unless its formulas are reviewed and extended.

A hypothetical sale with 12 lines at an average £18.00 each could leave £36.00 outside a summary limited to the first 10 lines. Before reporting funds raised, compare the Dashboard with the individual Total Sales figures in column N and correct any range issue rather than explaining a discrepancy afterwards.

That same range check matters when the sheet is tracking stock control records, because a summary that misses later rows can leave quantities and totals out of sync.

Make the Stock List part of the donation process, not a document saved for the morning of the sale. Start it when the first donor confirms a bake, then nominate one person to own entries and one person to check the physical labels against the completed lines.

A simple event with 10 items is manageable from one sheet; an event with 30 separately priced donations needs a fixed update rhythm. The technical priority is preserving one reliable record per bake line, rather than collecting several handwritten counts that must be merged after the event.

Use three timed checkpoints

• Complete the initial Stock List before food is displayed, including Item ID, Quantity Made, allergens and best-before date.
• Update Quantity Sold at a set interval, such as every 30 minutes, and once again when the sale closes.
• Review low-stock, sold-out and do-not-sell statuses before volunteers replenish or remove items.

For example, if a cake line begins with 24 portions and the first count records 18 sold, the next volunteer starts from six remaining rather than recounting the entire display. This is faster and avoids two people each recording the same four sales.

Keep inputs disciplined

Use the workbook’s available dropdown guidance for categories and dietary labels so category names do not drift between “Cake”, “cakes” and “cake slices”. The Dashboard uses SUMIF against category text, so a spelling variation can prevent a line being included in the intended category total.

Keep prices numeric and use the £ currency format already applied in the workbook. Entering £2.50 as text rather than a number risks preventing a correct multiplication in Total Sales and Expected Sales Value.

Know when to move on

This template suits a contained bake-sale event with a manageable number of donated items and a small group of volunteers. Move to a dedicated point-of-sale or inventory system when several tills need live updates, stock is held across multiple events, or you need an auditable link between payments, refunds and item-level sales.

Until then, archive a copy after each event and begin the next one by overwriting the fictional sample data and checking the Dashboard ranges. That preserves the useful structure without carrying old quantities into a new fundraiser.