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 3 of 50
Take your time. Find what helps.
Bar chart of your top 10 merchants from statement data
Make a sorted horizontal bar chart of your top 10 merchants with a pivot table Top 10 filter, and see how cleaning merchant names changes the ranking.
Read article
Bill due date calendar in Google Sheets with colour alerts
Build a bill due date calendar in Google Sheets with a days-to-go column from TODAY(), red overdue rows and a paid status that resets itself each month.
Read article
Bill due dates into Google Calendar from a sheet, no scripts
Turn a bill list in a sheet into Google Calendar reminders with a CSV import: set the Subject, Start Date and Description columns and handle repeating bills.
Read article
Blank cells in debit and credit columns breaking your formulas
Blank-looking cells in debit and credit columns can return #VALUE! or wrong totals; learn empty vs empty string vs space and a one-step clean-up.
Read article
Order tracker for boutiques and tailors: advance and balance
A boutique and tailor order tracker for Excel: advance, balance due, delivery date and an overdue flag, plus a month view of pending balances.
Read article
Break-even calculator sheet for a small shop or home business
Build a break-even sheet for a small shop or home business: fixed costs, price and variable cost per unit give the break-even quantity and rupees.
Read article
Budget progress bar with SPARKLINE in Google Sheets
Draw a budget progress bar inside a cell with the Google Sheets SPARKLINE function, charttype bar, a max set to the budget and a colour that turns red when over.
Read article
Budget vs actual combo chart in Excel
Make a budget vs actual chart in Excel: actual spend as columns, the budget as a marker or line, and over-budget categories coloured red.
Read article
Budget vs actual formula for a monthly budget in Excel
Build a three-column budget vs actual sheet in Excel: type the budget, pull actual spend with SUMIFS from your expense log and show the difference.
Read article
Budget vs actual sheet in Excel with a variance column
Build a budget vs actual sheet in Excel with twelve monthly columns, a variance column and a flag for categories that run over, with a groceries example.
Read article
Build a budget from three months of bank statements in Excel
Build a monthly budget in Excel from three bank statements: tag categories, average with SUMIFS, drop one-offs and move yearly bills to a sinking fund.
Read article
Separate business and personal expenses in one sheet with SUMIFS
Keep business and personal spending in one sheet with a validated Type column and SUMIFS for each, so a freelancer can pull only the business rows later.
Read article