Add columns to the Generic import transaction matcher

David T. sunfish62 at yahoo.com
Mon May 8 05:12:15 EDT 2017


Hello, 

I believe that gnucash expects that each OFX file will have transactions for one account. That is why you don't see a column for the source account; it is (to gnucash) implicitly known. I am also thinking that the OFX specification states this as well, but of that I am not sure. 
If you import each account separately, the matcher can learn from your choices, and begin to preselect based on that. 
As for adding the extra column, I imagine you'd have top wrote the code for that yourself. 
David

 
 
  On Mon, May 8, 2017 at 13:35, reaneyp<preaney at gmail.com> wrote:   Hello:

Is there a way that I can add columns to the import matcher?  When i import
OFX files from my bank, I'm doing it for several accounts at once.  The
dialog box that pops up has a list of all the transactions and one of the
columns is the 'destination' account (for example "Expenses:Auto:Gas"), but
the 'source' account is not there.  This makes transfers between accounts
difficult to figure out. I'm actually surprised that it can't figure that
out by itself.

Anyway, there will be two rows that say 'transfer debit' and 'transfer
credit' with the same date and amount. The 'Info' field will say something
like 'New, UNBALANCED, (need acct to transfer $xxx)!" I know they are the
two ends of the same transaction, but there's not enough information here to
reconcile it properly.

It winds up creating two separate entries, one in the source acct and the
other in the desintation account, each with the other side in 'imbalance
USD'. I then have to go into the 'Imbalance USD' account and set one of them
to the right account, then delete the other.

If the 'source' account was one of the columns I could figure this all out
before completing the import.  Is there a config somewhere that would let me
add this column? Any help would be appreciated.

Thank you



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Add-columns-to-the-Generic-import-transaction-matcher-tp4691515.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  


More information about the gnucash-user mailing list