Import credit card charges into QuickBooks

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.

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

Demonstration of importing credit card charges

Where the fields appear in QuickBooks Desktop

Detailed description of the fields that you can import
 

QuickBooks field	Type	Description
Account Full Name	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
Is Tax Included	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
Sales Rep FullName	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 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 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
Serial Number	Str 4095	The serial number used on the item
Lot Number	Str 40	The lot number used on the item