The View Batch History allows the user to see individual batches that have been processed. By clicking “Done” under Status, the user can see the individual transactions that occurred within the batch checking if each one was authorized. If the transaction failed, it will list an error with the reason why.
Batch Processor
Batch File Format
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)
Submit a Batch
Starting the Batch Run
- In the M-account, Go to Tools > Batch Processor > Submit a Batch
- Enter the following settings:
Batch Name Assign the batch a name, e.g. July 2008 Run Batch File Click on ‘Browse’ and select the .txt file containing the credit cards, e.g. c:\cards.txt Currency Type Select a currency GL Number Optionally assign a GL number. - Click on The batch pre-processor will look for any errors before running the batch. If some errors are detected, edit the c:\cards.txt file and fix all of the errors. If no errors are detected, the batch will begin to process. The process is actually occurring the in the background. If you like, you can go on to other work and return later to see the results of the batch.
- The following screen will appear
- click on the Refresh button to check the batch progress.
- When the Status is displayed as ‘Done’, click on the ‘Done’ hyperlink to view the Batch History. The following screen will appear: