A working expense log needs eight columns you type and two you never touch: Date, Amount, Type, Category, Payment mode, Merchant, Notes and Paid by, plus helper columns for Month and Financial Year that fill themselves. Beyond about ten columns, entering a purchase starts to feel like paperwork, and logging stops.
Which columns are worth typing?
| Column | What goes in it | Why it earns its place |
|---|---|---|
| Date | The day you paid, as a real date | Every monthly and yearly total depends on it |
| Amount | A positive number, no ₹ sign or commas typed | Keeps SUMIFS working |
| Type | Expense, Income or Transfer | Stops a move between your own accounts from counting as spending |
| Category | Chosen from a dropdown | Spelling mistakes break every summary |
| Payment mode | UPI, Card, Cash, NEFT, Auto-debit | Shows where money leaves and helps matching with statements |
| Merchant | Short, consistent name | Lets you search and spot repeats |
| Notes | Optional free text | For the unusual: advance, gift, shared bill |
| Paid by | Your name or your partner's | Only needed in a shared household |
Why is a Type column so useful?
Say you move ₹20,000 from savings to your current account. Without a Type, that row looks like an expense of ₹20,000 in one account and income of ₹20,000 in another, and your totals double count. Marking it Transfer lets every summary formula ignore it by adding "Expense" as a criterion. Credit card bill payments work the same way: the purchases already count when you logged them, so the bill payment itself is a Transfer.
Which helper columns save the most time?
Helper columns are formulas. You never type into them, so they do not slow you down.
- Month, in column I: =TEXT(A2, "yyyy-mm"), which gives labels like 2026-11 that sort correctly and make monthly pivots easy.
- Financial Year, in column J, for April to March: =IF(MONTH(A2)>=4, YEAR(A2)&"-"&RIGHT(YEAR(A2)+1, 2), YEAR(A2)-1&"-"&RIGHT(YEAR(A2), 2)). A date in October 2026 gives 2026-27, and a date in February 2027 also gives 2026-27.
If you use an Excel table, these fill down automatically for every new row. In a plain range, copy them down a few hundred rows in advance.
What should you leave out?
- Running balance. It duplicates your bank statement and breaks the moment you insert or sort a row.
- Time of day. Almost nobody uses it, and typing it takes longer than the entry itself.
- Separate columns for each payment mode. One column with a dropdown is shorter and filters better.
- GST or tax fields for ordinary household spending. Add them later only if you really need them, and treat any figures as estimates to confirm with your CA.
- Bank name and account number. A payment mode plus an account nickname is enough, and you should not paste full account numbers into a casual sheet.
Why does the number of columns matter so much?
Think about the logging moment: you are at a counter, phone in hand, and you have about ten seconds. Eight inputs, of which three are dropdowns and one is optional, is doable. Fifteen is not. A sheet with every field filled in for three weeks and abandoned for the rest of the year is worth far less than a sparse one that you use daily. If you find yourself skipping a column most of the time, delete it.
What is the one-page checklist?
- Date is a real date, not text.
- Amount is a plain number with no symbols.
- Category comes from a dropdown list kept on a separate tab.
- Type separates Expense, Income and Transfer.
- Payment mode has five options or fewer.
- Month and Financial Year are formulas, not typed.
- There is a header row and one entry per row, with no blank rows or merged cells.
The same set of columns is what a statement import needs, so if you later move to SpendixAI, which keeps each transaction against its account and lets you add expenses by hand, your sheet will translate cleanly.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

