New chart of accounts
- 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.