Month-End Closing Checklist in Excel for Small Businesses

Quick Answer: A small-business month-end closing checklist in Excel lists each close task in order (collect statements, record missing transactions, reconcile bank and card accounts, post accruals and adjustments, review the reports, lock the period) with columns for owner, due day, status and evidence. Reuse the same workbook each month and add a tab per month so open items carry forward.

Closing the month means getting the books to a point where the numbers for that month will not change again. For a small business that usually takes one to five working days and follows the same sequence every time: gather the source documents, finish recording, reconcile, adjust, review, then lock. An Excel checklist keeps that sequence visible and shows who is holding up what.

Why use an Excel checklist for the close at all?

Most of the close is not hard. It is a long list of small jobs, several of which depend on each other, done once a month by people who are also doing other work. The failures are almost always omissions: the payroll accrual nobody posted, the second credit card nobody reconciled, the sales tax liability that was never compared with the return. A checklist turns memory into a list.

Excel suits this because the checklist is a table, it needs a few formulas for dates and status, and everyone already has it. Dedicated close-management software adds approvals and audit trails that larger teams need; a business with one bookkeeper and an owner who reviews the numbers rarely does.

The month-end close checklist, task by task

The order below matters. Reconciling before every transaction is recorded means reconciling twice. Reviewing the profit and loss before accruals are posted means reviewing numbers you are about to change.

Stage 1: Gather (business day 1)

1. Download all of the month's bank and credit card statements for the month, including savings accounts and cards used only occasionally.
2. Export the payment processor and marketplace payout reports (Stripe, Square, PayPal, Shopify, Amazon) for the same dates.
3. Collect vendor bills received after month end that relate to the month just closed.
4. Get the payroll register for any pay runs dated in the month.

Stage 2: Record (days 1–2)

1. Bring in bank and card transactions through the software's bank feed, or import them from the statement files.
2. Code every uncategorized transaction. Transfers between your own accounts and credit card payments are not expenses.
3. Enter bills and invoices that are missing, and apply customer payments to the invoices they paid.
4. Record owner contributions and draws to the equity accounts.

Stage 3: Reconcile (days 2–3)

1. Reconcile each bank account to its statement closing balance.
2. Reconcile each credit card account to its statement balance.
3. Tie payment processor clearing accounts to zero, or to the payout in transit.
4. Compare accounts receivable and accounts payable aging totals with the balance sheet.
5. Check loan balances against the lender's statement and split the payment between principal and interest.
6. Agree payroll liabilities to the payroll provider's report.

Stage 4: Adjust (day 3)

1. Post accruals for expenses incurred but not billed (utilities, contractors, interest).
2. Record deferred revenue for payments received ahead of the work.
3. Amortize prepaid expenses such as annual insurance or software subscriptions.
4. Run depreciation for fixed assets.
5. Record sales tax collected and compare it with what will be filed.

Stage 5: Review and lock (days 4–5)

1. Compare this month's profit and loss with last month and the same month last year; explain any line that moved materially.
2. Scan the balance sheet for negative balances where none should exist and for suspense or "ask my accountant" accounts that are not empty.
3. Save the reports (P&L, balance sheet, reconciliation reports) to the month's folder.
4. Set the closing date or period lock in your accounting software so nobody posts into the month by accident.

Cash-basis businesses can skip most of stage 4: accruals, deferred revenue and prepaid amortization belong to the accrual method, where income and expenses are recorded when earned or incurred rather than when cash moves.

How do you build this checklist in Excel?

Put the tasks in a table with these columns:

Add conditional formatting so a TRUE in the Late column turns the row amber. Above the table, a summary line with =COUNTIF(F:F,"Done")/(COUNTA(B:B)-1) shows how much of the close is finished, which is the number an owner actually wants to see.

Two layout choices make the workbook last. First, keep one tab per month and copy last month's tab to start the next, so the task list improves over time instead of being rewritten. Second, keep a "Recurring issues" tab where you note anything that slowed the close down (a card statement that always arrives late, a vendor that bills a month behind). Those notes are where the next month's improvements come from.

WORKDAY and EOMONTH are standard Excel date functions; look them up, along with data validation lists and conditional formatting, in Microsoft's Excel help center.

What slows a small-business close down?

In practice the delay is almost never the accounting. It is waiting for information.

• Statements that are not in a usable form. A bank feed that dropped a week of transactions, or a card that has never been connected, means someone has to rebuild the month from the PDF statement. If your bank offers a CSV or QBO download for the period, that is the fastest fix. If all you have is the PDF, QuickBankConvert turns it into rows you can import, and the QuickBooks import guide covers bringing them into the books. A free account downloads CSV and Excel; the accounting import formats are on paid plans, listed on pricing.
• Receipts the owner is still holding. Set a rule that receipts arrive by business day 2 or the transaction is coded on the information available.
• Unreconciled prior months. If last month was never reconciled, this month's reconciliation inherits every one of its errors. Fix the oldest month first; catch-up bookkeeping describes how.
• Reconciling items nobody owns. An uncleared deposit from three months ago needs a name next to it. The account reconciliation template has an owner and age column for exactly this.

Which reconciliations belong on the checklist?

Every balance sheet account with a balance should be reconciled at least quarterly; cash and credit card accounts should be reconciled every month, because they are where errors and fraud show up first. A simple way to decide the frequency:

For the bank side in detail, the bank statement reconciliation guide explains matching and how to handle outstanding items, and how to do account reconciliation covers the other balance sheet accounts.

Keep the evidence

The checklist's Evidence column is not decoration. When an accountant prepares the year-end return, or a lender asks how the numbers were produced, a folder per month holding the statements, the reconciliation reports and the final P&L and balance sheet answers the question in minutes. The IRS's guidance on how long to keep records sets three years as the general period, longer in specific cases such as employment tax records, which it says to keep for at least four years.

Related guides

• Chart of accounts for a small business
• Bank reconciliation in Excel
• Reconciling the balance sheet
• Bookkeeping for small business