Wauvel
Finance 101

The month-end close for a D2C brand: a checklist that fits inventory

← All posts
By Blake EkelundJuly 21, 2026 · 10 min read

Closing the month is the ritual that turns a pile of transactions into numbers you can actually trust — the point where "money moved around" becomes "here's what we made, what we own, and what we owe." Skip it, or do it loosely, and every decision after is built on sand: you scale ad spend against a margin that isn't real, or discover in month three that inventory's been wrong since January.

The trouble is that almost every "month-end close checklist" you can find was written for a services business — one with no inventory, no payment processors skimming every sale, and no revenue tied to a physical box leaving a warehouse. For a D2C brand, those three things are exactly where the numbers go wrong. So here's the close built for the way you actually operate.

Why a D2C close is its own animal

Three things a services business never has to think about, and all three are landmines at month-end:

  • Inventory that becomes COGS. Your biggest asset is a pile of stuff that turns into an expense only when it sells. Get the timing or the cost wrong and both your balance sheet and your margin are off — usually flatteringly.
  • Processors and marketplaces. Shopify, Stripe, Amazon, and PayPal don't hand you your sales — they hand you a deposit, net of fees, refunds, and reserves, often days late. Booking that deposit as revenue quietly buries both real sales and real costs.
  • Physical cut-off. Revenue follows the box, not the order. An order placed on the 31st and shipped on the 2nd belongs to next month — and pre-orders and gift cards aren't revenue at all until you deliver.

Everything below is ordered the way you'd actually work it: get the raw material in, reconcile the cash, settle inventory, recognize revenue, then review and report. Check items off as you go — it remembers where you stopped, so you can close over two sittings or come back next month and hit reset.

Work through your close
0 / 15

1 · Get the raw material in

0/2

2 · Reconcile the cash

0/3

3 · Settle inventory & COGS

0/4

4 · Recognize revenue correctly

0/3

5 · Accrue, review & report

0/3

The step everyone gets wrong: inventory to COGS

Here's the one that sinks more D2C books than any other. Inventory is an asset — it sits on the balance sheet at cost — right up until the moment a unit sells, when exactly that unit's cost moves to cost of goods sold. If your books instead expense inventory when you pay the supplier (an easy cash-basis habit), COGS lurches around with your purchase orders, margin swings for no real reason, and no month tells the truth. Two rules keep it honest: landed cost — inbound freight and duty — gets capitalized into the unit, not dumped in a freight expense; and COGS is recognized against what sold, not what shipped in.

Then, once a month, you check the book against reality — because units walk off, break, and get miscounted, and none of that tells your accounting software what happened.

Inventory reconciliation · July
Inventory true-upAt cost
Book value — what QuickBooks says$84,200
Counted on-hand — what's on the shelf$81,050
= Variance to write off to COGS-$3,150
Book says $84,200; a count says $81,050. That $3,150 gap — shrink, damage, miscounts — is real cost that has to hit COGS this month. Leave it, and next month's margin inherits a lie while your balance sheet carries inventory you don't have.

This is also the single biggest reason to keep the books clean all month, not just at close — the reconciliation is only as trustworthy as the data under it. It's the same discipline behind keeping your QuickBooks clean, applied on a deadline.

The deposit is not the sale

The second D2C landmine hides in your bank feed. When Shopify Payments or Stripe pays you, the number that lands is net — gross sales minus refunds, minus the processor's cut, minus any rolling reserve. Book that one figure as revenue and you've erased both sales and fees in a single stroke, then spend the rest of the quarter wondering why margin looks strange. The fix is to reconcile the whole bridge, every payout:

One Shopify payout
Payout bridgeAmount
Gross sales in the batch$12,400
− Refunds-$540
− Processing fees (2.9% + 30¢)-$372
− Rolling reserve held back-$300
= Deposit that hits the bank$11,188
Only the last line ever shows up in your bank feed. The job at close is to reconstruct the four lines above it, so gross sales, refunds, and fees each land where they belong — and your revenue and margin are built on the $12,400, not the $11,188.

Free · no account · no card

Get your 2027 budget built from your QuickBooks — P&L, balance sheet and cash flow, in Excel.

Build my 2027 budget →

Cut-off and the pre-order trap

