[GNC] OFX import file xml tags for accounts

[David Cousens]

John,

Best source of information is straight from the horse's mouth. Sometimes not all thateasy to follow  though.
http://www.ofx.net/downloads/OFX%202.2.pdf  Around p193 has the info you are looking for.

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.