Income and Expense Tracker Spreadsheet: Google Sheets & Excel
Customer Testimonial

Not Sure Where Your Money Goes? Put It In Once and See What's Left

Input your income, input your expenses, one row per entry. Your monthly and annual totals, the charts and what's left fill in. All in your own Google Sheet or Excel file, paid once.

  • Where your money went, by category and month
  • What's left this month and this year
  • No bank login, nothing to disconnect
  • Pay once, no subscription

Instant download • Works with Google Sheets & Excel • One-time payment

The Ultimate Income and Expense Tracker: income in, expenses out, what's left, 19 tabs

Works wherever you track your money

XMicrosoft Excel
Google Sheets
Mac & PC
iPhone & Android

Income In, Expenses Out, See What's Left

Put in what came in and what went out. The totals and the graphs fill in, all in one connected file.

Transaction Log, One Row per Entry

Date, income or expense, category, description, amount. Put each one in once. The month fills itself from the date.

All-in-One Dashboard

Pick a month or the whole year. See income, expenses and what's left, spending by category, and income against expenses, with charts.

Annual Totals for the Whole Year

Every category month by month in one grid, with the year's income, expenses and what's left in each month.

12 Monthly Tabs, Start Any Month

January to December, each filled from the log: income and expenses by category, total in, total out and what's left.

Your Categories, Any Currency

Rename the preset income and expense categories and pick your currency symbol in Start Here. Typing each entry yourself makes it stick.

Google Sheets and Excel, Both Included

The same 19 tabs in both files. Open it in your browser on Mac or PC, or on your phone or tablet.

What's Included

19 Tabs in Google Sheets and Excel, All Listed

Setup and Log (2 Tabs)

Start Here sets your currency, year, start month and categories in 3 steps. The Transaction Log takes one row per entry, and every other tab fills in from it.

Dashboard and Monthly Tabs (13 Tabs)

Income, expenses and what's left for the month you pick and for the year, with charts. Then January to December, each filled from the log. Start with any month.

Year View (4 Tabs)

Annual Totals, Income Sources, Bills and Subscriptions, and Year Compare. See each category month by month, every source of income, every repeating payment, and this year against last.

Also Included

A Sample Copy With an Example Month
A Clean Copy to Start From
Preset Categories You Can Rename
No Bank Login Needed
Any Currency Symbol
Start in Any Month
Share the Google Sheet
Reuse It Every Year
The Ultimate Income and Expense Tracker: what you get, 19 tabs, a sample copy and a clean copy
Inside Your Tracker

Everything in the Ultimate Income and Expense Tracker

Every tab works in Google Sheets and Excel. Put each entry in once, and the totals fill in.

Start Here: Set Up Once in 3 Steps
1

Start Here: Set Up Once in 3 Steps

Set your categories and currency, add each income and expense as one row, then check the Dashboard. Your settings live here: currency, the year, the start month, and your income and expense categories.

How It Works in 3 Steps
Your Currency Symbol
The Year and the Start Month
Income Categories You Set
Expense Categories You Set
A Preset List You Can Rename
Transaction Log: Put It In Once
2

Transaction Log: Put It In Once

One row per entry: date, income or expense, category, description and amount. Type it or paste it once, and the month fills itself from the date. Every other tab reads from this one log.

One Row per Entry
Date, In or Out, Category
Description and Amount
The Month Fills Itself
Categories From a Drop-Down
Feeds Every Other Tab
Dashboard: See Where It Went
3

Dashboard: See Where It Went

Pick a month or look at the whole year. Income, expenses and what's left sit up top. Spending by category shows where your money went, and a month-by-month chart puts income against expenses.

Income, Expenses and What's Left
For the Month You Pick
For the Whole Year
Spending by Category Chart
Income Against Expenses Chart
Month by Month
12 Monthly Tabs, January to December
4

12 Monthly Tabs, January to December

Each month fills itself from the log. Start with any month of the year. Fell behind? Add the missed entries any time and the right month catches up. There is no streak to break.

Fills Itself From the Log
Income by Category
Expenses by Category
Total In and Total Out
What's Left This Month
Your Biggest Expense Categories
Annual Totals: The Year in One Grid
5

Annual Totals: The Year in One Grid

Every category, month by month, in one grid. See the year's income, expenses and what's left, and what was left in each month, so you can compare one month with the next.

Every Category in One Grid
Month by Month
The Year's Income
The Year's Expenses
What's Left for the Year
What's Left in Each Month
Income Sources: Where Your Money Comes From
6

Income Sources: Where Your Money Comes From

Each source of income, such as your pay, side income and anything else, month by month and for the whole year. See the share each one brings in. It fills itself from the log.

Each Income Source
Month by Month
For the Whole Year
Share of Your Total Income
Pay, Side Income and Other
Fills Itself From the Log
Bills and Subscriptions: What Repeats
7

Bills and Subscriptions: What Repeats

List each payment that repeats: rent, utilities, phone, streaming and insurance. Add the amount, how often it comes and the due day. See what repeats each month and each year.

Each Repeating Payment
Amount and How Often
The Due Day
Monthly Total of What Repeats
Yearly Total of What Repeats
Rent, Phone, Streaming, Insurance
Year Compare: This Year Against Last Year
8

Year Compare: This Year Against Last Year

Put this year next to last year, month by month. Compare income, expenses and what's left, and see the categories that went up most.

This Year Against Last Year
Month by Month
Income Compared
Expenses Compared
What's Left Compared
Categories That Went Up Most

What Planner Lovers Are Saying

More than 100,000 happy customers: real reviews from real planners

Real user reviews and results 1Real user reviews and results 2
Ultimate Income and Expense Tracker: one Google Sheet shared with your partner
Tracking Together?

Share It With Your Partner

Keep it for yourself, or share the Google Sheet. You both add rows to the same Transaction Log, and you both see the same totals.

One Shared Google Sheet
Both Can Add Rows
The Same Dashboard for Both
The Same Monthly Totals
Each Entry Is One Row
Or Keep It Just for You
Also in the Download

Bonus Pages Plus a Sample and a Clean Copy

Both copies come in Google Sheets and Excel. The printable pages are for anyone who likes to write it down first.

BONUS PRINTABLE PAGES

2 PDF pages in US Letter and A4: a monthly income and expense log and a month summary. Write it down, then type it into the Transaction Log.

A SAMPLE COPY

Filled with a household's example month, so you can see how every tab works before you add your own numbers.

A CLEAN COPY

The same 19 tabs with no data in them. Set your categories and currency, and start with any month.

How It Works

The formulas are already built. You only add rows.

1

Set Up Once

Pick your categories and currency in Start Here

2

Add Each Entry

Each income and expense is one row

3

Totals Fill In

Monthly and annual totals, graphs and what's left

4

Check the Dashboard

See where it went at month end

Pay $9 Once and Keep the File

Everything on this page is in one download: Start Here, the Transaction Log, the Dashboard, 12 monthly tabs, Annual Totals, Income Sources, Bills and Subscriptions and Year Compare, plus the printable pages. Your own file. No subscription.

$9
One-time payment • Instant access
  • Start Here and the Transaction Log (2 Tabs)
  • Dashboard, Annual Totals and Year Compare (3 Tabs)
  • 12 Monthly Tabs (start any month of the year)
  • Income Sources, Bills and Subscriptions (2 Tabs)
  • Google Sheets and Excel, Both Included
  • A Sample Copy and a Clean Copy

Instant download • Google Sheets & Excel • No subscription • No bank login

This is a digital product with immediate access after purchase. No refunds on digital downloads.

Why a Spreadsheet

No Subscription and Nothing to Disconnect

No bank login, and the screens don't change on you. Unlike a homemade sheet, the formulas are already built, and you can start in any month. Works on PC, Mac, phones and tablets.

Ultimate Income and Expense Tracker: works in Google Sheets and Microsoft Excel

Frequently Asked Questions

Everything you need to know before you buy

$297$9 only