Switching guide
Switch from Excel and spreadsheets
If your books are in spreadsheets, you can start in rupibooks with about 10 typed balances and one total per customer and supplier. You'll be invoicing and reconciling the next day. Upload your sheets as they are. The AI reads them and asks about anything unclear.
How do I move from Excel to rupibooks?
- Step 1: Pick a conversion date, such as the start of a month or of your financial year. Everything before it stays in Excel. Everything after it happens in rupibooks.
- Step 2: Export from Excel. The AI reads Excel, CSV and PDF files in any layout. There's nothing to reformat first.
- Step 3: Upload the files to rupibooks. The AI recognises standard reports from any system and maps your old chart of accounts to the Sri Lankan template for your business type. It can keep your old codes and names. Anything it isn't sure about is listed for you to decide, so it never quietly guesses.
- Step 4: Check the conversion. rupibooks compares its trial balance at the conversion date with the trial balance from Excel, line by line. It does the same for aged receivables, aged payables and stock value. Any difference is shown with the lines behind it. Fix it, or post it to an "opening balance difference" account to clear later.
- Step 5: Go live. Every migration runs first in a test copy that you can wipe and re-import as often as you like. When the numbers agree, press "Go live". rupibooks saves the signed conversion report to the audit trail for your accountant and auditor.
What should I export from Excel?
- Your balances at the conversion date: bank, cash, receivables, payables, stock, loans and capital (about 10 lines is typical), typed in or uploaded
- A list of who owes you and whom you owe, with one total each
- Customer, supplier and item lists, in any layout
- Your last bank statement, so reconciliation can start straight away
How much history should I bring?
Each depth adds to the one before, so you can start with Minimum and go deeper later without redoing anything.
| Depth | What you provide | Time | Result |
|---|---|---|---|
| Minimum | A conversion date, a trial balance at that date (any file, PDF or photo, or about 10 typed balances), and who owes you and whom you owe (one total per contact is enough) | Under 30 minutes | Correct opening balances. You can invoice and reconcile from the next day |
| Standard | Everything in Minimum, plus your chart of accounts, contacts, items and opening stock, open invoices and bills in detail, fixed-asset register and tax registrations | Same day | Everything you need day to day, with your original document numbers |
| Full history | Everything in Standard, plus every transaction for as many past years as you want, with attachments where the source allows | 1–3 days, or the guided migration add-on | Reports that compare years, and old documents you can open inside rupibooks |
Is it safe to try?
- Test copy first. Nothing touches your live books until you press "Go live".
- Run both for a while. Keep using your old system for a month, then import just the new transactions before you switch it off.
- You control the mapping. Tax codes, currencies, payment terms and tracking categories are mapped the same way as accounts. rupibooks merges duplicate contacts and checks that TIN and VAT numbers are in the right format.
- History as an archive. You can import old transactions as read-only history. You can search them and they appear in reports that compare years, but they stay separate from your live books.
- For accounting firms. Move many clients at once using the same mapping.
If you'd rather we did it, the guided setup and data migration add-on is a one-off LKR 25,000, on any plan.
Frequently asked questions
My spreadsheet doesn't balance. Can I still start?
Yes. rupibooks shows any difference, and you can post it to an "opening balance difference" account to clear later with your accountant. A difference never holds up the move.
See how rupibooks fits your business
Start free in minutes, or get a demo instantly. It opens right away with sample books for a business like yours.