THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 16 of 50

Take your time. Find what helps.
Editorial illustration for Find recurring payments with COUNTIFS on merchant and month
Spreadsheets 3 min read

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
Editorial illustration for Find recurring subscriptions in your statement with a formula
Spreadsheets 3 min read

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
Editorial illustration for Find transactions in one statement but not in the other in Excel
Spreadsheets 3 min read

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
Editorial illustration for Fiscal month number (April = 1) from a date: the formula
Spreadsheets 4 min read

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
Editorial illustration for Fiscal year label from a transaction date in Google Sheets
Spreadsheets 3 min read

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
Editorial illustration for Fit a wide budget sheet on A4: print area, scaling and page breaks
Spreadsheets 4 min read

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
Editorial illustration for A client package and session tracker for fitness trainers
Spreadsheets 4 min read

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
Editorial illustration for Fix dd/mm/yyyy date problems in your sheet before an import
Spreadsheets 4 min read

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
Editorial illustration for Fix text dates with Text to Columns (DMY) in Excel
Spreadsheets 4 min read

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
Editorial illustration for Fixed vs variable expenses: percentage formula in a sheet
Spreadsheets 3 min read

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
Editorial illustration for Flag ATM cash withdrawals in a statement with a formula
Spreadsheets 4 min read

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
Editorial illustration for Flag EMI, NACH and ECS auto-debits in a statement with a formula
Spreadsheets 3 min read

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