Civil Work Quotation Format in Excel: What to Include (And Where Contractors Lose Money Next)
The exact civil work quotation format used by Indian contractors — key sections, BOQ structure, and GST terms. Plus: what to do after the quote is approved to protect your margins on site.
Let's be direct: Construct Daily does not generate civil work quotations. Excel is the right tool for that, and most experienced contractors already have a working format. What this article covers is what your quotation must include — and more importantly, where the profit you quoted actually disappears once work begins on site.
Key Elements of a Professional Civil Quotation (For Your Excel Sheet)
A strong quotation protects your margins before work starts. Include these sections in your Excel format to ensure clarity and legal compliance:
- Clear Header & Project Info: Your GSTIN, the client's details, project location, and whether the quote covers labour-only, material-only, or both.
- Itemized BOQ (Bill of Quantities): A detailed breakdown of work items (Excavation, PCC, RCC, etc.) with units of measurement, quantities, unit rates, and totals. No vague line items — disputes start here.
- Tax Terms: Separate material supply (HSN codes) from labour charges (SAC code 995411) for correct GST treatment. CGST + SGST for intra-state, IGST for inter-state.
- Exclusions & Payment Milestones: State explicitly what is not included (scaffolding, debris disposal, water charges). Define advance percentage and milestone triggers upfront.
Why Contractors Who Quote Well Still Lose Money on Site
The quotation wins the project. The daily site execution determines whether you make money on it. This is where most contractors bleed:
- Labour headcount is guesswork: Your quote assumed 12 masons for 40 days. You have no digital record of actual daily attendance to verify against your cost estimate.
- Petty cash is invisible: Daily expenses — bhatta, fuel, tea, small tools — are paid in cash and never logged. Over a 3-month project, this can be ₹2–5 lakhs you cannot account for.
- Vendor dues pile up silently: You are mentally tracking what you owe three different material vendors. One of them has stopped delivering, and you don't know why until it is too late.
Use Excel for the Quotation. Use Construct Daily for What Comes After.
Once your quote is approved and the site begins, Construct Daily tracks daily labour attendance, bhatta, petty cash, and vendor bills — all from your phone. So you don't bleed out the margin you carefully quoted.
Start Free →