[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