Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 14 of 50
Take your time. Find what helps.
Excel swapping day and month in statement dates: why it happens
Why Excel swaps day and month in statement dates: days 1 to 12 flip while 13 to 31 stay text. Here is the cause, plus a repair for a damaged column.
Read article
Excel tables for an expense log with auto-expanding formulas
Turn your expense log into an Excel table with Ctrl+T, name it, and use structured references in SUMIFS so formulas grow automatically when you add rows.
Read article
Excel vs an expense tracker app: what you gain and what you give up
A fair comparison of an Excel or Sheets expense file and an expense tracker app across flexibility, setup, typing, categories, receipts, privacy and cost.
Read article
Exclude one-time expenses from your monthly average spend
Add a one-time flag column, then use SUMIFS and AVERAGEIFS to get a normal-month spending figure, kept apart from big annual or one-off costs.
Read article
Exclude opening and closing balance rows from transaction totals
Opening and closing balance lines can inflate statement totals. Tag them with a Type column, keep them for reconciliation, and sum only transactions.
Read article
Build an expense dashboard in Google Sheets with QUERY and charts
Build a Google Sheets expense dashboard with a month selector, scorecards, two charts and a QUERY top-10 list, using formulas you can copy.
Read article
Expense Excel file too slow or too big? How to fix it or move on
Why an expense Excel or Google Sheets file turns slow or huge, from volatile formulas to embedded receipts, and a clean-up routine before you move on.
Read article
Columns every expense log sheet needs (and ones to skip)
A checklist of the columns an expense log sheet needs, the helper columns that save work, and the ones to skip so you keep logging every day.
Read article
Expense-to-income ratio: formula and what the result means
Expense-to-income ratio explained: the one-cell formula, a worked example at three spending levels, and what the number does and does not tell you.
Read article
Track expenses by salary cycle (25th to 24th) instead of month
Group expenses by a salary cycle such as 25th to 24th instead of the calendar month using a helper column that shifts dates, then SUMIFS or a pivot as usual.
Read article
Export from an expense app to Excel and build your own pivot reports
Export expenses from an app to Excel, turn the CSV into a table, and build two pivot reports: category by month and merchant totals, with checks.
Read article
Extract the UPI handle after the @ sign from a narration
Extract the text after the @ sign in a UPI narration with TEXTAFTER or MID, group transactions by handle and use it carefully to review payees.
Read article