John, Correction 11.4.4.2 p2147-218is the relevant section for statements from your bank. There does not appear to be an ability to specify the account you want as the second transfer component as such. It may work to use the <NAME> field. I rely on the Bayesian matching algorithm to come up with the correct transfer account and once trained it generally does a fairly good job.
David Cousens On Fri, 2018-10-26 at 16:17 -0500, John A Brown wrote: > gnuCash successfully imports OFX file from my bank. There is nothing in the > OFX file to indicate what accounts to post to. The resulting checking > account register has two lines for each transaction, a deposit and a > withdrawal, a debit and credit. > > I want to perform a programming edit to the file before importing that will > label the accounts I want to effect with each transaction import. > > QUESTIONS: > What is the xml tag for Asset:Current Assets:Checking Account? > What is the xml tag for Expenses:UPS Shipping? > > The transaction listing AS IS is as follows: > <STMTTRN> > <TRNTYPE>DEBIT > <DTPOSTED>20180905120000 > <TRNAMT>-72.36 > <FITID>8904938 > <NAME>U. P. S. UPS BILL XXXXX0000X96W0 > <MEMO>U. P. S. UPS BILL XXXXX0000X96W00 > </STMTTRN> > > My expectation is transaction listing: > <STMTTRN> > <TRNTYPE>DEBIT > <DTPOSTED>20180905120000 > <TRNAMT>-72.36 > <FITID>8904938 > <NAME>U. P. S. UPS BILL XXXXX0000X96W0 > <MEMO>U. P. S. UPS BILL XXXXX0000X96W00 > <ACCOUNT>Expenses:UPS Shipping > </STMTTRN> > would do the trick as long as <ACCOUNT> is the correct xml tag. > > I can get QIF files to do what I want but I would prefer to use OFX. I DO > APPRECIATE OPEN SOURCE! > > Thank you for your help. > _______________________________________________ > gnucash-user mailing list > gnucash-user@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. _______________________________________________ gnucash-user mailing list gnucash-user@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.
