Share software can manage shares and show all sorts of interesting things. I use Portfolio Performance portfolio-performance.info/en/ and Sharesight sharesight.com is also popular.
Portfolio Performance easily imports broker trade pdfs (Sharesight even strips emails or uploads a hot folder) but importing dividends is not so easy. GnuCash imports bank statements, with a bit of assistance categorises them, and exports a dividend file for importing into Portfolio Performance. Importing dividends is demonstrated in a quick tutorial to Import CSV Files to Create Portfolio at https://forum.portfolio-performance.info/t/import-csv-file/17123 Portfolio Performance also exports broker account transactions that can be normalised with a python script to import into GnuCash as financial transactions: https://forum.portfolio-performance.info/t/security-account-export-csv-with-itemised-transaction-costs/17595 . Unfortunately, creating the financial transaction in GnuCash does not create the security which I understand means the portfolio value isn't maintained. I'm reluctant to manually reenter the data into GnuCash to get financial reports so I'm keen for suggestions. It seems this is essentially a managed portfolio, the share financial transactions are already in GnuCash, and only changes to portfolio value are required for unrealised gains in financial reports. Would a single asset:portfolio account be adequate with yearly valuations so the reports can be created? As a start for a data exchange dataset I've attached is a sample security export file and DemoPortfolioBrief.csv. Total is Net Price (ie Buy + Fees or Sell - Fees). All the shares are AUD in the ASX (.AX in Yahoo). There is a capital loss of $1,283.16 for WPL and two of the eight $9.50 Expense:Brokerage transactions apply to this security.
Date,Transaction ID,Number,Description,Notes,Commodity/Currency,Void Reason,Action,Memo,Full Account Name,Account Name,Amount With Sym,Amount Num.,Reconcile,Reconcile Date,Rate/Price 02/08/2017,c253d594ae7a48bfa5c271926304a3f3,,VAS,,CURRENCY::AUD,,Buy,,Assets:Investments:Brokerage Account:ETF,ETF,"6,836 VAS","6,836",n,,73.00 ,,,,,,,,,Expenses:Brokerage,Brokerage,$10.00,10.00,n,,1.0000 ,,,,,,,,,Bank:Investment,Investment,"-$499,038.00","-499,038.00",n,,1.0000
Trade Date,Action,Reference,Code,Units,Brokerage,Total 04/01/21,Buy,T20210104689951-1,REA,64,9.5,9880.86 01/02/21,Buy,T20210201523636-1,RIO,89,9.5,9912.53 01/03/21,Buy,T20210301378143-1,WPL,397,9.5,9998.02 29/03/21,Buy,T20210329345452-1,WOW,247,9.5,9998.18 26/04/21,Buy,T20210426460841-1,CBA,112,9.5,9983.1 24/05/21,Sell,T20210524608678-1,WPL,397,9.5,8695.86 24/05/21,Buy,T20210524356856-1,ALL,459,9.5,18690.8 21/06/21,Buy,T20210621600557-1,NCM,383,9.5,9986.65
_______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
