Free resource · No. 07
14,228 downloads
The Close Library · Vol. III

The month-end close checklist for closing in five days, not twelve

150 tasks. Six phases. Three industry add-ons. The workbook 200+ accounting firms use to close client books in five business days, without adding headcount. Free, no card, no sales follow-up.

Preview in Google Sheets ungated
CPA-reviewed
Built for QBO firms
Ungated preview
month-end-close-checklist.xlsx
Master Calendar
1 · Pre-Close
2 · Cash
3 · AR/AP
+ 9 more
#TaskDayOwnerStatus
42Bank rec, operating accountD+1RKDone
43Stripe payouts → bankD+1RKDone
44 Brex card reconciliation D+2AMIn prog
45 FX revaluation, EUR & GBP D+2AMQueued
46Cash position dashboardD+2RKQueued
4713-week cash forecastD+2JTBlocked
48AR sub-ledger to GL tie-outD+3SMQueued
150 tasks · 6 phases
● 38 done● 12 in prog● 100 queued
v3.2 · 2026

Trusted by QBO firms managing 8 to 800 clients

Northwind Accounting·Aperture CPA·LATTICE.CPA·Halberd & Co.·Meridian Books·Brisk Bookkeeping·FIELDNOTE.LLC·Saltline Group·
Northwind Accounting·Aperture CPA·LATTICE.CPA·Halberd & Co.·Meridian Books·Brisk Bookkeeping·FIELDNOTE.LLC·Saltline Group·
Quick answer
For people in a hurry

A month-end close checklist is a structured task list finance teams work through to finalize their books each month. A complete checklist covers six phases (pre-close, cash and bank reconciliations, AR/AP and revenue, adjusting entries, review, and reporting) and typically contains around 150 items. Top-decile accounting firms close in five business days. The median takes eight to ten. Bottom-quartile firms take twelve or more.

Top decile
3 to 5 days
Median
8 to 10 days
Bottom quartile
12+ days
01

Why your close takes twelve days

Most QBO firms can shave a week off their monthly close without hiring anyone. They just need to stop doing four things. We've sat in the war room with about 400 firms during close week, and the same four frictions show up every time.

The good news is none of them require a new accounting system, a CPA exam re-take, or buying a $30K close suite. They require a checklist that names the friction, assigns the work, and refuses to let tasks drift.

01

You're running tasks in a relay race that should be a four-lane track

Bank recs don't need AP to finish first. Revenue cut-off doesn't need depreciation. Reporting doesn't need every accrual posted. The teams shipping in five days realized this and broke the sequential chain. Different humans, different tabs, same day one.

02

Your senior accountant is doing $9-an-hour work for $90 an hour

If your most experienced person is tick-and-tying credit card statements line by line on Day 1, you're burning the wrong fuel. Categorization, document matching, and recurring journal entries are the highest-leverage candidates for automation. Review and judgment are not.

03

No clear owner per task

"I thought you were doing it" is the most expensive sentence in finance. Every line on the checklist needs a named human in the Owner column. Not the AP team. Not accounting. A specific person with initials. This single change kills more close delays than any software you can buy.

04

You're reviewing at the end instead of all the way through

Slow closes batch review at the finish line and discover errors at hour 96. Fast closes review continuously. Flux analysis runs before the period gets re-opened, not after. Variance commentary gets written the same day the journal hits, while context is still warm.

Operator's note

The single biggest unlock is not a tool. It's giving each phase a Day-of-Month deadline and refusing to let any task drift later. The discipline of lock the GL by Day 8 or the dashboard goes red reshapes everything upstream. Owners scope smaller. Reviewers respond faster. Surprises surface earlier.

02

What's inside the template

Six core phase tabs covering 150 tasks. Three industry-specific add-on tabs for SaaS, e-commerce, and agency clients. A master calendar that auto-rolls up status. Plus an owner matrix and a live dashboard tab.

13
workbook tabs
150
close tasks
3
industry add-ons
5d
target timeline
Phase 1 · Day -3 to 0~15 tasks

Pre-Close

Send pre-close communications to budget owners. Freeze new vendor bills. Confirm payroll posted. Verify all bank feeds are synced before Day 1.

Phase 2 · Day 1-2~20 tasks

Cash and Bank Recs

Reconcile every operating, savings, FX, and credit card account. Tie Stripe and Plaid feeds. Update the 13-week cash forecast and post FX revaluation entries.

Phase 3 · Day 3-4~25 tasks

AR, AP, and Revenue

Sub-ledger tie-outs. Aging buckets. ASC 606 contract review. Deferred revenue rollforward. Three-way match exceptions cleared by Day 4.

Phase 4 · Day 5-6~22 tasks

Adjusting Entries

Prepaid amortization. ASC 842 lease entries. Depreciation. Stock-based comp. Accruals for bonus, PTO, and 401(k). Intercompany eliminations.

Phase 5 · Day 7-8~20 tasks

Review and Flux

P&L flux versus prior month, prior year, and budget. Balance sheet flux. Every sub-ledger tied. All journals approved. Period locked by end of Day 8.

Phase 6 · Day 9-10~18 tasks

Reporting

Income statement, balance sheet, cash flow. Departmental P&Ls. Board KPI scorecard. Variance commentary. Investor update package.

Add-on
SaaS
+15 tasks · MRR · NRR · ASC 606
Add-on
E-commerce
+12 tasks · Shopify · Amazon · nexus
Add-on
Agency
+10 tasks · WIP · utilization · retainer
Month-end close, by the numbers

What the data says about a healthy close

Industry benchmarks pulled from the AFP Working Capital Survey 2025, the AICPA Close Benchmarks report, and Finlens close data from 200 accounting firms. Numbers your CFO can quote in a board meeting.

5
days

Target close timeline for top-decile accounting firms. The fastest 10 percent close in 3 to 5 business days.

12
days

Average close timeline at firms without close automation. Bottom-quartile firms take 12 or more.

60%
of the list

The portion of a typical 150-task checklist that can be safely automated with current tooling.

6 hrs
per client / month

Average time saved per client per month when firms move from manual close to automated workflows.

150
tasks

The number of distinct line items on a thorough close checklist for a single client.

38%
of firms

Share of accounting firms that still take 10+ days to close monthly books, per the AFP 2025 survey.

94%
match rate

Average auto-match rate Finlens achieves on bank and credit card reconciliations for typical QBO clients.

4
new clients

Median number of additional clients a 4-person firm can take on after cutting close time from 12 days to 5.

Free download

Want the workbook before you keep reading?

Drop your email and we'll send the 150-task Excel template to your inbox in two clicks. Used by 200+ firms.

Live preview · ungated

Browse the whole thing before you download

Month-End Close Checklist · Finlens v3.2
Auto-saved
FileEditViewInsertFormatDataTools
ABCDEF
1 #TaskPhaseDue DayOwnerStatus
2 001 Send pre-close comms to budget owners Pre-CloseD-3PRDone
3 002Confirm cutoff dates with AP/ARPre-CloseD-2PRDone
4 003 Freeze new vendor bills after EOD D0 Pre-CloseD-1AMDone
5 004Confirm payroll postedPre-CloseD-1AMDone
6 005 Bank reconciliation, operating Cash & BankD+1RKIn progress
7 006Bank rec, FX accounts (EUR, GBP)Cash & BankD+1RKQueued
8 007 Stripe payouts → bank reconciliation Cash & BankD+1RKQueued
9 008Brex card reconciliationCash & BankD+2AMBlocked
10 009FX revaluation entriesCash & BankD+2AMQueued
11 01013-week cash forecast updatedCash & BankD+2JTQueued
12 011AR sub-ledger to GL tie outAR/AP/RevD+3SMQueued
13 012 Deferred revenue rollforward (ASC 606) AR/AP/RevD+3SMQueued
14 013ASC 842 lease ROU amortizationAdjustingD+5PRQueued
15 014 Stock-based comp expense (ASC 718) AdjustingD+5PRQueued
16 015 P&L flux: actual vs prior month ReviewD+7JTQueued
17 … 135 more rows
150 tasks · 6 phases
Open in Google Sheets ↗
03

How to use this checklist

Six steps. About 45 minutes to set up the first time. After that it repeats every month with near-zero overhead.

~45 min initial setup
  1. 1

    Download in your preferred format

    Excel works best for senior accountants. Google Sheets is the easier choice for collaborative firms. Use Notion if your practice already runs there. All three stay in sync if you maintain them in parallel.

  2. 2

    Assign owners in column C

    Every task gets a named human. Initials are fine. Open the Owner Matrix tab to verify nobody is over-assigned on the same day. The most common mistake here is making yourself the owner of more than 20 tasks. That's a planning failure, not a workload one.

  3. 3

    Set the due day per task

    Day 1, Day 2, and so on. The defaults assume a 5-day close target. If your current close is 10 days, give yourself a 7-day target first. The dates auto-cascade once you set the close date in README.

  4. 4

    Update status daily during close

    Four states only: Not Started, In Progress, Blocked, Done. Conditional formatting paints rows green, amber, or red. If you can't update status in under 30 seconds per task, your task is too big. Split it.

  5. 5

    Review the dashboard at morning standup

    15 minutes at 9:00 am. The Status Dashboard tab shows percent done per phase, days remaining, overdue count, and blockers. Read it left to right. If you find yourself reading it twice in one meeting, the standup is too long.

  6. 6

    Archive at month end

    Save the workbook to your close folder with the month name. Link supporting docs in column G. When your auditors ask for evidence, you'll already have it pulled.

04

Seven month-end close best practices the 3-day firms have in common

Hard-won. Occasionally controversial. Pick three to start. Add the rest over the next two close cycles.

№ 01

Run a soft close mid-month

Spend a half-day on Day 15 doing a dry run. You catch broken integrations and missing accruals while there's still time to fix them. Not at hour 96 of real close, when everyone is running on coffee and frustration.

№ 02

Parallelize bank recs and AP cutoff

These don't depend on each other. Different humans, different tabs, Day 1 morning. You just saved 8 hours from your critical path before lunch.

№ 03

Pre-build recurring JE templates

Depreciation, SBC, lease amortization, prepaid amort. All formulaic. Build them once. Copy-paste forward. The senior accountant who re-derives these every month is doing more work than they need to.

№ 04

Lock the GL on Day 8. No exceptions

Discipline forces upstream behavior. Firms that allow "just one more entry" close on Day 14. Firms that lock hard close on Day 8. The rule changes how your team scopes work in the first place.

№ 05

Run flux before you re-open

Order matters. Find variances during review, not after distribution. Re-opening a "closed" period is a credibility tax with your CFO and your auditors. It says you don't trust your own process.

№ 06

Standardize variance commentary

Any line variance greater than 5 percent or $10K gets a one-line explanation. Same format every month. Your CFO scans it in 90 seconds. The board pack writes itself.

№ 07

15-minute daily standup during close

9:00 am, standing, three questions: Done since yesterday? Doing today? Blocked? Cuts surprise blockers by about 70 percent based on Finlens customer data. The shortest meeting on your calendar saves the longest week.

05

Manual close vs automated close

Time per task for a single mid-sized QBO client. The right column is what firms see in their first three months on Finlens. The middle column is what most QBO firms are doing right now, by hand, in spreadsheets.

Close taskManual close With Finlens Time saved
Bank reconciliation 4 to 6 hours per clientUnder 15 minutes~95%
Credit card reconciliation 2 to 3 hours per clientUnder 10 minutes~92%
Recurring journal entries Manually entered every month Auto-drafted. You approve.~85%
Sub-ledger tie-outs 90 minutes per ledgerContinuous. Always tied.~80%
P&L flux commentary Written from scratchFirst draft auto-generated~65%
Document capture and matching Manual upload, manual codeEmail forward, auto-coded~88%
Daily close standup 30 minutes15 minutes~50%
Total days to close 10 to 12 days 5 days~60% faster

Data source: median of 80 QBO firms in their first 90 days on Finlens. Your numbers will vary based on client count and transaction volume. See how this looks for your firm.

06

Industry add-ons

Generic close checklists fail at the seams. Specifically, where your client's industry meets GAAP. The template ships with three add-on tabs that bolt onto the core 150 tasks without re-numbering anything.

+15 tasks

SaaS

  • MRR and ARR rollforward (new, expansion, contraction, churn)
  • Net dollar retention by cohort
  • Burn multiple, magic number, Rule of 40
  • Deferred revenue waterfall
  • ASC 606 disclosures
  • LTV and CAC by acquisition channel
+12 tasks

E-commerce

  • Shopify settlement reconciliation
  • Amazon FBA fee reconciliation
  • Sales tax by state with nexus tracking
  • Inventory rollforward and shrinkage
  • Returns reserve and refund liability
  • Gift card liability rollforward
+10 tasks

