End-of-Month Closeout Checklist
A clean monthly close means seven steps in order: reconcile sales vs. deposits, count inventory, review expenses, calculate profit and loss, plan next month, reorder, and back up. Print one each month and tax-time bookkeeping becomes a 30-minute review instead of a January nightmare.
A printable one-page checklist that walks you through seven monthly closeout steps every maker, baker, and creator should run before opening the next month: reconcile sales vs. deposits, check inventory, review expenses, calculate P&L, plan next month, reorder, and back up. Each step is broken into concrete sub-tasks with a one-line "why this matters" so the work doesn't feel like busywork. Designed to be printed once a month — month and year fields at the top, notes section at the bottom, no software required.
- Sales reconciliation: match per-channel totals (Etsy, Shopify, Square, Stripe, in-person) against bank deposits
- Inventory check: physical counts on finished goods and high-value raw materials, with a write-off step
- Expense review: download statements, categorize transactions, file cash receipts, back out personal-use items
- P&L calculation: revenue, COGS, operating expenses, gross and net profit — compared to last month
- Planning, reorder, and backup steps so the close ends with the next month already set up
- Notes section to capture what went sideways and what to remember next time
Why monthly closes matter
A monthly close turns the end-of-year tax scramble into 12 small habits. The numbers you need on April 15 — gross revenue by channel, COGS, ending inventory value, deductible expenses by category, mileage — are easy to assemble when you closed every month and impossible to reconstruct from memory when you didn't. The work is the same; only the timing changes.
It also gives you a defensible profit number every 30 days. Most makers mistake "money in the bank" for "profit." A monthly P&L splits gross revenue from net profit and surfaces problems (margin compression, fee creep, mis-categorized spending) before they become a year of bad data.
The 15-minute version
Steps 1–4 (sales reconciliation, inventory check, expense review, P&L) are roughly 10 minutes if your data lives in one place — open each channel's monthly report, match deposits, spot-count high-value SKUs, categorize the month's expenses, run the report. Steps 5–7 (planning, reorder, backup) are 5 more.
The longest version of this work is when sales data is in three platforms, inventory is in a spreadsheet, and expenses are in a stack of receipts. The fastest version is when they share a system. Either way, the act of closing monthly is what makes the work small; deferring it is what makes it large.
Or skip the spreadsheet entirely
A monthly close is a habit, not a heroic effort. Ardent Seller pre-builds the per-channel sales totals, COGS, P&L, and reorder list every step on this checklist asks you to compile — so the close goes from a half-day reconciliation to a 15-minute review.
Profit & Loss reports
Pull a month-over-month P&L with revenue, COGS, operating expenses, and net margin in one click — no spreadsheet math.
Guided stocktake
Turn the monthly count into a 15-minute workflow with variance flags and a defensible audit trail.
Reorder thresholds
Set per-material thresholds and get a ready-to-order list every close, so step 6 is a review instead of a hunt.
Frequently asked questions
How do small businesses close their books each month?
A complete monthly close has seven steps: (1) reconcile sales vs. deposits per channel, (2) count physical inventory and adjust for shrinkage, (3) review and categorize expenses, (4) calculate P&L (revenue − COGS − operating expenses), (5) plan next month's production and goals, (6) place reorders for materials at or below reorder point, and (7) back up financial data. The whole thing takes 30 minutes to half a day depending on data volume.
What is included in a P&L for a craft business?
Profit and Loss: revenue (gross sales by channel), minus cost of goods sold (materials and direct labor), equals gross profit. Then minus operating expenses (platform fees, shipping, marketing, software, insurance, utilities, supplies), equals net profit. Compare month-over-month and against the same month last year to spot trends in margin and category spending.
How do I reconcile sales channels at month-end?
For each platform (Etsy, Shopify, Square, Stripe, in-person cash): pull the month's gross sales report, subtract platform fees and refunds, and verify the net deposit total matches what hit your bank account. Discrepancies are usually fee math, refund timing, or held-payments. Document any unreconciled differences in a notes column for next month.
How long should a monthly close take?
Under 30 minutes if your sales, inventory, and expenses share a system. Half a day if they live in three different platforms. The work scales with data fragmentation, not with revenue — a $5K/month maker with one channel and a single spreadsheet closes faster than a $25K/month maker reconciling across Etsy, Shopify, Square, and a paper expense file.
Related resources
Inventory Tracker Starter Kit
A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.
Monthly Inventory Count Sheet
Three sections, one page. Print, count, and reconcile raw materials, finished goods, and packaging — with expected, actual, and variance columns.
Year-End Inventory Reset Checklist
A two-page printable for the December/January annual ritual — full stocktake, write-off identification, dead-stock liquidation plan, and the Schedule C Part III math that turns this year’s ending inventory into next year’s opening balance.
Small-Batch Production Planning Playbook
A printable six-page playbook for handmade-goods producers — five planning principles, the demand-driven batch-sizing formula, and four worksheets for sizing, run logging, weekly WIP, and post-run audit.
Vendor & Supplier Contact Organizer
A four-page fillable PDF for tracking suppliers — vendor records, an alternate-supplier scoring sheet, and a one-row-per-vendor master index. Type into it in your PDF reader, or print blank copies for the clipboard.
Quarterly Estimated Tax Worksheet
A working Excel worksheet for self-employed makers — log income, set filing status, and the four quarterly estimated-tax payments calculate themselves. SE tax (15.3%) plus federal income tax math built in, with a safe-harbor escape hatch on its own tab.
Schedule C Tax Expense Tracker
A working Excel expense tracker organized by IRS Schedule C category. Drop-down picker on every row, a Monthly Summary that builds itself, a year-end Schedule C view, and a mileage log with the deduction calculated for you.
Small Business Tax Deduction Cheat Sheet
Every Schedule C line that matters to a maker — what belongs, what doesn't, and the mistakes that cost money.
From the blog
Articles that dig deeper into the topics this tool covers.
What Is Cost of Goods Sold? A Plain-English COGS Primer for Maker Businesses
COGS is the single number that quietly decides whether your maker business is profitable, what your taxes look like, and which products are worth keeping in the catalog. Here is what it actually means, what goes in (and what stays out), and how to start tracking it this week — without an accounting degree.
Why Are My Margins Shrinking? A Six-Symptom Diagnostic for Maker Businesses
Revenue is up, orders are up, and somehow the bank account is not. Here is a six-symptom diagnostic for the most common margin leaks in a maker business — supplier drift, packaging creep, shipping spillover, custom-order time bleed, marketplace fee inflation, and discount habituation — with the specific report that will tell you which leak is yours.
42 Questions Etsy Sellers Ask About Fees, Inventory, and Bookkeeping
Direct answers to the 42 questions Etsy sellers Google most — fee math, inventory tracking, monthly reconciliation, sales tax, 1099-K thresholds, and bookkeeping setup. Most-asked first; edge cases at the bottom.
Stocktake Guide: A Step-by-Step Walkthrough for Counting What You Actually Have
Most small sellers "know" their inventory — until they count it and discover they are off by 15-30%. A practical, no-excuses guide to running your first real physical inventory count, fixing what you find, and building a cycle counting habit that keeps your numbers honest year-round.