For a one-person business with a few dozen entries a month, a cash book spreadsheet is usually enough. It becomes risky when you issue many invoices, hold stock, employ staff or must reconcile several accounts. An expense app can help with the spending side, such as receipts and categories, but it is not accounting or invoicing software.
What does a cash book sheet look like?
| Column | Content |
|---|---|
| A | Date |
| B | Particulars, such as the supplier or customer |
| C | Payment mode: cash, UPI, bank, card |
| D | Money in (₹) |
| E | Money out (₹) |
| F | Running balance |
With the opening balance in F2, the balance on row 3 is =F2+D3-E3, copied down. A monthly total of spend by mode is =SUMIFS($E$2:$E$500,$C$2:$C$500,"UPI"). If you add GST columns, put the base amount, the rate you read off the bill and =base*rate for the GST amount. Which GST applies, and what you may do with it, is a question for your CA.
Where does a sheet work well?
- A handful of customers and suppliers, with entries you can check at a glance.
- One bank account and a petty cash drawer.
- You like seeing every formula, and your accountant is happy with a file.
- You do not need the sheet to cope with several people editing.
Where does an app help?
An app takes the repeated work: statements instead of typing, categories chosen from rules and history, receipts kept with the entry. SpendixAI, for example, keeps receipts with the transaction, estimates GST inside spending using a rate you set per category, and has an Export centre with templates for Tally, Zoho Books and QuickBooks, plus a standard all-transactions file. The GST figures are estimates to be checked against invoices and your CA. It is not invoicing or GST filing software and its Pro plan covers one personal workspace, so it does not replace accounting software or handle staff approvals.
Whichever you use, add a column for the bill number and, where the supplier gave one, their GST number. Those two details are what your accountant asks for most, and they are far easier to record on the day than to chase months later.
How does the sharing with an accountant differ?
| Need | Sheet | App |
|---|---|---|
| Send a month's entries | Share the file or email a copy | Export a file in a format they request |
| Show a payment's bill | Hunt through a folder | Open the receipt attached to the entry |
| See who changed what | Version history, if the sheet is shared | Depends on the tool |
| Tag payment mode | A column you fill | Account on each transaction |
A worked month in the cash book
Say the month opens with ₹25,000 in F2. Money in totals ₹62,000 and money out ₹41,500. The closing balance is 25,000 + 62,000 - 41,500 = ₹45,500, which should equal the last cell of column F and the sum =F2+SUM(D3:D200)-SUM(E3:E200). If the two disagree, a row was entered wrongly or a formula was overwritten. Compare the closing figure with your bank balance and cash in hand at month end; the difference is what to chase.
When does the sheet become risky?
These are my own warning signs, not rules. If two or more are true, speak to your CA about proper accounting software.
- You issue invoices regularly and need to match payments against them.
- You hold stock, so purchases and sales need tracking item by item.
- You have staff, with salary and statutory payments to manage.
- You are registered for GST and must reconcile your purchase bills.
- More than one person enters data into the sheet.
- You cannot explain last month's closing balance in a minute.
What to do this month
- Open a new tab and split last month's entries by payment mode.
- Photograph or save every bill and name the file with date and supplier.
- Ask your accountant what format they would like next quarter, and set the sheet or app up to produce it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

