Cost-code budget for a build: original budget plus change orders, committed and actual cost from invoices, and overrun warnings per line.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Budget lines, Costs
Fields
21
Views
grid, dashboard, calendar
The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
12 fields · 7 sample rows
| Cost itemText | DivisionSingle select | Cost typeSingle select | Original budgetCurrency | Change ordersCurrency | Revised budgetFormula | CommittedCurrency | CostsLink to another table | Actual costRollup | RemainingFormula | % spentFormula | Forecast overrunFormula |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Excavation & backfill | Site work | Subcontract | ₹8,50,000 | ₹0 | ₹8,50,000 | ₹8,20,000 | RA bill 1 — excavation | ₹8,20,000 | ₹30,000 | 96% | ₹0 |
| Raft foundation | Foundation | Subcontract | ₹32,00,000 | ₹2,40,000 | ₹34,40,000 | ₹34,40,000 | RA bill 1 — raft, RA bill 2 — raft | ₹35,20,000 | ₹-80,000 | 102% | ₹0 |
| RCC frame — G+4 | Structure | Subcontract | ₹98,00,000 | ₹0 | ₹98,00,000 | ₹1,01,50,000 | RA bill 1 — frame | ₹24,50,000 | ₹73,50,000 | 25% | ₹3,50,000 |
| Electrical & plumbing rough-in | MEP | Subcontract | ₹26,00,000 | ₹0 | ₹26,00,000 | ₹12,00,000 | ₹0 | ₹26,00,000 | 0% | ₹0 | |
| Flooring & paint | Finishes | Material | ₹21,00,000 | ₹-1,50,000 | ₹19,50,000 | ₹0 | ₹0 | ₹19,50,000 | 0% | ₹0 | |
| Building permit & approvals | Permits & fees | Fees | ₹4,50,000 | ₹0 | ₹4,50,000 | ₹4,50,000 | Municipal approval fees | ₹4,50,000 | ₹0 | 100% | ₹0 |
| Contingency (5%) | Contingency | Fees | ₹9,50,000 | ₹-90,000 | ₹8,60,000 | ₹0 | ₹0 | ₹8,60,000 | 0% | ₹0 |
9 fields · 5 sample rows
| InvoiceText | Budget lineLink to another table | VendorText | DateDate | AmountCurrency | Retention heldCurrency | Net payableFormula | PaidCheckbox | Invoice copyAttachment |
|---|---|---|---|---|---|---|---|---|
| RA bill 1 — excavation | Excavation & backfill | Earthmovers India | 20 Sep 2026 | ₹8,20,000 | ₹41,000 | ₹7,79,000 | Yes | |
| RA bill 1 — raft | Raft foundation | Solid Base Constructions | 10 Oct 2026 | ₹19,00,000 | ₹95,000 | ₹18,05,000 | Yes | |
| RA bill 2 — raft | Raft foundation | Solid Base Constructions | 30 Oct 2026 | ₹16,20,000 | ₹81,000 | ₹15,39,000 | ||
| RA bill 1 — frame | RCC frame — G+4 | Skyward Structures | 11 Nov 2026 | ₹24,50,000 | ₹1,22,500 | ₹23,27,500 | ||
| Municipal approval fees | Building permit & approvals | PMC | 21 Aug 2026 | ₹4,50,000 | ₹0 | ₹4,50,000 | Yes |
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
Line up subcontractor bids for each work package side by side — price with tax, duration, warranty and score — and award the best one.
2 tables · 24 fieldsBid Tabulation TemplateA classic bid tab: each BOQ line priced by three bidders against the engineer’s estimate, with extended totals and the lowest bidder per line.
1 table · 15 fieldsBill of Materials TemplateEvery component needed for a build with quantity, unit cost, extended cost and order status, tied to suppliers and their lead times.
2 tables · 23 fieldsClient List TemplateA tidy list of every client for any service business — contact details, visits, spend and how long since you last saw them.
1 table · 16 fieldsConstruction ChecklistPhase-by-phase site checklist from pre-construction to handover, with owners, due dates, required inspections and photo proof.
1 table · 10 fieldsConstruction CRMTrack clients from first site visit to signed contract, keep a vetted contractor roster with insurance expiry, and schedule every job.
3 tables · 33 fields