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

Three Balancing attributes in transaction matching in a single Match type

Received Response
edited Jul 3, 2021 8:55AM in Account Reconciliation 2 comments


We need to compare three amount column at the same time that is Net transaction Amount, Commission and VAT


Hi Team

We have a requirement in which we need to have three different columns as balancing attributes. Currently, the bank is providing CSV files in which they are giving commission, VAT, and Net Amount in different columns. We need to compare all these with ERP GL.
From the GL side, we will get VAT, Net Amount, and Commission in a single line. However, we will not get the same on another side (Bank)

One option is to have separate match types and integration for VAT, Commission, and Net Amount. But that leads to an increased volume of match types as there are a high number of banks

Howdy, Stranger!

Log In

To view full details, sign in.


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