Forum Discussion

RazzDazz's avatar
RazzDazz
Contributing User
10 days ago

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...
RazzDazz's avatar
RazzDazz
Contributing User
5 days 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
3 days 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

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