Credit Card Charge Import
To be able to import credit card charges data, your company must have a credit card account. To learn how to create a credit card account for your company, see Creating Company Credit Card Accounts.
After you have added a credit card account, you can import credit card charges and refunds CSV data. For information about importing credit card refunds data, see Credit Card Refund Import.
Credit Card Charge Body and Sublist Fields
When you import a credit card charge, you specify several body values, plus at least one record in the template's sublist.
Body Fields
To prepare credit card charge CSV data for import, make sure that your CSV file includes the following fields. They are required for a successful CSV import.
|
Field |
Notes |
|---|---|
|
Vendor |
The vendor related to this credit card transaction. |
|
Date |
The date when the charge occurred. |
Your file must also include one of internal ID, external ID or transaction ID to be used as a unique identifier for the record. The external ID can be any value that has not been used as the External ID in previous CSV imports.
If you have multiple credit card accounts, you must map the Account field to specify the credit card account for which you are importing the credit card charge.
Sublist Fields
Use the Items, Expenses, and Accounting Books sublists to add or update item and expense information about a credit card charge record.
|
Sublist |
Notes |
Required Fields |
|---|---|---|
|
Expenses |
You must map at least one item and expense. If you have more than one credit card accounts, then you must map the Account field in the Expenses sublist, as well as all required fields for the sublist. |
Amount |
|
Items |
The Items sublist is keyed using either Item or Order Line. Use the items sublist to specify the item that was purchased from the vendor with this credit card charge. The Items sublist is not mapped automatically. You must map at least one item or expense. To learn more about other supported fields, see Entering Company Credit Card Charges. |
Item or Order Line |
|
Accounting Books |
The Accounting Books sublist is keyed by Secondary Book. The sublist is available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. |
Secondary Book and Exchange Rate |
Credit Card Charge CSV File Examples
The following examples show how you might structure a file for importing credit card charge data.
Single File Import
|
External ID |
Vendor |
Date |
Posting Date |
Credit Card Charge Items: Item |
Credit Card Charge Items: Tax Code |
Credit Card Charge Expenses: Account |
Credit Card Charge Expenses: Amount |
|---|---|---|---|---|---|---|---|
|
CC_CH001 |
Best Fixture, Inc. |
11/11/2015 |
11/15/2015 |
Accessories : Cable -SCSI |
CA_HST |
Office Supplies |
10.5 |
|
CC_CH002 |
Best Fixture, Inc. |
12/11/2015 |
12/15/2015 |
Accessories : Cable -USB 10 ft |
CA_HST |
Office Supplies |
15 |
|
CC_CH003 |
Best Fixture, Inc. |
12/11/2015 |
12/15/2015 |
Accessories : Cable -SCSI |
CA_HST |
Office Supplies |
12.5 |
|
CC_CH004 |
Best Fixture, Inc. |
1/11/2016 |
1/15/2016 |
Accessories : Cable -USB 10 ft |
CA_HST |
Office Supplies |
15 |
The following example shows how you might map your fields to the fields in the import assistant.
Multiple Files Import
The following example includes the Items sublist data imported in a separate CSV file.
Primary file:
|
External ID |
Vendor |
Date |
|---|---|---|
|
CC_CH001 |
Best Fixture, Inc. |
11/11/2015 |
|
CC_CH002 |
Best Fixture, Inc. |
12/11/2015 |
|
CC_CH003 |
Best Fixture, Inc. |
1/11/2016 |
Linked file — Items:
|
External ID |
Credit Card Charge Items: Item |
Credit Card Charge Items: Quantity |
Credit Card Charge Items: Tax Code |
Credit Card Charge Items: Location |
|---|---|---|---|---|
|
CC_CH001 |
Accessories : Cable -SCSI |
2 |
CA_HST |
Canada |
|
CC_CH002 |
Accessories : Cable -USB 10 ft |
4 |
CA_HST |
Canada |
|
CC_CH002 |
Accessories : Cable -SCSI |
3 |
CA_HST |
Canada |
|
CC_CH003 |
Accessories : Cable - USB 10 ft |
6 |
CA_HST |
Canada |
Linked file — Expenses:
|
External ID |
Credit Card Charge Expenses: Account |
Credit Card Charge Expenses: Amount |
|---|---|---|
|
CC_CH001 |
Office Supplies |
94.35 |
|
CC_CH002 |
Office Supplies |
83.75 |
|
CC_CH002 |
Office Supplies |
58 |
|
CC_CH003 |
Office Supplies |
93.5 |