Skip to content
QB Specialist

Template

Month-end close template

A month-end close is the routine that proves a month is finished — every account reconciled, every adjustment made, the statements reviewed and the period locked. This template lays the close out as a task table with owner, frequency, and a done column, shown in full below so you can copy it and work the same steps every month.

Last reviewed July 2026

Closing the month is what turns raw data entry into books you can trust: it is the point where you prove the cash is real, make the adjustments that accrual accounting needs, and lock the period so the story of the month stops changing. Below is that routine as a table you can assign and work every month.

The month-end close task table

Work the table top to bottom. Replace the role labels in the owner column with the real people on your team, tick each task in the done column as you finish it, and don't skip ahead — each step assumes the ones above it are complete.

Month-end close — task template
Task Owner Frequency Done
Enter and categorize all transactions for the monthBookkeeperMonthly
Reconcile every bank account to its statementBookkeeperMonthly
Reconcile every credit card account to its statementBookkeeperMonthly
Reconcile loans and lines of credit to statementsBookkeeperMonthly
Clear Undeposited Funds to zeroBookkeeperMonthly
Review Accounts Receivable aging; follow up on overdueBookkeeperMonthly
Review Accounts Payable aging; confirm bills recordedBookkeeperMonthly
Reconcile payroll to the payroll provider's reportsBookkeeperMonthly
Reconcile sales tax payable to filingsBookkeeperMonthly
Record accruals, prepaids, and other adjusting entriesAccountantMonthly
Post the depreciation entryAccountantMonthly or quarterly
Review the Balance Sheet for negatives and odditiesAccountantMonthly
Review the Profit & Loss for anomaliesAccountantMonthly
Compare results to the prior month and budgetOwnerMonthly
Lock or close the periodAccountantMonthly

How to work the template each month

The first block reconciles everything the business touches — bank accounts, credit cards, loans, the Undeposited Funds holding account, payroll, and sales tax. This comes first on purpose: reconciliation is the check that recorded money is real, and every review further down assumes it. Skipping it and jumping straight to the Profit & Loss means reviewing numbers that may not be true. If reconciliation is where you tend to get stuck, the reconciliation workpaper template gives you the exact layout that proves a balance ties.

The middle block makes the adjustments that turn a cash-basis pile of transactions into accrual-ready books — accruals, prepaids, and depreciation — then reviews the two core statements for anything that looks wrong. The final step locks the period so a closed month cannot be quietly edited later. Set a closing date in QuickBooks after every close, and the story of a finished month stops changing behind your back. For the full reasoning behind each phase, read the month-end close process guide.

When the close won't finish

A template can order the work, but it cannot force an account to reconcile or a stuck balance to clear. If your close stalls in the same place every month, that is a signal the file has an underlying problem the monthly routine isn't built to fix. A free read-only QuickBooks review finds exactly what is blocking the close, and a one-time cleanup clears it so this template runs smoothly from then on. Prefer to work it yourself first? The interactive month-end close checklist saves your progress as you go.

Questions about the month-end close template

How is this different from the month-end close checklist?

The checklist is an interactive list that saves your progress in the browser for one person working a file. This template is the same routine as an assignable table — task, owner, frequency, and a done column — so a team can divide the close and see who owns what. Use whichever fits how you work.

How do I use the owner column?

Replace the role labels — Bookkeeper, Accountant, Owner — with the real people on your team, or leave them as roles if one person wears every hat. The point is that every closing task has a clear owner, so nothing falls between two people who each assumed the other did it.

Why does the order of tasks matter?

Because later steps depend on earlier ones. You reconcile cash before you review the Profit & Loss, because a review built on unreconciled cash is a review of numbers that may not be real. Work the table top to bottom and the close builds on a solid base each time.

How long should a monthly close take?

It depends on transaction volume and how clean the file is kept, so we won't invent a number. What is reliable is that a close run to the same template every month gets faster and more predictable, because you are maintaining a clean file rather than rediscovering a messy one.

What if I can never get the month to close?

A close that repeatedly stalls — accounts that won't reconcile, balances that won't clear — usually means an underlying problem the monthly routine can't fix on its own. A free review finds what is blocking the close, and a one-time cleanup clears it so the monthly template runs smoothly afterward.