Skip to content
Household Expenses Log cover: a sample sheet with spent this month, bills and utilities and recurring items and a bar chart, beside the Dashboard and Log tabs

Household Expenses Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Household Expenses Log suits a family or shared home that wants a single place to record daily spending. The Log tab records each item with its date, category, who paid, the amount and whether it recurs. The Dashboard totals the spending, counts the recurring items then splits the total by category and by payer.

The Bills tab is a grid of regular payments with a column for each month. Tick a box once a bill is paid, and the percent at the end of the row shows how many months so far are covered. Pick categories and payers from the lists so the dashboard can count them, and rename the grid's columns when the year rolls over.

Useful for

  • Keeping one record of household spending each month
  • Checking which regular bills are paid this month
  • Sharing costs between two people who both pay

What's included

  • 4 tabs: Dashboard, Log, Bills, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Log: a table
  • Bills: a grid
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I know a bill is paid?

Tick its box in the month column on the Bills tab. The percent at the end of the row shows how many months are ticked so far, and the column total counts how many bills are paid that month. Untick a box if a payment has to be made again.

Can I log a cost that repeats every month?

Yes. Tick the Recurring box on the Log row. The dashboard counts those rows, which tells you how many fixed costs you carry. Each month, copy the row and change its date.

How do I change the months on the grid?

Click the column heading and type the new month name, such as Feb 2027. The grid does not depend on the dates in the Log, so you can rename a month at any time without breaking a total.

  • #expense-tracker
  • #household-expenses
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…