Little things you can already do

Names that do the work

A slash makes a family. bank/idfc, bank/kotak. Now bank totals both, bank/idfc totals one. You never set up a category list — your typing did it.

Go as deep as you like. mom/union/fd counts three ways: under mom, under mom/union, and on its own. No setup, no limit.

Slashes work in tags too, not just From and To. marketing/instagram, marketing/print — and marketing adds them up.

Departments, teams, branches — for free. staff/salary, staff/wages, staff/bonus. The word staff is now every person you pay. You never designed a department; you just typed consistently.

One sheet, many lives. personal/…, shop/…, mom/…. The words are the walls. Watch one, or watch everything.

The dropdown remembers every name you've used. Start typing, pick from the list. That's the whole trick to keeping totals clean — never re-type a name from memory.

A name can be anything. A person, a bank, a shop, a machine, a project code like #PROJ-123. The sheet doesn't care what it is; it just counts it.

Changed your mind about a name? Ctrl+H. Find Acme, replace with Acme Pvt Ltd, every row at once. Split totals get merged, old habits get renamed, and nothing about what happened changes. (Select the columns first and tick "specific range" — then it can only touch what you picked. Do Log and Recurring both, or tomorrow's rows come back with the old name.)

That's what keeps it fresh. Reorganising your names is a two-minute job, not a project. So you can start rough today and tidy in December, and the whole history rewrites itself.

Fix a spelling and the totals heal. Swiggy and swiggy with a stray space were two strangers splitting one number. One replace, one number.

Words that count

A tag is a calculator you name. Put sharma-reception on the advance, the ingredients, the staff — and it adds itself up. Sign decides plus or minus.

Several words on one row. tiffins, packaging — both count it. Three calculators running at once, no extra work.

Anything can be a word. A client, a season (diwali-2026), a channel (instagram), a bet, one big order. If you'd judge it, name it.

A job that runs across months still reads whole. Advance in May, costs in June, balance in July — the word's total is the true number. Set the period to FY or All and the calendar stops lying to you.

Cash Flow already breaks up your money by the parent word, in and out, side by side. You'll see which family of spending is really the big one.

The sign, and the two ends

Minus left you, plus came to you. That's it. Green in, red out — the colour says it back.

You never tell the sheet which names are "you". Ravi gives you ₹5,000: ravi → cash, +5,000. You return it: cash → ravi, −5,000. Same names, opposite signs, both clear.

Moving your own money isn't income. Bank to cash — enter the pair, Mode: Self. Your total doesn't move and no report calls it earnings.

Starting balances have their own mode. Mode Opening Balance keeps day-one money out of your income reports while the balance still picks it up.

Mode gives you a second cut of everything — cash vs bank vs card vs UPI — without you tagging anything.

Description is free. Write anything, or nothing. It never affects a total, so it costs you nothing to be chatty.

Dates are a time machine

Type a future date, read the balance beside it. That's your money on that day if today's plans hold. Most of what "forecasting" means, already done.

Add a planned row to try out any future. A ₹2L machine in October, a client's ₹1L in August — the months ahead redraw instantly. Delete it and the future goes back. The sheet is the simulator.

Planned rows never touch your balance. Money isn't real until it lands, so hopes stay visible but never counted.

Two dates ride along. Planned on is when it was due, Date is when it happened. The gap is how the sheet learns who runs late — "Sharma runs about 12 days late."

The same tick does the linking too. Join two rows with a link and exactly one side carries the tick. A purchase paid in installments: the plan is ticked, the payments are real. One bill covering two jobs: the bill is real, the pieces are ticked. Whatever isn't a payment of its own gets the tick — so the money counts once, every time. Guide, sections 6 and 14.

Enter next year's rows today. Nothing stops you. Known school fees, a wedding in March, an insurance renewal — put them in once and stop carrying them in your head.

Backdate freely. Forgot a month? Type the rows with their real dates. The balance and every report reorder themselves.

A date can carry a time. 06-Aug 11:30 — and the balance beside it is your money at 11:30, not at the end of the day. For a shop, that's the morning float, the afternoon rush, the evening deposit, each in the right order.

Same-day rows stop guessing. Ten entries on one date sort themselves the way they actually happened, so the running balance is right at every single line — not just correct by closing time.

Ctrl+Shift+Alt+; stamps this exact moment. Date and time, one keystroke, as the sale happens. (Ctrl+; is just the date, Ctrl+Shift+; is just the time.)

Repeats — write once, run forever

One line covers a year. Rent, salaries, EMIs, subscriptions, the monthly retainer. Never type them twelve times.

Odd patterns are covered. Every 2 weeks, Third Friday, Last day, Day 1 and Day 15, every 4 months. Pick from dropdowns.

End is flexible. Blank = never. A number = that many times. A date = stop then.

Edit one month without breaking the rule. Date slipped, paid by cash instead — change that single row. Your edit is respected; the rule never overwrites it.

Every rule tells you its monthly bite. An ₹18,000 yearly insurance is ₹1,500 a month. Now anything can be compared with anything.

EMIs count themselves down. Paid, remaining, next date, and a bar filling up. No separate loan tracker.

Mark each rule Essential / Nice-to-have / Can drop. On a tight day the sheet already knows what to cut first — and how much comes back per month.

One number worth staring at: your repeats added up for the year. "₹14L is owed no matter what happens." People cancel subscriptions on that line alone.

Watchlist — the fastest thing in the sheet

Type any name, get its whole story. In, out, net, share, twelve-month trend. A client, an account, a tag, a project code.

Add a row to compare. Two clients, two months, two lines of work — side by side, no report to build.

Ready-made periods. This month · 90 days · FY · All · Custom. Blank means all time.

Ask a question, get an answer, delete the row. It's scratch paper. Nothing you type there can break anything.

Parent words work here. Type staff and every person you pay is in that one number.

Limits and goals

A limit is a ceiling, a goal is a floor. "Chai under ₹500 a week." "₹30L from events this year." Same small table.

Point them at anything — a name, a tag, an account. Not just spending categories.

Rolling windows, not just calendar months. "Last 30 days" keeps moving with you.

Colour is the alert. Green fills, amber at 80%, red over. Nothing pops up, nothing nags.

Break the same limit three times and it argues back — with a number from your own history. "₹871 is more realistic." A budget you always break is a wrong number, not a discipline problem.

Reading the numbers

The Chase List is the highest-paying screen in the sheet. Money you've already earned, not yet collected. Chasing it beats finding a new customer, every time.

It also learns your payers. Once there's history, it tells you how late each one usually runs — so you plan around them instead of hoping.

The monthly snapshot colours itself. A month sinking toward your cushion goes darker months before it arrives, while you can still do something.

Last year sits in the same table. This September against last September, no work.

Where the profit went, in three lines. Invested, loan, took home — the three things that eat cash without ever showing as a cost. This is the answer to "the year was profitable, so where's the money?"

Streams are ranked by share, not size. Big orders and small ones get judged fairly.

The report grades itself. Income sitting on no stream shows up as its own row, with the exact rows listed and a link to each. When it hits zero, it disappears.

Untick Planned and the chase closes itself. The due date stays behind so the sheet remembers how late it ran.

Paid in parts? Log what came, shrink the planned row to what's still due. The chase keeps tracking the rest. Or link each part to the planned row instead and the sheet keeps score for you — paid ₹2.5L, ₹1.5L left. Guide, section 14.

Free, because it's a spreadsheet

Every one of these is Google Sheets, not Hisaab. You already own them.

Entering and fixing

Ctrl+D repeats the row above. Most rows are near-copies of the last one.

It finishes your names for you. Start typing in a column and it suggests what you've typed before — Enter accepts, Escape refuses. Free protection against two spellings of one client.

Ctrl+Shift+V pastes plain. Copying from WhatsApp or a bank statement brings their colours and fonts with it. This strips all of that and keeps only what matters.

Drag the little blue square at a cell's corner to fill dates or repeat a name down twenty rows.

Ctrl+Z, and Ctrl+Shift+Z to put it back. Then version history behind both.

Getting around

Ctrl+F finds anything. A name, an amount, half a word in a description. Faster than any filter.

Ctrl+↓ jumps to the last row. The bottom of a 2,000-row Log, instantly.

Click a column heading to sort. Sort the Log by amount and the biggest spends of your life are at the top in one click.

Filter views slice without disturbing anyone. This month, one account, untagged rows — saved, reusable, invisible to whoever else is looking at the same file.

Select any set of amounts and read the corner. Bottom right shows the sum, live. Ctrl+click to pick scattered rows and it still adds them. A calculator you never open — and click it to switch to average, count, or highest.

Hide the columns you never use. Ref #, link — right-click, hide. Nothing is deleted, the sheet just gets quieter.

Group rows to fold them away. Old months collapse behind a little +. Your history stays; your screen doesn't.

Open the same file in two windows. Log on one screen, Dashboard on the other, both live. Type a row, watch the numbers move.

Working with people

Right-click a row → Comment. Stick the invoice number, a photo link, or "ask Ramesh about this" on the row itself.

Put @their-email in a comment and it becomes their job — they get the mail, they reply on the row, it ticks off when done. "@ramesh what was this ₹40,000?" Your questions stop living in WhatsApp.

Share it with your CA, read-only. They see everything, change nothing. No export, no email, no version confusion.

Get an email when anyone edits. Tools → Notification settings. Useful the day you let staff enter rows.

Keeping and carrying it

It's on your phone. Same file, Google Sheets app. Add a row standing at the shop.

It works with no network. Turn on offline in the app; type at the godown, type on a flight. It syncs when the signal comes back.

Download as PDF — the Dashboard, one page, for the bank or the CA.

Download as Excel or CSV for a hard backup that doesn't depend on Google.

Make a copy any time. That's a snapshot of your finances on that date, kept forever. Free year-end archive. A copy's automation isn't wired until you run Actions → Set up this copy — an archive doesn't need it.

Undo is forever. File → Version history → go back to any day. You cannot permanently break this file. Try things.

Making it yours

Add a tab for anything. Right-click at the bottom, new sheet, name it. Which nominee is on which account, policy numbers, the locker key, who to call when something goes wrong. Most families keep all that on one piece of paper and lose it; a business has ten times more of it and nowhere to put it. Now it lives next to the money it belongs to, in the one file you already open. Names, numbers and nominees, yes — passwords and OTPs, never, here or anywhere.

Your own formulas are welcome. Add a column, write a SUM, build the one view only you need. It's your file.

Add your own colour rules. Conditional formatting — "anything over ₹50,000 turns yellow." The sheet starts flagging what you care about.

Set your locale to India, once. File → Settings. Dates read 06/08 as 6 August and ₹ behaves. Two clicks that prevent a year of confusion.

Safety net

The bank check catches every kind of error at once. Type your real bank balance; the gap is the missing story — a bounced EMI, a forgotten sale, a typo.

A bounced payment takes two seconds. Re-tick Planned, move the date forward. It goes back to "coming" and the balance corrects itself.

Rough beats missing. One line — −40,000 · bank → misc · "catching up June" — and you're current again. No streaks, no guilt.

Words and tags are yours to change forever. What happened — date, amount, who to whom — keep that true. Everything on top of it can be reinterpreted any time.

None of this needed a new button. It fell out of four columns and a slash.