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 34 of 50
Take your time. Find what helps.
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
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
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
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
#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
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
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
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
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
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
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
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