Hello,
Is there anyway to automatically assign default category on old transactions ?
EG:
I have imported thousands of transactions from my bank .qif file.
I am manually going through and defining default categories for these (which is extremely painfully slow, as you have to do each PAYE manually , you can't even select multiple lines which is a bummer..).
Once these defaults are defined , I still have to manually update old transactions by right clicking and choosing a category
Define Category On Old Transactions
Moderator: Renato
-
- New User
- Posts: 2
- Joined: Fri Apr 29, 2016 12:31 am
- Are you a spam bot?: No
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Define Category On Old Transactions
in mmex 1.3.0 multyline selection is available. but category assignment not realized yet. but will be in future.
-
- New User
- Posts: 2
- Joined: Fri Apr 29, 2016 12:31 am
- Are you a spam bot?: No
Re: Define Category On Old Transactions
Thank you.
Any fast way to apply categories on old imported transactions?
EG:
- Import QIF file to dummy account
- Set default category for all PAYE
- Delete dummy account
- Re Import QIF file to actual account
(Also FYI: I have 1.2.5 version but am still unable to multi line select in any window)
Any fast way to apply categories on old imported transactions?
EG:
- Import QIF file to dummy account
- Set default category for all PAYE
- Delete dummy account
- Re Import QIF file to actual account
(Also FYI: I have 1.2.5 version but am still unable to multi line select in any window)
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Define Category On Old Transactions
May be import then export to csv file.
Edit csv file in excel. Just add new column with the category. Then import.
PS in that case transfers and split will lost.
Edit csv file in excel. Just add new column with the category. Then import.
PS in that case transfers and split will lost.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Define Category On Old Transactions
It seems to me that if in a qif file the data category is missing, mmex will be using 'Unknown' category.
Then redefine the 'Unknown' category to any other one using Tools - category re.....
Then redefine the 'Unknown' category to any other one using Tools - category re.....
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: Define Category On Old Transactions
When you import qif or csv, the unknown categories get auto set to your defaults. So if your default categories are all set, just importing it should do. Then set any unknowns and they become the new defaults. Then on the next import, there are less unknowns. I import my statements each month and hardly any unknowns come up any more.