You do not have to retype the whole khata. Type one recent month from your handwritten hisab diary into a plain four-column sheet, see how it feels, and then decide whether to carry on in the sheet or move to an app. Old pages can stay on paper, or be photographed and kept as an archive.
Why try a single month first?
A full conversion of years of paper is a project most people abandon. One month takes an evening, shows how much time the habit costs, and tells you how many of your entries are cash, UPI or card. It also shows whether your own diary headings, such as sabzi, dudh, bijli, maid, make a workable category list.
How do I set up the four columns?
| Column | What goes in it | Example |
|---|---|---|
| Date | The day, typed as 12-11-2026 | 12-11-2026 |
| Item | Your own words from the diary | Sabzi from mandi |
| Amount | Number only, no rupee sign | 340 |
| Category | One word chosen from a short list | Groceries |
Type refunds or money received as a negative amount, or keep them out and make a separate small list. Do not merge two diary lines into one row; the sheet is more useful when each purchase is its own line.
- Open a new sheet and type the four headings in row 1.
- Start with the earliest date of last month and work forward, one diary line per row.
- Write your categories in a short list on the right, 8 to 12 words, and keep spelling the same each time.
- After the last entry, add the total with =SUM(C2:C200) and compare it with what you remember spending or with the bank statement.
- Add a summary: =SUMIFS($C$2:$C$200, $D$2:$D$200, "Groceries") for each category.
For example, a diary line that reads dudh 60, sabzi 120, auto 80 on 12 November becomes three rows: milk 60 (Groceries), sabzi 120 (Groceries) and auto 80 (Transport). It feels slow for the first ten lines and then speeds up, because your handwriting follows a pattern and so do your categories.
Is typing every entry worth the effort?
Be honest after the first month. If you enjoyed seeing the totals but found typing every day a chore, you are a candidate for an app. Anything paid through a bank account or card is already written in your statement, so retyping it by hand is duplicate work. The diary is really needed only for cash: the milk bill paid at the door, the vegetable seller, auto fares.
What if I move to an app?
SpendixAI takes bank and card statements as PDF, CSV or Excel files, shows you the rows to review before saving, and lets you pick the account first, so you can bring in several months of history in a few uploads rather than retyping them. Cash expenses can be added by hand, one at a time or several together. It does not connect to your bank or read your SMS messages, and sign-in is with Google. Your paper diary then becomes just the source for cash, not for everything.
What should I do with the old diary pages?
- Keep the physical diary somewhere dry, especially if it has bills pinned inside.
- Photograph key pages, such as the year of a big purchase or a loan repayment, and store the photos in a folder named by year.
- Do not type old years unless you need them for something, like checking a long-running expense.
- Write the date you switched on the diary's last page so the break is clear.
Your next step
Tonight, pick last month's pages and spend 45 minutes on the four columns. Tomorrow, decide: stay in the sheet, or import. Either choice is fine, as long as you keep entering cash the same day. The next time you open a sheet you will also have a ready category list to reuse.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

