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 23 of 50
Take your time. Find what helps.
Joint family expense sheet: Excel format with member contributions
A joint family expense sheet in Excel: one row per earning member, a common pool for kitchen and utilities, and a contribution versus agreed share column.
Read article
Run your sheet and an app in parallel for one month: how to compare
How to run your spreadsheet and an expense app side by side for a month and compare total spend, category totals and transaction counts with a tolerance.
Read article
Keyword rules in priority order: first match wins in a sheet
Make a sheet categorise by keyword rules where the first match wins, so Amazon Pay Electricity lands in Utilities before the generic Amazon rule.
Read article
Daily cash book format in Excel for a small kirana shop
A daily cash book format in Excel for a small kirana shop: cash sales, UPI, udhaar recovered, payments, a running closing balance and a cash-short flag.
Read article
A reusable LAMBDA to clean UPI narrations in Excel
Wrap TEXTAFTER, TEXTBEFORE, SUBSTITUTE and TRIM into one named Excel function, CleanNarr, and clean a UPI narration column. Needs Microsoft 365.
Read article
LAMBDA basics: build your own expense function in Excel
Build a LAMBDA in Excel that returns net spend, debits minus refunds, for a category and month, then save it by name. Microsoft 365 only.
Read article
Rent collection tracker for landlords in Excel with tenant ledger
Set up an Excel rent register for a landlord: tenant ledger with due, received and arrears carried forward, plus a repairs and society charges tab.
Read article
Total expenses for the last 30 days with SUMIFS and TODAY
Sum your expenses for the last 7, 30 or 90 days with SUMIFS and TODAY, avoid the off-by-one mistake, and learn why the window moves each time you open the file.
Read article
Show your latest 10 transactions automatically with TAKE and SORT
Build a recent activity box that shows your latest 10 transactions automatically with SORT and TAKE on a summary tab, plus an option for Excel before 365.
Read article
LET function in Excel: make long expense formulas readable
Use the LET function in Excel to name each range once and make a long SUMIFS savings formula readable. Needs Excel 2021 or Microsoft 365.
Read article
Line chart of monthly spending trend in Excel
Turn a monthly spending summary into an Excel line chart with markers, set the date axis correctly, and read the trend without being fooled by one-off months.
Read article
Link receipt photos to expense rows with HYPERLINK in Sheets
Use the HYPERLINK formula in Google Sheets to link Drive receipt photos to expense rows, with a date_merchant_amount file name that is easy to search.
Read article