The month-end close questions every small business owner asks — what the close is, the order to run it in, how reconciliation works, and how to do the whole thing in Excel or Google Sheets.
The month-end close is the routine you run after a month ends to make your books final for that month: record everything, reconcile every account, fix what doesn’t match, and produce a profit & loss you can trust. Until you close, your numbers are drafts — you don’t actually know what you earned. A good close turns “I think we did okay” into a P&L you can make decisions from.
Work in the same order every month: (1) enter all income, bills, and receipts; (2) reconcile bank and credit card accounts to their statements; (3) record journal entries for depreciation, prepaid expenses, and accruals; (4) review the P&L for anything that looks off; (5) lock the month. The free Month-End Close Checklist is the one-page version, and the Month-End Close Template runs the whole sequence in one workbook.
For a small business with clean weekly habits, about 1–3 hours. If it takes days, the problem is almost never the close itself — it’s a month of unentered transactions landing all at once. Logging income and expenses weekly is what makes the close short; the checklist just makes it orderly.
Compare your books to the bank statement line by line for the month. Everything in your books should appear on the statement except deposits in transit and outstanding checks; anything on the statement that isn’t in your books (fees, interest, NSF items) gets recorded. When you’ve explained every line, the difference between the adjusted bank balance and your book balance must be $0.00 — not close to zero, zero.
Don’t force it, and don’t plug the difference. Work backwards: check the opening balance first, then look for the usual suspects — a transaction entered twice, a transposed number (a difference divisible by 9 is the classic tell), a check recorded at the wrong amount, or last month’s outstanding items clearing at a different value. A reconciliation sheet that flags the difference as you go — like the one in the Month-End Close Template — turns this into a ten-minute hunt instead of an afternoon.
The recurring ones: depreciation on equipment and vehicles, amortization of prepaid insurance or rent, accrued expenses you’ve incurred but haven’t been billed for, accrued revenue for work done but not yet invoiced, and payroll accruals when payday straddles the month boundary. Total debits must equal total credits — if they don’t, the entry isn’t done.
Cash and bank reconciliations, credit card reconciliations, revenue review, expense and bill entry, payroll review, journal entries, a P&L read-through with a prior-month comparison, and a final “lock the month” step so old numbers stop changing. Our free checklist prints on one page; the full template’s checklist runs 18 tasks in close order.
Yes — plenty of small businesses do, especially single-owner businesses with straightforward transactions. A spreadsheet close works when the workbook enforces the discipline software would: a fixed checklist order, a reconciliation that must tie to $0.00, and balanced journal entries. That’s exactly how the Month-End Close Template is built, and it runs in both Excel and Google Sheets.
The year-end close is a monthly close plus everything tax season needs: tying every balance-sheet account to a year-end statement, final depreciation, inventory counts where relevant, and producing the clean annual numbers your tax return is built from. The Year-End Close Bundle pairs the year-end sequence with the monthly system.
Close one month at a time, oldest first — never try to fix a whole year in one pass. Each month gets the same sequence: enter, reconcile, adjust, review. Most people find the first month is the slow one and the rest speed up as the routine sets in. Start with the free checklist; if reading standard print is a barrier, the Accessible Edition checklist runs the same close in large print.
Two free downloads run this whole page in practice: the Month-End Close Checklist (page one of the 18-step close, printable) and the Debt Payoff Starter Sheet. When you want the full system in one workbook, the Month-End Close Template is $29 on Gumroad and Etsy.
These answers are general bookkeeping education — not tax, legal, or CPA advice for your specific situation.