Implementation Engagement · The Close Pack

The six pages the founder reads at 7am on day one

This is the deliverable itself: a sample month-end close pack, assembled overnight from six sources through 14 signed metric definitions, reviewed and published the same morning. The old version of this document took three days to build.

Assembled automatically overnight. Reviewed, annotated, and published in four hours.

The nightly pipeline drafts every page below from the warehouse views before anyone wakes up. The humans do the judgment work: the fractional CFO clears the reconciliation flags, the founder and CFO walk the numbers and call three decisions, and the pack ships with commentary before lunch on day one.

7:00am
Pack drafts itself from the nightly run.
7:10 to 9:10
CFO reviews reconciliation flags, annotates.
9:10 to 10:10
Founder and CFO walkthrough, decisions called.
10:10 to 11:10
Published with commentary. Close done.
Month-End Close Pack · June (illustrative month) Drafted 7:00am, day one · Published 11:05am Illustrative Page 1 of 6

One-page summary

Net sales $1,238,000 against a plan of $1,265,000, a miss of 2.1 percent, driven mostly by wholesale. Contribution after fulfillment held at 43.0 percent. Three items need cash attention this month.

$1,238,000
Net sales (definition #1), all channels
2.1% below plan of $1,265,000
$532,152
Contribution after fulfillment cost, before marketing and overhead
43.0% of net sales vs 43.8% planned
3
Cash-relevant flags carried into the decisions page
Details on pages 3, 4, and 5

Revenue by channel vs plan

Actual net sales Plan Bars scaled to the largest plan value ($730,000)

Cash-relevant flags

$41,300 of wholesale receivables past 60 days

Two of the twelve wholesale accounts are past 60 days. One remittance is also $12,150 short against invoice with an unverified deduction claim.

Detail: page 5, appendix · Decision 3, page 6

$96,000 at cost sitting in three aging SKUs

Three SKUs have been on hand more than 180 days with little or no velocity. Cash is parked in inventory that is not turning.

Detail: page 3, aging flags · Decision 1, page 6

One parcel lane up 15.5% vs trailing quarter

Carrier B, zones 5 and 6, is now $8.20 per order against a $7.10 trailing average across 1,240 orders this month. Every other lane is within 2 percent of trend.

Detail: page 4, freight · Decision 2, page 6
Month-End Close Pack · June (illustrative month) All figures from signed metric definitions Illustrative Page 2 of 6

Channel table

One number per cell, one definition per column. This is the table that used to exist in three competing versions. Channel margin is net sales minus landed cost, channel fees, and fulfillment cost.

Channel Orders Net sales (#1) Returns Fulfillment cost / order Channel margin
Shopify DTCAOV $85.00 · 8,450 orders x $85.00 = $718,250 8,450 $718,250 $37,3505.2% of net sales $11.20$4.35 pick-pack + $6.85 parcel freight $350,67548.8% · landed cost $272,935 (38.0%)
AmazonAOV $65.00 · 5,150 orders x $65.00 = $334,750 5,150 $334,750 $24,1007.2% of net sales $8.10FBA fulfillment fee $115,61734.5% · landed $127,205 + referral fees $50,213 (15.0%)
Wholesale, 12 accountsAvg PO $2,500 · 74 POs x $2,500 = $185,000 74 POs $185,000 $1,8501.0% of net sales $310.00pallet freight + handling per PO $65,86035.6% · landed cost $96,200 (52.0% at wholesale price)
Total 13,674 $1,238,000 $63,300 $11.65 blended$159,295 total / 13,674 orders $532,15243.0% of net sales
Definition #1, net sales: gross order value minus discounts, refunds, and channel-level sales tax, recognized on ship date. Signed by founder and CFO in the definitions workshop. Same definition feeds the daily dashboard and this pack, so the founder math and the CFO math are now the same math.
Month-End Close Pack · June (illustrative month) Sellable inventory per definition #6 · cover per definition #11 Illustrative Page 3 of 6

Inventory position

$1,617,000 at landed cost across three locations. Cover on the top 20 SKUs is healthy in the middle and wrong at both ends: four SKUs are thin, three are drowning.

Sellable units by location

LocationSellable unitsLanded value
3PL distribution center84,600$1,152,000
Amazon FBA21,300$301,000
Inbound, in transit12,000$164,000
Total117,900$1,617,000

Weeks of cover, top 20 SKUs

9.4 wks
Median cover · target band 8 to 12 weeks
3.1 to 31.0
Range across the top 20
4 SKUs
Under 6 weeks · reorder review queued
Thin
3 SKUs
Over 20 weeks · reorders challenged
Heavy
Definition #11, weeks of cover: sellable units divided by the trailing 8-week average of weekly units sold, per SKU, all channels combined.

Aging flags: $96,000 at cost, 180+ days on hand

SKUDays on handValue at costSituation
HG-058 · bath mat, first generation200+$41,200Superseded by v2 in March; velocity near zero since.
HG-214 · napkin set, holiday colorway220$27,600No sales since February. Seasonal; candidate for bundle or liquidation.
HG-133 · oversized throw, damaged-carton lot185$27,200Held pending disposition decision; see open item 2, page 5.
Total aging exposure$96,000Carried to the summary page as cash flag 2.
Month-End Close Pack · June (illustrative month) Ship time per definition #8 · freight per order per definition #3 Illustrative Page 4 of 6

Fulfillment ops

The 3PL had a good month on speed. The story is in freight: one carrier lane broke away from its trailing average while every other lane held.

1.4 days
Median click-to-ship, 3PL orders
Improved from 1.6 trailing 3-month average
96.2%
Orders shipped within 2 business days
Target 95%
143
Fulfillment exceptions logged
1.7% of 3PL-shipped orders

Exceptions by type

Exception typeCountNote
Address corrections52Caught pre-ship by validation rule.
Carrier exceptions38Weather-related, concentrated week 2.
Inventory shorts3127 tied to the two thin SKUs on page 3.
Damage claims22In line with trailing average.
Total143

Freight per order vs trailing average

LaneThis monthTrailing 3-moChange
DTC parcel, all lanes8,450 orders$6.85$6.41+6.9%
Carrier B, zones 5-61,240 orders$8.20$7.10+15.5%
All other parcel lanes7,210 ordersWithin 2%
Amazon FBA fee per order$8.10$8.05+0.6%
Read: the blended increase is entirely the Carrier B lane. At current volume that lane costs an extra $1,364 per month vs its own trailing rate. Carried to decision 2.
Month-End Close Pack · June (illustrative month) Flags drafted nightly by the reconciliation agent · every resolution human-approved Illustrative Page 5 of 6

Reconciliation appendix

Four flags this month, all raised by the nightly agent with a drafted discrepancy note, all resolved by the CFO in the daily 10-minute review. Nothing auto-corrects. Two items remain open with named owners.

Flags raised and resolved

FlagMismatchResolutionStatus
Shipments: 3PL WMS vs carrier manifests WMS export 8,524 vs manifests 8,502; gap of 22. 22 multi-carton orders counted per carton in the WMS export. Definition #7 counts orders shipped, not cartons. No adjustment. Resolved
Amazon settlement vs expected proceeds Deposits $318,400 vs expected net proceeds $319,940; gap $1,540. $1,180 rolling reserve carried to next settlement plus $360 in late-posted chargeback fees. Reconciles to the penny. Resolved
3PL on-hand vs warehouse ledger 212 units off across 4 SKUs. Cycle count found 187 units mis-slotted (corrected) and 25 damaged awaiting disposition. Adjustment posted. Resolved
Returns log vs 3PL returns received CS log 512 vs 3PL received 487; gap of 25. 25 returns in transit at month-end cutoff. Definition #9 counts returns on receipt; carryover noted for next month. Resolved

Open items

ItemOwnerDueStatus
Wholesale remittance $12,150 short vs invoice; deduction claim for a damaged pallet not yet verified with the 3PL. Fractional CFO Day 10 Open
Disposition of 25 damaged units from the cycle count (HG-133 lot): claim, liquidate, or write off. Ops lead Day 15 Open
Why this page exists: these four mismatches are the arguments that used to consume Day 2 of the old close. Now each one arrives pre-investigated with a drafted note, and the humans spend minutes confirming instead of hours hunting.
Month-End Close Pack · June (illustrative month) Called in the 9:10am walkthrough · each backed by one number Illustrative Page 6 of 6

Decisions

Three decisions, called on day one of the month, on numbers that are one day old instead of three weeks old. Each cites the page that backs it.

Decision 1 · Inventory

Pause the HG-107 reorder for 8 weeks

31.0 weeks of cover
vs a 12-week target band ceiling · page 3

HG-107 sits at the top of the cover range with a 6,000-unit PO worth $52,800 scheduled. Pushing it 8 weeks holds that cash and lets velocity catch up before committing.

Owner: ops lead · revisit at next close
Decision 2 · Freight

Rebid the Carrier B zones 5-6 lane

$8.20 vs $7.10
per order, this month vs trailing, +15.5% · page 4

Carrier C has quoted $7.30 on the same lane. At 1,240 orders per month, switching saves about $1,116 per month, roughly $13,400 per year, if service holds in a 30-day trial.

Owner: ops lead with 3PL account manager
Decision 3 · Cash

Move two wholesale accounts to 50% deposit

$41,300 past 60 days
$29,150 + $12,150 across 2 of 12 accounts · page 5

Both accounts keep ordering while aging out. New POs require a 50 percent deposit until balances are current. The $12,150 short-pay dispute stays with the CFO as open item 1.

Owner: fractional CFO · founder approved

Nightly pipeline

Six sources pulled every night into a PostgreSQL warehouse: Shopify, Amazon settlements, 3PL WMS, freight invoices, processor payouts, returns log.

+

14 signed definitions

Argued once in a two-hour workshop, signed by founder and CFO, encoded as SQL views. Every number on every page comes from the same views.

+

Reconciliation flags

An agent compares sources nightly and drafts a note per mismatch. The CFO reviews in about 10 minutes a day. Nothing auto-corrects, ever.

=

This pack, 7am, day one

Drafted before anyone wakes up. Four hours of human judgment later, it is published. The old version took 3 days and 38 manual steps. This one took 0 manual steps and a 12-point review checklist.

The close moved from 3 days to 4 hours because the argument about what the numbers mean happened once, in writing, and the plumbing enforces it every night.