Importing vendor credits into QuickBooks

You can import vendor credits 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 vendor credits that you want to import.
  3. Set up the a Mapping of the columns in your vendor credit import file to the corresponding fields in QuickBooks
  4. Click Import and your vendor credits will be directly added to your QuickBooks company file:
Vendor Credit
 
 
QuickBooks field  Type  Description 
 VendorName  Str41  Name of vendor company, MANDATORY
 APAccount  Str159  Accounts payable file, if not mapped will default to AP Account
 TxnDate  Date  Date of the bill
 DueDate  Date  Date the bill is due for payment
 RefNumber  Str20  Reference number of the bill
 Terms  Str31  Vendors payment terms
 Memo  Str4095  Memo for the bill
 IsTaxIncluded  Bool  true or false - When tax is included in amounts (CA, UK and AU only)
 ExchangeRate  Float  Exchange rate to home currency
 Account  Str159  Expenses Account (from Chart of Account list), full name required
 ExpenseAmount  Amt  Amount for that line.
 ExpenseMemo  Str4095  Expense line memo
 CustomerName  Str209  CustomerJob name
 ClassName  Str159  Class name
 ExpenseSalesTaxCode  Str3  Sales Tax code for the Expense account line
 BillableStatus  Enum  Whether the line is Billable, NotBillable or HasBeenBilled
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  Item purchased on the bill, full name required
 Description  Str4095  Description for the Item purchased
 Quantity  Quan  Quantity of the item purchased
 UnitOfMeasure  Str31  Unit of measure for the item purchased
 Cost  Price  Cost of the item purchased
 ItemAmount  Amt  Line total of the item
 ItemCustomer  Str209  CusotmerJob
 ItemClass  Str159  Class of line item
 ItemSalesTaxCode  Str3  Item sales tax code, true or false - When tax is included in amounts (CA, UK and AU only)
 ItemBillableStatus  enum  Item billable status Billable, NotBillable or HasBeenBilled
Item SalesRep FullName Str Name of the Sales Rep as appears in the QuickBooks Sales Rep list
ItemDataExtName1 Str Name of the Custom field 1 read more
ItemDataExtValue1 Str Value for the Custom field 1
ItemDataExtName2 Str Name of the Custom field 2
ItemDataExtValue2 Str Value for the Custom field 2
 OverrideItemAccount  Str209  
SerialNumber Str Serial Number for the item being credited
LotNumber Str Lot Number for the item being credited

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

Add Feedback