Catch weight inventory: reconcile cartons, actual weight, and purchase cost

A shipment of 80 cartons can be complete even when its measured weight differs from the purchase order. A carton count and a weight answer different questions. The count shows how many packages moved; the weight supports a price or consumption calculation when the commercial agreement charges by weight. A useful catch weight reconciliation carries both quantities from receipt to sale instead of forcing one to match a fixed conversion.

Begin with the purchase order, supplier packing record, receiving weight, invoice, warehouse movements, and dispatch weights. Use the same product, lot, location, and transaction reference across those records. When identifiers differ, record the mapping explicitly. Matching only a date and approximate total can combine two deliveries and leave a plausible but unsupported balance.

The immediate output is a quantity bridge with an explanation for each difference. Accounting can then value the movements under the company's approved cost policy. Trying to solve the problem with a dollar adjustment first can conceal a missing carton, an inaccurate scale reading, or an invoice prepared using estimated weight.

A nominal conversion helps people plan storage, ordering, or transport. It does not prove the weight of a particular receipt. Keep nominal kilograms per carton in a planning field and measured kilograms in transaction records. If staff enter an estimated weight because the receiving scale is unavailable, flag it as estimated and assign a person to replace it with a supported measurement.

Microsoft's catch weight documentation describes separate package and inventory units, nominal conversions, and weight capture at different warehouse stages. Those settings explain why two reports from the same system can use different weight bases. Before investigating a financial variance, ask which basis each report used and whether its quantity came from measurement, an average, or a default.

Keep the original values when correcting an entry. The correction should show the mistaken unit, replacement quantity, supporting document, and approval. Overwriting a historical conversion globally may change old reports even though the earlier transactions were correct. Test the proposed correction on one affected receipt and its downstream sale before applying it across a product history.

Use opening cartons plus cartons received, less cartons dispatched and approved disposals, to calculate expected closing cartons. Add returns and transfers using their actual direction. Transfers between your own locations should leave total company cartons unchanged, even though each location changes. A transfer still in transit needs a visible location or separate status so both warehouses do not count it as theirs.

Suppose an illustrative lot opens with 40 cartons, receives 80, ships 95, and has 2 damaged cartons removed. Expected closing quantity is 23 cartons. A count of 22 leaves a one-carton difference that should be investigated separately from weight variation. Recording a weight loss will not explain where the carton went.

Check picking reversals, returns placed in quarantine, partial carton handling, and transfers posted on opposite dates. A product counted as a full carton after some contents were issued may explain an apparent quantity problem. If the operation uses opened cartons, define how staff identify and count them without inventing a fractional carton convention after the count has finished.

For the same illustrative lot, assume opening measured weight was 400 kilograms and receipts added 790. Dispatches totaled 935 kilograms, while damaged goods accounted for 18. Expected remaining weight is 237 kilograms. If a supported count finds 234 kilograms, the weight bridge has a three-kilogram difference. The carton and weight bridges must be reviewed together because they describe the same physical stock.

Investigate the measurement method before classifying that difference. Were scales calibrated for the required use? Did one record include packaging weight while another excluded it? Were kilograms and pounds mixed? Was a pallet weight allocated across cartons using an average that later became an apparent gain or loss? These questions often identify which record needs correction without assuming every difference is natural product loss.

Do not net unrelated lots merely because their gains and losses offset. An overstated receipt in one lot and an understated dispatch in another can produce a correct warehouse total while distorting product margins and customer billing. Preserve the lot detail, then show the warehouse total as an aggregation of reconciled movements.

Check the contractual pricing unit before recalculating an invoice. A supplier may charge per kilogram, per carton, or through a combination of product and handling charges. The finance reviewer needs the price agreement and actual billable quantity, not a guess based on how the warehouse counts stock.

In an illustrative purchase, 790 kilograms at $6.20 per kilogram produces product cost of $4,898. An invoice based on the nominal 800 kilograms would show $4,960, a $62 difference. If the agreement calls for actual measured weight, compare the supplier's measurement evidence with your receiving record and request a specific correction. If the agreement prices cartons, the same weight difference may not create an invoice claim.

Keep freight, packaging deposits, and other charges separate during the comparison. A total invoice difference can disappear when an omitted freight charge is added, but that does not validate an incorrect product quantity. Resolve each component on its own evidence and give the accounting reviewer the approved allocation of accepted costs.

Assign distinct outcomes to a missing package, a measurement correction, accepted physical weight change, and a supplier pricing dispute. Each outcome produces a different operational response. The warehouse may need a transfer correction, purchasing may need a credit, and accounting may need an adjustment under the applicable inventory policy. One generic adjustment reason provides little help when the same issue recurs next month.

Retain the quantity bridges with their source reports, measurement basis, invoice calculation, and approvals. IRS recordkeeping guidance explains that purchases can require several supporting documents to establish their details. The warehouse schedule is useful operational support, while the original purchasing and payment evidence should remain accessible.

For the next close, review exceptions by cause and age. A recurring estimate that is never replaced needs a receiving-process fix. A supplier dispute needs an owner and the amount still outstanding. A resolved difference should identify the correction reference and the reports it changed, so a later reviewer can reproduce the final carton, weight, and cost balances.