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

Take your time. Find what helps.
Editorial illustration for Credit card spend tracker sheet organised by statement cycle
Spreadsheets 4 min read

Credit card spend tracker sheet organised by statement cycle

Track credit card spends by statement cycle, not calendar month, in a spreadsheet with a statement-month formula and totals that match your bill.

Read article
Editorial illustration for Credit card statement lines marked Cr: refunds and payments in Excel
Spreadsheets 4 min read

Credit card statement lines marked Cr: refunds and payments in Excel

What Cr means on a credit card statement, why its sign differs from a bank account, and how to normalise both in Excel so payments are not spending.

Read article
Editorial illustration for Credit card statement PDF to Excel: pull out only the transactions
Spreadsheets 4 min read

Credit card statement PDF to Excel: pull out only the transactions

Convert a credit card statement PDF to Excel and keep only the transaction table: drop summary boxes, sign payments and refunds, and check the date range.

Read article
Editorial illustration for Cumulative spend line vs the monthly budget line
Spreadsheets 4 min read

Cumulative spend line vs the monthly budget line

Chart month-to-date spending against a straight budget line in Excel with SUMIFS, and see which day you will cross the limit at your current pace.

Read article
Editorial illustration for Customer paid less than the invoice: a difference column
Spreadsheets 3 min read

Customer paid less than the invoice: a difference column

Add Invoice, Received and Difference columns, then split each gap into labelled reasons such as deductions, bank charges and short payment.

Read article
Editorial illustration for Daily expense sheet in Google Sheets that is easy to fill on a phone
Spreadsheets 3 min read

Daily expense sheet in Google Sheets that is easy to fill on a phone

Design a daily expense sheet in Google Sheets for phone entry using a Google Form, a category dropdown, a Today total cell and a monthly summary tab.

Read article
Editorial illustration for Daily spending allowance for the rest of the month: formula
Spreadsheets 4 min read

Daily spending allowance for the rest of the month: formula

Work out how much you can spend per day for the rest of the month with a budget, spend so far, EOMONTH and TODAY, plus a guard for the last day.

Read article
Editorial illustration for Checklist: clean your expense data before formulas or pivots
Spreadsheets 4 min read

Checklist: clean your expense data before formulas or pivots

A ten-point checklist to clean expense data before formulas or pivot tables: real dates, numeric amounts, one header row and consistent categories.

Read article
Editorial illustration for Why you stop updating your expense spreadsheet after a few weeks
Spreadsheets 4 min read

Why you stop updating your expense spreadsheet after a few weeks

Why you stop updating an expense spreadsheet after a few weeks: one month's typing effort worked out, and which parts statement import can remove.

Read article
Editorial illustration for One-variable Data Table: see savings at different spending cuts
Spreadsheets 4 min read

One-variable Data Table: see savings at different spending cuts

Build a one-variable Data Table in Excel to see monthly savings at different spending cuts, and avoid the row and column input cell mix-up.

Read article
Editorial illustration for Two-variable Data Table: monthly saving vs months to a goal
Spreadsheets 4 min read

Two-variable Data Table: monthly saving vs months to a goal

Build a two-variable Data Table in Excel with monthly saving down the side and months across, to see the goal amount reached at each combination.

Read article
Editorial illustration for Data validation to stop wrong amounts in an expense sheet
Spreadsheets 3 min read

Data validation to stop wrong amounts in an expense sheet

Use Data Validation in Excel to stop wrong amounts: allow only a decimal above zero, show a clear message, block text like 1,200 rs and catch blanks.

Read article