Business

Expense tracker for a interior contractor in India: what to record

How an interior contractor in India can track project-wise materials, carpenters, vendors and client stage payments, with a worked project.

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

An interior contractor should track each project separately: client stage payments in, and plywood, laminates, hardware, carpenter pay, vendor work and site costs out. Keep rework and advances to vendors visible. Because payments come in stages while costs start early, a project-wise sheet shows whether you are margin-positive before the handover, not after.

Why do interior projects slip on cost?

The quotation is fixed, but the job is not. A client changes a finish, a carpenter redoes a panel, a vendor asks for an advance and a tempo makes three trips instead of one. Each small item is easy to forget, and together they decide the margin. Writing every spend against a project name the same day is the only reliable cure.

Which categories work for interiors?

CategoryWhat goes in it
Boards and plywoodPlywood, MDF, laminates, veneers, edge bands
Hardware and fittingsHinges, channels, handles, locks, lights
Carpenter and labourDaily wages or agreed rates for carpenters and helpers
Painting and polishPainter pay, paint, putty, polish
Electrical and plumbing vendorsSub-contract work for that project
Glass, stone and special itemsMirrors, countertops, custom pieces
Transport and loadingTempo hire, unloading, delivery to the site
Site consumablesAdhesives, screws, sandpaper, cleaning, protection sheets
Design and drawingDraftsman, 3D work, printing
Rework and snag costsCorrections after the client's inspection

How should client payments be tracked?

  • Write the project value, then each stage: advance, mid-stage, final.
  • Record each payment with date, amount and mode.
  • Mark which stage it covers, so you know what is still due.
  • Keep extra work, agreed in writing, as a separate line against the project.
  • Note any amount the client holds until snags are fixed.

What does one hypothetical project look like?

Say a project is worth ₹6,00,000. The client pays 30 per cent as advance, which is ₹1,80,000. Costs end up as boards ₹2,10,000, carpenter and labour ₹1,20,000, vendors ₹40,000, transport ₹15,000, consumables ₹8,000 and rework ₹12,000.

LineAmount (₹)
Project value6,00,000
Advance received1,80,000
Boards2,10,000
Carpenter and labour1,20,000
Vendors40,000
Transport15,000
Consumables8,000
Rework12,000
Total costs4,05,000
Margin on the full project1,95,000

Costs add up as 2,10,000 plus 1,20,000 plus 40,000 plus 15,000 plus 8,000 plus 12,000, which is ₹4,05,000, and 6,00,000 minus 4,05,000 leaves ₹1,95,000. At the time the advance arrives you hold ₹1,80,000 while costs run towards ₹4,05,000, so you finance about ₹2,25,000 until later stages are paid. That figure, 4,05,000 minus 1,80,000, is worth knowing before you start.

What gets missed on interior sites?

  • Material fetched in a hurry from a local shop with no bill.
  • Advances to carpenters and vendors that are never matched to a final bill.
  • Rework cost, which hides inside normal material cost.
  • Daily tea, snacks and travel allowances for the crew.
  • Returned boards or leftovers that reduce the cost but are not recorded.

What routine keeps projects honest?

  1. Give each project a short code and write it on every bill.
  2. Each evening, enter the day's cash spends against the project.
  3. Each week, compare costs so far with the quotation.
  4. At each stage payment, check what is still owed by the client and what you owe vendors.

How do you keep vendor advances under control?

Advances are how interior work actually runs, and they are where money goes missing. Say you give an electrical vendor ₹20,000 in advance against a ₹45,000 job. Write the advance with the date, the vendor and the project. When the job is done, the final payment is 45,000 minus 20,000, which is ₹25,000. If you record only the final ₹25,000, the project cost looks ₹20,000 lower than it was, and your margin is overstated.

  • Keep a short advance list: vendor, project, amount given, amount settled.
  • Never pay a second advance until the first is explained.
  • At project close, check that every advance has a matching final bill.
SPENDIXAI JOURNAL

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

Explore your reports