Is it possible to create an external transaction based on the variance between two transactions?
Summary:Our business has requested to create an external cash transaction based on the variance between a statement and system transaction.
For example, a the statement transaction of a credit card deposit is less than the corresponding system transaction due to the card processor deducting their commission fee from the deposit amount. Our business would like to match those transactions based on a percentage variance and at the same time, use that variance amount to generate the external transaction to record the commission amount to the general ledger. Is there any functionality that would allow this?
Content (please ensure you mask any confidential information):