Inventory
- Home
- Inventory
Sync from Extensiv
Sync from Monta API (EU)
Pulls live EU stock from the Monta API. Credentials must be saved in Settings.
Upload — Rocket Shippers
Upload a Rocket Shippers inventory grid export (NV or PA). Warehouse is auto-detected from FacilityName.
Upload — Monta (EU)
Upload a Monta inventory snapshot export. Warehouse is auto-detected from the file (Krefeld → EU-MONTA-DE, Rushden → EU-MONTA-UK).
Upload — Amazon FBA
Upload an Amazon FBA inventory report (Manage Inventory Health or FBA Inventory report).
Physical Inventory by SKU
Source: wh_qty_on_hand — updated on every Extensiv / Monta sync
Loading...
Opening Inventory Balance
Enter the beginning inventory value from your bookkeeper (e.g. $788,420.03 as of Dec 31, 2025).
Accounting Inventory by SKU
Source: qty_remaining — decremented only by sales imports & FIFO engine
Loading...
All Lots
Loading...
Lots Needing Cost Assignment
These lots have been imported but not yet linked to a PO. Link them to assign cost.
Loading...
Auto-Link POs to Lots
Automatically propose PO assignments for all lots using invoice quantities and receipt dates. Select your most recent (anchor) PO — the engine will work backwards through older POs.
Proposed Lot → PO Assignments
Review the proposals below. HIGH confidence = receipt date within ±7 days of expected arrival (invoice date + 21 days). You can override individual assignments before confirming.
Loading...
Physical vs. Accounting Variance
Aligned = Physical equals Accounting | Gap = Physical > Accounting (unimported sales) | Error = Accounting > Physical (data problem)
Loading...
Sync & Import History
Every sync run and file import, most-recent first
Loading...
Lot Audit Snapshots
Daily snapshot of every active lot taken after each sync. Shows what the system recorded on that date.
| ← Accounting Units | ← Physical / WH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| SKU | Warehouse | Lot Code | Status | Received | Accounting Units | Accounting Depleted | Physical (WH) | Variance | % Depleted | Synced At |
| Select a date to load audit data. | ||||||||||
Period Bridge
Accounting inventory walk from one period close to the next. Accounting units are authoritative — physical is the check.
Select a period and click Run.