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

Take your time. Find what helps.
Editorial illustration for Annual expense calendar sheet: map yearly bills month by month
Spreadsheets 4 min read

Annual expense calendar sheet: map yearly bills month by month

Build an annual expense calendar in Excel: a twelve-month grid for insurance, school fees, festivals and service bills that shows which months need a buffer.

Read article
Editorial illustration for Annual summary sheet that pulls from twelve monthly tabs
Spreadsheets 4 min read

Annual summary sheet that pulls from twelve monthly tabs

Make an annual expense summary in Excel from twelve monthly tabs with direct links, a 3D SUM or INDIRECT, plus totals and a highlighted peak month.

Read article
Editorial illustration for Append two bank accounts into one table with an Account column
Spreadsheets 4 min read

Append two bank accounts into one table with an Account column

Append a savings and a current account statement in Power Query, add an Account column to each first, and check that column names match before combining.

Read article
Editorial illustration for ARRAYFORMULA to fill a category column automatically in Sheets
Spreadsheets 4 min read

ARRAYFORMULA to fill a category column automatically in Sheets

Replace copy-down formulas in Google Sheets with one ARRAYFORMULA in the header row, add a blank-row guard and keep rows inserted later correct.

Read article
Editorial illustration for Ask ChatGPT or Claude to clean your expense sheet: prompts
Spreadsheets 4 min read

Ask ChatGPT or Claude to clean your expense sheet: prompts

Clean an expense spreadsheet with ChatGPT or Claude: ready-to-paste prompts for messy descriptions, categories and duplicates, plus a privacy checklist.

Read article
Editorial illustration for Receipts in a spreadsheet: Google Drive links and their limits
Spreadsheets 4 min read

Receipts in a spreadsheet: Google Drive links and their limits

Attach receipts to an expense spreadsheet using a Google Drive folder per month and a link column, with file naming tips and where this method breaks down.

Read article
Editorial illustration for Average monthly expenses over the last 6 months in Excel
Spreadsheets 3 min read

Average monthly expenses over the last 6 months in Excel

Find your average monthly expenses over the last 6 months in Excel by averaging monthly totals built with SUMIFS and EDATE, not averaging single transactions.

Read article
Editorial illustration for AVERAGEIFS for average spend per category in Excel
Spreadsheets 4 min read

AVERAGEIFS for average spend per category in Excel

AVERAGEIFS gives the average transaction per category, not the average per month. See the pitfall and the SUMIFS-divided-by-months fix with examples.

Read article
Editorial illustration for Baby expense budget sheet for the first year in Excel
Spreadsheets 3 min read

Baby expense budget sheet for the first year in Excel

A baby expense budget sheet for the first year in Excel: one-time buys, recurring items projected by units per week, a gift-received flag and a month grid.

Read article
Editorial illustration for Back-calculate GST from a GST-inclusive amount in Excel
Spreadsheets 3 min read

Back-calculate GST from a GST-inclusive amount in Excel

Split a GST-inclusive total into base amount and tax in Excel using a rate cell, with CGST and SGST halves, and avoid the common total-times-rate error.

Read article
Editorial illustration for Back up your expense workbook automatically (cloud or local)
Spreadsheets 3 min read

Back up your expense workbook automatically (cloud or local)

Set up automatic backup for your expense workbook with cloud autosave, version history and a scheduled copy, and test a restore once a month.

Read article
Editorial illustration for Back up your expense spreadsheet: a simple three-copy routine
Spreadsheets 4 min read

Back up your expense spreadsheet: a simple three-copy routine

A simple three-copy routine for your expense spreadsheet: a cloud copy, a dated monthly download and an offline copy, plus version history for bad edits.

Read article