Scenario Data
Several scenarios follow. Each scenario uses the data in the following tables.
ENTITY INFORMATION | |||||
---|---|---|---|---|---|
Entity ID | Country of Tax | Accrue Tax Indicator | Tax Accounting Method | Entity Tax Type | Entity Tax Qualifier |
Taxdemo1 | US | No | Gross Income | Trust | Level 1 |
Taxdemo2 | US | No | Gross Liability | Trust | Level 1 |
Taxdemo3 | US | No | Net Income | Trust | Level 1 |
Taxdemo4 | US | Yes | Net Method | Mutual Fund | Level 4 |
Taxdemo5 | US | Yes | Net Method | Mutual Fund | Level 4 |
SECURITY INFORMATION | ||||
---|---|---|---|---|
Primary Asset ID | Issue Country | Issue Tax Type | Primary Exchange | Instrument Type |
Tax Security 1 | AU | Standard | Melbourne | Fixed Income |
Tax Security 2 | AU | Standard | Sydney | Fixed Income |
Tax Security 3 | AU | Standard | Boston | Equity |
Tax Security 4 | GB | Standard | LONDON | Equity |
Tax Security 5 | FR | Avoir | Paris | Equity |
GLOBAL SPECIFIC TAX TABLE INFORMATION | ||||||||
---|---|---|---|---|---|---|---|---|
Begin Date | End Date | Distribution Type | Entity ID | Primary Asset ID | Tax W/H Rate | Tax Reclaim Rate | Avoir Fiscal W/H | Avoir Fiscal Reclaim Rate |
01/01/99 | INTEREST | TAXDEMO1 | Tax Security1 | 20.00 | 5.00 | 0.00 | 0.00 | |
01/01/99 | INTEREST | TAXDEMO5 | Tax Security | 10 | 5.00 | 0.00 | 0.00 |
GLOBAL OVERRIDE TAX TABLE INFORMATION | |||||
---|---|---|---|---|---|
Begin Date | End Date | Dist Type | Entity ID | Asset Country | Issue Tax Type |
01/01/99 | INTEREST | TAXDEMO 2 | AU | STANDARD | |
01/01/88 | DIVIDEND | TAXDEMO5 | UK | STANDARD |
GLOBAL TAX TABLE INFORMATION | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Begin Date | End Date | Override Ind | Dist Type | Entity Country | Asset Country | Entity Tax Type | Entity Qualifier | Tax Asset Type | Primary Exchange | Tax W/H Rate | Tax Reclaim Rate | Avoir Fiscal W/H | Avoir Fiscal |
01/01/99 | N | INT | US | AU | Trust | Level 1 | STD | Melbourne | 20 | 5 | 0 | 0 | |
01/01/99 | N | INT | US | AU | Mutual Fund | Level 1 | ALL | ALL | 15.5 | 0 | 0 | 0 | |
01/01/99 | N | INT | US | AU | Mutual Fund | Level 2 | ALL | ALL | 16.5 | 8.5 | 0 | 0 | |
01/01/99 | N | INT | US | AU | Mutual Fund | Level 3 | ALL | ALL | 10.5 | 2.5 | 0 | 0 | |
01/01/99 | N | INT | US | AU | Mutual Fund | Level 3 | ALL | ALL | 5.5 | 1.0 | 0 | 0 | |
01/01/99 | N | INT | US | AU | Mutual Fund | All | ALL | ALL | 19.40 | 0 | 0 | 0 | |
01/01/99 | N | INT | US | AU | All | All | ALL | ALL | 50 | 25 | 0 | 0 | |
01/01/99 | Y | DIV | US | GB | Mutual Fund | Level 4 | STD | ALL | 15 | 5 | 0 | 0 | |
01/01/99 | N | DIV | US | FR | Mutual Fund | All | ALL | ALL | 0 | 0 | 15 | 40 |
Scenario 1
Entities Taxdemo1, Taxdemo2, and Taxdemo3 all own a long position of Tax Security1. At the time of the Coupon Due Date, starting from January 1, 1999, the following tax withholding and reclaim rates are applied.
Example A. Entity Taxdemo1
Although there is a direct match for the entity Taxdemo1 and Tax Security1 in the Global Specific Tax table, zero Tax Rates and zero Reclaim Rates are applied for the Taxdemo1 entity. The reason for this is that the entity is set up with a Gross Income Tax Accounting Method. The gross income tax method tells Eagle Accounting not to apply tax withholding and tax reclaim.
Example B. Entity Taxdemo2
Zero Tax Withholding and Tax Reclaim rates are applied to the coupon:
- The first step involved in this decision process is that Eagle Accounting searches the Global Specific Tax table, and finds no match in the table for the combination of entity Taxdemo2 and Primary Asset ID Tax Security1.
- Because Eagle Accounting does not find a match in the Global Specific Tax table, Eagle Accounting then queries the Global Override Tax table for a match.
- In the Global Override Tax table, Eagle Accounting does find a match for the entity/security combination, and effective date of coupon payment (entity Taxdemo2, security Tax Security1, and effective date January 1 1999). Also, Tax Security1 has an Issue Tax Type of Standard, an Issue Country of Australia (AU), and a coupon payment date of January 1,1999.
- Because an applicable match was found in the Global Override Tax table, Eagle Accounting then searches for an applicable match in the Global Tax table, where the Override Tax Indicator is set to Yes.
- An exact match is not found in the Global Tax table. There is one row where the Override Indicator is set to Yes, it is the second to last row of the Global Tax table. However, this row did not meet all of the criteria, only those shown with a check mark below.
- Override Indicator is set to Yes
- Distribution Type equals Interest
- Entity Country is US
- Asset Country is AU
- Entity Tax Type is Trust
- Entity Qualifier is Level 1 or All
- Issue Tax Type is Standard or All
- Primary Exchange is Melbourne or All
- Because there is not an applicable match in the Global Tax table, where the Override Indicator is set to Yes, Eagle Accounting applies a zero Tax Withholding Reclaim Rate.
Example C. Entity Taxdemo3
20% Withholding and 5% Reclaim are applied to the coupon. This occurs because:
- First, there is no match in the Global Specific Tax table.
- There is no match in the Global Override Tax table.
- Eagle Accounting then searches the Global Tax table for the best possible match.
- Eagle Accounting finds a direct match (first row in Global Tax table above) for the:
- Entity Tax Type (Trust)
- Entity Tax Qualifier (Level 1)
- Entity Country (US)
- Issue Tax Type (Standard)
- Asset Country (AU)
- Primary Exchange (Melbourne)
Scenario 2
Entity Taxdemo4 Example
Taxdemo4 owns a long position of Tax Security2. During the accrual process starting from January 1, 1999, the following tax withholding and reclaim rates are applied:
19.4% Tax Withholding and 0% Reclaim are applied at the time of accrual processing.
- The first step involved in this decision process is to confirm that there is no match in the Specific Global Tax table, nor is there a match in the Global Override Tax table.
- Eagle Accounting then searches the Global Tax table for the best possible match. The best possible match follows:
- Entity Tax Type (Mutual Fund)
- Entity Tax Qualifier (Level 4)
- Entity Country (U.S.)
- Issue Tax Type (All) (See note)
- Issue Country (AU)
- Primary Exchange (All) (See note)
Info |
---|
The All value is used as a wild card to represent all possible values for this field. Note that entering All as a wildcard in the Entity Tax Type field does not work, because Eagle Accounting requires a direct match in this field. |
Scenario 3
Entity Taxdemo5 Example
Entity Taxdemo5 owns a long position of Tax Security2.
During the accrual process starting from January 1, 1999, 10% Tax Withholding and 5% Reclaim Rate are applied to Tax Security2 for the entity Taxdemo5.
This occurs because Eagle Accounting finds a direct match for this security and entity combination in the Global Specific Tax table.
Scenario 4
Entity Taxdemo4 and Entity Taxdemo5 both own Tax Security4 (equity). At the time of a dividend Eagle Accounting applies the following tax withholding and tax reclaim dividends:
- Eagle Accounting applies a 15.5% Tax Withholding rate, and a 5% Tax Reclaim rate.
- Eagle Accounting applies these rates when an entity and security match is not found in the Global Specific Tax Rate table.
- Eagle Accounting does find an Entity, Issue Tax Type, Distribution Type, and Issue Country match in the Global Tax Override table.
- Eagle Accounting then searches the Global Tax table for the best possible match where the Override Indicator is set to Yes. Eagle Accounting finds the best possible match with:
- Entity Tax Type of Mutual Fund
- Entity Tax Qualifier of Level 4
- Entity Country of US
- Issue Tax Type of Standard
- Issue Country of GB
- Primary Exchange of All
- Eagle Accounting applies a Tax Withholding rate of 0.0% and a Tax Reclaim rate of 0.0%.
- This occurs because Eagle Accounting does not find a match in either the Global Specific Tax table, or in the Global Override Tax table.
- Eagle Accounting then searches the Global Tax table for the best possible match where the Override Indicator is set to No. Eagle Accounting does not find a match, so the Tax Reclaim Rate is set to 0.
Scenario 5
Entity Taxdemo5 owns security short position of Tax Security5. At the time a dividend is created:
- No tax withholding is applied. Eagle Accounting does not apply Tax Withholding and Tax Reclaim rates for short positions; therefore, the dividend payable record is created with 0% Tax Withholding and 0% Tax Reclaim rate.