Month-End Close Checklist for Bookkeepers (Free Template)

A month-end close checklist for bookkeepers closing many client books: day-by-day steps, a free template, and where AI saves time.

Save

It’s Wednesday, day 3 of the close, and 27 client files are open. Twenty-four of them are this month. Three are leftovers from last month that never got a receipt. Half the tabs are the same café. Client A is on Xero. The bank feed is fine. The Saturday cash-up receipts are not, and nobody has answered the question about a $640 transfer on the 18th. Until that list comes back, you can’t lock the month, and Client B’s QuickBooks file is already waiting behind it.

This month end close checklist is for that week. Same core list for every client, a short add-on where a client actually needs one, and the close dates spread out so they don’t all fall on day 5.

What a month-end close is

A month-end close is the work that makes one month’s numbers safe to send. You get the transactions in, reconcile the accounts that can be reconciled, ask about anything you can’t explain, send the reports, and lock the period so it stays still.

That’s the whole meaning. The reports come out of that work.

The month-end close checklist

Run the same month-end close procedures for every file. The order below is the month-end close process steps: a short prep, then five working days. The owner is the bookkeeper unless the line says the client answers. Skip a line that doesn’t apply. The free template is this list with a row per client.

Before the close day

  • Send one document request: statements where the feed is short, receipts, the payroll report if payroll runs outside the ledger, and a sales summary. The client provides them.
  • Write this client’s close day on the status board, so they aren’t stacked with everyone else.

Day 1: get the transactions in

  • Confirm bank and card feeds run through the last day of the month.
  • Download a statement for any account where the feed stopped. If only the client can log in, that download is theirs.
  • Code what’s sitting in uncategorised or suspense.
  • Match receipts to card and cash spending.

Day 2: reconcile

  • Reconcile every bank account to the statement.
  • Reconcile every credit card.
  • Clear undeposited funds, and any other clearing account that should be zero.

Day 3: invoices, bills and payroll

  • Review unpaid invoices. You prepare the list. The client decides any write-off.
  • Enter supplier bills that aren’t already in the ledger.
  • Check for duplicate bills. A bill paid on the feed and entered again from the PDF is the usual one.
  • Post the payroll journal if wages are calculated outside the ledger.

Day 4: tax line, balance sheet, questions

  • If a sales tax, VAT, GST or BAS return is due this period, tie the ledger to that return. Details by country are in the next section. If nothing is due, skip the line.
  • Read the balance sheet. Look for negative liabilities, amounts that have been uncleared for months, and a loan balance that doesn’t match the lender’s statement.
  • Note large movements on the profit and loss against last month. Two sentences a client can read is enough.
  • Send one list of questions. Not one email per question.

Day 5: sign off and lock

  • Apply the answers, and post only the journals a person has decided.
  • Send the profit and loss and the balance sheet.
  • Set the closing date in QuickBooks Online, or the lock date in Xero. You need admin access for this.
  • Mark the client closed on the board.

If day 4’s questions are still out on the morning of day 5, don’t lock. Move the close day, and say so on the board. A locked month with a guessed $640 is worse than a late one.

Month-end close procedures by client type

The core list covers a straightforward service client. Add a line only when the client has that thing, and write it under their name in the template. Client A, the café, gets a stock line. Client B, a plumber on QuickBooks Online, gets none.

Payroll. If payroll runs in the ledger, match wages, tax withheld and the super or pension payment to the payroll reports, and clear any liability left from an older period. If a bureau runs it, their report belongs on the document request. Day 3’s journal waits on that PDF.

Inventory. Compare a stock count, or their inventory report, with the inventory asset. A café that “doesn’t really do stock” can still be carrying coffee and food from the day the file was set up. Count it, or agree in writing that you won’t adjust it each month.

Deferred revenue. Anyone paid ahead of the work (a gym, a retainer) needs a schedule: invoiced, earned this month, still unearned. A person writes the journal from that schedule.

Sales tax, VAT, GST and BAS. Tie this out when a return is due. A quarterly filer doesn’t need the same check in the two months between returns.

  • United States. Sales tax is state and local. Separate taxable sales from exempt ones, and compare tax collected on the invoices with what that state’s return asks for. Use the due date that state already gave this client. There is no single federal sales-tax deadline to drop onto the list.
  • United Kingdom. A VAT-registered client usually sends a return every 3 months, including when there’s nothing to pay. The online deadline is usually one calendar month and 7 days after the period ends, and that is also the payment deadline, weekends included. That’s from GOV.UK’s VAT return guidance. Check the return against the ledger before anyone files.
  • Canada. GST/HST is monthly, quarterly or annual, from the setup already agreed with the CRA. Match tax collected and input tax credits to the period that is actually due. Read the frequency off the client file.
  • Australia. A business activity statement covers GST and, for many employers, PAYG withholding. The cycle is monthly, quarterly or annual, and lodging through a BAS agent can move a quarterly date. Read the date on the statement. Current dates are on the ATO’s BAS due dates page.

