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

Take your time. Find what helps.
Editorial illustration for Opening balances when you move from a sheet to an app
Spreadsheets 4 min read

Opening balances when you move from a sheet to an app

Moving from a spreadsheet to an expense app? Pick a cut-over date, note each account's balance from the statement and check it after the first import.

Read article
Editorial illustration for A trip, fuel and earnings sheet for an owner-driver cab
Spreadsheets 4 min read

A trip, fuel and earnings sheet for an owner-driver cab

A trip, fuel and earnings sheet for an owner-driver cab: daily rows, weekly earnings, cost per km, and a monthly line for EMI and servicing.

Read article
Editorial illustration for Parents monthly support tracker sheet for money sent home
Spreadsheets 4 min read

Parents monthly support tracker sheet for money sent home

A monthly support tracker for money sent to parents: fixed transfers, medicines, bills and gifts in one sheet, who paid, and a sibling share review at year end.

Read article
Editorial illustration for Pareto chart: which few categories make up most of your spending
Spreadsheets 3 min read

Pareto chart: which few categories make up most of your spending

Build a Pareto chart of your spending in Excel: sort categories, add a cumulative percentage line and see which few categories make up most of it.

Read article
Editorial illustration for Pareto chart of spending categories in Excel
Spreadsheets 4 min read

Pareto chart of spending categories in Excel

Build a Pareto chart of your spending categories in Excel: sort totals, add a cumulative percentage and draw a combo chart to see what drives most of the spend.

Read article
Editorial illustration for Parse a pasted bank SMS alert into columns in Google Sheets
Spreadsheets 3 min read

Parse a pasted bank SMS alert into columns in Google Sheets

Parse a pasted bank debit SMS into amount, date and merchant columns in Google Sheets with REGEXEXTRACT, and see why alert formats differ from bank to bank.

Read article
Editorial illustration for Password protect an Excel file that holds your expense data
Spreadsheets 3 min read

Password protect an Excel file that holds your expense data

Password protect an Excel file that holds your expense data with File, Info, Encrypt with Password, and learn what it covers and what it does not.

Read article
Editorial illustration for PDF or CSV statement download: which one should you pick?
Spreadsheets 4 min read

PDF or CSV statement download: which one should you pick?

PDF or CSV statement download for Excel: compare effort, accuracy and completeness, with a simple rule for when only a PDF is on offer.

Read article
Editorial illustration for Percentage of income spent on each category: formula and layout
Spreadsheets 4 min read

Percentage of income spent on each category: formula and layout

Work out the percentage of income spent on each category in Excel or Sheets: divide the category total by one take-home income cell and format as percent.

Read article
Editorial illustration for Personal expense dashboard in Google Sheets with category charts
Spreadsheets 4 min read

Personal expense dashboard in Google Sheets with category charts

Make a personal expense dashboard in Google Sheets: a Data tab, a month selector, SUMIFS category totals, a pie chart and a top-five merchants list.

Read article
Editorial illustration for Before you share your finance sheet: a privacy clean-up checklist
Spreadsheets 4 min read

Before you share your finance sheet: a privacy clean-up checklist

A privacy clean-up checklist for sharing a finance spreadsheet with an adviser, spouse or flatmate: remove identifiers, check hidden data and set link limits.

Read article
Editorial illustration for A bed-wise rent and occupancy sheet for PG owners
Spreadsheets 4 min read

A bed-wise rent and occupancy sheet for PG owners

A bed-wise rent and occupancy sheet for PG owners in Excel: monthly rent due versus received, deposits, occupancy percentage and cash flow after costs.

Read article