MunshiTo digitize a paper khata book, pick one cut-off date, list every customer with their balance as of that day, enter or import those balances once, check that the app’s total matches your paper total, then run both books side by side for a week before you stop using the notebook. The checking step is what keeps you from losing a balance. You do not need to retype years of history; you only need today’s balances, accurate.
Before you start: what you are actually moving
A khata book holds two things: history (every old entry) and balances (who owes what today). For running the business, you only need the balances. History matters for disputes, and you can keep it in the paper book. So the job is small: carry each person’s balance across, once, correctly. Our guide moving your bahi khata to a mobile app covers the wider picture; this one is the step-by-step, with a check built in.
Step 1: pick a cut-off date
Choose a day when you can sit for an hour, perhaps a quiet evening or the end of the week. Draw a line in the paper book under that day’s last entry. All balances are “as of” this date. Entries after the line are written in the app. Do not move anything on the move day except balances, or you will get mixed up about what has been counted.
Step 2: list every balance
On a clean sheet, write each customer who owes you, and each supplier you owe, with their name, phone number if you have it, and balance. Then add the column and write the total at the bottom.
- Spell each name the way you will search for it later.
- If two customers share a name, add a detail such as the street or the work.
- Mark balances you are unsure about, and settle them with the customer before you move them, or write a note.
- Skip people with a zero balance unless they buy often.
This total is your safety net. Every later check is against it.
Step 3: enter or import the balances
There are two ways, depending on how many customers you have.
Typing them in. Under about thirty customers, add each person in Munshi, then record one opening entry for their balance. If they owe you, use You gave with the note “opening balance”. If you owe them, use You got. The note matters: it tells you later where the figure came from.
Importing a sheet. If you have more, type the list into a spreadsheet with a header row: name, phone, balance. Save it as .xlsx or CSV. In Munshi use the import button on the Accounts screen or the import option in Settings, choose the file, check the columns, and look at the preview. Munshi asks which business the customers should go to, shows a summary, and lets you undo the import. See how to import customers from Excel or CSV.
Step 4: check the total against the paper
This is the step that matters. Open the home screen and compare the total owed to you with the total you wrote on paper. They should match exactly.
- If they match, you are done with the moving.
- If the app is lower, a customer is missing or an amount was typed short. Go down the paper list and tick each name in the app.
- If the app is higher, a customer was added twice or an amount has an extra digit.
- If a balance’s direction is wrong, use Correct on that account or flip the entry so it reads the right way. See how to fix a wrong entry.
Do not go further until the two totals agree. It is far easier to find a mistake now than three weeks later.
Step 5: run both books for a week
For the next seven days, write every new entry in the app and also in the paper book. At the end of each day, compare a few customers’ balances in both. This week is when you find habit problems, such as forgetting to enter a payment, and when your staff learn the app. After a week with no differences, stop writing in the paper book. Keep it somewhere safe as an archive. Then turn on the safety features:
- Back up to your Google Drive in Settings.
- Lock the app with a PIN or fingerprint.
- Set up the Cash Book so the drawer is recorded too.
An example with real numbers
Rashid runs a small store with six credit customers. His paper total is Rs 18,400: Ali 3,500, Bano 2,000, Chaudhry 6,200, Dawood 1,500, Eman 4,000 and Farhan 1,200. He adds all six to Munshi with opening entries and notes “opening balance”. The home screen shows Rs 17,200. He is Rs 1,200 short, which is exactly Farhan. He had forgotten to add him. He adds Farhan, the total reads Rs 18,400, and the two books agree. A check that took a minute found an error that would otherwise have shown up as a quarrel months later.
Common mistakes to avoid
- Trying to retype all history. It takes days and adds errors. Move balances, archive the book.
- Skipping the total check. It is the only protection against a missed customer.
- Switching in the middle of a busy day. Pick a quiet time.
- Throwing the book away too soon. Keep it for at least a year.
- Forgetting backup. A digital khata without a backup is as fragile as a paper one.
What to do next
With the balances in, set a weekly day to look at who owes the most, and use reminders. For a complete first-day setup, read getting started with Munshi, and for wording of reminders, polite payment reminders. If your list was in Excel to begin with, Excel or a khata app explains what changes.
Ten minutes of preparation that save an hour
Before the move day, do a little tidying on paper. Cross out balances that are already settled. Mark any entry you cannot read. Write phone numbers beside names where you have them, because a phone number lets Munshi’s contact finder match people later and makes reminders easier. If you plan to import a sheet, build it now so move day is only checking, not typing.