Make room for
better money habits.
Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.
Find your next good read.
Small decisions. Clearer thinking. A useful place to start.
599 guides · Page 5 of 50
Take your time. Find what helps.
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
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
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
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
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
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
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
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
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
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
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
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