Summary
Retail profit is decided long before the checkout: by how much inventory you buy, when you buy it, how fast it sells and how much you mark down. A driver-based financial model links traffic, conversion and average sale to merchandise plans, staffing, rent and cash, so retailers can see the effect of every decision before they make it. This guide explains how to build one, covering sales forecasting, seasonality, open-to-buy, inventory turns and GMROI, and includes a calculator for your next buying plan.
Independent retailers across Canada, from boutiques and gift shops to sporting goods, home décor, pharmacy-adjacent and specialty food stores, run on thin margins and heavy inventory. A single over-buy before the holidays can tie up a year's profit in stock that has to be cleared at a discount in January.
Most retailers track sales in their point-of-sale system and see profit once a year from their accountant. What's missing is the forward-looking link between the two: a model that says how much to buy each month, how much staff to schedule, how much cash will be left after the holiday build, and what happens if traffic drops 10%.
That is what a retail financial model does. Ledgerive's financial modeling services build driver-based models for single stores, multi-location operators and omnichannel brands, connected to clean data from our bookkeeping services.
Want a model that runs your store by the numbers?
Get a free scoping call for a driver-based retail model with sales, inventory and cash planning. Book a free 30-minute call.
1. Canadian Retail in 2026
Retail sales rebounded in August 2026 after a dip in July, with core retail, which excludes gas stations and auto dealers, up 1.1%. Shoppers are still spending, but more selectively, so retailers that match inventory to demand and protect margin outperform those that simply stock more. Rising wages and borrowing costs make that discipline even more important.
2. Why Retailers Need a Driver-Based Model
- Buying decisions: know how much you can buy each month without running out of cash or space.
- Seasonal cash: see the low point of cash after the holiday inventory build and before sales arrive.
- Pricing and markdowns: understand how promotions and clearance affect gross margin.
- Staffing: schedule labour to forecast traffic, not habit.
- Growth: test a second store, a pop-up or an online channel before committing.
- Financing: give lenders and landlords projections built from drivers they recognize.
If you're opening a new store, start with a business plan; our guide to business plan services for retail stores in Oakville covers location, lease and break-even analysis. This article focuses on the model that runs the store once it's open.
3. How a Retail Model Is Structured
| Module | Key inputs | Key outputs |
|---|---|---|
| Sales | Traffic, conversion, average transaction, seasonality, online sales | Sales by week or month, by channel |
| Merchandise | Category mix, markup, markdowns, shrink, stock targets | Gross margin, open-to-buy, inventory levels |
| Labour | Hours by day part, wage rates, payroll costs | Labour cost and % of sales |
| Occupancy and operations | Rent, TMI, utilities, card fees, marketing, software | Fixed cost base and break-even |
| Cash and financing | Supplier terms, loan payments, HST timing, capital spending | Monthly cash balance and borrowing needs |
| Scenarios | Traffic, price, markdown and cost changes | Profit and cash under each scenario |
4. Forecasting Sales and Seasonality
A retail forecast should explain sales, not just project them. Build it from three drivers: traffic × conversion rate × average transaction value. Then shape it by season.
- Use weekly history: holidays, long weekends, back-to-school and Boxing Week move sales between weeks.
- Separate channels: in-store, online and marketplace sales have different margins, fees and return rates.
- Model promotions: show the extra units sold and the margin given up.
- Plan new stores separately: they ramp up over months, while existing stores follow last year's pattern.
5. Merchandise Planning: Open-to-Buy, Turns and GMROI
Inventory is a retailer's largest investment, and three measures keep it under control.
| Measure | Formula | What it tells you |
|---|---|---|
| Open-to-buy (retail) | Planned sales + markdowns + planned ending inventory − beginning inventory − on order | How much more you can buy this period |
| Inventory turnover | Cost of goods sold ÷ average inventory at cost | How many times stock sells through in a year |
| Weeks of supply | 52 ÷ inventory turnover | How long current stock lasts |
| GMROI | Gross margin dollars ÷ average inventory at cost | Margin earned per dollar of inventory |
| Stock-to-sales ratio | Beginning inventory ÷ planned sales for the period | Whether stock is in line with demand |
Carrying less of the right inventory often improves returns more than squeezing an extra point of margin. Category-level turns and GMROI show which products deserve more space and which should be reduced.
6. Interactive Open-to-Buy and GMROI Calculator
Plan next month's purchases and check how hard your inventory is working. Enter inventory and sales at retail value; results are illustrative.
Next month's buying plan
Annual performance
7. Labour, Occupancy and Omnichannel Costs
- Labour: build schedules from forecast traffic by day and hour, then add vacation pay, CPP, EI and WSIB; Ontario's minimum wage is $17.95 an hour.
- Occupancy: include net rent, TMI, utilities and any percentage rent, and track occupancy as a share of sales.
- Payment costs: card processing fees on every sale, plus buy-now-pay-later and gift card costs.
- E-commerce: platform fees, shipping, packaging, returns and digital advertising, modeled per order.
- Shrink: theft, damage and admin errors, usually modeled as a share of sales by category.
8. Cash Flow, Financing and BN Registration
Retail cash follows inventory. Stock for the holiday season is bought and often paid for in late summer and fall, while sales arrive in November and December. A monthly cash forecast shows how low the bank balance gets and when.
- Supplier terms: model deposits, net 30 or net 60 terms and early-payment discounts.
- HST: 13% HST collected in Ontario is remitted on your filing schedule; a holiday quarter can bring a large HST payment in the new year.
- Lines of credit: CSBFP lines of credit go up to $150,000, with interest capped at prime plus 5%; arrange financing before the seasonal build.
- Capital spending: fixtures, renovations and POS upgrades should be scheduled in the model, not funded from inventory cash.
Lenders also check registrations. Every account runs through your nine-digit CRA business number:
- BN registration: obtain a business number when you incorporate or register the store.
- GST/HST (RT), payroll (RP) and corporate tax (RC) accounts, plus an import-export (RM) account if you import merchandise directly.
- Keep accounts current: lenders and landlords may ask for CRA statements under your CRA business number.
9. KPI Dashboard and Using the Model
| KPI | Review | Action it drives |
|---|---|---|
| Traffic, conversion, average sale | Weekly | Staffing, merchandising, promotions |
| Sales vs plan by category | Weekly | Reorders or cuts to open-to-buy |
| Gross margin, markdowns, shrink | Monthly | Pricing and loss prevention |
| Turns, weeks of supply, GMROI | Monthly | Assortment and buying decisions |
| Labour and occupancy % of sales | Monthly | Scheduling and lease decisions |
Once the model runs monthly, it supports bigger decisions: opening another location, adding an online store or approaching a lender. Our business plan services turn the model into a financing package, and our fractional CFO services review results with you every month. We use the same driver-based approach in other sectors, as our guides to financial modeling for consulting firms in Vaughan, bookkeeping services for consulting firms in Mississauga and business plan services for manufacturing in Ontario show. As a guide, our models range from about $1,500 to $15,000 before HST, depending on scope.
10. Frequently Asked Questions
What is open-to-buy in retail?
Open-to-buy is the amount of merchandise a retailer can still purchase for a period without exceeding its inventory plan. At retail value it is commonly calculated as planned sales plus planned markdowns plus planned end-of-period inventory, minus beginning inventory and merchandise already on order, then converted to cost using the markup.
What is GMROI and what is a good GMROI?
Gross margin return on inventory investment (GMROI) is annual gross margin dollars divided by average inventory at cost. It shows how many dollars of gross margin each dollar invested in inventory earns. A GMROI above 1 means inventory earns more than it costs, and what counts as good varies widely by category, so compare against your own history and peers in your segment.
How do you forecast sales for a retail store?
A driver-based forecast multiplies store traffic by conversion rate and average transaction value, adjusted for seasonality, promotions and new-store ramp-up. Existing stores can also build on last year's sales by week or month, adjusted for trends, price changes and planned marketing.
How much inventory should a retail store carry?
Enough to meet forecast sales and maintain an attractive assortment, but not so much that cash is tied up and markdowns rise. Retailers set inventory levels using stock-to-sales ratios, weeks of supply and turnover targets by category, then manage purchases through an open-to-buy plan.
What KPIs should a retail store track?
Key retail KPIs include sales per day and per square foot, traffic, conversion rate, average transaction value, gross margin, markdown and shrink rates, inventory turnover, GMROI, weeks of supply, labour cost as a share of sales and occupancy cost as a share of sales.
Summary
A retail financial model connects traffic, conversion and average sale to merchandise plans, staffing, rent and cash. Use open-to-buy to control purchases, track turns, weeks of supply and GMROI by category, model seasonality and the holiday cash low point, and arrange financing ahead of the inventory build. Keep CRA business number accounts current and review KPIs monthly so every buying decision is backed by numbers.
Plan your inventory and cash with confidence
Ledgerive builds financial models for independent retailers, multi-store operators and e-commerce brands across Ontario and Canada. Book a free 30-minute call or reach us directly.
Sources: CP24, Statistics Canada retail sales for August 2026; ISED, CSBFP Overview and Highlights 2024-25; ISED, CSBFP FAQ. Seasonality, GMROI examples and calculator results are illustrative.