Skip to main content
Pay less than Zoho Books, with Sri Lankan tax built in. Growth is LKR 3,390 a month.See pricing →

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.

Last reviewed:

How do I move from Excel to rupibooks?

  1. 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.
  2. Step 2: Export from Excel. The AI reads Excel, CSV and PDF files in any layout. There's nothing to reformat first.
  3. 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.
  4. 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.
  5. 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.

DepthWhat you provideTimeResult
MinimumA 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 minutesCorrect opening balances. You can invoice and reconcile from the next day
StandardEverything in Minimum, plus your chart of accounts, contacts, items and opening stock, open invoices and bills in detail, fixed-asset register and tax registrationsSame dayEverything you need day to day, with your original document numbers
Full historyEverything in Standard, plus every transaction for as many past years as you want, with attachments where the source allows1–3 days, or the guided migration add-onReports 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.