Wax Melt Maker's Income & Expenses Tracker 2026/27 | UK Tax Year Spreadsheet for Wax Melt & Candle Businesses

Know exactly what your wax melt business makes, and what to put aside for HMRC, without a shoebox of receipts in January.

This UK spreadsheet is built for wax melt and candle makers. Log each sale and pick where it came from: Etsy, your own website or Payhip shop, craft fairs and markets, or wholesale. Log each receipt under maker-friendly categories like wax, fragrance oils, clamshells, CLP labels, packaging, postage, selling fees, equipment and stall fees.

It then does the maths for you. See sales and profit month by month across the 2026/27 tax year (6 April to 5 April), check whether the £1,000 trading allowance or your actual expenses saves you more, and get an estimated Income Tax and National Insurance figure, with Scottish tax bands built in. It even tells you how much to move to your tax pot now and each month.

Example data shows you how it works, and a clear Start Here tab walks you through it. Works in Excel and Google Sheets. UK English, £.

What's included:

- Sales log with drop-downs for Etsy, website/Payhip, craft fairs, wholesale and other channels

- Expenses log with 15 wax-maker categories, business-use % and a receipt check

- Monthly Summary with sales by channel, profit, a chart and where your money goes

- Tax Estimate: £1,000 trading allowance check, tax set-aside, plus Self Assessment, Etsy reporting, MTD and VAT warnings

- Start Here guide and a Tax Rates tab checked against gov.uk (October 2026), easy to update next year

Small print: A planning tool, not tax or financial advice. Estimates assume you're a UK sole trader with no other income besides a salary.