Import credit card charges into QuickBooks

You can import credit card charges from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. 
  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 credit card charges that you want to import.
  4. Set up the a Mapping of the columns in your import file to the corresponding fields in QuickBooks.
  5. Click Import and your data will be directly added to your QuickBooks company file.

For more information about importing credit card charges into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support. The following fields are the principal fields when importing credit card charges into QuickBooks.


Sample credit card charge import file Credit Card Charge.txt
 

QuickBooks field Type Description
Account Ref Str 159 Credit Card company to whom the money is owed, as appears in QuickBooks Chart of Accounts
Payee Entity Str 209 Refers to the vendor or company from whom the merchandise was purchased
Txn Date Date The date of the charge
Ref Number Str 11 Reference number for this transaction
Memo Str 4095 Additional information
IsTaxIncluded Boolean CA, UK and AU only - Whether amounts include tax, true or false
Exchange Rate   Market price for which the currency can be exchanged for
Expense Account Str 159 Full name of the expense account that the charge is to be allocated to
Expense Amount   A monetary amount
Expense Customer Name Str 209 Full name of the Customer job that the charge is against
Expense Class Str 159 Class as a category
Expense Sales Tax Code Str 3 A sales tax code that indicates whether the item is taxable and why
Expense Billable Status Enum The billing status of this expense line, values accepted Billable, NotBillable, 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 209 The item code that is being purchased
Description Str 4095 A description for the item
Unit of Measure Str 31 Name of the unit of measure
Quantity Quan How many of the item are purchased
Cost Quan Cost of the item
Item Amount   Amount of the item
Item Customer Name Str 209 Full name of the Customer associated with the charge
Item Class Name Str 159 Class as a category
Item Sales Tax Code Str 3 A sales tax code that indicates whether the item is taxable and why
Item Billable Status Enum The billing status of this item line, values accepted Billable, NotBillable, HasBeenBilled
Override Item Account    
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
Serial Number Str 4095 The serial number used on the item
Lot Number Str 40 The lot number used on the item

 

Add Feedback