OFX transaction dilemma

harphauler hurst.lou at gmail.com
Mon Feb 9 11:06:48 EST 2015


I'll paste part of a QFX download below, have added some line feeds for a
little more clarity.  In this example there's just one dividend paid of
$10.10 and a new share purchased as a reinvest for $9.92.  If I keep things
simple, running this through the cash account only as two transactions and
accepting the transactions as is, the $9.92 purchase/reinvest results in
$9.92 too much cash in the cash account and -1 share in the investment
account.

Thanks!  Lou

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20150209074656.443[-7:MST]<LANGUAGE>ENG<FI><ORG>dadco.com<FID>59401</FI><INTU.BID>17850<INTU.USERID>******</SONRS></SIGNONMSGSRSV1><INVSTMTMSGSRSV1><INVSTMTTRNRS><TRNUID>******<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><INVSTMTRS><DTASOF>20150209074658.317

[-7:MST]<CURDEF>USD<INVACCTFROM><BROKERID>dadco.com<ACCTID>******</INVACCTFROM><INVTRANLIST><DTSTART>20150109000000.000[-7:MST]<DTEND>20150209074658.573

[-7:MST]<REINVEST><INVTRAN><FITID>R238269573826956<DTTRADE>20150126173000.000[-7:MST]<DTSETTLE>20150126173000.000[-7:MST]<MEMO>FIRST
TRUST DIV STRENGTH 25 MO
RE</INVTRAN><SECID><UNIQUEID>30284Y695<UNIQUEIDTYPE>CUSIP</SECID><INCOMETYPE>DIV<TOTAL>9.9200<SUBACCTSEC>CASH<UNITS>1.0000<UNITPRICE>9.920000<CURRENCY><CURRATE>1<CURSYM>USD</CURRENCY></REINVEST><INVBANKTRAN><STMTTRN><TRNTYPE>DIV<DTPOSTED>20150126173000.000[-7:MST]<TRNAMT>10.1000<FITID>187616018761601<MEMO>FIRST
TRUST DIV STRENGTH 25 MO RE 012515        
669</STMTTRN><SUBACCTFUND>CASH</INVBANKTRAN>

</OFX> 



--
View this message in context: http://gnucash.1415818.n4.nabble.com/OFX-transaction-dilemma-tp4675761p4675863.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list