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 28 of 50
Take your time. Find what helps.
Opening balances when you move from a sheet to an app
Moving from a spreadsheet to an expense app? Pick a cut-over date, note each account's balance from the statement and check it after the first import.
Read article
A trip, fuel and earnings sheet for an owner-driver cab
A trip, fuel and earnings sheet for an owner-driver cab: daily rows, weekly earnings, cost per km, and a monthly line for EMI and servicing.
Read article
Parents monthly support tracker sheet for money sent home
A monthly support tracker for money sent to parents: fixed transfers, medicines, bills and gifts in one sheet, who paid, and a sibling share review at year end.
Read article
Pareto chart: which few categories make up most of your spending
Build a Pareto chart of your spending in Excel: sort categories, add a cumulative percentage line and see which few categories make up most of it.
Read article
Pareto chart of spending categories in Excel
Build a Pareto chart of your spending categories in Excel: sort totals, add a cumulative percentage and draw a combo chart to see what drives most of the spend.
Read article
Parse a pasted bank SMS alert into columns in Google Sheets
Parse a pasted bank debit SMS into amount, date and merchant columns in Google Sheets with REGEXEXTRACT, and see why alert formats differ from bank to bank.
Read article
Password protect an Excel file that holds your expense data
Password protect an Excel file that holds your expense data with File, Info, Encrypt with Password, and learn what it covers and what it does not.
Read article
PDF or CSV statement download: which one should you pick?
PDF or CSV statement download for Excel: compare effort, accuracy and completeness, with a simple rule for when only a PDF is on offer.
Read article
Percentage of income spent on each category: formula and layout
Work out the percentage of income spent on each category in Excel or Sheets: divide the category total by one take-home income cell and format as percent.
Read article
Personal expense dashboard in Google Sheets with category charts
Make a personal expense dashboard in Google Sheets: a Data tab, a month selector, SUMIFS category totals, a pie chart and a top-five merchants list.
Read article
Before you share your finance sheet: a privacy clean-up checklist
A privacy clean-up checklist for sharing a finance spreadsheet with an adviser, spouse or flatmate: remove identifiers, check hidden data and set link limits.
Read article
A bed-wise rent and occupancy sheet for PG owners
A bed-wise rent and occupancy sheet for PG owners in Excel: monthly rent due versus received, deposits, occupancy percentage and cash flow after costs.
Read article