Simple Account Balances Import Specification

(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