Business

Expense tracker for a civil engineer freelancer in India: what to record

A civil engineer freelancer's guide to tracking fees, site visits, software, printing and pass-through costs, with ten categories and a worked month.

Editorial illustration for Expense tracker for a civil engineer freelancer in India: what to record

A civil engineer freelancer should record each client's fees as invoiced and as received, then every cost of doing the work: software, site travel, printing, an assistant and workspace. Fees paid to authorities on a client's behalf are pass-through money and belong in a separate column. A project-wise sheet shows which clients are worth the effort.

What makes a freelance engineer's money different?

You are paid by project or milestone, often after drawings are approved or a site stage is complete. Income arrives in uneven chunks, and some clients pay late. Meanwhile your costs, such as a software subscription, internet and travel, come every month. You may also pay fees to an authority or a vendor for the client, and get reimbursed later. If that money is mixed into your income, your profit looks larger than it is.

Which categories suit this work?

CategoryWhat goes in it
Design and drawing softwareSubscriptions and licence renewals for the programs you use
HardwareLaptop, tablet, laser distance meter, repairs
Printing and plottingDrawing sheets, reports, binding, courier
Site travelFuel, cab, bus or train, parking, toll, FASTag recharge for work trips
Site meals and small costsTea, water, photocopies near the site
Assistant or draftsmanMonthly pay or per-drawing payments
Workspace and internetCo-working desk, home office share, broadband, phone
Memberships and renewalsProfessional membership or registration renewals you actually pay
Courses and booksCodes, standards, training that you pay for yourself
Pass-through feesMoney paid to others on behalf of a client, tracked until reimbursed

How should pass-through money and deductions be tracked?

  • Write each pass-through payment with the client's name, the amount and the date you paid it.
  • Record the reimbursement separately when it arrives, so the two entries cancel out.
  • If a client deducts tax at source before paying, record three numbers: invoice amount, deduction and the amount that reached your bank.
  • Keep any certificate the client issues, since your CA will need it. Do not guess rates; ask your CA how it applies to you.

What does a hypothetical month look like?

Say fees received in a month are ₹85,000. Costs are software ₹3,500, printing ₹2,400, site travel ₹9,600, internet and phone ₹1,800, a draftsman ₹15,000 and a co-working desk ₹6,000. Separately you paid ₹12,000 to an authority for a client, to be reimbursed.

LineAmount (₹)
Fees received85,000
Software3,500
Printing2,400
Site travel9,600
Internet and phone1,800
Draftsman15,000
Co-working desk6,000
Total costs38,300
Left over46,700
Pass-through paid for client, not counted above12,000

Adding the costs, 3,500 plus 2,400 plus 9,600 plus 1,800 plus 15,000 plus 6,000 comes to ₹38,300, and 85,000 minus 38,300 leaves ₹46,700. The ₹12,000 is not a cost of yours; it is owed back to you, so it waits in its own column until the client pays.

What do freelancers usually forget?

  • Small site-trip costs such as parking and toll, which vanish without a bill.
  • A subscription that renews automatically on a card.
  • Printing paid in cash at a local shop.
  • Money paid to a vendor for a client in your own name.
  • Part payments that come in two or three transfers for one invoice.

What routine works around site visits?

  1. After each site trip, enter the travel and meals the same evening, while you remember them.
  2. Tag every entry with the project or client name.
  3. On the first of each month, raise invoices for finished milestones and list the unpaid ones.
  4. Match the bank statement with invoices received and mark any payment you cannot place.

Review the project list quarterly. Divide each project's fees received by the hours you spent, including site travel, and you will quickly see which clients are worth keeping and which ones eat your weekends. Write the figure in the sheet; it is an honest answer to a question most freelancers only guess at.

SPENDIXAI JOURNAL

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

Explore your reports