Import credit card charges into QuickBooks

Overview of importing credit card charges

In QuickBooks Desktop a credit card charge transaction is used to record purchases of items or services using a company card. Using Zed Axis you can import credit card charges from text files or from Excel spreadsheets directly into QuickBooks Desktop.

Steps to import credit card charges

Follow these steps: 
  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 credit card charges will be directly added to your QuickBooks company file.

More help?

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


Where the fields appear in QuickBooks Desktop


Detailed description of the fields that you can import
 

QuickBooks fieldTypeDescription
Account Full NameStr 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
Is Tax IncludedBooleanCA, 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
Sales Rep FullNameStrName 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 NameStr 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 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
Serial NumberStr 4095The serial number used on the item
Lot NumberStr 40The lot number used on the item

 

Add Feedback