Home bakers and the spreadsheet: what actually needs replacing

The spreadsheet gets blamed and it is usually doing its job. What fails is everything around it: orders arriving in a thread and being copied across by hand, capacity that exists only as a feeling about how busy next month looks, and a business run from a kitchen that is also where the family eats.

Replacing the spreadsheet with software solves the least important of those. The things worth fixing are capacity you can actually see, the obligations that come with selling food from home, and the boundary between the business and the house.

What we'll cover

• The spreadsheet is not the problem
• Capacity you cannot see
• Registration and what it brings
• Building it with CodeWords
• Allergens from a home kitchen
• Pricing for one person
• The boundary between business and house
• What to keep manual
• Making it survive
• Limits worth knowing about
• What to build first
• Frequently asked questions

The spreadsheet is not the problem

It holds the orders adequately for most home bakers, and it is free and familiar.

The gap is the copying, from a conversation into the sheet, by hand, usually late at night.

And the state, since a spreadsheet does not tell you an unpaid deposit is now three weeks old.

And the visibility, because nobody else can see it if you are ill.

Fix the flow into it before replacing it, which is the cheaper and more effective order.

Many home bakers never need to replace it, which is worth saying since most advice assumes otherwise.

Capacity you cannot see

The real constraint is oven hours and your hands, not order count.

A weekend with three cakes may be lighter than one with two, depending on the cakes.

Say what a week can hold, in cakes of a given complexity, and write it down.

Check against it when quoting, which is the moment the decision is made and the moment it is usually guessed.

Watch the compound weekends — a wedding on Saturday and two birthdays is not three orders, it is a week.

Declining is a capacity decision, and doing it deliberately is better than doing it at two in the morning.

Registration and what it brings

Selling food from home requires registering as a food business in most jurisdictions, and it is usually free.

It is not optional because the volume is small or the kitchen is domestic.

An inspection may follow, which is a conversation rather than a test, and is generally helpful.

Insurance is separate, and public liability and product liability are worth understanding before you need them.

Records matter — suppliers, batches, allergens — in a way that is easier to keep from the start than to reconstruct.

Check your own position with your local authority, since the requirements and the terms differ by country.

Building it with CodeWords

CodeWords connects to more than 3,000 integrations, and the connection is made once and reused.

1. Open CodeWords and start a new automation.
2. Describe what should happen in plain language to Cody, the automation builder: what an enquiry captures, where the order is recorded, and what reaches you.
3. Authorize the connections to wherever orders live — a sheet is fine — and your WhatsApp Business Platform account.
4. Describe the exceptions: a date at capacity, an allergen you cannot accommodate, an unpaid deposit, a message out of hours.
5. Run it for a fortnight alongside how you work now rather than switching.

You describe the outcome; Cody builds it, connects it, and deploys it. The free plan covers light use, with Pro at $39 per month and Business at $100 per month as usage grows; details are on the pricing page.

Allergens from a home kitchen

A domestic kitchen is shared, which is the honest starting point.

You cannot usually guarantee absence of an allergen in a kitchen where the household also cooks.

Say so plainly rather than agreeing and hoping, since this is the one area where a misunderstanding is serious.

Ask about allergens at enquiry, before design and before quoting.

Keep the ingredient records, including decorations and anything bought in, which is what you would need if asked.

The rules differ by jurisdiction and by whether the item is made to order or prepacked, so check what applies to how you actually sell.

Pricing for one person

Most home bakers underprice, and the usual cause is not counting their own time.

Count the hours honestly, including shopping, decorating, cleaning and the conversation.

Ingredients are the smaller number for a custom cake, which surprises people the first time they add it up.

Overheads exist at home too — the oven, the fridge, the equipment that wears out, the mileage.

Price for the business you want, not the one you would feel awkward charging for.

Raise prices on new enquiries rather than on existing customers, which is easier and works.

The boundary between business and house

Your kitchen is also your home, which affects when you can work and when you want to.

