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 AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing...