Credit Card Refund Import
To be able to import credit card refund 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 charges data, see Credit Card Charge Import.
Credit Card Refund Body and Sublist Fields
When you import a credit card refund, you specify several body values, plus at least one record in the template's sublist.
Body Fields
To prepare credit card refund 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 refund 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.
Sublist Fields
Use the Items, Expenses, and Accounting Books sublists to add or update item and expense information about a credit card refund record.
|
Sublist |
Notes |
Required Fields |
|---|---|---|
|
Expenses |
The Expenses sublist uses Line as a key. You must map at least one item or expense. |
Line and Amount |
|
Items |
The Items sublist is keyed using either Item or Order Line. Use the items sublist to specify the item that was returned to the vendor with this credit card refund. 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 Refund CSV File Examples
The following examples show how you might structure a file for importing credit card refund data.
Single File Import
|
External ID |
Vendor |
Date |
Posting Date |
Credit Card Refund Items: Item |
Credit Card Refund Items: Quantity |
Credit Card Refund Items: Tax Code |
Credit Card Refund Items: Location |
|---|---|---|---|---|---|---|---|
|
CC_CH001 |
Best Fixture, Inc. |
11/11/2015 |
11/15/2015 |
Accessories : Cable -SCSI |
4 |
CA_HST |
Canada |
|
CC_CH002 |
Best Fixture, Inc. |
12/11/2015 |
12/15/2015 |
Accessories : Cable -USB 10 ft |
2 |
CA_HST |
Canada |
|
CC_CH002 |
Best Fixture, Inc. |
12/11/2015 |
12/15/2015 |
Accessories : Cable -SCSI |
3 |
CA_HST |
Canada |
|
CC_CH003 |
Best Fixture, Inc. |
1/11/2016 |
1/15/2016 |
Accessories : Cable -USB 10 ft |
4 |
CA_HST |
Canada |
Multiple Files Import
The following example includes the Items sublist data imported in a separate CSV file.
Primary file:
|
External ID |
Vendor |
Date |
Posting Date |
|---|---|---|---|
|
CC_CH001 |
Best Fixture, Inc. |
11/11/2015 |
11/15/2015 |
|
CC_CH002 |
Best Fixture, Inc. |
12/11/2015 |
12/15/2015 |
|
CC_CH003 |
Best Fixture, Inc. |
1/11/2016 |
1/15/2016 |
Linked file — Items:
|
External ID |
Credit Card Refund Items: Item |
Credit Card Refund Items: Quantity |
Credit Card Refund Items: Tax Code |
Credit Card Refund Items: Location |
|---|---|---|---|---|
|
CC_CH001 |
Accessories : Cable -SCSI |
3 |
CA_HST |
Canada |
|
CC_CH002 |
Accessories : Cable -USB 10 ft |
4 |
CA_HST |
Canada |
|
CC_CH002 |
Accessories : Cable -SCSI |
2 |
CA_HST |
Canada |
|
CC_CH003 |
Accessories : Cable -USB 10 ft |
5 |
CA_HST |
Canada |
Linked file — Expenses:
|
External ID |
Credit Card Refund Expenses: Account |
Credit Card Refund Expenses: Amount |
|---|---|---|
|
CC_CH001 |
Office Supplies |
55 |
|
CC_CH002 |
Office Supplies |
83.75 |
|
CC_CH002 |
Office Supplies |
66.34 |
|
CC_CH003 |
Office Supplies |
46 |