(updated January 5, 2015)
The definition for the comma-delimited file format contains one account balance per record with no header record. The fields in the record are separated by commas and optionally enclosed in double-quotes ("). The filename has a suffix of ".csv". The fields in the file are as follows:
# |
Field
Name |
Format |
Req |
Comment |
---|---|---|---|---|
1 |
Date |
MM/DD/YYYY |
Y |
|
2 |
MANumber |
50 char |
Y |
Assigned by merchant - identifies customer to merchant |
4 |
Amount |
$###,###.## -$###,###.## $###,###.##- ($##,###.##) $###,###.##CR |
Y |
Dollars.cents, dollar sign ($) &
commas (,) ignored Negative number indicates credit due Negative number indicates credit due Negative number indicates credit due Inclusion of 'CR' indicate credit due |