We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Automatic categorisation tool for transactions
twister_teddy
Posts: 123 Forumite
I have exported my credit card statements for past 5 years in a spreadsheet. I would like to categorise them and was wondering if there is a tool out there which can perform automatic categorisation for each transaction based on the merchant name and/or description.
Sample data as below.
Date DESCRIPTION Amount
01/12/2019 Taco Bell Restaurant (Android Pay) 7.56
25/03/2019 The Card Factory 57.76
17/03/2019 Primark 20.66
So in above example there can be a new column and should assign something like "Eat out", "Shopping" and "Clothing" respectively for each row.
I can save the data in a different format if needed CSV, Excel, PDF etc
This will save me going through 6000+ records.
Sample data as below.
Date DESCRIPTION Amount
I can save the data in a different format if needed CSV, Excel, PDF etc
This will save me going through 6000+ records.
0
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.2K Banking & Borrowing
- 253.6K Reduce Debt & Boost Income
- 454.3K Spending & Discounts
- 245.2K Work, Benefits & Business
- 600.9K Mortgages, Homes & Bills
- 177.5K Life & Family
- 259.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards