Reconcile packaging at your factories
A factory that completes 380 units should have used 380 pouches. The Factory Packaging Reconciliation report checks that for every contractor site and component over a date range: it starts from what the site held, adds what you sent, takes off what the completed units should have used, and compares the result with what SKU.io holds there now. A difference beyond the recipe's expected scrap is flagged, so you know which factory to ask about.
Before you begin
- You need access to the Factory Packaging Reconciliation report, under Report Access in your role (
report_access.factory-packaging-reconciliation). Admins and Full Access have it. - The factory has to be an activated contractor with a site warehouse, and you receive its finished goods on outsourced manufacturing orders. See Manufacture with a contract manufacturer.
Steps
- Go to Insights → Reports and open Factory Packaging Reconciliation. You can also click Reconciliation on Manufacturing → Contractors → Packaging at factories.
- Set From and To. The report opens on the last 90 days.
- To check one factory, pick it in Site.
- Read the cards at the top: Units completed, Received at sites, Consumed by completed units, and Flagged variances.
- To list only the rows that need a look, turn on Flagged only.
- Hover a Variance to read what explains it.
- To see the records behind a row, expand it.
- To download the report, click Export. You get a CSV file for the range and site you picked.
Reset puts the dates and site back to their defaults.
How each row adds up
Each row is one component at one site.
| Column | What it shows |
|---|---|
| Opening | On hand at the site at the start of the range. |
| Received | Purchase order receipts and transfers into the site. |
| Consumed by completed units | The recipe quantity times the units received on outsourced orders at this site, with the unit count underneath. This is what the completed units should have used, before expected scrap. |
| Scrap & adjustments | Recorded manufacturing scrap and manual adjustments at the site. |
| Transfers out & other | Transfers out of the site and any other movement, such as a return to the supplier. |
| Expected closing | Opening plus Received, minus Consumed by completed units, and plus or minus the two columns before it. |
| On hand at close | What SKU.io holds at the site at the end of the range. |
| Variance | On hand at close minus Expected closing. |
A variance is flagged when it's at least one whole unit and larger than the recipe's expected scrap for the units completed. A shortfall shows red and a surplus amber.
For example, a recipe uses 1 pouch per unit with 1% expected scrap, and the factory completes 380 units. The completed units should use 380 pouches, and up to 3.8 more is allowed as scrap. If the factory recorded 385 pouches, the variance is −5, which is beyond the allowance, so the row is flagged.
The hover text on a variance names its two possible causes:
- More or less consumed at receipt than the recipe expects. When you receive finished goods, you can override what the contractor consumed. An overrun shows here.
- Stock counts at the site. A stock take at the contractor's site that corrected the count.
If a row's component has a warning icon, or a Unit check column appears, a recipe line uses a unit the component has no conversion for. Its expected consumption is unconverted, so the variance may be wrong. Add the conversion on the product's Units tab.
What the drill-down shows
Expanding a row shows two lists for that site and component over the range:
- Production received: each receipt of finished goods, with the manufacturing order, its purchase order, the date, the Units, what the recipe expects (BOM expects), what was Recorded, and the Difference. The order and date link to the order and the production record.
- Receipts, transfers & adjustments: each movement in or out, with its Date, What it was (Received, Consumed, Scrap & adjustments, Stock count, or Transfer out / other), a link to its Source, and the Quantity. When a row has many movements, the list shows the first ones and links to Inventory Movements for the rest.
Next steps
- Track packaging at your factories to see what each site holds now and get an alert before it runs short.
- Manufacture with a contract manufacturer to override what a contractor consumed when you receive finished goods.
- Reports catalog for the other inventory reports.