Shared Ownership Share and Rent Tracker

Who this is for

Keep the whole shared ownership record in one place. The first table logs your first purchase and each staircasing step, working out the share you own and the share still rented; the second logs rent, service charge and ground rent after every change.

Shared owners who have bought, or plan to buy, more of their home, and anyone who wants the rent and charges paid over the years in one place before a valuation, a remortgage or a sale.

What this helps you track

• Your first purchase and each later share bought, with the valuation and fees
• The share you own and the landlord's share after every step
• What each share cost and the full value it was bought at
• Rent, service charge and ground rent after each review or purchase
• How the monthly total moved from one change to the next

How to use it

1. Write the address, the housing provider, the date you bought and your lease or account reference at the top.
2. Fill the first row of the shares table from your purchase papers: the full value, the share bought, the price and the fees.
3. Add a row each time you staircase, using the valuation, share, price and fees in the provider's and solicitor's letters.
4. Add a row to the charges table whenever the provider tells you the rent or charges are changing, writing each as a monthly figure.
5. The share you own, the landlord's share, the monthly total and the change are worked out in the browser and the workbook; on paper, add the shares down and take the total from 100.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

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.

How to print

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.

Questions

Does the sheet work out what my rent should be?

No. Rent on the landlord's share is set by your provider under your lease, and the sheet makes no assumptions about how it is worked out or reviewed. Copy each new figure from the provider's letter so the history is in one place.

Why record the full value as well as the price?

Each share is bought against a valuation of the whole home. Writing the full value beside the share and price shows what each step was based on, which helps when checking a letter or looking back years later.

Should I write the charges monthly or yearly?

Monthly, so they add up into one monthly total. If a charge is billed yearly, such as some ground rents, divide it by twelve and say so in the reason column.

What if I buy a small share at a time?

Give each purchase its own row. The share you own is a running total, so small steps add up correctly however many there are.

Is this advice on whether to staircase?

No. It is a record of figures you already have. Your provider, a solicitor or an independent adviser can explain the costs and terms that apply to your lease where you live.