Blog Delivery Software

Daily LPG Cylinder Reconciliation: How to Match Stock, Returns and Cash

Daily LPG Cylinder Reconciliation: How to Match Stock, Returns and Cash

Daily LPG cylinder reconciliation answers one question: where did every cylinder and payment go today? On 15 November 2026, Dubai’s petroleum regulatory committee reported more than 19,252 counterfeit gas cylinders seized since June 2022. But inside your yard, the test is simpler. Can you prove which cylinders left, which came back, and what customers paid?

This guide shows how to reconcile filled cylinders, empties, and payments before the end of each day. It covers the records you need, six steps, a worked closing, and what to do when numbers differ. Then it shows where Tarsil fits.

The advice rests on desk research into published reports and regulator announcements, plus the Tarsil team’s workflow analysis. Still, the worked figures are calculations, not customer data.

What Is Daily LPG Cylinder Reconciliation?

Daily LPG cylinder reconciliation is the end-of-day check that filled stock, empties, and payments each match the day’s records.

Because each of the three must close on its own, a balanced filled count says nothing about empties or cash. So a finished delivery round is not the same as a reconciled one.

Why a Daily LPG Close Matters: Three Real-World Signals

Three recent reports show how quickly cylinder control can slip.

The same 15 November report also says that inspection campaigns found more than 275 sites storing or distributing counterfeit cylinders. So a gate check lets a distributor catch a foreign or counterfeit shell before it enters saleable stock.

But prices can move just as fast. Reuters reported that a 12 kg cylinder in Pakistan rose from PKR 4,500 to 7,000 within days. That followed border closures with Iran on 17 October 2026. So a daily close should check each invoice against that day’s approved rate.

Meanwhile, Kenya’s regulator EPRA issued new trader rules in February 2026. The Star reported that they require a record per cylinder sold: brand, serial number, net weight, price, and any deposit.

What Records Does LPG Cylinder Reconciliation Need?

Start with records your team already creates, since each one answers a different question.

Record What it proves Who owns it
Warehouse issue slip What left the yard, by cylinder size Store keeper
Vehicle loading sheet What the rider took Rider and supervisor
Delivery and collection record Filled deliveries and empties collected at each stop Rider
Warehouse receiving count What came back, filled and empty Store keeper
Invoices What was billed, and on what terms Accounts
Cash and digital receipts What customers actually paid Accounts
Sign-off Who accepted the close Supervisor

Keep quantities by cylinder size, because sizes never offset each other.

How to Reconcile LPG Cylinders From Loading to Delivery

LPG cylinder reconciliation flow showing yard opening count, filled cylinders delivered versus returned, and gate empty cylinder checks for daily stock accuracy.

Step 1: Verify Opening LPG Stock and Vehicle Loads

Count the yard against last night’s closing figure before the first truck leaves. Then log each loaded cylinder as a warehouse-to-vehicle transfer, because a sale entry would hide whatever comes back unsold.

Step 2: Match Filled LPG Delivered and Returned

Before closing, filled cylinders loaded must equal filled delivered plus filled returned. For example, 76 delivered and 24 returned account for 100 loaded. So any gap points to a missing stop record or a miscount.

Step 3: Compare LPG Empties Collected With Warehouse Receipts

Count every returning cylinder at the gate before the rider parks. Check seals, valves, and brand markings while counting. Afterwards, compare the rider’s collection records with the warehouse receiving count. Because exchange terms vary, a gap between delivered and collected is not automatically a shortage.

How to Complete LPG Cylinder Reconciliation at Day End

Step 4: Log Damaged, Missing and Disputed LPG Stock

Move damaged, foreign-branded, or doubtful cylinders into a separate quarantine count, since they must not enter saleable stock. Then record missing and disputed cylinders with a reason, so the difference stays visible. Never hide a gap by shifting numbers between sizes, because each size closes on its own.

Step 5: Verify LPG Cash, Credit and Digital Payments

Reconcile three money lines separately: cash handed over, verified digital receipts, and credit invoices. Because rates can change in days, check each invoice against that day’s approved rate. Also keep refundable deposits out of sales collections.

Step 6: Review Exceptions and Approve the LPG Closing

Before anyone signs, give every open exception an owner, evidence to collect, and a resolution date. Afterwards, the rider and supervisor both sign, and the note lists what stays open. A documented open exception is a valid close, but a forced zero hides the problem.

LPG Cylinder Reconciliation Example: A Complete Delivery Round

This worked example is the Tarsil team’s calculation, not customer data. It also assumes one cylinder size, one price, and no other stock movements.

Check Record Quantity
Filled Dispatched 100
Filled Delivered 76
Filled Returned unsold 24
Filled Unexplained difference 0
Empties Collected from customers 59
Empties Received at warehouse 57
Empties Open difference 2
Money 76 deliveries billed at 100 each 7,600
Money 26 credit deliveries 2,600
Money 50 paid deliveries 5,000
Money Cash handed over plus digital receipts 4,900 + 100
Money Unreconciled difference 0

