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.