An expense tracker in Google Sheets is a log of what you spend, with a category on every row, that adds itself up by category and by month. Here is how to build one, how to track expenses in Google Sheets without it becoming a chore, and a free template that connects your tracker to a full budget.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Create columns: Date, Category, Description, Amount, Paid with.
Make Category a dropdown (Data > Data validation) so every row uses the same names (Google's guide).
Make "Paid with" a dropdown too: debit card, credit card, cash, bank transfer, other.
On a second tab, total each category with SUMIFS, for example =SUMIFS(Expenses!D:D, Expenses!B:B, "Groceries").
Add month conditions to see this month only, then a chart of spending by category.
Log in batches. Every two or three days, from your banking app, takes a couple of minutes.
Use the Sheets phone app for cash spending right after it happens.
Do not over-split categories. "Groceries" is enough; you do not need "fruit".
Let red cells do the nagging. Conditional formatting that flags overspending is more effective than reading totals.
A tracker tells you where the money went. A budget tells you where it should go. The real value is connecting the two: each expense you log reduces the "left to spend" number of its category in your plan. The free template does exactly that, and adds a monthly summary for the whole year.
Skip the build: the Free Monthly Budget Template does all of this for you in Google Sheets or Excel. It is free (type 0 in the price box), and you can preview it in Google Sheets first.
Budget plan: 21 ready categories in four groups (Essential, Lifestyle, Savings, Debt). Rename or add your own.
Expense tracker: date, category dropdown, description, amount and payment method.
Income log: one row per payment, from any source.
Monthly summary: income, spending, plan vs. actual and money left over for all 12 months.
Dashboard: income and spending this year, money left over, what is left to spend this month, two charts and quick checks.
Two files: a blank template and a demo file filled with a year of sample data.
Download the free budget template →
Also tracking bills and subscriptions? See Bill Tracker Spreadsheet.
Free template: a complete monthly budget. Best if your paycheck is the same every month. Get it free.
Irregular Income Budget Bundle ($9): everything in the free template plus steady salary, buffer, taxes, pending invoices, bills, sinking funds and debt payoff. Best for freelancers and anyone with changing income. See the full bundle.
Your rows copy straight across, so you can start free and upgrade later without retyping anything.
Yes. The free template on this page includes an expense tracker connected to a monthly budget and dashboard.
Yes. Open your copy in the Google Sheets app and add rows on the go.
Use SUMIFS on the amount column with the category column as the condition.
Yes. Add or rename them on the Budget Plan tab and the dropdown updates.
Download the free budget template (Google Sheets + Excel) →
Get the Irregular Income Budget Bundle ($9) →
About this page: written by Abdallah Elsied, who makes the Free Monthly Budget Template (free) and the Irregular Income Budget Bundle ($9), both linked on this page. Last updated October 2026. This is general budgeting information, not financial, tax or legal advice.