Shopify inventory reports for the whole picture.

From what is on order to what is on the shelf, on a truck or not selling, see every part of your stock in one place. Filter, save and export to CSV.

Trusted by Shopify and Amazon sellers

  • Kate King Jewellery
  • Eugene Textile Center
  • búl
  • Totally Numb
  • The Store X Berlin
  • Gather Here
  • From The Bronx
  • The Kitchen Nashville
  • Good Day Smart
  • Mine and Yours
  • Culture Fly
  • Canadian Coin
  • Shepherds Fashion
  • Purpose Built
  • Modlite
  • Vapor Shoppe
  • Bio-Spielzeug
  • Santa Cooking
  • Gourmend Foods
  • Evtrove
  • American Raggie

Your stock questions shouldn't need a spreadsheet.

What is my stock worth? Which supplier is late? What should I reorder this week? What is sitting on the shelf not selling? Every one of those usually means an export, a pivot table and an hour you didn't have. Channel Bay answers them from the stock, orders and purchase orders it already keeps in sync.

Pick a question. Open the report.

Follow every unit, from purchase order to sale.

Most stores can see what's on the shelf. Channel Bay shows the rest of the journey too, so nothing about your stock is out of sight.

1. On order

What you've ordered, from whom, what's still open and which deliveries are late.

The reports merchants open first.

Stock on Hand by Variant

Your everyday stock check: on hand, committed, available and incoming, with value at cost and retail and margin %.

Answers: What do I have right now, and what is it worth?

Reorder Suggestions

What to order, from whom and how much, rounded to the supplier's pack size and minimum order, with an order-by date.

Answers: What should I buy this week?

Receipts Log with Landed Cost

Every delivery line with its share of freight added, so you see the true unit cost against the catalogue price.

Answers: What did that shipment really cost?

Supplier Performance

On-time %, real lead times and price drift for every supplier.

Answers: Which suppliers should I keep?

Dead Stock

Items that have barely sold in 60 days, with the cash tied up in them and a suggested action.

Answers: What's quietly costing me money?

Inventory Turnover

How many times stock turned over, annualised, and how many days of inventory you hold.

Answers: Am I carrying too much stock?

Your data, your way.

Filter and save

Filter by date and channel, choose your columns and save the layout you use every week.

Export to CSV

Download any report as a CSV for your accountant, your buyer or your own spreadsheet.

API for your own systems

Pull report data into your own tools through the Report Pundit API.

Value and margin reports run on your real costs.

Reports that show stock value, cost of goods or margin use the cost of each delivery you received, so the numbers reflect what you actually paid. Switch on Cost Tracking to fill these columns.

See how cost tracking works

On the way.

  • Month-End Inventory Value: beginning and ending stock value each month, with what sold, came back and arrived
  • Stock on Hand as of Date: what you held, and what it was worth, on any past date
  • Roll-forward reports (units and value): opening stock plus what came in, minus what went out, by variant and location
  • Write-offs and Shrinkage by Month: what damage, theft and count errors cost you each month
  • Returns and Restocks by Variant: which items come back most, and how many go back on the shelf
  • Estimated Lost Sales: roughly what stock-outs cost you in revenue

Every report, in one list.

Stock levels & value 10
  • Stock on Hand by Variant Uses cost tracking

    Your everyday stock check. See what you hold, what is already promised to customers, what is arriving, and what it is all worth.

  • Stock on Hand by Product Uses cost tracking

    Same as R01 but one row per product, so you can see which products hold the most stock and money without scrolling through every size and colour.

  • Stock by Variant and Location Uses cost tracking

    Find where each item is sitting so you know which location to pick from, or which one to top up.

  • Stock by Location Uses cost tracking

    Compare your warehouses and shops. Shows which location holds the most stock and money, and what is on its way.

  • Stock Value by Vendor Uses cost tracking

    See which suppliers or brands tie up the most cash, so you know where to cut back on buying.

  • Stock Value by Product Type Uses cost tracking

    See which product types hold the most stock money. Helps you balance your range.

  • Variant Catalogue and Costing Uses cost tracking

    The master price list. Check supplier cost against what you really paid, and your margin. Use it to spot wrong costs or prices.

  • Out of Stock

    Your 'what is empty' list. Use it each morning to reorder and to stop selling items you cannot ship.

  • Below Reorder Point

    Your reorder list. Shows what has dropped to its reorder level and how much to buy to get back to full.

  • Overstock Uses cost tracking

    Find stock you bought too much of. Use it to stop reordering, run a sale, or send stock to another location.

