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

Take your time. Find what helps.
Editorial illustration for Joint family expense sheet: Excel format with member contributions
Spreadsheets 3 min read

Joint family expense sheet: Excel format with member contributions

A joint family expense sheet in Excel: one row per earning member, a common pool for kitchen and utilities, and a contribution versus agreed share column.

Read article
Editorial illustration for Run your sheet and an app in parallel for one month: how to compare
Spreadsheets 3 min read

Run your sheet and an app in parallel for one month: how to compare

How to run your spreadsheet and an expense app side by side for a month and compare total spend, category totals and transaction counts with a tolerance.

Read article
Editorial illustration for Keyword rules in priority order: first match wins in a sheet
Spreadsheets 3 min read

Keyword rules in priority order: first match wins in a sheet

Make a sheet categorise by keyword rules where the first match wins, so Amazon Pay Electricity lands in Utilities before the generic Amazon rule.

Read article
Editorial illustration for Daily cash book format in Excel for a small kirana shop
Spreadsheets 3 min read

Daily cash book format in Excel for a small kirana shop

A daily cash book format in Excel for a small kirana shop: cash sales, UPI, udhaar recovered, payments, a running closing balance and a cash-short flag.

Read article
Editorial illustration for A reusable LAMBDA to clean UPI narrations in Excel
Spreadsheets 4 min read

A reusable LAMBDA to clean UPI narrations in Excel

Wrap TEXTAFTER, TEXTBEFORE, SUBSTITUTE and TRIM into one named Excel function, CleanNarr, and clean a UPI narration column. Needs Microsoft 365.

Read article
Editorial illustration for LAMBDA basics: build your own expense function in Excel
Spreadsheets 4 min read

LAMBDA basics: build your own expense function in Excel

Build a LAMBDA in Excel that returns net spend, debits minus refunds, for a category and month, then save it by name. Microsoft 365 only.

Read article
Editorial illustration for Rent collection tracker for landlords in Excel with tenant ledger
Spreadsheets 4 min read

Rent collection tracker for landlords in Excel with tenant ledger

Set up an Excel rent register for a landlord: tenant ledger with due, received and arrears carried forward, plus a repairs and society charges tab.

Read article
Editorial illustration for Total expenses for the last 30 days with SUMIFS and TODAY
Spreadsheets 4 min read

Total expenses for the last 30 days with SUMIFS and TODAY

Sum your expenses for the last 7, 30 or 90 days with SUMIFS and TODAY, avoid the off-by-one mistake, and learn why the window moves each time you open the file.

Read article
Editorial illustration for Show your latest 10 transactions automatically with TAKE and SORT
Spreadsheets 4 min read

Show your latest 10 transactions automatically with TAKE and SORT

Build a recent activity box that shows your latest 10 transactions automatically with SORT and TAKE on a summary tab, plus an option for Excel before 365.

Read article
Editorial illustration for LET function in Excel: make long expense formulas readable
Spreadsheets 4 min read

LET function in Excel: make long expense formulas readable

Use the LET function in Excel to name each range once and make a long SUMIFS savings formula readable. Needs Excel 2021 or Microsoft 365.

Read article
Editorial illustration for Line chart of monthly spending trend in Excel
Spreadsheets 4 min read

Line chart of monthly spending trend in Excel

Turn a monthly spending summary into an Excel line chart with markers, set the date axis correctly, and read the trend without being fooled by one-off months.

Read article
Editorial illustration for Link receipt photos to expense rows with HYPERLINK in Sheets
Spreadsheets 4 min read

Link receipt photos to expense rows with HYPERLINK in Sheets

Use the HYPERLINK formula in Google Sheets to link Drive receipt photos to expense rows, with a date_merchant_amount file name that is easy to search.

Read article