Appendix > Appendix > QuickBooks® Import File Requirements > General Ledger
General Ledger
These are the master account and transaction history fields that are imported from QuickBooks® and the corresponding field names in Denali. Required fields are noted with an asterisk.
QuickBooks Master Export
Denali Field
Notes
*Accnt. #/Account
Number
50 character limit, uppercase, unique; if this field is not in the import, the value will come from the Account column; account numbers are made up of the header row and header subaccounts.
Account
Description
50 character limit
*Type
Class
Mapping for Type/Class is below
*Balance
Balance
Blank field will import as $0; imports into history
* Required Fields
 
You can only import history transactions if you previously imported all accounts in the master file (including inactive accounts). In QuickBooks, your Reports and Graphs Company Preferences must be set to Name only in the Reports - Show Accounts By section or you will not be able to import transaction history.
Transaction history is imported with a posting reference of “QBGL TranImport” and a batch of “_QBGL_.” Transaction history imports into the GL_PostedDetail table.
QuickBooks Transaction History Export
Denali Field
Notes
*Any account group
Account Number
Uses the mapping established during the master import; account numbers are made up of the header row and header subaccounts.
Date
Trans. Date
Date format
Item Description
Trans. Detail Description
120 characters
*Amount
Debit/Credit
Numeric; stored as a single value (curAmount) and split up on reports
Last modified by
User ID
6 characters
The following fields are only used if you’re importing Sales transaction history.
*Trans #
 
Numeric; used to match GL and Sales transactions
*Type
 
Text; no size limit; used to match GL and Sales transactions
*Num
 
Text; no size limit; used to match GL and Sales transactions
Name
 
6 characters, uppercase; populates the tax vendor on generated Tax Codes
Memo
 
120 characters; used in place of item description when generating missing sales lines
*Item
 
6 characters, uppercase; matches/creates Tax Codes and other sales lines
Sales Tax Code
 
Used when generating missing sales lines
*Qty
 
Numeric; used when generating missing sales lines
*Sales Price
 
Numeric followed by %; holds the tax percent on Sales Tax lines
* Required Fields
Below is a table mapping QuickBooks account types and Denali account classes.
QuickBooks Account Type
Denali Class
Non-Posting
Non ledger
Bank
Current Asset
Accounts Receivable
Current Asset
Other Current Asset
Current Asset
Other Asset
Asset
Fixed Asset
Fixed Asset
Accounts Payable
Current Liability
Credit Card
Current Liability
Other Current Liability
Current Liability
Long Term Liability
Long Term Liability
Equity
Equity
Income
Income (Operating Credit)
Other Income
Other Revenue/Gains (Income)
Cost of Goods Sold
Cost of Goods Sold (Expense)
Expense
Expense (Operating Debit)
Other Expense
Other Expense (Expense)
Published date: 12/03/2021