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 2 of 50
Take your time. Find what helps.
Annual expense calendar sheet: map yearly bills month by month
Build an annual expense calendar in Excel: a twelve-month grid for insurance, school fees, festivals and service bills that shows which months need a buffer.
Read article
Annual summary sheet that pulls from twelve monthly tabs
Make an annual expense summary in Excel from twelve monthly tabs with direct links, a 3D SUM or INDIRECT, plus totals and a highlighted peak month.
Read article
Append two bank accounts into one table with an Account column
Append a savings and a current account statement in Power Query, add an Account column to each first, and check that column names match before combining.
Read article
ARRAYFORMULA to fill a category column automatically in Sheets
Replace copy-down formulas in Google Sheets with one ARRAYFORMULA in the header row, add a blank-row guard and keep rows inserted later correct.
Read article
Ask ChatGPT or Claude to clean your expense sheet: prompts
Clean an expense spreadsheet with ChatGPT or Claude: ready-to-paste prompts for messy descriptions, categories and duplicates, plus a privacy checklist.
Read article
Receipts in a spreadsheet: Google Drive links and their limits
Attach receipts to an expense spreadsheet using a Google Drive folder per month and a link column, with file naming tips and where this method breaks down.
Read article
Average monthly expenses over the last 6 months in Excel
Find your average monthly expenses over the last 6 months in Excel by averaging monthly totals built with SUMIFS and EDATE, not averaging single transactions.
Read article
AVERAGEIFS for average spend per category in Excel
AVERAGEIFS gives the average transaction per category, not the average per month. See the pitfall and the SUMIFS-divided-by-months fix with examples.
Read article
Baby expense budget sheet for the first year in Excel
A baby expense budget sheet for the first year in Excel: one-time buys, recurring items projected by units per week, a gift-received flag and a month grid.
Read article
Back-calculate GST from a GST-inclusive amount in Excel
Split a GST-inclusive total into base amount and tax in Excel using a rate cell, with CGST and SGST halves, and avoid the common total-times-rate error.
Read article
Back up your expense workbook automatically (cloud or local)
Set up automatic backup for your expense workbook with cloud autosave, version history and a scheduled copy, and test a restore once a month.
Read article
Back up your expense spreadsheet: a simple three-copy routine
A simple three-copy routine for your expense spreadsheet: a cloud copy, a dated monthly download and an offline copy, plus version history for bad edits.
Read article