How do I reconcile consignment stock and sales?

Reconcile consignment by connecting the agreed ownership and selling terms to units delivered, units sold and returned, customer receipts, the retailer's compensation and money remitted. Use the same cutoff. A delivery to the retailer is not automatically a sale to its customer or a payment to the goods' owner.

The International Trade Administration's Trade Finance Guide describes an export consignment arrangement in which the exporter retains title until the distributor sells to the end customer. The domestic illustration below uses its own explicitly supplied terms; it does not prescribe legal ownership, accounting or tax treatment for other arrangements.

Write the terms beside the delivery

Consider a fictional maker placing fifty serving trays with a shop for one selling month. The agreed retail price is $40 each. The maker retains ownership until a customer sale. The shop keeps 25 percent of net customer sales after permitted returns and remits the remaining 75 percent at month-end.

Under these invented terms, customers may return trays during this selling month for a full refund; the shop reverses both parties' shares for those returns. No customer return rights continue beyond this model's ending. Unsold trays return to the maker, with no shop purchase obligation. There are no discounts, payment charges or other deductions.

The maker's complete paid manufacturing cost is $18 per tray, including all making labor. All fifty were made and paid for at the start. A $60 prepaid transport arrangement covers delivery to the shop and collection of unsold stock. No unpaid maker delivery or additional freight is assumed.

Reconcile the units before the payment

The shop sells eighteen trays and receives $720. Two customers then return one tray each and receive $40 refunds, totaling $80. The two returned trays are undamaged and rejoin the consigned stock.

Net customer sales are sixteen trays, or $640. Physical stock left with the shop is 34 trays: fifty delivered, less eighteen sold, plus two returned. Those 34 remain the maker's under the supplied arrangement and are collected at month-end.

The closing unit record is therefore fifty accounted for: sixteen net sales and 34 returned to the maker. A report showing eighteen sales and 32 remaining would miss both the refunds and the returned goods. A report deducting two trays from sales without putting them back into stock would leave the quantity unexplained.

Calculate the retailer and owner amounts

The shop's 25 percent share of $640 is $160. The maker's 75 percent share is $480. Together they equal the $640 net customer receipts.

Calculating commission on the original $720 would give $180 and ignore the agreed return reversals. The correct compensation uses the actual base in these terms, not whichever sales total appears first in the report. The payment-base guide examines that broader distinction.

The shop's complete incremental cost for this finite arrangement is $80: $60 paid merchandising and reconciliation work plus $20 in tools and display use. The $160 commission leaves $80 after those stated costs, before other central overhead, financing and income tax. The retailer's opening $200 is separately available to fund the $80 before any sale; other commitments are excluded.

After customer receipts, refunds, the $480 remittance and $80 of costs, shop cash ends at $280: $200 + $720 − $80 − $480 − $80. The $80 increase agrees with the limited operating comparison.

Follow the maker's money and unsold stock

The maker starts with $1,100 assigned solely to the arrangement. Manufacturing costs $900 for fifty trays, and prepaid freight costs $60, leaving $140 before any remittance. The $480 arrives only after the month-end records are matched, taking cash to $620.

That is $480 less cash than the maker began with. It is not a $480 loss: 34 trays remain, carrying $612 of the stated manufacturing cost. The sixteen net sales used $288 of manufacturing cost.

The maker's limited result is $132 before financing and income tax: $480 received, less $288 cost for trays sold and $60 freight. The same amount reconciles ending resources at cost: $620 cash plus $612 remaining stock, less $1,100 starting cash. The stock's cost is not a promise of resale proceeds.

The model includes all making and arrangement-specific work and payments; no other balances arise. A real maker still needs a complete business budget and a plan for selling or using the returned stock.

Close the record with the other party

At month-end, both parties compare the delivery list, individual sales, customer return records, closing count and agreed shares. They record the 34-unit collection and verify the $480 remittance actually arrived. An amount calculated as due is not yet an observed receipt.

If quantities or receipts differ, hold that specific item for investigation rather than forcing the total to balance. The transaction-evidence guide distinguishes records answering different questions. A physical movement does not alone establish its sale, and a matching total can still link the wrong events.

Before the next consignment, agree who can discount, how returns and damage are handled, how stock can be checked, what records accompany a remittance and when unsold goods come back. The maker's ownership alone does not establish that goods can be recovered promptly or without dispute.