In addition to the standard formatting rules that apply to all batch upload file formats, keep the following points in mind about the flat file format:
• Multiple lockboxes may be included in a single file.
• The lockbox must exist in System Information.
• Any number of payment entry records may follow the lockbox header.
Lockbox flat file format
Name |
Starting Character Position |
Length |
Required? |
Special Formatting |
Lockbox – 59 Characters | ||||
Leading Text |
1 |
16 |
Yes |
BATCH-AR LOCKBOX |
[blank space] |
17 |
1 |
Yes |
|
Lockbox Number |
18 |
11 |
Yes |
Left justified. Must exist in System Information. |
Date |
29 |
10 |
Yes |
YYYY-MM-DD format |
[blank space] |
39 |
1 |
Yes |
|
Bank Name |
40 |
18 |
Yes |
|
Total amount of payments in this lockbox |
49 |
15 |
Yes |
Padded with zeros. No decimal points. For example, 625.00 would be formatted as follows: 000000000062500 |
[blank space] |
54 |
1 |
Yes |
|
Total number of payments in this lockbox. |
55 |
5 |
Yes |
Padded zeroes. For example, 5 payments would be formatted as 00005. |
Payment – 57 Characters | ||||
System Information Chart of Accounts Code |
1 |
2 |
Yes |
|
System Information Organization Code |
3 |
4 |
Yes |
|
Customer Number |
7 |
9 |
Yes |
Left justified. |
Origination Code |
16 |
2 |
Yes |
01 |
Invoice Number |
18 |
9 |
Yes |
Left justified |
Billing Date |
27 |
10 |
Yes |
YYYY-MM-DD format |
Total Invoice Amount |
37 |
16 |
Yes |
Padded with zeros. No decimal points. For example, 625.00 would be formatted as follows: 000000000062500 |
Applied Amount |
53 |
14 |
Yes |
Padded with zeros. No decimal points. For example, 625.00 would be formatted as follows: 000000000062500 |
Debit/Credit indicator |
67 |
1 |
Yes |
D or C – C indicates that a payment has been received. |
More: