In this Article:
- Overview of the "Inventory - Monthly Reconciliation" Report
- How to use the Report
- Report FAQs
Overview
This report is currently available only to select merchants. For those with access to the “Inventory - Ecommerce Monthly Reconciliation” report, we’ve made the following improvements:
- Reserve Storage Reconciliation: Now includes reconciliation for units in Reserve Storage.
- Enhanced In-Transit Classification: In-transit units are now further classified into "Transfer In" and "Transfer Out" for better clarity. Any excessive "Transfer Out" quantity for a product will provide the actual in-transit units at the end of the month.
- Updated "Under Investigation" Units: Units marked as "Under Investigation" are constantly updated with correct categories from previous months once our internal investigations are completed. Please note, there will be no change in the starting or ending balances.
- New Category - Removed & Disposed Units: We’ve added a new category for removed and disposed units.
Please reach out to Support if you would like to request access or have any further questions.
How To Use The Reconciliation Report
For all products received in Flexport DTC Fulfillment & Reserve Storage facilities, this report provides start- and end-of-month total balances for monthly accounting reconciliation. It also provides high-level reasons for the monthly quantity change.
| Column | Definition |
| Start date | Report start date, displayed in UTC |
| End date | Report end date, displayed in UTC |
| DSKU | Identifier assigned by Flexport |
| SKU | Your unique identifier assigned to the product on Flexport portal |
| Service | Will shows balances in all sites for corresponding network:
|
| Starting balance | Balance (total inventory physically available in the network) on start date at 12:00AM UTC for fully received & available for sale units in the sites (excludes inbounding units) |
| Ending balance | Balance (total inventory physically available in the network) on end date at 12:00AM UTC for fully received & available for sale units in the sites (excludes inbounding units) |
| Monthly change in total quantity |
Quantity difference between start- and end-of-month total inventory in the network This can be further classified into and will the be sum of:
|
| Received at fulfillment centers | Net Units scanned and received at an DTC Fulfillment or Reserve Storage centers including Receipt Corrections (excludes units received at Cross Dock) |
| Shipped quantity | Net Units sold within the month and shipped out of the sites. Does not include pending orders at beginning/end of month |
| Return quantity | Returns received and added back into inventory. |
| Removed/Disposed Qty | Net units removed out of Flexport's network within the month (as requested by seller) |
| Transfer Out Qty |
Units shipped out of facilities for replenishments or consolidation transfers. Includes CD-DTC, DTC-DTC, RS-RS, RS-CD-DTC, RS-DTC* facility transfers. Does not include Inbounding units |
| Transfer In Qty |
Units received in the facilities for replenishments or consolidation transfers. Includes CD-DTC, DTC-DTC, RS-RS, RS-CD-DTC, RS-DTC* facility transfers. Does not include Inbounding units |
| Under investigation | Change in inventory quantities that cannot be explained by categories above. Refer to FAQs for more details |
*CD= Cross dock, DTC= Ecomm facilities, RS=Reserved Storage Facilities
FAQs
Why don’t the starting/ending balance or shipped quantities match with Legacy reports available on the portal?
Starting and ending balances will show total physical units on hand. We are not deducting units for processing orders, so the balances will vary compared to legacy reports. Shipped Units will be recorded only after orders are physically moved out of warehouses.
How do I arrive at total units in the network at the end of month?
Take Ending Balance for a DSKU for both service type and any In-Transit units derived as net of Transfer In Qty and Transfer out Qty (consider positive values only).
Why don't the Transfer In Qty and Transfer Out Qty match?
If Transfer In Qty is greater than Transfer Out Qty, then the Units transferred in previous month were received in the current month. Greater Transfer Out Qty means the units are still In-Transit (by the end of month)
Why is my inventory in “Under Investigation” and when will they be recovered/resolved?
Primary reasons for Under Investigation:
- Timing of the report: When the snapshots are generated, certain transactions could be partially reconciled showing them in this category. Please generate the report for next month (if available)
- Improper categorization: Sites could mark wrong reasons for certain transactions, e.g., receipt correction marked as LOST.
- Inventory Errors at sites: Occasionally, sites could mark units as lost, if they are unable to find them while picking orders. Large discrepancies are investigated by the site team on a daily basis.
- Inventory Adjustments: For operations like Kitting, we currently adjust inventory from one SKU and add them to another through Adjustment operations. They will show up in this category
We have operational processes in place to constantly monitor units in this category and will complete corrective actions within two months. Once the investigations are completed, the reports will automatically reflect the accurate categories once you regenerate them. Any unrecoverable units will be declared as LOST and shared in a different report. Please reach out to Support in case of urgent issues.
The report shows fewer units received than what I expect, how should I go about it?
Any non-compliance or inbounding units are not part of Received Qty. It shows units physically verified and added to the sellable/available inventory at site. Please check pending actions in Inbounds -> Problems, Inbounds - Shipping Plan Reconciliation Report in the Reports section on the Portal for more details.
If you need more help understanding your inventory report, please contact the Support team.