Download AA: Audit PBC (Prepared by Client) Tracker (.xlsx)
What it does
Keeps every audit request in one list with its area, owner, due date and priority, works out days open and days overdue, follows auditor queries to closure and summarises progress by audit area and by owner for the weekly status call.
Who it is for
Controllers and finance teams preparing for statutory, internal or lender audits, and audit seniors.
How to use it
- Go to 'Settings'. Type the company, the year, the audit firm and the 'status as at' date (type today's date, or =TODAY() if you prefer it to change by itself).
- Go to 'Requests'. Paste or type the auditor's list: one line per item with area, description, owner, date requested, due date and priority.
- When you hand an item over, type the date provided. When the auditor replies, pick their status. If they raise a query, type it and the date it was closed.
- Read the 'Status' and 'Days overdue' columns. Filter on 'Overdue' and 'Query open' before each status call.
- Go to 'Summary' for progress by area and by owner, and the Checks box.
Tabs in the file
| Tab | What it holds |
|---|---|
| Settings | Company, year, audit firm and status date. |
| Requests | One line per request, with status. |
| Summary | Progress by area and owner, and checks. |
Learn the topic
For computation and reconciliation assistance only; not a substitute for formal statutory audit or legal tax advice. All sample data is illustrative and made up. Rates, limits and rules must be checked against current law and your own agreements before use. No tax saving, audit outcome or compliance result is promised.