| Case | Scenario | Status |
|---|---|---|
| UAT-001 | Total reconciliation | Pass |
| UAT-002 | Date filter | Fail |
| UAT-003 | Empty state | Not run |
UAT & Issue Tracker
Keep test scenarios, expected results, evidence, and retests in one place.
FreeView template
EXCEL / XLSX
Monthly KPI Scorecard
Turn monthly targets and actuals into a clear performance conversation.
Q1 actual · sample3,380 102.4% of target
| Month | Target | Actual | Variance |
|---|---|---|---|
| January | 1,000 | 1,080 | +80 |
| February | 1,100 | 1,160 | +60 |
| March | 1,200 | 1,140 | −60 |
Preview uses illustrative sample content.
What’s inside
- 12-month scorecard with editable targets and actuals
- Variance and target attainment formulas
- Blank months stay blank until both inputs are entered
Make it yours
- Open the workbook in Excel and replace the example KPI name and units.
- Replace the amber input cells with your monthly targets and actual results. Clear the sample inputs for months you have not reported.
- Variance is actual minus target. Attainment is actual divided by target; a zero target is shown as n.a. Use this scorecard for a higher-is-better KPI.
Format & compatibility
Excel .xlsx workbook. No macros or external data connections. Sample figures are illustrative.