Built for businesses that sell, stock and ship.
Our work centers on three kinds of data: sales, inventory and daily operations. These are the businesses where those three meet, and the reports we most often build for them.
Retail and e-commerce
Online and in-store sales live in different systems, and the stock sheet is always a week behind. We combine them so you can see sell-through by product and channel, and reorder before the bestsellers run out.
- Typical sources:
- Shopify, Square, QuickBooks, inventory spreadsheets
- Typical reports:
- weekly sales vs last year, sell-through by category, reorder list, channel margin
- Online share
- 43%
- +3 pts
- Low-stock SKUs
- 27
- Below 14 days
Days of stock by warehouse
| Warehouse | On hand | Days |
|---|---|---|
| Fresno Main DC | 18,420 | 36 |
| Bakersfield | 6,105 | 58 |
| Visalia | 4,870 | 9 |
| In transit Open POs | 3,200 | — |
Wholesale and distribution
Margins are thin and cash is tied up in stock. We report days of stock and turnover by warehouse and supplier, open purchase orders, customer margin and receivables aging, so buyers and finance work from the same figures.
- Typical sources:
- ERP or inventory system exports, QuickBooks, purchase order sheets
- Typical reports:
- stock by location, slow movers, customer profitability, A/R aging
Light manufacturing
Production runs, raw material stock and finished goods sales usually sit in separate files. We connect them to show output against plan, material on hand versus open orders, and product margin using your actual costs.
Typical reports: production vs plan, material coverage, order backlog, cost per unit.
Multi-location service businesses
When each site reports in its own way, comparisons are guesswork. We put every location on the same definitions, then use row-level security so each manager sees their own site and the owner sees all of them.
Typical reports: sales and labor by location, supplies usage, job or ticket volume, location rankings.
Measures we define in writing
Each project includes a measure catalog. These are the definitions we start from; we adjust them to how your business counts.
| Measure | Definition | Sources |
|---|---|---|
| Net sales | Gross sales minus returns and discounts, by day, week or fiscal period | POS, Shopify, invoices |
| Gross margin % | Net sales minus cost of goods sold, divided by net sales | Accounting (COGS) + sales |
| Days of stock on hand | Current units on hand divided by average daily units sold | Inventory + sales |
| Inventory turnover | Cost of goods sold divided by average inventory value | Accounting + inventory |
| Stockout rate | Share of active SKUs with zero on hand at period end | Inventory system |
| Order fulfillment time | Hours from order placed to order shipped | Order or ERP exports |
| A/R aging | Open invoices grouped by 0–30, 31–60, 61–90 and 90+ days | QuickBooks or ERP |
Not on this list?
If your business runs on sales, stock and operational data, the approach is the same. Tell us what you sell and how you track it.