Paste the review points raised on an engagement with who raised them and when each was cleared. Enter an as-of date and an overdue limit. The tool shows what is still open, how long it has waited and which reviewer has the most outstanding.
Leave Cleared on blank for points still open. Dates can be dd/mm/yyyy, dd-mm-yyyy or yyyy-mm-dd.
Set the overdue limit from your own file closure timetable. Check the current file assembly requirements in your standards.
| Reviewer | Open | Overdue | Cleared |
|---|---|---|---|
| Meera | 2 | 2 | 1 |
| Arun | 2 | 2 | 1 |
| Point | Working paper | Reviewer | Raised | Days open | Status |
|---|---|---|---|---|---|
| RP-02 | D-12 Debtors | Meera | 2020-09-02 | 2,236 | Overdue |
| RP-03 | F-04 Fixed assets | Arun | 2020-09-05 | 2,233 | Overdue |
| RP-05 | C-03 Cash | Meera | 2020-09-22 | 2,216 | Overdue |
| RP-06 | P-02 Provisions | Arun | 2020-10-01 | 2,207 | Overdue |
Review comments that sit open past the planned date delay the report and the archive of the file. A tracker puts every point, its reviewer and its age in one place. Clear the oldest first, and look at which working papers keep generating points, because that often shows where the preparer needs guidance.
Each line is one review point. A point with a cleared date is closed. A point without one is open and its age is counted from the raised date to your as-of date.
Open points older than the limit you set are marked overdue. Totals are shown for each reviewer.
The Excel file lists every point with its days open and a column for the preparer response.
A review point was raised on 2 September and is still open on 17 October. The limit is 7 days.
