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

Take your time. Find what helps.
Editorial illustration for SPLIT function in Google Sheets: break narrations into columns
Spreadsheets 4 min read

SPLIT function in Google Sheets: break narrations into columns

Learn the SPLIT function in Google Sheets to break a slash-separated bank narration into columns, pick one part with INDEX, and know when the menu command is better.

Read article
Editorial illustration for SPLIT on several separators at once: slash, dash and space
Spreadsheets 4 min read

SPLIT on several separators at once: slash, dash and space

See how to pass several separators to SPLIT in Google Sheets, what split_by_each and remove_empty do, and clean a messy NEFT-style narration in one formula.

Read article
Editorial illustration for Split a narration into columns by slash with Text to Columns
Spreadsheets 4 min read

Split a narration into columns by slash with Text to Columns

Split a bank narration into separate columns at each slash with Excel's Text to Columns, keep the original column safe and handle uneven rows.

Read article
Editorial illustration for Split one amount column into separate debit and credit columns
Spreadsheets 3 min read

Split one amount column into separate debit and credit columns

Split one signed amount column into separate debit and credit columns with MAX(0,...) formulas, plus a check that debit minus credit equals the original.

Read article
Editorial illustration for Split a semicolon or pipe separated statement file into columns
Spreadsheets 4 min read

Split a semicolon or pipe separated statement file into columns

Split a semicolon or pipe separated bank statement file into Excel columns using Text to Columns, or Power Query when you want it repeatable.

Read article
Editorial illustration for Spreadsheet cannot read your bank statement PDF: what to do
Spreadsheets 4 min read

Spreadsheet cannot read your bank statement PDF: what to do

What to do when a spreadsheet cannot read your bank statement PDF: retyping, copy-paste, CSV or Excel download, converters or an app, and each one's risks.

Read article
Editorial illustration for When your spreadsheet has 40 categories: how to simplify them
Spreadsheets 4 min read

When your spreadsheet has 40 categories: how to simplify them

Too many expense categories in your spreadsheet? Audit each category with COUNTIF and SUMIF, merge the rare ones and settle on 12 to 15 for a family.

Read article
Editorial illustration for Spreadsheet or app for freelancers: tracking client income
Spreadsheets 4 min read

Spreadsheet or app for freelancers: tracking client income

Spreadsheet or app for freelancer expense tracking? Compare invoice, TDS and GST columns, business versus personal spends, and quarter-end totals.

Read article
Editorial illustration for Spreadsheet vs app for small business expenses: where each fits
Spreadsheets 4 min read

Spreadsheet vs app for small business expenses: where each fits

Compare a cash book spreadsheet with an expense app for a one-person business: GST fields, receipts, payment modes, accountant sharing and warning signs.

Read article
Editorial illustration for Stacked column chart of monthly spend by category in Excel
Spreadsheets 4 min read

Stacked column chart of monthly spend by category in Excel

Build a stacked column chart of monthly spend by category in Excel from a SUMIFS grid, order the series sensibly and know when 100% stacked reads better.

Read article
Editorial illustration for Stacked column chart of categories by month: build and read it
Spreadsheets 4 min read

Stacked column chart of categories by month: build and read it

Build a stacked column chart of expenses by month in Excel or Sheets, learn when it shows category mix, and how it compares with 100 percent stacked.

Read article
Editorial illustration for Standardise column names and order across different statement files
Spreadsheets 4 min read

Standardise column names and order across different statement files

Build a column-mapping table and use Power Query to rename and reorder different statement headings into one standard layout before you append the files.

Read article