Expense categories

How to track craft materials month by month

A monthly routine for tracking craft materials: batch costing, a stock tally, festival season planning, and a candle-making example with the arithmetic.

Editorial illustration for How to track craft materials month by month

Track craft materials by costing each batch, tallying leftover stock at month end and planning ahead for festival season. The idea is to see what one unit costs you before you set a price, and to notice when materials quietly get more expensive. The example below uses candles, with all figures made up.

What should I record for each batch?

Write down every material that went into the batch, the amount paid, and how many finished items came out. A batch is simply one production run, whether that is twenty candles, thirty bangles or a dozen hampers.

MaterialAmount paid
Wax₹2,000
Wicks₹300
Fragrance oil₹640
Jars₹1,200
Total batch cost₹4,140

The sum is 2,000 plus 300 plus 640 plus 1,200, which is 4,140. If the batch made 40 candles, each cost 4,140 divided by 40, or ₹103.50 in materials. If you sell at ₹250, that leaves ₹146.50 before your time, electricity and packaging. It is only a guide, but it is far better than a guess.

How do I handle stock that carries over?

Materials are rarely used up in the month they are bought. Wax bought in bulk may last three batches. A simple tally keeps this honest: at month end write what you had, what you bought, what you used and what is left. You do not need to price the leftover precisely; a rough count is enough to prevent buying the same thing twice.

  • Opening stock: what was on the shelf on the first of the month.
  • Bought: new purchases from your records.
  • Used: what went into batches.
  • Closing stock: what remains, counted, not guessed.

How do I plan around festival season?

Orders spike before Diwali, Raksha Bandhan and wedding seasons, and so does the price of popular materials. Look at last year's records, if you have them, to see which month your spending peaked. Then plan to buy staple materials a few weeks earlier and decide a limit for the festival month. If you have no history, start recording this year so that next year's plan is based on facts.

What should a monthly review cover?

  1. Total materials bought, split into raw materials, tools and packaging.
  2. Cost per unit for each product made that month.
  3. Any material whose price went up since the last purchase.
  4. Stock left, and what must be reordered first.

A price change is easy to miss. If jars cost ₹30 each last month and ₹34 now, that is ₹4 more on each of 40 candles, or ₹160 on the batch, which is invisible unless you compare invoices.

What about unsold items?

Unsold stock is money that has already left your account. After a festival, count what remains and note how many units and from which batch. That tells you which products to make fewer of next year, and it stops you from judging a season only by the orders that came in. Do not delete the cost; just note that it has not yet turned into income.

How do I price from these numbers?

Start from the cost per unit, then add packaging, your time and a margin you are comfortable with. Using the candles, ₹103.50 of materials plus a ₹25 box is ₹128.50 before any time. Writing the build-up on paper once means that when a customer asks for a discount, you know exactly how much room there is.

Where does an expense tracker fit?

Use it for the part that repeats: bank statement imports and categorised spending by month. In SpendixAI you can upload a statement, review the rows before saving, and add cash purchases from the market by hand. Batch costing and stock counts will still be done in your own notes or a sheet.

Checklist for the first of each month

  • Stock counted.
  • Last month's batch costs worked out.
  • Upcoming festival dates noted with a planned limit.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports