Income And Expense Tracker For Google Sheets

The Income & Expense Tracker is Avery's simplest way to see the whole picture in Google Sheets: money in, money out, and the one number most trackers skip — your net cash flow. Instead of only logging spending, it records income alongside expenses and tells you whether you finished the month ahead.

Who it's for

• Individuals who want a clear money-in versus money-out view, not just a list of expenses.
• Very small businesses and sole proprietors tracking revenue against costs each month.
• Side-hustlers who need to know whether the side income actually clears its expenses.
• Anyone who wants their net — the single number that says whether things are improving or sliding.

What's inside

A pre-built Google Sheet with everything wired up:

• Transactions — one log for both income and expenses (typed manually or synced by Avery).
• Categories — starter income and expense categories you can rename, add to, or trim.
• Net cash flow — total income minus total expenses, calculated automatically.
• Monthly summary — income against spending, month by month, so the trend is obvious.

The honest part

A tracker only works if the numbers are actually in it. Most go stale because nobody wants to type in transactions every week — and with income and expenses both, that's twice the entry. This template assumes Avery handles that part — auto-syncs income and expense transactions and categorizes them automatically — so the tracker stays current and your net cash flow is never guesswork.

Want the full walkthrough with examples? Read the complete income and expense tracker guide, or jump to the most-asked income and expense tracker questions. Tracking spending only? Try the Expense Tracker template.