General

How to Track Spending with a Simple Spreadsheet

· October 22, 2026 · 6 min read

You do not need a paid app or a fancy template to understand your money. A plain spreadsheet, set up once and updated for a few minutes each week, will show you where every dollar goes. This guide shows you how to track spending with a spreadsheet, from the first column to a monthly summary, using only basic features available in Excel, Google Sheets, Numbers or LibreOffice.

It is general educational content, not personal financial advice.

Why a spreadsheet?

It is free and flexible. You decide the categories and layout.
It builds awareness. Typing in transactions makes you notice them in a way that passive apps may not.
It is private. You choose whether to store it on your own device.
It is portable. You can import bank statement files, and you are never locked in.

The trade-off is that it takes a little discipline. If you want automation, see Best Budgeting Apps Compared for 2026. Many people use both.

Step 1: Create the sheets

Create a new workbook with three tabs (sheets):

Transactions. Every purchase, one row each.
Categories. A list of your categories, for consistency.
Summary. A monthly view built with formulas.

Keeping data and summary separate keeps things tidy.

Step 2: Set up the Transactions tab

Use these columns in row 1:

Column	Header	Example
A	Date	2026-03-04
B	Description	Supermarket
C	Category	Groceries
D	Amount	42.80
E	Payment method	Debit card
F	Notes	Weekly shop

Format column A as a date and column D as currency. Enter spending as positive numbers, and use a separate column or tab for income, or add a “Type” column with values like “Expense” and “Income”. Keep it consistent.

Tip: freeze the top row so headers stay visible, and turn on filters so you can sort and search.

Step 3: Define your categories

Write your categories in the Categories tab, one per row. Keep the list short, around 10 to 15 at the start. For example:

Housing
Utilities
Groceries
Transport
Insurance
Health
Debt payments
Eating out
Entertainment
Shopping
Subscriptions
Savings
Gifts and giving
Miscellaneous

Too many categories make tracking tedious. Too few hide the detail. You can merge or split them later. If you have irregular expenses such as car repairs or holidays, give them their own categories so you can plan for them.

Step 4: Use a drop-down for categories

Typos create problems when you summarise. Add data validation:

Select the Category column (C) in the Transactions tab, excluding the header.
Open Data validation (in Google Sheets: Data, then Data validation).
Choose “List from a range” and select your list on the Categories tab.
Save.

Now every entry gets a drop-down menu.

Step 5: Enter your data

You have two options.

Manual entry

Enter spending once a week, using your bank app or receipts. This takes around ten minutes and keeps you in touch with your finances.

Importing bank data

Many banks let you download transactions as a CSV file. Paste the rows into your Transactions tab, then add categories. Check for duplicates and make sure the amounts have the right sign. Be careful when handling financial files: store them on a device you trust, and don’t share them casually.

For the first month, aim for completeness over perfection. If you can’t remember a cash purchase, label it “Miscellaneous” and move on.

Step 6: Build the monthly summary

On the Summary tab, list categories down the first column. Choose a month, for example in cell B1 (type the first day of the month, such as 2026-03-01). Then use the SUMIFS function to total each category for that month.

A formula for the Groceries row, assuming dates are in column A, categories in C and amounts in D of the Transactions tab, might look like this:

=SUMIFS(Transactions!D:D, Transactions!C:C, A3, Transactions!A:A, ">="&B1, Transactions!A:A, "<"&EDATE(B1,1))

What it does: it adds up amounts where the category equals the name in A3 and the date falls within the month starting in B1. Copy it down the column for each category. Function names and separators can vary slightly between software and language settings, so check your program’s help if you see an error.

Add:

A Total spending row using SUM
A Budget column next to the totals where you enter the planned amount for each category
A Difference column (budget minus actual)
Conditional formatting to turn overspent cells red

Step 7: Add income and savings

Create a small block at the top of the Summary tab:

Income this month
Total spending
Left over (income minus spending)
Savings contribution

This gives you a one-glance view. If you’re building a savings plan, see How to Build an Emergency Fund Step by Step.

Step 8: Create a simple chart

Select your category totals and insert a bar or pie chart. Bar charts are easier to read for comparing categories. Looking at a chart each month highlights trends quickly. Don’t spend too long polishing; the goal is insight.

Step 9: Set a weekly routine

Consistency matters more than detail. Here is a ten-minute routine:

Pick a regular time, such as Sunday evening
Open your bank app and enter or import the week’s transactions
Categorise them
Glance at the Summary and note anything that is above plan
Decide on one adjustment for next week

At the end of the month, spend twenty minutes reviewing: which categories ran over, which ran under, and whether your budget numbers need to change.

Common problems and fixes

Falling behind. Don’t try to catch up on everything. Go back as far as is practical, then continue from today.
Cash spending vanishes. Keep receipts or note cash spending on your phone at the time.
Shared accounts. Agree on categories with your partner, or add a column for “Who”.
Annual bills. Add a monthly “sinking fund” line to the budget to set aside a twelfth.
Refunds. Enter them as negative amounts in the same category.
Too much work. Simplify. Fewer categories and a weekly check may be enough.

Using what you learn

Data is useful only when you act on it. After a month or two, look for:

Categories that are consistently over plan, which may need a realistic budget or a spending change
Recurring charges that you could cancel or negotiate
Seasonal patterns, such as higher heating costs in winter
Opportunities to automate savings

Pair your tracker with a budgeting approach that suits you, such as those in Budgeting for Beginners: Methods Compared.

Frequently Asked Questions

Is a spreadsheet better than an app?
Neither is better in every case. Spreadsheets offer control and privacy; apps offer automation. Choose what you will actually use.

How often should I update it?
Weekly works well for most people. Daily is more detailed, while monthly can leave you with too much to catch up on.

Is it safe to store financial data in a cloud spreadsheet?
It can be, if you use a strong password and two-step verification. Avoid putting account numbers or login details in the file.

What if I overspend one month?
Review why, adjust the budget or the behaviour, and move on. One month does not ruin a plan.

To sum up

A simple spreadsheet with a transactions tab, a category list and a summary page is enough to take control of your spending. Start with the basics, keep a weekly routine and refine over time.