Importing Inventory

Hi Islander,

Totally hear you, spending 2 hours going around in circles with support is a lot of time. Let’s get these errors to chill out:

Error -4012: You must specify an expense account for tracking costs.
Think of this as MYOB asking “where do these costs live?”
Fix: In your import file, add a real Expense or Cost of Sales detail account for that item (the same kind you’d choose under “I buy this item” in item setup). Save, then try the import again.

Warning 44: Invalid Account Number; account ignored.
This one pops up when MYOB doesn’t recognise the account.
Fix: Check that the account number actually exists in your chart of accounts, is active, and matches exactly (no extra spaces or typos). Tidy or remove that account number in the file, then re-import.

Warning 59: Expense account invalid; item may not be bought.
Here MYOB is saying “I can’t use that account for buying.”
Fix: Make sure the Expense Account for Buying is:

• an existing account in your chart
• an Expense or Cost of Sales detail account (not a header, asset, or liability)
• active

Update that account number in your file, then re-import.

Error -1015: The ItemName must be specified.
This just means MYOB wants a name/number for every item.
Fix: Give each row a unique Item Number/Name (no blanks), save, and re-import.

Once those pieces line up – real item names, valid accounts, and proper expense/COS links – your import should flow a lot smoother instead of throwing all that noise at you.

You can also check out this link about importing data for more info. And if you’re still running into issues after that, you can always submit a support case via My Account so the team can dig into your specific file with you.

Cheers,

Doreen