Switch from Excel to Lekha
Fill in Lekha's Excel templates with what you already have. We import them, check every figure with you, and you go live on the first of a month.
Setup ৳15,000 one time + VAT, credited against your first year.
How the switch works
Send us your files
We send you Lekha's Excel templates. Fill them in from your spreadsheets and send them back.
We import and check
We import everything and check that it adds up to your trial balance, figure by figure.
You check
Your team ticks bank and cash against statements and goes through the open invoices, bills and document numbers.
Go live on the 1st
You start working in Lekha from the first of a month. Your old system stays as it was.
What comes across
- Your opening trial balance
- Unpaid invoices and bills, in their own currency at their original rate
- Advances clients paid that you haven't used yet
- Clients and vendors
- Staff, and the salaries paid so far this fiscal year
- The next number of each Mushak document series
What stays in Excel
- Past entries. Lekha starts from your balances
- Old invoices and bills: unpaid ones are settled in Lekha, but they stay the old system's documents. Lekha never reprints them or reports them for VAT.
What to prepare
- Your balances on the day before your go-live date: bank, cash, receivables, payables, VAT and tax
- Unpaid invoices and bills, one row each, in their own currency
- Advances clients have paid but you haven't invoiced yet
- If you go live after 1 July: income and expenses for each month since 1 July
- Staff list and salaries paid since July
- The last number used in each Mushak series
Questions about switching from Excel
- Do we have to retype our spreadsheets?
- Only into Lekha's templates, which have one column per field. Copying from your sheets usually works; anything that doesn't fit is marked in a copy of your file.
- Can we import a CSV?
- No. Lekha takes only its own Excel templates, so dates, leading zeros and Bangla names arrive exactly as you typed them. If you have a CSV, paste it into the template.
- What happens to our old spreadsheets?
- Keep them for your records. Lekha starts from your opening balances and doesn't need your past entries.
- When can we go live?
- On the first of any month. Most of the time goes into preparing your files; once we have them, we agree the date with you.
- Can we start in the middle of the fiscal year?
- Yes. You also send the income and expenses of each month since 1 July, when the fiscal year starts, and the salaries paid so far, so the year's reports and your staff's income tax stay complete.
- What if we find a mistake after going live?
- Before going live you can undo your latest import and import it again, or clear all opening data and start over. After going live, most mistakes are fixed with a journal in an open month. To correct the opening balances themselves, the owner reopens them with a reason, and your accountant approves if you have one.
Using Tally instead? Switch from Tally
Plan your switch from Excel
In a walkthrough we look at your spreadsheets together and plan the switch.