Little things you can already do
A companion to the Guide. Nothing here needs switching on. It all comes from how the sheet is built. Skim it once, and you'll keep finding uses.
Names that do the work
A slash makes a group. bank/idfc, bank/kotak. Now bank totals both, and bank/idfc totals one. You never set up a list of categories. Your naming 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.
Departments, teams and branches, for free. staff/salary, staff/wages, staff/bonus. The word staff now totals everyone you pay. You never set up a department. You just named things the same way.
One sheet, many lives. personal/…, shop/…, mom/…. The first word keeps them apart. Look at one, or at everything.
The dropdown remembers every name you've used. Start typing and pick from the list. That's the whole trick to clean totals: never retype 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, and every row changes at once. Split totals join up, old names get updated, and nothing about what happened changes. (Select the columns first and tick "specific range", so it only touches what you picked. Do it in both Log and Recurring, or tomorrow's rows come back with the old name.)
So you can start rough. Renaming takes two minutes, not a project. Start with rough names today, tidy them in December, and your whole history updates.
Fix a spelling and the totals join up. Swiggy and swiggy (with a stray space) were two names splitting one number. One replace, and it's one number again.
Words that count
A tag totals every row that carries it. Put sharma-reception on the advance, the ingredients and the staff, and the sheet adds them up. The sign decides plus or minus.
Several words on one row. tiffins, packaging: the full amount counts in both. Two totals from one row, no extra work.
Anything can be a tag. A client, a season (diwali-2026), a channel (instagram), an experiment, one big order. If you'll want to judge it later, tag it.
A job that runs across months still adds up. Advance in May, costs in June, final payment in July. The tag's total is the real number. Set the period to FY or All so a single month doesn't mislead you.
Cash Flow shows who pays you and where it goes, side by side, with each one's share. You'll see where the money really goes.
The sign, and the two ends
Minus means it left you. Plus means it came to you. That's all. The colour matches: green in, red out.
You never tell the sheet which names are "you". Ravi gives you ₹5,000: ravi → cash, +5,000. You pay it back: cash → ravi, −5,000. Same names, opposite signs.
Moving your own money isn't income. Bank to cash is one row: the amount as a minus, From the account it left, To the one it reached, Purpose Self. No report counts it as earnings.
Starting balances have their own mode. Mode Opening Balance keeps day-one money out of your income reports. The balance still counts it.
Mode gives you a second view of everything: cash, bank, card or UPI, without tagging anything.
Description is free text. Write anything, or nothing. It never changes a total.
Dates let you see ahead
Type a future date and read the balance beside it. That's your money on that day if things go as planned. That's most of what "forecasting" means.
Add a planned row to try out a decision. A ₹2 L machine in October, a client's ₹1 L in August: the months ahead update straight away. Delete the row and everything goes back.
Planned rows never change your balance. Money isn't real until it arrives, so expected money is shown but not counted.
Two dates are kept. Planned on is when it was due. Date is when it happened. The gap is how the sheet learns who pays late. It shows as Avg Waiting Time on the Chase List.
The same tick handles linked rows. When two rows are linked, exactly one side is ticked. A purchase paid in instalments: the plan is ticked, the payments are real. One bill covering two jobs: the bill is real, the parts are ticked. Whatever isn't a payment on its own gets the tick, so the money is counted once. Guide, sections 6 and 14.
Enter next year's rows today. School fees you know are coming, 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 sort themselves out.
A date can include 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 and the evening deposit, each in the right order.
Rows on the same day stay in order. Ten entries on one date sort in the order they happened, so the running balance is right on every line, not just at the end of the day.
Ctrl+Shift+Alt+; enters the date and time right now, in one keystroke. (Ctrl+; is just the date. Ctrl+Shift+; is just the time.)
Recurring — write once, runs by itself
One row covers a year. Rent, salaries, EMIs, subscriptions, a monthly retainer. Never type them twelve times.
Unusual patterns are covered. Every 2 weeks, the third Friday, the last day, both Day 1 and Day 15, every 4 months. Pick from the dropdowns.
End is flexible. Blank means never. A number means that many times. A date means stop then.
Change one month without breaking the rule. Date moved, paid in cash instead? Change that one row. The rule never overwrites your edit.
Every rule shows its monthly bite. ₹18,000 a year of insurance is ₹1,500 a month. Now you can compare anything with anything.
EMIs count down by themselves. Paid, remaining, next date, and a bar filling up. No separate loan tracker.
Mark each rule Essential, Nice-to-have or Can drop. In a tight month you already know what to cut first, and how much a month it saves.
One number worth a look: Safety money on the Dashboard. With months to survive set to 12, it's a year of what goes out whether you work or not. Most people cancel something after seeing it.
Watchlist — the fastest thing in the sheet
Type any name and see its whole story. In, out, net, money life, and a trend line. 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, with no report to build.
Ready-made periods. This month or this year, the next or last 30 days, 90 days, 6 months or a year, and more. Or leave Period blank and set your own From and To dates.
Ask a question, get the answer, delete the row. Use it like scrap paper. Nothing you type there can break anything.
Group names work here. Type staff and everyone you pay is in one number.
Limits and goals
A limit is a ceiling. A goal is a floor. "Chai under ₹500 a week." "₹30 L from events this year." Both go in the 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" moves forward with you.
Colour is the alert. The bar fills green, and anything over the limit shows red. No pop-ups, no nagging.
Break the same limit three times and it suggests a better one, worked out from your own spending: "₹900 is more realistic." A budget you always break is the wrong number, not a lack of discipline.
Reading the numbers
The Chase List is the most valuable list in the sheet. It's money you've already earned but not collected. Collecting it is easier than finding a new customer.
It learns how your clients pay. Once there's history, it shows how late each one usually pays, so you can plan around it.
The monthly snapshot colours itself. A month that won't cover what it needs turns amber, then red, months before it arrives, while you can still act.
Last year is in the same table. This September next to last September, with no extra work.
Where the profit went, in three lines. Invested, Loan, Took home: the three things that take cash without being a cost. This answers "we made a profit, so where's the money?"
The report checks itself. Income that isn't tagged to any line of work shows up as its own figure, with the rows listed under Missing Counts. Tag them and it clears.
Untick Is Planned and the row leaves the Chase List. The due date is kept, so the sheet remembers how late it was.
Paid in parts? Add what came, and reduce the planned row to what's still due. The Chase List keeps tracking the rest. Or link each part to the planned row and the sheet keeps count for you: paid ₹2.5 L, ₹1.5 L left. Guide, section 14.
Free, because it's a spreadsheet
All of these are Google Sheets features, not Hisaab's. You already have them.
Entering and fixing
Ctrl+D copies the row above. Most rows are nearly the same as the last one.
It finishes names for you. Start typing in a column and it suggests what you've typed before. Enter accepts, Escape ignores it. That stops two spellings of one client.
Ctrl+Shift+V pastes plain text. Copying from WhatsApp or a bank statement brings their colours and fonts along. This keeps only the text.
Drag the small blue square at a cell's corner to fill dates or repeat a name down twenty rows.
Ctrl+Z undoes, Ctrl+Shift+Z redoes. And version history is behind both.
Getting around
Ctrl+F finds anything. A name, an amount, part of 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 your biggest payments are at the top.
Filter views let you slice without changing the view for others. This month, one account, untagged rows: saved, reusable, and only you see them.
Select some amounts and look at the bottom-right corner. It shows the sum. Ctrl+click to add scattered rows. Click it to switch to average, count or highest.
Hide the columns you never use. Ref Num, link: right-click, Hide. Nothing is deleted. The sheet just looks simpler.
Group rows to fold them away. Old months collapse behind a small +. The history stays; it's just out of the way.
Open the same file in two windows. Log on one screen, Dashboard on the other, both live. Type a row and watch the numbers change.
Working with people
Right-click a row → Comment. Add the invoice number, a photo link, or "ask Ramesh about this" to the row itself.
Put @their-email in a comment and it's assigned to them. They get an email, they reply on the row, and it's marked done when finished. "@ramesh what was this ₹40,000?" Your questions stop getting lost in WhatsApp.
Share it with your CA as view-only. They see everything and can't change anything. No exports, no emails, no confusion about versions.
Get an email when anyone edits. Tools → Notification settings. Useful once staff start entering rows.
Keeping it safe and taking it with you
It's on your phone. Same file, in the Google Sheets app. Add a row standing in the shop.
It works offline. Turn on offline mode in the app, and type at the godown or on a flight. It syncs when you're back online.
Download as PDF: the Dashboard on one page, for the bank or your CA.
Download as Excel or CSV for a backup that doesn't depend on Google.
Make a copy any time. It's a snapshot of your finances on that date, kept forever. A free year-end archive. A copy's automation doesn't run until you use Actions → Set up this copy, and an archive doesn't need it.
Undo goes back as far as you like. File → Version history → go back to any day. You can't permanently break this file, so try things.
Making it yours
Add a tab for anything. Right-click at the bottom, add a sheet, name it. Which nominee is on which account, policy numbers, where the locker key is, who to call when something goes wrong. Most families keep this on one piece of paper and lose it. A business has ten times more of it and nowhere to keep it. Now it sits next to the money it's about, in the file you already open. Names, numbers and nominees, yes. Passwords and OTPs, never, here or anywhere.
Add your own formulas. 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 highlighting what you care about.
Set your locale to India, once. File → Settings. Then 06/08 reads as 6 August and ₹ works properly. Two clicks that prevent a year of confusion.
Safety net
One check catches every kind of mistake. On Wealth, under Checks, type what you actually have. The gap is whatever's missing: a bounced EMI, a forgotten sale, a typo.
A bounced payment is quick to fix. Tick Is Planned again and move the date forward. It goes back to "coming", and the balance corrects itself.
Roughly right is better than missing. One row, −40,000 · bank → misc · "catching up June", and you're up to date. No streaks to keep.
Tags and words are yours to change any time. Keep what happened true: date, amount, who paid whom. Everything else can be changed whenever you like.
None of this needed a new button. It all comes from four columns and a slash.