You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to group the System Transactions lines over Manual Reconciliation ?

edited Nov 6, 2023 7:33AM in Payables, Payments & Cash Management 1 comment

On the right side, where system transactions are recorded, we observe multiple entries representing receipts processed through i.e. Lockbox. The request we've received indicates a preference for these multiple entries to be consolidated into a single line item.Conversely, on the left side, where the bank statement lines are displayed, the Lockbox transactions will be typically represented as one consolidated line.  Is there a way we can do this ?

For example, the system transactions that we processed amounted to $100 and $1,000, respectively. The goal is to batch the system transactions in such a way that they appear on the system transactions side as a singular transaction totaling $1,100.00. This would streamline the reconciliation process by matching one consolidated system transaction to the corresponding single line item on the bank statement side.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!