Construction Daily Report Template for Mining and Civil Crews

A superintendent who leaves the site without a complete daily is working from memory the next day. The daily report is the source document for every invoice line, every delay dispute, and every MSHA inspection record for that shift. Get the fields right and the rest of the month follows. Skip one and the number has to be reconstructed, which means it will be wrong or it will be fought over.

This template works for underground drilling, open-cut excavation, and any heavy civil crew billing on a time-and-materials or schedule-of-rates contract. The equipment checksheet fields draw from the MSHA Small Mine E-Guide and 30 CFR § 77.1713, both of which require a documented shift-level examination before a machine goes into service.

Crew hours, equipment hours, quantities, delays, and signatures. Five field groups, each with a direct invoice line. When a delay goes uncoded, that billing line disappears. When the mine representative's signature is missing, the quantities are disputable. Equipment hours cannot be combined into a single total without losing the standby rate.

Worked example

A 4-person underground drilling crew logs a day shift at a gold mine. Contract rates for this example: $88 per person-hour labor, $195 per drill-hour productive, $148 per drill-hour standby. The shift daily shows 4 crew members at 12 hours each, 9.5 productive drill hours, and a 2-hour standby delay while waiting for the explosives crew - coded SC (service crew standby, client-caused).

Answer: One correctly coded 2-hour client delay adds $296 to Tuesday's invoice. The same delay uncoded produces a $296 gap per shift. Over 22 shifts in a month with the same pattern, the unbilled standby reaches $6,512.

What a Construction Daily Report Must Capture

Five field groups make up a complete shift record. Every group answers a question the invoice or an auditor will eventually ask.

Crew. Name, classification, start time, finish time, regular hours, overtime hours, task code. This group produces the labor lines on the invoice. Classification matters because drill operators, offsiders, and supervisors bill at different rates on most schedule-of-rates contracts. The task code splits hours by cost center so the same crew can work two headings in a shift and the cost stays separate.

Equipment. Asset ID, description, productive hours, standby hours, breakdown hours, meter start, meter end, delay code. Equipment hours cannot go onto the form as a single total. A drill that ran 9.5 hours and sat idle for 2 carries three distinct billing states: productive time at the operating rate, client-caused standby at the standby rate, and contractor-caused breakdown which does not bill. Collapse all three into one number and the standby rate is gone before the form leaves the site.

Quantities. Activity, unit of measure, plan, actual, variance, notes. This is the production record: meters drilled, cubic meters excavated, tons hauled. The variance column is not optional. A planned-vs-actual gap that is not explained on the daily becomes a dispute at invoice time, and the first question the client asks is why it was not flagged when it happened.

Delays. Start time, end time, duration, delay code, cause in plain language, responsible party, billable flag. This is the group most often incomplete and the group most likely to cost money. A delay without a responsible party cannot be billed as standby. A 2-hour explosive crew wait that goes uncoded is 2 hours the contractor absorbs.

Signatures. Superintendent name and signature, mine representative name and signature, time of each. The mine representative's signature is client acceptance of that shift's quantities and hours. Without it, the client is agreeing from memory at the end of the week.

30 CFR § 77.1713 requires a daily on-shift examination at surface coal operations by a certified person, with a written report of findings. The MSHA Small Mine E-Guide publishes a motor grader checksheet with 20 items covering engine levels, tires, lights, brakes, and back-up alarm operation (MSHA Small Mine E-Guide, 56.14100 Mobile Equipment, p. 84). That checksheet result feeds the breakdown hours field on the daily: a machine pulled off shift for a failed item is breakdown, not standby.

The Template

Copy this and adapt the column headers to your contract's rate schedule language.

CONSTRUCTION DAILY REPORT

CREW HOURS

EQUIPMENT HOURS

QUANTITIES PRODUCED

DELAYS

MATERIALS USED

SAFETY

Daily equipment checksheet completed and on file: Yes / No

SIGNATURES

How Each Field Maps to an Invoice Line

The SME Mineral Processing and Extractive Metallurgy Handbook identifies daily reporting as the tier where operators, supervisors, and shift leads manage daily targets and resolve immediate issues (SME Mineral Processing and Extractive Metallurgy Handbook, 2.6 Process Control and Operational Intelligence, p. 302). The daily report is not the summary. It is the raw evidence the summary draws from.