Stock movements 11
  • Movement Summary by Type & Month Coming soon

    See how stock moved each month (bought, sold, returned, moved, counted). Good for spotting odd months.

  • Roll-forward Units by Variant Coming soon

    Explain why stock changed. Opening stock plus what came in, minus what went out, equals closing stock, item by item.

  • Roll-forward Value by Variant Coming soon Uses cost tracking

    The same as R12 but in money. Used by your accountant to reconcile inventory value at month end.

  • Roll-forward Units by Location Coming soon

    Explain stock changes for each location, including stock moved between locations.

  • Month-End Inventory Value Coming soon Uses cost tracking

    Month-end inventory value for your books, with what sold, came back and arrived during the month.

  • Daily Stock Movement by Location Coming soon

    A day-by-day stock diary for one location. Use it to trace exactly when stock went wrong.

  • Stock on Hand as of Date Coming soon Uses cost tracking

    Look back in time. See what you held, and what it was worth, on any past date. Used for audits and month-end.

  • Stock Adjustments Log

    The full history of every manual stock change, with when, where, why and what it cost. Use it to check who changed what.

  • Adjustments by Reason & Location Coming soon

    See which reasons (damage, theft, recounts) cause the most stock changes at each location.

  • Write-offs & Shrinkage by Month Coming soon

    See how much money you lose each month to damage, theft and count errors. Helps you fix the cause.

  • Returns & Restocks by Variant Coming soon

    See which items get returned most, and how many go back on the shelf. Points to quality or description problems.

Purchase orders & suppliers 14
  • Purchase Order Register

    Your list of all purchase orders. Check what you ordered against what has arrived, and what is still open.

  • Open PO Lines

    Everything you are still waiting for, line by line. Use it when a supplier asks 'what is outstanding?'.

  • Incoming Stock by Variant

    See how many units of each item are on order and when the next delivery is due, before you order again.

  • Overdue Purchase Orders

    Chase late deliveries. Lists purchase orders past their due date and how late they are.

  • Receipts Log with Landed Cost

    Every delivery with its true cost once freight is added. Use it to check receiving and costs.

  • Landed Cost by Supplier

    Compare suppliers on the real cost of their goods after freight, not just the price on the quote.

  • Landed Cost by Variant Uses cost tracking

    See the true cost of each item compared with the catalogue price. Use it to set selling prices and find cost creep.

  • Vendor Purchase History

    See how much you buy from each supplier and what is still open. Useful before price talks.

  • Supplier Performance

    Score your suppliers on being on time, real lead times and price changes. Use it to choose who to keep.

  • Supplier Lead Time by Variant

    Compare how long suppliers really take with what is set in the system, so reorder dates are right.

  • Owed to Suppliers

    Your supplier payables. Shows what you owe for goods already received and which invoices are late.

  • Purchase Price Variance

    See where you paid more or less than the catalogue price. Catches price rises and invoice mistakes.

  • Monthly Purchases Received

    Monthly buying by supplier (goods and freight). Use it for budgeting and spotting rising freight.

  • Supplier Catalogue

    Your supplier price list. Who supplies each item, at what cost, pack size and minimum order.

Stock transfers 4
  • Stock Transfer Register

    Every transfer between locations with its status and value. Use it to track and audit stock moves.

  • Transfers by Variant

    See what moved between locations for each item, and what has not arrived or was rejected.

  • In-Transit Stock Uses cost tracking

    Stock on the road right now and its value. Use it to chase late transfers.

  • Transfer Flow by Route & Month

    See which routes between locations move the most stock. Helps you plan restocking.

