ElliboHelp Centre

Bring your data from other software

Moving to Ellibo? Bring in your accounts and opening balances, customers, suppliers, items and every unpaid invoice and bill - and undo any import with one click.

Go to Accounting › Bring your data. The steps are in the order to follow. Each one shows every row's result before anything is saved, and every import can be undone.

Before you start, set your books start date (Settings › Books). It is the day your opening balances are on. Usually it is the first day of your financial year, or of the month you move.

1. Customers and suppliers

Import them from Excel or CSV with their contact details, tax numbers and opening balances. Files exported from most accounting and billing software work: columns are matched by their heading.

If you'll bring in unpaid invoices and bills (step 4), leave the opening balances out. The unpaid documents make up those balances, one by one.

2. Items

Your products and services, with prices, tax rates and opening stock.

3. Accounts and opening balances

Export a trial balance on your books start date from your old software. Click Template to see the columns, then Choose Excel / CSV.

  • An account that is already in your books (same name or code) gets the balance. Others are added under the type in the file (Bank, Cash, Fixed asset, Loan, Equity, Income, Expense and so on).
  • Receivables, payables and stock are left out. They come from your customers and suppliers, unpaid invoices and bills, and items, so they are not counted twice.
  • The trial balance must balance: debits = credits. If it doesn't, nothing is saved until the file is fixed.
  • Moving in the middle of the year? Income and expense balances come in as this year's figures so far.

4. Unpaid invoices and bills

One row per invoice or bill that is still open on your books start date: its number, date, due date, customer or supplier, and what is still owed. Customers and suppliers who are not in your books yet are added.

Only the amount owed comes in. The sale or purchase itself, and its tax, stay in your old books, so these documents are left out of your tax returns. You can then:

  • see ageing and send reminders from day one
  • record payments against each document as they come in
  • show customers what they owe on the customer portal

These documents can't be edited. To correct one, cancel it, or undo the import and bring it in again.

Where you stand

At the top, Opening balance difference shows what is still missing from your opening balances. It reaches zero when all the steps are done and your figures agree with the old books.

Undo an import

Under Your imports, click Undo next to the import. Everything it brought in is removed, and opening balances it changed are put back.

An import can't be undone once something has been built on it, for example a payment recorded against one of its invoices. You are told what is in the way.

Still need help?Write to us and we'll walk you through it.
Contact support