|
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.
- Download and install the Zed Axis software on your computer
- Open your QuickBooks company file as Administrator and open Zed Axis
- Select your text file or spreadsheet which contains the credit card charges that you want to import.
- Set up the a Mapping of the columns in your import file to the corresponding fields in QuickBooks.
- 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
|
Field
|
Max
|
Description
|
|
Account Ref
|
159
|
bank or credit card company to whom money is owed as appears in QuickBooks
|
|
PayeeEntity
|
209
|
refers to the vendor or company from whom merchandise was purchased
|
|
TxnDate
|
|
The date of the charge
|
|
RefNumber
|
11
|
A string of characters that refers to this transaction
|
|
Memo
|
4095
|
Additional information
|
|
IsTaxIncluded
|
|
Whether the amounts include tax, either true or false
|
|
ExchangeRate
|
9
|
market price for which this currency can be exchanged for
|
|
ExpenseAccount
|
159
|
Expense account that the charge is to be allocated to
|
|
ExpenseAmount
|
|
A monetary amount
|
|
ExpenseCustomerName
|
209
|
Customer job
|
|
ExpenseClass
|
159
|
Classes can be used to separate transactions into meaningful categories
|
|
ExpenseSalesTaxCode
|
3
|
a sales-tax code that indicates whether the item is taxable or non-taxable, and why
|
|
ExpenseBillableStatus
|
|
The billing status of this expense line, values accepted Billable, NotBillable, HasBeenBilled
|
|
ItemFullName
|
|
The item code that is being purchased
|
|
Description
|
4095
|
A descriptive text field.
|
|
Unit of Measure
|
31
|
the name of the unit of measure selected from within the item's available units
|
|
Quantity
|
|
Quantity indicates how many of this item are beinig purchased
|
|
Cost
|
|
Cost of that item
|
|
ItemAmount
|
|
A monetary amount
|
|
ItemCustomerName
|
209
|
Customer job
|
|
ItemClassName
|
159
|
Classes can be used to separate transactions into meaningful categories
|
|
ItemSalesTaxCode
|
3
|
a sales-tax code that indicates whether the item is taxable or non-taxable, and why
|
|
ItemBillableStatus
|
|
The billing status of this expense line, values accepted Billable, NotBillable, HasBeenBilled
|
|
OverrideItemAccount
|
159
|
Refers to a QuickBooks account
|
|