The month-end inventory handoff: what your bookkeeper needs from Shopify

Short answer: your bookkeeper needs four things from Shopify every month — an inventory snapshot at a fixed date, the month's purchases total, the adjustments log with reasons, and a five-line note on what changed. Thirty focused minutes on the first business day of the month covers all four, and the payoff is that your books stop arguing with your shelf. Skip it, and every quarter-end becomes an archaeology dig through three months of half-remembered adjustments.

This is the recurring handoff — the monthly ritual. It deliberately skips why purchased inventory isn't yet an expense; if you've ever wondered why $11,000 of received POs didn't show up in your P&L, that's the timing gap between your bank and your books, and inventory purchases vs COGS explains the mechanics properly. Here we make sure the numbers crossing that boundary are clean.

The 30-minute runbook

Same slot every month — first business day, 9:00, calendar-blocked. The timeboxing matters because the run dies when "export a few things" becomes an afternoon.

Minutes 0–5: freeze and date-stamp. No inventory edits, no receiving, no count adjustments while the run is happening — a moving target poisons the snapshot. Write the snapshot date on everything you're about to produce; every number your bookkeeper sees should reference one date.

Minutes 5–12: export the inventory snapshot. Pull the Shopify inventory CSV — SKU, location, available on hand — joined with your cost column, and save it with the date in the filename (2026-10-31-inventory-snapshot.csv). This is your ending inventory at cost. If you track stock in more than one location, export all of them and reconcile the total to one date before moving on.

Minutes 12–18: total the month's purchases. Sum what actually arrived during the month: received purchase orders from your native PO records — Shopify's POs capture order date, expected arrival, and receiving (Shopify Help Center, accessed November 2026) — plus non-PO buys that belong in inventory (that packaging stock ordered off the credit card counts too). One number, with the PO-by-PO breakdown attached.

Minutes 18–24: export the adjustments log. Shopify keeps an audit trail of every inventory adjustment with the reason attached (Shopify Help Center, accessed November 2026); export the month's entries. Flag anything over your threshold — a single adjustment above 25 units or $200 at cost is a reasonable illustrative line — and write a one-sentence explanation next to each flag now, while the reason is still findable in your memory.

Minutes 24–30: write the handoff note. Five lines, template below, sent with the exports.

The handoff note (with a worked tie-out)

Here's the note filled in for a coffee-bean retailer, 40-odd SKUs, illustrative figures:

Month: October 2026 (snapshot taken Nov 2 for period ending Oct 31)
Ending inventory at cost: $19,700 — per attached CSV, all locations
Purchases received in month: $11,300
  - PO-204 (beans, received Oct 9): $6,200
  - PO-205 (filters + brew gear, received Oct 21): $3,900
  - Non-PO card buys (packaging, labels): $1,200
Adjustments: 3 entries, all damage/roast-loss; largest 8 units at $54 cost
Changes worth knowing: new bean supplier added mid-month; no location or price changes
Questions: none

And the arithmetic your bookkeeper will run with it — the tie-out that makes the month auditable:

Beginning inventory at cost $18,400 + purchases received $11,300 − ending inventory $19,700 = $10,000 implied cost of goods sold (all figures illustrative).

The $54 of damage adjustments is already inside that movement, which is exactly why the adjustments export matters: it explains why the shelf number moved without a sale behind it. When those three inputs — beginning, purchases, ending — all carry the same snapshot discipline, the implied COGS lands close to what your sales data says it should be, and the books close without a forensic month.

The three reconciliations hiding in the run

The 30 minutes produce four artifacts, but what your bookkeeper is actually doing with them is three checks:

1. Counted vs. book. Did a count happen this month, and do the snapshot's on-hand numbers agree with the last physical truth? If you run a counting cadence, this check is nearly free; if you don't, it's the one worth adding — the counted-vs-book comparison is what makes the snapshot a fact instead of a claim.
2. Adjustments vs. reasons. Every variance entry should carry a human-readable cause — damage, roast loss, theft suspicion, receiving correction. An adjustments log full of unexplained negatives is the single fastest way to lose an auditor's (or a lender's) trust. The audit-trail discipline is laid out in Shopify inventory adjustments.
3. Purchases vs. bills. The POs you marked received should match supplier bills arriving in the accounting system — the same three-way-match logic procurement teams use on invoices, applied in miniature. Mismatches here (received in October, billed in November) are normal; unexplained ones are not.

If your books run through QuickBooks or Xero, the connection layer has its own sync quirks and failure modes — what Shopify syncs with QuickBooks and what breaks covers that plumbing, and the handoff note is precisely what lets a bookkeeper diagnose a sync gap in minutes instead of hours.

When it's not 30 minutes

Budget an hour instead in any of these months: the first month after adding a location, the first month after an app migration, the month of a big count correction, or the first month with a new supplier whose receiving patterns you don't know yet. None of these are problems — they're just months where the adjustments log will be longer and the note's "changes worth knowing" section is doing real work.

The annual deep version — the full stocktake with valuation sign-off — is a different event entirely, covered in the year-end inventory count. The monthly handoff is what makes that annual event boring instead of terrifying, and a weekly layer helps too: most months go short because the weekly checklist already caught the stragglers mid-month.

Common questions

What does a bookkeeper need from Shopify every month? Four artifacts: a dated inventory snapshot at cost, the month's total purchases received with a PO breakdown, the adjustments log with reasons, and a short note of any structural changes — new suppliers, locations, or cost updates. Thirty minutes on the first business day produces all four, and the note takes five of those minutes.

Is inventory an expense when I buy it or when it sells? When it sells. Cash leaves at purchase, but the cost only hits the P&L as cost of goods sold once the units sell — which is why your bank balance and your profit disagree every month you're stocking up. The inventory purchases vs COGS piece owns the formula; the handoff above gives your bookkeeper clean inputs for it.

How do I export inventory from Shopify for my accountant? Export the inventory CSV — SKU, location, and available on hand — and join it with your cost column before sending, then name the file with the snapshot date. Multi-location stores should export every location and confirm the totals reconcile to a single date. The export itself takes minutes; the dated filename is what saves the back-and-forth later.

Which inventory adjustments should I report to my bookkeeper? All of them, via the adjustments export — but flag the ones over your threshold with a written reason. Small recurring damage and shrink entries just need the log; large single adjustments, anything that looks like theft, and any bulk correction deserve a one-sentence explanation while the context is still fresh.

How long should a month-end inventory close take? Thirty minutes once the routine is established, on the first business day of the month. The first run takes longer, as does any month following a location change, migration, or major count correction. If it's regularly exceeding an hour, the fix is usually upstream — a weekly counting or receiving habit, not a faster month-end.

Next step

Put the recurring slot on your calendar right now — first business day of each of the next three months — and run the runbook twice before judging it; the first run builds the export muscle, the second is where the 30 minutes becomes real. And if the tie-out arithmetic above raised more questions than it answered, read why your bank and your P&L disagree on inventory — the handoff makes sense fastest once the timing gap underneath it does.