I am trying to import new stock items and getting an error message 4012 Require an expense accou ...

Question

nt for tracking stock - I have this in the import file

I am trying to import new stock items and getting an error message 4012 Require an expense account for tracking stock - I have this in the import file

Genreve_S · Answer

Hi @BIRD_PLACE,

Thanks for sharing the screenshots.

From what I can see, the account codes do look to be filled in correctly in both the item card and the import sheet.

The next thing I’d check is the import file itself:

* Make sure you’re importing a tab-delimited TXT file, not the Excel workbook version
* Export one item directly from this same company file, then copy your new items into that exported file and import that as the template

Even when the account numbers look right, using a fresh export template from the file often fixes this type of 4012 import error. If those still don't work, reaching out to support would be the next best step.

Regards,
Genreve

BIRD_PLACE · Answer

Hi Genreve,

I have done the imports before without an issue.

I have attached a screen shot of an item with the various account codes.

I have attached a screen shot of the excel version of the import showing the various account codes.

Thanks for any assistance.

260722 Screen Shot Items.docx

260722 Screen Shot of Import Excel.docx

Genreve_S · Answer

Hi @BIRD_PLACE,

Thanks for sharing your import issue. This error usually means MYOB can’t find a valid Expense/COS account for the item you’re importing.

Please check the Expense/COS Acct column in your import file and ensure it contains an existing account from your Accounts List, entered exactly as it appears in MYOB. It also needs to be a P&L expense/COS account.

If you’re still stuck, I recommend reaching out to our support team through My Account or through live chat via MOCA, our virtual assistant. A good workaround is to create one item manually in MYOB, export it, then use that exported file as your import template.

Regards,
Genreve