A home baker can find profit per order in Excel with one row per order: selling price minus ingredient cost, packaging, delivery and a share of shared overheads like gas and electricity. Total the month and you see which cakes and cookie boxes earn money and which only keep you busy. The sheet needs about eight columns and two formulas.
What columns does an order sheet need?
| Column | Heading | Notes |
|---|---|---|
| A | Date | Delivery or pickup date |
| B | Customer | Name or order source |
| C | Item | Chocolate cake 1 kg, cookie box |
| D | Selling price | What the customer paid |
| E | Ingredients | Cost of what went into this order |
| F | Packaging | Box, board, ribbon, card |
| G | Delivery | What you paid for delivery, if any |
| H | Overhead share | Allocated from the month's gas and electricity |
| I | Profit | =D2-E2-F2-G2-H2 |
| J | Hours | Time spent, including shopping and decorating |
Ingredient cost per order is the hard part. Work out the cost of the main ingredients from your last purchase bills, divide by the number of batches they made, and keep the figures on a small recipe tab so you are not guessing each time.
How do I share gas and electricity across orders?
You cannot meter the oven for one cake, so allocate. In a cell such as M1, enter the month's share of gas and electricity that you attribute to baking. Decide the share fairly, for example by how much of the household bill the oven and mixer account for, and write the method down. Then:
- Orders in the month: =COUNTIFS($A$2:$A$200, ">="&M2, $A$2:$A$200, "<="&EOMONTH(M2,0)), where M2 is the month's first date
- Even share per order in H2: =$M$1/$M$3, where M3 holds the order count
- Share by ingredient cost, if big cakes use more oven time: =$M$1*E2/SUMIFS($E$2:$E$200, $A$2:$A$200, ">="&$M$2, $A$2:$A$200, "<="&EOMONTH($M$2,0))
The second method is more realistic when your orders vary a lot in size; the first is easier to explain.
What does a weekend of orders look like?
Say one weekend brings a cake and a cookie box, and the month has 12 orders in all with ₹1,200 of gas and electricity to share. The even share is ₹1,200 / 12 = ₹100 an order. The figures are invented.
| Order | Price | Ingredients | Packaging | Delivery | Overhead | Profit |
|---|---|---|---|---|---|---|
| Chocolate cake | ₹1,800 | ₹620 | ₹90 | ₹120 | ₹100 | ₹870 |
| Cookie box | ₹650 | ₹210 | ₹60 | ₹0 | ₹100 | ₹280 |
The cake: 1,800 - 620 - 90 - 120 - 100 = ₹870, a margin of 870 / 1,800, about 48.3%. The cookie box: 650 - 210 - 60 - 0 - 100 = ₹280, about 43.1%. Now add hours: if the cake took 4 hours, profit per hour is ₹217.50; if the cookies took 2 hours, it is ₹140. Per-hour profit often changes which order you promote.
What should I not leave out?
- Your time, even if you do not pay yourself, because profit per hour is how you judge pricing
- Wastage from failed batches and trial runs
- Cakes given free to family or as samples
- Fuel or cab cost for supply runs
- Tools wearing out, such as moulds and tins, put in a small yearly line
How do I get a monthly view?
Use a Summary tab with SUMIFS on dates: revenue =SUMIFS(Orders!$D$2:$D$200, Orders!$A$2:$A$200, ">="&B1, Orders!$A$2:$A$200, "<="&EOMONTH(B1,0)), and the same for total profit using column I. Divide profit by revenue for the month's margin. A pivot table in Excel by item name shows which products repeat.
What about licences, GST and tax?
Home food businesses can be subject to registration and tax rules, and these differ by state and by size of business, and change over time. Record every order and every bill so the information is there when you ask a CA or the relevant authority what applies to you.
Where can an app help?
Supply purchases show up in your bank or card statement. SpendixAI can import the statement, let you set up custom categories such as Ingredients and Packaging, and keep receipts with the transactions, so you can read the month's baking spend directly. Per-order profit stays in your sheet.
Weekend routine
- Add each order as soon as it is confirmed
- Fill ingredient cost from the recipe tab
- Add delivery and packaging after the order
- Update hours
- Check the month's margin on Sunday night
Useful ideas start with a clearer picture of your own spending.
Explore your reports


