How to identify recurring payments and receipts in Excel
The ‘recurring transactions’ area of the analysis options allows the user to identify daily / weekly / fortnightly / monthly / quarterly / annual transactions within an acceptable  day or % variance. Also, allow  missed occurrence(s), so that holiday or suspension periods are still included in the calculation. Using dates and amounts, each within an acceptable variance, helps to show regular financial dependencies that are imposed on the account holder. When analysing several months, patterns can be identified and possible future trends extrapolated using robust rules with documented evidence.
Recent PostsSee 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