Skip to main content
GullySystem

Notes for owners · Industry-Specific Software Guides

How a Beverage Maker Sets Up a Returnable Crate, Bottle and Jar Ledger

Set up a returnable ledger with one row per customer and container type, and count every movement at the gate, out and back. Record the deposit held beside the count. GullySystem’s custom build for beverage manufacturers adds this ledger around the production and ordering software, which do not hold containers.

Ganesh HS, Strategy and Technology, GullySystem · · 2 min read

Why empties are the quiet loss

A beverage unit sells the drink and lends the container. Crates, returnable glass bottles and twenty-litre jars go out on vans, and they have to come back to the filling line.

They rarely come back in the same number. Some are broken, some are kept by a retailer, and some are counted wrong at the gate. A notebook of deposits cannot tell which.

Decide what counts as one container

Start with a list of container types. A crate, a bottle, a jar and a cap each need their own line, and a crate of twenty-four bottles is better counted as one crate plus its bottles.

Give each type a deposit value that your accountant agrees. Keep that value on the ledger, so a change in deposit does not rewrite old entries.

  • Crate by size and brand
  • Returnable bottle by size
  • Twenty-litre jar
  • Pallet or trolley, if you lend them
  • Deposit value for each type

Count out and back at the gate

Every van leaves with a loaded count and returns with an empty count. The gate clerk writes both against the vehicle, the route and the customer served.

Short returns are not written off on the spot. They stay on the customer’s balance until a person decides what happens. This keeps the argument with the retailer short and factual.

Tie the ledger to the bill

The deposit goes on the invoice as its own line, not inside the drink’s rate. When a customer returns containers, a credit goes against that line.

Your accountant decides how deposits are booked. The ledger only needs the count, the type and the value agreed for each customer.

  • Containers out, by invoice
  • Containers back, by gate entry
  • Balance held by the customer
  • Breakage written off, with a reason

Review it weekly

A weekly list of customers with the largest balance of unreturned containers is enough to start with. Sort it by how long the balance has stood.

Read it with the route salesman. He knows which outlet is holding crates for a slow season and which one has quietly stopped buying.

Returnable container sheet

Rule a page with one row per customer and one column per container type, split into out, back and balance. Add a deposit column and a last-return date. Fill it for a month, then sort by balance.

Open a blank worksheet to print

Questions owners ask

Does production software count crates and jars?

No. The production and ordering software hold material, batches, orders and invoices. A returnable ledger is a separate build, written around them during implementation.

Can the van driver scan crates?

Not on its own. Counts are keyed by the gate clerk or the driver on a phone. Barcodes or tags on crates are possible but scoped separately.

Who decides the deposit value?

You do, with your accountant. The ledger holds the value you set for each container type and keeps old entries unchanged when it changes.

Next step

Have a specific situation to work through?

This article covers the general case. Tell us what you’re actually dealing with and we’ll respond directly.

See software for beverage manufacturers