Reconcile Lockbox in Cash Management
Client wants to reconcile Lockbox in Cash Management. Lockbox file is loaded into AR and creates receipts associated with invoices. The receipts come down to Cash Management as individual receipts. On the Bank Statement side, we receive all lockbox activity as 1 receipt. You cannot reconcile receipts at the receipt batch level (only for remittance batches).
Bank is unable to provide us with individual Check detail on Lockbox side. Just the batch summary amount.
Has anyone else encountered this before? How did you reconcile the Lockbox Receipt Batches to a single line? Is the only way to individually pull up each and every receipt and reconcile them all to the single statement line?