Excel report: tracking remediation progress

Column structure

Each row in the Excel export represents one check. The columns are:

Sorting and filtering

The top row is a frozen header row with Excel's AutoFilter enabled. You can immediately filter by Severity to show only Critical and High failures, or filter by Module to focus on a specific area. Sorting by Status with "Fail" first gives you the complete remediation backlog at a glance.

The Severity column uses consistent text values (Critical, High, Medium, Low), making it easy to create a custom sort order: Critical > High > Medium > Low using Excel's custom sort feature.

Tips for tracking remediation progress

Add a Remediation Status column next to the Status column with values like "Not started", "In progress", "Fixed", "Won't fix". This turns the sheet into a living task tracker. You can then filter by Remediation Status to see what's outstanding.

Add an Assignee column to assign findings to specific developers or team members. If your team uses Jira or Linear, the Check ID provides a stable reference to include in ticket titles, making it easy to cross-reference the audit sheet with your issue tracker.

Comparing across audits

Because Check IDs are stable across audit runs, you can export two audits to Excel and use VLOOKUP or XLOOKUP to compare status columns by Check ID. Any check that moved from Fail to Pass represents a fixed issue; any that moved from Pass to Fail is a regression introduced since the last audit. This approach works well for producing "before and after" reports to show clients the impact of a tracking remediation sprint.