Agency and Services

  • Project WIP schedule
  • Unbilled revenue by project
  • Utilization and realization rate by team
  • Time and materials cut-off
  • Retainer revenue amortization
  • Subcontractor accruals
07

Five month-end close mistakes that cost you a week

01

Skipping the soft close

If you only run close once a month, that's the first time you find problems.

+
The fastest firms run a mid-month dry run on Day 15. It surfaces broken bank feeds, missing accruals, and integration failures while you still have two weeks to fix them. Cost: half a day. Savings: regularly two to three days off real close.
02

No clear task owners

"I thought you were doing it" is the most expensive sentence in finance.

+
Every task on the checklist needs a named human in the Owner column. Not "AP team." Not "accounting." A specific person, by name or initials. The Owner Matrix tab in the template gives each person their full list across phases so nobody is surprised mid-close.
03

Pulling reports before journals are approved

You'll re-do the work. Then you'll do it again.

+
Reporting tasks belong in Phase 6 for a reason. Generating financials while adjusting entries are still posting means you regenerate them later. And the version your client already screenshotted is now wrong. Lock the period first.
04

No flux variance threshold

Without a rule, every variance becomes a debate.

+
Set a written rule. For example: any line variance greater than 5 percent or $10K versus prior month gets a one-line written explanation. The threshold itself is less important than having one. The Review phase has a flux template tab that automates this.
05

Re-opening the period after close

A re-opened close isn't a close.

+
If you re-open the period twice a quarter, what you have isn't a close. It's a perpetual approximation. Find errors in Phase 5 review. Post true-ups in the next month with a clear adjusting entry. Maintain audit credibility.
08

Month-end close glossary

The vocabulary you actually need. Most close glossaries try to teach you accounting. This one assumes you already know it. Use these definitions to align your team, brief new hires, or settle the occasional Slack debate.

Close calendar
A day-numbered schedule that maps every close task to a target completion day. Day -3 through Day +10 is the typical range. The calendar is the spine of any working checklist.
Flux analysis
A line-by-line comparison of current period results against a baseline, usually prior month, prior year, or budget. Any variance over a stated threshold gets a written explanation. Lives in Phase 5.
Sub-ledger
A detailed transaction record (AR, AP, fixed assets, inventory) that aggregates into a single GL control account. The sub-ledger must tie to the GL before close is final.
Hard close vs soft close
A soft close is a fast, estimate-driven close for internal reporting. A hard close is the final locked period of record. Most firms run a soft close on Day 15 and a hard close at month-end.
Accrual
Recognition of revenue or expense before cash actually moves. Bonus accruals, PTO accruals, and utility accruals are common. Reversed in the following period if not paid.
Cutoff
The line that determines which period a transaction belongs to. A vendor bill dated March 30 received on April 3 still belongs to March. Cutoff disputes are the most common source of inter-month variances.
3-way match
An AP control where the purchase order, the receipt, and the vendor invoice all agree on quantity, price, and items before payment posts. Exceptions get flagged for review during Phase 3.
Adjusting journal entry (AJE)
Any GL entry posted during close to correct, accrue, defer, or reclassify a transaction. Recurring AJEs include depreciation, amortization, and SBC. One-time AJEs cover errors and reclasses.
Trial balance
The list of every GL account balance at a point in time. Debits must equal credits. The trial balance is the input to financial statements and the first thing your auditor will ask for.
Period lock
A system setting in QuickBooks Online (or any GL) that prevents further entries from posting into a closed period. The fast firms lock on Day 8. The slow ones never lock at all.
09

Month-end close FAQ

The questions accounting firms ask us most often. Written to be quoted by humans, ranking engines, and AI assistants alike.

Schema.org/FAQPage · Indexed
Still have questions?

Email close@finlens.app. Real CPAs respond, usually within an hour.

What is a month-end close checklist?

+
A month-end close checklist is a structured task list that finance teams work through to finalize the books for a given month. A thorough checklist covers six phases: pre-close preparation, cash and bank reconciliations, AR/AP and revenue, adjusting entries, review, and reporting. Most include between 100 and 150 line items, each with a named owner and a target completion day. The version on this page contains 150 tasks and is built specifically for QuickBooks Online firms.

How long should month-end close take?

+

Industry benchmarks for accounting firms:

  • →Top decile: 3 to 5 business days
  • →Median: 8 to 10 business days
  • →Bottom quartile: 12 or more business days

