Shared Flat Bills Split Calculator
Every bill due this month, who supplies it and when it is due.
Students and Shared Living · US-964 · Form
Student accommodation comparison spreadsheet: halls and private lets side by side on rent, bills, contract weeks and total cost. Excel, PDF 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.
Halls and private lets compared on the same terms. Weekly rent, extra bills and contract length are turned into a total contract cost and a monthly equivalent, so a cheaper weekly rent on a longer contract shows what it really costs.
Students choosing between halls, private student blocks and shared houses, and parents helping them weigh the options.
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.
Weekly rent plus any bills not included, multiplied by the number of weeks in the contract. The deposit is shown separately because it is normally returned, less any deductions, at the end.
The weekly total multiplied by 52 and divided by 12, the same figure a monthly rent would be over a full year. It makes a weekly rent easier to set against monthly income such as a loan split into months.
Enter 0 in the extra bills column. Where only some bills are included, estimate the weekly cost of the rest from what the landlord or current tenants tell you, and note what is covered.
No. It supplies no rents, bills or typical prices. It only lines up the figures you collect so the options can be compared on the same basis.
Every bill due this month, who supplies it and when it is due.
What each housemate paid towards the deposit, and when.
The money you have for the term and what is committed to fixed costs.
Documents and ID to have with you, not in a box.
Printable sheets, workbooks and tools on the same subject.
Compare properties on the same points instead of on whichever one you saw last, and remember the things that are easy to ask about on the day and impossible to check afterwards.
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.