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 Options.

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.

<what is this>

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:

Budget Construction