pacific crest supply

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
Illustrative product interface
Illustrative product interface

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.

MeasureDefinitionSources
Net salesGross sales minus returns and discounts, by day, week or fiscal periodPOS, Shopify, invoices
Gross margin %Net sales minus cost of goods sold, divided by net salesAccounting (COGS) + sales
Days of stock on handCurrent units on hand divided by average daily units soldInventory + sales
Inventory turnoverCost of goods sold divided by average inventory valueAccounting + inventory
Stockout rateShare of active SKUs with zero on hand at period endInventory system
Order fulfillment timeHours from order placed to order shippedOrder or ERP exports
A/R agingOpen invoices grouped by 0–30, 31–60, 61–90 and 90+ daysQuickBooks 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.

Contact us