Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Three Balancing attributes in transaction matching in a single Match type — Cloud Customer Connect
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
31
Views
2
Comments
edited Jul 3, 2021 8:55AM in Account Reconciliation 2 comments

Summary

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

Content

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.

Register

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