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 34 of 50

Take your time. Find what helps.
Editorial illustration for Reconcile a supplier's statement of account with your ledger
Spreadsheets 3 min read

Reconcile a supplier's statement of account with your ledger

Reconcile a supplier's statement of account with your ledger: match on invoice number, list timing differences, missing credit notes and disputed items.

Read article
Editorial illustration for Reconcile transfers between your own accounts so they net to zero
Spreadsheets 3 min read

Reconcile transfers between your own accounts so they net to zero

Match each transfer out of one account with its credit in another by amount and date, flag the unmatched ones, and prove the transfers net to zero.

Read article
Editorial illustration for Recover an unsaved or overwritten Excel expense file
Spreadsheets 4 min read

Recover an unsaved or overwritten Excel expense file

Recover an unsaved or overwritten Excel expense file with Document Recovery, AutoRecover and version history, and know what to do right after an overwrite.

Read article
Editorial illustration for Reduce an Excel file's size: used range, formatting and XLSB
Spreadsheets 4 min read

Reduce an Excel file's size: used range, formatting and XLSB

How to reduce an Excel file's size: reset the used range, clear blank formatted rows, compress images, trim pivot caches, and when XLSB is worth using.

Read article
Editorial illustration for #REF! error in Excel: why expense formulas break, and fixes
Spreadsheets 4 min read

#REF! error in Excel: why expense formulas break, and fixes

Why #REF! appears in an Excel budget or expense sheet, the three usual causes, a before and after formula, the Ctrl+Z test and how to repair and prevent it.

Read article
Editorial illustration for Reference numbers turning into 1.23E+11 when opening a CSV
Spreadsheets 4 min read

Reference numbers turning into 1.23E+11 when opening a CSV

UPI and transaction reference numbers turn into 1.23E+11 in Excel. See when the digits are safe, when they are lost, and how to import them as text.

Read article
Editorial illustration for Refresh a Power Query workbook when a new statement month arrives
Spreadsheets 3 min read

Refresh a Power Query workbook when a new statement month arrives

A routine for adding a new month to a Power Query workbook: drop in the file, Refresh All, check row counts, and fix a slightly different layout.

Read article
Editorial illustration for Refunds in an expense sheet: negative row or income?
Spreadsheets 4 min read

Refunds in an expense sheet: negative row or income?

How to record a refund in an expense sheet: a negative row in the same category or as income, how each changes your totals, and when to use which.

Read article
Editorial illustration for REGEXEXTRACT to pull the merchant out of a UPI narration in Sheets
Spreadsheets 3 min read

REGEXEXTRACT to pull the merchant out of a UPI narration in Sheets

Use REGEXEXTRACT in Google Sheets to pull the merchant name out of a UPI bank narration, understand the capture group, and add an IFERROR fallback.

Read article
Editorial illustration for REGEXMATCH to categorise expenses by keywords in Google Sheets
Spreadsheets 4 min read

REGEXMATCH to categorise expenses by keywords in Google Sheets

Use REGEXMATCH in Google Sheets to tag bank narrations with a category from a list of keywords, then fill the whole column with one ARRAYFORMULA.

Read article
Editorial illustration for REGEXREPLACE to strip reference numbers from narrations in Sheets
Spreadsheets 3 min read

REGEXREPLACE to strip reference numbers from narrations in Sheets

Strip long reference numbers, dates and stray symbols from bank narrations with REGEXREPLACE in Google Sheets, with three patterns and what each one removes.

Read article
Editorial illustration for Remaining budget per category: the formula (budget minus spent)
Spreadsheets 4 min read

Remaining budget per category: the formula (budget minus spent)

Find the remaining budget per category with Budget minus SUMIFS spent, floor it at zero with MAX, and add an OK, Close or Over status column in Excel.

Read article