How to import a list of accounts to an existing chart of accounts
The company I am working on is a home flipping business. As such, it made sense to set up my cost collection accounts as type other current asset in case a sale was not made in the same year as the costs and they needed to be left on the balance sheet. As it turns out, the property in question was sold in the same year and this left me with an account structure set up as other current asset accounts that for tax purposes need to be classified as cost of good sold. SInce QB won't let me change the account type I need to set up new accounts of the appropriate type and do a reclassification entry. There are a lot of accounts so what I'd like to do is export the existing structure to an excel file, change the account type on each account, reimport the accounts with the desired account type, and then transfer the balance with a JE. All of the articles I've found in the community have to do with exporting from and old company and importing into a new company. What I need to do is export and import accounts into an existing company without overwriting the old accounts. Can this be done?
