VThe Vera Standard

How to track your household bills and spending in Google Sheets (without linking your bank)

Short answer: Make a Transactions sheet with one row per payment or pay-in, a Bills sheet that works out each next due date, and a Summary sheet that adds up money in, money out and what is left over for the month with SUMIFS. You type what you spent; nothing connects to your bank.

Who it is for: the person in the household who pays the bills, is comfortable with Excel or Google Sheets, and wants to see where the money goes each month. You type what you spent; nothing is connected to your bank.

It is not the right fit if you need:

  • an automatic bank feed or import;
  • business accounts, payroll or tax filing;
  • investment or tax software;
  • someone to tell you what to spend, save or pay first.

This is a record-keeping method. It writes down and adds up what your household already does. It is not financial, tax or investment advice.

What you will have at the end

It takes about an hour to set up, then a few minutes a week to type in.

Step 1: The Transactions sheet

Make a sheet called Transactions. Type these headings in row 1:

ColumnHeadingExample
ADate10/02/2026
BDescriptionSupermarket
CCategoryGroceries
DTypeExpense (or Income)
EAmount112.35
FCheckformula (Step 2)

Rules that save trouble later:

Choose a short list of categories you will really use. The example below uses Housing, Utilities, Groceries, Transport, Insurance and Leisure for spending, and Pay and Other income for money in.

Step 2: The row check

In F2 type this, then copy it down to row 1000:

=IF(COUNTA(A2:E2)=0,"",IF(NOT(ISNUMBER(A2)),"Fix date",IF(D2="","Add Type",IF(C2="","Add category",IF(NOT(ISNUMBER(E2)),"Add amount","OK")))))

An empty row shows nothing. A complete row shows OK. A row with something missing shows what to add. To make a problem easy to see, select F2:F1000, choose Format, then Conditional formatting, pick "Custom formula is" and type =AND($F2<>"",$F2<>"OK"), then choose a red fill.

If your Google Sheets uses a locale that wants semicolons between the parts of a formula, replace the commas with semicolons throughout this guide.

Step 3: The Bills sheet

A bills list answers one question: what is due next. Make a sheet called Bills with these headings in row 1:

ColumnHeadingYou type, or formula
ABillYou type
BAmountYou type
CDue day of the monthYou type (1 to 28)
DCategoryYou type
ENext due dateFormula
FDue in the next 7 days?Formula

Keep the due day between 1 and 28 so the formula works in every month. In E2:

=IF(C2="","",IF(DAY(TODAY())<=C2,DATE(YEAR(TODAY()),MONTH(TODAY()),C2),DATE(YEAR(TODAY()),MONTH(TODAY())+1,C2)))

Format column E as a date. In F2:

=IF(E2="","",IF(E2-TODAY()<=7,"Due soon",""))

Copy both down to row 11, which leaves room for ten bills. Under the list, put Monthly total in A12 and, in B12:

=SUM(B2:B11)

Bills that come yearly or every three months can go in a second list, or be typed into Transactions the day they are paid. The Bills sheet is a reminder; Transactions is the record.

Step 4: The monthly Summary

Make a sheet called Summary. Type Month starting in A1 and the first day of the month in B1, for example 10/1/2026. Type Month ending in A2, and in B2 put the last day of that month:

=EOMONTH(B1,0)

Format B1 and B2 as dates. Changing B1 is how you look at any other month.

Then the three answers, with their labels in A4 to A6:

