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 27 of 50
Take your time. Find what helps.
Unexplained difference in a reconciliation: how to narrow it down
A step-by-step method to narrow down an unexplained difference in a reconciliation by month, week and day, then test for transpositions, halves and duplicates.
Read article
Net monthly spend with SUMIFS from separate debit and credit columns
Net monthly spend from debit and credit columns using two SUMIFS with start and end dates, plus a 12-row example that ties back to the statement.
Read article
Net worth tracker in Excel: assets, liabilities, monthly snapshots
Build a net worth tracker in Excel with assets and liabilities by month, a net-worth row and a line chart, plus how to value a house or gold carefully.
Read article
Next due date for recurring bills with EDATE in a sheet
Calculate the next due date for monthly, quarterly or yearly bills with EDATE, roll it forward after each payment and flag what is due within seven days.
Read article
No-cost EMI vs cash discount: a sheet to find the cheaper option
Compare a no-cost EMI with a cash discount in Excel using the RATE function to reveal the interest hidden in the offer, plus a simple decision cell.
Read article
NPER formula: how many months to clear a loan at a fixed payment
Use the NPER formula in Excel to find how many months a loan or credit card balance takes to clear at a fixed payment, and compare total interest for two payments.
Read article
Numbers stored as text in a statement: convert a column at once
Convert text to number in Excel for a whole statement column at once: error-check menu, Text to Columns, Paste Special and VALUE, plus a test to confirm.
Read article
Petty cash register format in Excel for a small office
A petty cash register format in Excel for a small office: voucher number, payee, purpose, amount, approver, running balance, top-ups and a closing cash check.
Read article
One master transaction table or one workbook per year?
One master transaction table or a workbook per year? Compare speed, year-on-year views and archiving, then see a simple structure for personal finances.
Read article
One-page spending dashboard layout in Excel
A one-page Excel spending dashboard layout: what belongs on it, a column grid that fits most screens, and a separate calculation sheet behind it.
Read article
Match one payment to several invoices in a sheet
Match one lump-sum payment to several invoices in a sheet with an allocation table, a remaining-balance column and a check that allocations equal the bank amount.
Read article
Open a password-protected statement PDF so you can convert it
Open a password-protected statement PDF you already have the password for, save an unprotected working copy, convert it, then delete the copy.
Read article