Plan the store. Understand the margin. Look ahead at cash.
Ten retail business models, with the Excel and Claude resources to review sales, inventory, operating performance and cash timing.
Choose a starting point for an online store, a subscription business or a physical retail location. Adapt the relevant model to your operating assumptions, then use the supporting workbooks and finance playbooks for the questions you need to answer.
10
Industry financial models
20
Excel tools and dashboards
5
Cash-flow and liquidity workbooks
3
AI, skills and playbook packs
Start with the way the business earns revenue
10 financial models
The collection covers three online formats and seven store-based retail businesses. Each model has its own operating case, assumptions and workbook structure. Open a model’s product page to inspect its scope before choosing your starting point.
A Shopify gift store with outsourced US printing and shipping. Forecast accepted orders from store sessions, conversion, product mix and prices, then review the fulfillment costs, staffing and funding behind the plan.
An inventory-owning grocery retailer delivering five curated basket formats. Plan buying households, order frequency, basket selection and checkout receipts alongside merchandise, delivery and operating costs.
A direct-to-consumer lifestyle box business with monthly prepayments. Explore subscriber acquisition, cancellations, box prices and fulfillment costs as the paying customer base develops.
A neighbourhood women’s apparel and accessories shop. Connect customer traffic, purchase conversion, retained items, product mix and prices to merchandise costs, store expenses and staffing.
An independent neighbourhood grocer with five merchandise departments. Model checkout transactions, items purchased and departmental prices, then review the costs and staffing required to operate the store.
A pet retailer selling shelf-stable merchandise. Review customer activity, category prices, stock costs, staffing and store overhead within the model’s defined retail operating case.
A standalone cosmetics retailer. Link store visits, purchase conversion, basket size, seasonality and category prices to merchandise revenue, costs, staffing and financial reports.
An independent over-the-counter parts retailer. Plan store sales, merchandise costs, staffing, opening investment and financing for a physical location serving local customers.
A store selling new printed books in six categories. Explore visits, purchase conversion, books per transaction, category prices and seasonality alongside the bookstore’s spending and operating plan.
A community pharmacy with insured and cash prescriptions plus a retail front end. Connect purchasing customers, items sold and realised receipts to merchandise costs, pharmacy staffing and overhead.
Review the numbers behind retail performance
20 Excel tools
Use the reporting tools for the monthly picture, then choose a focused workbook to investigate a margin, inventory, pricing or customer question. The tools include worked examples; adapt their units, definitions and inputs to the business you are reviewing.
Planning and sales performance4 tools
Monthly P&L Excel Dashboard
Review monthly profit, budget variance and fiscal year-to-date results with an editable P&L dashboard and report.
12-Month Rolling Forecast Excel Dashboard
Keep the next 12 months of revenue, profit and cash in view as the latest closed month changes.
Price Volume Mix (PVM) Excel Dashboard
Explain the movement between planned and actual revenue through product quantities, selling prices and mix.
Sales Tracking Spreadsheet
Forecast sales-team hiring, ramped capacity, bookings and supporting roles where that sales structure applies.
Margins, pricing and returns6 tools
E-commerce Contribution per Order Excel Dashboard
Reconcile net sales, variable costs and contribution per fulfilled order.
Product Contribution Portfolio Excel Dashboard
Investigate which products drive contribution and why a SKU can sell more units while earning less.
Discount Approval & Margin Floor Excel Dashboard
Compare proposed discounts with the margin floor and remaining discount headroom.
Target Profit Pricing Excel Dashboard
Review price and volume assumptions against a defined operating-profit target.
Break-Even & Margin of Safety Excel Dashboard
Examine the sales level needed to cover costs and the headroom above break-even.
Returns & Reverse Logistics Excel Dashboard
Trace the effect of returned goods and reverse-logistics costs on contribution per unit shipped.
Inventory, suppliers and credit5 tools
Inventory Reorder and Safety Stock Excel Dashboard
Review stock cover, reorder triggers and safety-stock assumptions by SKU.
Inventory Efficiency & GMROI Excel Dashboard
Compare gross profit earned against the capital held in inventory.
Supplier Discount Decision Excel Dashboard
Evaluate the trade-off between taking an early-payment discount and retaining cash.
Freight and Landed Cost Excel Dashboard
Compare supplier and freight costs on a landed-cost basis per usable unit.
Customer Credit Limit Monitor Excel Dashboard
Review credit exposure and orders that need release approval before shipment.
Acquisition and repeat demand5 tools
Marketing Contribution After Ad Spend Excel Dashboard
Review how much attributable contribution remains after media spend.
Customer Acquisition Payback Excel Dashboard
Follow the recovery of acquisition spending through the contribution earned by a customer cohort.
Historical Cohort Retention Excel Dashboard
Review customer and recurring-revenue retention by cohort, particularly for subscription formats.
Realized Cohort Contribution Excel Dashboard
Compare the contribution recovered per original customer across cohorts.
Sales Funnel Economics Excel Dashboard
Investigate conversion-stage economics and the constraint on the next incremental sale.
Follow the timing of money in and money out
5 cash and liquidity workbooks
Combine cash planning with supplier-payment and settlement review. These five products are listed separately from the 20 Excel tools above.
Weekly cash planning
Organise expected cash receipts and payments by week and follow the resulting opening and closing balances.
Monthly cash flow
Build a 12-month view of operating, investing and financing cash movements, with the resulting monthly cash balance.
Budget vs. actual cash flow
Compare planned and recorded cash flows and review their effect on monthly and year-to-date cash movement.
Payables due-date ladder
Arrange upcoming supplier obligations by due date so concentrated payment periods are visible.
Marketplace payout reconciliation
Investigate the differences between marketplace activity, settlements and the amounts received.
Give the finance review a defined method
3 AI and playbook packs
The collection includes three named resource packs for use with your own Claude access and source files. They provide instructions, templates, worked examples and review checks for specific finance tasks.
Finance Team Toolkit for Claude
A collection of 25 finance playbooks covering data checks, planning, profitability, cash, funding and CFO decisions.
25 editable Markdown playbooks and 25 copy-ready prompts.
Reusable CSV input templates, fictional sample data and worked answers.
A searchable start guide and catalogue, with optional Python checks for the supplied examples.
Procedures for account mapping, forecasting, variance analysis, collections, management reporting and other recurring finance tasks.
Use it for: giving a recurring finance task clearer inputs, a defined method and a result another person can review.
12 Shopify Finance Agents for Claude
A Shopify finance kit organised around sales, cash and profit, with a worked close that follows the figures back to their source records.
12 Markdown agent definitions for Claude Code, with guidance for using selected roles in regular Claude chat.
An editable Excel control workbook with sales, cash, profit, SKU and reconciliation views.
A five-page PDF playbook, setup instructions and 12 synthetic source CSVs.
An independent Python calculation checker for the included worked example.
Use it for: understanding how orders, discounts, returns, fees and costs connect to payouts, bank deposits and operating profit.
7 Claude Agents for Budget vs. Actuals
A structured monthly review from source intake and account mapping through revenue and cost analysis, management commentary and independent checks.
7 agent files with required inputs, defined outputs, handoffs and review checks.
A formula-driven Excel workbook covering Monthly, YTD, Products, Drivers, Inputs, Mapping and Checks.
A four-page PDF playbook, workflow instructions and a one-page reference.
Fictional budget and actuals CSVs, mapping files, driver evidence, expected control totals and a worked management note.
An optional Python calculation checker for the supplied example.
Use it for: explaining why a revenue result and an operating-profit result can move in different directions, with calculations and source evidence kept visible.
Choose the files relevant to the question. The collection contains separate workbooks and guidance resources that you adapt to your own business.
A practical starting point for different retail projects
Use the model library when comparing retail formats or preparing a new forecast. Use the supporting tools when reviewing an existing store’s margins, purchasing, cash or management reports. Advisers can select the files that fit each client’s operating model.
What you need
Microsoft Excel for the workbooks and your own compatible Claude access for the AI resources. Some agent workflows are designed for Claude Code; selected instructions can also be used in regular Claude chat. Python 3 is optional for the included local checkers.
How to begin
Review the scope of the model or tool you select, inspect its worked example and prepare the required inputs. Adapt the assumptions, definitions and reporting periods, then check the calculations against your source information.
Is this one combined workbook?
The bundle is a collection of separate files. Each workbook and resource pack keeps its own structure and instructions; select the tools that match the task.
What do the counts mean?
The four groups contain 38 named catalogue products. AI packs include multiple files; the counts do not represent a total of unique agents or individual worksheets.
Are the examples real trading results?
The financial-model cases and supporting examples are illustrations for planning and review. Replace the relevant assumptions with information appropriate to your business.
Are software subscriptions included?
Use your own Excel and Claude access. Software subscriptions, custom integrations and individual consulting services are separate from this digital collection.
Some supporting dashboards and AI resources are also available individually at no charge. This bundle combines the selected industry financial models with the named supporting resources. Created by Henry Sheykin / FinModelsLab.
Choosing a selection results in a full page refresh.
