Reconcile a lockbox deposit to the customer remittance records

A bank statement may show one lockbox credit while the underlying collection contains many customer payments. Obtain the batch report, individual payment detail and available remittance images. Identify the receiving account, processing date, bank batch reference and total before applying the cash to invoices.

U.S. Bank describes lockbox services that provide remittance transmission, check and document images, and exception tools. The exact files and retention periods depend on the service agreement. Confirm which records your own bank supplies and who is responsible for downloading them before portal access expires.

Total the items included in the deposited batch and compare them with the bank credit. Distinguish received items from processed deposits and rejected or held items. A document in the lockbox portal does not necessarily mean its associated payment reached the account.

Record adjustments and returns using their own references. If the bank groups several processing batches into one statement credit, preserve the grouping. If one batch appears across more than one credit, retain that split. The working paper should explain the actual relationship rather than forcing a one-to-one match.

Check whether the receivables import already created the cash entry. Accepting the same bank credit as new sales can duplicate income or receipts. Use the accounting system's supported matching or clearing process and verify the resulting bank and customer-ledger balances. Retain the import identifier and accepted item count so a later retransmitted file can be recognized before posting.

Match the payer, amount and remittance details to the customer account. A single check can cover multiple invoices, deductions and credits. Retain the customer's allocation and investigate differences from the open receivables record. Do not assume the oldest invoice is the intended one merely because its amount is close.

When remittance is missing or unreadable, keep the receipt identifiable in an unapplied-cash process while collections staff obtain clarification. Include the bank batch and item reference in the request. Avoid sending a full bank report containing other customers' information when one payment image or reference will answer the question.

Separate a valid cash receipt from a disputed commercial deduction. The bank can establish the amount deposited, but it cannot determine whether a customer was entitled to a discount or credit. Route that question to the person authorized to resolve the underlying invoice.

Maintain a list of unapplied receipts, rejected items, missing images and bank differences with amounts, owners and next actions. Reconcile its total to the relevant clearing or receivables balances. An exception should remain traceable even after the bank's portal moves it out of the current-day view.

Review subsequent returned checks or adjustments against the original lockbox item. Reopen the customer balance through the approved accounting process when supported. Retain the initial application and correction trail so a later collections conversation does not rely on an outdated paid-in-full record.

At close, sign off the bank total, applied receipts and remaining exceptions together. The reviewer should be able to trace a statement credit down to its customer items and trace an invoice payment back to its bank batch. Use repeated missing-remittance patterns to improve payment instructions or customer follow-up, with the bank's file specifications documented for the accounting team.