Skip to content

· 7 min read

Income and expense spreadsheet layout that works

An expense spreadsheet you build yourself: 12 monthly sheets, categories, budget vs actual, columns the import wizard maps by name, and when to import.

You searched for an expense spreadsheet, downloaded three, and none of them survived February. The first was too pretty and you couldn't tell where to type. The second wanted every purchase entered on the day it happened. The third is still open somewhere on your computer, January filled in and February blank. Meanwhile the month keeps ending before the money does.

You were told the problem is consistency. That people who control their spending simply sit down every evening and type. And that if the spreadsheet didn't work, you need a fancier one, with macros and color-coded charts.

There is a part of you that says, "I am not typing 90 rows a month." It's right, and it helps to see what it's protecting: it wants the picture without the picture becoming a second job, and it wants the numbers to stay with you, no bank password handed to anyone, no subscription. There is another part that just wants to know how much is left until the end of the month. The layout here was built for both, and further down we say where it stops.

What's in the budget spreadsheet, sheet by sheet

It didn't hold, and not because of you. Most templates online are built for manual entry, one row at a time, and whoever stops typing for a week loses the month. This one is built the other way around: its columns match the columns your bank and card company export, so you fill it by pasting, not typing. And the column layout below is the one the app's import wizard maps by name, so a sheet built this way, in any spreadsheet program, imports without retyping.

The layout has 14 sheets:

SheetWhat's in itWhen you touch it
SettingsCategories and subcategories, payment sources (each card and account)Once, at the start
12 monthly sheets (January to December)One row per income or expenseOnce a week, by pasting
Yearly summaryBudget vs actual for every category in every month, and the gapAt the end of each month

Every monthly sheet has the same 8 columns, in the same order:

ColumnExampleWhy it's there
Date14/03/2026The order of the month
DescriptionSupermarket near homeTo recognize the row
CategoryFoodThe yearly summary is built from it
SubcategoryGroceriesTo know what's inside "food"
Amount412 ₪Expenses positive; income in its own column
Payment sourceDana's cardTo know which card
Fixed/variableVariableTo separate what's known in advance
NotesInstallment 2 of 3Installments, refunds

At the top of each monthly sheet, three summary rows fill themselves in: total income, total fixed expenses, total variable expenses. In the yearly sheet, next to each category, a budget column you fill once and an actual column that updates from the monthly sheets.

How to fill an expense spreadsheet in 10 minutes a week

The secret is not to type. Pick a day and an hour, say Friday morning before coffee: export last week's rows from the bank's site and the card company's site, paste them into the month's sheet, and fill in only the category column. Ten minutes. After a month most descriptions repeat, and autocomplete fills the category almost by itself.

A full quarter in the spreadsheet, without typing every shekel

The goal is three full months in the spreadsheet, with a budget-vs-actual column that shows something, without entering expenses on the day they happened, without giving a password to any app, and without a subscription. After a quarter you'll know two things: what your month really costs, and where the spreadsheet stops helping.

The stages: from a blank workbook to a quarter

Stage 1: settings, once

Open a new workbook, add a settings sheet, and keep at most 10 categories in it. Food, housing, car, kids, health, insurance, going out, clothing, subscriptions, other. More than that and you won't know where anything belongs. Add every card and account in the household, including your partner's. That's all you do this week. Nothing more.

Stage 2: the first month, pasted

Export last month in full from the bank and the card company, not just a week. Paste, fill in categories, and look at the three summary rows. That's the first number you own: what the month costs when nobody plans it. For most people the first number is higher than they expected. That's what it's there for.

Stage 3: the budget column

In the yearly sheet, fill the budget column based on the first month, without cutting anything yet. A budget based on what actually happened holds; one based on what you'd like falls apart in week two. Cuts wait for the third month, when there's a pattern.

Stage 4: the quarter, and where the spreadsheet ends

In the third month you'll start to feel the edge. There are three things a spreadsheet, even the best one, can't do:

  1. Forecast. The sheet knows what went out. It can't tell you on the 8th how much is really free until the end of the month once rent and insurance that haven't posted yet are taken off.
  2. Be shared. Two people in one file means two copies after a week, and nobody knows who pasted what.
  3. Catch duplicates. You pasted the same week twice and every expense doubled. A recurring charge that changed amount won't stand out anywhere.

In AlphaHome: you import the spreadsheet as it is. The import wizard accepts CSV, XLS, XLSX and XLSM files, shows the columns it found and asks you to map them to the record's fields: amount, title, category, subcategory, date, payment source. Because the layout's columns are exactly those fields, the mapping almost fills itself. Rows that already exist are flagged as duplicates and not entered twice.

After the import, the quarter in your spreadsheet becomes months on the dashboard: one "free to spend until the end of the month" number that already subtracts fixed charges from day one, a daily pace, and a partner who sees it at the same moment.

Where it gets hard, and what gets you back on track

The hard moment: a formula got deleted and the yearly summary shows zero. What gets you through: it's what happens to living files, not a sign you're not built for Excel. Today: rebuild the settings sheet from the column list above and paste the monthly sheets into it. Next time: a saved copy before every new month.

The hard moment: February is blank. Two weeks without pasting, and it feels like the month is gone. What gets you through: it isn't gone. The bank keeps everything. Today: export February in full and paste it in one go, 15 minutes. Next time: a fixed weekly reminder, same day, same hour.

The hard moment: your partner's card isn't in the sheet, and the number is wrong. What gets you through: half a picture still beats no picture, but it isn't the household's number. Today: add the card to payment sources and export it too. Next time: if the shared file doesn't work for both of you, that's the moment to move to a shared workspace.

One number instead of one file

A good spreadsheet is an excellent start, and your first quarter in it is worth more than any article. What holds afterward is what's around you: categories already defined, import instead of typing, a monthly review waiting on a fixed date, and two people looking at the same number. You aren't "people who can't stick with Excel." You're people who know what their month costs, and that's the only thing the spreadsheet ever needed to teach. Once it has, you can take that quarter, import it in one go, and start planning next month instead of only recording the last one.

Do one thing this week

Open AlphaHome, record this month's income and fixed charges, and see how much is really free to spend. Everything in this article starts from that number.