Lockbox Processing Unapplied Payment

(1) Share

Report

Posted on by Nancy Hogan

1,295

We are testing the import of a cash receipts file from our bank into the lockbox processing module. In 2 cases, there is no invoice to apply the cash to. I want to be able to just apply the cash to the customer. How can I do this?

Does it have to do with the setting you select for the Lockbox Apply Method? I would think the setting would be "None". However, there are only 2 in the batch that should be open, unapplied payments. The rest need to be applied to an invoice.

How can we account for payments that we want applied to the customer's account but not to a document?

Thanks!

Nancy

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Richard Whaley 25,195 on at

Like (0)

Report
Copy link

Link copied!

When you automatically apply payments to invoices via lock box it does it's best to match them. It then allows the user to review and correct the matches. Remaining unmatched payments are typically posted in as Unapplied Payments.

Believe it or not, some of the largest banks prepare the lockbox files to send you by hand keying the data into Excel. Strange but True. I have seen documents that were issued as INV000001001 sent back in lock boxes as 1001, which will not match, of course.

If you are having these kinds of issues with mismatches, talk to your rep at your bank and let them know the full prefix (INV0000) is needed!

Was this reply helpful? Yes No