A building-budget spreadsheet that separates changes from payments

You may have paid very little while committing to expensive changes. Or a large deposit may have left your account before much work is visible. Neither situation is explained well by a spreadsheet that contains only a quotation total and a list of bank transfers. A useful building ledger shows both obligations and cash.

The structure below is an owner's tracking method, not a replacement for accounting, contract administration or professional valuation of the work. Begin with the complete Spanish house-building budget so the contract you are monitoring is not mistaken for the whole project.

Give the original agreement a fixed reference

Save the accepted quotation with its date and revision, then assign stable codes to its sections. Keep that original version intact. When a contractor issues a differently arranged invoice, map it to the codes rather than silently rewriting the baseline. Otherwise you lose the ability to explain a change in the total.

State the boundary of the sheet at the top: building contract only, project excluding land, or overall investment. Specify whether the figures include tax, and keep unlike bases separate. Resolve omissions using our construction quotation comparison guide before loading data. A perfectly working spreadsheet still produces a misleading comparison if the underlying scopes are different.

Use separate columns for separate questions

For each section, record original amount, approved changes, revised approved amount, certified work and payments made. Keep proposed changes in a separate register until they are decided. This exposes possible future pressure on the budget without presenting every idea as an agreed commitment. Record agreed reductions as well as additions.

The owner's guide to Spanish construction terms explains vocabulary you may see in supporting documents. Agree what counts as certified, invoiced and paid in your own process. An invoice is not automatically technical confirmation of completed work, and payment does not prove that a section has been finished. Each status needs an identifiable document or check behind it.

Test the totals with a small worked example

These are illustrative figures for one fictional contract, all in euros excluding tax. They are not market estimates. Put the section name in column A, original amount in B, approved change in C, revised amount in D, certified amount in E and payments in F. For row 2, the revised amount is =B2+C2.

Using =SUM(D2:D4) gives a revised approved amount of 203,000. Certified work totals 50,000 and payments total 40,000. Certified but unpaid work is therefore 10,000; the approved amount still unpaid is 163,000. Adding certified work to the revised contract would count the same cost twice. Deposits need their own reconciliation when later invoices deduct them.

Keep a change log that survives a disagreement

Give each change a reference, description, requester, price, status and approval document. Record any effect on timing. “Better kitchen” cannot explain a later invoice; an identified substitution with its associated work can. Where the price is still uncertain, show an allowance and the question required to replace it.

Microsoft's SUMIF function adds values meeting a condition and can support an approved-change total. Function names and separators depend on your Excel language settings. Before relying on the summary, test a positive change, a reduction and an unapproved proposal. The approval itself must be a recorded decision, not something inferred because a number happened to appear in the calculation.

Reconcile payment records with the work records

Record invoice reference, due date, payment date, amount and bank reference. When one transfer covers several items, allocate it transparently rather than copying its full value into each section. Keep disputed sums or contractual retentions visible according to the actual agreement; they are not automatic savings. Store the supporting documents somewhere the people responsible can access.

Review the sheet against the building certificates and payment checks at a regular interval. If the contractor and your technical adviser use different progress figures, identify the reason. A documented monthly reconciliation is usually more informative than constant edits that mix estimates, invoices and memories without a consistent rule.

Make a separate forecast of when cash is needed

The cost ledger tells you about scope and commitments. A payment forecast tells you when money must be available. Put expected payments beside realistic funding dates, including deposits and decisions that trigger orders. If the project depends on staged finance, verify the conditions for drawing funds through the Spanish self-build mortgage process.

Do not treat a discussion with a lender as cleared money. Try a scenario in which a financing stage or sale of another property takes longer than planned. Identify which commitment becomes difficult and what decision you could make in advance. This is a planning exercise, not a prediction of delays or a recommended financing product.

Close the month with a version you can explain

Distinguish input cells from formulas, protect calculations where useful and save a dated copy of each close. Review duplicate references, negative amounts and totals. If an old entry changes, write down why. Someone joining the project later should be able to understand the difference between the original agreement and the current position without reconstructing every conversation.

The project budget calculator helps organise the overall funding picture; your ledger then follows the actual decisions and payments. To discuss the scope behind those numbers, tell us about your build and which quotations or drawings you already have. Clear inputs are the most valuable improvement you can make to either tool.