Utility and Service Accounts Register

Who this is for

Every account the house pays, on one page. Gas, electricity, water, broadband, phone, TV, council or local charges, insurance, waste — one line each with the supplier, the account number, the tariff or plan, how and when it is paid and when the contract ends. The monthly figures total and the days left count down.

Anyone who has just moved in and is setting the accounts up, households where somebody else may have to ring a supplier, and people who want to see what the house costs a month before a renewal conversation.

What this helps you track

• Which supplier provides what, with the account number to quote
• The tariff or plan name, so you know what you are actually on
• How each one is paid and on which day of the month
• What each costs a month, at the figure on your own bill
• When each contract ends, and how many days that is from today

How to use it

1. Write the address, the period the sheet covers and the currency at the top.
2. Add a line per account, taking the supplier, account number and tariff from the most recent bill or the online account.
3. Fill in how it is paid and the day of the month the payment leaves, so a missed payment can be traced.
4. Write the monthly amount as it appears on the bill. Where a bill is quarterly or annual, divide it yourself and note that you did.
5. Enter the contract end date where there is one; the days-left column and the summary count down in the browser and the workbook.
6. Keep the sheet with the household binder and update a line whenever a supplier, tariff or amount changes.

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

Where do I find the tariff or plan name?

On the bill, usually near the account number, or in the online account under the plan or tariff details. It is worth writing down because it is what a supplier will ask when you ring.

What if a bill is not monthly?

Divide it into a monthly figure yourself and say so in the notes, or leave the monthly column blank for that line. The total only adds what you typed.

Does days left show something for accounts with no contract?

Leave the contract end date blank and the column stays blank. Rolling accounts without an end date are still worth a line for the account number and payment day.

Does the sheet tell me whether I am paying too much?

No. It shows what you pay and when each contract ends, which is the information a comparison needs. Whether a tariff is good value depends on your usage and what is on offer where you are.

Is this the same as the policy renewal calendar?

They overlap on purpose in one or two rows. The renewal calendar is about dates and premiums for things that renew; this register is about the accounts a house pays month by month and the details needed to manage them.