You can
import journal entries from text files and spreadsheets into QuickBooks using Zed Axis.
The following are the fields that you can import into QuickBooks
|
Column
|
Format (max)
|
Desc
|
|
Date
|
DATE
|
Date of the journal
|
|
RefNumber
|
String(11)
|
A string of characters that refers to this transaction and that can be arbitrarily changed by the QuickBooks user.
|
|
IsAdjustment
|
True of false
|
When a change is an "adjustment," the original information is retained, usually so an accountant can see the effects of the adjustment.
|
|
Memo
|
String (209)
|
Description for the journal line
|
|
Currency
|
|
The name and currency code values are internationally accepted values and thus are not editable
|
|
ExchangeRate
|
|
The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the "home" currency
|
|
CR
|
Amount (10)
|
Credit Amount (net)
|
|
DR
|
Amount (10)
|
Debit Amount (net)
|
|
Account
|
String (159)
|
The Account list is the company file’s list of accounts
|
|
Memo
|
String (209)
|
Description for the journal line
|
|
Customer
|
String (209)
|
Customer or vendor reference
|
|
Class
|
String (159)
|
Classes can be used to separate transactions into meaningful categories. Must match in QuickBooks
|
|
Item Sales Tax Code
|
String (31)
|
QB 2008/09 and up Australia & NZ only
|
|
BillableStatus
|
ENUMTYPE
|
The possible values are Billable, NotBillable, HasBeenBilled. Cannot be left blank
|
Troubleshooting issues:
- The journal must balance for an import to proceed, note that journals that included a tax code (QuickBooks Australia and New Zealand only) which calculate a tax net amounts might not appear to balance prior to import.
- Out of balance errors. You may receive this error from QuickBooks if after calculating gross amounts (including tax) the journal is out of balance. Please check your net amounts and if possible round your net amount calculations to 5 decimal places (QuickBooks will accept numbers in 8.5 (recent editions 10.5) format or 13 digits long.