How to identify reversed transactions in Excel

Transactions that are reversed within a user defined number of days, with one or two credits that equal (or are within an acceptable % variance of) a debit, or one or two debits that equal (or are within an acceptable % variance of) a credit are identified in a single click. This quickly catches any disguised transactions that may be filtering through a bank account and potentially should not be classed as trading income.

#All #Transactionsummary