UAT Template (Excel)
Test cases and a defect log in one workbook, with a dashboard that answers the only two UAT questions anyone asks: how far through are we, and what is still broken.
Sold and delivered through Etsy; download available immediately after payment. Why Etsy shows a higher number: €9,95 is the price excluding VAT. Etsy is the merchant of record and adds your country’s VAT at checkout, so an EU buyer in the Netherlands pays €12,04 (€9,95 + 21%). Buyers outside the EU are charged their own local rate, or none.
An Excel workbook holding test cases and a defect log together, with a dashboard answering the only two UAT questions anyone asks: how far through are we, and what is still broken. Test cases carry an owner and a result; defects carry severity and status. Editable, so the case list matches your scope.
UAT is usually run by business users who are doing it alongside their day job, which means the tracking has to be obvious rather than complete. Anything that requires explanation will be filled in wrongly.
This workbook keeps to what a tester can maintain: what they were asked to check, whether it passed, and what went wrong if it did not. The dashboard turns that into the progress view a project manager needs without asking testers to produce it.
Who it is for
IT project managers, test coordinators and business analysts running user acceptance testing.
What is included
- Start Here — how to brief testers on using it
- UAT Test Cases — scenario, steps, expected result, tester, status
- Defect Log — severity, description, owner, status, retest result
- Dashboard — pass rate, progress and open defects by severity
When to use it
- UAT starts next week and there is no tracker
- Testers are reporting defects by email and nothing is consolidated
- You need a defect count by severity for the go/no-go meeting
Format and compatibility
- File format
- Microsoft Excel workbook (.xlsx)
- Editable
- Yes — nothing locked, protected or watermarked
- Delivery
- Instant download after purchase on Etsy
- Licence
- Single-user commercial use on your own projects. See licence and downloads.
- Price
- €9,95 excluding VAT · €12,04 including 21% Dutch VAT, which is what Etsy shows an EU buyer at checkout
Delivered as a standard .xlsx workbook. No macros — the .xlsx format cannot contain them, so it opens without security warnings and passes corporate download policies. Every cell is editable; nothing is locked or password protected.
Questions
Is this enough for a formal test phase?
For UAT, yes. For system and integration testing with formal traceability to requirements, you need a fuller test management approach.
Does it link defects to test cases?
Both sheets carry IDs, so a defect references the case that found it.
Is there a version that covers data migration too?
Yes — the Data Migration & UAT Tracker adds migration objects, reconciliation and sign-off.
Get the UAT Template (Excel)
€9,95 excl. VAT (€12,04 incl. 21% VAT on Etsy) — instant download, editable, no subscription and no account beyond Etsy.
View on Etsy →