Open the WhatsApp group of any active Indian construction site at 7:30 PM and you will find the same daily ritual playing out — the site engineer typing out a DPR on his phone in two paragraphs of broken English, followed by ten photos in random order, followed by a “good night sir” sticker. By the time the project manager opens the message at 9:00 PM, three other sites have sent the same thing, none of them in the same format, and there is no way to compare yesterday’s progress to today’s without scrolling through three weeks of chat history.

This is what passes for a daily progress report on most Indian sites. And it is the single biggest reason owners do not trust contractors — not because the work is bad, but because the reporting is so chaotic that the work becomes invisible.

This guide is the version a site engineer should hand to every junior on day one — what a real DPR contains, the free Excel template that every contractor should be using, and the honest answer to whether you should still be doing this in Excel at all in 2026.

What a Daily Progress Report (DPR) actually is

A DPR is a one-page snapshot, generated at the end of each working day on a construction site, that answers seven questions an owner or project manager needs to be able to read in under 90 seconds:

1. How many people worked on the site today, and what trades?
2. What activities were executed and where on the building?
3. What materials were received, and what materials were consumed?
4. What is the planned versus actual progress on the critical path?
5. What stopped work or slowed it down — weather, materials, drawings, labour, approvals?
6. What is planned for tomorrow?
7. What does the site look like right now, in 5 to 10 timestamped photos?

If the report cannot be read in 90 seconds, it is not a DPR. It is a diary. And nobody reads a contractor’s diary.

Free DPR format in Excel — the fields that actually matter

Every contractor we have worked with eventually settles on a near-identical Excel structure. Steal it directly:

Section 1: Header (5 fields)

• Project name
• Site location
• Date (today)
• Day count from project start (e.g., “Day 142 of 480”)
• Weather (clear / overcast / rain / extreme heat)

Section 2: Manpower table

Three columns: Trade (mason, bar bender, shutter carpenter, electrician, plumber, helper, supervisor), Number planned, Number present. If the planned and present columns differ by more than 15%, the supervisor has to write a one-line reason in a fourth column. Total at the bottom.

Section 3: Activities executed

Two columns: Activity description (with grid reference or floor number — “shuttering for slab on grid B4 to D7, 3rd floor”), and unit/quantity completed. This is where most DPRs go wrong — the activity is written as “slab work” instead of “shuttering for slab on grid B4 to D7, 3rd floor, 86 sqm.” Specificity is everything.

Section 4: Material received and consumed

Two mini-tables side by side. Material received: item, quantity, supplier, gate-pass number. Material consumed: item, quantity, where used (which work order or activity). The discipline of writing the material consumption against a work order is what makes material reconciliation possible later.

Section 5: Critical-path status

Three numbers — planned cumulative %, actual cumulative %, and variance. Plus one line of context. If the project is 38% complete on plan and 35% in reality, the line should say “behind by 3% due to TMT supplier delay last week, expected recovery by Friday.”

Section 6: Issues and blockers

Five columns: issue description, raised on date, severity (low/medium/high), owner of resolution, expected resolution date. Anything older than 7 days should be flagged red. Anything older than 14 days should be on the project manager’s morning call.

Section 7: Plan for tomorrow

Three to five line items. Activity, target quantity, assigned trade, materials needed. If tomorrow’s plan needs material that has not been ordered, that is a blocker that should appear in section 6 today.

Section 8: Photos

Five to ten timestamped photos with one-line captions. Not 50. The discipline of choosing the 5 to 10 most informative photos is more valuable than uploading everything.

Section 9: Sign-off

Site engineer name, supervisor name, time of submission. Optional — owner acknowledgement on receipt.

That is the entire format. Nine sections, one A4 page (or two with photos), readable in 90 seconds. Build it once in Excel, lock the headers, and use it forever.

Five mistakes that kill 90% of DPRs

Mistake 1: Vague activities

“Brick work” instead of “brick work for partition wall, room 4B, 4th floor, 22 sqm completed.” The first version tells you nothing six months later. The second version is searchable, billable, and disputable.

Mistake 2: Photos without timestamps and captions

An untimed photo is a rumour. A timestamped photo with a one-line caption (“3:40 PM, slab pour grid B4-D7, 86 cum, vendor: Ultratech”) is evidence. The site engineer who takes 90 seconds extra per photo is the one whose contractor wins the next project.

Mistake 3: Manpower numbers that never tie back to attendance

The DPR says 47 workers on site. The biometric attendance system says 39. The supervisor’s salary register says 52. Three different numbers in the same building. This is why proper labour attendance and payroll integration is the single highest-leverage upgrade most contractors can make.

Mistake 4: No issue log

The TMT supplier was 3 days late. Nobody wrote it down. Six weeks later when the slab is delayed, nobody can prove the delay started with TMT — and the contractor eats a penalty he did not cause. Issue log entries are insurance.

Mistake 5: Reports submitted at midnight

If the DPR lands in the project manager’s inbox at midnight, it gets read at 9 AM tomorrow, by which time the site is already running. The DPR has to be in the PM’s hands by 7:30 PM at the latest, while the supervisor is still on site and can answer questions.

Should you be doing this in Excel at all in 2026?

The honest answer: Excel works for one site. It does not work for two or more.

The moment you have multiple active sites, multiple supervisors, and an owner who wants to see all of them in one view, Excel breaks down. Every site has its own version of the template, every supervisor formats it differently, and the project manager spends Sunday night manually copy-pasting numbers from 6 spreadsheets into a master view.

This is exactly what DPR software like Trackovo was built to solve. Same nine-section format, except the supervisor fills it on his phone in 5 minutes, photos are timestamped automatically, the project manager sees all sites in one dashboard, and the owner gets a clean weekly summary without anyone spending Sunday night in Excel.

That said — if you are running one site and you have a disciplined site engineer, the Excel template is genuinely fine. Do not buy software you do not need. Buy it the day your second site starts.

The DPR habit that separates good contractors from great ones

Here is the single discipline that, more than any template or tool, distinguishes contractors who consistently deliver on budget from those who do not:

The DPR is filed before the supervisor leaves the site.

Not at home. Not at 11 PM after dinner. Not “first thing tomorrow.” Before he physically leaves the site that day. Because the moment he steps off site, he stops remembering details. The activity becomes “we did slab work” instead of “we poured 86 cum from 2:40 to 4:15 PM, two workers stopped the chute briefly because of an electrical conduit conflict on grid C5 which we have flagged for tomorrow.”

You cannot reconstruct that level of detail from memory four hours later. You can only capture it on the spot. Every DPR system that has ever worked on an Indian construction site has been built around this single discipline.

Where to start

If you do not currently have a DPR format at all, your week looks like this:

1. Today: Build the 9-section template in Excel. Lock the headers. Email it to every site supervisor.
2. Tomorrow: First DPR submitted from every site, before supervisor leaves. Project manager reviews each one before bed.
3. Day 3: First feedback round — what fields are people skipping, what fields are confusing, what is missing.
4. End of week 1: Stable template, every site reporting daily, project manager reviewing every morning at 9 AM.
5. End of week 2: If you have more than one site, evaluate whether to move to a DPR software that handles multi-site reporting natively. If you have one site, stay on Excel until you have two.

That is the entire roadmap. No certification, no consultant, no six-week implementation. Just a template, a deadline, and the discipline of filing before leaving the site.

Want to see what a 5-minute DPR looks like on a real Indian site, on a phone, with photos timestamped automatically and the dashboard updating in real time? Book a 15-minute Trackovo demo on WhatsApp — straight from the founder, no form to fill.