How to track bills in Google Sheets
Who it is for: households that pay their own bills and want one sheet that shows what is due next, using the bill amounts and dates they already know.
It is not the right fit if you need:
- a bank connection or an automatic import;
- bill payment from the sheet;
- business accounts;
- someone to tell you which bills to pay first.
This is a records method. It lists and adds up your bills; it does not give money advice.
What you will build
One sheet, one row per bill. You type five things per bill. The sheet works out the next due date, what each bill costs per year, a monthly set-aside figure, and which bills fall due in the next 14 days.
Step 1: Set up the columns
In a new Google Sheet, type these headings in row 1:
| Column | Heading | You type it, or a formula? |
|---|---|---|
| A | Bill | You type |
| B | Amount | You type |
| C | How often | You type (from a dropdown) |
| D | A due date (any one) | You type |
| E | Months between | Formula |
| F | Next due date | Formula |
| G | Per year | Formula |
| H | Set aside each month | Formula |
| I | Due in 14 days | Formula |
Shade columns A to D a light colour so it is clear where to type.
Step 2: Add a dropdown for "How often"
Select C2:C41, then Data > Data validation > Add rule > Dropdown, with three options: Monthly, Quarterly, Yearly. A dropdown keeps the spelling the same, which the formulas below rely on.
Step 3: Type your bills
One row per bill: name, amount, how often, and any one date it fell or falls due (last month's date is fine). Format column D as a date (Format > Number > Date).
Step 4: Add the formulas (row 2, then copy down)
E2, months between:
=IF(C2="Monthly",1,IF(C2="Quarterly",3,IF(C2="Yearly",12,"")))
F2, next due date (rolls the date you typed forward until it is today or later):
=IF(OR(D2="",E2=""),"",IF(D2>=TODAY(),D2,IF(EDATE(D2,E2*ROUNDUP(DATEDIF(D2,TODAY(),"M")/E2,0))>=TODAY(),EDATE(D2,E2*ROUNDUP(DATEDIF(D2,TODAY(),"M")/E2,0)),EDATE(D2,E2*(ROUNDUP(DATEDIF(D2,TODAY(),"M")/E2,0)+1)))))
Format F as a date.
G2, per year: =IF(E2="","",B2*12/E2)
H2, set aside each month: =IF(E2="","",B2/E2)
I2, due in 14 days: =IF(F2="","",IF(F2-TODAY()<=14,"Yes",""))
Select E2:I2 and drag the fill handle down to row 41 (room for 40 bills).
Step 5: Add the totals
Below the table, or at the top of a second sheet:
- Due in the next 14 days:
=SUMIF(I2:I41,"Yes",B2:B41) - Bills per year:
=SUM(G2:G41) - Set aside each month:
=SUM(H2:H41)
Step 6: Sort by what is due next
Select A1:I41, then Data > Create a filter, and sort column F from A to Z. The next bill is always at the top. Optional: Format > Conditional formatting on A2:I41 with the custom formula =$I2="Yes" to shade the bills due soon.
An example (made-up bills, checked on 14 November 2026)
| Bill | Amount | How often | A due date | Next due date | Per year | Due in 14 days |
|---|---|---|---|---|---|---|
| Rent | $1,350 | Monthly | 1 Jan 2026 | 1 Dec 2026 | $16,200 | |
| Phone and internet | $124.98 | Monthly | 6 Jan 2026 | 6 Dec 2026 | $1,499.76 | |
| Water | $96 | Quarterly | 20 Feb 2026 | 20 Nov 2026 | $384 | Yes |
| Car insurance | $612 | Yearly | 25 Nov 2025 | 25 Nov 2026 | $612 | Yes |
Due in the next 14 days: $708. Bills per year: $18,695.76.
Keep it in one workbook
The Household Money Workbook has this bills sheet already built, next to the budget, savings goals, debts and net worth, with a dashboard that shows the bills due in the next 14 days. It works in Google Sheets and Excel. You type or paste your own figures; there is no bank login.
See the Household Money Workbook
Next: track your household bills and spending together, with a monthly summary and a one-page print.