Three Balancing attributes in transaction matching in a single Match type
SummaryWe need to compare three amount column at the same time that is Net transaction Amount, Commission and VAT
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