The breakdown hours column is the one field that never earns anything. Every hour coded as breakdown is a cost the contractor absorbs. This is why the distinction between standby and breakdown matters: a crew waiting on an explosive charge that arrives late is standby (client-caused). The same crew waiting on a drill repair is breakdown (contractor-caused). The code is the only place that distinction lives.

To size what the full reporting chain costs in office time - from the superintendent's handwritten form through the retype into the invoice - the reporting-chain-cost calculator works through each handling step with your own inputs.

Construction Daily Report Format: Excel Setup

For most small and mid-size contractors, Excel remains the daily reporting tool. The format question is not which software to use. It is whether the column headers in the spreadsheet match the invoice line items exactly.

Three components make an Excel daily format that does not break at invoice time.

One tab per shift. Name each tab by date and shift (2026-10-07-Day, for example). Do not merge shifts or weeks into one tab. Disputes trace back to specific shifts, and finding a single number inside a merged tab takes longer than the dispute is worth.

A master rollup tab. This tab pulls totals from the shift tabs using SUMIF formulas keyed to task codes and asset IDs. The rollup becomes the invoice backup with no retyping. Every hour already exists in a shift tab; the rollup adds it up. The SME Mining Reference Handbook's work-order form (SME Mining Reference Handbook, Citations and Regulations, p. 395, FIGURE 21.7) separates equipment sections from materials sections. The same principle applies here: equipment hours and crew hours occupy separate tables so either can be totaled without reading both.

Column headers that match the invoice. If the invoice reads "Labor - Straight Time," the column reads "Reg Hrs." If the invoice reads "Equipment Usage," the column reads "Prod Hrs." When the headers correspond, the rollup-to-invoice step is mechanical. When they do not, someone translates, and translations introduce errors.

One practical addition: a carry-forward row at the top of each shift tab that pulls the previous day's ending meter reading from the tab before it. Equipment hours are then calculated as today's ending meter minus today's starting meter. Without the carry-forward, the starting meter is entered by hand, and the starting meter is the number entered wrong most often.

Delay Codes: The Field Most Often Left Blank

A delay code is a short reference that identifies why a crew or machine stopped producing. The code alone is not enough. A complete delay entry needs three things together:

1. The delay code (what type of delay) 2. The cause in plain language (what actually happened) 3. The responsible party (client-caused or contractor-caused)

Without the responsible party, a delay is ambiguous at invoice time. Without the cause, the responsible party can be contested. Without the code, there is no label to attach it to on the monthly summary.

A working delay code set for underground drilling:

The field most often blank is Responsible Party. It is blank because the superintendent does not want to create an argument on shift. The right approach is to flag it before the mine representative signs. A signature on a daily that includes a coded client-caused delay is the client's acknowledgment of that delay. A claim made two weeks later on the invoice is a negotiation, not a record.

Signatures and What They Prove

The superintendent's signature certifies the record is accurate. The mine representative's signature certifies the client has seen and accepted it.

Both are required and neither substitutes for the other. A superintendent signing alone is evidence of internal accuracy. It is not evidence the client agreed to the quantities. A mine representative who was present at shift end and did not sign leaves the shift open for dispute.

The practical rule: hand the daily to the mine representative before the shift ends. Give them time to ask questions. A question answered on shift costs nothing. A question answered at invoice time costs a week and often costs half the line item.

One field worth adding to the signature block: the time of signature. A mine representative who signs at 06:00 for a shift that ended at 22:00 is signing from memory. A signature time that matches the shift end time is evidence of presence, not reconstruction.

The SME Mineral Processing and Extractive Metallurgy Handbook places shift-level data at the operator and supervisor tier, with the objective of achieving daily targets and resolving immediate issues (SME Mineral Processing and Extractive Metallurgy Handbook, 2.6 Process Control and Operational Intelligence, p. 302). The mine representative signature is the moment operational data becomes a shared record. Before that signature, the shift is still open. After it, the client has accepted the numbers.

Run your own numbers

Rather than work it by hand every time, the reporting chain cost calculator does this arithmetic and shows its working. The rest of the set is on the mining calculators page.

Common questions

All field tools