Lockbox Upload Format

 

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:

Capital Asset Management