Construction Budget Template

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

Construction

Tables

Budget lines, Costs

Fields

21

Views

grid, dashboard, calendar

Tables, columns and sample rows

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.

Budget lines

12 fields · 7 sample rows

  • Cost report (Grid)
  • Budget dashboard (Dashboard)
Cost itemTextDivisionSingle selectCost typeSingle selectOriginal budgetCurrencyChange ordersCurrencyRevised budgetFormulaCommittedCurrencyCostsLink to another tableActual costRollupRemainingFormula% spentFormulaForecast overrunFormula
Excavation & backfillSite workSubcontract₹8,50,000₹0₹8,50,000₹8,20,000RA bill 1 — excavation₹8,20,000₹30,00096%₹0
Raft foundationFoundationSubcontract₹32,00,000₹2,40,000₹34,40,000₹34,40,000RA bill 1 — raft, RA bill 2 — raft₹35,20,000₹-80,000102%₹0
RCC frame — G+4StructureSubcontract₹98,00,000₹0₹98,00,000₹1,01,50,000RA bill 1 — frame₹24,50,000₹73,50,00025%₹3,50,000
Electrical & plumbing rough-inMEPSubcontract₹26,00,000₹0₹26,00,000₹12,00,000₹0₹26,00,0000%₹0
Flooring & paintFinishesMaterial₹21,00,000₹-1,50,000₹19,50,000₹0₹0₹19,50,0000%₹0
Building permit & approvalsPermits & feesFees₹4,50,000₹0₹4,50,000₹4,50,000Municipal approval fees₹4,50,000₹0100%₹0
Contingency (5%)ContingencyFees₹9,50,000₹-90,000₹8,60,000₹0₹0₹8,60,0000%₹0
Field details
Cost item · Text
Division · Single select
Site work, Foundation, Structure, Masonry, Roofing, MEP, Finishes, Permits & fees and 1 more
Cost type · Single select
Labour, Material, Equipment, Subcontract, Fees
Original budget · Currency
INR
Change orders · Currency
INR
Revised budget · Formula
{Original budget} + {Change orders}
Committed · Currency
INR
Costs · Link to another table
Links to Costs
Actual cost · Rollup
sum of Amount via Costs
Remaining · Formula
{Revised budget} - {Actual cost}
% spent · Formula
IF({Revised budget}, {Actual cost} / {Revised budget}, BLANK())
Forecast overrun · Formula
MAX({Committed} - {Revised budget}, 0)

Costs

9 fields · 5 sample rows

  • Invoices (Grid)
  • Calendar (Calendar)
InvoiceTextBudget lineLink to another tableVendorTextDateDateAmountCurrencyRetention heldCurrencyNet payableFormulaPaidCheckboxInvoice copyAttachment
RA bill 1 — excavationExcavation & backfillEarthmovers India20 Sep 2026₹8,20,000₹41,000₹7,79,000Yes
RA bill 1 — raftRaft foundationSolid Base Constructions10 Oct 2026₹19,00,000₹95,000₹18,05,000Yes
RA bill 2 — raftRaft foundationSolid Base Constructions30 Oct 2026₹16,20,000₹81,000₹15,39,000
RA bill 1 — frameRCC frame — G+4Skyward Structures11 Nov 2026₹24,50,000₹1,22,500₹23,27,500
Municipal approval feesBuilding permit & approvalsPMC21 Aug 2026₹4,50,000₹0₹4,50,000Yes
Field details
Invoice · Text
Budget line · Link to another table
Links to Budget lines
Vendor · Text
Date · Date
Amount · Currency
INR
Retention held · Currency
INR
Net payable · Formula
{Amount} - {Retention held}
Paid · Checkbox
Invoice copy · Attachment

Construction Budget Template: questions

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.

Related templates