Skip to main content
Switching guide

Switch from Excel and spreadsheets

If your books live in spreadsheets, you can start in Ganana with about 10 typed balances and one total per customer and supplier, and be invoicing and reconciling the next day. Upload your existing sheets as they are; the AI reads them and asks about anything unclear.

Last reviewed:

How do I move from Excel to Ganana?

  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 Ganana.
  2. Step 2: Export from Excel. Excel, CSV and PDF files are read by the AI, whatever their layout. There is nothing to reformat first.
  3. Step 3: Upload the files to Ganana. 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 keeps your old codes and names if you prefer, and lists anything uncertain for you to decide; it never guesses silently.
  4. Step 4: Check the conversion. Ganana's trial balance at the conversion date is compared with the Excel trial balance line by line, and the same check runs 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 sandbox copy that you can wipe and re-import as often as you like. When the numbers agree, press "Go live". The signed conversion report is saved 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; ready to 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 dayA day-to-day working set 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-onComparative reports and drill-down to old documents inside Ganana

Is it safe to try?

  • Sandbox first. Nothing touches your live books until you press "Go live".
  • Parallel run. Keep using your old system for a month and import only the new transactions before you switch it off.
  • Mapping you control. Tax codes, currencies, payment terms and tracking categories are mapped the same way as accounts. Contacts are de-duplicated, and TIN and VAT numbers are checked for format.
  • History as an archive. Old transactions can be imported as read-only history: searchable and included in comparative reports, but kept separate from the live ledger.
  • For accounting firms. Migrate many clients in bulk 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. Any difference is shown, and you can post it to an "opening balance difference" account to clear later with your accountant, so the migration is never blocked.

Let the books do themselves.

Start on the Free plan. No card needed.