Fund name: Deemed Segregation Test fund
Members:
| Member1 Account Balances | Member2 Account Balances | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Description | Date | Member 1 Amount | Member 2 Amount | Accumulation | Retirement phase unsegregated | Retirement phase segregated | Accumulation | Retirement phase unsegregated | Retirement phase segregated | Income |
| Accumulation balance at 1 July | 01/07/2017 | 500000 | 500000 | |||||||
| Retirement phase unsegregated at 1 July | 800000 | 800000 | ||||||||
| Retirement phase segregated at 1 July | ||||||||||
| Transfer - Member One pension commencement | 08/02/2018 | 500000 | 500000 | 810000 | M2 + 10000 | |||||
| Transaction - Member One gross pension payment | 10/05/2018 | 20000 | 480000 | |||||||
| Transaction- Member Two gross pension payment | 12/05/2018 | 70000 | 480000 | 774322 | M2 + 34322 income | |||||
| Transaction - Member One non-concessional contribution | 01/06/2018 | 100000 | 100000 | 750000 | M1 + 5000 income & M2 - 24322 income | |||||
Download example JSON file here: Example1DeemedSegregation.json
{
"Comments": "This is the Deemed Segregation Scenario",
"Username": "admin@smith.com",
"SourceRef": "xyz.fund456.cert-2018",
"SoftwareProvider": "XYZAdminSoftware",
"Client": {
"FirstName": "John",
"LastName": "Smith",
"CompanyName": "XYZ Accounting Pty Ltd",
"ABN": "97676767373",
"PostalAddress1": "Level 5",
"PostalAddress2": "1 George St",
"Town": "Hobart",
"State": "TAS",
"PostCode": "7000",
"PhoneAreaCode": "03",
"PhoneNumber": "62878797",
"EmailPrimary": "john@smith.com",
"EmailSecondary": null,
"SourceRef": null
},
"Fund": {
"Name": "Deemed Segregation Test Fund",
"ABN": "54807715425",
"FinancialYear": "2017/2018",
"CommencementDate": null,
"WindUpDate": null,
"HasElectedSegregatedAssets": false,
"IsEligibleToUseSegregation": true,
"HasNonArmsLengthIncome": false,
"HasDefinedBenefitPension": false,
"TotalAssetsAt1July": 1300000.00,
"ClosingFundBalance": 1335000.00,
"TrusteeType": "Corporate",
"CorporateTrustee": {
"Name": "ACCESS TESTING PTY LTD",
"ABNACN": "80638816205"
},
"SourceRef": "xyz.fund123",
"FullySegregatedPeriods": [
{
"StartDate": "2018-02-08T00:00:00",
"EndDate": "2018-05-31T00:00:00"
}
],
"Persons": [
{
"FirstName": "John",
"MiddleNames": "",
"LastName": "Lennon",
"DateOfBirth": "1942-10-09T00:00:00",
"JoinDate": null,
"ExitDate": null,
"ExitReason": null,
"IsTrusteeOrDirector": true,
"IsMember": true,
"Accounts": [
{
"AccountRef": "Lennon1",
"AccountType": "Accumulation",
"OpeningBalanceAt1July": 500000.00,
"ClosingBalanceAt30June": 100000.00,
"SourceRef": "abc123"
},
{
"AccountRef": "Lennon2",
"AccountType": "RetirementPhaseUnsegregated",
"OpeningBalanceAt1July": 0.00,
"ClosingBalanceAt30June": 485000.00,
"SourceRef": "abc456"
},
{
"AccountRef": "Lennon3",
"AccountType": "RetirementPhaseSegregated",
"OpeningBalanceAt1July": 0.00,
"ClosingBalanceAt30June": 0.00,
"SourceRef": "abc789"
}
],
"SourceRef": "JLennon001"
},
{
"FirstName": "Paul",
"MiddleNames": "",
"LastName": "McCartney",
"DateOfBirth": "1942-06-18T00:00:00",
"JoinDate": null,
"ExitDate": null,
"ExitReason": null,
"IsTrusteeOrDirector": true,
"IsMember": true,
"Accounts": [
{
"AccountRef": "McCartney1",
"AccountType": "RetirementPhaseUnsegregated",
"OpeningBalanceAt1July": 800000.00,
"ClosingBalanceAt30June": 750000.00,
"SourceRef": "def123"
},
{
"AccountRef": "McCartney2",
"AccountType": "RetirementPhaseSegregated",
"OpeningBalanceAt1July": 0.00,
"ClosingBalanceAt30June": 0.00,
"SourceRef": "def456"
}
],
"SourceRef": "PMcCartney001"
}
],
"ReserveAccount": null,
"InternalTransactions": [
{
"Date": "2018-02-08T00:00:00",
"TransactionType": "PensionCommencement",
"Amount": 500000.00,
"AmountLeftOver": 0.0,
"AmountLeftOverAtEndOfDay": 0.0,
"FromAccountRef": "Lennon1",
"ToAccountRef": "Lennon2",
"SourceRef": "142536"
},
{
"Date": "2018-02-08T00:00:00",
"TransactionType": "AssetSegregation",
"Amount": 500000.00,
"AmountLeftOver": 0.0,
"AmountLeftOverAtEndOfDay": 0.0,
"FromAccountRef": "Lennon2",
"ToAccountRef": "Lennon3",
"SourceRef": "165748"
},
{
"Date": "2018-02-08T00:00:00",
"TransactionType": "AssetSegregation",
"Amount": 810000.00,
"AmountLeftOver": 0.0,
"AmountLeftOverAtEndOfDay": 0.0,
"FromAccountRef": "McCartney1",
"ToAccountRef": "McCartney2",
"SourceRef": "085069"
},
{
"Date": "2018-06-01T00:00:00",
"TransactionType": "AssetUnsegregation",
"Amount": 485000.00,
"AmountLeftOver": 0.0,
"AmountLeftOverAtEndOfDay": 0.0,
"FromAccountRef": "Lennon3",
"ToAccountRef": "Lennon2",
"SourceRef": "689403"
},
{
"Date": "2018-06-01T00:00:00",
"TransactionType": "AssetUnsegregation",
"Amount": 750000.00,
"AmountLeftOver": 0.0,
"AmountLeftOverAtEndOfDay": 0.0,
"FromAccountRef": "McCartney2",
"ToAccountRef": "McCartney1",
"SourceRef": "164938"
}
],
"ExternalTransactions": [
{
"Date": "2018-05-10T00:00:00",
"TransactionType": "GrossPensionPaymentInclPAYG",
"Amount": 20000.00,
"IsAccountEmpty": false,
"AccountRef": "Lennon3",
"SourceRef": "338596"
},
{
"Date": "2018-05-12T00:00:00",
"TransactionType": "GrossPensionPaymentInclPAYG",
"Amount": 70000.00,
"IsAccountEmpty": false,
"AccountRef": "McCartney2",
"SourceRef": "290909"
},
{
"Date": "2018-06-01T00:00:00",
"TransactionType": "NonConcessionalContribution",
"Amount": 100000.00,
"IsAccountEmpty": false,
"AccountRef": "Lennon1",
"SourceRef": "004958"
}
]
}
}Download example XML file here: Example1DeemedSegregation.xml
<?xml version="1.0" encoding="utf-8"?>
<ActuarialCertificateRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<Comments>This is the Deemed Segregation Scenario</Comments>
<Username>admin@smith.com</Username>
<SourceRef>xyz.fund456.cert-2018</SourceRef>
<SoftwareProvider>XYZAdminSoftware</SoftwareProvider>
<Client>
<FirstName>John</FirstName>
<LastName>Smith</LastName>
<CompanyName>XYZ Accounting Pty Ltd</CompanyName>
<ABN>97676767373</ABN>
<PostalAddress1>Level 5</PostalAddress1>
<PostalAddress2>1 George St</PostalAddress2>
<Town>Hobart</Town>
<State>TAS</State>
<PostCode>7000</PostCode>
<PhoneAreaCode>03</PhoneAreaCode>
<PhoneNumber>62878797</PhoneNumber>
<EmailPrimary>john@smith.com</EmailPrimary>
</Client>
<Fund>
<Name>Deemed Segregation Test Fund</Name>
<ABN>54807715425</ABN>
<FinancialYear>2017/2018</FinancialYear>
<CommencementDate xsi:nil="true" />
<WindUpDate xsi:nil="true" />
<HasElectedSegregatedAssets>false</HasElectedSegregatedAssets>
<IsEligibleToUseSegregation>true</IsEligibleToUseSegregation>
<HasNonArmsLengthIncome>false</HasNonArmsLengthIncome>
<HasDefinedBenefitPension>false</HasDefinedBenefitPension>
<TotalAssetsAt1July>1300000.00</TotalAssetsAt1July>
<ClosingFundBalance>1335000.00</ClosingFundBalance>
<TrusteeType>Corporate</TrusteeType>
<CorporateTrustee>
<Name>ACCESS TESTING PTY LTD</Name>
<ABNACN>80638816205</ABNACN>
</CorporateTrustee>
<SourceRef>xyz.fund123</SourceRef>
<FullySegregatedPeriods>
<FullySegregatedPeriod>
<StartDate>2018-02-08T00:00:00</StartDate>
<EndDate>2018-05-31T00:00:00</EndDate>
</FullySegregatedPeriod>
</FullySegregatedPeriods>
<Persons>
<Person>
<FirstName>John</FirstName>
<MiddleNames />
<LastName>Lennon</LastName>
<DateOfBirth>1942-10-09T00:00:00</DateOfBirth>
<JoinDate xsi:nil="true" />
<ExitDate xsi:nil="true" />
<ExitReason xsi:nil="true" />
<IsTrusteeOrDirector>true</IsTrusteeOrDirector>
<IsMember>true</IsMember>
<Accounts>
<Account>
<AccountRef>Lennon1</AccountRef>
<AccountType>Accumulation</AccountType>
<OpeningBalanceAt1July>500000.00</OpeningBalanceAt1July>
<ClosingBalanceAt30June>100000.00</ClosingBalanceAt30June>
<SourceRef>abc123</SourceRef>
</Account>
<Account>
<AccountRef>Lennon2</AccountRef>
<AccountType>RetirementPhaseUnsegregated</AccountType>
<OpeningBalanceAt1July>0.00</OpeningBalanceAt1July>
<ClosingBalanceAt30June>485000.00</ClosingBalanceAt30June>
<SourceRef>abc456</SourceRef>
</Account>
<Account>
<AccountRef>Lennon3</AccountRef>
<AccountType>RetirementPhaseSegregated</AccountType>
<OpeningBalanceAt1July>0.00</OpeningBalanceAt1July>
<ClosingBalanceAt30June>0.00</ClosingBalanceAt30June>
<SourceRef>abc789</SourceRef>
</Account>
</Accounts>
<SourceRef>JLennon001</SourceRef>
</Person>
<Person>
<FirstName>Paul</FirstName>
<MiddleNames />
<LastName>McCartney</LastName>
<DateOfBirth>1942-06-18T00:00:00</DateOfBirth>
<JoinDate xsi:nil="true" />
<ExitDate xsi:nil="true" />
<ExitReason xsi:nil="true" />
<IsTrusteeOrDirector>true</IsTrusteeOrDirector>
<IsMember>true</IsMember>
<Accounts>
<Account>
<AccountRef>McCartney1</AccountRef>
<AccountType>RetirementPhaseUnsegregated</AccountType>
<OpeningBalanceAt1July>800000.00</OpeningBalanceAt1July>
<ClosingBalanceAt30June>750000.00</ClosingBalanceAt30June>
<SourceRef>def123</SourceRef>
</Account>
<Account>
<AccountRef>McCartney2</AccountRef>
<AccountType>RetirementPhaseSegregated</AccountType>
<OpeningBalanceAt1July>0.00</OpeningBalanceAt1July>
<ClosingBalanceAt30June>0.00</ClosingBalanceAt30June>
<SourceRef>def456</SourceRef>
</Account>
</Accounts>
<SourceRef>PMcCartney001</SourceRef>
</Person>
</Persons>
<InternalTransactions>
<InternalTransaction>
<Date>2018-02-08T00:00:00</Date>
<TransactionType>PensionCommencement</TransactionType>
<Amount>500000.00</Amount>
<AmountLeftOver>0</AmountLeftOver>
<AmountLeftOverAtEndOfDay>0</AmountLeftOverAtEndOfDay>
<FromAccountRef>Lennon1</FromAccountRef>
<ToAccountRef>Lennon2</ToAccountRef>
<SourceRef>142536</SourceRef>
</InternalTransaction>
<InternalTransaction>
<Date>2018-02-08T00:00:00</Date>
<TransactionType>AssetSegregation</TransactionType>
<Amount>500000.00</Amount>
<AmountLeftOver>0</AmountLeftOver>
<AmountLeftOverAtEndOfDay>0</AmountLeftOverAtEndOfDay>
<FromAccountRef>Lennon2</FromAccountRef>
<ToAccountRef>Lennon3</ToAccountRef>
<SourceRef>165748</SourceRef>
</InternalTransaction>
<InternalTransaction>
<Date>2018-02-08T00:00:00</Date>
<TransactionType>AssetSegregation</TransactionType>
<Amount>810000.00</Amount>
<AmountLeftOver>0</AmountLeftOver>
<AmountLeftOverAtEndOfDay>0</AmountLeftOverAtEndOfDay>
<FromAccountRef>McCartney1</FromAccountRef>
<ToAccountRef>McCartney2</ToAccountRef>
<SourceRef>085069</SourceRef>
</InternalTransaction>
<InternalTransaction>
<Date>2018-06-01T00:00:00</Date>
<TransactionType>AssetUnsegregation</TransactionType>
<Amount>485000.00</Amount>
<AmountLeftOver>0</AmountLeftOver>
<AmountLeftOverAtEndOfDay>0</AmountLeftOverAtEndOfDay>
<FromAccountRef>Lennon3</FromAccountRef>
<ToAccountRef>Lennon2</ToAccountRef>
<SourceRef>689403</SourceRef>
</InternalTransaction>
<InternalTransaction>
<Date>2018-06-01T00:00:00</Date>
<TransactionType>AssetUnsegregation</TransactionType>
<Amount>750000.00</Amount>
<AmountLeftOver>0</AmountLeftOver>
<AmountLeftOverAtEndOfDay>0</AmountLeftOverAtEndOfDay>
<FromAccountRef>McCartney2</FromAccountRef>
<ToAccountRef>McCartney1</ToAccountRef>
<SourceRef>164938</SourceRef>
</InternalTransaction>
</InternalTransactions>
<ExternalTransactions>
<ExternalTransaction>
<Date>2018-05-10T00:00:00</Date>
<TransactionType>GrossPensionPaymentInclPAYG</TransactionType>
<Amount>20000.00</Amount>
<IsAccountEmpty>false</IsAccountEmpty>
<AccountRef>Lennon3</AccountRef>
<SourceRef>338596</SourceRef>
</ExternalTransaction>
<ExternalTransaction>
<Date>2018-05-12T00:00:00</Date>
<TransactionType>GrossPensionPaymentInclPAYG</TransactionType>
<Amount>70000.00</Amount>
<IsAccountEmpty>false</IsAccountEmpty>
<AccountRef>McCartney2</AccountRef>
<SourceRef>290909</SourceRef>
</ExternalTransaction>
<ExternalTransaction>
<Date>2018-06-01T00:00:00</Date>
<TransactionType>NonConcessionalContribution</TransactionType>
<Amount>100000.00</Amount>
<IsAccountEmpty>false</IsAccountEmpty>
<AccountRef>Lennon1</AccountRef>
<SourceRef>004958</SourceRef>
</ExternalTransaction>
</ExternalTransactions>
</Fund>
</ActuarialCertificateRequest>