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

Take your time. Find what helps.
Editorial illustration for Bar chart of your top 10 merchants from statement data
Spreadsheets 4 min read

Bar chart of your top 10 merchants from statement data

Make a sorted horizontal bar chart of your top 10 merchants with a pivot table Top 10 filter, and see how cleaning merchant names changes the ranking.

Read article
Editorial illustration for Bill due date calendar in Google Sheets with colour alerts
Spreadsheets 4 min read

Bill due date calendar in Google Sheets with colour alerts

Build a bill due date calendar in Google Sheets with a days-to-go column from TODAY(), red overdue rows and a paid status that resets itself each month.

Read article
Editorial illustration for Bill due dates into Google Calendar from a sheet, no scripts
Spreadsheets 4 min read

Bill due dates into Google Calendar from a sheet, no scripts

Turn a bill list in a sheet into Google Calendar reminders with a CSV import: set the Subject, Start Date and Description columns and handle repeating bills.

Read article
Editorial illustration for Blank cells in debit and credit columns breaking your formulas
Spreadsheets 4 min read

Blank cells in debit and credit columns breaking your formulas

Blank-looking cells in debit and credit columns can return #VALUE! or wrong totals; learn empty vs empty string vs space and a one-step clean-up.

Read article
Editorial illustration for Order tracker for boutiques and tailors: advance and balance
Spreadsheets 3 min read

Order tracker for boutiques and tailors: advance and balance

A boutique and tailor order tracker for Excel: advance, balance due, delivery date and an overdue flag, plus a month view of pending balances.

Read article
Editorial illustration for Break-even calculator sheet for a small shop or home business
Spreadsheets 4 min read

Break-even calculator sheet for a small shop or home business

Build a break-even sheet for a small shop or home business: fixed costs, price and variable cost per unit give the break-even quantity and rupees.

Read article
Editorial illustration for Budget progress bar with SPARKLINE in Google Sheets
Spreadsheets 4 min read

Budget progress bar with SPARKLINE in Google Sheets

Draw a budget progress bar inside a cell with the Google Sheets SPARKLINE function, charttype bar, a max set to the budget and a colour that turns red when over.

Read article
Editorial illustration for Budget vs actual combo chart in Excel
Spreadsheets 3 min read

Budget vs actual combo chart in Excel

Make a budget vs actual chart in Excel: actual spend as columns, the budget as a marker or line, and over-budget categories coloured red.

Read article
Editorial illustration for Budget vs actual formula for a monthly budget in Excel
Spreadsheets 4 min read

Budget vs actual formula for a monthly budget in Excel

Build a three-column budget vs actual sheet in Excel: type the budget, pull actual spend with SUMIFS from your expense log and show the difference.

Read article
Editorial illustration for Budget vs actual sheet in Excel with a variance column
Spreadsheets 3 min read

Budget vs actual sheet in Excel with a variance column

Build a budget vs actual sheet in Excel with twelve monthly columns, a variance column and a flag for categories that run over, with a groceries example.

Read article
Editorial illustration for Build a budget from three months of bank statements in Excel
Spreadsheets 3 min read

Build a budget from three months of bank statements in Excel

Build a monthly budget in Excel from three bank statements: tag categories, average with SUMIFS, drop one-offs and move yearly bills to a sinking fund.

Read article
Editorial illustration for Separate business and personal expenses in one sheet with SUMIFS
Spreadsheets 4 min read

Separate business and personal expenses in one sheet with SUMIFS

Keep business and personal spending in one sheet with a validated Type column and SUMIFS for each, so a freelancer can pull only the business rows later.

Read article