Simple Bill Import Specification

(updated January 5, 2015)

The definition for the comma-delimited file format contains one bill 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
BillDate
MM/DD/YYYY
Y

2
MANumber
50 char
Y
Assigned by merchant - identifies customer to merchant
3
DueDate
MM/DD/YYYY Y

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
5
Name
50 char Y

6
ServiceAddress 100 char
Y