A month-end bookkeeping checklist for 20+ clients

Use the same month-end bookkeeping checklist at 24 clients. Change the calendar.

If every close day is the 5th, that morning is 27 open files and very little finished. Spread the dates. A client with an outside deadline keeps the early slot. Client A needs figures by the 10th because the landlord asks, so the close day is the 8th. Client B answers email in a batch on Thursdays, so the close day is the 16th: questions go out Wednesday, answers come back before the lock. Everyone else moves off the 5th. Ask once, write it down, and leave it there.

A simple board is enough until the book of clients outgrows it. One row per client:

Client Ledger Close day Status Blocker
Client A, café Xero 8 Waiting on client Saturday receipts; $640 transfer on the 18th
Client B, plumber QuickBooks Online 16 In progress Payroll report

On Monday, filter to Waiting on client. That filter is the chase list. Keep each blocker to a few words. When a second person needs the same view, or recurring tasks start getting missed, move the board into accounting practice management software and keep this checklist as the steps on each job.

Why closes stall: missing receipts and client questions

The reconciliation is rarely what stops the close. The stop is a receipt you don’t have, and a transaction you won’t categorise from the bank description alone.

Make it one weekly job per client. Collect every open item into a single list: date, amount, bank description, and the question in one line. Send that list once. Client A’s email is two lines. Saturday cash-up receipts, and “what was the $640 transfer on the 18th?” The $9 charge you can already see is the milk supplier stays off the email.

A date in the email gets more replies than “when you get a chance”. The routine for one reminder per client, instead of one per document, is in how to stop chasing clients for documents. When the receipts still arrive as three attachments of the same photo, a client portal for accountants gives each client one place to put them.

Stuck chasing the same clients every month? Grab the free checklist and send it before day 1. If you want that weekly list set up so you aren’t rewriting it, we can help with that.

Where AI saves time in the close, and where it shouldn’t decide

Use an assistant on the drafting. Keep a person on anything that changes the accounts.

Where it helps. A first pass on bank-feed categories, with the unsure lines marked, for you to accept in the ledger. A flag on odd balances: a negative liability, a bill that looks duplicated, a round-number transfer to the owner. A draft question list from the lines still uncoded, which you cut down before sending. A variance note from two months of profit and loss totals, three sentences, which you edit.

In a general chat tool, paste a small extract: date, amount, description, client name removed. The prompts for the question list and the variance note are in AI prompts for accountants. What goes wrong when software categorises unsupervised is covered in AI bookkeeping.

Where a person decides. Posting a journal (payroll, stock, deferred revenue, owner drawings). Writing off a debt, or calling a transfer a loan instead of income. Any tax treatment. Signing the month off and setting the lock. Anything with no statement, invoice or reply behind it.

Grok Bot is the assistant we’d use for the question list and the variance note. Setup and the other options are in the tools section.

How to do month-end closing in QuickBooks Online and Xero

How to do month end closing in QuickBooks Online, for a firm, is the checklist above and then a lock. The lock is the last click. A warning-only setting is a weak lock.

QuickBooks Online. An admin goes to Settings, Account and settings, Advanced, then Accounting. Turn on Close the books, enter the last day of the month, and choose a warning or a warning plus a password. Intuit’s steps are in Lock your books in QuickBooks Online. A warning alone still lets someone save the edit, so use the password when the client can change the file. The Exceptions to Closing Date report shows what changed afterwards.

Xero. An administrator opens Accounting, Accounting settings, Financial settings, and enters the lock date. Transactions on or before that date can’t be added or edited. Draft invoices, bills, expense claims and manual journals can still be saved. You can lock every user, or every user except administrators. If the client is an admin, excluding administrators leaves them free to edit. Xero’s steps are in Set up or remove lock dates.

Lock Client A on the 8th, once the receipts and the $640 are in. Leave Client B open until the 16th. One lock date for the whole firm undoes the stagger.

How long should a month-end close take?

It depends on transaction volume and on how long the client takes to answer. A café with a clean feed and a contractor with three loans and a payroll report that arrives on the 12th are different jobs, so this page doesn’t offer one universal number of hours.

