Bank Transaction Default cash account
Attempting to create a map that would import to Bank Transactions (Decrease Adjustment). I know the cash account will automatically be generated. However, how would I go about to calculate the amount needed. These transactions would have debits and credits of varying amounts and the cash account entry would be the net of the two sides (offset). Is there a way to sum the credit, sum the debits and force the difference as my ‘Amount’ which would then be the amount entered in my default cash account?