Broadband and Mobile Contract Tracker

Who this is for

Every broadband, TV, landline and mobile contract in one list. Each line holds the provider, monthly cost, contract end date, notice period, the month prices go up and any early exit fee, and the days left are counted from your review date. The summary totals the monthly and yearly cost and counts contracts that are already out of term.

Households paying for several phone, broadband and TV contracts who want to catch each one as it ends instead of rolling on at a higher price.

What this helps you track

• Every broadband, TV, landline and mobile contract in the house
• The monthly cost of each and the total for the household
• When each contract ends and how many days remain
• The notice needed, the month prices rise and any exit fee
• Which contracts are already out of term and worth reviewing

How to use it

1. Write the household and today's date as the review date at the top.
2. Give each service a line: who it is for, the provider and account number, the monthly cost and the contract end date from your latest bill or account page.
3. Add the notice period, the month the annual price change applies and the early exit fee your contract states.
4. Days remaining, out-of-term flags and the totals are worked out in the browser and the workbook; on paper, count forward from the review date.
5. Change the review date each time you look, and update the status as you negotiate, switch or cancel.

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 are days remaining counted?

From the review date in the header to the contract end date on each line. A minus figure means the minimum term has passed, and the out-of-term column shows a 1 so the summary can count them.

Where do I find the price-rise month and exit fee?

They are in your contract summary or terms, or on your account page with the provider. The sheet does not suggest figures; copy them as written so you can check them when a bill changes.

Should each mobile have its own line?

Yes. Give every SIM its own line even when they sit on one account, because they often have different end dates. Put the person's name in the service column so you know whose is whose.

Does it include streaming subscriptions?

It can, but monthly subscriptions without a minimum term sit better in a subscription tracker. Keep this one for contracts with an end date, notice period or exit fee.