We can import the credit card transaction using CSV import. Credit card transaction import doing in two ways credit card charge import and credit card refund import.
When we prepare credit card charge CSV data for import, make sure that our CSV file includes the following fields. They are required for a successful CSV import.
External ID
VENDOR
Account
Credit Card Transaction
Location
DATE
Item
Tax code
Expenses Account
Our file must also include one 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 we have multiple credit card accounts, we must map the Account field to specify the credit card account for which we are importing the credit card charge.
