Money tips

Track Bills Due on Different Dates With a Simple UK Spreadsheet

A spreadsheet with TODAY and EDATE formulas shows the days left on each bill and the total due in the next fortnight. Works in Excel and Google Sheets.

Editorial illustration for Track Bills Due on Different Dates With a Simple UK Spreadsheet

A small spreadsheet can show every bill's next due date, how many days are left and how much you need in the next fortnight. You need four columns and three formulas: TODAY to count the days, IF to flag urgent ones and EDATE to roll the date forward once a bill is paid.

What does the sheet look like?

Set up headers in row 1: Bill, Amount, Next due, Days left, Status. Then enter your bills from row 2. Here is a made-up example in pounds.

BillAmountNext dueDays left (on 10 June)
Rent£8501 July21
Broadband£2815 June5
Phone£1420 June10
Home insurance£2228 June18

Which formulas do you need?

  • Days left, in D2: =C2-TODAY() and fill down. Format column D as a number, not a date.
  • Status, in E2: =IF(D2<0,"OVERDUE",IF(D2<=5,"DUE SOON","ok")). It shows OVERDUE for past dates, DUE SOON for five days or fewer, and ok otherwise.
  • Roll forward, in C2 after you pay: =EDATE(C2,1). It moves the date one month on, and you format the cell as a date.
  • Total due in the next 14 days: =SUMIFS($B$2:$B$20,$D$2:$D$20,">=0",$D$2:$D$20,"<=14").

These work in both Excel and Google Sheets. TODAY recalculates every time you open the file, so the days left stay current. Check that your Amount column holds numbers, not text with a pound sign typed in by hand; format the column as currency instead.

How do the formulas behave on the example?

On 10 June, broadband due 15 June shows 5 days and DUE SOON. Phone due 20 June shows 10 and ok. The total for the next 14 days adds the bills with days between 0 and 14: £28 + £14 = £42. Rent on 1 July is 21 days away and insurance on 28 June is 18 days away, so neither is counted yet.

After you pay broadband, type =EDATE(C3,1) into its date cell, and the next due date becomes 15 July.

Should you add a column for the account?

Yes. Add a Paid from column, such as Current account or Credit card. Then sort by that column before payday to see how much each account needs. Using the example, if rent and insurance leave the current account, you need £850 + £22 = £872 there, while the phone and broadband on a card need £42.

What if a bill has no fixed date?

Some bills arrive when the supplier sends them. For those, enter the date the last one was due as an estimate and put 'est' in a Notes column. When the real bill arrives, overwrite the date and the amount. If an estimated bill passes its date and nothing has arrived, the OVERDUE flag becomes a prompt to check your emails and your statement, not necessarily a sign that you have missed a payment.

Keep one row per bill even if two bills share a due date. A shared row hides one of them the moment you roll the date forward.

A weekly routine

  1. Open the sheet and read the Status column.
  2. Pay or schedule anything marked DUE SOON.
  3. Roll forward the date for anything paid.
  4. Check the 14-day total against the account balance.

When a sheet stops being enough, for example when you want payments from bank statements sorted into categories, SpendixAI can import statements, though it is built around India and INR rather than pounds.

Before you close the sheet

  • Dates are real dates, not text.
  • Amounts are numbers.
  • The ranges in your SUMIFS reach beyond your last bill row.
  • You have saved a copy in case an edit breaks a formula.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports