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 fieldTypeDescription
Account RefStr 159Credit Card company to whom the money is owed, as appears in QuickBooks Chart of Accounts
Payee EntityStr 209Refers to the vendor or company from whom the merchandise was purchased
Txn DateDateThe date of the charge
Ref NumberStr 11Reference number for this transaction
MemoStr 4095Additional information
IsTaxIncludedBooleanCA, UK and AU only - Whether amounts include tax, true or false
Exchange Rate Market price for which the currency can be exchanged for
Expense AccountStr 159Full name of the expense account that the charge is to be allocated to
Expense Amount A monetary amount
Expense Customer NameStr 209Full name of the Customer job that the charge is against
Expense ClassStr 159Class as a category
Expense Sales Tax CodeStr 3A sales tax code that indicates whether the item is taxable and why
Expense Billable StatusEnumThe billing status of this expense line, values accepted Billable, NotBillable, HasBeenBilled
SalesRep FullNameStrName of the Sales Rep as appears in the QuickBooks Sales Rep list
DataExtName1StrName of the Custom field 1 read more
DataExtValue1StrValue for the Custom field 1
DataExtName2StrName of the Custom field 2
DataExtValue2StrValue for the Custom field 2
ItemFullNameStr 209The item code that is being purchased
DescriptionStr 4095A description for the item
Unit of MeasureStr 31Name of the unit of measure
QuantityQuanHow many of the item are purchased
CostQuanCost of the item
Item Amount Amount of the item
Item Customer NameStr 209Full name of the Customer associated with the charge
Item Class NameStr 159Class as a category
Item Sales Tax CodeStr 3A sales tax code that indicates whether the item is taxable and why
Item Billable StatusEnumThe billing status of this item line, values accepted Billable, NotBillable, HasBeenBilled
Override Item Account  
Item SalesRep FullNameStrName of the Sales Rep as appears in the QuickBooks Sales Rep list
ItemDataExtName1StrName of the Custom field 1 read more
ItemDataExtValue1StrValue for the Custom field 1
ItemDataExtName2StrName of the Custom field 2
ItemDataExtValue2StrValue for the Custom field 2
Serial NumberStr 4095The serial number used on the item
Lot NumberStr 40The lot number used on the item

 

Add Feedback