Income & Expense Tracker: Your Questions Answered
Clear, direct answers to the questions people ask most about the Income & Expense Tracker — setup, categories, taxes, and automation — all in one place.
Get the Income & Expense Tracker (Free)
We’ll email you a copy and open it in a new tab.
We’ll email you a copy and open the template in a new tab. No spam.
Getting started
How do I set up the income and expense tracker?
Copy the Google Sheet to your Drive, log your income and expense transactions with a date and category, then either keep entering them manually or connect Avery for automatic bank sync. The net cash flow and summary update on their own. Setup takes about 10 minutes.
What is an income and expense tracker?
An income and expense tracker is a sheet that records the money coming in and the money going out, sorted by category, then subtracts one from the other to show your net cash flow. It tells you whether you finished a period positive or negative, not just where you spent.
Can I use the tracker on my phone?
Yes. The Google Sheets mobile app opens the full tracker, so you can log income or an expense in about 30 seconds and check your monthly net from anywhere.
Who is this tracker for?
It's built for individuals who want a clear money-in versus money-out picture, and for very small businesses tracking revenue against costs. Anyone who wants to know their net cash flow each month, not just their spending, will get value from it.
Income and expenses
How do I track income and expenses in one sheet?
Log every transaction in one place with an amount, a date, a category, and whether it's income or an expense. The sheet sums each side and subtracts expenses from income, so a single view shows total in, total out, and what's left.
What is net cash flow and why does it matter?
Net cash flow is your total income minus your total expenses for a period. A positive number means you earned more than you spent; a negative number means the opposite. It's the single clearest signal of whether your money situation is improving or sliding.
How do I know if I'm net positive each month?
The summary subtracts total expenses from total income and shows the result for the month. If it's above zero you're net positive; if it's below zero you spent more than you brought in. The tracker calculates it automatically as transactions come in.
How is this different from a budget?
A budget plans what you intend to spend before the month starts. An income and expense tracker records what actually happened — money in and money out — and reports your real net cash flow. Many people use the tracker to check whether they hit the plan from their budget.
Can I track income with irregular pay?
Yes. Because the tracker records actual transactions rather than a fixed plan, irregular or variable income just gets logged as it arrives. Your net cash flow always reflects what really came in, so months with less income show up honestly.
Categories and customizing
What categories come built in?
The tracker ships with starter categories for both sides — income lines like salary, freelance, and other income, and expense lines like housing, groceries, transport, and subscriptions. Rename, add, or delete any of them and the totals and net update automatically.
How many categories should I use?
Keep it simple — a handful of income sources and roughly 10–15 expense categories. Too many categories make a tracker hard to maintain. You can always split one later if you need more detail.
Can I change the categories?
Yes. Once the sheet is in your Drive it's yours — rename, add, or remove any income or expense category on the Categories tab and the summary and net cash flow recalculate on their own.
Can I track multiple accounts?
Yes. You can log income and expenses from any number of accounts, and with Avery connected, transactions from every linked checking, savings, and credit card account flow into one sheet automatically.
Can I share it with someone else?
Yes. Google Sheets lets two people edit in real time, so couples or a small business owner and a partner can manage one shared income and expense tracker without emailing files back and forth.
Automating with Avery
How does Avery keep the tracker updated?
Avery connects to your bank through a read-only link, imports every new income and expense transaction, and uses AI to sort each one into your categories — so your net cash flow stays current without any manual entry. You just review weekly.
Is my financial data safe with Avery?
The tracker lives in your own Google Drive — you own it, not a third-party app. Avery's bank connections are read-only and bank-grade encrypted and can never move money. Two-factor authentication on your Google account adds another layer.
How much does Avery cost?
The template is free forever. Avery's automatic bank sync and AI categorization are a paid subscription with a free trial, so you can see the automated version of the tracker before paying.
Keep going