Add columns to the Generic import transaction matcher

[David Carlson]

Actually, the OFX specification does not limit files to a single source
account.  I regularly import files containing transactions from four
different accounts (2 checking and 2 savings) at my bank.  GnuCash
correctly assigns them each to it's proper account.  However, as you
noticed, GnuCash does not show the source account on the screen, and it
does not show some other information such as check numbers.  Finally, as
you also observed, it does not match transactions between multiple source
accounts when they are in the same OFX data file.  Quite some time ago I
filed bugs https://bugzilla.gnome.org/show_bug.cgi?id=766849 and
https://bugzilla.gnome.org/show_bug.cgi?id=751586 as well as
https://bugzilla.gnome.org/show_bug.cgi?id=721139 and
https://bugzilla.gnome.org/show_bug.cgi?id=673307. about these matters.

David C

On Mon, May 8, 2017 at 4:12 AM, David T. via gnucash-user <
gnucash-user at gnucash.org> wrote:

> 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.
>
> _______________________________________________
> 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.
>