How to
Bring your running scheme accounts in from Excel
Moving from a paper book or another software? Save your scheme plans, download a sample Excel made from them, fill in each running account and open them all at once, with what is already paid brought forward.
A shop starting with RMK Billing often has hundreds of scheme members halfway through their plan. Typing each one with its old instalments takes days. Import them instead.
- 1Schemes → Import running accounts. First check your plans are saved: the sample file is made from them.
- 2Download sample file. It has a sheet with one made-up row per plan and a How to fill sheet.
- 3Fill one row per account: customer name and mobile, plan, start date, instalments paid, amount paid (blank = instalments × instalment), weight for weight plans, last paid date, nominee, and your book number if you want to keep it.
- 4Choose the file. The app checks every row and shows which are ready and what is wrong with the rest.
- 5Open the accounts. Customers are found by mobile number, or added.
What it checks
- The plan exists, the start date isn't in the future, and not more instalments are paid than are due.
- The instalment is not below the plan's minimum, and weight plans have the weight.
- No account number twice. Importing the same file again opens nothing new.
Tip: What was paid before is kept as Brought forward on the account and the passbook. It is not entered as receipts, so it doesn't show in today's money or go to Tally: that money was taken before the app.
