Just investigating MMEX as an alternative to our existing (Windows only) system.
I can get csv files from our bank and credit card companies, but they obviously do not include category information.
Am I correct in assuming that I would have to create a column "category" in the csv file, and then populate each line with the exact category name that appears in MMEX? If so, this seems very labour intensive and prone to error. Especially as MMEX does not have codes for categories.
My existing system allows me to import the file, and THEN associate each transaction with a category within the program by click and select.
Also - there is a note saying not to use the same category name for withdrawals and deposits within the same account.
Would that mean that a refund from a shop for the purchase of an item would have to have a different category to the purchase? Refund as a sub-category?
Thanks!!
Import CSV and Categories
Moderator: Renato
-
- New User
- Posts: 13
- Joined: Tue Oct 25, 2022 12:31 pm
- Are you a spam bot?: No
-
- Developer
- Posts: 343
- Joined: Fri Aug 21, 2020 5:44 pm
- Are you a spam bot?: No
Re: Import CSV and Categories
You can import without category. It will them appear as "Unknown" in the transaction register.
Ignore that, the documentation is wrong. You can do as you describe and use the sam category for wihdrawals and deposits which will balance out the category spend.Also - there is a note saying not to use the same category name for withdrawals and deposits within the same account.
Would that mean that a refund from a shop for the purchase of an item would have to have a different category to the purchase? Refund as a sub-category?
-
- New User
- Posts: 13
- Joined: Tue Oct 25, 2022 12:31 pm
- Are you a spam bot?: No
Re: Import CSV and Categories
Thanks whall3y - very helpful and it works!
-
- New User
- Posts: 13
- Joined: Tue Oct 25, 2022 12:31 pm
- Are you a spam bot?: No
Re: Import CSV and Categories
Hi again.
Importing CSV file is working fine except in Category.
If I use the : separator between category and sub-category, MMEX takes it in as a | separator and creates new categories.
I'm generating the CSV from Microsoft Excel for Mac, version 16.66.1
Thanks for any thoughts!
Importing CSV file is working fine except in Category.
If I use the : separator between category and sub-category, MMEX takes it in as a | separator and creates new categories.
I'm generating the CSV from Microsoft Excel for Mac, version 16.66.1
Thanks for any thoughts!
-
- New User
- Posts: 13
- Joined: Tue Oct 25, 2022 12:31 pm
- Are you a spam bot?: No
Re: Import CSV and Categories
Also tried importing SubCategory as a separate field, but MMEX takes it in as a new Category and SubCategory.
-
- New User
- Posts: 13
- Joined: Tue Oct 25, 2022 12:31 pm
- Are you a spam bot?: No
Re: Import CSV and Categories
Actually, ignore the last post. Importing the CSV with Category and SubCategory works.
So that seems the way to go.
So that seems the way to go.