Retail monthly close template (free): the 90-minute ritual that catches every leak.

A retail monthly close template is not paperwork. It is the difference between an owner who knows what their shop did in May and an owner who feels like May was probably fine. Most independent boutiques skip the close entirely — they look at the till total on the last day, glance at the bank balance on the first, and move on. By month nine they cannot tell which category is bleeding, which subscription auto-renewed three months ago, or whether real EBIT is actually positive once rent and supplier invoices land. This template fixes that with seven sections that take 90 minutes if you have been logging daily, on the first Saturday of every new month. It is printable, it is free, and it works in a notebook, a spreadsheet, or in nouz. The structure is the asset; the format is just where you write.

TL;DR

Why monthly close is the difference between knowing and guessing

Walk into ten small boutiques on the third of any month and ask the owner whether the previous month was profitable. Eight will give you a feeling. One will quote revenue from memory. One — at most — will give you a real EBIT number. The gap between the feeling and the real number is where small retail shops quietly die. Revenue can be flat and EBIT can collapse; revenue can dip 4% and EBIT can grow because the dead-stock markdowns from last month stopped dragging on margin. Without a monthly close you only see revenue, and revenue is the least informative line on a retail P&L.

Four things only show up at a real monthly close. Real EBIT, not gross. Margin drift per category. Dead stock you have stopped noticing. Fixed cost creep. None of them are visible in daily till glances, weekly bank checks, or even the accountant report that arrives a quarter after the period it covers. Owners running on intuition catch the leaks at year-end. Owners running a monthly close catch them in week one of the following month, while there is still something to do about them.

The template below is the operational version — built to fit on one printable page, filled in on the first Saturday of every new month, and designed so the answer at the bottom is a three-line action list, not a fifteen-page report. The point is not to produce a beautiful document. The point is to produce three things you will actually do differently next month, based on what last month said rather than what last month felt like. For the deeper "why" on monthly close, see the retail end-of-month checklist — this post is the printable template the checklist refers to.

When to do it — first 3 days of the new month

Pick one fixed slot inside the first three days of the new month. The first Saturday morning before opening is the most common choice. The first Sunday afternoon if your shop is closed Sundays. Whatever you choose, defend it — a monthly close scheduled as "when I get a quiet hour" never happens. A monthly close scheduled as "first Saturday, 8 a.m., kitchen table" gets done eleven months out of twelve.

Three reasons to do it in the first three days rather than the last three:

• The previous month is still in your head. You remember which week was strange, which Saturday had the burst trade, which Wednesday the supplier called. A close on the 12th of the month is reconstruction; a close on the 2nd is review.
• Supplier invoices have arrived. Most suppliers send invoices within 1-3 business days of month-end. A close on the 4th has every invoice in hand. A close on the 30th is missing the last batch.
• Card settlements have cleared. The last 2-3 days of card sales settle in the following month. By the 4th, most of those settlements are visible in the bank and the reconciliation in section 1 actually works.

Do not do month-end on the actual last day of the month. By then you are tired from a full trading month, you do not yet have the late supplier invoices, and the close becomes a chore you postpone. The first morning of the new month is the highest-energy slot for a 90-minute thinking exercise — and the highest-energy slot is the one most likely to produce a real action list rather than a tired one.

What this template gives you — 7 deliverables

When you finish a close with this template, you have produced seven specific deliverables. Not a vague sense of how the month went — seven written outputs that go in a folder and stay there as the year unfolds. The list:

Seven outputs, one page each. Across a year that is 84 pages of operational history — enough that by next March you can answer questions you cannot answer today: which months are structurally weakest, which categories are seasonally fragile, which supplier increased prices three times in one year. None of that exists without the monthly cadence. All of it falls out naturally once you have run the template ten times.

The 7-section monthly close template (printable)

