I want to start a brand new company file in Quickbooks, but I want to use the chart of accounts from an existing company. Is there a procedure to initialize a new company file with empty chart of accounts taken from an established Quickbooks company file?
The Export menu option allows you to export the Chart of Accounts from the existing company file.
Then, see the following for the import step:
From QB help:
"You can import lists of customers, vendors, accounts, or items into QuickBooks." [search for "About Importing Data"]
From "QuickBooks® 2010 The Official eGuide for Premier Edition Users"
"Using the Advanced Import Feature
"You can click the Advanced Import button to import the chart of accounts in addition to the customer, vendor, and items lists. This method gives you greater control of the import process and allows you to fill in more of the fields for a particular record than the preformatted option mentioned in the previous section. To use this feature, don?t open your Excel file first; instead, when the Import A File dialog opens, tell QuickBooks where to find your file.
"QuickBooks launches Excel and opens the file. Select the worksheet in your Excel file that has the list you want to import. The next step is to create a ?mapping? between your file and QuickBooks."
How do you import sub-accounts? Assume you have a Brokerage account named "Brokerage-A" and account number 101000. Would you duplicate the account number in the import file like the following:
101000 Brokerage-A 101000 Brokerage-A:Cash 101000 Brokerage-A:Investment Cost Basis 101000 Brokerage-A:Value Change Unsold InvestmentsThe intent is to end up with one parent account and three subaccounts under the parent account:
101000 Brokerage-A Cash Investment Cost Basis Value Change Unsold InvestmentsBeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.