Stocktakes 3
  • Stocktake Variance Detail Uses cost tracking

    After a stocktake, see each counted item: expected vs counted, the difference and its cost. Use it to investigate.

  • Stocktake Summary Uses cost tracking

    Judge each stocktake. Shows how accurate the count was and what the differences cost in total.

  • Last Counted

    Your cycle-count worklist. Shows what has not been counted for longest, so you count the stalest items first.

Sales, COGS & margin 8
  • Sales by Variant

    Your main sales report by item: sales, discounts, returns and net sales. Use it to see what sells.

  • Sales by Product

    Sales by product, with each product's share of total sales. See which products carry the business.

  • Sales & Margin by Location Uses cost tracking

    Compare locations on sales, margin and average order value. Shows which location earns the most.

  • Sales & Margin by Vendor Uses cost tracking

    See which brands or suppliers make you the most money and which are not worth the shelf space.

  • Sales by Channel

    Compare sales channels (online store, Amazon and others) on orders, sales and average order value.

  • Sales & Margin by Product Type Uses cost tracking

    See which product types earn the best margin. Helps you decide what to stock more of.

  • Orders over Time

    See sales trends by day, week, month or weekday. Use it to plan staffing and promotions.

  • Top Sellers Uses cost tracking

    Your best sellers by units, with revenue and profit. Use it to make sure they never run out.

Planning & optimisation 14
  • Sales Velocity & Days of Cover

    See how fast each item sells and how many days its stock will last. The base for reorder decisions.

  • Reorder Suggestions

    Tells you what to order, from whom and how much, rounded to the supplier's pack size and minimum. Use it to build purchase orders.

  • Projected Shortfall

    Look ahead for stock-outs. Shows what will run short in the next days you choose, even after counting incoming orders.

  • Dead Stock Uses cost tracking

    Find items that barely sell. Use it to run clearance sales and stop wasting cash on them.

  • Days Since Last Sale Uses cost tracking

    See how long each item has gone without a sale and how much money is stuck in it.

  • Aging Stock Uses cost tracking

    See how old your stock is by age band. Old stock is a risk, so use it to plan markdowns.

  • ABC Analysis Uses cost tracking

    Ranks items A, B or C by share of sales. Focus buying and counting on the A items.

  • Sell-Through Rate Uses cost tracking

    See what share of the stock you had was actually sold. A low number means you bought too much or the item is slow.

  • Inventory Turnover Uses cost tracking

    See how many times your stock turns over a year and how many days of stock you hold. A key health measure for your inventory.

  • Inventory-to-Sales Ratio Uses cost tracking

    See how much stock you carry for every unit sold. A high number means too much stock for your sales.

  • Stock Availability Coming soon

    See how many days each item was in stock. Shows which items are often unavailable to customers.

  • Estimated Lost Sales Coming soon

    Estimate the sales you lost because items were out of stock. Shows what stock-outs cost you.

  • Weeks of Cover by Vendor Uses cost tracking

    See how many weeks of sales each brand's stock will cover. Use it to decide which brands to reorder first.

  • GMROI by Product Type Uses cost tracking

    See how much profit each product type earns for the stock money held in it. Shows where your money works hardest.

Shopify inventory reports, answered.

Questions? Talk to our team

Book a demo
What can I see in Channel Bay reports?

Every stage of your stock: what's on order, what arrived and what it really cost, what you hold at each location, what's in transit, how accurate your counts are, what's selling and what to reorder.

Do reports include Amazon sales?

Yes. Sales by Channel compares your online store, Amazon and other channels on orders, sales and average order value.

Do I need Cost Tracking for reports to work?

Most reports work without it. Reports that show stock value, cost of goods or margin need Cost Tracking switched on to fill those columns.

Is the cost of goods exact?

Cost of goods and gross profit columns are estimates based on your tracked purchase costs. Use them to spot trends and problems, and your accounting system for final figures.

Can I see my inventory value at month-end?

Today, Stock on Hand by Variant shows your current value at cost and retail. A dedicated Month-End Inventory Value report and a Stock on Hand as of Date report are coming soon.

See your whole inventory in one place.

Install Channel Bay and follow every unit from purchase order to sale, in reports built on your synced stock and orders.