[GNC] OFX import file xml tags for accounts

[David Cousens]

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