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

Take your time. Find what helps.
Editorial illustration for Income vs expense chart with a savings rate line
Spreadsheets 4 min read

Income vs expense chart with a savings rate line

Chart monthly income and expenses as columns with a savings rate line on a secondary axis in Excel. Includes the formula and a four-month example.

Read article
Editorial illustration for INDEX MATCH to look up a category from a merchant list
Spreadsheets 4 min read

INDEX MATCH to look up a category from a merchant list

Look up a category from a merchant list with INDEX and MATCH, including the case where the category sits left of the merchant and VLOOKUP cannot work.

Read article
Editorial illustration for Indian lakh comma format in Excel (12,34,567) with a custom format
Spreadsheets 4 min read

Indian lakh comma format in Excel (12,34,567) with a custom format

Show Excel amounts as 12,34,567 with a conditional custom number format, see where it breaks for negatives and crores, and when to use the regional setting.

Read article
Editorial illustration for Indian number format in Google Sheets: lakh grouping and rupee
Spreadsheets 4 min read

Indian number format in Google Sheets: lakh grouping and rupee

Set the spreadsheet locale to India and use a custom number format in Google Sheets to show lakh grouping and the rupee sign, and see how it differs from Excel.

Read article
Editorial illustration for INDIRECT to pull totals from whichever monthly tab you pick
Spreadsheets 4 min read

INDIRECT to pull totals from whichever monthly tab you pick

Use INDIRECT with a month dropdown to pull category totals from whichever monthly tab you pick, plus the trade-offs of a volatile function and a table alternative.

Read article
Editorial illustration for Inflation-adjusted future cost sheet: what a price may become
Spreadsheets 4 min read

Inflation-adjusted future cost sheet: what a price may become

Project a future cost with inflation in Excel using FV or a power formula, shown for a college fee as a what-if across a range of rates.

Read article
Editorial illustration for Insurance premium tracker sheet with renewal dates and policies
Spreadsheets 4 min read

Insurance premium tracker sheet with renewal dates and policies

Set up an insurance premium tracker in Excel or Google Sheets: one row per policy, due-date alerts, an annualised premium total and a link to each document.

Read article
Editorial illustration for Interior designer project ledger: client advances and vendors
Spreadsheets 4 min read

Interior designer project ledger: client advances and vendors

An Excel project ledger for interior designers: client instalments in, vendor and carpenter payments out, project-wise cash position and a margin check.

Read article
Editorial illustration for Find invoices paid in the bank but missing from your ledger
Spreadsheets 3 min read

Find invoices paid in the bank but missing from your ledger

List bank debits that match an invoice number or amount but have no ledger entry, rank them by amount, and see what to do with each payment in the books.

Read article
Editorial illustration for IPMT and PPMT: split any EMI into interest and principal in Excel
Spreadsheets 4 min read

IPMT and PPMT: split any EMI into interest and principal in Excel

Use IPMT and PPMT in Excel to split any EMI into interest and principal for a chosen month, and add up the interest paid in the first twelve instalments.

Read article
Editorial illustration for Is Google Sheets enough for a family budget? A practical test
Spreadsheets 4 min read

Is Google Sheets enough for a family budget? A practical test

A practical four-question test to see whether Google Sheets is enough for your family budget, with a simple score and the point at which an app pays back.

Read article
Editorial illustration for Is it safe to upload a bank statement PDF to an online converter?
Spreadsheets 4 min read

Is it safe to upload a bank statement PDF to an online converter?

Is it safe to upload a bank statement PDF to a free online converter? A checklist of what the file reveals, what to check and safer offline options.

Read article