From POA&M Spreadsheets to Risk Signals: Making Open Findings Mean Something

The Plan of Action and Milestones, usually abbreviated as POA&M, is one of the most commonly used artifacts to track findings and remediation progress related to cybersecurity at Federal agencies. The Office of Management and Budget (OMB) implemented the use of this artifact in 2001 as the government-wide mechanism for tracking the remediation of security weaknesses. More than two decades later, most organizations still maintain POA&Ms in spreadsheets.

The primary purpose of POA&Ms are to track remediation activities related to all findings. The total number of findings, their severity, the time they have been open, their rate of return, and the pattern across control families together should be able to summarize whether the overall control environment is actually improving.

A list of rows within a spreadsheet and its content does not clearly summarize whether the control environment is improving over time or not. A chart of the right metrics does. The gap between the two is where most agency compliance programs lose connectivity, and the Authorizing Official who approves continued operation of a system makes that approval against a narrower view.

This article covers what a POA&M is supposed to produce, what the raw spreadsheet does not produce, which specific metrics convert the data into a risk rating, and how an agency moves from the spreadsheet to risk rating model without rebuilding its documentation.

What the Framework Actually Requires

The POA&M sits inside the NIST Risk Management Framework and the control families that implement it. Three control references matter.

1. NIST SP 800-53 Rev. 5 control CA-5 requires an organization to develop a plan of action and milestones for the system to document planned remediation actions, and to update it based on findings from assessments and continuous monitoring. The discussion in the control itself notes that POA&M documents are required in authorization packages and are subject to federal reporting requirements established by OMB.

2. CA-7, Continuous Monitoring, requires the organization to report POA&M status on the continuous monitoring cadence rather than only at authorization.

3. RA-5, Vulnerability Scanning, is a primary source of new entries that feed the POA&M between assessments.

Three features of that framework are easy to miss when the artifact is treated as a form.

1. The POA&M is a management tool, not only a reporting document. The purpose is to help the organization identify, prioritize and monitor the progress of corrective efforts. A document reviewed only at submission time has not been used as the framework intends.

2. The Authorizing Official reads it between authorizations. Risk-based decisions about continued system operation depend on the current POA&M state. If the state is only visible as a 300-row spreadsheet, the AO is reading a table and making an inference, which is not the position the framework contemplates.

3. Entries are supposed to change state. The artifact is dynamic by design. A POA&M that looks the same from month to month is either describing a system with no activity, or more commonly, describing a documentation gap between what the system is doing and what the POA&M reflects.

What a Spreadsheet Does Not Produce

A row-level POA&M handles three things well: identifying each finding, assigning an owner, and recording a remediation plan. Those are its design purposes and it is adequate for them.

Six analytical questions are difficult to answer from the row view, and all six are what an Authorizing Official or an Information System Security Manager needs to know.

1. Is the overall remediation velocity increasing or decreasing? A count of open items is a snapshot. The useful signal is the derivative: are findings closing faster than new ones that arrive, and is that trend sustained across months?

2. Where is risk actually accumulating? Open counts by control family show whether a specific capability area is drifting out of control. The spreadsheet knows the control for each row; the question needs the aggregation.

3. Which findings are approaching or exceeding their severity windows? A finding scheduled to close next week is not the same as one that has been open for 160 days against a 180-day limit. The spreadsheet carries the dates but makes the pattern invisible.

4. Which findings are repeat offenders? A finding that is closed and reappears in the next assessment indicates a root cause that was not addressed. The row view cannot show this across time; the pattern lives across assessment cycles.

5. Where is milestone slippage concentrating? A milestone that moves twice is a different signal from one that has never moved. Tracking the history of each milestone date is the condition for identifying systemic estimation problems.

6. Is the environment improving in a way the AO can see? The AO needs one view that answers the question. Thirty rows of raw data do not answer it in a form a non-specialist official can read in the time available.

The practical consequence

An Authorizing Official who approves continued operation on the basis of a spreadsheet is accepting the output format as a constraint on the risk decision.

The POA&M artifact is adequate as a record. It is not adequate as a decision support instrument, and the framework does not require it to be. The question is who closes that gap.

The Metrics That Make Findings Mean Something

Industry practice has converged on a small set of indicators that translate POA&M data into something an executive or an authorizing official can act on. They draw on the vulnerability management literature, FedRAMP continuous monitoring practice, and the broader risk analytics tradition. None requires new data; all require the existing data to be structured and plotted correctly.