Importing checks into QuickBooks

Axis
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.

Note: As in QuickBooks when importing a check it should either be associated to an Item purchased or an Expense Account or a combination of both.  You must also set the bank account from which the check is drawn.

 

QuickBooks Field  Type Description
AccountFullName Str159 Mandatory. Refers to the account from which the funds are being drawn for this check, for example, Checking or Savings. FullName is required
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.  Accounts should be specified as a full name format
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. Full name required
Description Str 4095  Descriptoin 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, full name
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
 Freight  Amt Freight amount on Check, see more on shopping cart fields
 Insurance  Amt  Insurance amount on Check, see more on shopping cart fields 
 Serial Number  Str 4095  The serial number for the item more
 Lot Number  Str 40 The lot number of the item more


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

 

Add Feedback