VThe Vera Standard

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:

ColumnHeadingYou type it, or a formula?
ABillYou type
BAmountYou type
CHow oftenYou type (from a dropdown)
DA due date (any one)You type
EMonths betweenFormula
FNext due dateFormula
GPer yearFormula
HSet aside each monthFormula
IDue in 14 daysFormula

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:

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)

BillAmountHow oftenA due dateNext due datePer yearDue in 14 days
Rent$1,350Monthly1 Jan 20261 Dec 2026$16,200
Phone and internet$124.98Monthly6 Jan 20266 Dec 2026$1,499.76
Water$96Quarterly20 Feb 202620 Nov 2026$384Yes
Car insurance$612Yearly25 Nov 202525 Nov 2026$612Yes

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.