File Format For Credit Card Transaction Submission
Expiry Date | Amount | Card Number | Cardholder’s Name | Company Name (Optional) |
mmyy | 0.00 | dddd dddd dddd dddd | Jimmy Breer | Interware.Net Inc. |
- Each line of the file should appear as follows as shown in the example.
- Each column is separated by tabs.
- An unlimited number of lines/transactions are allowed.
- The batch file must be in .txt format.
- The fifth column can be omitted
Example of the Batch File format: (tab delimited)
1209 10.00 4500 5400 2300 1200 John Doe Interware.Net Inc.
1115 15.00 5500 5400 4400 1265 Peter Jones ABC company
Notes about Excel
If the card information is stored in excel,
- Ensure the batch file is in the correct format:
- the first column contains the expiry month and year,
- the second column contains the amount to be charged (no negative amounts are allowed)
- the third column contains the credit card number (must be 15 or 16 digits long)
- the fourth column contains the card holder’s name
- the fifth column contains the card holder’s company. (optional column)
- Save the excel sheet to a new file of type *.txt, e.g. c:\cards.txt (Save as…, Text (Tab delimited) (*.txt)
Join the Discussion!