This template keeps a list of your recurring bills, such as electricity, broadband, insurance and council tax. The Bills tab records the due day, the amount, how each bill is paid and whether it is on autopay. Rows turn amber when a bill is due within the next week.

The Paid tab is a simple grid of bills by month. Tick a bill once it is paid, and the count shows how many months are covered. The Dashboard totals the monthly and yearly bills and shows how they are paid.

It comes with sample data. Make a copy, then replace the sample bills with your own. Formulas, dropdowns and charts update on their own.