NOTE: This report is currently only available to select merchants, but will be launching to all merchants soon. Please reach out to us if you would like to request access or have any further questions.
Description
Provides start- and end-of-month on hand balances for all in-Network ecommerce products for monthly accounting reconciliation. Also provides high-level reasons for the monthly quantity change.
Documentation
| Column | Definition |
|---|---|
| DSKU | Identifier assigned by Flexport. |
| End date | Report end date, displayed in UTC. |
| Ending balance | Balance on end date at 11:59 PM UTC |
| In transit | Number of products in transit (e.g. on a truck or plan) at the end of the month. Transfers can be either from one fulfillment center to another or from reserve storage to a fulfillment center for just-in-time replenishment. If quantity is zero, all in-transit products have reached their destination at the time the report was generated. |
| Monthly change in total quantity | Quantity difference between start- and end-of-month on hand inventory. |
| Received at fulfillment centers | Number of products scanned and received at an ecommerce fulfillment center; includes inbounded inventory and internal transfers received. |
| Returns quantity | Buyer return that is received back into inventory. |
| Shipped quantity | Number of products that leave the warehouse; includes buyer order shipments, inventory disposals, inventory sent back, and internal transfers sent. |
| SKU | Identifier you assigned your product. |
| Start date | Report start date, displayed in UTC. |
| Starting balance | Balance on start date at 11:59 UTC. |
| Under investigation | Changes in inventory quantities that we are still investigating. |