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

Take your time. Find what helps.
Editorial illustration for A 13-week cash flow forecast sheet for a freelancer
Spreadsheets 4 min read

A 13-week cash flow forecast sheet for a freelancer

Build a 13-week cash flow forecast sheet for a freelancer: client payments, known bills, opening and closing balance, and a flag for the week the balance runs low.

Read article
Editorial illustration for A 50/30/20 budget sheet in Excel with live formulas
Spreadsheets 4 min read

A 50/30/20 budget sheet in Excel with live formulas

Build a 50/30/20 budget sheet in Excel: enter take-home pay once, tag expenses as need, want or saving, and compare actual share with target.

Read article
Editorial illustration for 50/30/20 rule in Excel: formulas to split income and check spend
Spreadsheets 4 min read

50/30/20 rule in Excel: formulas to split income and check spend

Split take-home pay into 50/30/20 targets in Excel, tag spending as needs, wants or savings and use SUMIFS to see how your actual month compares.

Read article
Editorial illustration for Add a currency column and convert foreign spend to INR in Excel
Spreadsheets 4 min read

Add a currency column and convert foreign spend to INR in Excel

Add Amount, Currency and Rate columns to an Excel expense sheet, build a small rate table, and use XLOOKUP to convert foreign spend to INR, keeping the original.

Read article
Editorial illustration for Add a reconciliation checks sheet to your statement workbook
Spreadsheets 4 min read

Add a reconciliation checks sheet to your statement workbook

Build a Checks sheet in Excel with row counts, debit and credit totals, balance continuity and an uncategorised count, each with a PASS or FAIL cell.

Read article
Editorial illustration for Add a trendline and moving average to an expense chart
Spreadsheets 3 min read

Add a trendline and moving average to an expense chart

Add a linear trendline or a 3-month moving average to an Excel expense chart, read the R-squared value sensibly and know when lumpy spending makes it misleading.

Read article
Editorial illustration for Add an April to March financial year column to your transactions
Spreadsheets 4 min read

Add an April to March financial year column to your transactions

Add an April to March financial year column in Excel: one formula labels dates as FY 2023-24, plus a quarter column tested around 31 March.

Read article
Editorial illustration for Add GST to a price in Excel: exclusive to inclusive with rounding
Spreadsheets 4 min read

Add GST to a price in Excel: exclusive to inclusive with rounding

Add GST to a price in Excel with =ROUND(price*(1+rate),2), set up a rate dropdown, and build a line-item invoice whose total matches the printed bill.

Read article
Editorial illustration for Add a month-and-year column from transaction dates for grouping
Spreadsheets 4 min read

Add a month-and-year column from transaction dates for grouping

Add a month-and-year column in Excel from transaction dates: compare TEXT, DATE and EOMONTH and see which one sorts and groups correctly in pivots.

Read article
Editorial illustration for Advance tax set-aside tracker in Google Sheets for self-employed
Spreadsheets 4 min read

Advance tax set-aside tracker in Google Sheets for self-employed

Build an advance tax set-aside tracker in Google Sheets that reserves a percentage of every payment and shows the reserve against each due date you enter.

Read article
Editorial illustration for Allow Users to Edit Ranges in Excel: let family add entries only
Spreadsheets 4 min read

Allow Users to Edit Ranges in Excel: let family add entries only

Use Allow Edit Ranges in Excel so family can type expenses in one entry area while your formula columns stay locked, and learn what the password protects.

Read article
Editorial illustration for Spread an annual prepaid expense across 12 months in a sheet
Spreadsheets 4 min read

Spread an annual prepaid expense across 12 months in a sheet

Spread an annual insurance or software payment evenly across 12 months in a sheet, and see cash paid versus monthly cost, with formulas you can copy.

Read article