top of page

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 [2] day or [10]% variance. Also, allow [2] 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.

identify recurring receipts payments

Recent Posts

See All

Improving Excel with Python (May 2022)

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

bottom of page