Forum Discussion

stacey-watts's avatar
stacey-watts
Contributing Cover User
6 years ago

New chart of accounts

Hi,  Looking at create a whole now myob file- is there a way you can import a chart of accounts?  Can you also import any employee information like their cards and entitlement balances?   
  • Haydes's avatar
    Haydes
    6 years ago

    Hi stacey-watts 

     

    From your description, it sounds like there were some fields missing in the file that was needed, such as the "Inactive" field and the "Header" field. Going by this support note: Import and export fields these fields indicate whether the account is inactive or active and if the account is a header or detail.

     

    I'd suggest opening your import file in Excel and add the extra 2 fields in with the same names as what is listed there. Here's a support note that shows you how to open it in Excel: Opening an export file in Excel

     

    Assuming it's tab-delimited you should be able to just add extra Column names to the top and then add values in the right cells before saving and importing to update the accounts again.

     

    Quick hint: Just add H in the fields under the Header Column for accounts you want to designate as Header Accounts, and put N in the fields under the Inactive Column for accounts you want to designate as Active. You can leave this as blank and it'll assume it's active, however by convention it's easier note what you want to be active and not active.

     

    If this continues to fail, I'd suggest posting your import file so that we can take a peek at it and see if anything sticks out to us.

amylee91's avatar
amylee91
MYOB Staff

Hey stacey-watts 

 

There certainly is,  in the current file- if you go to file - import / export assistant you will be able to export and import virtually everthing except payroll , i have attached a link Here, this will show you what you can export and which information comes across with each export.

 

(helps if you also need to edit anything)

 

Regards

Amylee

stacey-watts's avatar
stacey-watts
Contributing Cover User
6 years ago

Thanks guys very helpful! So I just tried importing my expense coa and all the accounts have come in as inactive and all my headers have disappeared? 

 

When importing I had Account number, account name, type and tax code selected.

 

Any idea why this could of happened? 

  • Haydes's avatar
    Haydes
    MYOB Product Team
    6 years ago

    Hi stacey-watts 

     

    From your description, it sounds like there were some fields missing in the file that was needed, such as the "Inactive" field and the "Header" field. Going by this support note: Import and export fields these fields indicate whether the account is inactive or active and if the account is a header or detail.

     

    I'd suggest opening your import file in Excel and add the extra 2 fields in with the same names as what is listed there. Here's a support note that shows you how to open it in Excel: Opening an export file in Excel

     

    Assuming it's tab-delimited you should be able to just add extra Column names to the top and then add values in the right cells before saving and importing to update the accounts again.

     

    Quick hint: Just add H in the fields under the Header Column for accounts you want to designate as Header Accounts, and put N in the fields under the Inactive Column for accounts you want to designate as Active. You can leave this as blank and it'll assume it's active, however by convention it's easier note what you want to be active and not active.

     

    If this continues to fail, I'd suggest posting your import file so that we can take a peek at it and see if anything sticks out to us.

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.