Migrating AccountEdge multi-currency to Business Lite

Hey RazzDazz,

You’ve mapped out your imports really clearly. AccountRight is the better match because it handles those CSV imports properly, while Business Pro would feel too tight for what you’re planning to do. You can check the inclusions for each product here to compare them side by side. If anything feels unclear with the products, you can reach out to our team through this link.

Cheers,

Doreen

Well, that's a fly in the ointment..

My standard workflow imports the following as CSVs from my online store once per quarter:

• Invoices
• Invoice payments
• Spend Money purchases

I also export a CSV with the stock-on-hand figures via the inventory report.  

Please tell me what product will support this.  Can I get away with business pro?

I'm starting to feel like spreadsheets are easier...

Thanks for your help, 

Razz

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

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

Thanks Gavin, I'll look into it!

Razz

Hi RazzDazz​ 

FGH Tables can convert multi currency back to single currency - get in touch with them if you want to continue to use your existing data.

Regards

Gavin

I’m not about to start monkeying with Windows so the fresh start sounds like the solution.

Is this something the migration team can help out with?

And - thanks for your reply!

Russ

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