Forum Discussion

RazzDazz's avatar
RazzDazz
Contributing User
2 months ago
Solved

Migrating AccountEdge multi-currency to Business Lite

I have a small online store (it sells paper notebooks in the iPad age…) that has been using AccountEdge since around 2009.  I buy stock in Euros and have used the multi-currency feature for purchases...
  • Genreve_S's avatar
    Genreve_S
    2 months ago

    Hi RazzDazz, 

     

    Bit of a tricky one, because your AccountEdge file has used multi‑currency, our migration team can’t move that file into MYOB Business/Lite at all, even if it’s only a few Euro purchases. There’s no supported way to strip those out, so it’ll fail migration checks.

    Realistically, you’ve got two paths:

    • Keep multi‑currency → move to AccountRight Premier (Windows), which does support multi‑currency and lets you keep your history.
    • Go simple and cheap with Business Lite → start a brand new Lite file, bring in just your lists (accounts/customers/items) and AUD opening balances, and keep the old AccountEdge file just for looking up history.

    Regards,
    Genreve

RazzDazz's avatar
RazzDazz
Contributing User
2 months ago

OK, I have decided to start afresh - well, nearly.  

Plan is:

- create new vendor cards for all suppliers that currently use foreign currencies (only one, I think);

- migrate the master data and chart of accounts with balances from my AccountEdge backup taken at the end of last FY;

- reapply all transactions since then.  

Not as onerous as it sounds - I import two aggregated sales transactions from my online store once a quarter - one for bank transfer sales and one for Paypal sales. Most outbound payments are created when the bank statement is imported, and all shipping purchases are imported as Spend Money payments from a CSV generated by the online store software.

 

Please confirm or correct the list of data I need to transfer to the new empty system:

- Customer cards

- Supplier cards

- Chart of accounts with balances

- inventory with stock levels

- … Anything else?

And are there any dependencies? Such as should I import the chart before the inventory?

 

And finally, is there any point in importing this data into an AccountEdge file and sending it to MYOB’s transition group, or can I import it straight into Business Lite myself and get the same result?

 

I know its a big ask, but thanks for any help you can offer,

Razz

Genreve_S's avatar
Genreve_S
MYOB Moderator
2 months ago

Hi RazzDazz, 

 

Nice one, starting a fresh file will definitely keep things simpler.

Just a heads up, Business Lite can only import:

  • Chart of accounts
  • Customer contacts
  • Supplier contacts
  • Employees
  • Items
  • Timesheets

Anything outside of that (like invoices, bills, payments, etc.) would need to be re‑entered or handled via opening/historical balances.

Here’s a quick rundown of how to move things across:

  1. Export from AccountEdge
    • In AccountEdge, export each list you want (Accounts, Cards, Items, Employees, Timesheets) to a TXT/CSV file.
  2. Grab the MYOB Business templates
    • In MYOB Business Lite, go to:
      Settings → Import and export data → Import
    • Choose the type (Accounts, Contacts, Items, Employees, Timesheets) and download the sample/template file.
  3. Map your data into the template
    • Open your AccountEdge export and the template in Excel.
    • Copy your data into the matching columns (headings and order need to match what Lite expects).
    • Save it as a CSV.
  4. Import into Lite
    • Back in Lite, go to Import, pick the data type, and upload your CSV.
    • If any rows error, tweak those lines and re‑import.

 

Regards,

Genreve

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.