Returnable Packaging: How to Make Crates, Trays and Kegs Reconcile

Crates, trays, kegs, dollies and cylinders move in the opposite direction to the goods they carry. Product leaves the depot and is sold. The packaging is expected to come back. If the returnable item is recorded only as a note on the delivery, the business has no reliable answer to a basic question: how many assets are currently held by each customer?

Returnable packaging tracking works better when every issue and return changes a ledger. The aim is not to count the depot once a quarter. It is to maintain custody as the packaging moves, so a missing float can be traced to a customer balance, a route event, a transfer or an authorised adjustment.

Treat returnables as a custody ledger

Treat the returnable item as an asset with a current holder. The depot owns the float. A customer may hold part of it after a delivery. A driver may hold part of it while the van is on the road. The important event is the handover.

That is why the useful unit of record is not “we sent 40 crates today”. It is “Customer A received 40 crates, returned 24, and therefore holds 16 more than before this visit.” Once the events are ledgered, the current balance can be rebuilt from the movements.

Define the movements before counting the float

A returnable ledger is only as clear as its event types. Keep the list short enough that drivers and depot staff use it consistently.

The distinction between a return and an adjustment matters. If a customer hands back ten trays, that is a return event. If the depot counts 498 trays when the ledger says 500, that is a variance that needs investigation before anyone posts a two-tray adjustment.

Work one deposit balance from issue to return

The numbers below are illustrative. Assume a bakery uses returnable trays and values the deposit at £5 per tray for the purpose of its customer agreement.

The useful part of the calculation is the movement, not the deposit rate. Even where a business does not invoice a deposit on every movement, the custody balance still tells operations what should be recoverable from the customer.

Keep packaging separate from equipment at site

A crate that circulates every day is not the same management problem as a branded fridge installed at a customer for three years. Both are assets outside the depot, but the evidence needed is different.

Use a deposit-style ledger for high-volume returnables whose main question is quantity held. Use an equipment register for individually placed assets where identity, installation, location, service history or condition matters. Mixing the two creates an awkward process: either every crate becomes an individual asset record, or every high-value fridge is reduced to a quantity.

Reconcile the float from three directions

Quantity tells operations what is missing. A sensible internal value helps finance understand the exposure. You do not need to turn the ledger into a full depreciation model; use the replacement cost, deposit value or another agreed internal basis that matches how the business manages the asset.

The same control principle appears in day-end stock and cash reconciliation: a variance is useful only when the movements behind it can be traced rather than guessed.

Suppose the total tray float is 6,000 units and the agreed internal value is £6 each. That is an illustrative £36,000 float. If a physical count is 240 trays below the ledger, the quantity variance represents £1,440 on that basis. The calculation does not prove where the trays went. It gives the investigation a scale and helps the business decide which returnable categories deserve tighter control.

Keep the rate visible beside the calculation so the number can be reproduced. If the value changes, update the model rather than leaving an old replacement cost embedded in a spreadsheet.

A customer ledger can be correct while the depot count is wrong, and a depot count can be correct while customer balances are incomplete. Reconciliation needs both views.

Start with the physical float: what is in the depot, what is on vehicles and what is known to be at customer sites. Then compare that with the ledgered custody. If the totals differ, work the variance through recent issues, returns, transfers and adjustments before changing the balance.

Run the same check by item type. A total float can reconcile while one crate size is short and another is over because the movements were posted against the wrong returnable code.

Recovery belongs on the normal route

The deposit ledger becomes useful when it produces a short recovery list. You do not need to call every account about crates. Look for balances that deserve attention.

This turns recovery into exception management. The team can contact the customer with a specific quantity and recent movement history rather than a general request to “send the empties back”.

Once the exception list is clear, use the normal customer visit to recover items where that is operationally appropriate. Give the driver the quantity the ledger says the customer holds and let the visit record what actually came back. If the customer disputes the balance, keep the disagreement visible rather than forcing the driver to post an adjustment at the door.

Where you also need signed or photographed collection evidence, keep that separate from the quantity ledger and use the ePOD collection record as the proof layer.

For returnable packaging tracking, that creates a clean handoff: the route captures the physical return; the office resolves commercial disputes and authorised corrections. Recovery then becomes part of the operating rhythm instead of a once-a-year crate chase.

Close the balance when the customer closes

An account can stop ordering while still holding packaging. Build a returnables check into the customer-close process: confirm the deposit balance, agree the recovery plan and record any authorised loss or settlement. Otherwise inactive accounts become a quiet accumulation of small asset balances that nobody owns.

The same check is useful before a customer changes site. Recover or explicitly transfer the balance to the new delivery point rather than assuming the crates will follow the commercial account automatically.

Deposit Items keep the movement on one ledger

RouteMagic supports Deposit Items for returnable packaging such as crates, trays and kegs. The live inventory-management workflow describes these items on a per-customer deposit ledger, with drivers able to count returnables at customer visits. The Driver App also supports deposit items, returns and collections as part of the site-visit workflow.

RouteMagic keeps Equipment as a separate customer-management concept for individually placed assets such as coolers, dispensers, cylinders and branded fridges, with installation and service history. That boundary is useful when one operation has both a high-volume crate float and a smaller set of named assets at customer sites.

For a demo, use one customer with a known opening balance. Issue returnables, collect a different quantity and confirm the closing customer balance. The test should prove the ledger movement, not just show a list of deposit-item products.

Conclusion

Returnable packaging becomes difficult when the business treats it as background to the product delivery. The crate, tray or keg still has a holder after the goods are sold, so the system needs to record that custody change. Define a small set of movements, post issues and returns against the customer, investigate adjustments rather than using them as a shortcut and keep high-value equipment on a separate asset process. Then review exceptions: balances that keep growing, closed accounts that still hold items and routes whose physical counts do not reconcile with the ledger. The first practical exercise is simple. Pick one returnable item and one route, establish the opening float, record every issue and return for a week, and compare the closing physical count with the customer balances. If the two views agree, the process is becoming controllable. If they do not, the missing movement tells you where to improve the capture.