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

Load difference of two columns as amount in Transaction Matching

edited Nov 17, 2020 3:02PM in Account Reconciliation 11 comments

Summary

Load difference of two columns as amount in Transaction Matching

Content

We have a trial balance report from which we want to load the data into Transaction Matching. The data is available as Total debits and Total credits in two separate columns and we want to load the difference of these two columns as the amount into transaction matching.

For example in the attached image, column AG has the Total Debits and column AH has the Total Credits and we want to load the difference of these two columns as the amount for each transaction.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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