Each section below is one block of the printable template. Print all seven, staple them, and the first Saturday of each month becomes mechanical — you sit down with the stack, work through each block in order, and the close is done when the stack is full. The exact prompts in each section are the prompts you would fill in.

1. Revenue reconciliation

Goal: three numbers that should match within a known tolerance — POS total, P&L total, bank deposits. The point is not to force them to match, it is to know exactly why they do not.

The expected gaps:

The prompts on the printable template for section 1:

• POS total for the month (cash + card, split): €______ cash, €______ card, €______ total.
• P&L revenue total for the month (sum of daily entries): €______ cash, €______ card, €______ total.
• Bank deposits for the month (cash deposits + card settlements net of fees): €______.
• Card volume in transit (last 2-3 days, settling in the new month): €______.
• Gap explained? Yes / No. If no, action: investigate this week.

For the upstream daily discipline that makes this section fast, see the daily sales report for retail. If you log the POS total exactly every evening, this whole section takes 5 minutes; if you reconstruct from receipts, it takes 45.

2. COGS verification

Goal: match the COGS your P&L recorded against the COGS your actual stock movement implies. The standard formula:

The prompts on the printable template for section 2:

• Opening stock at cost (from last month-end): €______.
• Purchases during the month at cost (sum of supplier invoices received): €______.
• Closing stock at cost (this month's count or estimate): €______.
• Implied COGS = opening + purchases − closing: €______.
• COGS recorded on P&L (or in nouz): €______.
• Gap: €______ (acceptable: within 2-3% of recorded).

Gaps larger than 3% point to one of three causes — receiving errors (stock arrived but never logged), damage or shrinkage uncounted (stock left without a sale and never written off), or cost-price drift (supplier raised prices and the P&L is still costing units at the old price). Note which on the template and assign the investigation to the action list at the bottom.

nouz holds COGS as a value snapshot at the moment of each sale — editing a product's cost-price later does not retroactively change historical entries. That is by design. It means each month's historical COGS reflects what you actually paid at the time, not what you pay today. More on the COGS snapshot rule.

3. Inventory check

Goal: a 15-minute floor walk that flags dead stock before it becomes the silent cash trap that breaks the year. Section 2 reconciles numbers; section 3 walks the floor. They are not the same exercise.

The template prompts you to do three spot-counts and one flag pass:

1. 01
   1. Spot-count: high-value SKUs.

   Walk to every item priced over €80 at retail — designer pieces, jewellery, leather goods, premium electronics. Count every unit. Write down any gap against the stock list. High-value items are where one missing unit is meaningful, and they are the most common shoplifting targets. About 4-5 minutes.

2. 02
   2. Spot-count: top-3 weekly sellers.

   Look up your top three SKUs by units sold last week. Count what is on the floor right now. If any of the three are out of stock or down to one unit, that is a stockout that is costing you sales every day until the reorder lands. Note as urgent. About 3 minutes.

3. 03
   3. Spot-count: one back-room box.

   Open one box in the back room — preferably one that has not been opened recently. The back room is where dead stock hides and grows. Whatever is inside, note the receiving date and the cost value. If it is older than 90 days, it joins the aged-stock list. About 4 minutes.

4. 04
   4. Floor walk: dead stock flag pass.

   Walk every rack, shelf, and display. Flag anything with a receiving date 90+ days ago. Flag twice anything 120+ days. The aged-stock list is the output. About 4-5 minutes for a typical small boutique.

For the markdown cascade that converts the aged-stock list into recovered cash (the 60/90/120 rule), see retail dead stock: how to spot it before it kills your margin. For the deeper diagnostic on turnover that section 6 builds on, see boutique inventory turnover mastery. Use the inventory turnover calculator at month-end to convert the stock value from section 2 and the COGS from section 5 into a turnover ratio.

4. Fixed cost confirmation

Goal: a tick-list of every recurring monthly line, confirmed paid (or cancelled with the end date set). The fixed cost section is where forgotten subscriptions and quiet price increases come to die.

A typical small-retail fixed cost list, with the ones owners forget marked:

For every line, the template asks three questions:

1. Paid? Yes / No. If no, why not — is the bank running tight or did the invoice not arrive?
2. Same amount as last month? Yes / No. Note any change. Rent escalators, software price increases, and insurance renewals all creep without warning.
3. Still using it? Yes / No. If no, cancel today and set the end_date in nouz so it stops allocating to your daily fixed cost slice.

nouz allocates monthly fixed costs to days at the rate of monthly amount ÷ 30.4375 (the average days per month across a year), so a €4,200 rent line shows as €138.01 per day in your EBIT. Confirming the list at month-end is what keeps that daily slice honest. Most first closes find 1-2 active subscriptions the owner forgot existed — usually €20-€40/month each, €240-€960/year of pure recovery for 15 minutes of work.

5. Margin trend

Goal: four numbers that tell you whether margin is drifting, holding, or recovering — and a single line written underneath summarising the story.

The four numbers on the template:

The story you are looking for, in order of frequency:

• Gross margin steady, EBIT margin dropping. Fixed costs have crept. Go back to section 4 with sharper eyes.
• Gross margin dropping, EBIT margin steady. Mix shift toward lower-margin SKUs or supplier price creep. Goes on the action list as a repricing exercise.
• Both margins dropping. Compounding leak — almost always dead stock dragging on the average plus an unflagged subscription. Section 7 gets two of its three actions from here.
• Margin recovering vs trailing 3-month. Confirm it is not a one-off (a big high-margin sale, a refund processed wrong). If real, write down which action from last month's close caused it.

A drop of 4+ percentage points in EBIT margin versus the trailing three-month average is the trigger for a deeper diagnostic — see the six-step margin diagnostic for retail. A drop under 2 points is normal noise. A drop of 2-4 points is "watch closely next month and flag the most likely cause now."

6. Top 5 sellers + Bottom 5 sellers + GMROI line

Goal: eleven SKUs ranked plus one ratio for the whole shop. The point is to confront which SKUs are paying the rent and which are taking shelf space without earning it.

The template asks for three lists:

1. Top 5 by units sold this month. Your bestsellers in volume. These deserve the best display real estate next month — if any of them are not in your top window or top shelf, that is an action.
2. Top 5 by gross margin contribution this month. Often different from top 5 by units. A SKU selling 30 units at 35% margin contributes less than a SKU selling 12 units at 70%. Both lists matter; the overlap is your protected core.
3. Bottom 5 by sell-through this month. SKUs that took shelf space and did not move. Cross-check against the aged-stock list from section 3 — most of the bottom 5 should already be flagged.

Then one ratio — the shop-wide GMROI line:

The bottom-5 list is where buying decisions get made for the next season. Once a SKU appears on the bottom-5 list for two months running, it should not be reordered — the data has voted. Use the retail sell-through rate calculator to confirm before you walk it through with your buying notebook.

7. Action list for next month

Goal: exactly three actions. Not five, not ten, not "a plan". Three specific moves with a date and a name next to each, written in the visible notebook on your desk — not in a folder.

The constraint is deliberate. A 14-item action list never gets done. A 3-item list gets done in the first week of the new month and then you have time to do the next 3-item list at the next close. Across a year that is 36 actions — far more than any one-time strategic review produces.

Examples of the kind of action that belongs here:

• Cancel the design software subscription that has not been opened since November. Owner. By Tuesday.
• Apply 30% markdown to every SKU on the aged-stock list flagged 90+ days. Staff briefing Saturday morning. Live by Sunday.
• Renegotiate the card processor rate. Pull two competing quotes this week, call incumbent Thursday.
• Move the top-3-by-units SKUs from the back wall to the window display by Monday opening.
• Re-cost the homewares category — supplier raised prices on six SKUs in March, sell-prices still set to the old cost. Update by Wednesday.

How to fill it in — 90 minutes

A 90-minute close is realistic if you have been logging daily through the month. The work shifts from reconstruction to review. If you are starting from a shoebox of receipts, budget three to four hours for the first close and commit to daily logging from day one of the new month — the next close will fit in 90 minutes.

The 90-minute breakdown, in order:

1. 01
   1. Revenue reconciliation — 10 min.

   Sum daily POS totals (cash + card, split). Sum daily P&L revenue entries (same split). Pull cash deposits and card settlements from the bank statement. Compare three totals against the expected-gap table from section 1. Write the one-line reconciliation note.

2. 02
   2. COGS verification — 12 min.

   Opening stock + purchases − closing stock = implied COGS. Compare to recorded COGS. If the gap is over 3%, note the most likely cause (receiving error, uncounted damage, cost-price drift) on the template. Do not investigate now — that goes on the action list.

3. 03
   3. Inventory check — 18 min.

   Three spot-counts (high-value, top-3 weekly sellers, one back-room box) plus the dead-stock flag pass. The walk is the only part of this template that physically requires you in the shop. About 15-18 minutes for a typical 50-80 m² boutique.

4. 04
   4. Fixed cost confirmation — 12 min.

   Open the bank statement, walk down the list of recurring lines, tick each one as paid / same amount / still in use. Set end_dates on anything cancelled this month. Flag any escalators.

5. 05
   5. Margin trend — 8 min.

   Write the four numbers (this month gross margin, trailing 3-month, same month prior year, this month EBIT margin). Write the one-line story underneath. nouz pre-builds these — in a spreadsheet, allow an extra 5 minutes.

6. 06
   6. Top 5 / Bottom 5 / GMROI — 15 min.

   Pull the SKU-level sales report for the month. Rank by units and by margin contribution. Write the two top-5 lists. Pull the bottom 5 by sell-through. Compute the GMROI ratio and write it down.

7. 07
   7. Action list — 15 min.

   Sit with the previous six sections in front of you. Pick the three biggest leaks or opportunities. Write three actions with a date and an owner. Stop at three. Place the notebook open on your desk where you will see it during the week.

Total: about 90 minutes, with 10 minutes of slack for whichever section ran long. The first close in your life almost always takes 2-3 hours because the lists do not exist yet (no fixed cost master list, no category structure, no prior-month margin to compare against). By the third close, most owners are landing inside the 90-minute target.

Worked example — Vienna boutique, March 2026 close

To make the template concrete, here is what one filled-in close looks like. Call the owner Mira. She runs a 55 m² womenswear and accessories boutique in Vienna's 7th district. Four years open, about 380 active SKUs across 14 brands, monthly gross revenue around €34,000. She does the close on the first Saturday morning of each new month, at her kitchen table, in 85-95 minutes.

Her March 2026 close, section by section.

Section 1 — Revenue reconciliation.

Note written: "March 2026 revenue reconciled — POS €34,180, P&L €34,196 (€16 rounding gap), bank €33,142 net + €590 in transit. Gap explained."

Section 2 — COGS verification.

• Opening stock at cost (1 March): €48,200.
• Purchases at cost (March supplier invoices): €11,840.
• Closing stock at cost (31 March estimate): €44,720.
• Implied COGS: 48,200 + 11,840 − 44,720 = €15,320.
• COGS recorded in nouz: €14,910.
• Gap: €410 (2.7% — just inside acceptable).

Most likely cause: two supplier invoices arrived with small freight surcharges that were not added to the unit cost-prices in nouz. Goes on the action list as a 10-minute fix.

Section 3 — Inventory check.

• High-value spot-count (12 SKUs > €80): all present and matching.
• Top-3 weekly sellers spot-count: one SKU (a wool scarf) down to one unit, reorder triggered.
• Back-room box opened: a box of summer dresses received in September, never put on the floor. €640 at cost. Joins the dead-stock list immediately.
• Dead-stock flag pass: 14 SKUs older than 90 days (€2,180 at cost). 4 SKUs older than 120 days (€890 at cost).

Total aged stock: €3,070 at cost — about 6.9% of inventory. Inside the healthy 8% line, but the back-room box was a real find that would have stayed invisible without the walk.

Section 4 — Fixed cost confirmation.

• Rent (€2,800), utilities (€340), internet (€45), mobile (€38): all paid, same amounts.
• Payroll (€2,400 one part-time + own draw €1,400): paid, same.
• Software stack: POS (€59), accounting (€45), e-commerce (€29), email (€12), photo editing (€19) — found! Not used since December. Cancelled today, end_date set.
• Insurance: nothing this month (annual renewal in July).
• Bank/card fixed fees: terminal rental (€18), account fee (€12): same.
• Cleaning (€140), waste (€55): paid, same.

Recovery from this section alone: €19/month from cancelled photo editing software = €228/year. Pure margin recovery for the 15 minutes spent walking the list.

Section 5 — Margin trend.

One-line story: "Gross margin down 1.4 pts vs trailing 3-month and 3.5 pts vs March prior year — homewares mini-category dropped from 44% to 38% margin (supplier raised cost-prices in February, sell-prices not updated). EBIT margin down 1.6 pts — partly the gross margin slip, partly the photo editing subscription that ran 4 months unused. Both go on the action list."

Section 6 — Top 5 / Bottom 5 / GMROI.

• Top 5 by units sold: wool scarf (28), midi skirt (19), basic tee (17), leather belt (15), denim jacket (12). All apparel and accessories — none currently in the front window.
• Top 5 by margin contribution: denim jacket (€480), midi skirt (€420), leather belt (€380), wool scarf (€330), silk blouse (€310). Overlap of 4 SKUs with the units list — strong protected core.
• Bottom 5 by sell-through: two homewares vases (0 sold in 60 days), a printed scarf (1 unit in 90 days), two beaded bags (0 sold in 75 days). All four already on the aged-stock list.
• GMROI annualised: €13,587 monthly gross margin × 12 ÷ €46,500 average inventory at cost = 3.5. Inside the healthy 2.5-3.5 band for fashion.

Section 7 — Action list, three moves for April.

1. Re-cost the homewares mini-category and update sell-prices on the 6 SKUs where supplier costs rose in February. Owner. By Wednesday 8 April.
2. Move the top-5-by-units SKUs to the front window and entrance display by Saturday 4 April opening. Staff briefing Friday evening.
3. Run a 30% markdown on the 14 aged-stock SKUs flagged 90+ days for one week, then escalate to 50% on the 4 flagged 120+. Live by Sunday 5 April.

Total time for the close: 92 minutes. Total recoveries identified: €19/month subscription cancelled + likely €380-€600/month from homewares re-cost + estimated €1,800 cash converted from aged-stock markdown over the next month. None individually dramatic. All additive across the year.

Common close-out mistakes

Five traps that most owners fall into on the first 2-3 closes. Avoiding them is the difference between a 90-minute close that holds and a 3-hour close that gets skipped by month four.

1. Doing the close on the last day of the month, not the first 2-3 days of the new one. The last day is tired, supplier invoices have not all arrived, and the last days of card sales have not settled. Move it to the first Saturday and the time drops by a third.
2. Trying to reconcile to the euro. The expected gaps in section 1 are real and have known causes. Spending 20 minutes trying to close a €14 gap is a waste — note it, move on.
3. Skipping the floor walk because the numbers look fine. Section 2 gives you stock totals; section 3 gives you stock ages. They are different. The back-room box in Mira's example would have stayed invisible if she had only done section 2.
4. Writing a 12-item action list. The constraint is three. Twelve never gets done. Three gets done in the first week and you can do another three at the next close. Discipline on this number is the difference between an action list that acts and one that decorates.
5. Filing the close in a folder and never looking at it again. The action list lives in a notebook open on your desk, not in a folder. The diagnostic sections (1-6) go in the folder; the action list (7) stays visible. Owners who file everything stop running the close within four months because nothing visibly changed.

What to share with your accountant (vs what stays with you)

The monthly close produces two distinct outputs with different audiences. Conflating them is why most retail owners end up with neither working well.

For the accountant — statutory pack, ~6 lines:

1. Gross revenue, split by tax rate.
2. Tax collected.
3. COGS — reconciled total per section 2.
4. Fixed costs — totals per category (rent, payroll, software, etc.).
5. Variable costs — totals per category (packaging, deliveries, ad spend, etc.).
6. Supplier invoices for the month (paid and unpaid), as a folder.

That is enough for filing, VAT, and year-end accounts. They do not need (and almost certainly do not want) the margin-trend table, the aged-stock list, the GMROI ratio, the top-5 / bottom-5 ranking, or the action list. Those are operational outputs for you.

For you — operational pack, the other 6 outputs:

• The three-way reconciliation note (section 1).
• The COGS gap note and likely cause (section 2).
• The aged-stock list (section 3).
• The fixed cost tick-list with any cancellations flagged (section 4).
• The margin trend table with one-line story (section 5).
• The top-5 / bottom-5 / GMROI line (section 6).
• The action list — on your desk, not in a folder (section 7).

A separate point: do not let the accountant be the only person who sees your numbers in detail. Their job is filing, not operating. Owners who outsource monthly numerical understanding to the accountant end up running on quarterly hindsight. Owners who run the 90-minute monthly close themselves keep the operating model in their own head and use the accountant for what accountants are actually for — tax accuracy and compliance.

When you outgrow paper

The printable template above works in a notebook or a spreadsheet. Most owners run it that way for the first 2-6 months. At some point — usually around close number 4 or 5 — the arithmetic starts taking longer than the thinking, and the close stretches past 90 minutes for reasons that have nothing to do with the shop and everything to do with summing daily entries by hand.

That is the moment to move the arithmetic somewhere else.

nouz computes the daily numbers every evening using the exact formula the template assumes — gross revenue minus tax minus card fees gives net; net minus COGS minus variable costs minus the daily fixed-cost slice gives EBIT. The daily slice is the monthly fixed cost divided by 30.4375. Card fees only apply to card revenue. COGS is snapshotted at the moment of sale. Fixed costs respect start_date and end_date so cancelled subscriptions stop allocating the day you set the end date.

By the time you sit down for monthly close, nouz has pre-built:

• Section 1 — daily revenue totals already summed, cash/card split enforced at entry.
• Section 2 — COGS snapshot total for the month, ready to compare against your supplier invoice sum.
• Section 3 — aged-stock list (you still walk the floor; the list pre-flags the candidates).
• Section 4 — active fixed cost list sorted by amount, with end_dates visible.
• Section 5 — margin per period with trailing 3-month and year-over-year columns.
• Section 6 — SKU-level units and margin contribution rankings.

Section 7 — the action list — stays in your notebook on your desk. Tools should not write your action list. The close shrinks from 90 minutes to 50-60, the arithmetic stops being the bottleneck, and the time saved goes into the parts that actually require judgement — the floor walk, the supplier conversations, and the three actions you commit to for the new month.

The same-day promise that runs through every nouz page applies here too. You should not be waiting until month-end to find out what March looked like. You should be seeing today's number tonight, the week's number on Sunday, and using the monthly close as the time to step back and see the pattern across the 30 days — not the time to find out whether the month worked. For the bigger context on retail profitability and where this monthly ritual sits in the broader operating system, see the retail profitability guide.

Seven sections. Ninety minutes. Three actions. First Saturday of every new month. That is the honest retail monthly close. Print the template, do the first one this weekend, and the year stops being a feeling and starts being a number.

FAQ