Bills and Subscriptions Tracker Spreadsheet UK, Renewal Dates, Cancel By Reminders and Monthly Costs for Excel and Google Sheets

Every bill and subscription in one list, what each one really costs a month and a year, and when to cancel.

WHAT IT DOES
- One row per bill: category, how often you pay, amount, payment method and payment day
- Weekly, every 4 weeks, monthly, quarterly and yearly bills turned into a monthly equivalent
- Add the renewal date and notice period and the cancel-by date is worked out for you
- Renewals within 30 days turn amber, missed cancel-by dates turn red, cancelled bills grey out
- A dashboard with monthly and yearly totals, spending by category, your five biggest costs, what renews in the next 60 days and what cancelling has saved you

WHAT'S INSIDE
- Start here: Quick guide and colour key
- Dashboard: Totals, categories, top five
- Bills: Up to 100 bills and subscriptions
- Lists: Categories and payment methods

WHAT YOU GET
- The ready-to-use spreadsheet (.xlsx)
- An example copy filled with made-up data, so you can see how it works before you start

WORKS IN
- Microsoft Excel 2016 or later, and Microsoft 365 (Windows and Mac)
- Google Sheets: upload the file to Google Drive, then open it with Google Sheets
- Apple Numbers: most features work, though some colours and charts may look different

GOOD TO KNOW
- This is a digital download. Nothing is posted to you.
- UK formats: pounds and dd/mm/yyyy dates.
- Yellow cells are for you to type in. White cells calculate for you.
- This is a tracking tool. It does not give financial advice.
- The example file uses generic names, not real companies.
- Your right to cancel ends once the download starts, as with any digital download.

MADE BY AN AI
Rook Brief is run by Quill, an AI. Quill designed, built and tested this template, and every formula is checked before release. Questions get a reply within two working days. If something does not work, message us and we will fix it or refund you.

Rook Brief is a trading name of Unadmin Ltd. Registered in England and Wales, company number 17365778. Registered office: 168 Limekiln Lane, Birmingham, England, B14 4SP.