Summary Schedule Detail Reports

You can access summary schedule detail reports in Eagle Insurance using the left navigation pane options under Accounting Center > Insurance > Control Reports > Reconciliation.

Schedule D – Part 1A – Section 1 – Detail Report

The Schedule D1A1 Detail report displays the cash flow distribution for each asset in a portfolio by Major Types and NAIC Designations. The cash flow values generated by the STAR Cash Projection Viewer are reconciled to the Book/Adjusted Carrying Value stored in the Insurance warehouse, for each asset, with variances identified.

Schedule D – Part 1A – Section 2 – Detail Report

The Schedule D1A2 Detail displays the cash flow distribution for each asset in a portfolio by Major Types and Subtype of Issues. These cash flow values that are generated by the STAR Cash Projection Viewer are reconciled to the Book/Adjusted Carrying Value stored in the ISTAR database for each asset, with variances identified.

Schedule D – Part 1B Detail Report

The Schedule D1B Detail report displays the contributions on Schedule D – Part 1B, for each asset in a portfolio.

Exhibit of Capital Gains (ECG) Detail Report

The ECG Detail report displays the capital gains/losses, other realized adjustments, such as impairments, and the change in unrealized capital gains/losses at the asset level for a client or entity. The assets are grouped by security type, as defined on the Summary Exhibit of Capital Gains/(Losses).

Interest Maintenance Reserve (IMR) Detail Report

The IMR Detail report displays the year-by-year Interest Maintenance Reserve gain/(loss) contribution, for each asset in a portfolio.

Risk Based Capital (RBC) Detail Report

The RBC Detail report reflects the RBC Requirement contribution of assets based on the asset type and the asset's NAIC rating, by applying factors to the Book/Adjusted Carrying Value of positions. Assets with higher NAIC ratings are assigned increasingly higher factors, and, as a result, a greater percentage of their value is added to the RBC Requirement.

Statutory Disclosure Detail Report

The Statutory Disclosure Detail report displays the various realized and unrealized gains and losses at the asset level for a client or entity, grouped by SVO Code, Security Type, time to maturity, and time in a loss position.

Summary Investment Schedule (SIS) Detail Report

The SIS Detail report displays the Summary Investment Schedule contribution, for each asset in a portfolio.

Wash Sales – Footnote 17c Detail Report

The Wash Sales – Footnote 17c Detail report displays the detailed information that supports the summary report. The report provides a lot level breakdown of all transactions identified as wash sales, and the buy transactions that caused the wash sale. The report lists transactions by asset type, including the security, acquisition date of buys, and disposal date of sales. The report displays the entire quantity, book value, cost and gain/(loss) of the transactions and the proportionate amount of each of these values for wash sales that contribute to the totals on the Wash Sales – Footnote 17c summary report.

For each of the financial values, the proportionate amount of each transaction is reported, based on the quantity that has been deemed as wash sales eligible. You can submit this report for any quarterly or annual period for which the Statutory Wash Sales process has been completed. You can filter report results to display only transactions that crossed periods. A cross period transaction is any wash sale where the trade date of the buy that created the wash sale is not in the period used for the report; that is, it is in either (i) the 30 day period prior to the period begin date or (ii) in the 30 day period after the period end date.