An accounting year-end checklist template for Excel is a task tracker that assigns each close activity an owner, due date, status, and evidence link. In Excel for Microsoft 365 on Windows, create columns for those fields, add a status drop-down, and use formulas to monitor completion and overdue work; then tailor the tasks to your fiscal year, accounting policies, and reporting obligations.
What a year-end checklist is for
Year-end close is the process of reviewing and organizing financial records for the end of an accounting period. The period may match the calendar year, but it can also end on another date set by the organization. A checklist makes the work visible: staff can see what must be completed, who is responsible, what is blocking progress, and where supporting documentation is stored.
An Excel checklist is useful because it is flexible and familiar, but it is not an accounting system and does not make a set of financial statements accurate by itself. It helps coordinate work around the ledger, source records, reconciliations, and approvals. The responsible accounting team still needs to apply its own policies and review the underlying figures.
There is no single universally correct year-end task list. A small business with few accounts will have a different close from a company with inventory, payroll across several locations, multiple currencies, or a formal external audit. Treat a template as a starting point, not as a guarantee that every required task is included.
Decide what the checklist needs to cover
Before creating rows, define the period and the work included. Record the fiscal year-end date, the date transactions should stop or be reviewed through, the target date for completing the close, and the people responsible for accounting, review, and approval. Clarify whether the tracker covers only internal close work or also preparation for tax filings, board reporting, or an audit. Those workstreams can have different owners and deadlines.
Also establish what each status means. A simple set is Not started, In progress, Waiting, Done, and N/A. Mark an item Done only when the task is complete and any required review or supporting evidence is recorded. N/A should mean that the task genuinely does not apply, with a short explanation in the Notes column; it should not be used to hide an incomplete task.
- Period: Specify the fiscal year and closing date so the tracker is not reused with an ambiguous date.
- Ownership: Name one accountable owner for each task, even if several people contribute.
- Completion rule: Define what evidence or approval makes a task complete.
- Dependencies: Note tasks that cannot start until a report, reconciliation, or decision is available.
Build the Excel template
Start with a new workbook and create a worksheet called Close Checklist. In row 1, add these headings: ID, Area, Task, Owner, Due Date, Status, Evidence or File Link, and Notes. Put one task on each row beneath the headings. Select the range, then choose Insert > Table and confirm that the table has headers. A table makes it easier to filter by owner, date, status, or accounting area as the list grows.
Keep the task wording specific and verifiable. For example, Replace “review cash” with “Reconcile operating bank account to the statement dated 31 December and document outstanding items.” The longer version identifies the account, the comparison, the relevant date, and the expected output. If an organization has several bank accounts, make a separate row for each one or clearly identify the accounts covered by a single documented procedure.
To create a controlled status list, enter the allowed values in a separate worksheet, such as Lists. Select the status cells, choose Data > Data Validation, choose List as the validation criteria, and point the source to the cells containing the status names. A drop-down reduces inconsistent entries such as Done, Complete, and Finished being used for the same state. Keep the list editable only by the workbook owner if status definitions need to be controlled.
For scanning, freeze the header row with View > Freeze Panes > Freeze Top Row. You can add visual warnings with Home > Conditional Formatting, such as highlighting past-due dates or tasks marked Waiting. Use color as a prompt, not as the only way to communicate status: retain readable text, and make sure the formatting does not obscure the task or its due date.
Include practical close tasks
Build the list around the organization’s actual accounts and close procedure. The groups below are common examples, not a substitute for checking the entity’s own reporting requirements or professional guidance.
- Cash and bank: Obtain period-end statements, reconcile each account to the general ledger, investigate outstanding checks or deposits, and record documented adjustments that have been approved.
- Receivables and revenue: Review customer balances, investigate old or disputed items, check that sales and receipts are recorded in the appropriate period, and document any estimates or adjustments required by the organization’s accounting policy.
- Payables and expenses: Reconcile supplier statements where available, review unpaid invoices and recurring expenses, and identify goods or services received before year-end that may need to be considered in the close.
- Payroll and benefits: Reconcile payroll reports to accounting records, confirm that relevant payroll liabilities and payments are reviewed, and assign any jurisdiction-specific filing checks to the appropriate qualified owner.
- Inventory and fixed assets: If applicable, document the inventory count and investigation of differences; review additions, disposals, and depreciation records under the organization’s established policies.
- General ledger and reporting: Review account reconciliations, investigate unusual balances or movements, check journal entry approvals, and prepare the agreed financial reports for review.
- Governance and archive: Record reviewer sign-off, note unresolved issues and their disposition, and store final reports and supporting files in the approved location.
Use separate tasks where the owner, due date, or evidence differs. For example, “reconcile all accounts” is difficult to assign and verify if bank accounts, payroll liabilities, and fixed assets are handled by different people. A well-designed list is detailed enough to be accountable without turning every minor action into an unnecessary row.
Add completion and overdue formulas
Formulas can summarize activity, but they rely on consistent entries and correctly stored Excel dates. For a basic completion percentage, assume task names are in C2:C13 and statuses are in F2:F13. If the 12 listed tasks include 2 marked N/A and 8 marked Done, the remaining 2 are not complete, so the percentage of applicable tasks completed is 8 out of 10, or 80%. Put this formula in a summary cell and format that cell as a percentage:
=IFERROR(COUNTIF(F2:F13,"Done")/(COUNTA(C2:C13)-COUNTIF(F2:F13,"N/A")),0)
The formula counts Done statuses and divides by the number of named tasks excluding those marked N/A. It returns 0 if there are no applicable tasks, preventing a divide-by-zero error. If you leave a task name blank, it is not included in the denominator; therefore, populate the task list before using the percentage as a progress measure.
To count overdue items, assume due dates are in E2:E13 and statuses are in F2:F13. With two dated tasks before today that are neither Done nor N/A, the formula returns 2. Blank due dates are excluded. TODAY updates when Excel recalculates, so the count changes over time.
=COUNTIFS(E2:E13,"<"&TODAY(),E2:E13,"<>",F2:F13,"<>Done",F2:F13,"<>N/A")
Enter actual Excel dates in the due-date cells rather than text that only looks like a date; otherwise date comparisons may not work as intended. In the formula above, the HTML displays the less-than signs as entities, but the formula to enter in Excel uses the ordinary characters, as shown by the expression inside the code element when rendered. Check the result against a few known rows, especially where dates or statuses are blank.
Make the tracker easier to manage
For a useful working file, keep the task list separate from summary information. A Summary worksheet can show the fiscal year-end, target close date, total applicable tasks, completion percentage, and open overdue count. Avoid putting confidential financial balances into the checklist merely because there is space; link to approved records when the team’s access controls allow it.
Consider adding a Priority or Dependency column only if the team will maintain it. A priority field can help identify work that blocks later steps, such as receiving a bank statement before finalizing a reconciliation. Too many optional fields can make updates slower and encourage users to leave the tracker stale. Assign a workbook coordinator to review the list, resolve duplicate tasks, and follow up on status changes.
Use a dated copy for each close, or create a fresh period from a controlled master template. Preserve prior-period versions as records rather than overwriting them. This helps explain what was assigned and when, while avoiding confusion between a current status and an old one. If the organization has formal retention or document-control rules, follow those rules for the workbook and linked evidence.
Common mistakes and limitations
- Using the wrong year-end: A calendar-year checklist may not match a fiscal year ending on another date. Put the actual period in the workbook and review date-sensitive tasks accordingly.
- Confusing a task with its evidence: A status marked Done is less useful if no one can locate the reconciliation, report, or approval that supports it. Use a stable file path or approved document link and check access permissions.
- Counting N/A as unfinished: Decide whether summaries exclude N/A items and use the same rule throughout. Record why an item does not apply so a reviewer can understand the decision.
- Assuming the checklist validates accounting: Excel can track tasks and calculate simple counts; it cannot determine whether an accounting judgment, estimate, or entry is correct.
- Allowing uncontrolled edits: Shared files can develop conflicting versions or accidental changes. Use an approved shared location, name an owner, and limit editing or protect worksheet structure where appropriate.
A spreadsheet is often adequate for a small team with a manageable number of tasks and a clear process. If many people need simultaneous updates, formal approval routing, a detailed audit trail, or links directly to accounting-system records, a dedicated close-management or workflow tool may fit better. The right choice depends on scale, controls, and the systems already in place—not on a claim that one format is always superior.
Excel template versus other options
A downloadable workbook can save setup time, but check that it matches your fiscal calendar and does not contain unexplained formulas, macros, external links, or sample data that could be mistaken for actual results. A blank template built internally is more work at first, but it lets the organization define its own task names, roles, and completion rules. Either approach needs review before use.
Some teams use a shared task or project-management application instead of Excel. Those tools may offer assignment notifications and activity histories, while Excel offers a familiar grid and straightforward filtering. A document checklist in a shared folder may be enough for a very small close, but it can be harder to summarize ownership and overdue tasks. Compare options by asking how the team will assign work, retain evidence, control access, and preserve a record of completion.
Frequently Asked Questions
Can I download a free accounting year-end checklist template for Excel?
A free workbook may be available from accounting, software, or business-information providers, but inspect it before entering company information. Confirm the fiscal-year assumptions, formulas, links, and macros, and remove example data. If the template does not fit your process, use it as a reference and adapt a controlled copy.
What should an accounting year-end checklist include?
It commonly covers bank and balance-sheet reconciliations, receivables, payables, payroll, inventory or fixed assets where relevant, ledger review, reporting, approvals, and document retention. The exact list depends on the entity, accounting policies, systems, and applicable obligations.
How do I calculate year-end checklist completion in Excel?
Count tasks marked Done and divide by the number of applicable tasks, excluding N/A items if that is your chosen rule. The formula in this guide assumes task names in C2:C13 and statuses in F2:F13. Test the result against a small manual count before relying on it.
Should year-end mean 31 December?
No. Year-end means the end of the accounting period being closed. Some organizations use 31 December, while others use a different fiscal year-end. Use the organization’s actual reporting period and do not assume a calendar-year deadline applies to every task.
Is an Excel checklist enough for an audit or tax filing?
A checklist can help track preparation and supporting documents, but it does not replace required records, review, accounting judgments, or professional advice. Confirm filing dates and documentation needs with the relevant authority or a qualified professional for the organization’s circumstances.
Related
- Why Can’t I Hyperlink in Excel? Common Causes and Fixes
- Why Use Scenario Manager in Excel? Compare Outcomes
- Why Can’t I Add a Hyperlink in Excel? Common Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Duplicates Based on Two Columns in Excel: StepsTo remove duplicates based on two columns in Excel, select the entire data range, choose Data > Remove…
- Show Unread Emails in Outlook and Keep Them VisibleTo show only unread emails in Outlook, open the inbox or folder you want to check and apply…
- Password Protect Excel Before Opening: How It WorksYes. In Excel for Microsoft 365 on Windows, choose File > Info > Protect Workbook > Encrypt with…
- How to Set Up Solver in ExcelTo set up Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in from File >…
- Excel Custom Number Format for MillionsYes. In Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Custom, and enter #,##0.0,,"M".…
- How to Set an Out of Office Reply in OutlookTo set an out-of-office reply in Outlook, open Automatic Replies, turn them on, write your message, and—if available—choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.