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.


identify reversed transactions

#All #Transactionsummary

Recent Posts

See All

Revisited 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

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm