Buildings Insurance Premium Split Calculator

Who this is for

One premium, divided fairly between the flats. The sheet keeps the block policy's key details and cover on one side and applies each flat's share to the premium on the other, so every leaseholder can see how their part was worked out.

Freeholders, management company directors and residents who arrange a block buildings policy and recharge the premium to each flat.

What this helps you track

• The insurer, policy number, renewal date and sum insured
• What the policy covers, with limits and excesses
• Each flat's share of the premium, from the percentages you enter
• Which flats have been invoiced and which have paid
• Any part of the premium not yet allocated to a flat

How to use it

1. Copy the insurer, policy number, renewal date and the total premium from the policy schedule.
2. Write the sum insured on the first row of the policy schedule, then list the main cover items with whether each is included, its limit and its excess.
3. Enter each flat with the share it pays, taken from the lease or whatever basis your building has agreed.
4. The premium share, outstanding amounts and unallocated balance are worked out in the browser and the workbook; on paper, multiply the premium by each share.
5. Record the date each flat was invoiced and what it has paid, and check the shares add up to the whole premium.

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

How should the premium be divided?

Use the proportion set in each lease if there is one, or the basis your building has agreed, such as floor area or equal shares. The sheet applies whatever percentages you enter and does not suggest any.

What if the shares do not add up to 100?

The summary shows the part of the premium left unallocated. A figure other than zero usually means a flat is missing or a share has been mistyped.

Should insurance premium tax or fees be included?

Enter the total premium as billed, including any tax and fees that are shared in the same way. If a fee is divided differently, keep it off this sheet and recharge it separately.

Can each leaseholder check their own share?

Yes. The policy schedule and the calculation sit on the same page, so the sheet can be sent with the invoices and any leaseholder can repeat the sum.