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

Take your time. Find what helps.
Editorial illustration for Tables in Google Sheets: column types, dropdowns and auto-fill rows
Spreadsheets 4 min read

Tables in Google Sheets: column types, dropdowns and auto-fill rows

Convert an expense log to a Google Sheets table, set Date, Currency and Dropdown column types, and watch new rows inherit formatting. Notes for older files included.

Read article
Editorial illustration for Top N expenses in Excel 365 with TAKE and SORTBY
Spreadsheets 3 min read

Top N expenses in Excel 365 with TAKE and SORTBY

List the top N expenses in Excel 365 with TAKE and SORTBY, set N from a cell, and see the LARGE and INDEX method that works in older Excel.

Read article
Editorial illustration for Document and proof tracker sheet for tax-time paperwork
Spreadsheets 4 min read

Document and proof tracker sheet for tax-time paperwork

A tax-time paperwork tracker for Excel or Google Sheets: columns, sample rows and formulas that show which documents have arrived. No figures involved.

Read article
Editorial illustration for TDS gross to net calculator in Excel for a freelance invoice
Spreadsheets 4 min read

TDS gross to net calculator in Excel for a freelance invoice

Set up a TDS calculator in Excel for a freelance invoice: net receivable from the gross, and the reverse formula for the gross needed to receive a target.

Read article
Editorial illustration for TDS tracker for freelancers: matching client deductions in Excel
Spreadsheets 4 min read

TDS tracker for freelancers: matching client deductions in Excel

Set up a TDS tracker in Excel for freelancers that logs each client deduction, flags short deductions and totals TDS per client for the year.

Read article
Editorial illustration for Template or app: which to choose for your very first budget
Spreadsheets 4 min read

Template or app: which to choose for your very first budget

Template or app for your very first budget? Use a three-question quiz on time, patience and spending habits to decide whether a sheet or a tracker suits you.

Read article
Editorial illustration for TEXTBEFORE, TEXTAFTER and TEXTSPLIT for narrations in Excel 365
Spreadsheets 3 min read

TEXTBEFORE, TEXTAFTER and TEXTSPLIT for narrations in Excel 365

Use TEXTBEFORE, TEXTAFTER and TEXTSPLIT in Excel 365 to cut bank narrations apart by delimiter, with nth-instance, if_not_found and spill examples.

Read article
Editorial illustration for List merchants per category in one cell with TEXTJOIN and FILTER
Spreadsheets 3 min read

List merchants per category in one cell with TEXTJOIN and FILTER

List every merchant in each spending category in one cell using TEXTJOIN, FILTER and UNIQUE, with no pivot table and results that update with your data.

Read article
Editorial illustration for Three-way match of invoice, bank and ledger in one sheet
Spreadsheets 4 min read

Three-way match of invoice, bank and ledger in one sheet

Build a three-way match of invoice, bank and ledger in one sheet with lookups on invoice number and amount, giving statuses like Matched and Paid not booked.

Read article
Editorial illustration for Top 5 biggest expenses with LARGE and INDEX MATCH
Spreadsheets 4 min read

Top 5 biggest expenses with LARGE and INDEX MATCH

List your five biggest expenses in Excel with LARGE and INDEX MATCH, including a trick for equal amounts, plus the SORTBY and TAKE shortcut.

Read article
Editorial illustration for Top 5 expenses in Excel using LARGE (works in older versions)
Spreadsheets 3 min read

Top 5 expenses in Excel using LARGE (works in older versions)

List your top 5 expenses in Excel with LARGE, fetch the merchant and date with INDEX and MATCH, and handle tied amounts. Works in older Excel versions too.

Read article
Editorial illustration for Find the top merchant in each category with MAXIFS and XLOOKUP
Spreadsheets 3 min read

Find the top merchant in each category with MAXIFS and XLOOKUP

Find the top merchant in each spending category with a helper table, MAXIFS and XLOOKUP in Excel, with INDEX and MATCH for Google Sheets.

Read article