Pillar
Systems
Good financial decisions fail without good systems to execute them. This hub is about the operating layer of personal finance: the spreadsheets, trackers, document organisation, automation, and review routines that turn intentions into consistent action — so your money runs on rails instead of willpower. It is for the person who knows what to do but keeps missing the follow-through: the bill paid late, the SIP that lapsed, the documents nobody can find in an emergency. The aim is a small, durable setup you will actually maintain — automated savings on payday, a clean folder and naming structure, a net-worth sheet you open four times a year, and a monthly money review — rather than ten apps and no process.
What this pillar teaches
- Building a personal finance operating system
- Net worth and portfolio trackers in Google Sheets
- Organising financial documents and going paperless
- Automating savings, bills and investments
- Monthly and annual review routines
- Rebalancing and keeping your plan on track
Start here — beginner path
How to work through Systems
- Put everything in one place — List every account, policy, loan and login, and keep the documents in a folder structure or DigiLocker you can search in a minute. Documents to organise →
- Automate the routine — Move savings on salary day, put bills and card payments on autopay, and run SIPs on fixed dates. Automating savings →
- Reconcile every month — Match bank statements with your tracker, so errors, missed payments and fraud show up within weeks rather than at year-end. Bank statement reconciliation →
- Make it work without you — Nominees, a will and a financial power of attorney let your family run the system if you can’t. Writing a will →
All Systems guides
Business Compliance Records: How to Organise Them Before Anyone Asks
A renewal file works only if every document in it can be found. How to organise registrations and licences: folders, one tracker and backups in two places.
Managing Aadhaar, PAN and KYC: Run It Like a Reconciliation
Our rice mill runs on matching one record against another. Keep Aadhaar, PAN and KYC details identical, handle re-KYC safely and avoid frozen accounts.
The Account Aggregator Framework: What Lenders See and You Control
Our mill reports to its bank every month and gives farmers input credit, so I see both sides. How AA consent works, what to approve and how to share safely.
Your Annual Financial Review, Run the Way a Business Closes Its Year
A yearly money review in one four-hour session: ten sections, from net worth and savings rate to insurance and tax, ending in three decisions for the year.
How to Automate Your Savings in India: Get the Sequence Right First
Give every debit a job and a date. How to automate SIPs, RDs and EMIs in India, put the debits in the right order and keep a cushion so nothing bounces.
Bank Statement Reconciliation: A Habit Our Mill Runs Weekly
For a personal account, monthly is enough: the six steps to reconcile a bank statement, the Indian transaction codes, and what to do about an unknown debit.
Personal Finance Apps in India, From Someone Who Builds Spreadsheets
I build this site's spreadsheet templates, so my bias is stated upfront. What finance apps in India do well, where they fall short, and when a sheet wins.
A Bill-Payment System So Nothing Slips, Run Like a Business's Payables
Every recurring bill on one list, with the cash ready before its date. What to autopay, what to keep manual, and how to catch a payment that silently fails.
Budget App vs Spreadsheet: A Spreadsheet Builder's Honest Answer
I build this site's spreadsheet templates, and I would still start a first-time tracker on an app. How to choose, India's app options and a starter sheet.
A Shared Money System for Couples: Yours, Mine and Ours, Numbers First
I build this site's money spreadsheets, and a couple's system starts with four numbers. Yours-mine-ours accounts, a fair split and a monthly money date.
DigiLocker and a Document Vault: The Two Layers I'd Set Up
DigiLocker for the IDs it can issue, a private vault for everything else, and a two-minute test of whether your family could find any document.
Digital Financial Declutter: Every Account Is a Reconciliation You Owe
Every account you keep is one more statement to reconcile. How to inventory, close and consolidate accounts, apps, folios, old EPF and scattered documents.
UPI vs Cards vs Wallets vs Net Banking: Float, Risk and Records
Float has a price and records have value. When to use UPI, cards, wallets or net banking in India, and why, weighed the way a business weighs its payments.
An Emergency Information Document, Written Like a Business Handover
In a family business, the next person needs a handover. The household version: what goes in an emergency document, what to leave out, and where to keep it.
Year-End Tax Checklist for March 31: Decide in April, Check in March
I would settle the tax regime in April with a calculator and use March only to check. The March 31 list: 80C, NPS, 80D, LTCG harvesting and advance tax.
Financial Accountability: A Review System Built Like Business Books
A monthly check, a quarterly look and an April deep-dive that keep your money on track, and the one part of the review nobody else can do for you.
How to Automate Your Financial Life in India, and Still Keep Watch
For autopay, the balance on the debit date matters more than salary on paper. How to automate savings, SIPs, EMIs and bills in India, and still keep watch.
Financial Calendar: Tax, EMI and Renewal Deadlines, Set Up Once a Year
One calendar for every tax date, EMI, SIP and renewal in India, set up in a single April session, with reminders timed to start the work, not announce it.
Organise Your Financial Documents the Way a Business Keeps Vouchers
What to keep and for how long, folders, file names, scans and who can reach them: a filing system for an Indian household's financial papers that holds up.
Financial Goals Framework: Price Each Goal, Match Money to Its Horizon
Price each goal in future rupees, date it, match the money to its horizon and decide what to fund first: a goals framework for Indian households.
Set Up Your Financial Goals in a Spreadsheet, and Keep It Honest
I build this site's spreadsheet templates. A goals sheet with one row per goal, an on-track test, inflation for long goals, and a saved column kept honest.
Financial Power of Attorney in India: A Family Business Owner's View
Who can sign when the usual signatory can't is a practical question in any family business. A financial PoA: general vs special, registration and scope.
Goal-Based Savings: Why I Treat a Pooled Balance Like a Credit Limit
Our mill's cash comes in seasons, so I watch what is already spoken for. Give each goal its own bucket, instrument and auto-debit, with a worked example.
Google Sheets Monthly Finance Tracker, From Someone Who Builds Them
I build this site's spreadsheet templates. A five-tab Google Sheets tracker on plain formulas, no macros, that takes about 30 minutes a month to keep current.
How to Consolidate Bank Accounts: Why I'd Keep Only What I Reconcile
How many bank accounts you actually need, which ones to keep, how to close the rest without a failed debit, and the traps in closing an old account.
How to Write a Will in India, and What a Family Business Adds
A family business adds questions a simple will never answers. What a valid will needs in India, witnesses, registration, and the mistakes that sink one.
Annual Insurance Review Checklist, Run Like a Bank Renewal
Insurance deserves the lead time a bank renewal gets. What to check each year in term, health, vehicle and home cover, and when to start the review.
Investment Portfolio Tracker in Google Sheets, Built Numbers First
I build this site's trackers and won't tell you what to buy. One Google Sheet for MFs, stocks, EPF, PPF and NPS: CAS imports, GOOGLEFINANCE, XIRR per goal.
Joint Accounts and Nominations: Three Records, One Story
Your joint mode, nominees and will should tell one story. How operating modes and nominations work in India, and how to check that the three agree.
Monthly Money Review: A 30-Minute Routine With a Business Owner's Rhythm
Thirty minutes once a month: confirm automation ran, catch the unexpected, reconcile spending and update net worth. A monthly money review, step by step.
Net Worth Milestones: Measure the Usable Number, Not the Paper One
Net worth milestones as multiples of expenses, investable versus total net worth, and how to track the number you could actually use, year after year.
Net Worth Tracker in Google Sheets: Build It Honest on Both Sides
I build this site's trackers, and I'd never let a credit limit onto the asset side. How to build a net worth tracker, source each number and read the trend.
Nominee vs Legal Heir in India: Who Collects and Who Keeps the Money
The person who collects your money and the person who owns it are often different. How nominees and legal heirs differ for bank, MF, shares, EPF, insurance.
Going Paperless With Your Finances in India: Could You Produce It?
Can you produce any financial document the day someone asks for it? DigiLocker, one folder system, file names, statement auto-delivery and a two-copy backup.
Personal Finance Operating System: What to Automate, What to Keep
Automate what runs itself, delegate the routine records, keep the decisions: a personal finance operating system for India, with its weekly-to-yearly cadence.
Protecting Yourself From Financial Fraud in India: Trust the Statement
The common scams in India, the habits that block them and how to report to 1930 in time, built on one check: is the money actually in your statement?
Portfolio Rebalancing: Write the Rule Before the Market Moves
A rebalancing rule written while you are calm is the only one you will follow. Calendar vs threshold, four tax-efficient methods, and where EPF and PPF fit.
Safe Storage of Financial Documents: What to Keep and Who Can Find It
In a family business, papers outlive the person who filed them. What to keep as originals, for how long, locker vs safe vs cloud, and a family access sheet.
Setting Up Autopay, NACH and e-Mandates: Cap Them Like a Credit Limit
Every mandate is a small limit you sanction to someone else, so size its cap with care. NACH, UPI e-mandates, card instructions, and how to cancel each.
Subscription and Renewal Tracker: A Payables Register for Your Home
At our mill, what we owe is tracked by due date. A home needs the same for subscriptions: one tracker for each recurring charge and renewal, and what to cut.
Tracking Multiple Bank Accounts: One Job Each and a Lean Spending Float
One job for each bank account, one dashboard, a lean spending float and a monthly check: a system for tracking the several accounts you keep on purpose.
UPI and Net Banking Safety: Settings, Limits and What Never to Hand Off
Your UPI PIN, OTPs and passwords belong on a short list nobody else ever gets. The settings, limits and habits that keep UPI and net banking safe in India.
Year-End Financial Housekeeping: Close the Year the Way a Business Does
A half-day household checklist for the end of the year: dormant accounts, unused subscriptions, nominees, the year's documents and your trackers.
Common mistakes in systems
- Collecting too many apps and no actual process to run them
- Downloading templates but never building a review rhythm around them
- No document naming or folder structure — so nothing is findable when it matters
- No backup or export habit, so one account lockout loses years of records
- Automating before the manual process is clear, which just automates the mess