CellLabelFormula
B4Money in=SUMIFS(Transactions!$E:$E,Transactions!$D:$D,"Income",Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<="&$B$2)
B5Money out=SUMIFS(Transactions!$E:$E,Transactions!$D:$D,"Expense",Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<="&$B$2)
B6Left over this month=B4-B5

Under them, list your spending categories in A9 to A14 (Housing, Utilities, Groceries, Transport, Insurance, Leisure). In B9 put this, and copy it down to B14:

=SUMIFS(Transactions!$E:$E,Transactions!$C:$C,$A9,Transactions!$D:$D,"Expense",Transactions!$A:$A,">="&$B$1,Transactions!$A:$A,"<="&$B$2)

That is the SUMIFS by category and month: it adds the amounts whose category matches A9, whose Type is Expense, and whose date falls inside the month set by B1 and B2.

Two small checks under the categories (rows 15 and 16 in the example):

CellLabelFormula
B15Categories added up=SUM(B9:B14)
B16Spending not in a category above=B5-B15

B16 should read 0.00. If it does not, a category was spelled differently or is missing from your list.

One more, with Rows to fix in A18 and, in B18:

=SUMPRODUCT((Transactions!$F$2:$F$1000<>"")*(Transactions!$F$2:$F$1000<>"OK"))

It counts the rows the row check has flagged. Read it before you trust the month: when it says 0, every row has a date, a type, a category and an amount.

A small worked example

Here are 18 rows for a household in October 2026. Two rows fall outside October on purpose, to show the dates doing their work.

DateDescriptionCategoryTypeAmount
30 Sep 2026SupermarketGroceriesExpense41.15
1 Oct 2026Pay, first earnerPayIncome2,400.00
1 Oct 2026RentHousingExpense1,250.00
2 Oct 2026SupermarketGroceriesExpense112.35
5 Oct 2026ElectricityUtilitiesExpense86.40
6 Oct 2026FuelTransportExpense54.30
8 Oct 2026InternetUtilitiesExpense45.00
9 Oct 2026SupermarketGroceriesExpense87.60
12 Oct 2026Home insuranceInsuranceExpense62.50
14 Oct 2026Cinema and mealLeisureExpense38.00
15 Oct 2026Pay, second earnerPayIncome1,850.00
16 Oct 2026SupermarketGroceriesExpense64.05
19 Oct 2026FuelTransportExpense48.70
22 Oct 2026Mobile phoneUtilitiesExpense29.99
24 Oct 2026SupermarketGroceriesExpense71.40
27 Oct 2026Coffee with friendsLeisureExpense24.50
28 Oct 2026Sold an old bikeOther incomeIncome60.00
1 Nov 2026RentHousingExpense1,250.00

With B1 set to 10/1/2026, the Summary shows:

LineAmount
Money in4,310.00
Money out1,974.79
Left over this month2,335.21
CategoryAmount
Housing1,250.00
Utilities161.39
Groceries335.40
Transport103.00
Insurance62.50
Leisure62.50
Categories added up1,974.79
Spending not in a category above0.00
Rows to fix0

The 30 September supermarket row and the 1 November rent row are left out, because their dates are outside the month. Change B1 to 11/1/2026 and the November rent appears on its own.

To see the row check work, delete the category in one October row. Its F cell changes from OK to "Add category", Rows to fix becomes 1, and "Spending not in a category above" shows that row's amount. Put the category back and both return to 0.

The Bills sheet for the same household:

BillAmountDue dayCategory
Rent1,250.001Housing
Electricity86.405Utilities
Internet45.008Utilities
Home insurance62.5012Insurance
Mobile phone29.9922Utilities
Monthly total1,473.89

On 10 October 2026 the Next due date column reads 1 Nov (rent), 5 Nov (electricity), 8 Nov (internet), 12 Oct (insurance) and 22 Oct (phone). Only home insurance shows "Due soon", because it is 2 days away; the phone is 12 days away.

Step 5: A one-page summary for your partner

The Summary sheet is the page to share. To make it print well:

  1. Keep the sheet short enough for one page: the labels in column A and the figures in column B, nothing else beside them.
  2. Choose File, then Print. Under "Print", pick Current sheet.
  3. Set the paper size to Letter or A4 and the page orientation to Portrait.
  4. Under "Scale", choose Fit to width.
  5. Untick "Show grid lines" under Formatting if you want a cleaner page. For a title on the page, open "Headers and footers" and add one, for example "Household money, October 2026". Check that the preview shows one page, press Next, then print it or save it as a PDF.

The three answers sit at the top (money in, money out, left over), with the categories under them. Your partner can read the page in a minute, with nothing to log in to.

Keep it going

Questions people ask

Can I track my budget without linking my bank?

Yes. You type each payment once a week from receipts and the statements you already get. The sheet adds it up; nothing links to your bank and your numbers stay in your file.

Where did it all go? How do I see spending by category?

A Summary sheet with one SUMIFS per category adds the month's amounts for each category, and a check line shows anything that is not in a category, so the totals can be trusted.

How do I know when a bill is due?

On the Bills sheet, type the amount and the due day of the month; a formula works out the next due date and marks anything due in the next 7 days.

I'm not a spreadsheet person. Is this hard?

It takes about an hour to set up and a few minutes a week. Every row checks itself and says OK or what is missing, so a slip is easy to see.

If you would like it ready-made

The Household Money Workbook is a ready-made version of this method for Google Sheets and Excel, for households that want one file for the year. Every row you type checks itself and says OK or what to fix, as in Step 2, and its Year summary is made to print: income by month, spending by category and month, and what is left over. It was tested in Microsoft Excel (Microsoft 365, Windows); you can upload the file to Google Drive and open it with Google Sheets. Nothing connects to your bank, and a blank copy is included. If anything is wrong we fix it or refund you, and if you change your mind you can write within 30 days for a full refund. It is on The Vera Standard's Gumroad page. The method above works without it.