The biggest drivers of speed are parallel workflows, reconciliation automation, and clarity of task ownership. Firms that hire more staff without changing the process rarely close faster.

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

+
A soft close is a fast, estimate-driven close used internally for management reporting. Accruals can be revised later. A hard close is the final, audited close where the period is locked and no further adjustments are permitted. Most firms run a soft close mid-month and a hard close at month-end.

What are the 5 steps of month-end close?

+
The five canonical steps of month-end close are:
  1. Record all transactions and run cutoff
  2. Reconcile bank, AR, AP, and sub-ledgers
  3. Post adjusting and accrual entries
  4. Review trial balance and run flux analysis
  5. Generate financial statements and management reporting

Can month-end close be automated?

+
Yes. Roughly 60 percent of the typical 150-task close checklist can be safely automated with current tools. The highest-leverage candidates are bank reconciliations, credit card matching, recurring journal entries, sub-ledger tie-outs, and first-draft flux commentary. Manual judgment is still required for review, approval, and any non-standard transactions. The right model is automation plus oversight, not automation alone.

How can AI accelerate month-end close?

+
Finlens categorizes transactions, matches documents to entries in the GL, drafts recurring journal entries, and flags variance outliers. Your team reviews and approves. Firms using Finlens close in 5 days instead of 12 and save roughly 6 hours per client, per month. Agents handle the grind. Your team signs off.

What is the fastest a month-end close can be?

+
The fastest closes documented are 1 to 2 business days, achieved by firms with deeply integrated systems, well-instrumented sub-ledgers, and high reconciliation automation. For most QuickBooks Online accounting firms, a realistic target is 5 business days. Anything faster usually requires either fewer transactions or significant up-front engineering investment.

What tools do accounting firms use for month-end close?

+

A typical QBO firm stack:

  • ·GL: QuickBooks Online
  • ·Close automation: Finlens
  • ·Practice management: Karbon, Canopy
  • ·Document capture: Dext, Hubdoc
  • ·Reporting: Fathom, LiveFlow, Reach Reporting

How do you organize a month-end close calendar?

+
Build a day-numbered calendar starting from Day -3 (pre-close) and running through Day +10 (reporting). Assign every task an owner, a due day, and a status. Use a single master calendar tab that pulls from per-phase sub-tabs. Hold a 15-minute daily standup during close week to surface blockers fast. The downloadable template ships with this exact structure pre-built.

What are common month-end close mistakes?

+
The five most expensive month-end close mistakes are:
  1. Skipping a mid-month soft close
  2. Leaving tasks without a named owner
  3. Generating reports before journals are approved
  4. Having no written flux variance threshold
  5. Re-opening the period after close

Each of these costs an average firm about one day per month. Fixing all five takes a working checklist and discipline, not new software.

10
The Finlens part

Finlens automates the grind. Your team signs off

Bank recs, sub-ledger tie-outs, recurring journal entries, flux commentary, and the 13-week cash forecast. Finlens drafts them in the background. Your accountants review and approve.

Built natively for QuickBooks Online firms. No migration. No new GL. Add clients without adding headcount.

5d
avg close
6 hrs
saved · client · mo
1 day
setup
finlens · live close
running
Operating bank rec · April
2,847 transactions · 99.2% matched
12s
Brex card recon
414 charges · vendor mapping suggested
8s
Drafting recurring JEs · ASC 842 leases
14 entries · review pending
live
Flux commentary, P&L
queued · waiting for review approval
queued
Board KPI scorecard
scheduled · Day +9
queued
Progress · 92 / 150 tasks61%

Before Finlens, our close took 12 business days. Now we're done in 5. We added four clients without hiring anyone.

RT
Rachel Tanaka
Managing Partner · Midwest CPA Group · 38 clients
The Close Library

More from the resource shelf

3×
Faster bank rec
Template · Vol. I

Bank Reconciliation Template

3-tab workbook for multi-currency bank rec with timing-difference flagging.

A clean AR aging beats a fancy dashboard, every quarter.
Template · Vol. II

AR Aging Report Template

0/30/60/90+ buckets with CECL bad-debt allowance and dunning queue.

Receipt
→
Finlens
→
QBO
Template · Vol. IV

Year-End Close Checklist

280-item annual close with audit-ready supporting schedules and PBC list.

One last thing

Close in days, not weeks

Download the workbook, run your next close, then talk to us about automating the 60% you don't want to do twice.

Book a 30-minute demo