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

Take your time. Find what helps.
Editorial illustration for Merge yearly expense tabs into one master transaction list
Spreadsheets 4 min read

Merge yearly expense tabs into one master transaction list

Combine multiple Excel sheets of expenses into one master list: stack yearly tabs, add a year column, fix column order and remove duplicates safely.

Read article
Editorial illustration for Microsoft Forms to Excel: log expenses from your phone
Spreadsheets 4 min read

Microsoft Forms to Excel: log expenses from your phone

Build a Microsoft Form tied to an Excel workbook in OneDrive to log expenses from your phone, then add a summary tab that reads the responses without editing them.

Read article
Editorial illustration for Mileage log template in Excel for business trips
Spreadsheets 4 min read

Mileage log template in Excel for business trips

Create a mileage log in Excel with start and end odometer, purpose, per-km value in a settings cell and a business versus personal split, with an example.

Read article
Editorial illustration for Milk delivery log in Google Sheets to check the monthly bill
Spreadsheets 4 min read

Milk delivery log in Google Sheets to check the monthly bill

A milk delivery tracker in Google Sheets: daily litres, price per litre, skipped and extra days, and a monthly total to check against the vendor's bill.

Read article
Editorial illustration for Why expense entry in Excel on a phone is painful and what helps
Spreadsheets 3 min read

Why expense entry in Excel on a phone is painful and what helps

Why entering expenses in an Excel or Google Sheets file on your phone is painful, which workarounds help, and when a mobile-first tracker removes the issue.

Read article
Editorial illustration for Month-by-category expense matrix with one SUMIFS formula
Spreadsheets 4 min read

Month-by-category expense matrix with one SUMIFS formula

Build a month-by-category expense matrix with a single SUMIFS formula using mixed references, then add total row and column plus a check cell.

Read article
Editorial illustration for Extract month and year from a date column in an expense sheet
Spreadsheets 4 min read

Extract month and year from a date column in an expense sheet

Add a month and year helper column in Excel with MONTH, TEXT and a sortable key, and learn which version works best for SUMIFS and pivot tables.

Read article
Editorial illustration for Add a month name column that fills itself in Google Sheets
Spreadsheets 4 min read

Add a month name column that fills itself in Google Sheets

Make a month name column in Google Sheets that fills itself for every new transaction with one ARRAYFORMULA and an IF guard for blank rows.

Read article
Editorial illustration for Month-on-month spending change: percentage formula in Excel
Spreadsheets 4 min read

Month-on-month spending change: percentage formula in Excel

Calculate month-on-month spending change in Excel with =(this-last)/last, guard against zero with IF or IFERROR, and colour rises and falls automatically.

Read article
Editorial illustration for Month selector dropdown for an Excel spending dashboard
Spreadsheets 4 min read

Month selector dropdown for an Excel spending dashboard

Add a month dropdown to an Excel spending dashboard with data validation, so SUMIFS formulas and charts update for whichever month you pick.

Read article
Editorial illustration for Monthly expense tracker in Excel with Indian categories pre-filled
Spreadsheets 4 min read

Monthly expense tracker in Excel with Indian categories pre-filled

Build a monthly expense tracker in Excel with Indian categories pre-filled, a transaction log and a SUMIFS summary, in about fifteen minutes.

Read article
Editorial illustration for Monthly grocery tracker sheet for Excel with price per unit
Spreadsheets 4 min read

Monthly grocery tracker sheet for Excel with price per unit

A grocery expense tracker for Excel with a purchase log, price per kg or litre by month and a kirana, supermarket and online split to spot price creep.

Read article