top of page

Step by step guide to categorising transactions automatically with StatementReader


First, click Options -> Analysis options, then select the ‘categories’ area. Here you can see all categories and, when one is selected, the other settings that have been configured (including the keywords, whether the category is output as a separate tab in Excel, and also whether the transactions matching the keywords are restricted to receipts/payments/both). Additionally, you can set the order of priority incase more than one category matches against a single transaction, by moving categories up and down in the list shown, and also, you can select if the keywords should be identified as separate words (for example, if this option is selected this would disallow a match for ‘fee’ in ‘coffee’).

For example, for a new ‘HMRC’ category, enter a new category title (e.g. ‘HMRC’), click to add the category, then add the category keywords (e.g. ‘hmrc,hm revenue,vat’) and select the other settings. Finally, save the options.

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