Accounts Receivable                     Payment Processing                     Lockbox Overview

Lockbox Overview (continued)

Generic Lockbox File Specification

A generic lockbox file may be created and imported using the Payment Processing form within SedonaOffice.  The file contains four data elements and must be saved in a .csv format.  The file may not contain a header row - data records only.

The four data elements are:

·Customer Number

·Check Number

·Check Amount

·Invoice Number

If the customer is not paying an invoice, the value of 2 or any number that is not a valid invoice number is entered into the Invoice Number column.  When not referring to a valid invoice number, the application will apply the payment first to any assessed late fees and then the balance to unapplied cash on the customer's account. 

The first column contains the Customer Number, the second column contains the Check Number, the third column contains the Check Amount and the fourth column contain the Invoice Number.  If a customer number begins with leading zeros, you must precede the leading zeros with an apostrophe.  The Check Amount field must be numeric formatted - do not use a money format in this field; the import process does not allow this format.  Below is a sample Generic Lockbox file.

4289

Previous Page                                                            Page  2 of 2