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

Take your time. Find what helps.
Editorial illustration for Unexplained difference in a reconciliation: how to narrow it down
Spreadsheets 3 min read

Unexplained difference in a reconciliation: how to narrow it down

A step-by-step method to narrow down an unexplained difference in a reconciliation by month, week and day, then test for transpositions, halves and duplicates.

Read article
Editorial illustration for Net monthly spend with SUMIFS from separate debit and credit columns
Spreadsheets 3 min read

Net monthly spend with SUMIFS from separate debit and credit columns

Net monthly spend from debit and credit columns using two SUMIFS with start and end dates, plus a 12-row example that ties back to the statement.

Read article
Editorial illustration for Net worth tracker in Excel: assets, liabilities, monthly snapshots
Spreadsheets 4 min read

Net worth tracker in Excel: assets, liabilities, monthly snapshots

Build a net worth tracker in Excel with assets and liabilities by month, a net-worth row and a line chart, plus how to value a house or gold carefully.

Read article
Editorial illustration for Next due date for recurring bills with EDATE in a sheet
Spreadsheets 3 min read

Next due date for recurring bills with EDATE in a sheet

Calculate the next due date for monthly, quarterly or yearly bills with EDATE, roll it forward after each payment and flag what is due within seven days.

Read article
Editorial illustration for No-cost EMI vs cash discount: a sheet to find the cheaper option
Spreadsheets 4 min read

No-cost EMI vs cash discount: a sheet to find the cheaper option

Compare a no-cost EMI with a cash discount in Excel using the RATE function to reveal the interest hidden in the offer, plus a simple decision cell.

Read article
Editorial illustration for NPER formula: how many months to clear a loan at a fixed payment
Spreadsheets 3 min read

NPER formula: how many months to clear a loan at a fixed payment

Use the NPER formula in Excel to find how many months a loan or credit card balance takes to clear at a fixed payment, and compare total interest for two payments.

Read article
Editorial illustration for Numbers stored as text in a statement: convert a column at once
Spreadsheets 4 min read

Numbers stored as text in a statement: convert a column at once

Convert text to number in Excel for a whole statement column at once: error-check menu, Text to Columns, Paste Special and VALUE, plus a test to confirm.

Read article
Editorial illustration for Petty cash register format in Excel for a small office
Spreadsheets 3 min read

Petty cash register format in Excel for a small office

A petty cash register format in Excel for a small office: voucher number, payee, purpose, amount, approver, running balance, top-ups and a closing cash check.

Read article
Editorial illustration for One master transaction table or one workbook per year?
Spreadsheets 3 min read

One master transaction table or one workbook per year?

One master transaction table or a workbook per year? Compare speed, year-on-year views and archiving, then see a simple structure for personal finances.

Read article
Editorial illustration for One-page spending dashboard layout in Excel
Spreadsheets 4 min read

One-page spending dashboard layout in Excel

A one-page Excel spending dashboard layout: what belongs on it, a column grid that fits most screens, and a separate calculation sheet behind it.

Read article
Editorial illustration for Match one payment to several invoices in a sheet
Spreadsheets 3 min read

Match one payment to several invoices in a sheet

Match one lump-sum payment to several invoices in a sheet with an allocation table, a remaining-balance column and a check that allocations equal the bank amount.

Read article
Editorial illustration for Open a password-protected statement PDF so you can convert it
Spreadsheets 4 min read

Open a password-protected statement PDF so you can convert it

Open a password-protected statement PDF you already have the password for, save an unprotected working copy, convert it, then delete the copy.

Read article