Excel workbook previewAudit PBC List Template (Prepared by Client, Excel)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A prepared by client list is the auditor's request list: the reconciliations, schedules, contracts and reports the finance team must deliver before and during the audit. When nobody tracks it, items arrive late, fieldwork stretches and the audit fee grows. This workbook turns the list into a live tracker that the controller can review at each weekly status call with the audit team.
The workbook holds 50 typical requests for a public company integrated audit, grouped in 12 areas from planning to completion, each with an owner, dates, status and a days late formula. A summary counts open and overdue items by area and owner, and a key dates sheet works out the Form 10-K deadline from SEC Form 10-K General Instruction A. Notes point to the public PCAOB standards on pcaobus.org that explain why each item is requested.
Who it is for
The controller who must hand the external auditor dozens of schedules on time and needs one list showing who owes what and what is late.
What is inside
- 50 worked request items in 12 audit areas, plus 20 blank formatted rows
- Owner, auditor contact, requested, due and received dates for every item
- Days late formula that counts up daily until the item is received, then freezes
- Overdue due dates turn red; priority and status are color coded
- Summary sheet with items, accepted, open and overdue counts by area and by owner
- Key dates sheet that calculates the Form 10-K due date from the filer category
- 11 audit milestones counted back from the filing deadline
- Notes link items to the PCAOB standards behind the request
How to use it
Replace the sample rows with your auditor's request list and give each item one owner and a due date.
Files
- XLSXaudit-pbc-list-template.xlsx21 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What does PBC mean in an audit?
PBC stands for prepared by client. It is the list of schedules, reconciliations and documents the company prepares for the external auditor, such as the trial balance, bank reconciliations, fixed asset roll-forwards and the management representation letter. The auditor issues the list and the company delivers each item by an agreed date.
When should the PBC list be agreed with the auditor?
Agree it at or soon after the planning meeting, months before year end. That leaves time to assign owners, agree formats and dates, and move items such as contracts, minutes and control evidence into the interim visit. Year-end items then only need the final balances.
How do I show the auditor what is outstanding?
Share the Summary sheet at each status meeting. It counts accepted, open and overdue items by audit area and by owner, live from the list. Items past their due date with nothing received turn red, so both sides see the same picture.




