Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section provides examples of the rate selection process in Eagle Accounting.

Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px

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
Reclaim Rate

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.

(tick) Override
    • Override Indicator is set to Yes (CHECK MARK)

    • Distribution Type equals Interest

(tick) Entity
    • Entity Country is US (CHECK MARK)

    • Asset Country is AU

    • Entity Tax Type is Trust

    • Entity Qualifier is Level 1 or All

(tick) Issue
    • Issue Tax Type is Standard or All

(tick) Primary
    • (CHECK MARK)

    • Primary Exchange is Melbourne or All (CHECK MARK)

  • 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:

  1. 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

  2. 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.

On this page

Table of Contents
minLevel1
maxLevel2
outlinefalse
indent2 px
typelist
printablefalse