What it is
An accounting firm closes many clients at once. This tracker gives each client ten steps, a percent complete, a due date and a status.
The summary counts closed, late and in progress clients and shows how many each accountant still holds.
When to use it
- In the first ten days of each month.
- When allocating staff.
- In client service reviews.
What’s inside
- Close tab with 60 clients
- Ten step columns with Yes, No and N/A
- Percent complete and status formulas
- Summary with workload by accountant
Standard cited
This template follows Accounting services. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Why N/A?
Some clients have no payroll or sales tax. N/A removes the step from the percent complete.
What is Late?
The due date is before the as-of date and the client is not at 100%.
Is there a checklist version?
Yes. See the month-end close checklist for step detail.
Related templates
- Month-End Close Checklist (Excel)
- Accounting Close Calendar and Task Tracker (Excel)
- Staff Assignment Matrix by Engagement (Excel)
- Bookkeeping Services Engagement Letter
Last updated 11/06/2026. All free templates.