Tracking returnable containers and gas cylinders

A returnable is any container you lend rather than sell. A twenty litre water bottle, a beer crate, a keg, a gas cylinder, a pallet. You paid for it once and you expect to use it many times, which only works if it comes home.

The trouble is that losing them does not feel like losing money. No single delivery looks like a problem. Most businesses find out the same way. Someone counts the yard, compares it to what was bought over the years, and the gap is bigger than anyone expected. Nobody stole a hundred containers in one night. They left one at a time, each with a good reason, and nothing brought them back.

Count containers, not just stock

Most stock systems answer one question. How many do I have. That is enough when you sell a thing and it goes away. A returnable needs a second question answered at the same time, which is how many are out and with whom.

Those two numbers behave differently. Stock in the yard falls when you sell. Containers out rises when you sell and falls only when someone brings something back. A business can look healthy on stock and be quietly bleeding containers.

Give each one an identity

For high value containers like kegs and cylinders, number them individually. Stamp, engrave or tag each one, then keep that number for the life of the container. You will want to know which one, not just how many, when you are chasing a specific customer or checking a return.

For cheaper, high volume items like water bottles or crates, counting by quantity per customer is usually enough. The point is not to be exhaustive, it is to know the balance for each customer at any moment.

This is the change that makes everything after it possible. It is also the part people skip, because on the day you do it you have two hundred containers and no problem you can see yet.

Record three moments, not everything

You do not need a full history of every movement to get control. You need three:

• It goes out. Which container, which customer, what date, what deposit was taken.
• It comes back. Which container, what date, and whether the deposit was refunded or carried to the next order.
• It is late. Anything that has been out longer than your normal cycle, so you can chase it while the customer still remembers.

Everything useful comes from those three. How many are out right now. Who has held one the longest. How much deposit money you are sitting on. Which customers always return and which never do.

Hold a deposit and tie it to the container

A deposit is the only thing that reliably makes a container come back. It turns your problem into the customer’s problem, which is where it belongs, because they are the one holding it.

The common mistake is recording deposits as money and containers as items, in two different places. Then a customer returns two cylinders, claims a deposit on three, and nobody can prove otherwise. Your staff then stop asking for deposits to avoid the fight. When the deposit is attached to the specific container number, the refund is arithmetic rather than an argument.

It also tells you something most businesses never see. The total deposit you are holding is money that belongs to your customers, not to you. Knowing that figure changes how you think about your cash position.

Gas cylinders and LPG

Cylinders are the hardest version of this problem, because each one is worth enough that losing a few matters and there are usually enough of them that nobody can hold the count in their head. If you fill and deliver LPG, a large part of your money is not in the bank. It is standing in customers’ yards.

Number every cylinder. A cylinder without its own number cannot be traced. It becomes one of many, and the moment it is out of the yard you have no way to say which one it was or who took it. Set the deposit near the replacement cost, so returning it is worth more to the customer than keeping it, and record that deposit against the cylinder number rather than against the customer as a lump.

Then set a normal cycle, whatever matches how your customers actually use gas, and treat anything beyond it as needing a call.

Watch the age, and chase early

Knowing that four hundred crates are out tells you very little. Knowing that eleven of them have been out for over two months tells you exactly who to call this morning.

A container that is two weeks late usually comes back with a phone call. One that is six months late usually does not come back at all. The value of tracking is not the report at the end of the year, it is the nudge in week three while the customer still knows where it is. A short list you act on beats a long list you read.

Make it survive your staff

The system that works is the one the person at the gate will actually use while a truck is waiting. If recording a return takes longer than waving the truck through, it will not be recorded, and a record with holes in it is worse than no record because you will trust it.

It also needs to work when the person who set it up is not there. A book in someone’s handwriting, or a spreadsheet on one laptop, is a business that stops knowing where its containers are the week that person travels.

What about a book or a spreadsheet

Both work, up to a point, and plenty of good businesses run on them. A book fails when you need to answer a question quickly, because the answer is spread across pages and only one person can read it at a time. A spreadsheet fails when more than one person needs to update it, or when it is on a laptop at one branch and the container went out from another.

The honest test is this. If someone asked you right now how many containers are out and who has held one longest, could you answer in under a minute? If yes, what you have is working. If no, that gap is costing you containers you have already paid for.

Common questions