Spreadsheet: 863029d1710592963-what-is-the-best-formula-to-get-an-input-of-date-based-on-bd-close-calendar_2024
Sheet: Close Calendar

External Close Calendar
Full Year Deliverables |  | March
Month/Quarter/Annual Tag | Monthly | Quarterly | Annual
Monthly/Quarterly/Annual | Business Day  Day | Date | Item | Stakeholder | Contact | Recipient | Status | Comments/Notes
Quarterly | 0 |  | Schedule Quarterly Meetings (Month prior qtr close) | Actuarial Valuations | [NAME]
Quarterly | 4 |  | Full Quarterly Settlement sheet:  [NAME]/First British Vermont II LGRe | Actuarial Valuations | [NAME]
Quarterly | 4 |  | Full Quarterly Settlement sheet:  [NAME] and FBVRC IV LGRe | Actuarial Valuations | [NAME]
Quarterly | 4 |  | Full Quarterly Settlement sheet:  LGAS - Adams III-VIII, X-XI | Actuarial Valuations | [NAME]
Quarterly | 4 |  | Full Quarterly Settlement sheet:  LGAS (Washington/Adams) | Actuarial Valuations | [NAME]
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Monthly | 2 |  | Protection L&G recharges |  | Elmer Quintanilla
Monthly | 4 |  | Interface:  Stat/GAAP Reinsurance ceded premium and commission allowance due and unpaid, summary file to Finance | ASU Reinsurance | PJ Wuor/Anthony Rudez, [NAME]
Monthly | 4 |  | Reinsurance ceded premium with recoverable taxes (balances and dates billed) | ASU Reinsurance | PJ Wuor/Anthony Rudez, [NAME]
Monthly | 1 |  | PRT NB Premium | IFRS 17 Team | [NAME]
Quarterly | 2 |  | Walnut - IFRS 17 Deliverable | IFRS 17 Team | [NAME]
Monthly | 2 |  | Data Contracts:  LGA Reference Data – Financial Product [NAME] (DC41) | IFRS 17 Team | EDW Pradeep Kumar
Monthly | 3 |  | Gross Due Epicor data (i.e., 40001, 41001, 41003) | IFRS 17 Team | [NAME]
Monthly | 3 |  | IBNR Epicor data (i.e., 60001) | IFRS 17 Team | [NAME]
Monthly | 7 |  | Investment Expenses data from Epicor | IFRS 17 Team | [NAME]
Monthly | 8 |  | Data Contracts:  LGA Gross Financial Transactions – Contract Level (DC350) | IFRS 17 Team | EDW Pradeep Kumar
Monthly | 8 |  | Data Contracts:  LGA Gross Financial Transactions – UoA Level (DC349) | IFRS 17 Team | EDW Pradeep Kumar
Monthly | 8 |  | Data Contracts:  LGA Reference Data – Transaction Type Mapping (DC344) | IFRS 17 Team | EDW Pradeep Kumar
Monthly | 9 |  | Data Contracts:  LGA Reinsurance Financial Transactions – Contract Level (DC351) | IFRS 17 Team | EDW Pradeep Kumar
Monthly | 9 |  | Data Contracts:  LGA Reinsurance Financial Transactions – UoA Level (DC352 | IFRS 17 Team | EDW Pradeep Kumar
Monthly | 10 |  | Data Contracts:  Anaplan Functional Expense Allocation (DC146) | IFRS 17 Team | EDW Pradeep Kumar
Quarterly | 10 |  | Data Contracts:  Funds Withheld Data Provisioning DC(245) | IFRS 17 Team | EDW Pradeep Kumar
Annual | 10 |  | Expense Summary to Valuation | IFRS 17 Team | [NAME]
Annual
Monthly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Monthly
Quarterly
Quarterly
Monthly
Annual
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Monthly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Monthly
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Quarterly
Quarterly
Monthly
Monthly
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Annual
Monthly
Monthly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly
Quarterly