Revenue recognition is where a good month can borrow from a bad one without anyone noticing. The rule for a physical-goods brand is simple: recognize revenue when the order ships, not when it's placed and not when the cash clears. Orders sitting in the pack queue on the last day are a liability, not a sale. And anything you've been paid for but haven't delivered — pre-orders, gift cards, a subscription's future boxes — is deferred revenue, cash you're holding on someone else's behalf until you ship. (Each industry has its own version of this line; it's worth reading when a sale becomes revenue for yours.)

The four numbers a close should hand you

A close isn't bookkeeping for its own sake — it exists to produce numbers you steer by. When you finish, these should fall out clean:

Gross margin

58%

sales minus real, landed COGS

Contribution / order

$22

after fulfillment & CAC — the atom

Inventory days

74days

cash sitting on the shelf

Gross margin tells you the product works; contribution margin — the real unit economics of an order after fulfillment and acquisition — tells you the business works; and inventory days tells you how long your cash is trapped on a shelf before it sells, the front half of your cash conversion cycle. Together they're the difference between knowing you had a good month and just hoping you did — and they're how a brand avoids being profitable but broke.

A close is a discipline, not a hero effort — the goal is to make it boring and repeatable, the same steps every month. That's where Wauvel earns its keep: it reads your QuickBooks and flags the exact things this checklist hunts for — negative inventory, uncategorized transactions, a balance that won't tie — with Watch-outs, then turns the closed books into a plain-English monthly report. Bookmark this page and reuse the checklist every month — it'll remember the boxes you've ticked until you reset it.

Need your financials for a lender, a buyer or your accountant? Get the free financials pack →

See what an AI CFO says about your own numbers.

$99/mo, everything included. Free for 14 days, no card.

Meet your AI CFO →

Keep reading

Finance 101October 23, 2026 · 7 min read

Overhead allocation: charging costs to the jobs that caused them

If overhead is a lump nobody owns, every job looks more profitable than it is and the least efficient work looks the best. Here's how to push shared costs down to jobs without building a costing department.

Read it →
Finance 101October 21, 2026 · 7 min read

Deposits, retainers and progress billing: getting paid before you deliver

The cheapest working capital available to most businesses is their own customers, and the mechanism is billing structure rather than collections. Here's how deposits and progress billing change your cash curve - and how to book them correctly.

Read it →
Finance 101October 17, 2026 · 7 min read

Financing options, ranked by what they actually cost

The advertised rate on small business funding is often nothing like the real annualised cost. Here's how to convert every offer to one comparable number, and roughly where each option lands once you do.

Read it →
Finance 101October 15, 2026 · 6 min read

Your P&L by month tells a story the annual one hides

An annual income statement is twelve months averaged into a single column, which is exactly the wrong shape for spotting anything. Laid out month by month, the same data shows you drift, seasonality, and the exact month a problem started.

Read it →
Finance 101October 13, 2026 · 6 min read

Bad debt: when to write off a customer

Carrying an invoice you'll never collect doesn't preserve the money - it just overstates your assets and flatters the month you booked it. Here's how to decide when a receivable is dead, what writing it off actually does, and how to stop creating more.

Read it →
Finance 101October 11, 2026 · 7 min read

Year-end tax planning: the decisions that expire December 31

Tax planning is not tax filing. Filing reports what happened; planning changes it, and only until December 31. Here are the levers still available to a small business in Q4 and the arithmetic for deciding whether to pull them.

Read it →
Finance 101October 9, 2026 · 7 min read

What "profit" means on four different reports

Your P&L, your tax return, your bank balance and your valuation will all give you a different profit number for the same year. None of them is lying. Here's what each is measuring and which one to use for which decision.

Read it →
Finance 101October 7, 2026 · 7 min read

Fixed vs. variable: why your cost structure decides your risk

Two businesses with identical revenue and identical profit can be completely different risks, depending on how much of the cost base is fixed. Here's how operating leverage magnifies both directions, and how to choose the structure that fits your volatility.

Read it →
Finance 101October 3, 2026 · 7 min read

Contribution margin: the number that decides what to sell more of

Gross margin tells you about a product. Contribution margin tells you what one more sale is worth - and once overhead is in the mix, the two rankings disagree often enough to change what you push.

Read it →