I'd welcome any suggestions on how to get the Financial Statement reporting closer to the examples below to save manual rework:
* Balance Sheet - https://www.pssuper.com.au/wp-content/uploads/2019/07/Sample-Reports.pdf#page=11 * Income and Expenditure - https://www.pssuper.com.au/wp-content/uploads/2019/07/Sample-Reports.pdf#page=10 * Taxation Preparation report - similar to I&E with distribution components 1. Is there a Balance Sheet showing both the previous and end of current financial year? 2. How can the I&E report Distributions and the Taxation Preparation report Distribution Components. My workflow: Typically an ETF has four payments a year with the last payment received in the following financial year. This is easily fixed by drawing the last payment from Liability:Conta account and paying into that account when it is received. At the end of the financial year I reverse the distributions and split them into components. The problem with the account structure as shown below is the Asset:Shares:CostBase split is no longer under Income:Distribution so the I&E report doesn't report the full payments received for the I&E report. Typical ETF annual tax statement: https://github.com/flywire/ETF-Annual-Statement/blob/main/Tax/VAS-annual-tax-statement-2018.pdf Transactions: Bank:Savings Typically 2-4 payments 23,053.38 Income:Distribution -23,053.38 Asset:Shares:CostBase -62.21 Income:Distribution 23,053.38 Income:Distribution:13Q Trust franking credits 7,069.35 Income:Distribution:20O Foreign income tax offset 15.64 Income:Distribution:13C Franked distributions from trust -22,870.71 Income:Distribution:13U Net trust income, less NCG/FI/FD -3,606.42 Income:Distribution:18H:18A Net capital gain -1,568.43 Income:Distribution:18H:GCTGrossUp Total current year capital gains -1,567.05 Income:Distribution:20E/20M Assessable foreign source income -463.54 Income:Distribution:Rounding Rounding -0.01 Regards _______________________________________________ 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.
