wildcard match to assign accounts on import
The most time consuming activity for me - assigning accounts to imported transactions. Most could be automated with a smart query string match using a wildcard. Most transactions are like this:
Telco Co. Ltd {#2392Random Number58359}
and I just want it assigned it to phone every time. I would look forward to using GnuCash then.
-
PRG commented
I really dislike the Bayesian importer, hence I'm using a non-B one. The partial string filter with a wildcard feature would be amazing to have!
-
thomasb commented
This is sorely needed. Manually selecting each transaction during import and assigning to an account is a significant burden on the user.
-
Hans Deragon commented
This feature should exist on imports, but also for reassigning existing transactions already imported, and already assigned to accounts. The code to do both is mostly the same and could be shared.
-
Ian commented
@Eldon Rosenberg, sorry, I know this is an old post, but it's the only one I've found that addresses this issue. I tried importing a QIF file into Gnucash, got to the "Match payees/memos to GnuCash accounts" dialog, and found all I could do was allocate an account to a transaction. There is nowhere to edit the payee/memo part of the match as you mentioned in your post. I'm on 2.6.12 currently. Are you using a later version?
Thanks, Ian -
Ian commented
I agree with Josh Buhi, it would be nice to be able to select a number of transactions and assign them to the same transfer in one go, instead of manually selecting each transaction and selecting the account to transfer it to. I didn't know about the "match payees/memos to Gnucash accounts" option. I'll have to look into that.
-
Eldon Rosenberg commented
Suggestion: In the "Match payees/memos to GnuCash accounts" dialog, allow users to edit the payee/memo part of the match to put in wildcards / regular expressions, validate that the resultant pattern matches the original, and then remove other payee/memo list entries that match (i.e. amalgamate them into 1 line) so that the account assignment only needs to be done once, then I think this would accomplish the desired result nicely. I believe this would require that mappings listed in the user's qif-accounts-map file be treated as patterns (or regular expressions), or that some cue be added to any mapping that represents a pattern (I'd prefer this option).
Some years ago I wrote a simple Java program to pre-process the .QIF files from my bank because of this and another problem. The other problem is possibly just a quirk of my banking entity: it often lists further identifying information about transactions on one or two separate transactions with the same date and a zero value. Due to this 2nd problem I can't reliably identify transactions during the QIF Import Assistant if I haven't pre-processes the input file to merge the extra descriptive information into the one transaction. Since there wasn't a wildcard matching function in GnuCash, and other people's programs along these lines didn't work with my peculiar .QIF files, I wrote my little Java program to do both. If it was just addressing the 2nd problem it wouldn't need a GUI, but since it involves creating and editing text patterns (I use regular expressions), I gave it a GUI too. But it has occurred to me that my GUI somewhat resembles the "Match payees/memos to GnuCash accounts" dialog, though I have also added the ability to optionally match on dates and amounts and to add extra narration to the description of the matched transaction (that is, the processed output file gets extra narration text added to transactions where desired). Anyway, this similarity suggested to me the solution I began with above: to add pattern editing to that step in the import assistant.
Regards,
Eldon -
Josh Buhl commented
The keyword here would be *Import Filters*. The other half of this would be to be able to (once the transactions are imported and in 'imbalance') select or mark multiple transactions and then assign an account for all the selected transactions in one go!