Appendix B Deliverables.xlsx
XLSX spreadsheet 55 KB Posted
- Solicitation number
- FA701426_FMF_FIAR
About this file
This document is an Appendix B Deliverables Excel spreadsheet detailing comprehensive deliverable requirements for the Department of the Air Force's Financial Improvement and Audit Remediation (FIAR) contract. The extensive deliverables matrix covers multiple functional areas including A-123 publications, financial statements, reconciliations, risk assessments, service provider monitoring, audit support, and various technical and administrative submissions across assessable units such as General Fund, Working Capital Fund, and Defense Security Cooperation Agency.
Key deliverables include quarterly and annual submissions like Agency Financial Reports, Statement of Assurance packages, Control Evaluation Matrix updates, financial reconciliations, SOC 1 monitoring reports, and various technical documentation. Delivery mechanisms primarily involve email to government points of contact, posting to specific SharePoint sites or Teams channels, and include precise timing requirements ranging from monthly to annual frequencies. The document supports critical financial management functions including audit remediation, internal controls assessment, financial reporting, and comprehensive tracking of financial system improvements across multiple Department of Air Force organizational units.
View the file
Other files
Show all 25
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Deliverables
| Deliverable | Reference | Due Date/Frequency | AU | Delivery | Updates/Notes |
| Updated A-123 Publications (AFPD, AFI, RMIC Playbook/DAFMAN) | PWS Section 2.1a.1 | Annually, Q1 | A-123 | Email to govt POCs | |
| Quarterly Statement of Assurance Submission Packages | PWS Section 2.1a.2 & 2.1a.6.3 | Quarterly |
Q1 ~ 1/24 Q2 ~ 4/03 Q3 ~ 6/26
| Q4 ~ 10/02 | A-123 | Email to govt POCs | As required by OUSD(C) SOA Handbook | |||
| Draft Self Identified Deficiencies (SIDs) | PWS Section 2.1a.3 | As required | A-123 | Email to govt POCs | ||
| Certification Statement Call Letter | PWS Section 2.1a.3 | Annual, Q1 | A-123 | Email to govt POCs | ||
| Annual RMIC Training | PWS Section 2.1a.4 | Annually, Q1 | A-123 | Posted to MyLearning | Modules 1 - 5 are posted to MyLearning. Module 0 is presented live twice to accomodate the organizations in different time zones. Both sessions are recorded and the better of the 2 is posted to the FIAR communications web site for reference. | |
| Summary of Aggregated Deficiencies (SAD) Template | PWS Section 2.1a.5 | Annually, Q3 | A-123 | Email to govt POCs | ||
| Schedule for the full A-123 Cycle | PWS Section 2.1a.6 | Annually, Q4 | A-123 | Email to govt POCs | ||
| DAF General Fund Scoping Document | PWS Section 2.1a.6.1 | Annually, Draft in Q3 and Final in Q1 | A-123 | Email to govt POCs | ||
| Updated Process Cycle Memorandum (PCM) Template | PWS Section 2.1a.6.2 | Annually, Q3 draft and Final in Q4 | A-123 | Data entered into eGRC | ||
| Assessable Unit (AU) PCM Review comments | PWS Section 2.1a.6.2 | Annually ,Q1 | A-123 | Data entered into eGRC | ||
| Updated Control Evaluation Matrix (CEM) Template | PWS Section 2.1a.6.2 | Annually, Q1 | A-123 | Data entered into eGRC | ||
| AU CEM Review comments | PWS Section 2.1a.6.2 | Annually | A-123 | Data entered into eGRC | ||
| Updated Control Testing Workbook Template | PWS Section 2.1a.6.2 | Annually | A-123 | Data entered into eGRC | ||
| Updated Walkthrough Template | PWS Section 2.1a.6.2 | Annually | A-123 | Data entered into eGRC | ||
| Self-Identified Deficiency (SID) Template | PWS Section 2.1a.6.2 | As required | A-123 | Data entered into eGRC | ||
| Updated Entity Level Control (ELC) Testing Matrix | PWS Section 2.1a.6.2 | Annually, Q4 | A-123 | Data entered into eGRC | ||
| ELC Testing results report | PWS Section 2.1a.6.2 | Annually, Q4 | A-123 | Data entered into eGRC | ||
| ELC SIDs | PWS Section 2.1a.6.2 | As required | A-123 | Data entered into eGRC | ||
| Service Provider Stakeholder Contact List | PWS Section 2.1a.7.1 | As required | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Service Provider Monitoring Guide | PWS Section 2.1a.7.10 | Annually | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| OUSD(C) SOC 1 Feedback Result | PWS Section 2.1a.7.12 | As required | Service Provider | Email to govt lead, post to applicable FMFA Teams Channel, and as requested by OUSD(C) | ||
| FIAR IT System Listing | PWS Section 2.1a.7.13 | Annually | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Third-Party Service Provider Annual Update Summary | PWS Section 2.1a.7.14 | Annually | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Service Provider Working Group Slides | PWS Section 2.1a.7.2 | Bi-annually | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| SOC Report and Bridge Letter Tracker | PWS Section 2.1a.7.3 | As required | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Service Provider Assessment Template | PWS Section 2.1a.7.4 | Annually updated, reviewed/completed as required | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Service Provider Assessment Feedback | PWS Section 2.1a.7.4 | As required according to Assessment Timeline | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Service Provider Assessment Timeline | PWS Section 2.1a.7.4 | Annually | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| SOC Monitoring Reports | PWS Section 2.1a.7.5 | Annually | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Automated Service Provider deliverables (development) | PWS Section 2.1a.7.6 | As Required | Service Provider | As requested by AU lead | ||
| Quarterly progress reports on eGRC development | PWS Section 2.1a.7.6 | Quarterly | Service Provider | Maintained on Sharepoint | ||
| OUSD(C) CUEC Summary Assessment Survey | PWS Section 2.1a.7.7 | As required | Service Provider | Email to govt lead, post to applicable FMFA Teams Channel, and as requested in SoA Handbook | ||
| 19 Audit Support MOUs | PWS Section 2.1a.7.8 | Annual, initiate review 60 days prior to expiration date | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Audit Support MOU Tracker | PWS Section 2.1a.7.8 | As required | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Service Provider Module for RMIC Training | PWS Section 2.1a.7.9 | Annual | Service Provider | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Metrics, meeting agendas, briefing materials, and minutes, SOPs, training | PWS Section 2.1a.8, 2.1b.6, 3.6, 4.12, 5.6, 6.12, 7.10, 8.6, 9.1.8 | As requested | All | As requested by AU lead | ||
| WCF A-123 Full Cycle Schedule | PWS Section 2.1b.2 | Annually | WCF A-123 | Email to Government POCs | ||
| WCF Scoping Document | PWS Section 2.1b.3 | Annually | WCF A-123 | Email to Government POCs | ||
| Process Cycle Memorandum (PCM) Updates | PWS Section 2.1b.4 | Annually | WCF A-123 | Email to Government POCs | ||
| Control Evaluation Matrix (CEM) | PWS Section 2.1b.4 | Annually | WCF A-123 | Email to Government POCs | ||
| Control Testing Workbook | PWS Section 2.1b.4 | Annually | WCF A-123 | Email to Government POCs | ||
| Self Identified Deficiencies | PWS Section 2.1b.4 | As required | WCF A-123 | Email to Government POCs | ||
| Test Result Briefing | PWS Section 2.1b.4 | Annually | WCF A-123 | Email to Government POCs | ||
| Service Provider Assessment Workbook | PWS Section 2.1b.5.1 & 2.1b.5.3 | Annually | WCF Service Provider | Email to Government POCs | ||
| CUEC Assessment Summary | PWS Section 2.1b.5.2 | Annually | WCF Service Provider | Email to Government POCs | ||
| Service Provider PCM Updates | PWS Section 2.1b.5.3 | Annually | WCF Service Provider | Email to Government POCs | ||
| Service Provider CEM | PWS Section 2.1b.5.3 | Annually | WCF Service Provider | Email to Government POCs | ||
| Correspondence with Service Providers on Corrective Actions | PWS Section 2.1b.5.4 | As required | WCF Service Provider | Email to Government POCs | ||
| Audit Support MOUs | PWS Section 2.1b.5.5 | Annually | WCF Service Provider | Email to Government POCs | ||
| Trip Report | PWS Section 24.5 | Following official travel, the Contractor shall prepare a trip report detailing the purpose of the trip, the individuals contacted, any agreements that were reached during the trip or any other significant issues that were identified during the travel. The Contractor shall provide this trip report to the COR within 5 business days after the completion of travel | All | Email to govt POCs | ||
| Create Corrective Action Plan (CAP) closure packages | PWS Section 3.1 | As needed | All | As requested by AU lead | ||
| Create new Corrective Action Plan (CAP) records and milestones for newly issued / re-issued Notice of Findings and Recommendations | PWS Section 3.1 | As determined by internal and external policy | All | Government OM&S Teams Site or email, DoD SAFE (Large Files) | ||
| CAP validation package | PWS Section 3.1 | As needed | All | As requested by AU lead | ||
| Update to ODFO database. | PWS Section 3.2 | Monthly | All | As requested by AU lead | ||
| Accelerated Audit Plan (AAP) | PWS Section 3.3 | Bi-weekly | All | Sharepoint | ||
| AAP updates in SharePoint | PWS Section 3.3 | As needed | All | As requested by AU lead | ||
| Metrics | PWS Section 3.4 | Monthly | All | As requested by AU lead | ||
| Metrics | PWS Section 3.5 | Monthly | WCF, DSCA SAA | As requested by AU lead | ||
| Key Supporting Documentation | PWS Section 4.1 | As needed | All | As requested by AU lead | ||
| Audit tools/process training | PWS Section 4.10 | As needed | All | As requested by AU lead | ||
| Helpdesk Capability | PWS Section 4.11 | As needed | All | As requested by AU lead | ||
| Meeting minutes | PWS Section 4.2 | As needed | All | As requested by AU lead | ||
| Update site visit tool in SharePoint | PWS Section 4.3 | As needed | All | As requested by AU lead | ||
| Report generation and PBC/Sample Tool updates | PWS Section 4.4 | As needed | All | As requested by AU lead | ||
| SOPs | PWS Section 4.5 | As needed | All | As requested by AU lead | ||
| Update to SharePoint tools | PWS Section 4.6 | As needed | All | As requested by AU lead | ||
| Update to SharePoint tools | PWS Section 4.7 | As needed | All | As requested by AU lead | ||
| Update to SharePoint tools | PWS Section 4.8 | As needed | All | As requested by AU lead | ||
| Briefings | PWS Section 4.9 | As needed | All | As requested by AU lead | ||
| OMB A-136 compliance review | PWS Section 5.1 | Annual , 1 September | FSCR | Email to govt POCs | ||
| Agency Financial Report (AFR) schedule | PWS Section 5.1.1 | Annual , 30 March | FSCR | Email to govt POCs | ||
| Reconciliation of DDRS financial statements and footnotes to AFR | PWS Section 5.1.10 | Annual, 23 October | FSCR | Email to govt POCs | ||
| Final AFR | PWS Section 5.1.11 | Annual, November | FSCR | Email to govt POCs | ||
| AFR status updates | PWS Section 5.1.2 | Bi-weekly (until 15 July); Weekly (15 July- 15 Nov) | FSCR | Email to govt POCs | ||
| AFR theme options and outline | PWS Section 5.1.3 | Annual , 31 May | FSCR | Email to govt POCs | ||
| Draft Management’s Discussion and Analysis (MD&A) | PWS Section 5.1.4 | Annual, 1 Aug | FSCR | Email to govt POCs | ||
| Draft Agency Head Letter | PWS Section 5.1.5 | Annual, 15 August | FSCR | Email to govt POCs | ||
| Draft CFO Message | PWS Section 5.1.5 | Annual, 15 August | FSCR | Email to govt POCs | ||
| Draft Management Response Letters | PWS Section 5.1.5 | Annual, 15 August | FSCR | Email to govt POCs | ||
| Update Management Representation Letters | PWS Section 5.1.6 | Annual 3 October (Final) | FSCR | Email to govt POCs | ||
| Management Schedule of Information (MSI) and reconciliation to the Legal Counsel Response (LCR) Letter | PWS Section 5.1.7 | 13 July (Interim); 6 October (Final) | CLL | Email to govt POCs | ||
| Contingent Legal Liability Report (CLLR) | PWS Section 5.1.7 | Quarterly | CLL | Email to govt POCs | ||
| Administrative Claim Payout Analysis | PWS Section 5.1.7 | Quarterly | CLL | Email to govt POCs | ||
| Roll forward contingent legal liability analysis | PWS Section 5.1.7 | Quarterly | CLL | Email to govt POCs | ||
| Retrospective Analysis | PWS Section 5.1.7 | Quarterly | CLL | Email to govt POCs | ||
| Judgement Fund Analysis | PWS Section 5.1.7 | Quarterly | CLL | Email to govt POCs | ||
| Draft Financial Statement footnotes and respective templates | PWS Section 5.1.8 | Quarters 3 and 4 by 17th Business Day | FSCR | Email to govt POCs | ||
| Draft AFR | PWS Section 5.1.9 | Annual, 23 October | FSCR | Email to govt POCs | ||
| Draft quarterly variance analysis requiring explanations | PWS Section 5.3.1 | 15th Business Day (Q1-Q3); 18th Calendar Day (Q4) | FSCR | Email to govt POCs | ||
| Final quarterly variance analysis with explanations | PWS Section 5.3.2 | 15th Business Day (Q1-Q3); 18th Calendar Day (Q4) | FSCR | Email to govt POCs | ||
| Consolidated historical variance explanations | PWS Section 5.3.3 | 17th Business Day (Q1-Q3); 20th Calendar Day (Q4) | FSCR | Email to govt POCs | ||
| Data Calls and Quarterly Data Call tracker | PWS Section 5.4 | Quarterly | FSCR | Email to govt POCs | ||
| Federal Accrual and prepare JV packages for review and submission | PWS Section 5.4 | Quarterly | RBAE | Email to govt POCs and posted to joint FMFA SBR Teams Channel | ||
| Public Accrual and prepare JV packages for review and submission | PWS Section 5.4 | Quarterly | MOCAS and Vendor Pay | Email to govt POCs and posted to joint FMFA SBR Teams Channel | ||
| Quarterly, prepare Journal Vouchers (JVs) and Prior Period Adjustments (PPAs) as needed | PWS Section 5.4 | Quarterly | All | As requested by AU lead | ||
| MOCAS Accrual Validation | ||||||
| (AP Aging analysis) | PWS Section 5.5 | Monthly | MOCAS | Email to govt POCs and posted to the O: Drive Folder | ||
| DDRS-B MOCAS Accrual Journal Voucher Reconciliation and Testing | PWS Section 5.5 | Quarterly | MOCAS | Email to govt POCs and posted to the O: Drive Folder | ||
| JV review documentation and root cause analysis | PWS Section 5.5 | Monthly | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website | ||
| Financial statement review process which include trial balance reviews, DDRS reconciliation suite analysis, and financial statement and footnote schedule reviews (Development). | PWS Section 5.7 | As Applicable | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website | ||
| Federal trading partner seller side template and reconciliation of Advana outputs | PWS Section 5.8.1 | Quarterly | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website | ||
| Federal trading partner reconciliation of transfers to APSR data (Development). | PWS Section 5.8.2 | Quarterly | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website | ||
| Federal buyer side trading partner reconciliation of payables, expenses and advances and data calls for supported JV accruals (Development). | PWS Section 5.8.3 | Quarterly | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website | ||
| FRPG Standard Operating Procedure Guide (development) | PWS Section 5.9.1 | Annually | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | ||
| FRPG Templates, Guides, Reports, Training materials (development) | PWS Section 5.9.1 | Annually | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | ||
| FRPG Project Plan (development) | PWS Section 5.9.1 | Annually | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Feedback/Revisions for Draft Acct Policy Data Calls | PWS Section 5.9.2 | As Required | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | ||
| Tracking system/tool to identify responsible Air Force policy implementation owners | PWS Section 5.9.3 | Weekly | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | https://fasab.gov/accounting-standards/ |
https://www.whitehouse.gov/omb/information-resources/guidance/circulars/ https://comptroller.defense.gov/FMR.aspx
| Oversight process for quality reviews and remediation plans (development) | PWS Section 5.9.3 | As Required | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | |
| White paper template for gap analysis documentation (development) | PWS Section 5.9.3 | As Required | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | |
| OUSD FMPR Tool Tracker | PWS Section 5.9.3 | Weekly | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | |
| Policies and procedures for oversight of accounting standard implementation (development) | PWS Section 5.9.4 | Quarterly, or as needed when developed | FRPG | Maintained on Sharepoint | |
| Templates for documenting ownership and implementation (development) | PWS Section 5.9.4 | Quarterly, or as needed when developed | FRPG | Maintained on Sharepoint | |
| Unimplemented Standards Tracker | PWS Section 5.9.4 | Quarterly | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | |
| White papers documenting ownership and accounting standards implementation at DAF level (development) | PWS Section 5.9.4 | Quarterly, or as needed when developed | FRPG | Maintained on Sharepoint | |
| GAO Financial Audit Manual (FAM) Volume 3 Checklist | PWS Section 5.9.5 | Annually | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | |
| FASAB Board Meeting Minutes and Deliverables | PWS Section 5.9.6 | Quarterly | FRPG | Email to govt lead and post to applicable FMFA Teams Channel | |
| SFFAS Compliant Solutions (development) | PWS Section 6.1 and 6.2 | As Needed | MCA | As requested by AU lead | |
| SFFAS Compliant Solution (development) | PWS Section 6.10 | Ad hoc | MCA | As requested by AU Lead | |
| Develop quarterly GPP&E on-top JVs and PPAs | PWS Section 6.11 | Quarterly | MCA | As requested by AU Lead | |
| Meeting minutes for Executive Level meetings | PWS Section 6.13 | Ad hoc | All | As requested by AU lead | |
| Support the development of executive level briefings and metrics for monitoring and oversight. | PWS Section 6.13 | As needed | MCA | As requested by AU Lead | |
| Prepare annual Significance Analysis for OM&S AUs under Purchase Method. | PWS Section 6.2 | Due Date: Annually, by email to govt POCs and posted to joint TEAMS Repository | OM&S | As requested by AU lead | |
| Develop and execute Roll Forwards | PWS Section 6.2 | Quarterly | MCA | As requested by AU lead | |
| Develop and execute Point to Point Reconciliations | PWS Section 6.2 | Monthly | MCA | As requested by AU lead | |
| Develop a Management Review Checklist | PWS Section 6.2 | Monthly | MCA | As requested by AU lead | |
| Develop and execute Materiality Calculations | PWS Section 6.2 | Annually | MCA | As requested by AU lead | |
| Roll Forward Reconciliations | PWS Section 6.2 | Monthly | WCF Inventory | AF VAULT | |
| SFFAS Compliant Solution (development) | PWS Section 6.2 | As needed | MCA | As requested by AU lead | |
| Develop and execute Data Quality Reconciliations | PWS Section 6.2 and 6.8.1 | Monthly | MCA | As requested by AU lead | |
| SFFAS Compliant automated solution (development) | PWS Section 6.3 | Ad hoc | MCA | As requested by AU Lead | |
| Assets are entered into the approved DAF APSR | PWS Section 6.4 | Ad hoc | MCA | As requested by AU Lead | |
| Monthly/Quarterly Reconciliations | PWS Section 6.5 | Monthly, Quarterly | MCA | As requested by AU Lead | |
| 1010 Budgetary Reconciliation | PWS Section 6.6.1 | Annual, Q4 | GF FBwT | Post to FBwT Teams Channel | |
| MOCAS Disb to DCMS to GAFS-BQ Reconciliation | PWS Section 6.6.1 | Quarterly | GF FBwT | Post to FBwT Teams Channel | Separate recons for USSF and USAF to GAFS-BQ and DEAMS |
| DCMS to GL Reconciliations | PWS Section 6.6.1 | Quarterly | GF FBwT | Post to FBwT Teams Channel | Separate recons for USSF and USAF to GAFS-BQ and DEAMS |
| MAFR to GAFS-R Reconciliation | PWS Section 6.6.1 | Quarterly | GF FBwT | Post to FBwT Teams Channel | Separate recons for USSF and USAF |
| CDS to GL Reconciliations | PWS Section 6.6.1 | Quarterly | GF FBwT | Post to FBwT Teams Channel | Separate recons for USSF and USAF to GAFS-BQ and DEAMS |
| DIL to GL Reconciliations | PWS Section 6.6.1 | Quarterly | GF FBwT | Post to FBwT Teams Channel | Separate recons for USSF and USAF to GAFS-BQ and DEAMS |
| DTIM to GL Reconciliations | PWS Section 6.6.1 | Quarterly | GF FBwT | Post to FBwT Teams Channel | Separate recons for USSF and USAF to GAFS-BQ and DEAMS |
| DDS to GL Reconciliation | PWS Section 6.6.1 | Quarterly | GF FBwT | N/A - This reconciliation is in development. | |
| Source system to GL reconciliations. | PWS Section 6.6.1 | Monthly/Quarterly | FBWT | As requested by AU lead | |
| CivPay Reperformance | PWS Section 6.6.2 | One month per quarter | GF FBwT | Post to FBwT Teams Channel | |
| 7113 Reperformance | PWS Section 6.6.2 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| DEAMS TDD Reperformance | PWS Section 6.6.2 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| MOCAS Reperformance | PWS Section 6.6.2 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| MOCAS 600B to CARS reconciliation | PWS Section 6.6.2 | Monthly | GF FBWT | As requested by AU lead | |
| DDS Reperformance | PWS Section 6.6.2 | Monthly | FBWT | N/A - This is a potential compensating control required to maintain sustainment if DDS activity becomes material in FY25. | The Disbursing SOC-1 for FY25 did not include DDS. As the transition from CDS to DDS is expected to be completed by year end, a potential DDS reperformance control may need to be developed to address any IT-related observations. |
| Suspense Materiality Assessment Oversight | PWS Section 6.6.3 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| SOD Materiality Assessment Oversight | PWS Section 6.6.3 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| Deposit Management Analysis Oversight | PWS Section 6.6.3 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| CivPay SOD Oversight (DSSN 8522) | PWS Section 6.6.3 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| Deposits in Transit SOD Oversight | PWS Section 6.6.3 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| DAF GF SOD Assessment and Note 3 Review | PWS Section 6.6.3 | Semi-annual (Q3 and Q4) | GF FBwT | Post to FBwT Teams Channel | |
| MOCAS System Parameter Assessment/MOCAS to CEDMS | PWS Section 6.6.3 | Semi-annual (January and July) | GF FBwT | Post to FBwT Teams Channel | |
| SCRT Risk Assessment | PWS Section 6.6.3 | Semi-annual (Q2 and Q4) | GF FBwT | Post to FBwT Teams Channel | |
| Perform oversight control and materiality assessments. | PWS Section 6.6.3 | Monthly/Quarterly | FBWT | As requested by AU lead | |
| Develop, update, and maintain processes and procedures for ingestion of DAF data into Advana | PWS Section 6.6.4 | As needed | FBWT | As requested by AU lead | |
| DSSN Analysis | PWS Section 6.6.5 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| Interfund Analysis | PWS Section 6.6.5 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| Trend Analytic | PWS Section 6.6.5 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| Undistributed to FBwT Recon Lookback Analysis | PWS Section 6.6.5 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| Undistributed to FBwT Recon Lookback Analysis- Baseline Review | PWS Section 6.6.5 | Annual | GF FBwT | As requested by AU lead | |
| Advana FBwT Recon Source File Validation | PWS Section 6.6.5 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| Advana FBwT Recon Baseline Code Review | PWS Section 6.6.5 | One-time | GF FBwT | Post to FBwT Teams Channel | |
| Advana FBwT Recon Code Update Analysis | PWS Section 6.6.5 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| Advana FBwT Recon User Access Review | PWS Section 6.6.5 | Quarterly | GF FBwT | Post to FBwT Teams Channel | |
| Advana FBwT Recon Customer MOA review | PWS Section 6.6.5 | Annual | GF FBwT | As requested by AU lead | |
| Advana FBwT Recon CDM/MOA Validation | PWS Section 6.6.5 | Annual | GF FBwT | As requested by AU lead | |
| Advana FBwT Recon Process Narrative Review | PWS Section 6.6.5 | Annual | GF FBwT | Post to FBwT Teams Channel | |
| Advana FBwT Recon Aged Root Cause Analysis | PWS Section 6.6.5 | Monthly | GF FBwT | Post to FBwT Teams Channel | |
| Advana Reperformance | PWS Section 6.6.5 | TBD | GF FBwT | N/A - This is a potential compensating control required to maintain sustainment with the Advana SOC-1exceptions identified. | The Advana SOC-1 had multiple exceptions related to COs the FBwT Recon relies upon. Further compensating controls may need to be developed to address the exceptions. |
| Perform and maintain ADVANA compensating control environment. | PWS Section 6.6.5 | As needed | FBWT | As requested by AU lead | |
| Annual testing | PWS Section 6.6.6 | Annually | FBWT | As requested by AU lead | |
| Implement FBWT required updates to the control environment. | PWS Section 6.6.6 | As needed | FBWT | As requested by AU lead | |
| Cash Worksheet Reperformance Workbook | PWS Section 6.7.1 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Data Validation Workbook | PWS Section 6.7.1 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Change Log and User Access Workbook | PWS Section 6.7.1 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Cash Worksheet Supplemental File Analysis Workbook | PWS Section 6.7.2 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| FSUS Analysis Workbook | PWS Section 6.7.2 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Advana Data Ingestion Reconciliation Workbook | PWS Section 6.7.3 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| SIPR and NIPR Baseline Code Review Workbook | PWS Section 6.7.4 | Annual | WCF FBwT | Post to WCF FBwT Teams Channel | |
| SIPR and NIPR Code Change Log Workbook | PWS Section 6.7.4 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Crosswalk Assessment Workbook | PWS Section 6.7.4 | Annual | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Lookback Analysis Workbook | PWS Section 6.7.4 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Root Cause Analysis Workbook | PWS Section 6.7.4 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Treasury Reporting - CivPay Reperformance Workbook | PWS Section 6.7.5 | Quarterly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Treasury Reporting - 7113 Reperformance Workbook | PWS Section 6.7.5 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Treasury Reporting - MOCAS to CARS Reconciliation Workbook | PWS Section 6.7.5 | Monthly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| DSSN & Interfund Analysis Workbook | PWS Section 6.7.6 | Quarterly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Suspense Materiality Assessment Workbook | PWS Section 6.7.6 | Annually | WCF FBwT | Post to WCF FBwT Teams Channel | |
| SOD Monitoring and Oversight Materiality Assessment Workbook | PWS Section 6.7.6 | Quarterly | WCF FBwT | Post to WCF FBwT Teams Channel | |
| Footnote Review Memorandum for Record | PWS Section 6.7.7 | Annually | WCF FBwT | Post to WCF FBwT Teams Channel | |
| (Monthly) Data Quality Reconciliations, (Quarterly) MEV models | PWS Section 6.8.1 | Monthly, Quarterly | MCA - ME | As requested by AU Lead | |
| Recommend Template Changes | PWS Section 6.8.10 | As needed | MCA | As requested by AU lead | |
| Quarterly CIP Journal Vouchers. | PWS Section 6.8.11 | Quarterly | MCA - ME | As requested by AU Lead | |
| Quarterly CIP Journal Vouchers, Zero Dollar Journal Voucher, and Prior Period Adjustment Journal Vouchers. | PWS Section 6.8.12 | Quarterly | MCA - ME | As requested by AU Lead | |
| MEV Models | PWS Section 6.8.13 | As needed | MCA - ME | As requested by AU lead | |
| MEV Annual Attestation Letter | PWS Section 6.8.14 | Annually | MCA | As requested by AU lead | |
| Valuation Models (development) | PWS Section 6.8.15 | Monthly | MCA | As requested by AU lead | |
| Monthly Metrics (development) | PWS Section 6.8.16 | As needed | MCA | As requested by AU lead | |
| Written recommendations on MEV Data Completeness, drafted self-inspections checklists and updated process guides | PWS Section 6.8.17 | As needed | MCA - ME | As requested by AU Lead | |
| Management Review Checklists, Data Quality Reviews, Roll forwards, system to system reconciliations | PWS Section 6.8.18 | As needed | MCA - ME | As requested by AU lead | |
| Updated Control Evaluation Matrix | PWS Section 6.8.19 | As needed | MCA - ME | As requested by AU lead | |
| MEV models | PWS Section 6.8.2 | Quarterly | MCA - ME (USAF / USSF) | As requested by AU Lead | |
| Overview of ME-Training Materials, Course Instructor Materials, Student training material | PWS Section 6.8.20.1 | As needed | MCA - ME | As requested by AU lead | |
| Training Schedule | PWS Section 6.8.20.2 | As needed | MCA | As requested by AU lead | |
| IML/AML Review Report. | PWS Section 6.8.3 | Annually | MCA - ME | As requested by AU Lead | |
| Quarterly CIP Journal Voucher, Zero Dollar Journal Voucher, Prior Period Adjustments, MEV Model, Acquisition Package | PWS Section 6.8.4 | Quarterly | MCA - ME | As requested by AU Lead | |
| Materiality Calculation Excel Workbook | PWS Section 6.8.5 | Annually | MCA - ME | As requested by AU Lead | |
| Indirect cost models. | PWS Section 6.8.6 | Annually | MCA | As requested by AU lead | |
| Quarterly Code Review Checklist | PWS Section 6.8.7 | Quarterly | MCA - ME | As requested by AU Lead | |
| Quarterly Valuation Package, Mangement Review Checklist, Center Level Review Checklist | PWS Section 6.8.8 | Quarterly | MCA - ME | As requested by AU Lead | |
| Update SharePoint data repository | PWS Section 6.8.9 | Monthly | MCA | As requested by AU Lead | |
| Strategic Plan on a Mid-Tier subledger solution | PWS Section 6.9 | Ad hoc | MCA | As requested by AU Lead | |
| Completeness controls (development) | PWS Section 7.1.1 | As needed | UoT | As requested by AU lead | |
| Quantitative Drill Down | PWS Section 7.1.2 | Monthly | UoT | As requested by AU lead | |
| 4-way system match | PWS Section 7.1.3 | Quarterly | UoT | As requested by AU lead | Excel |
| The Universe of Transactions Framework Population Completeness Guide, dashboards, and visualizations (development) | PWS Section 7.1.4 | As needed | UoT | As requested by AU lead | |
| GAFS-R and DEAMS UoT narratives | PWS Section 7.1.5 | Annually | UoT | As requested by AU lead | |
| Reconciliations (complete list of reconciliations in sustainment can be found in the bidder’s library) | PWS Section 7.2 | As needed | UoT | As requested by AU lead | |
| Reconciliation AFM Airstaff to GAFS-R: Review, Analysis, and Research | PWS Section 7.2 | Monthly | FRAD | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation AFM Airstaff to CEFMS | PWS Section 7.2 | Monthly | UoT | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation AFM MAJCOM to GAFS-R | PWS Section 7.2 | Monthly | UoT | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation AFM MAJCOM to DEAMS/GAFS-BQ/GAFS-R | PWS Section 7.2 | Monthly | UoT | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Management Review Checklist | PWS Section 7.2, 7.3 | Annually | UoT | As requested by AU lead | |
| List of reconciliations (development) | PWS Section 7.3 | As needed | UoT | As requested by AU lead | |
| Reconciliation MOCAS OBS to GAFS-BQ | PWS Section 7.3 | Monthly | MOCAS | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation CWS to MOCAS | PWS Section 7.3 | Monthly | MOCAS | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation MOCAS EUD to GAFS-BQ | PWS Section 7.3 | Monthly | MOCAS | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation WAWF to MOCAS EUD | PWS Section 7.3 | Monthly | MOCAS | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation CWS to EDA | PWS Section 7.3 | Monthly | MOCAS and Vendor Pay | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation CWS to GAFS-BQ | PWS Section 7.3 | Monthly | MOCAS and Vendor Pay | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation CWS to DEAMS | PWS Section 7.3 | Monthly | MOCAS and Vendor Pay | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation WAWF to DEAMS | PWS Section 7.3 | Monthly | P2P | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation CCaRs to GAFS-BQ | PWS Section 7.3 | Monthly | RBAE | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation JOCAS to DTIM | PWS Section 7.3 | Monthly | RBAE | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Reconciliation DTIM to GAFS-BQ | PWS Section 7.3 | Monthly | RBAE | Email to govt POCs and posted to joint FMFA Teams Channel | |
| Data analysis improvements (development) | PWS Section 7.4 | As needed | UoT | As requested by AU lead | |
| Training materials (development) | PWS Section 7.5 | As needed | UoT | As requested by AU lead | |
| DDRS Crosswalk Oversight | PWS Section 7.7 | As required | UoT and DSCA | As requested by AU lead | |
| End-of-month general ledger oversight controls (development) | PWS Section 7.7 | Monthly | UoT | As requested by AU lead | |
| GAFS-R Fiscal year end oversight checklists, DEAMS Fiscal year end oversight checklist (development). | PWS Section 7.8 | Annually | UoT | As requested by AU lead | |
| GAFS-R GL Posting Logic Oversight | PWS Section 7.9 | As required | UoT and DSCA | As requested by AU lead | |
| DEAMS Posting Logic Oversight | PWS Section 7.9 | As required | UoT and DSCA | As requested by AU lead | |
| Posting Logic Review Checklist (development) | PWS Section 7.9 | Annually | UoT | As requested by AU lead | |
| Data analytical tool (development) | PWS Section 8.1 | As needed | All | As requested by AU lead | |
| Tool scripts and data (development) | PWS Section 8.2 | As needed | All | As requested by AU lead | |
| Data visualization dashboards for Cash, Journal Vouchers (including subscription report), Financial Stattements, Inventory, Abnormal Balances, Cash What-if Modeling, NFR-CAPs, and FIABS Transfer Logs | PWS Section 8.3 | Monthly | WCF All | AF VAULT | |
| Data visualization dashboard for Select Transaction History (STH) (development) | PWS Section 8.4 | As required | WCF All | AF VAULT | |
| Training materials (development) | PWS Section 8.5 | As required | All | As requested by AU lead | |
| Update Annual Audit Remediation Plan | PWS Section 9.1.1 | As needed | All | As requested by AU lead | |
| Change Management Plan (development) | PWS Section 9.1.2 | As needed | All | As requested by AU lead | |
| Maintain current SAF/FM FIAR SharePoint site. | PWS Section 9.1.3 | As needed | All | As requested by AU lead | |
| Weekly tasker status tracker | PWS Section 9.1.3 | Weekly | All | As requested by AU Lead | |
| Bi-weekly AAP metrics | PWS Section 9.1.3 | Bi-weekly | All | As requested by AU Lead | |
| Update SAF/FM FIAR Communications SharePoint Site | PWS Section 9.1.3 | Monthly | All | As requested by AU Lead | |
| Training Documentation and Briefings (development) | PWS Section 9.1.4 | As needed | All | As requested by AU Lead | |
| Briefings (development) | PWS Section 9.1.5 | As needed | All | As requested by AU Lead | |
| Governance Body Charters - Executive Steering Committee / Senior Assessment Team (ESC/SAT) Charter | PWS Section 9.1.6 | Annually | Strategic Communications | Email to govt POCs | |
| Document and submit ESC meeting minutes | PWS Section 9.1.6 | Monthly | All | As requested by AU lead | |
| Responses to taskings | PWS Section 9.1.7 | As needed | All | As requested by AU lead | |
| Documentation of Assessment, test plans, and results | PWS Section 10.1 | Annually | DSCA SAA | As requested by AU Lead | |
| Test Plans, Test Results, and Corrective Action Plans | PWS Section 10.2 | Annually | DSCA SAA | As requested by AU Lead | |
| System Change Request | PWS Section 10.3 | As required | DSCA SAA | As requested by AU Lead | |
| Metrics development and supported briefings | PWS Section 10.4 | As required | DSCA SAA | As requested by AU lead | |
| Monthly Activity Report | PWS Section 16.1 | Monthly, by the 15th of the month. If the 15th occurs on a weekend or holiday, then the Contractor shall provide the Report the previous business day. | All | Email to COR | |
| Project Management Review | PWS Section 16.2 | Bi-annually (January & July) | All | Powerpoint briefing | |
| List of Key Personnel | PWS Section 17.1 | Within 10 days of contract award | All | Via email to COR |
Potential RFP Deliverables
| Deliverable | Reference | Due Date/Frequency | AU | Delivery | Updates/Notes |
| Management/Staffing Plan | Request for Proposal | All plans listed at left will be submitted as part of the Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria |
· The OCI Plan shall also be submitted IAW RFP/contract section 4, paragraph 4a-6
| The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | |||||
| Organizational Conflict of Interest (OCI) Plan | Request for Proposal | All plans listed at left will be submitted as part of the Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria | ||
| · The OCI Plan shall also be submitted IAW RFP/contract section 4, paragraph 4a-6 | The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | ||||
| Transition Plan | Request for Proposal | All plans listed at left will be submitted as part of the Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria | The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | |
| Small Business SubcontractingPlan | Request for Proposal | All plans listed at left will be submitted as part of the Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria | ||
| · The Small Business Subcontracting Plan shall also be submitted IAW RFP/contract section 4, paragraph 4a-6 | The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | ||||
| Quality Control Plan (QCP) | PWS Section 6.5.2 | The Contractor shall provide a QCP to the Government PMO and COR, as specified in PWS paragraph 6.5.2, NLT 10 calendar days after AF FIAR Support contract award | The Contractor shall provide any changes or updates to the Government PMO and COR prior to Contractor implementation. | ||
| Data Accession List CDRL |
AF FIAR Spt CDRL
| A001 Data Accession | Data shall be as of the last day of the contractual quarter. First submittal shall be NLT 90 days after contract start. Following submittals shall be NLT the 15th calendar day (last weekday before the 15th calendar day if it falls on a weekend or holiday) following the contractual quarter. | Quarterly above. | |||
| Kick-off Meeting | PWS Section 6.2.1 | The Contractor shall attend the Kick-Off Meeting within 10 business days of contract award. | Government PM responsible for setting up meeting | ||
| SubContractor List | The Contractor shall provide a SubContractor List to the Government PMO NLT 10 calendar days after AF FIAR Support ID/IQ contract award. | The Contractor shall disclose new teaming partners/ subContractors prior to that entity’s participation in response to a task order solicitation. The Contractor shall coordinate with the CO prior to adding or deleting subContractors from the prime’s subContractor list. The Contractor shall provide timely notification to the CO of any acquisitions or mergers that impact this contract. | |||
| Individual and/or Summary SubcontractingReport (ISR/SSR). | The Contractor shall submit ISR/SSR using the Electronic Subcontracting Reporting System (eSRS) at http://www.esrs.gov) IAW FAR 19.704(a)(10)(iii)(A) and guidance in eSRS. | ||||
| Contractor Labor Hours Report(eCMRA) | PWS Section 6.7 | Annual, NLT 31 October | The Contractor shall report all Contractor labor hours (including subContractor labor hours) required for performance of services provided under this contract at http://www.ecmra.mil. | ||
| Contractor-identified concern that impacts the Contractor’s ability to meet deliverable milestones/timelines | • Verbal and electronic notification identifying the nature of the issue to the COR within three (3) business hours of identification. |
• Written recommendations and corrective actions required to meet deliverable milestones/timelines within eight (8) business hours of identification, unless otherwise approved in writing by the applicable COR.
Task Order Invoices All invoicing will be at the CLIN level.
Copy wo IT
| Deliverable | Reference | Due Date/Frequency | AU | Delivery | Updates |
| Management/Staffing Plan | IDIQ Request for Proposal | All plans listed at left will be submitted as part of the ID/IQ Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria |
· The OCI Plan shall also be submitted IAW RFP/contract section 4, paragraph 4a-6
| The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | |||||
| Organizational Conflict of Interest (OCI) Plan | IDIQ Request for Proposal | All plans listed at left will be submitted as part of the ID/IQ Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria | ||
| · The OCI Plan shall also be submitted IAW RFP/contract section 4, paragraph 4a-6 | The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | ||||
| Transition Plan | IDIQ Request for Proposal | All plans listed at left will be submitted as part of the ID/IQ Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria | The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | |
| Small Business SubcontractingPlan | IDIQ Request for Proposal | All plans listed at left will be submitted as part of the ID/IQ Proposal, and will be incorporated into the contract. | · All documents shall be delivered IAW the criteria established in the ID/IQ RFP Technical Criteria | ||
| · The Small Business Subcontracting Plan shall also be submitted IAW RFP/contract section 4, paragraph 4a-6 | The Contractor shall provide any changes or updates to the Government PMO (CO, Program Manager, Quality Assurance Manager (QAM)) and COR prior to Contractor implementation. | ||||
| Quality Control Plan (QCP) | PWS Section 8 | The Contractor shall provide a QCP to the Government PMO and COR, as specified in PWS paragraph 6.2, NLT 10 calendar days after AF FIAR Support contract award | The Contractor shall provide any changes or updates to the Government PMO and COR prior to Contractor implementation. | ||
| Data Accession List CDRL |
AF FIAR Spt CDRL
| A001 Data Accession | PWS paragraph 2.1.9 | Data shall be as of the last day of the contractual quarter. First submittal shall be NLT 90 days after contract start. Following submittals shall be NLT the 15th calendar day (last weekday before the 15th calendar day if it falls on a weekend or holiday) following the contractual quarter. | Quarterly above. | ||
| Kick-off Meeting | PWS paragraph 7.4 | The Contractor shall attend the Kick-Off Meeting within 10 business days of contract award. | Government PMO responsible for setting up meeting | ||
| SubContractor List | Reference? | The Contractor shall provide a SubContractor List to the Government PMO NLT 10 calendar days after AF FIAR Support ID/IQ contract award. | The Contractor shall disclose new teaming partners/ subContractors prior to that entity’s participation in response to a task order solicitation. The Contractor shall coordinate with the CO prior to adding or deleting subContractors from the prime’s subContractor list. The Contractor shall provide timely notification to the CO of any acquisitions or mergers that impact this contract. | ||
| Individual and/or Summary SubcontractingReport (ISR/SSR). | Reference? | The Contractor shall submit ISR/SSR using the Electronic Subcontracting Reporting System (eSRS) at http://www.esrs.gov) IAW FAR 19.704(a)(10)(iii)(A) and guidance in eSRS. | |||
| Contractor Labor Hours Report(eCMRA) | PWS paragraph 7.6 and subparagraphs | The Contractor shall report all Contractor labor hours (including subContractor labor hours) required for performance of services provided under this contract at http://www.ecmra.mil. | |||
| Contractor-identified concern that impacts the Contractor’s ability to meet deliverable milestones/timelines | PWS paragraph 9.2 | • Verbal and electronic notification identifying the nature of the issue to the COR within three (3) business hours of identification. |
• Written recommendations and corrective actions required to meet deliverable milestones/timelines within eight (8) business hours of identification, unless otherwise approved in writing by the applicable COR.
| Scoping and Planning Activities Report | PWS Para 2.2.1.8 | |||
| Trip Report | PWS Para 2.1.7 | Following official travel, the Contractor shall prepare a trip report detailing the purpose of the trip, the individuals contacted, any agreements that were reached during the trip or any other significant issues that were identified during the travel. The Contractor shall provide this trip report to the COR within two (2) days after the completion of travel | All | |
| Document Testing Report | PWS Para 2.2.1.8 | |||
| Report and Monitoring Results | PWS Para 2.2.1.8 | |||
| Corrective Actions Report | PWS Para 2.3 | |||
| Monitor and Report Corrective Actions | PWS Para 2.3.1 | |||
| Monthly Activity Report | PWS Paragraph 2.8 | The Contractor shall provide two Monthly Activity Reports - one for Air Force Working Capital Fund FIAR efforts and a second that reports on Contractor Program Management by Task Order by the 15th of every month. If the 15th occurs on a weekend or holiday, then the Contractor shall provide the Report the previous business day. Report to reflect major accomplishments, projected major tasks, and identified risks for each task order and all applicable Tasks outlined in the PWS. | All | |
| Task Order Invoices | PWS Paragraph 7.1 | All invoicing will be at the CLIN level. | ||
| Quarterly Statement of Assurance Submission Packages | PWS Paragraph 2.1.7 | As required by OUSD(C) SOA Handbook | A-123 | Email to govt POCs |
| Updated A-123 Publications (AFPD, AFI, RMIC Playbook/DAFMAN) | PWS Paragraph 2.1.10 | As required, but at a minimum, review for updates annually | A-123 | Email to govt POCs |
| Executive Steering Committee / Senior Assessment Team (ESC/SAT) Charter | PWS Paragraph 2.1.4 | As required | A-123 | Email to govt POCs |
| ESC/SAT Governance Meeting Package | PWS Paragraph 2.1.4 | Quarterly | A-123 | Email to govt POCs |
| Annual RMIC Training | PWS Paragraph 2.1.5 | Annually, Quarter 1 | A-123 | Virtually |
| DAF General Fund Scoping Document | PWS Paragraph 2.1.7 | Annually, Quarter 1 | A-123 | Email to govt POCs |
| Updated Process Cycle Memorandum (PCM) Template | PWS Paragraph 2.1.8 | Annually | A-123 | Email to govt POCs |
| Assessable Unit (AU) PCM Review comments | PWS Paragraph 2.1.8 | Annually | A-123 | Email to govt POCs |
| Updated Control Evaluation Matrix (CEM) Template | PWS Paragraph 2.1.8 | Annually | A-123 | Email to govt POCs |
| AU CEM Review comments | PWS Paragraph 2.1.8 | Annually | A-123 | Email to govt POCs |
| Updated Control Testing Workbook Template | PWS Paragraph 2.1.8 | Annually | A-123 | Email to govt POCs |
| Updated Walkthrough Template | PWS Paragraph 2.1.8 | Annually | A-123 | Email to govt POCs |
| Self-Identified Deficiency (SID) Template | PWS Paragraph 2.1.7 | As required | A-123 | Email to govt POCs |
| Updated Summary of Aggregated Deficiencies (SAD) Template | PWS Paragraph 2.1.7 | Annually, Q3 | A-123 | Email to govt POCs |
| Summary of Aggregated Deficiencies (SAD) Template | PWS Paragraph 2.1.7 | Annually, Q3 | A-123 | Email to govt POCs |
| AFAA-Agreed Upon Procedures (AUPs) requirements listing | PWS Paragraph 2.1.7 | Annually, Q4 | A-123 | Email to govt POCs |
| Updated Entity Level Control (ELC) Testing Matrix | PWS Paragraph 2.1.7 | Annually, Q4 | A-123 | Email to govt POCs |
| ELC Testing results report | PWS Paragraph 2.1.7 | Annually, Q4 | A-123 | Email to govt POCs |
| ELC SIDs | PWS Paragraph 2.1.7 | As required | A-123 | Email to govt POCs |
| Updated Fraud Risk Assessment template | PWS Paragraph 2.1.3, 2.1.7 | Annually | A-123 | Email to govt POCs |
| Fraud Risk control Testing Results | PWS Paragraph 2.1. 3, 2.1.7 | Annually | A-123 | Email to govt POCs |
| Recurring updates (A4 Audit Update, MAJCOM Audit Update, etc.) | PWS Paragraph 2.1.4, 2.1.7 | As required | A-123 | Email to govt POCs |
| CAP for A-123 deficiencies (Self-Identified or External) | PWS Paragraph 2.1.7 | As required | A-123 | Email to govt POCs |
| DAF Risk Profile | PWS Paragraph 2.1.3 | Annually, Q3 | A-123 | Email to govt POCs |
| Automated A-123 testing activities uploaded into production | PWS Paragraph 2.1.1 | In accordance with a mutually agreed upon schedule, Demonstration and User Acceptance Testing (UAT) | A-123 | |
| Develop an automated Form in eGRC fed by an automated Entity Level Control process | PWS Paragraph 2.1.1 | In accordance with a mutually agreed upon schedule, Demonstration and UAT | A-123 | |
| Real-time risk and control posture dashboard | PWS Paragraph 2.1.1 | In accordance with a mutually agreed upon schedule, Demonstration and UAT | A-123 | |
| Export capability for AFAA Agreed Upon Procedures work papers | PWS Paragraph 2.1.1 | In accordance with a mutually agreed upon schedule, Demonstration and UAT | A-123 | |
| Automated initiation of fraud control assessment to populate OUSD(C) Template | PWS Paragraph 2.1.1 | In accordance with a mutually agreed upon schedule, Demonstration and UAT | A-123 | |
| Automated data quality control assessments and population of the OUSD(C) data quality testing and reporting template | PWS Paragraph 2.1.1 | In accordance with a mutually agreed upon schedule, Demonstration and UAT | A-123 | |
| User training, and configuration documentation | PWS Paragraph 2.1.1 | Prior to Go-Live, “How to” function embedded in the GRC system | A-123 | |
| Certification Statement Call Letter | PWS Paragraph 2.1. | Annual, Quarter 4 | A-123 | |
| SOC 1 Monitoring Reports | PWS Paragraph 2.1.7 | Annual, End of Quarter 3 | Service Provider | Email to govt POCs |
| SOC 1 Report Feedback | PWS Paragraph 2.1.7 | Annual, as required by the Service Provider Working Group | Service Provider | Email to govt POCs |
| SOC 1 Deficiency Tracker | PWS Paragraph 2.1.7 | Annual, two weeks after receipt of last SOC 1 Report | Service Provider | Email to govt POCs |
| Review/refresh Service Provider MOUs | PWS Paragraph 2.1.7 | Annual, initiate review 60 days prior to expiration date | Service Provider | Email to govt POCs |
| Review/refresh MOU Appendices | PWS Paragraph 2.1.7 | Annual, after completion of PCMs/CEMs | Service Provider | Email to govt POCs |
| CUEC Update Distribution | PWS Paragraph 2.1.7 | Bi-Annual, within five business days of the OUSD(C) Service Provider Working Group | Service Provider | Email to govt POCs |
| Agency Financial Report (AFR) schedule | PWS Paragraph 2.4.1 | Annual , 30 March | FSCR | Email to govt POCs |
| AFR status updates | PWS Paragraph 2.4.1 | Bi-weekly (until 15 July); Weekly (15 July- 15 Nov) | FSCR | Email to govt POCs |
| AFR theme options | PWS Paragraph 2.4.1 | Annual , 30 March | FSCR | Email to govt POCs |
| AFR outline | PWS Paragraph 2.4.1 | Annual, 29 April | FSCR | Email to govt POCs |
| Draft Management’s Discussion and Analysis (MD&A) | PWS Paragraph 2.4.1 | Annual, 29 July | FSCR | Email to govt POCs |
| Draft Agency Head Letter | PWS Paragraph 2.4.1 | Annual, 10 August | FSCR | Email to govt POCs |
| Draft CFO Message | PWS Paragraph 2.4.1 | Annual, 15 August | FSCR | Email to govt POCs |
| Draft Management Response Letter | PWS Paragraph 2.4.1 | Annual, 15 August | FSCR | Email to govt POCs |
| Prepare Management Schedule of Information (MSI) that reconciles to the Legal Representation Letter | PWS Paragraph 2.4.1 | 13 July (Interim); 6 October (Final) | FSCR | Email to govt POCs |
| TMT packages for Agency Head Letter, CFO Message, Management Response Letters | PWS Paragraph 2.4.1 | Annual, 29 August | FSCR | Email to govt POCs |
| OMB A-136 compliance review | PWS Paragraph 2.4.1 | Annual , 1 September | FSCR | Email to govt POCs |
| TMT packages for Management Representation Letters | PWS Paragraph 2.4.1 | Annual , 19 September | FSCR | Email to govt POCs |
| Reconciliation of DDRS-AFS financial statements and footnotes to AFR | PWS Paragraph 2.4.1 | Annual, 23 October | FSCR | Email to govt POCs |
| Draft AFR | PWS Paragraph 2.4.1 | Annual, 23 October | FSCR | Email to govt POCs |
| Final AFR | PWS Paragraph 2.4.1 | Annual, 7 November | FSCR | Email to govt POCs |
| Identify all lines requiring variance analyses explanation | PWS Paragraph 2.4.2 | 15th Business Day (Q1-Q3); 18th Calendar Day (Q4) | FSCR | Email to govt POCs |
| Final Variance Analysis briefing materials | PWS Paragraph 2.4.2 | 17th Business Day (Q1-Q3); 20th Calendar Day (Q4) | FSCR | Email to govt POCs |
| Quarterly Datacall JV packages and tracker | PWS Paragraph 2.4.3 | Quarterly | FSCR | Email to govt POCs |
| JV review documentation and root cause analysis | PWS Paragraph 2.4.4 | Monthly | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website |
| Planning and scoping document for A-123 cycle execution and overall project schedule for the next fiscal year. The project schedule becomes contractual due dates when accepted by the AU lead. | PWS Paragraph 2.1.7 | Monthly | FSCR | Email to govt POCs and posted to joint FSCR SharePoint website |
| Updated business process cycles memorandums; Updated risk assessments, internal controls (including required complementary user entity controls (CUECs), entity level controls, and fraud risk) for each business cycle/assessable unit and a comprehensive master controls catalog; Walk through results, Updated testing plans and resulting TOD and TOE results; Draft update of Statement on Standards for Attestation Engagements (SSAE) No 18 Air Force Analysis Monitoring Report for each SSAE applicable to the Air Force. |
tc={48989978-2320-42E1-B2CE-54BB0810318A}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if…
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .