Inventory Transfers
Report for Shopify

Every stock movement between your locations in one view — origin, destination, status, and received-vs-rejected quantities — so you can balance stock, reconcile transfers, and measure internal lead times.

Star

5 from 1,800+ merchants

2,000+ data fields

Trusted by 40,000+ Shopify stores

Updated June 2026

What this report is
The Inventory Transfers Report is a Shopify analytics report that tracks stock moving between your locations — showing each transfer’s origin, destination, status (Draft, Ready, Shipped, Received), and the quantities ordered, received, and rejected. It helps multi-location merchants balance stock, reconcile what arrived against what was sent, and measure internal lead times. Report Pundit makes it a free pre-built template with exports to Google Sheets, Excel, CSV, and PDF.
Report type
Inventory movement between locations
Best for
Multi-location retailers, warehouse ops, inventory controllers
Refresh
Near real-time
Setup time
Under 5 minutes
Tracks
Transfer name, status, origin, destination, ordered / received / rejected qty, dates
Export to
Google Sheets · Excel · CSV · PDF
Scheduling
Daily · Weekly · Monthly
Shopify plan
All plans with multiple locations
Keep up with Shopify reports
We promise we won’t spam you.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Why this report matters

The moment you run more than one location, stock starts moving between them — warehouse to store, store to store, warehouse to 3PL. Each of those movements is a transfer, and each is a chance for stock to go missing, arrive short, or sit in limbo as "in transit" for longer than it should.

The Inventory Transfers Report gives you a single view of every movement: what was sent, where it came from, where it’s going, its current status, and how much actually arrived versus how much was rejected. That visibility is what keeps inventory counts accurate across locations and prevents the overselling that happens when stock is assumed to be somewhere it isn’t.

It also turns transfer history into a performance metric. By tracking the gap between when a transfer ships and when it’s received, you can measure internal lead times and spot the routes or teams that consistently run slow.

What’s included in the report

The report ships with the columns below by default. Every column is optional, and you can add 50+ more from the Report Pundit field library. Examples, formulas, and heads-up notes are included to help merchants read each field correctly.

Transfer Name

The name or reference number of the transfer.

Transfer Status

Where the transfer is in its lifecycle.

Example:  Draft · Ready to Ship · In Transit / Shipped · Received

Heads up:  Stock in a Ready-to-Ship transfer is reserved at the origin — it’s committed and shouldn’t be counted as freely available there.

Transfer Note / Reason

The note or reason attached to the transfer, useful for context and reconciliation.

Route

Origin Location

The location the stock is moving from.

Example:  NY Warehouse

Destination Location

The location the stock is moving to.

Example:  LA Flagship Store

Quantities & line items

Product / Variant / SKU

The items in the transfer, down to variant and SKU.

Received Quantity

Units accepted into the destination location.

Rejected Quantity

Units rejected at receiving — damaged, mismatched, or unexpected.

Heads up:  A persistent gap between sent and received quantities is your early warning of loss, mis-picks, or damage in transit.

Timing

Expected Arrival Date

The planned arrival date set when the transfer was created.

Shipped / Received Dates

Formula:  Internal Lead Time = Received Date − Shipped Date

When the transfer shipped and when it was received — the basis for internal lead-time measurement.

Common added columns

Staff member · Tracking number · Carrier · Tags · Linked purchase order · Variant cost

Who uses this report

Concrete scenarios where this report drives a decision. Pick the one closest to your business.
01

01. Multi-location retailers balancing stock

Situation
One store is overstocked while another runs low on the same SKU.
Look at
Open and recent transfers between the two locations, plus their status.
Decision
Initiate or confirm a transfer to rebalance — and track it through to Received.
02

02. Inventory controllers reconciling receipts

Situation
You need to confirm that what was sent actually arrived.
Look at
Received vs. rejected quantities per transfer, against what was originally sent.
Decision
Investigate any gaps; adjust counts so both locations stay accurate.
03

03. Warehouse ops measuring internal lead time

Situation
Transfers seem to take too long to land.
Look at
Shipped-to-Received gap across transfers, grouped by route or staff member.
Decision
Target the slow routes; set realistic expected-arrival dates.
04

04. Finance linking transfers to POs

Situation
You need transfers tied back to purchase orders and suppliers for reconciliation.
Look at
Transfers with their linked purchase order and supplier references.
Decision
Transfers with their linked purchase order and supplier references.

How to read the report

Patterns to look for first:

  • Stuck in transit. Transfers sitting in Shipped status well past their expected arrival date — chase these before stock is assumed lost.
  • Sent vs. received gaps. A recurring shortfall between sent and received points to loss, theft, or damage on a route.
  • High rejected quantities. Frequent rejections suggest packing, picking, or handling problems at the origin.
  • Lead-time outliers. Routes with consistently long ship-to-receive times need attention or more realistic planning.

How to build the report in Report Pundit

Under 5 minutes from install to insight. No code, no SQL.

Under 5 minutes from install to insight. No code, no SQL.

  1. Install Report Pundit. from the Shopify App Store — 14-day free trial, no card required.
  2. Open Pre-built Reports. and select Inventory Transfers from the Inventory category.
  3. Choose a date range. pick the window of transfers to review — last 30 or 90 days is typical.
  4. Apply filters. narrow by status (Draft, Ready, Shipped, Received), origin, destination, tag, or reason.
  5. Customize columns. add staff member, tracking number, carrier, or linked purchase order as needed.
  6. Run the report. every transfer and its line items appear with ordered, received, and rejected quantities.
  7. Export or schedule. export to Google Sheets or CSV, or schedule a weekly transfers summary to ops.

Customization & filters

The pre-built version covers 90% of merchant needs. For the remaining 10%, common customizations:
  • Filter by status — Draft, Ready, Shipped, or Received.
  • Filter by origin / destination — focus on a specific route.
  • Add internal lead time — measure ship-to-receive duration.
  • Add staff member — attribute transfers to the team handling them.
  • Link to purchase orders — reconcile against procurement.
  • Group by route — spot consistently slow lanes.

Automate & export

Once the report is set up the way you want it, automation does the rest:
  • Schedules — hourly, daily, weekly, monthly, or custom cron
  • Delivery formats — Excel, CSV, PDF, or push to Google Sheets in real time
  • Group by month or week — trends instead of a static snapshot
  • Destinations — email (multiple recipients), Google Sheets, Google Drive, FTP/SFTP, Looker Studio, BigQuery
  • Conditional alerts — get notified only if a channel's net sales drop more than X% week-over-week

Report Pundit vs Shopify's native Sales by Channel report

Shopify ships a basic version. Here's where it stops — and what Report Pundit adds.
Capability Shopify Built-in Report Pundit
Transfer status, origin, destination
Sent vs. received vs. rejected
Schedule + email/Sheets/Slack delivery ×
Internal lead-time measurement Limited
Combine with on-hand & shipments data ×
Custom calculated columns Limited

Frequently Asked Questions

What is the Inventory Transfers Report?

A report that tracks stock moving between your Shopify locations — showing each transfer’s origin, destination, status, and the quantities sent, received, and rejected.

What transfer statuses does it show?

The full lifecycle: Draft, Ready to Ship, In Transit / Shipped, and Received. You can filter to any status.

Can it show what was received vs. rejected?

Yes. Each transfer’s line items show received and rejected quantities, so you can reconcile what arrived against what was sent.

Report Not Found
Let's create it!
Your request is in! Check out all reports with the button below.
* Error. Please input correct email

Benefits

Granular Product level insights

Granular Product-Level Insights

The report enables users to track the true sales performance of individual products, considering discounts and returns for accurate financial analysis.
Discount analysis icon

Discount Analysis

Understand the impact of discounts on product profitability and overall order value.
Order tracking icon

Order Tracking

Monitor the financial details of orders even if they undergo edits. This helps maintain accurate records and simplifies financial reconciliation processes.

Inventory Shipments

Every inbound shipment tracked end to end — shipped, received, accepted, and rejected quantities with acceptance rate — so you can catch discrepancies, plan around arrivals, and benchmark supplier reliability.

Inventory Reorder Point

This report helps identify the exact point at which inventory should be restocked to prevent any interruptions in product availability, ensuring a smooth supply chain from both your inventory and your vendor's end. It informs the merchant about the sales velocity, lead time, and safety stock.

Inventory Status

A comprehensive overview of product inventory, detailing the quantity available for products that are live, in draft, or have been archived.

Low Stock Product

The Low Stock Product Report highlights products that are approaching or have reached a low stock threshold, helping Shopify merchants proactively manage restocking needs. This report is crucial for preventing stockouts on popular items and ensuring seamless sales without interruption

Inventory Sell-Through

The percentage of stock that actually sold for every product and variant so you can separate the fast-movers worth reordering from the dead stock eating your shelf space and cash.

Inventory on Hand

A real-time snapshot of every product, variant, and SKU in stock - across every warehouse, retail location, and 3PL - with vendor, cost, and inventory value in a single view.

Inventory Sale Value

A report outlining the sale value of your inventory, including details on product quantities, variants, collections, and total value based on current sale prices for analysis.

Inventory Replenishment

A ready-to-action list of exactly which products need reordering now — driven by real sell-through velocity, adjusted for stock already on its way, and broken down by location.

ABC Analysis

Every product graded A, B, or C by its share of revenue — so you can pour stock investment into the items that earn it, and stop over-buying the ones that don’t.

Inventory Cost

The Inventory Cost Report provides a comprehensive analysis of the costs associated with your inventory, giving you a clear view of the financial investment tied up in stock. This report calculates the cost of inventory on hand and can include both current and historical cost data

Out of Stock Product

A report listing products that are out of stock, including essential details such as product inventory and the location where the stock was depleted.

Inventory level Indicator

The report provides Shopify merchants with a real-time analysis of stock levels, highlighting products that are overstocked, optimally stocked, or understocked. This report is essential for monitoring stock health and ensuring that inventory levels align with demand.

Inventory by Location

A report organized by inventory locations, detailing products and variants on hand, with a breakdown of the value for each product.

Inventory On Specific Day

A point-in-time snapshot of exactly what you had in stock on any past date — by product, variant, SKU, and location — for month-end accounting, audits, and cross-date comparison.

Inventory by Product Type

This is grouped inventory data organized by custom product types, alongside product and variant details, providing a comprehensive view to analyze overall inventory status.

Inventory by Collections

This report provides a detailed view of inventory levels, organized by product collections, allowing businesses to track stock availability and manage inventory efficiently.

Build and automate your Shopify Reporting

Unlock the full potential of your Shopify store with Report Pundit. Gain access to over 2000 data fields, automate reports, and make data-backed decisions to grow your business.