Importing vendor credits into QuickBooks

Overview of importing vendor credits

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.  

Follow these steps to import vendor credits

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

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 NameStrName of the Sales Rep as appears in the QuickBooks Sales Rep list
Data Ext Name 1StrName of the Custom field 1 read more
Data Ext Value 1StrValue for the Custom field 1
Data Ext Name 2StrName of the Custom field 2
Data Ext Value 2StrValue 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 NameStrName of the Sales Rep as appears in the QuickBooks Sales Rep list
Item Data Ext Name 1StrName of the Custom field 1 read more
Item Data Ext Value 1StrValue for the Custom field 1
Item Data Ext Name 2StrName of the Custom field 2
Item Data Ext Value 2StrValue for the Custom field 2
 Override Item Account Str209 
Serial NumberStrSerial Number for the item being credited
Lot NumberStrLot Number for the item being credited

Add Feedback