Report - Distribution Reconciliation
GET {{baseUrl}}/sf/funds/:fundId/reports/distributionRecTaxComponents?financialYear={{financialYear}}
Allows you to retrieve the Distribution Reconciliation Report for a specific entity.
API Scopes
The following API scopes can access this resource
- smsf_partner
- bgl_partner
- auditor
Entities Supported
The following entityTypes are supported
- SMSF
- BillableTrust
- BillableCompany
- BillableIndividual
The Distribution Reconciliation Report includes comprehensive income information that will assist in the following ways:
- Verifying tax components that have been entered against your distribution income.
- The payment received reconciles with the Operating Statement.
- Gross trust distributions (label 11M in the tax return) can be easily reconciled.
- Capital Gains reconciliation section added at the bottom of the report to assist in reconciling the gross capital gain of the fund with the NET capital gains for both the 1/3, 2/3 method (superfund) and 50% (individuals) discount rates. The discount elected for each distribution is determined by the election made in the Distribution details panel when recording tax statements.
Response
| Key | Type | Comments |
|---|---|---|
| financialYear | Date | The financial year of the report. Format: YYYY |
| fundName | String | The name of the fund. |
| fundId | String | The fund identification number. |
| residentSMSF | Boolean | True or False. |
| investmentControlAccounts | Array | Contains a set of investment control accounts in the report. See Investment Control Accounts Array. |
1 - Investment Control Accounts array
| Key | Type | Comments |
|---|---|---|
| accountCode | String | The control account code from the Chart of Accounts. |
| investmentControlName | String | The control account name from the Chart of Accounts. |
| totalPayment | Number | Total income amount for the Control account. |
| totalTaxableIncome | Number | Total Taxable Income for the Control account. |
| nonPrimaryProductionIncome | Object | See below. |
| capitalGains | Object | See below. |
| otherComponents | Object | See below. |
| investmentSubAccounts | Array | Contains a set of investment sub accounts for the Control account. |
1.1 Non Primary Production Income Object (Control Account level)
| Key | Type | Comments |
|---|---|---|
| totalFrankedDividends | Number | Total franked dividends for the Control Account. |
| totalUnfrankedDividends | Number | Total unfranked dividends for the Control Account. |
| totalGrossInterest | Number | Sum of interest for all distribution transactions under investments for the Control Account. |
| totalOtherIncome | Number | Total other income for the Control Account. |
| totalLessOtherAllowableTrustDeductions | Number | Sum of trustDeductns for all distribution transactions under investments for the Control Account. |
| totalFrankingCredits | Number | Total franking credits for the Control Account. |
| totalNonPrimaryProductionIncome | Number | divFrankDist + divUnfrankDist + interest + otherInc - trustDeductns for all distribution transactions under investments for the Control Account level. |
1.2 Capital Gains Object (Control Account level)
| Key | Type | Comments |
|---|---|---|
| totalDiscountedCgAfterDiscount | Number | Total Discounted Capital Gain (Before Discount) for the Control Account. |
| totalDiscountedCgNtarpAfterDiscount | Number | |
| totalDiscountedCgTarpAfterDiscount | Number | |
| totalCgtConcessionAmount | Number | Total CGT Concession Amount for the Control Account. |
| totalCgIndexationMethodNtarp | Number | Total Capital Gain - Indexation Method for the Control Account. |
| totalCgIndexationMethodTarp | Number | |
| totalCgOtherMethod | Number | |
| totalCgOtherMethodNtarp | Number | |
| totalCgOtherMethodTarp | Number | |
| totalForeignDiscountedCgAfterDiscount | Number | |
| totalForeignCgIndexationMethod | Number | |
| totalForeignCgOtherMethod | Number | |
| totalForeignDiscountedCgFtc | Number | Total Foreign Discounted Capital Gains (Before Discount) Foreign Tax Credits for the Control Account. |
| totalForeignCgIndexationMethodFtc | Number | Total Foreign Capital Gains - Indexation Method Foreign Tax Credits for the Control Account. |
| totalForeignCgOtherMethodFtc | Number | Total Foreign Capital Gains - Other Method Foreign Tax Credits for the Control Account. |
| totalDistributedCg | Number | Total Distributed Capital Gains for the Control Account. Equivalent to Distributed Capital Gains (B) in the Distribution more details. |
| totalNetCg | Number |
1.3 Other Components Object (Control Account level)
| Key | Type | Comments |
|---|---|---|
| totalAssessableForeignSourceIncome | Number | Total Assessable Foreign Source Income for the Control Account. |
| totalOtherNetForeignSourceIncome | Number | Total Other Net Foreign Source Income for the Control Account. |
| totalForeignIncomeTaxCredits | Number | Total Foreign Income Tax Credits for the Control Account. |
| totalAusFrankingCreditsFromNz | Number | Total Australian Franking Credits from a NZ company for the Control Account. |
| totalTaxExempt | Number | Total Tax Exempted amounts for the Control Account. |
| totalTaxFree | Number | Total Tax Free amounts for the Control Account. |
| totalTaxDeferred | Number | Total Tax Deferred amounts for the Control Account. |
| totalAmitCostBaseNetIncreaseShortfall | Number | Total AMIT Cost Base Increase / Shortfall amounts for the Control Account. |
| totalAmitCostBaseNetDecreaseExcess | Number | Total AMIT Cost Base Decrease / Excess amounts for the Control Account. |
| totalLessTfnAmountsWithheld | Number | Total Less TFN Amounts Withheld for the Control Account. |
| totalLessOtherExpenses | Number | Total Less Other Expenses amounts for the Control Account. |
2. Investment Sub Accounts Array
| Key | Type | Comments |
|---|---|---|
| accountCode | String | The investment control account code + “/” + sub account code from the Chart of Accounts. |
| securityCode | String | The security code attached to the investment sub account. |
| accountName | String | The investment sub account name from the Chart of Accounts. |
| totalPayment | Number | Total income amount for the investment sub account. |
| netCashDistribution | Number | Total Net Cash Distribution for the investment sub account. Equivalent to Net Cash Distribution in the Distribution more details. |
| variance | Number | |
| totalTaxableIncome | Number | Total Taxable Income for the investment sub account. |
| nonPrimaryProductionIncome | Object | See below. |
| capitalGains | Object | See below. |
| otherComponents | Object | See below. |
| incomeEntries | Array | See below. |
2.1 nonPrimaryProductionIncome Object (Sub Account Level)
- Same definition as nonPrimaryProductionIncome object in control account (point 1.1) applied for the Sub Account level.
2.2 capitalGains Object (Sub Account Level)
- Same definition as capitalGains object in control account (point 1.2) applied for the Sub Account level.
2.3 otherComponents Object (Sub Account Level)
- Same definition as otherComponents object in control account (point 1.3) applied for the Sub Account level.
2.4 - Income Entries array (Sub Account Level)
- List out all distribution transactions posted to the 23800/xxx sub account.
| Key | Type | Comments |
|---|---|---|
| transactionDate | Date | Date of the distribution transaction. |
| payment | Number | Income amount for the distribution transaction. Credit = positive amount. Debit = negative amount |
| taxableIncome | Number | Same calc as Taxable Income in the Rec Report. |
| nonPrimaryProductionIncome | Object | Please see point 1.1 to be applied to the transaction level. |
| capitalGains | Object | Please see point 1.2 to be applied to the transaction level. |
| otherComponents | Object | Please see point 1.3 to be applied to the transaction level. |
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
financialYear | string | [REQUIRED] Financial Year of Report. Expected format : YYYY |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Authorization | string |
RESPONSES
status: OK
"{\n \"financialYear\": \"2020\",\n \"fundName\": \"0509 Jo Distribution\",\n \"fundId\": \"8a009e7948437d56014843a2aa440013\",\n \"residentSMSF\": \"Y\",\n \"investmentControlAccounts\":\n [\n {\n \"accountCode\": 78200,\n \"investmentControlName\": \"Units in Listed Unit Trusts (Australian)\",\n \"totalPayment\": 2730.13,\n \"totalTaxableIncome\": 89.29,\n \"nonPrimaryProductionIncome\":\n {\n\t \"totalFrankedDividends\": 241.52,\n\t \"totalUnfrankedDividends\": 44.24,\n\t \"totalGrossInterest\": 3.12,\n\t \"totalOtherIncome\": 7.17,\n\t \"totalLessOtherAllowableTrustDeductions\": null,\n\t \"totalFrankingCredits\": 89.85\n \t},\n \t\"capitalGains\":\n \t{\n \t\t\"totalDiscountedCgAfterDiscount\": null,\n \"totalDiscountedCgNtarpAfterDiscount\": null,\n \t\t\"totalCgtConcessionAmount\": null,\n \t \"totalCgIndexationMethod\": null,\n \"totalCgIndexationMethodNtarp\": null,\n \t \"totalCgOtherMethod\": null,\n \"totalCgOtherMethodNtarp\": null,\n \t\t\"totalForeignDiscountedCgAfterDiscount\": null,\n \t\t\"totalForeignCgIndexationMethod\": null,\n \t\t\"totalForeignCgOtherMethod\": null,\n \t\t\"totalForeignDiscountedCgFtc\": null,\n \t\t\"totalForeignCgIndexationMethodFtc\": null,\n \t\t\"totalForeignCgOtherMethodFtc\": null,\n \t\t\"totalDistributedCg\": null,\n \t\t\"totalNetCg\": null\n \t},\n \t\"otherComponents\":\n \t{\n \t\t\"totalAssessableForeignSourceIncome\": 5.88,\n \t\t\"totalOtherNetForeignSourceIncome\": null,\n \t\t\"totalForeignIncomeTaxCredits\": 0.80,\n \t\t\"totalAusFrankingCreditsFromNz\": null,\n \t\t\"totalTaxExempt\": null,\n \t\t\"totalTaxFree\": null,\n \t\t\"totalTaxDeferred\": null,\n \t\t\"totalAmitCostBaseNetIncreaseShortfall\": null,\n \t\t\"totalAmitCostBaseNetDecreaseExcess\": 11.73,\t\n \t\t\"totalLessTfnAmountsWithheld\": null,\n \t\t\"totalLessOtherExpenses\": null\n \t},\n \t\"investmentSubAccounts\": \n \t[\n \t\t{\n \t\t\t\"accountCode\": \"78200/EX20.AX\",\n \t\t\t\"securityCode\": \"EX20.AX\",\n \t\t\t\"accountName\": \"Betashares Australian Ex-20 Portfolio Diversifier Etf\",\n \t\t\t\"totalPayment\": 0.00,\n \t\t\t\"netCashDistribution\": 232.64,\n \t\t\t\"variance\": -232.64,\n \"totalTaxableIncome\": 89.29,\n \t\t\t\"nonPrimaryProductionIncome\":\n\t\t {\n\t\t\t \"totalFrankedDividends\": 140.88,\n\t\t\t \"totalUnfrankedDividends\": 44.24,\n\t\t\t \"totalGrossInterest\": 3.12,\n\t\t\t \"totalOtherIncome\": 0.32,\n\t\t\t \"totalLessOtherAllowableTrustDeductions\": null,\n\t\t\t \"totalFrankingCredits\": 67.72,\n\t\t\t \"totalNonPrimaryProductionIncome\": 188.56\n\t\t \t},\n\t\t \t\"capitalGains\":\n\t\t \t{\n\t\t \t\t\"totalDiscountedCgAfterDiscount\": 2.59,\n\t\t \"totalDiscountedCgNtarpAfterDiscount\" null,\n\t\t \t\t\"totalCgtConcessionAmount\": 1.29,\n\t\t \t\t\"totalCgIndexationMethod\": null,\n\t\t \"totalCgIndexationMethodNtarp\": null,\n\t\t \t\t\"totalCgOtherMethod\": 0.02,\n\t\t \"totalCgOtherMethodNtarp\": null,\n\t\t \t\t\"totalForeignDiscountedCgAfterDiscount\": null,\n\t\t \t\t\"totalForeignCgIndexationMethod\": null,\n\t\t \t\t\"totalForeignCgOtherMethod\": null,\n\t\t \t\t\"totalForeignDiscountedCgFtc\": null,\n\t\t \t\t\"totalForeignCgIndexationMethodFtc\": null,\n\t\t \t\t\"totalForeignCgOtherMethodFtc\": null,\n\t\t \t\t\"totalDistributedCg\": 2.60,\n \t\t\t\t\"totalNetCg\": 1.31\n\t\t \t},\n\t\t \t\"otherComponents\":\n\t\t \t{\n\t\t \t\t\"totalAssessableForeignSourceIncome\": 31.31,\n\t\t \t\t\"totalOtherNetForeignSourceIncome\": null,\n\t\t \t\t\"totalForeignIncomeTaxCredits\": 5.46,\n\t\t \t\t\"totalAusFrankingCreditsFromNz\": null,\n\t\t \t\t\"totalTaxExempt\": null,\n\t\t \t\t\"totalTaxFree\": null,\n\t\t \t\t\"totalTaxDeferred\": null,\n\t\t \t\t\"totalAmitCostBaseNetIncreaseShortfall\": null,\n\t\t \t\t\"totalAmitCostBaseNetDecreaseExcess\": 10.17,\t\n\t\t \t\t\"totalLessTfnAmountsWithheld\": null,\n\t\t \t\t\"totalLessOtherExpenses\": null\n\t\t \t},\n \t\t\t\"incomeEntries\":\n \t\t\t[\n \t\t\t\t{\n \t\t\t\t\t\"transactionDate\": \"30/06/2020\",\n \t\t\t\t\t\"payment\": 0.00,\n \t\t\t\t\t\"taxableIncome\": 89.29,\n \t\t\t\t\t\"nonPrimaryProductionIncome\":\n\t\t\t\t {\n\t\t\t\t\t \"frankedDividends\": 140.88,\n\t\t\t\t\t \"unfrankedDividends\": 44.24,\n\t\t\t\t\t \"grossInterest\": 3.12,\n\t\t\t\t\t \"otherIncome\": 0.32,\n\t\t\t\t\t \"lessOtherAllowableTrustDeductions\": null,\n\t\t\t\t\t \"frankingCredits\": 67.72,\n\t\t\t\t\t \"nonPrimaryProductionIncome\": 188.56\n\t\t\t\t \t},\n\t\t\t\t \t\"capitalGains\":\n\t\t\t\t \t{\n\t\t\t\t \t\t\"discountedCgAfterDiscount\": 2.59,\n\t\t\t\t \"discountedCgNtarpAfterDiscount\": null,\n\t\t\t\t \t\t\"discountRate\": \"1/2\",\n\t\t\t\t \t\t\"cgtConcessionAmount\": 1.29,\n\t\t\t\t \t\t\"cgIndexationMethod\": null,\n\t\t\t\t \"cgIndexationMethodNtarp\": null,\n\t\t\t\t \t\t\"cgOtherMethod\": 0.02,\n\t\t\t\t \"cgOtherMethodNtarp\": null,\n\t\t\t\t \t\t\"foreignDiscountedCgAfterDiscount\": null,\n\t\t\t\t \t\t\"foreignCgIndexationMethod\": null,\n\t\t\t\t \t\t\"foreignCgOtherMethod\": null,\n\t\t\t\t\t\t\t\t\"foreignDiscountedCgFtc\": null,\n \t\t\t\t\t\t\"foreignCgIndexationMethodFtc\": null,\n \t\t\t\t\t\t\"foreignCgOtherMethodFtc\": null,\n \t\t\t\t\t\t\"distributedCg\": 2.60,\n \t\t\t\t\t\t\"netCg\": 1.31\n\t\t\t\t \t},\n\t\t\t\t \t\"otherComponents\":\n\t\t\t\t \t{\n\t\t\t\t \t\t\"assessableForeignSourceIncome\": 31.31,\n\t\t\t\t \t\t\"otherNetForeignSourceIncome\": null,\n\t\t\t\t \t\t\"foreignIncomeTaxCredits\": 5.46,\n\t\t\t\t \t\t\"ausFrankingCreditsFromNz\": null,\t\n\t\t\t\t \t\t\"taxExempt\": null,\n\t\t\t\t \t\t\"taxFree\": null,\n\t\t\t\t \t\t\"taxDeferred\": null,\n\t\t\t\t \t\t\"amitCostBaseNetIncreaseShortfall\": null,\n\t\t\t\t \t\t\"amitCostBaseNetDecreaseExcess\": 10.17,\t\n\t\t\t\t \t\t\"lessTfnAmountsWithheld\": null,\n\t\t\t\t \t\t\"lessOtherExpenses\": null\n\t\t\t\t \t}\n\n\t\t\t\t },\n\t\t\t\t {\n \t\t\t\t\t\"transactionDate\": \"30/06/2020\",\n \t\t\t\t\t\"payment\": 0.00,\n \t\t\t\t\t\"taxableIncome\": 89.29,\n \t\t\t\t\t\"nonPrimaryProductionIncome\":\n\t\t\t\t {\n\t\t\t\t\t \"frankedDividends\": null,\n\t\t\t\t\t \"unfrankedDividends\": null,\n\t\t\t\t\t \"grossInterest\": 2.90,\n\t\t\t\t\t \"otherIncome\": 7.17,\n\t\t\t\t\t \"lessOtherAllowableTrustDeductions\": null,\n\t\t\t\t\t \"frankingCredits\": 89.85,\n\t\t\t\t\t \"nonPrimaryProductionIncome\": 234.05\n\t\t\t\t \t},\n\t\t\t\t \t\"capitalGains\":\n\t\t\t\t \t{\n\t\t\t\t \t\t\"discountedCgAfterDiscount\": 2.59,\n\t\t\t\t \"discountedCgNtarpAfterDiscount\": null,\n\t\t\t\t \t\t\"discountRate\": \"1/2\",\n\t\t\t\t \t\t\"cgtConcessionAmount\": 1.29,\n\t\t\t\t \t\t\"cgIndexationMethod\": null,\n\t\t\t\t \"cgIndexationMethodNtarp\": null,\n\t\t\t\t \t\t\"cgOtherMethod\": 0.02,\n\t\t\t\t \"cgOtherMethodNtarp\": null,\n\t\t\t\t \t\t\"foreignDiscountedCgAfterDiscount\": null,\n\t\t\t\t \t\t\"foreignCgIndexationMethod\": null,\n\t\t\t\t \t\t\"foreignCgOtherMethod\": null,\n\t\t\t\t\t\t\t\t\"foreignDiscountedCgFtc\": null,\n \t\t\t\t\t\t\"foreignCgIndexationMethodFtc\": null,\n \t\t\t\t\t\t\"foreignCgOtherMethodFtc\": null,\n \t\t\t\t\t\t\"distributedCg\": 2.60,\n \t\t\t\t\t\t\"netCg\": 1.31\n\t\t\t\t \t},\n\t\t\t\t \t\"otherComponents\":\n\t\t\t\t \t{\n\t\t\t\t \t\t\"assessableForeignSourceIncome\": 5.88,\n\t\t\t\t \t\t\"otherNetForeignSourceIncome\": null,\n\t\t\t\t \t\t\"foreignIncomeTaxCredits\": 0.80,\n\t\t\t\t \t\t\"ausFrankingCreditsFromNz\": null,\t\n\t\t\t\t \t\t\"taxExempt\": null,\n\t\t\t\t \t\t\"taxFree\": null,\n\t\t\t\t \t\t\"taxDeferred\": null,\n\t\t\t\t \t\t\"amitCostBaseNetIncreaseShortfall\": null,\n\t\t\t\t \t\t\"amitCostBaseNetDecreaseExcess\": 11.73,\t\n\t\t\t\t \t\t\"lessTfnAmountsWithheld\": null,\n\t\t\t\t \t\t\"lessOtherExpenses\": null\n\t\t\t\t \t}\n\n\t\t\t\t }\t\n \t\t\t]\n \t\t}\t\n \t]\n }\n ]\n}"