Chris, I've missed the point. Can you run that report? I've attached the files (GnuCash V 5.8).
This crosstab is effectively a 30/06/2018 trial balance with the $62.21 CostBase rolled into the Asset account: Full Account Name Sum - Value Asset:Shares:VAS 501,918.69 Bank:Savings 16,099.16 Equity -501,980.90 Income:Distribution 0.00 Income:Distribution:13C -22,870.71 Income:Distribution:13Q 7,069.35 Income:Distribution:13U -3,606.42 Income:Distribution:18H:18A -1,568.43 Income:Distribution:18H:GCTGrUp -1,567.05 Income:Distribution:20E/20M -463.54 Income:Distribution:20O 15.64 Income:Distribution:Rounding -0.01 Liability:Contra 6,954.22 Regards Chris Grinton wrote https://lists.gnucash.org/pipermail/gnucash-user/2024-September/112864.html : > ... >
VasDistribution.gnucash
Description: Binary data
VasDistribution.ods
Description: application/vnd.oasis.opendocument.spreadsheet
Date,Description,Action,Full Account Name,Amount,Value,Memo 01/08/17,VAS,Buy,Asset:Shares:VAS,6836,501980.9,6836 VAS @ $73.4305 + $10 brokerage 01/08/17,VAS,,Equity,-501980.9,-501980.9, 17/10/17,VAS Distribution,,Bank:Savings,6896.23,6896.23, 17/10/17,VAS Distribution,,Income:Distribution,-6896.23,-6896.23, 17/01/18,VAS Distribution,,Bank:Savings,4655.24,4655.24, 17/01/18,VAS Distribution,,Income:Distribution,-4655.24,-4655.24, 18/04/18,VAS Distribution,,Bank:Savings,4547.69,4547.69, 18/04/18,VAS Distribution,,Income:Distribution,-4547.69,-4547.69, 30/06/18,VAS Distribution,,Income:Distribution,-6954.22,-6954.22, 30/06/18,VAS Distribution,,Liability:Contra,6954.22,6954.22, 30/06/18,VAS,Sell,Asset:Shares:VAS,0,-62.21,CostBase 30/06/18,VAS,,Income:Distribution,23053.38,23053.38, 30/06/18,VAS,,Income:Distribution:13Q,7069.35,7069.35, 30/06/18,VAS,,Income:Distribution:20O,15.64,15.64, 30/06/18,VAS,,Income:Distribution:13C,-22870.71,-22870.71, 30/06/18,VAS,,Income:Distribution:13U,-3606.42,-3606.42, 30/06/18,VAS,,Income:Distribution:18H:18A,-1568.43,-1568.43, 30/06/18,VAS,,Income:Distribution:18H:GCTGrUp,-1567.05,-1567.05, 30/06/18,VAS,,Income:Distribution:20E/20M,-463.54,-463.54, 30/06/18,VAS,,Income:Distribution:Rounding,-0.01,-0.01, 17/07/18,VAS Distribution,,Bank:Savings,6954.22,6954.22, 17/07/18,VAS Distribution,,Liability:Contra,-6954.22,-6954.22,
Type,Full Account Name,Account Name,Account Code,Description,Account Colour,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder ASSET,Asset,Asset,,,,,AUD,CURRENCY,F,F,F ASSET,Asset:Shares,Shares,,,,,AUD,CURRENCY,F,F,F STOCK,Asset:Shares:VAS,VAS,,,,,VAS,ASX,F,F,F INCOME,Income,Income,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution,Distribution,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:13C,13C,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:13Q,13Q,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:13U,13U,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:18H,18H,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:18H:18A,18A,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:18H:GCTGrUp,GCTGrUp,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:20E/20M,20E/20M,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:20O,20O,,,,,AUD,CURRENCY,F,F,F INCOME,Income:Distribution:Rounding,Rounding,,,,,AUD,CURRENCY,F,F,F EQUITY,Equity,Equity,,,,,AUD,CURRENCY,F,F,F EQUITY,Liability,Liability,,,,,AUD,CURRENCY,F,F,F EQUITY,Liability:Contra,Contra,,,,,AUD,CURRENCY,F,F,F BANK,Bank,Bank,,,,,AUD,CURRENCY,F,F,F BANK,Bank:Savings,Savings,,,,,AUD,CURRENCY,F,F,F
_______________________________________________ gnucash-user mailing list [email protected] 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.
