Importing checks into QuickBooks

You can import checks from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software.  Download and install the Zed Axis software on your computer

1. Open your QuickBooks company file as Administrator and open Zed Axis
2. Select your text file or spreadsheet which contains the checks that you want to import.
3. Set up the a Mapping of the columns in your check import file to the corresponding fields in QuickBooks
4. Click Import and your checks will be directly added to your QuickBooks company file.

Download a sample check import file

QuickBooks Field	Type	Description
AccountFullName	Str159	refers to the account from which the funds are being drawn for this check, for example, Checking or Savings
PayeeEntity	Str 209	refers to the person or company to whom the check is written
RefNumber	Str 11	refers to this transaction and that can be arbitrarily changed by the QuickBooks user
TxnDate	Date	The date written on the check
Memo	Str 4095	The memo that is printed on the check itself
Address		Address block
IsToBePrinted	Bool (true or false)	If IsToBePrinted is true, this transaction is on a list of forms to be printed later
IsTaxIncluded	Bool (true or false)	If IsTaxIncluded is true, this transaction includes Tax (CA, UK, AU only)
ExchangeRate	float	the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the "home" currency
Expense Account	str 159	you must include AccountRef if the “Require accounts” check box is selected in the QuickBooks Accounting preferences. (It is selected by default.) Typically this is an expense, asset or liability account.
Expense Amount	Amt	A monetary amount
Expense Memo	Str 4095	Additional information about this expense line.
Expense Customer Name	Str 209	If AccountRef refers to an A/P account, CustomerRef must refer to a vendor (not to a customer). If AccountRef refers to any other type of account, the CustomerRef must refer to a customer
Expense Class	Str 159	Classes can be used to separate transactions into meaningful categories.
Expense Sales Tax Code	Str 3	Tax code (CA, UK AU only)
Expense Billable Status	Values: Billable, NotBillable, HasBeenBilled	The billing status of this expense line. No default value
Item Full Name	Str 209	An ItemLine is used to track any portion of a transaction that represents the purchase of an "item."   ItemRef can refer to an item on any Item list
Description	Str 4095	Descriptin of the item
Unit of Measure	Str 31	Unit of measure for that item
Cost		If both Quantity and Amount are specified, QuickBooks will use them to calculate Cost. Likewise, if both Quantity and Cost are specified, QuickBooks will use them to calculate the total Amount
ItemAmount	Amt
Item Customer Name	Str 209	Refer to a Customer or job
Item Class		Classes can be used to separate transactions into meaningful categories.
Item Sales Tax Code	Str 3	Tax code (CA, UK AU only)
Item Billable Status	Values: Billable, NotBillable, HasBeenBilled	The billing status of this expense line. No default value

For more information about importing checks into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support

 

Article ID: 100, Created On: 10/21/2011, Modified: 10/21/2011