Mortgage Offer Comparison Spreadsheet
The loan amount, term and property price the quotes are based on.
Property Buying and Selling · PB-552 · Budget
Free house buying costs worksheet: survey, legal, searches, tax, mortgage fees and removals, estimated, quoted and actual. PDF, Excel and browser.
One page. The A4 and US Letter files are laid out identically, so neither is shrunk to fit.
Print it and write on it
Fillable PDF type and save
Spreadsheet formulas included
The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.
The same sheet, on screen. Totals and figures are worked out as you type, rows can be added or removed, and you can print it or download the completed version as a PDF. Everything stays in your browser — your entries are kept in this browser's own storage on this device, nothing is uploaded, and there is no account.
What buying costs beyond the deposit. List each one-off cost, from the survey to the removal van, with your early estimate, the quote you were given and what you finally paid. The sheet adds them up and shows the total cash you need alongside the deposit.
Buyers working out how much money they need to have ready, and anyone who wants to see where the final bill for a purchase ended up against their first guess.
The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.
Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.
Anything paid once because of the purchase: survey, legal fees, searches, any purchase tax, lender and broker fees, removals and the like. Ongoing costs such as the mortgage payment belong in a monthly budget instead.
No. Rates and bands differ between countries and change over time. Enter the figure your conveyancer quotes or that you work out from your tax authority's own calculator.
Estimate minus actual for each line. A positive figure means the cost came in below what you guessed; a negative figure means it cost more. The total shows the drift across the whole purchase.
Early on you only have guesses; later you have quotes. Keeping both shows how the picture changed and helps you spot a quote that is far from what you expected.
The loan amount, term and property price the quotes are based on.
The transaction and property price every firm quoted on.
The deposit target, target date and starting balance you have set.
The deposit required and the amount due at exchange.
Printable sheets, workbooks and tools on the same subject.
Have a prompt list to work through with whoever is handling the transaction, so documents are found before they are asked for rather than afterwards.
A monthly budget that adds up planned against actual, keeps income, outgoings and saving apart, and rolls twelve months into a year view.
Every sheet, binder, game and puzzle on Upkeep Papers is free to download, with no email and no account. Making them is not free: each one takes days of research, design and checking, and the site costs money to run. If something here saved you time, you can buy us a coffee. It is entirely optional: nothing is locked, and nothing changes if you don’t.
Opens PayPal in a new tab. Any amount, and nothing changes if you would rather not.