Load difference of two columns as amount in Transaction Matching

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.