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

Take your time. Find what helps.
Editorial illustration for CGST and SGST split formula in Excel for an intra-state invoice
Spreadsheets 3 min read

CGST and SGST split formula in Excel for an intra-state invoice

Split GST into CGST and SGST in Excel: total tax, half for CGST, the balance for SGST, and how to handle an odd paisa so the halves add to the total.

Read article
Editorial illustration for A chart that always shows the last 12 months
Spreadsheets 4 min read

A chart that always shows the last 12 months

Feed an Excel chart from a rolling 12-row summary block so the axis rolls forward by itself, with no series editing each month. Setup and fixes included.

Read article
Editorial illustration for Check a converted PDF statement against its closing balance
Spreadsheets 4 min read

Check a converted PDF statement against its closing balance

Verify a PDF to Excel conversion: prove opening balance plus credits minus debits equals the closing balance, then locate a missing or duplicated row.

Read article
Editorial illustration for Check your statement for missed or double EMI debits with a sheet
Spreadsheets 3 min read

Check your statement for missed or double EMI debits with a sheet

Check a bank statement for missed or double EMI debits: list expected dates and amounts, match them with COUNTIFS in a date window, and flag odd months.

Read article
Editorial illustration for Does each month closing balance match the next opening balance?
Spreadsheets 4 min read

Does each month closing balance match the next opening balance?

Check that each month closing balance equals the next month opening balance with a simple chain formula that highlights the first gap in your statements.

Read article
Editorial illustration for Paid/unpaid checkbox for bills in Google Sheets
Spreadsheets 4 min read

Paid/unpaid checkbox for bills in Google Sheets

Set up a paid/unpaid checkbox for bills in Google Sheets: tick to strike a row through, and use SUMIF on FALSE to see what is still to pay this month.

Read article
Editorial illustration for Chit fund contribution tracker sheet for members and organisers
Spreadsheets 4 min read

Chit fund contribution tracker sheet for members and organisers

A chit fund tracker sheet for members and organisers: month-wise instalment, dividend, net paid, the month you get the pot and total paid in versus received.

Read article
Editorial illustration for Remove extra spaces and line breaks from narrations: TRIM and CLEAN
Spreadsheets 4 min read

Remove extra spaces and line breaks from narrations: TRIM and CLEAN

Remove extra spaces and line breaks from narrations in Excel or Sheets with TRIM, CLEAN and SUBSTITUTE(CHAR(10)), and fix lookups that fail on spaces.

Read article
Editorial illustration for Clean an NEFT narration to just the beneficiary and reference
Spreadsheets 3 min read

Clean an NEFT narration to just the beneficiary and reference

Clean an NEFT narration in Excel down to the beneficiary and reference using SUBSTITUTE and MID, after finding the structure on your own statement.

Read article
Editorial illustration for Clean card swipe (POS) narrations: terminal codes, city and noise
Spreadsheets 4 min read

Clean card swipe (POS) narrations: terminal codes, city and noise

Clean card swipe (POS) narrations in Excel by stripping terminal codes, city names and asterisk prefixes with a small substitutions table.

Read article
Editorial illustration for Clean up a statement CSV on your phone with a spreadsheet app
Spreadsheets 3 min read

Clean up a statement CSV on your phone with a spreadsheet app

What you can realistically do with a bank statement CSV on a phone: open it, delete junk rows, fix the date column, share it, and when to wait for a laptop.

Read article
Editorial illustration for Clean UPI narrations into merchant names with formulas
Spreadsheets 3 min read

Clean UPI narrations into merchant names with formulas

Turn a UPI bank narration into a clean merchant name with MID, FIND, SUBSTITUTE or TEXTSPLIT, so your lookups and totals use one consistent key.

Read article