[GNC] OFX import file xml tags for accounts

David Carlson david.carlson.417 at gmail.com
Fri Oct 26 18:25:08 EDT 2018


John,

GnuCash is designed to remember those choices after the first import.
Sometimes the choices vary, but GnuCash always proposes a choice and gives
you a chance to override it.

David C

On Fri, Oct 26, 2018, 4:20 PM John A Brown <johnbrowngreybeard at gmail.com>
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.
>


More information about the gnucash-user mailing list