Thred

Month-end close checklist (Excel template)

Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.

Book a demo
Download the template

Excel (.xlsx), every close step with owner, deadline and status

Free, no sign-up, no email address.

How to use the checklist

The sheet lists the steps of the close in groups: bank and reconciliation, receivables, payables, accruals and deferrals, fixed assets, VAT, intercompany, and reporting and closing. Each task has a short explanation of what done looks like.

Before the first close, go through the list once with your team. Delete the tasks that do not apply to you, add the ones that are specific to your business, and give every task an owner. Then set a deadline for each one in working days after the month ends, such as WD+1 for the bank and WD+5 for the report.

During the close, set the status of each task to Open, In progress, Done or N/A, with the date it was finished and a note when something is unusual. The summary at the top counts the tasks and shows the percentage done, and finished rows turn green.

Plan the deadlines in working days

A deadline in working days after the month end keeps the plan the same every month, whatever the calendar does. A common rhythm is the bank and receivables on WD+1, payables and accruals on WD+2, fixed assets, VAT and intercompany on WD+3, the review on WD+4 and the report on WD+5. Put the tasks that wait for someone else, such as missing supplier invoices or a statement from a payment provider, as early as you can, because they are the ones that slip.

Make a copy every month

Save a copy per month, or add a sheet per month, so you keep a record of who did what and when. That record is useful for your accountant at year-end and shows where the close loses time. If the same task is late every month, that is the one to fix or automate first.

Prefer to tick the steps off in your browser? The interactive month-end close checklist has the same steps, with notes for Exact Online, Moneybird and Xero.

Frequently asked questions

How long should a month-end close take?

Many small and mid-sized businesses take one to three weeks. Teams that keep the books current during the month close in three to five working days. The deadline column helps you plan towards that.

Can I use this with Exact Online, Moneybird or Xero?

Yes. The steps are the same whatever ledger you use. The interactive checklist on this site adds where to find each step in those three.

Is the checklist free?

Yes. No sign-up and no email address. Download it and use it as you like.

More free tools

Where Thred comes in

Thred Layer

Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo