Month end close checklist (free Excel template, 42 tasks)

What should a month end close checklist include?

Free Excel month end close checklist: 42 tasks, 12 areas, owners and due dates that calculate from your period end. A close takes 3 to 5 business days, and each task shows its day. Get it by email.

Free download

What's in the template?

Enter your work email and the Excel file arrives in your inbox: 42 close tasks in 12 areas, a status dropdown, a progress summary, a filled-in October 2026 example and a short how-to.

Excel workbook · 42 tasks · works in Excel and Google Sheets
  • 42 month-end tasks in 12 areas, from pre-close cut-offs to locking the period
  • Due dates that calculate in business days from your period end (day -2 to day 7)
  • Status dropdown per task; done rows turn green, overdue rows turn red
  • A summary of done, open and overdue tasks with % complete and a progress bar
  • A worked example: the October 2026 close on business day 3, 44% complete with one overdue accrual
Month-end close checklist (Excel): the filled-in example sheet
Free template

Get it in your inbox.

Work email only. We send this one email with the file, and an occasional note you can unsubscribe from. See our privacy policy.

Day-by-day plan

How long does a month end close take, and what happens each day?

Three to five business days is a realistic target for a single-entity company with clean subledgers. Here's the plan, from Day -1 to Day 5. The template turns each step into dated tasks with owners.

1Day -1

Cut off the period

Confirm receiving, shipping and billing cut-offs. Tell approvers when the last expense report and invoice must land. Day 1 starts with the same data everyone saw on the last day of the month.

2Day 1

Post and close the subledgers

Finish AR, AP, inventory and fixed asset postings. Run the recurring journals. Nothing else can be reconciled until the subledgers stop moving.

3Day 1

Reconcile cash

Match the bank statement to the cash ledger. List outstanding cheques and deposits in transit with dates, so the next person can clear them.

4Day 2

Book accruals and prepaids

Accrue what you used but haven't been billed for: utilities, payroll, goods received not invoiced. Amortize prepaids. Reverse last month's accruals first.

5Day 2

Run depreciation and inventory costing

Post monthly depreciation. Run the inventory cost adjustment and post cost to the GL. Both feed the trial balance.

6Day 3

Tie subledgers to the GL

AR, AP and inventory subledger totals must equal their control accounts. A difference is a posting that bypassed the subledger or a timing gap. Find it today.

7Day 3

Review the trial balance

Scan for odd balances: credits in asset accounts, debits in liabilities, accounts that should be zero. Fix errors before analysis.

8Day 4

Run flux analysis

Compare this month to last month. Explain every line over your threshold, in writing, with a source document.

9Day 5

Sign off, report and lock

Preparer, reviewer and controller sign. Issue statements. Lock the period in the ERP so late postings can't change reported numbers.

How to fill in the month end close checklist: Cut off the period, Post and close the subledgers, Reconcile cash, Book accruals and prepaids, Run depreciation and inventory costing, Tie subledgers to the GL, Review the trial balance, Run flux analysis, Sign off, report and lock
The steps at a glance.
Worked example

What does a close in progress look like on business day 3?

The template ships with this example filled in: the October 2026 close for Northwind Distribution Inc. (illustrative). Period end is Saturday 31 Oct 2026, so business day 1 is Monday 2 Nov. The status below is as of Wednesday 4 Nov.

LineNorthwind, status on business day 3
Period endSaturday 31 Oct 2026; business day 1 is Monday 2 Nov
Tasks in the checklist42
Marked N/A1 (intercompany charges, single entity this month)
Tasks in scope41
Done18
Open23, including the overdue one
Overdue1: the GRNI accrual (goods received not invoiced), due business day 2 (3 Nov), still in progress
Why it's lateWaiting on the receiving report from the warehouse
% complete44% (18 of 41 in scope)
Pre-close tasksRan on days -5, -3 and -2
StatementsDue day 5
Management review and period lockDay 6
RetrospectiveDay 7

One overdue row turns red and the summary counts it, so the controller sees the problem on day 3 instead of day 6.

Journal entries

Which journal entries does a close need, in a worked example?

Six items from the same fictional company, each with debit and credit lines. The amounts are illustrative. Use them to sanity-check your own entries.

Entry and linesDebit or creditAmount
1. Accrue unbilled October utilities: Utilities expenseDebit$4,200
1. Accrued expensesCredit$4,200
2. Prepaid insurance, $36,000 annual premium, one month: Insurance expenseDebit$3,000
2. Prepaid insuranceCredit$3,000
3. Monthly depreciation: Depreciation expenseDebit$12,500
3. Accumulated depreciationCredit$12,500
4. Bank rec: statement balanceStart$248,300
4. Add deposit in transitPlus$9,500
4. Less outstanding chequeMinus$6,800
4. Adjusted bank balance equals GL cashMatch$251,000, difference $0
5. Accrue payroll for days worked but unpaid: Salaries expenseDebit$18,600
5. Accrued payrollCredit$18,600
6. AR subledger vs GL control accountTie-out$412,350 vs $412,350, difference $0
6. AP subledger vs GL control accountTie-out$287,900 vs $287,900, difference $0

The bank reconciliation needs no entry here: an outstanding cheque and a deposit in transit are timing items, and they clear next month. The four entries total $38,300 in debits and $38,300 in credits.

Trial balance

How does the trial balance change after those entries?

Selected accounts before and after the four entries. Expenses rise by $38,300 and the matching credits land in the balance sheet.

AccountBefore entriesAfter entries
Cash$251,000 Dr$251,000 Dr
Accounts receivable$412,350 Dr$412,350 Dr
Prepaid insurance$24,000 Dr$21,000 Dr
Accumulated depreciation$300,000 Cr$312,500 Cr
Accounts payable$287,900 Cr$287,900 Cr
Accrued expenses$9,000 Cr$13,200 Cr
Accrued payroll$0$18,600 Cr
Utilities expense (October)$7,000 Dr$11,200 Dr
Insurance expense (October)$0$3,000 Dr
Depreciation expense (October)$0$12,500 Dr
Salaries expense (October)$142,000 Dr$160,600 Dr
Entries totaln/a$38,300 debits = $38,300 credits

If your trial balance doesn't move by the same debit and credit totals, an entry posted one-sided or hit the wrong period.

Flux analysis

Which variances need an explanation in flux analysis?

Set a rule and apply it the same way every month. This one flags a line only when it moves more than 10% and more than $5,000 against last month.

LineOct 2026Sep 2026VarianceFlag
Revenue$1,840,000$1,795,000+$45,000 (2.5%)No
Inventory$1,204,000$1,131,000+$73,000 (6.5%)No: over $5,000, under 10%
Freight-in expense$96,000$71,000+$25,000 (35.2%)Yes: explain
Bad debt expense$9,000$3,000+$6,000 (200%)Yes: explain
Utilities expense$11,200$10,900+$300 (2.8%)No
Salaries expense$160,600$158,900+$1,700 (1.1%)No

Requiring both tests keeps small accounts from drowning you in noise and large accounts from hiding real swings. Pick thresholds that fit your own volumes.

Review and sign-off

Who signs off on a close, and what evidence should you keep?

A close isn't done when the numbers look right. It's done when someone other than the preparer has checked them and the proof is filed. The COSO framework treats this separation of duties as a core control activity.

0 of 13 settled
Preparer
Reviewer
Controller
Evidence to keep
Common mistakes

What mistakes slow a month-end close down?

Most late closes trace back to the same few habits. Fix these before buying anything.

0 of 11 settled
Process mistakes
Control mistakes
Late invoices
ERP navigation

How do you run a close in Business Central, GP and NetSuite?

Menu names shift by version, role and setup, so use each product's search to confirm yours. These are the pages and routines the close touches. For Business Central, see our Business Central practice; for GP, Dynamics GP.

0 of 12 settled
Dynamics 365 Business Central
Microsoft Dynamics GP
NetSuite
With an AI agent

How does an approval-first AI agent help with the close?

An agent works inside your ERP and does the matching and drafting. A person approves every action. It doesn't post anything on its own. See how month-end close automation works.

  1. 1
    Agent

    Pulls the data

    Reads the subledgers, bank lines and trial balance through the ERP's own interfaces, with a read-only role to start.

  2. 2
    Agent

    Drafts and flags

    Proposes accruals, matches bank lines, runs the tie-outs and flags variances over your threshold, each with its source.

  3. 3
    Your team

    Reviews and approves

    The preparer and reviewer see each proposed entry and approve, edit or reject it. Nothing posts until they do.

  4. 4
    Agent

    Posts and logs

    Approved entries go to the ERP with the evidence attached, and every step lands in an audit trail.

  5. 5
    Our team

    Sets it up

    We map your close tasks, set the permissions and tune thresholds with your controller. Start with a process assessment and see human-in-the-loop agents.

FAQ

What do controllers ask about the month end close checklist?

How long should a month-end close take?

Three to five business days is a common target for a single-entity company with clean subledgers. Multi-entity groups, heavy inventory or manual bank feeds take longer. Track your own days and shorten them one task at a time. Our month end close process guide covers the sequence in more detail.

What's the difference between a soft close and a hard close?

A soft close lets you produce management numbers while the period stays open for adjustments. A hard close locks the period so nothing posts to it. Many teams soft close on day 3 and hard close after review.

What should we do about invoices that arrive after the close?

Accrue an estimate at month end, supported by the receiving report or contract. Book the difference when the invoice arrives, in the open period. Don't reopen a locked period for a small variance.

Do we have to reconcile every account every month?

No. Reconcile cash, AR, AP, inventory and payroll liabilities monthly. Lower-risk accounts can follow a schedule by risk and balance, if your controller documents it. For AR, see our accounts receivable reconciliation routine.

Which accounting standards touch the close?

Revenue recognition under FASB ASC 606 and lease accounting under ASC 842 both generate month-end entries, such as deferred revenue releases and lease amortization. Your auditors will expect them to follow documented policy.

What happens if the numbers don't tie?

Find the difference before moving on. Check for postings straight to a control account, items in the wrong period, and unposted batches. The template's status column keeps the item open and visible until it's cleared.

Want the close to run itself, with you in control?

Cut your close with an agent you approve

Bring your checklist and your ERP. We'll show where an approval-first agent fits and where it doesn't.

Book Appointment
Sahil kataria (1)
Sahil Kataria

Founder and CEO

amit Kumar
Amit Kumar

Chief Sales Officer

Talk To Sales

USA

+1 270-550-1166

flag

+1 270-550-1166

Phil J.
Phil J.Head of Engineering & Technology​
QServices Inc. undertakes every project with a high degree of professionalism. Their communication style is unmatched and they are always available to resolve issues or just discuss the project.​
Assured

Thank You

Thanks, we’ve got your details. A named member of our team will reply within one business day.