DroptoExcel identifies where the same amount is paid (or received) within a user defined period; quickly listing weekly, monthly or annual transactions across the data. The user can also enter an acceptable variance of recurring transactions to allow for differences in consecutive amounts. This means that (for example) direct debit or salary payments that change slightly each month can still be identified.
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.