top of page

How can I categorise and separate transactions using StatementReader?

Transactions are categorised using a user specified keyword list and order of prioritisation; these can be edited and added to by user. Categories can be identified as receipts, payments or both; the transactions matching this rule and the specified keywords can be displayed in a separate tab. If a separate tab is used, then the summary is dynamic (i.e. it updates automatically if transactions are removed or added from the relevant tab). Also, if a separate tab exists, the user can click on the category title from the summary tab to view the relevant tab (with the transaction breakdown). The summary also shows the total amounts, the amounts as a percentage of the total, and the number of transactions for each category.

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