Say when you answer messages and hold to it, since orders arriving at eleven at night are answered at eleven at night otherwise.

A separate number is the single clearest boundary available, and it costs very little.

Collections at your home need a thought about who comes to the door and when.

Family time disappears silently in this business, and the boundary is the only thing that protects it.

Protect one day, deliberately, because a business you cannot step away from stops being one you enjoy.

What to keep manual

The design conversation, which is the part customers value and you are good at.

The recommendation about what would work for their occasion.

Anything about a complaint, which is a person's job.

The decision to take an order, which is a capacity and a judgement call.

The photographs and the relationship, which is why people come back to you rather than a shop.

Automate the copying, the chasing and the reminding — which is the administration, not the baking.

Making it survive

Keep the order record somewhere other than the thread, whatever it is.

Check capacity before confirming, every time.

Keep your ingredient and allergen records in a form you could show somebody.

Have a fallback for a week you are ill, even if it is a message saying so.

Report the outcome: enquiries, orders, capacity used against what you said a week holds.

Limits worth knowing about

Registration and food safety rules are local and are not optional.

Insurance terms may require records you are not keeping.

A home kitchen constrains what you can safely offer, particularly around allergens.

Automation does not add oven hours, which is the actual ceiling.

Growth changes the obligations, and a volume that outgrows a domestic kitchen changes the regulatory picture entirely.

What to build first

Capacity, written down: how many cakes of what complexity a week can hold, checked at the point of quoting. It is not software, it takes an afternoon, and it converts the decision that is currently made at two in the morning into one made deliberately while the enquiry is still open.

Two habits make the difference. Be plain about what a shared home kitchen can and cannot guarantee on allergens, since it is the one area where agreeing to be helpful is genuinely unsafe. And count your own hours when pricing, because the ingredients are the smaller number and undercharging is the thing that ends home baking businesses that were otherwise working.

Frequently asked questions

Should I replace my spreadsheet?

Probably not. It holds orders adequately and it is free. The gap is the copying from conversations into it by hand, the absence of state such as an unpaid deposit ageing, and the fact nobody else can see it — fix the flow into it first.

What is the real capacity constraint?

Oven hours and your hands, not order count. Three cakes may be lighter than two depending on complexity, and compound weekends — a wedding plus two birthdays — are a week rather than three orders.

Do I need to register to sell cakes from home?

In most jurisdictions yes, usually free, and it is not optional because the volume is small or the kitchen domestic. Insurance is separate. Check your own position with your local authority.

What should I say about allergens from a home kitchen?

The honest thing: a shared domestic kitchen usually cannot guarantee the absence of an allergen. Say so plainly rather than agreeing and hoping, because this is the one area where being accommodating is unsafe.

Why do home bakers underprice?

Because they do not count their own hours — shopping, decorating, cleaning and the conversation. Ingredients are the smaller number for a custom cake, which surprises people the first time they add it up.

How do I raise prices?

On new enquiries rather than on existing customers. It is easier, it works, and it avoids a difficult conversation with the people who have supported you.

How do I stop the business taking over the house?

State when you answer messages and hold to it, get a separate number, think about collections at your door, and protect one day deliberately. Family time disappears silently otherwise.

What should stay manual?

The design conversation, the recommendation, anything about a complaint, and the decision to accept an order. Automate the copying, the chasing and the reminding — the administration rather than the baking.

What happens if my volume outgrows a home kitchen?

The regulatory picture changes rather than scaling. Beyond a certain volume the question becomes commercial premises or a shared kitchen, and that is worth understanding before you are turning work away or working in a way that no longer fits what you registered.

Can automation add capacity?

No. Oven hours and your hands are the ceiling, and no system changes either. What it removes is the copying, the chasing and the late-night administration around them.

Related reading

• Taking custom cake orders over WhatsApp
• A baker's guide to WhatsApp automation
• Collecting bakery deposits and payments