Our plan is five calendar days per client: hands-on work on days 1 and 2, the question list on day 4, the lock on day 5. On a straightforward file the hands-on part is often a morning. The rest is waiting, which is why the close days are staggered.

When the same client misses day 5 every month, move the document request earlier and set the close day for when they actually read email.

Free month-end close checklist template

This month-end accounting checklist template is the core list, one block of rows per client. Columns are client, task, owner, day, status and notes. Client A and Client B are already filled in, one mid-close and one further along. Copy a block, rename the client, and set status back to Not started.

  • Excel workbook, free. This is the month-end close checklist Excel template. Status has a dropdown: Not started, Waiting on client, In progress, Done.
  • CSV, same rows. In Google Sheets use File, then Import. Keep the sheet in your own Drive.
  • For a month-end close checklist PDF, print this page and choose Save as PDF. The task list is near the top.

The file tracks close tasks. The free Client Onboarding & Document Tracker is the Google Sheet for the other half: what you asked for, what’s late, and a reminder you can copy.

If you’d like the close days and the question list running without rebuilding them each month, have a look at the systems we set up for firms.

Month-end close checklist software and other tools

Question lists, variance notes, a status pass. Start with Grok Bot. It can work in tools you already use, including QuickBooks Online, and it asks before it sends or changes something. ChatGPT, Claude and Microsoft Copilot draft the same note from a small anonymised paste. Keep the full client file out of them.

The same checklist on every client. Karbon holds recurring jobs, and its close checks (Aider) flag issues in QuickBooks Online and Xero. Financial Cents is recurring work for smaller firms. TaxDome and Canopy carry client jobs and a portal, useful when the problem is finding the statement. A very small firm can stay on the Excel file or a shared Google Sheet until a second person needs the board.

Review inside the close. Digits is its own ledger: it categorises, reconciles, and puts exceptions in front of a person. Double, formerly Keeper, sits on QuickBooks Online, Xero, Sage or NetSuite and leaves sign-off with you. Ramp’s accounting automation codes card spend and syncs it to QuickBooks Online, Xero and other ledgers, which only helps clients who spend on Ramp.

Receipts and bills. Dext captures receipts and bills and publishes them to QuickBooks Online, Xero and Sage. Hubdoc reads bills and receipts and can create the transaction in Xero or QuickBooks Online with the document attached. Someone still matches the receipt to the feed on day 1.

A ledger that can lock a period. QuickBooks Online and Xero are above. Sage Accounting can set a lockdown date so earlier transactions are view-only. FreshBooks Financial lock lets an owner, or an accountant with full access, stop edits to invoices, expenses, bills and journals before a date you choose.

The once-a-year version of this week is the tax season checklist for accounting firms.

Questions

What are the steps in month end close for a small business?

Get the month’s transactions in, reconcile the bank and cards, clear invoices and bills, review the tax line if a return is due, send the client one list of questions, then lock the period and send the reports. Add payroll, inventory or deferred revenue only when that client actually has them.

How long does month end close take?

It depends on how many transactions there are and how fast the client replies. On this checklist a straightforward file is spread over five calendar days. The hands-on work sits on the first two days and the lock on day five. The gap in the middle is usually the client, not the reconciliation.

How long should month end close take?

Give each client a close day and finish the hands-on work inside that week. Don’t promise figures the same afternoon if receipts are still out. For a bookkeeper with many clients, the useful target is a staggered calendar, so only a handful of files need you on any one day.

How do you speed up month end close?

Ask for receipts before day 1, send one question list per client each week, and stagger close dates so twenty files don’t all land on the 5th. An assistant can draft categories and the question list. A person still posts journals and signs the month off.

What does month end close mean in accounting?

It means making one month’s figures reliable enough to use. Transactions are in, accounts are reconciled, odd items have been questioned, reports have been sent, and the period is locked so a later edit doesn’t quietly change the numbers.

Why is month end closing important?

Tax returns, the client’s own decisions and next month’s work all sit on those figures. Leave the month open and a client, or a bank rule, can change September in November. You often won’t notice until something stops tying out.

Is month end close hard?

The reconciliation is usually the straightforward part. What’s hard is a missing receipt and an unanswered question, multiplied by clients who all want reports in the same week. A fixed list and staggered close dates make the week repetitive, which is what you want.

This guide covers running the practice, not tax law. Rules differ by country and change often, so check anything technical with your local tax authority or professional body.