How to import item receipts into QuickBooks

You can import item receipts into QuickBooks from text files or Excel spreadsheets using Zed Axis:

  1. Download and install the Zed Axis software on your computer
  2. Open your QuickBooks company file as Administrator and open Zed Axis
  3. Select your text file or spreadsheet which contains the item receipts that you want to import.
  4. Set up the a Mapping of the columns in your item receipts import file to the corresponding fields in QuickBooks, as shown below
  5. Click Import and your item receipts will be directly added to your QuickBooks company file.

item receipt import

QuickBooks field  Type  Description 
 Vendor  Str 41  Name of the vendor supplying the goods or services
 APAccount  Str 159  Refers to an Accounts Payable account in QuickBooks
 TxnDate  Date  Date that the transaction occurred
 RefNumber  Str 20  Transaction reference number
 Memo  Str 4095  Additional information
 IsTaxIncluded  true or false  Whether amounts include tax or not (CA, UK, AU only)
 SalesTaxCode  Str 3  Sales tax code
 ExchangeRate  Float Exchange rate in exchange for the home currency 
 LinkToTxnID ID  Refers to the TxnID of the Purchase order that the Item Receipt is linked to.
SalesRep FullName Str Name of the Sales Rep as appears in the QuickBooks Sales Rep list
DataExtName1 Str Name of the Custom field 1 read more
DataExtValue1 Str Value for the Custom field 1
DataExtName2 Str Name of the Custom field 2
DataExtValue2 Str Value for the Custom field 2
 ItemFullName  Str  Full name of the item received
 ItemInventorySite  Str 31  Inventory site which the item is received at 
 ItemDesc  Str 4095  Description on the line
 ItemQuantity  Quant  Quantity of the item received
 ItemUOM  Str 31  Unit of measure more here
 ItemCost  Quant  Cost
 ItemAmount  Amt  Amount
 ItemCustomer  Str 209  Customer item line is associated to
 ItemClass  Str 159  Class item line is associated to
 ItemSalestaxCode  Str 3  Sales Tax for the item line
 ItemBillableStatus  enum  Billable Status for the expense line (possible values are Billable, NotBillable, HasBeenBilled)
Serial Number  Str 4095 The serial number or numbers for the item
Lot Number  Str 40 The lot number for the item



Add Feedback
How do you receive against an existing PO?
Lauren de Sylva (May 26 at 11:55 PM)

Add Feedback