[GNC] Financial Statements

flywire flywire0 at gmail.com
Mon Sep 2 01:44:35 EDT 2024


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


More information about the gnucash-user mailing list