The filled count closes, because 76 plus 24 equals 100. The money closes too, because cash and digital receipts cover all 50 paid deliveries. Still, the 26 credit deliveries stay as receivables.

But the day is still not closed, because two collected empties never reached the warehouse. Assign an owner, log the evidence, and record the outcome before you sign. Besides, 76 delivered against 59 collected is not automatically a 17-cylinder shortage. Exchange terms and earlier customer balances decide how many empties were due.

How to Investigate LPG Stock and Cash Differences

Investigate before you adjust. Recount the stock, check the handover times, then speak to the people involved.

Difference Likely causes Evidence to check Action
Empties collected exceed received Timing, miscount, unconfirmed handover Collection record, gate count, receipt Recount, then log owner and date
Filled cylinders unaccounted for Missing stop record, wrong size Loading sheet, delivery record Correct from the source records
Cash short or over Wrong rate, unrecorded credit, entry error Invoice, receipt, rate sheet Trace to the invoice
Cylinder still missing Verified loss Signed recount, rider statement Approve the adjustment with a named reviewer

Never edit an original record to force a balance, because that erases the evidence. Instead, add a dated correction with a reason. Four mistakes also make every difference harder to trace:

  • Treating loads as sales, because that hides what comes back unsold.
  • Counting bank receipts as physical cash, since the rider never handled them.
  • Mixing refundable deposits with revenue, because the money may go back.
  • Posting adjustments with no explanation, so nobody can review them.

Daily Closing for LPG Distributors in the UAE and GCC

Dubai’s Roads and Transport Authority reported 4,322 inspections of household gas distribution between 2023 and mid-2025. Those produced 1,098 violations and about 170 impounded vehicles. The RTA said its oversight aims to find counterfeit or untraceable cylinders. So daily records make each cylinder easier to trace.

Operations with several vehicles or branches should close each vehicle first, then combine totals. Rules differ across emirates and GCC countries, so confirm local requirements with your compliance adviser.

Manual vs. Digital LPG Day-End Closing

Paper sheets work for one yard and a few trucks. But beyond that, every extra vehicle adds another set of numbers to match by hand.

Area Manual closing Digital closing
Traceability Spread across sheets and notebooks Each entry links to a record
Shared data Warehouse and accounts see different copies One record for every team
Review steps Done at day’s end from memory Reviewed from logged entries
Audit history Overwritten or lost Can keep a name and time
Entry risk Retyped at each stage Entered once, if the team logs it

Still, digital records are only as good as the entries behind them.

Where Tarsil Fits Into LPG Cylinder Reconciliation

Tarsil brings customers, orders, deliveries, cylinders, deposits, billing, payments and collections into one system. Riders log delivered and collected quantities from the driver app at each stop. So the warehouse count has a recorded figure to check against. Its finance modules also include aging and credit reports, plus the main financial reports. Still, your supervisor reviews every exception and signs the close.

See How Tarsil Works → See how stock, returns and cash records fit together.

LPG Cylinder Reconciliation Checklist

Run this checklist at day end:

  • Before the first truck leaves, verify opening stock and each vehicle load by size.
  • Then match filled, delivered, and returned to filled loads.
  • Afterwards, compare empties collected with the warehouse receiving count.
  • While counting, quarantine damaged or doubtful cylinders and log disputes.
  • Finally, check cash, digital receipts, and credit invoices separately.
  • Since every gap needs an owner, add evidence and a date to each open exception.

Book Your Free Demo Today → See how this would work for your own LPG delivery business.

FAQs About LPG Cylinder Reconciliation

What is daily LPG cylinder reconciliation?

It is the end-of-day check that filled stock, empties, and payments each match the day’s records. Each one must close on its own.

How do LPG distributors reconcile filled and empty cylinders?

Match filled loaded to filled delivered plus returned. Then compare empties collected with the warehouse count, because the two checks are independent.

How do you calculate an LPG cylinder stock difference?

Subtract the received count from the recorded count for each size. For example, 59 collected minus 57 received leaves 2 to investigate.

What should a rider’s daily LPG settlement include?

Filled, delivered and returned, empties collected, cash handed over, digital receipts and credit invoices. Both the rider and supervisor sign afterwards.

How do LPG distributors reconcile cash and credit deliveries?

Split paid deliveries from credit ones. Then match cash and digital receipts to paid invoices, and keep credit invoices as receivables.

What happens when empty returns do not match warehouse records?

Recount first, then check handover times and collection records. Log an owner and evidence, but correct only verified quantities.

Try Tarsil

Run your routes and recoveries on one sheet

Deliveries and empties recorded together, signed at the doorstep, reconciled the same day. Used by 400+ distributors across 77 cities.

Start free signup Book Demo

14 days free · no card required

Scroll to Top