...
The security that follows was purchased into entity TaxDemo2, with a Trade Date and Settle Date on 2016040120140401; Par is 1,000,000.00 and it has accrued for 3 days, to 2016040420140404.
The following tables describe the security, entity, and global tax table information used for this example.
...
Global Tax Table Information |
|
|
|
|
|
|
|
|
| |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Begin Date | End Date | Portfolio Country | Issue Country | Entity Tax Type | Entity Tax Qualifier | Issue Tax Type | Primary Exchange | Tax W/H | Tax Reclaim | |||||||||
20090101 | US | UK | MF | Level 1 | All | ALL | 10.00 | 5.00 | ||||||||||
20090101 | US | UK | MF | Level 1 | Standard | London | 7.50 | 2.50 | ||||||||||
20090101 |
| US | UK | MF | Level 1 | Special | ALL | 5.00 | 1.00 | |||||||||
20090101 | US | UK | MF | Level 1 | Special | London | 12.5 | 10.00 |
...
Trade Date | Acct. Date | Tax W/H Rate | Tax Reclaim Rate | Traded Interest Local | Accrual Delta Local | Tax Expense | Tax Reclaim Amount Local | Tax Reclaim Receivable Delta |
---|---|---|---|---|---|---|---|---|
Apr 01 2014 | Apr 01 2014 | 7.500 | 2.500 | 23,055.56 | 138.88 | 1,159.72 | 579.86 | 579.86 |
Apr 02 2014 | Apr 02 2014 | 7.500 | 2.500 | 23,055.56 | 138.89 | 1,166.67 | 583.33 | 3.47 |
Apr 03 2014 | Apr 03 2014 | 7.500 | 2.500 | 23,055.56 | 138.89 | 1,173.61 | 586.81 | 3.48 |
Apr 04 2014 | Apr 04 2014 | 7.500 | 2.500 | 23,055.56 | 138.89 | 1,180.56 | 590.28 | 3.47 |
Apr 05 2014 | Apr 05 2014 | 12.500 | 10.000 | 23,055.56 | 138.89 | 593.75 | 2,375.00 | 1,784.72 |
If the accounting periods are not open for 20140404 and you want to roll back and replay earnings, you have two options, described in the following sections.
In the prior table, the system calculated the Traded Interest amount as follows:
Round ( 1,000,000.00 * 5% / 360 * 166 ) = 23,055.56
This Traded Interest calculation used the following values:
Start of Coupon | Oct 15 2013 |
Settlement Date | Apr 01 2014 |
Days Until Settlement Date | 166 |
Par` | 1,000,000.00 |
Coupon Rate | 5.00 % |
Daily Accrual | 360 |
Days in Period | 166 |
Traded Interest | 23,055.56 |
If the accounting periods are not open for 20140404 and you want to roll back and replay earnings, you have two options.
Option 1 for Rollback and Replay
If the accounting periods are not open for 20140404 and you want to roll back and replay earnings, you can use this option.
Do the following:
- Reopen the prior period and roll back the earning to 20140404.
- Apply the earnings for 20140404.
- Close the period for 20140404.
- Apply the earnings to 20140405.
Option 2 for Rollback and Replay
If the accounting periods are not open for 20140404 and you want to roll back and replay earnings, you can use this option.
Eagle Accounting rolls back earnings to 20140404, and replays the earnings to 20140405. Eagle Accounting still tracks and displays the change in earnings caused by the rollback and replay of earnings with a Trade Date and Earn Thru Date from the event, but displays an Accounting Date of 20140405.
...