Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

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.

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, see more on linking transactions 
 ExpenseAccount  Str 159  Expense Account for the line
 ExpenseAmount  Amt  Expense Line amout
 ExpenseMemo  Str 4095  Expense line memo
 ExpenseCustomer  Str 209  Customer expense line is associated to
 ExpenseClass  Sr 159  Class expense line is associated to
 ExpenseSalesTaxCode  Str 3  Sales Tax for the expense line
 ExpenseBillableStatus  enum  Billable Status for the expense line (possible values are Billable, Nonbillable, Billed)
 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
 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, Nonbillable, Billed)

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