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

Take your time. Find what helps.
Editorial illustration for Excel swapping day and month in statement dates: why it happens
Spreadsheets 4 min read

Excel swapping day and month in statement dates: why it happens

Why Excel swaps day and month in statement dates: days 1 to 12 flip while 13 to 31 stay text. Here is the cause, plus a repair for a damaged column.

Read article
Editorial illustration for Excel tables for an expense log with auto-expanding formulas
Spreadsheets 3 min read

Excel tables for an expense log with auto-expanding formulas

Turn your expense log into an Excel table with Ctrl+T, name it, and use structured references in SUMIFS so formulas grow automatically when you add rows.

Read article
Editorial illustration for Excel vs an expense tracker app: what you gain and what you give up
Spreadsheets 4 min read

Excel vs an expense tracker app: what you gain and what you give up

A fair comparison of an Excel or Sheets expense file and an expense tracker app across flexibility, setup, typing, categories, receipts, privacy and cost.

Read article
Editorial illustration for Exclude one-time expenses from your monthly average spend
Spreadsheets 3 min read

Exclude one-time expenses from your monthly average spend

Add a one-time flag column, then use SUMIFS and AVERAGEIFS to get a normal-month spending figure, kept apart from big annual or one-off costs.

Read article
Editorial illustration for Exclude opening and closing balance rows from transaction totals
Spreadsheets 4 min read

Exclude opening and closing balance rows from transaction totals

Opening and closing balance lines can inflate statement totals. Tag them with a Type column, keep them for reconciliation, and sum only transactions.

Read article
Editorial illustration for Build an expense dashboard in Google Sheets with QUERY and charts
Spreadsheets 4 min read

Build an expense dashboard in Google Sheets with QUERY and charts

Build a Google Sheets expense dashboard with a month selector, scorecards, two charts and a QUERY top-10 list, using formulas you can copy.

Read article
Editorial illustration for Expense Excel file too slow or too big? How to fix it or move on
Spreadsheets 4 min read

Expense Excel file too slow or too big? How to fix it or move on

Why an expense Excel or Google Sheets file turns slow or huge, from volatile formulas to embedded receipts, and a clean-up routine before you move on.

Read article
Editorial illustration for Columns every expense log sheet needs (and ones to skip)
Spreadsheets 4 min read

Columns every expense log sheet needs (and ones to skip)

A checklist of the columns an expense log sheet needs, the helper columns that save work, and the ones to skip so you keep logging every day.

Read article
Editorial illustration for Expense-to-income ratio: formula and what the result means
Spreadsheets 3 min read

Expense-to-income ratio: formula and what the result means

Expense-to-income ratio explained: the one-cell formula, a worked example at three spending levels, and what the number does and does not tell you.

Read article
Editorial illustration for Track expenses by salary cycle (25th to 24th) instead of month
Spreadsheets 4 min read

Track expenses by salary cycle (25th to 24th) instead of month

Group expenses by a salary cycle such as 25th to 24th instead of the calendar month using a helper column that shifts dates, then SUMIFS or a pivot as usual.

Read article
Editorial illustration for Export from an expense app to Excel and build your own pivot reports
Spreadsheets 4 min read

Export from an expense app to Excel and build your own pivot reports

Export expenses from an app to Excel, turn the CSV into a table, and build two pivot reports: category by month and merchant totals, with checks.

Read article
Editorial illustration for Extract the UPI handle after the @ sign from a narration
Spreadsheets 3 min read

Extract the UPI handle after the @ sign from a narration

Extract the text after the @ sign in a UPI narration with TEXTAFTER or MID, group transactions by handle and use it carefully to review payees.

Read article