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.
Recent Posts
See AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo