[GNC] Using GnuCash with Portfolio Performance Share Software

flywire flywire0 at gmail.com
Sun Aug 14 04:06:26 EDT 2022


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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Trust-ETF_Shares.csv
Type: text/csv
Size: 467 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220814/f33d8cde/attachment.csv>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DemoPortfolioBrief.csv
Type: text/csv
Size: 470 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220814/f33d8cde/attachment-0001.csv>


More information about the gnucash-user mailing list