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 16 of 50
Take your time. Find what helps.
Find recurring payments with COUNTIFS on merchant and month
Find recurring payments in a bank statement with COUNTIFS on a cleaned merchant column and month, then filter for merchants seen in three or more months.
Read article
Find recurring subscriptions in your statement with a formula
Find recurring subscriptions in your statement sheet with COUNTIFS: flag a merchant and amount that repeats three months in a row, then total the monthly cost.
Read article
Find transactions in one statement but not in the other in Excel
Find missing transactions between two lists in Excel: build a match on amount, date and reference with COUNTIFS, flag rows in A or B only, then filter.
Read article
Fiscal month number (April = 1) from a date: the formula
Get a fiscal month number from any date, with April as month 1 and March as 12, using MOD or IF, then use it for sorting and year-to-date totals.
Read article
Fiscal year label from a transaction date in Google Sheets
Create an FY 24-25 style fiscal year label for every transaction in Google Sheets with IF, MONTH, TEXT and ARRAYFORMULA, with blank rows handled.
Read article
Fit a wide budget sheet on A4: print area, scaling and page breaks
How to make a wide Excel budget sheet print on A4: set the print area, fit all columns on one page, use landscape, fix page breaks and keep the text readable.
Read article
A client package and session tracker for fitness trainers
A client package and session tracker for fitness trainers: sessions used and remaining, payment status, renewal flags and monthly income and expenses.
Read article
Fix dd/mm/yyyy date problems in your sheet before an import
Why 03/04 can import as March or April, how to test with a few rows, and how to convert text dates with DATE, DATEVALUE or Text to Columns before export.
Read article
Fix text dates with Text to Columns (DMY) in Excel
Convert dd/mm/yyyy text to real dates in Excel with Text to Columns and the DMY setting, no formula needed, and confirm they are true numbers afterwards.
Read article
Fixed vs variable expenses: percentage formula in a sheet
Split spending into fixed and variable expenses in a sheet with a category lookup and SUMIFS, then see what percentage of the month is already committed.
Read article
Flag ATM cash withdrawals in a statement with a formula
Flag ATM cash withdrawals in a bank statement with ISNUMBER and SEARCH, total cash taken out each month and see how much cash goes untracked.
Read article
Flag EMI, NACH and ECS auto-debits in a statement with a formula
Flag EMI, NACH and ECS auto-debits in a bank statement with a keyword formula, then total them by month to see what leaves without a manual action.
Read article