Import Chart of Account lists into QuickBooks desktop

Overview of importing Accounts into QuickBooks Desktop

With Zed Axis you can import a Chart of Accounts list into QuickBooks desktop from text, Excel or IIF files. You can do this from directly inside QuickBooks but the advantages of using Zed Axis are:

You can modify existing accounts
You can update a wider range of fields

Steps to import Accounts into QuickBooks Desktop

To import follow these steps:

Open Zed Axis and connect to the QuickBooks company file that you want to import into
In the import module click Browse and open the Excel, Text or IIF file that you would like to import into QuickBooks Desktop
Next create a map between select the transaction type as Chart of Account and create a map between the fields in QuickBooks and the columns in your import file
Finally click the Import button and Axis will import the Chart of Account list directly into your QuickBooks desktop company file

More help?

Download a sample Chart of Account import template

Where the fields appear in QuickBooks desktop

Detailed description of the Chart of Account list fields

QuickBooks field	Format	Description
Name	Str 31	Mandatory. The Full Name of the chart of account, (ie including the parent). Ignore the alert message about the length of the field if you are importing the Full Name.
Is Active	Bool	Whether the account is enabled of not values true of false
Parent Full Name	Str	Full name of the Parent can contain colons (do not map if you have set the full name for the Name field)
Account Type	Enum	The type of QuickBooks account, values AccountsPayable, AccountsReceivable, Bank, CostOfGoodsSold, CreditCard, Equity, Expense, FixedAsset, Income, LongTermLiability, NonPosting, OtherAsset, OtherCurrentAsset, OtherCurrentLiability, OtherExpense, OtherIncome
Bank Number	Str 25	The bank account number or an identifying note about the account. If a BankNumber exists in a QuickBooks company file, it will only be returned to applications that have been granted permission to access sensitive data
Desc	Str 200	A description for the account
Open Balance	Amt	The value of this account as of the Open Balance Date
Sales Tax Code	Enum	Whether the Account is Taxable or Non-taxable (values NON or TAX)
Tax Line ID	Int	The Tax Line associated with this account
Currency Ref Full Name	Enum	The currency to be used for this account ie US Dollar, Canadian Dollar, Euro, British Pound Sterling, etc...

Need to import Custom fields on Accounts? More here

Article ID: 336, Created: 11/3/2020 at 5:06 AM, Modified: 6/25/2024 at 12:18 AM