How to Track Construction Project Cost Site-Wise, Week by Week

Many construction projects look profitable while work is going on. The real loss appears only after handover. A few material bills were missed. Labour advances were not adjusted. A subcontractor submitted a final claim. Small site kharcha entries were never added. By then, it is too late to correct the project.

Site-wise cost tracking prevents this surprise. It shows what each site has spent, what it still owes, and how much budget remains. The best time to review this is every week. A weekly check is frequent enough to catch a problem and simple enough for a site team to maintain.

The four cost heads

Start by dividing project cost into four clear heads. Do not create too many categories in the beginning. A complicated system is often left incomplete.

1. Material cost

This includes cement, steel, sand, tiles, plywood, hardware, electrical items, plumbing items and other purchases. Include transport, loading, unloading and wastage where applicable. Record the material challan and receipt against the correct site. A material stock register helps you compare purchased quantity, received quantity, issued quantity and closing stock.

Material ordered is also a future cost. Do not wait for payment before considering it. If tiles worth Rs 2,00,000 have been ordered but not paid for, that commitment already reduces the available project budget.

2. Labour cost

Labour cost includes daily-wage labour, weekly wages, overtime, advances and contractor bills. Hajiri should be recorded site-wise and linked to the correct trade. Separate mason, helper, carpenter, electrician and plumber cost where useful.

A basic labour attendance sheet works well for one small site when one person maintains it carefully. For several sites, attendance, wage calculations and advances become harder to reconcile. A hajiri app for construction labour can reduce repeated entry.

3. Subcontractor and vendor cost

This head covers civil contractors, false ceiling teams, fabricators, painters and other work-package vendors. Record the agreed amount, completed work, certified amount, payments, retention and balance owed. Keep purchase vendors separate from work contractors if that makes review easier.

Do not treat an advance as the final cost. Adjust it against measured or certified work. Otherwise, the same amount may appear once as an advance and again inside the contractor bill.

4. Site overhead and other expenses

This includes site rent, electricity, water, fuel, security, temporary works, machine hire, transport and petty cash. Tea, local delivery, repairs and munshi expenses may look small, but repeated entries can become a large total.

Use a consistent site expense register. Ask for a bill, challan or photo wherever practical. When no document is available, record the reason and the person who approved the payment.

Tag every rupee to a site and a head

Every entry needs two tags: the project site and the cost head. Add a third tag for the work package or activity when possible. For example, a plywood purchase may be tagged to “Villa A”, “Material”, and “Kitchen carpentry”.

This rule must apply to cash, bank payments, UPI, credit purchases and contractor bills. If the office pays a common bill for two sites, split it using a reasonable basis. Transport can be split by trip or quantity. Machine hire can be split by days used. Office overhead can remain under a separate company head unless it directly belongs to a project.

Use one naming system. “Site 4”, “Mr Sharma site” and “Baner bungalow” should not refer to the same project in different records. Assign a short project code and use it on every request, order, receipt, wage sheet and expense entry.

The site engineer or munshi should submit entries daily. The office can verify and approve them. Do not depend on memory at the end of the week. Missing entries are easier to find while the challan, labour team and vendor are still available.

A weekly cost sheet

Choose one fixed review day, such as Saturday evening or Monday morning. Update the sheet before the review. The numbers below are only an example.

In this sheet, balance means budget minus spent minus committed. A positive balance does not automatically mean the site is safe. Compare it with unfinished work. If only half the work is complete but most of the budget is consumed, investigate.

During the weekly meeting, ask four questions:

• Which cost head increased more than expected this week?
• Which order or contractor claim is committed but unpaid?
• Is recorded progress matching the money spent?
• What large payments or purchases are expected next week?

Keep a note beside every unusual change. “Steel rate increased” is more useful than only seeing a red number. The note helps during the next review and during final project analysis.

Paid versus owed: why both matter

A bank statement shows paid cost. It does not show the full project liability. Materials may have reached the site on credit. A mistri may have completed work but submitted no bill. Labour wages may be calculated on Saturday and paid on Monday.

Track both amounts separately. “Paid” is the cash already gone. “Owed” is the verified amount payable to vendors, labour or contractors. “Committed” can include approved orders or contracts where supply or work is still pending.

For example, suppose a site has paid Rs 12,00,000. It also owes Rs 3,00,000 for received materials and has approved orders worth Rs 2,00,000. Looking only at payments suggests a cost of Rs 12,00,000. The wider exposure is Rs 17,00,000, subject to receipt and verification.

This distinction also improves cash planning. The owner can see what must be paid this week without confusing it with the total cost of the project. GST and TDS should be recorded consistently so that payable amounts and accounting exports can be checked properly.

How Trackovo shows site-wise cost

Trackovo keeps site-wise payments and expenses in one app on Android, iPhone and web. Its finance management workflow can be used with material requests, approvals, orders, receipts and stock. Delivery or GRN can be recorded with photo proof. Labour attendance can include a photo and site location, and the same system handles labour wages and contractor settlement.

This creates a clearer link between site activity and cost. The team can review project records through reports and dashboards instead of combining separate hajiri sheets, purchase lists and petty cash messages at the last minute. Trackovo also supports GST and TDS handling. It provides a Tally export, not a live Tally integration.

Excel still does some jobs well. It is flexible, familiar and suitable for a small contractor with one site and disciplined data entry. You can begin with construction Excel templates. The difficulty starts when many people edit copies, approvals happen on WhatsApp, or one office tracks several active sites.

Trackovo can help import existing Excel data, and the team exports your data on request. Before changing systems, test one live project, define cost heads, and decide who enters and approves each record. A 14-day free trial is available without a card. Plan limits, launch-offer validity and GST details are listed on the plans page.

Common questions

How often should construction project cost be updated?

Enter transactions daily and review totals weekly. Daily entry reduces missing bills and forgotten site kharcha. The weekly meeting is for checking budget, committed cost, unpaid dues and progress. A monthly review alone is usually too late for correcting repeated overspending.

What is the difference between spent and committed cost?

Spent cost covers verified goods, labour or work already received, whether paid or still owed. Committed cost covers approved orders and contracts for future supply or work. Both matter because an unpaid or pending order still uses part of the project budget.

Can I track site-wise cost in Excel?

Yes. Excel works well when the format is fixed, one responsible person updates it, and supporting documents are filed properly. Use separate project codes and one master list of cost heads. As sites and users increase, an app may provide better control over entries, approvals and records.

Which number should I compare with the project budget?

Compare the budget with spent cost plus committed cost. Then compare the remaining balance with the value of unfinished work. Also keep paid and owed amounts visible for cash planning. No single number gives the full picture, so review cost, liability and physical progress together.