Chart of accounts (ACCNT)
Import and export files can contain complete information about
your chart of accounts. The keyword for the chart of accounts is ACCNT.
Column
headings
The following table shows the column
headings for a chart of accounts. The NAME and ACCNTTYPE columns are required.
NAME |
(Required) The name of an
account in your chart of accounts. If the account is a subaccount,
the account's name includes the names of the parent accounts, beginning with
the highest level account. If you are creating an import file, use a colon
(:) to separate subaccount names. |
|
TIMESTAMP |
(Export files only) A
unique number that identifies the company file from which you exported the
chart of accounts. |
|
REFNUM |
(Export files only) A
unique number that identifies the account in the list. |
|
ACCNTTYPE |
(Required) The type of
account. If you are creating an import file, use one of the keywords below to
indicate the account type: |
|
|
AP |
Accounts payable |
|
AR |
Accounts receivable |
|
BANK |
Checking or savings |
|
CCARD |
Credit card account |
|
COGS |
Cost of goods sold |
|
EQUITY |
Capital/Equity |
|
EXEXP |
Other expense |
|
EXINC |
Other income |
|
EXP |
Expense |
|
FIXASSET |
Fixed asset |
|
INC |
Income |
|
LTLIAB |
Long term liability |
|
NONPOSTING |
Non-posting account |
|
OASSET |
Other asset |
|
OCASSET |
Other current asset |
|
OCLIAB |
Other current liability |
OBAMOUNT |
The opening balance of the
account. Leave the amount blank and import the account without an opening
balance. If the account must have an opening balance, use the TRNS keyword to
create an opening balance transaction for the account. |
|
DESC |
A brief description of the
account. |
|
SCD |
The tax line assigned to
the account. To specify the tax line, enter its number (tax line numbers come
from the file BUSTAX.SCD). If you don't know the correct number, leave this
field blank. You can always assign the tax line later, after you import the
chart of accounts into QuickBooks. |
|
ACCNUM |
The account number of the
account. |
|
EXTRA |
Identifies an account as
one of the special balance sheet accounts that QuickBooks automatically
creates when the need for the account arises. If you are creating an import
file, use one of these keywords to identify the account: |
|
|
OPENBAL |
Opening Balance Equity |
|
RETEARNINGS |
Retained Earnings |
|
SALESTAX |
Sales Tax Payable |
|
UNDEPOSIT |
Undeposited
Funds |