[GNC] OFX Import matcher user input memo / description enhancement
Jeff Albrecht
jeffa at rodaw.com
Wed Aug 5 14:03:26 EDT 2020
Hi Jean,
In my workflow it's not a drawback for me as I don't want matches
recorded, at least as we probably all do, I use Ebay and Amazon a lot.
And I end up buying things destined for a diverse set of accounts
(classifications) that can't be determined by the matcher. Perhaps five
to ten different accounts from a vendor that sells a wide range of
stuff. Unlike say Albertsons, Kroger etc will always be a single
account; groceries.
I put them in the UnAccountedFor2020 specifically so I can easily add
the memo text. That way it's a bit easier to find transactions I want to
add memos too, rather than searching around the register for the
imported transactions I want to add the memo too..
++ "I too would love to be able to add a note to the imported info
*in* the matching dialog, rather than having to go to the register
after the import to add notes... "
I wonder how many folks enter additional text to transactions? Maybe
easier to ask who doesn't?
c ya... - Jeff
On 8/5/2020 10:37 AM, Jean Laroche wrote:
> One drawback of your workflow is that GC does not learn how to better
> match incoming OFX transactions to your accounts, because you're doing
> that outside of the import matcher...
> I guess you move them to UnAccountedFor2020 so you can go back to them
> at a later time, and take your time importing them to the right
> account...
>
> I too would love to be able to add a note to the imported info *in*
> the matching dialog, rather than having to go to the register after
> the import to add notes...
> J.
>
> On 8/5/20 10:28 AM, Jeff Albrecht wrote:
>> Devs and users,
>>
>> I want to add a short text entry somewhere on many of my transactions
>> that are being imported and matched. Specifically if I bought some
>> goodie, dodad or whatnot from ePay or Amizoned I'd like to add what
>> the item was in my GNUCash check register.
>>
>> _My Current Workflow_
>> Ignore monthly reminders to import .OFX
>> Do six to twelve months at a time
>> Download the .OFX from my bank
>> Import the .OFX
>> Match obvious like Netflix, utilities, grocers etc... that don't need
>> a memo.
>> Move the remaining unmatched transactions into a temporary register,
>> for instance 'UnAcountedFor2020' where I can add some arbitrary text
>> to a memo or description field.
>> Then lookup transactions on the vendor websites and try to jog my
>> memory what a a transaction was actually for. This may be handy for
>> reordering, or explaining to my Accountant. For instance in the
>> following image replacement nozzles for my pressure washer, this text
>> string was copied from the vendor, Amazon, orders list item
>> description. Copy and Paste.
>>
>>
>>
>> Next I highlight the UnAccountedFor2020 and utilize the 4.x partial
>> pattern matcher which again, is so COOL, such a time saver. (Maybe
>> have a short list at the top of the picker of the last ten accounts
>> selected? This would leave my hand on the mouse for many of the
>> transactions)
>> I continue this until the UnAccountedFor2020 register is empty.
>> I've noticed that the yellow line which has the 'UnAccountedFor2020'
>> is always blank in the memo/description. I put my desired text there.
>>
>> _Enhancement_
>>
>> If during the .OFX import matching some input box that I could enter
>> my memo/description text would appear as I pick the proper matching
>> account. Again that yellow line that has the desired target account
>> is always blank in the memo/description and may be the likely
>> candidate for the text target. If I could ad that user inputted text
>> during the import transaction matching I wouldn't need to move
>> desired transactions for memo/description into a temporary register
>> as I do in my current work flow.
>>
>> c ya... - Jeff
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
--
Jeff Albrecht
KF7CRU @jhalbrecht
More information about the gnucash-user
mailing list