Importing vendor credits into QuickBooks

In QuickBooks Desktop a vendor credit transaction is uses to track credits made for purchases of items or expenses from vendors. With Zed Axis software you can import vendor credits from text files or from Excel spreadsheets directly into QuickBooks.  

After downloading 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:

More help?

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

Where the fields appear on a vendor credit

What fields you can map on a vendor credit 

QuickBooks field	Type	Description
Vendor Name	Str 41	Name of vendor company, MANDATORY
AP Account	Str 159	Accounts payable file, if not mapped will default to AP Account
Txn Date	Date	Date of the bill
Due Date	Date	Date the bill is due for payment
Ref Number	Str 20	Reference number of the bill
Terms	Str 31	Vendors payment terms
Memo	Str 4095	Memo for the bill
Is Tax Included	Bool	true or false - When tax is included in amounts (CA, UK and AU only)
Exchange Rate	Float	Exchange rate to home currency
Account	Str159	Expenses Account (from Chart of Account list), full name required
Expense Amount	Amt	Amount for that line.
Expense Memo	Str4095	Expense line memo
Customer Name	Str209	CustomerJob name
Class Name	Str159	Class name
Expense Sales Tax Code	Str3	Sales Tax code for the Expense account line
Billable Status	Enum	Whether the line is Billable, NotBillable or HasBeenBilled
Sales Rep Full Name	Str	Name of the Sales Rep as appears in the QuickBooks Sales Rep list
Data Ext Name 1	Str	Name of the Custom field 1 read more
Data Ext Value 1	Str	Value for the Custom field 1
Data Ext Name 2	Str	Name of the Custom field 2
Data Ext Value 2	Str	Value for the Custom field 2
Item Full Name	Str	Item purchased on the bill, full name required
Description	Str4095	Description for the Item purchased
Quantity	Quan	Quantity of the item purchased
Unit Of Measure	Str31	Unit of measure for the item purchased
Cost	Price	Cost of the item purchased
Item Amount	Amt	Line total of the item
Item Customer	Str209	CusotmerJob
Item Class	Str159	Class of line item
Item Sales Tax Code	Str3	Item sales tax code, true or false - When tax is included in amounts (CA, UK and AU only)
Item Billable Status	enum	Item billable status Billable, NotBillable or HasBeenBilled
Item Sales Rep Full Name	Str	Name of the Sales Rep as appears in the QuickBooks Sales Rep list
Item Data Ext Name 1	Str	Name of the Custom field 1 read more
Item Data Ext Value 1	Str	Value for the Custom field 1
Item Data Ext Name 2	Str	Name of the Custom field 2
Item Data Ext Value 2	Str	Value for the Custom field 2
Override Item Account	Str209
Serial Number	Str	Serial Number for the item being credited
Lot Number	Str	Lot Number for the item being credited