Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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!