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

Take your time. Find what helps.
Editorial illustration for Client payment follow-up tracker for freelancers in Google Sheets
Spreadsheets 4 min read

Client payment follow-up tracker for freelancers in Google Sheets

A client payment follow-up tracker in Google Sheets for freelancers: days overdue, last reminder, next action and a list that puts the oldest dues first.

Read article
Editorial illustration for A daily collection and expense sheet for a small clinic in Excel
Spreadsheets 3 min read

A daily collection and expense sheet for a small clinic in Excel

An Excel daily collection and expense register for a small clinic: consultations, procedures, cash versus UPI, costs and a monthly roll-up, with no patient data.

Read article
Editorial illustration for College admission cost planner sheet: fees, deposits, setup
Spreadsheets 3 min read

College admission cost planner sheet: fees, deposits, setup

Plan a first year of college with a sheet that splits one-time and per-semester costs, tracks due dates and shows who pays: parents, loan or scholarship.

Read article
Editorial illustration for Colour scale heatmap of monthly spending by category
Spreadsheets 4 min read

Colour scale heatmap of monthly spending by category

Make a colour scale heatmap of monthly spending by category in Excel: a SUMIFS grid, then a 3-colour scale that shows each row's own heaviest months.

Read article
Editorial illustration for Colour debits and credits differently with conditional formatting
Spreadsheets 3 min read

Colour debits and credits differently with conditional formatting

Colour debits and credits differently in Excel with a conditional formatting formula based on the Dr/Cr flag or sign, and keep it working on new rows.

Read article
Editorial illustration for Columns misaligned after converting a statement PDF: how to realign
Spreadsheets 4 min read

Columns misaligned after converting a statement PDF: how to realign

Amounts in the wrong column after converting a statement PDF to Excel? Spot the misaligned rows with simple tests, fix them, and prove it with a row count.

Read article
Editorial illustration for Combine separate debit and credit columns into one amount column
Spreadsheets 3 min read

Combine separate debit and credit columns into one amount column

Combine separate debit and credit columns into one amount column in Excel, handle blank cells safely, and keep the original columns for audit.

Read article
Editorial illustration for Combine several statement tabs into one list in Google Sheets
Spreadsheets 4 min read

Combine several statement tabs into one list in Google Sheets

Stack statement tabs in Google Sheets with curly braces, clean blank and header rows with QUERY, and pull tabs from other files using IMPORTRANGE.

Read article
Editorial illustration for Combine twelve monthly statement CSV files into one sheet
Spreadsheets 4 min read

Combine twelve monthly statement CSV files into one sheet

Combine twelve monthly bank statement CSV files into one Excel sheet by copy and paste, with a Month column and row counts that prove no rows were lost.

Read article
Editorial illustration for Compare a bank statement with your sheet to find missing entries
Spreadsheets 3 min read

Compare a bank statement with your sheet to find missing entries

Compare a bank statement with your expense sheet to find missing entries: COUNTIFS on date and amount marks unmatched lines, and a reverse check catches the rest.

Read article
Editorial illustration for Compare this month with last month in a spreadsheet
Spreadsheets 4 min read

Compare this month with last month in a spreadsheet

Compare this month with last month by category in a spreadsheet using SUMIFS, EDATE with -1 and IFERROR, showing the change in rupees and in percent.

Read article
Editorial illustration for Compare this month with the same month last year in a chart
Spreadsheets 3 min read

Compare this month with the same month last year in a chart

Compare each month's spending with the same month last year in Excel: two SUMIFS series using EDATE shifts and a clustered column chart.

Read article