Property development cost spreadsheet template
A working Excel template for tracking what a development actually costs: one sheet of supplier invoices coded by plot and cost head, one linked sheet of line items, and a budget-versus-actual sheet whose actual column is a live formula over your invoice rows rather than a number you retype. Free, no sign-up and no email address.
What is in it
| Sheet | One row per | What it does for you |
|---|---|---|
| Invoices | Supplier invoice | Date, supplier, invoice number, plot or unit, cost code, net, VAT, gross, paid. Gross calculates itself from net and VAT. |
| Line items | Purchased item | Description, quantity, unit price, line total and a “total includes VAT?” column, linked to its invoice number. |
| Budget vs actual | Cost code | Your budget beside a live SUMIF of everything coded to it, and the variance. Nothing to retype. |
Why the cost codes are not a builder's
Acquisition, planning, professional fees, build, utilities, finance, legal, marketing, contingency. A developer who tracks groundworks and frame is tracking their contractor's job; the costs that decide whether a scheme works are the ones around the build. Finance in particular is the line most often left out of a spreadsheet and most often the reason the numbers stop working.
Why costs are carried per plot
A scheme total tells you whether you are over budget. A plot column tells you which unit is carrying it, which is the question you need answered before you can do anything about it — and it is the one thing you cannot reconstruct later if you did not record it as the invoices arrived.
Why the VAT basis column is there
It looks like clutter until you know that invoices genuinely disagree. In our field-by-field study of 87 published invoices, 26 line rows stated a tax-inclusive total against 173 exclusive, with 22 undetermined. Those are counts from that corpus rather than a rate to expect anywhere else, but they are enough to show both kinds arrive in ordinary paperwork — and a column that mixes them without recording which is which can be summed into a figure nobody can check.
Filling it in without typing
The template is the easy half. The work is turning a folder of supplier PDFs, scans and phone photos into those rows. That is what Invoices to Spreadsheets does. Its export carries supplier, invoice number, net, VAT and totals; the plot, the cost code and paid status stay yours, because no extraction can decide them. Try one invoice free, without an account.
Building rather than developing? The construction job cost template uses trade cost codes instead.
Is the property development cost spreadsheet template free?
Yes. Download it, use it, change it. No account, no email address, no card.
How is this different from a construction job cost template?
Two things a build sheet does not track. Every invoice carries a plot or unit, so you can see what each one has absorbed rather than only a scheme total. And the cost codes are the ones that decide whether a development works — acquisition, planning, professional fees, finance, legal, marketing and contingency — not groundworks and frame, which belong to your contractor.
What is in the template?
Three sheets. Invoices — one row per supplier invoice, with plot, cost code and a gross column that adds itself up. Line items — one row per purchased item, linked to its invoice number. Budget vs actual — one row per cost code, where the actual column is a live SUMIF over your invoice rows, so it is never out of date.
Why is there a "total includes VAT?" column on the line items sheet?
Because invoices disagree. In our own study of 87 published invoices we found 26 line rows stating a tax-inclusive total against 173 exclusive, with 22 we could not determine. Those are counts from that corpus, not a rate to expect anywhere else — the point is that both kinds turn up in ordinary paperwork, so summing a column that mixes them without recording which is which can produce a figure nobody can check.
Can I change the cost codes?
Yes. Edit them on the Budget vs actual sheet and use the same code in the invoice rows — the SUMIF matches on whatever you type. Keep CONTINGENCY: a development without one is a forecast, not a budget.
Does it work in Google Sheets or Numbers?
Yes. It is a standard .xlsx and the formulas are SUMIF, SUM and IF, which both import cleanly. Set your locale before importing so dates and £ parse as dates and numbers.
Do I have to type the invoices in by hand?
That is the part this template cannot do for you. Filling it from a folder of PDFs, scans and photos is what Invoices to Spreadsheets does. Its export gives you supplier, invoice number, net, VAT and totals; the plot, the cost code and whether it has been paid are yours to add, because no extraction can decide them for you.
7 days · 50 documents · No card needed