Business

Expense tracker for a carpenter in India: what to record

How a carpenter in India can track plywood, hardware, labour and workshop costs: ten categories, business versus personal money and a worked monthly example.

Editorial illustration for Expense tracker for a carpenter in India: what to record

A carpenter's tracker should link each job to what it cost: wood, laminate, hardware, helper wages and transport. Record what the customer paid, add what you spent on that job, then add the workshop's running costs. What is left, after your own drawings, is what the work earned.

What are a carpenter's real cost lines?

CategoryWhat goes in itEasy to miss
Plywood and timberBoards, planks, battensOffcuts bought to finish a job
Laminate and polishLaminates, adhesive, polish, paintSmall tins bought for touch-ups
HardwareHinges, handles, channels, screws, locksBoxes of screws bought in bulk
Helper wagesDaily pay, advancesExtra hands on a large order
Workshop rentShed or room, storageSpace rented for finished furniture
ElectricitySaw, planer, drill, lightsGenerator fuel
Blades and bitsSaw blades, router bits, sandpaperReplaced often
TransportLoading, tempo hire, fuelTempo paid in cash at the gate
Machine repairSaw, planer, drill servicingRoadside mechanic
Phone and rechargeCustomer calls and photosData pack

A cupboard order that costs ₹30,000 in wood and fittings and brings in ₹45,000 is very different from one that brings in ₹36,000. To see this, give every job a short name, such as the customer's flat or room, and write that beside each purchase. At the end of the job, add up everything labelled with that name.

What about advances and stage payments?

  • Advance at order: write date, customer, amount
  • Material advance: note it separately if the customer gave money only for wood
  • Stage payment on delivery of carcasses or panels: date and stage
  • Final payment: date and method
  • Balance pending: put it in a separate list, not in the takings

What does a hypothetical month look like?

Say a month brings ₹55,000 in cash and ₹75,000 by UPI: ₹1,30,000. Costs: plywood and timber ₹45,000, laminate, hardware and polish ₹14,000, helper wages ₹24,000, workshop rent ₹12,000, electricity ₹5,000, blades and bits ₹3,000, transport ₹4,000 and machine repair ₹2,500. Added together, ₹1,09,500.

₹1,30,000 minus ₹1,09,500 leaves ₹20,500. If you drew ₹15,000, ₹5,500 stayed in the workshop. Example numbers only.

Which money is business and which is personal?

Furniture made for your own home, a favour for a relative and household electricity on the same meter as the workshop are the common mixes. Write them in a personal list. Fix a monthly draw and write it as a draw.

What is a simple routine?

  1. Write each payment with the job name the day it arrives.
  2. Photograph timber market and hardware slips and file them by month.
  3. On Saturday, add up the week's wood and hardware per job.
  4. At month end, match UPI receipts to the statement.
  5. Subtract total costs from takings and compare with the last month.

Furniture work swings with the calendar. Weddings, new house moves and festival months bring orders, while the rainy weeks slow timber work and delay drying and polishing. Write the reason beside each month's total and compare with the same month last year. A single low month then reads as the season, not as a failing business.

When might an app help?

SpendixAI can import the workshop account's statement as PDF, CSV or Excel, ask you to review rows before saving and keep receipts with transactions. Cash purchases can be added by hand, several at once, and your own categories such as wood or hardware keep them tidy. It does not do quotations.

Closing checklist

  • Every purchase labelled with a job name
  • Advances and stage payments dated
  • Pending balances kept apart from takings
  • Drawings marked as drawings
  • A list of questions for your CA
SPENDIXAI JOURNAL

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

Explore your reports