Reconciling weighbridge tickets, delivery tickets and invoices at a quarry

Every load that leaves a quarry exists four times: as an order line, a weighbridge ticket, a signed delivery ticket and an invoice line. Reconciling them means proving, for each load, that the four describe the same truck, the same material and the same tonnes, and holding the ones that do not until someone with the right to decide has decided. This guide gives the identity of a load, the rules for tare and units, how to find missing and duplicate tickets, who may correct what, and a worked day of ten loads with every anomaly resolved.

Published
Sources checked
Reading time
17 min
Written by
Mirage Metrics team

Scope: aggregates, sand and stone sold by weight from a quarry weighbridge, with owned and subcontracted trucks. It covers the method and the controls, not the choice of weighbridge hardware or software. The legal points are jurisdiction-labelled and limited to what the cited texts say.

Decision snapshot

Best suited to
Quarry managers, weighbridge and dispatch leads, finance and credit control, and whoever owns the weighbridge software and the ERP at a site that bills customers by the tonne.
Inputs needed
The day's weighbridge tickets with tare source and timestamps, the delivery tickets as signed, the open orders, the vehicle and haulier lists with stored tares, the draft invoice lines, and the exit camera or gate log if there is one.
What can be automated
Matching tickets to orders, delivery tickets and invoice lines; sequence and duplicate checks; flagging stored tares against weighed ones; building invoice lines from tickets; comparing customer weights with tickets; routing each anomaly with its evidence.
What requires human approval
Voiding a ticket after departure, accepting a return, correcting a billed quantity, deciding a load with no ticket, accepting a variance with a customer, and changing tolerances or stored tares.
When this approach is insufficient
When trucks regularly leave without being weighed, or tickets are written by hand: fix the gate first. Also when the contract does not say which weight governs: no reconciliation can settle a dispute the contract leaves open.

What identifies one load across systems

A load has no single identifier that every system shares. The order lives in the ERP or the dispatch tool, the ticket in the weighbridge software, the delivery ticket on paper or in a driver app, the invoice line in billing. Reconciliation starts by deciding which fields carry the identity from one to the next, and by making the ticket number the spine: every other record should point to it.

The fields that identify a load, where each is created, what it is for, and how it goes wrong
FieldCreated inWhat it is forHow it goes wrong
Order numberSales or order desk, in the ERP or dispatch toolSays what was sold: customer, product, site, price basisTruck loaded against the wrong order, or against none
Vehicle registration and fleet numberVehicle master; read at the gate by a camera or typed by the operatorLinks the weighings of one truck and its stored tarePlate typed wrong, trailer swapped, unknown haulier truck
Haulier and driverHaulier list, driver card or the operator's entryWho carried the load, who signed, who gets paidSubcontracted truck recorded as the quarry's own
Ticket numberWeighbridge software, one per weighing transactionThe spine of the reconciliation: every other record should point to itReprints issued under a new number; voids without a reason
First and second weighing timestampsWeighbridge indicator or its softwareOrder the events; show whether the tare was weighed todayClock drift between the weighbridge PC and the ERP
Product or gradeOrder, then the loader's or operator's selectionPrices the line and moves the stock0/20 loaded on a 0/31.5 order; product changed on the ticket afterwards
Loading point and destinationDispatch, loader terminal, delivery site on the orderProves where the material came from and wentDelivered to the wrong site of the same customer
Delivery ticket numberPrinted with the weighbridge ticket, or written by handWhat the customer signs; what the customer's accounts payable will compareA handwritten note with no ticket behind it
Invoice line referenceBilling, in the ERPCloses the chain: which tickets each line billsA line with a quantity and no ticket numbers
The fields that identify a load, where each is created, what it is for, and how it goes wrong

When a record carries no ticket number (a handwritten delivery ticket, an invoice line keyed from the order), match it on a composite key instead: vehicle, order, product and a time window. A composite match is a proposal for a person to confirm, never a silent link.

Orders, vehicles, weighings, deliveries: four records, one chain

The four records have different lifetimes. An order spans many loads; a vehicle spans many weighings; a ticket describes one load; a delivery confirms one ticket. Getting these cardinalities right is most of the work: a model that assumes one order per truck per day breaks on the first customer who orders 300 tonnes.

The records behind a quarry load, how many of each, what links them and what each must hold
RecordOne perLinks toMust hold
OrderOne per customer purchase, often several days or weeks of loadsMany loadsCustomer, product, site, ordered quantity, price basis, unit of sale
VehicleOne per truck or trailer combinationMany weighingsRegistration, haulier, stored tare and the date it was taken, maximum gross
Weighing (ticket)One per load leaving or arrivingOne load; a return gets its own ticketTicket number, gross, tare and its source, net, times, product, order, vehicle
DeliveryOne per load deliveredOne ticketDelivery ticket number, signature, time, site, any quantity the customer records
Invoice linePer load or per period, per orderOne or many ticketsTicket numbers billed, quantity, unit, price
The records behind a quarry load, how many of each, what links them and what each must hold
  • A load is one ticket. One truck, one departure, one weighed net. A truck and trailer weighed together are one load; uncoupled and weighed separately, they are two weighings summed into one load, and the ticket should say so.
  • A return is a new ticket. It refers to the original ticket and never overwrites it.
  • An invoice line names its tickets. Whether it bills one load or a day of loads, the list of ticket numbers is what makes it checkable.

Tare, gross, net and units

The weights on a weighbridge ticket and how far each can be trusted
WeightWhat it isNote
GrossVehicle and load on the deck, weighedAlways weighed on the day
Tare, weighedEmpty vehicle on the deck, weighed on the same visit or the same dayThe strongest basis for a net
Tare, stored (preset)A value saved in the weighbridge software from an earlier weighing and reusedSaves a weighing; wrong as soon as the truck changes (trailer, crane, fuel, mud, body)
NetGross minus tareThe quantity sold, in tonnes, unless the contract says otherwise
The weights on a weighbridge ticket and how far each can be trusted

Stored tare against weighed tare

A stored tare saves the truck a second trip over the deck, which is why most sites use them for regular hauliers. It is also the most common source of a wrong net that nobody sees: the haulier fits a different trailer, adds a crane, or the body carries a few hundred kilos of wet fines, and every load is billed on yesterday's truck. Four rules keep it under control:

  • Every stored tare carries the date it was weighed and who saved it, and expires after a period you set.
  • The ticket shows whether the tare was weighed or stored. OIML R 76-1 asks for a preset tare to be printed with the net calculated from it, marked PT.
  • Each time a truck with a stored tare is weighed empty, compare the two; above a threshold you set, the stored value is replaced and the loads billed since it was last confirmed are reviewed.
  • A stored tare is never edited to make a net look right. It is replaced by a weighing, with the old value kept in the log.

Units

Quarries sell by the tonne because the weighbridge weighs in kilograms or tonnes. Bill in the unit of the ticket. Convert to cubic metres only when the contract specifies it, and then only with the density the contract names for that product; the density is a commercial term, not a physical constant of "sand". With an invented contract density of 1.6 t/m³ for 0/4 sand, a 27.20 t load is billed as 27.20 ÷ 1.6 = 17.00 m³, and the ticket still says 27.20 t. Round once, at the invoice line, to the precision the contract states, and keep the scale interval of the instrument in mind: a weighbridge that reads in 20 kg steps cannot settle a 10 kg dispute.

Missing and duplicate tickets

Missing and duplicate tickets are found by counting, not by reading. Each check below compares two lists that should have the same members; the anomaly is whatever appears on one list and not the other.

Checks that find missing and duplicate tickets, how each shows up, and who acts
CheckHow it shows upWho acts
Gap in the ticket sequenceTicket numbers are consecutive; a missing number is listedWeighbridge operator explains it; a void without a reason goes to the quarry manager
Ticket without a delivery ticketThe ticket exists, no delivery ticket or signature came backDispatch chases the driver or the haulier; the load is not invoiced until the delivery is confirmed, if your contract requires a signature
Delivery ticket without a ticketA signed delivery ticket matches no ticketHeld: no weighed quantity exists; finance and the quarry manager decide on the basis the contract allows
Exit without a ticketThe exit camera, the barrier log or GPS shows a loaded truck leaving with no ticketHeld, same as above; the weighbridge outage or bypass is logged
Duplicate ticketSame vehicle, same order, same gross within a few scale intervals, a few minutes apart, no tare weighing in betweenWeighbridge operator voids one with a reason; the void is reviewed
ReprintSame ticket number printed twiceNo action on quantities; the reprint is logged so billing never counts it twice
Checks that find missing and duplicate tickets, how each shows up, and who acts

The sequence check has a blind spot worth knowing: a truck that leaves during a weighbridge outage leaves no gap, because no ticket was ever issued. Only an independent record of the exit (a camera, a barrier log, GPS, the loader's count) finds it.

Returns, cancellations and corrections

Three different events, often recorded the same way, which is how billing ends up crediting the wrong load. Keep them apart:

  • Cancellation (void): the ticket should not exist. A load aborted at the deck, a ticket on the wrong order caught before departure, a duplicate. The ticket is kept, marked void, with a reason.
  • Return: the material came back. Refused on site, wrong grade, contaminated. The truck is weighed in, a return ticket refers to the original, and the material goes back to a stockpile you name.
  • Correction: the weighing happened, but the quantity to bill is different. A stored tare found wrong, a load split between two orders. The ticket is unchanged; a correction record carries the new billed quantity.
Who may void, return or correct, and what the audit trail must hold (adapt the roles to your own delegation)
ActionWho may do itWhat the audit trail holds
Void a ticket before the truck leaves (wrong order, wrong product, aborted load)Weighbridge operatorReason from a fixed list; original kept, marked void
Void a ticket after the truck has leftQuarry managerReason, evidence (camera frame, driver statement), linked replacement ticket if any
Issue a return ticketWeighbridge operatorReference to the original ticket; return reason; who accepted the return
Correct a quantity for billing (for example, a stored tare found wrong)Quarry manager, with finance informedOriginal ticket unchanged; correction record with old value, new value, basis and approver; customer informed
Accept a variance with a customerFinance or sales, per your delegationThe variance, the evidence on both sides, the decision and the credit note or invoice it produced
Change stored tares, product lists, tolerance rulesSystems owner, on request from operationsChange log: old and new value, date, requester
Who may void, return or correct, and what the audit trail must hold (adapt the roles to your own delegation)

Quantity variances and tolerances

A variance is a difference between two quantities that should describe the same thing. Name each comparison, because each has different causes and a different owner.

The four quantity comparisons in a quarry reconciliation, what to expect and the usual causes of a difference
ComparisonWhat to expectUsual causes of a difference
Ticket against delivery ticketShould be identical when the delivery ticket is printed from the ticketA handwritten delivery ticket, a product changed after printing, a ticket reissued
Ticket against the customer's receiving weightTwo instruments, two times, sometimes rain or spillage in betweenInstrument accuracy, verification status of either scale, losses on the road, a stored tare
Delivered against invoicedShould be identical when invoice lines are built from ticketsQuantities keyed from the order, a duplicate billed, a return not credited
Ordered against deliveredNormal to differ load by load; the order closes on the totalTruckloads rounded to a nominal tonnage, an order over-delivered
The four quantity comparisons in a quarry reconciliation, what to expect and the usual causes of a difference

There is no universal tolerance. The threshold between "accept" and "investigate" comes from the contract or, where it is silent, from your own written policy, and it may differ by product and by customer. Write down three things per customer: which weight governs (yours, theirs, or a rule for disagreements), the threshold above which a variance is investigated, and the period within which the customer can raise one. Without those, every variance is a negotiation.

Linking the loads to invoicing

The invoice is the last record in the chain and the one most often built from the wrong source. Build every invoice line from reconciled tickets, never from the ordered quantity and never by retyping the delivery ticket.

  • A load reaches billing only once it is matched, or once its anomaly has a decision.
  • Each line lists its ticket numbers, so a customer's accounts payable team can check it against the delivery tickets they hold.
  • Held loads stay out of the invoice run and appear in a held list with their reason, so nobody forgets them at period end.
  • Haulier payments for subcontracted trucks come from the same reconciled loads, so the quarry pays for what it billed and the haulier's own count is a cross-check, not the source.
  • Period cut-off is by weighing time on the ticket, stated once, so a load weighed at 23:50 on the last day falls in one period only.

The same three-way logic, order against delivery against invoice, is what a shipper uses to audit carrier invoices; here the quarry is the one issuing the invoice, so the check runs before it goes out.

Worked example: one day, ten loads

Illustrative example, invented figures: one working day at a quarry, three customers, four trucks

Assumptions, all invented. Three open orders: O-501 for customer A (0/20 gravel), O-502 for customer B (20/40 aggregate), O-503 for customer C (0/4 sand). Trucks V-101 (the quarry's own), V-205 and V-412 (haulier H1), V-310 (haulier H2). The weighbridge prints the delivery ticket with the ticket. An exit camera reads plates. The weighbridge was offline from 13:30 to 13:50. Weights in tonnes. Customer B's contract says the quarry's ticket governs and that a difference above 1% with the customer's own weighing is investigated: an invented term for this example, not a norm. The billing system drafted the invoice lines from the ticket export and the delivery tickets before anyone reconciled them.

The day's weighings as the weighbridge recorded them, in tonnes (invented)
LoadTicketTimeVehicleOrder and productTareGrossNet
L1T-204107:05V-101 (own)O-501, 0/2014.20 weighed42.6028.40
L2T-204207:20V-205 (haulier H1)O-502, 20/4013.86 weighed41.9628.10
L3T-204307:40V-412 (haulier H1)O-502, 20/4014.06 weighed42.3628.30
L4T-204408:10V-310 (haulier H2)O-503, 0/412.94 weighed40.1427.20
L4T-204508:13V-310 (haulier H2)O-503, 0/412.94 weighed40.1427.20
L5T-204608:50V-101 (own)O-501, 0/2014.22 weighed43.0828.86
L7T-204710:30V-310 (haulier H2)O-503, 0/412.96 weighed40.4027.44
L8T-204811:05V-101 (own)O-501, 0/2014.20 weighed42.8628.66
L7 returnR-001212:15V-310 (haulier H2)O-503, 0/4, returned12.96 weighed40.3827.42
L6none13:41V-205 (haulier H1)O-502, 20/40nonenonenone
L9T-204914:20V-412 (haulier H1)O-502, 20/4013.10 stored (PT)42.2829.18
L10T-205015:30V-205 (haulier H1)O-502, 20/4013.88 weighed41.9428.06
The day's weighings as the weighbridge recorded them, in tonnes (invented)
Reconciliation of each load: ticket, delivery ticket, draft invoice line, quantity to bill, status (invented)
LoadTicketDelivery ticketDraft invoiceTo billStatus
L1T-204128.40, signedA: 28.4028.40Matched
L2T-204228.10, signedB: 28.1028.10Matched
L3T-204328.30, signedB: 28.3028.30Matched
L4T-2044 and T-204527.20, signed (one note carried)C: 27.20 twice27.20Duplicate voided
L5T-204628.86, signedA: 28.8628.86Matched
L6noneHandwritten, "28 t approx.", signedB: 28.000, heldHeld: no weight
L7T-2047, R-0012Refused on site, not signedC: 27.440Return, not billed
L8T-204828.66, signedA: 30.0028.66Invoice line corrected
L9T-204929.18, signedB: 29.1828.22Tare corrected, approved
L10T-205028.06, signed; customer weighed 27.70B: 28.0628.06Variance explained
Reconciliation of each load: ticket, delivery ticket, draft invoice line, quantity to bill, status (invented)

What each anomaly was, and how it was decided

  • L4, duplicate. T-2044 and T-2045 have the same truck, order, gross and tare, three minutes apart, with no weighing in between: the printer jammed and the operator issued the ticket again under a new number. T-2045 is voided with the reason "reissue after printer fault", and the draft line for it is removed.
  • L6, missing ticket. The ticket sequence has no gap (T-2048 at 11:05 is followed by T-2049 at 14:20). The exit camera read V-205 leaving loaded at 13:41, during the outage, and the driver came back with a handwritten delivery ticket saying "28 t approx.", signed by customer B. No weighed quantity exists, so the 28.00 t draft line is removed and the load is held for the quarry manager and finance, who will agree the basis with customer B under the contract. It is not billed today.
  • L7, return. Customer C refused the load on site. V-310 came back loaded at 12:15 and was weighed in at 40.38 t gross; after tipping on the returns stockpile, its tare was 12.96 t, so return ticket R-0012 shows 27.42 t returned against 27.44 t sent. The 0.02 t is one scale interval of this invented weighbridge. The load is not billed, the stock goes back, and the refusal reason is recorded with a photo.
  • L8, invoice line mismatch. The draft line for T-2048 says 30.00 t, the order's nominal truckload, keyed from the order instead of the ticket. The ticket says 28.66 t, the signed delivery ticket says 28.66 t. The line is rebuilt from the ticket: 30.00 minus 28.66 is 1.34 t that would have been billed and disputed.
  • L9, stored tare. T-2049 used V-412's stored tare of 13.10 t, saved four months earlier and marked PT on the ticket. The same truck was weighed empty at 14.06 t that morning on L3, and again at 14.04 t when it came back at 16:10, at the quarry manager's request: the haulier had changed the trailer. The billed quantity is corrected to 42.28 minus 14.06 = 28.22 t (the manager used the higher of the two weighed tares, so the customer is not billed for the doubt). The ticket is unchanged, the correction record carries both values, customer B receives a corrected delivery statement, and the stored tare is replaced by 14.04 t. On this one load the stored tare overstated the net by 0.96 t, 3.4% of 28.22 t.
  • L10, customer weight. Customer B weighed V-205 at 27.70 t on arrival against 28.06 t on T-2050: 0.36 t less, 1.28% of the ticket. That is above the contract's 1% investigation threshold, so finance sends both weights to the customer and asks for the receiving scale's last verification date. Under the contract the quarry's ticket governs, and 28.06 t is billed; the investigation is recorded with the line.
Draft invoices against reconciled quantities per customer, in tonnes (invented)
Customer and orderDraft invoicesReconciled, to billDifference and cause
A (O-501, 0/20)87.2685.92minus 1.34: L8 billed at the order's nominal 30 t
B (O-502, 20/40)141.64112.68minus 28.96: L6 held (28.00), L9 tare corrected (0.96)
C (O-503, 0/4)81.8427.20minus 54.64: duplicate T-2045 (27.20), returned load L7 (27.44)
Total310.74225.80minus 84.94, and one load held for a decision
Draft invoices against reconciled quantities per customer, in tonnes (invented)

Check the totals: the ten outbound tickets, T-2041 to T-2050, sum to 281.40 t of net weight (the duplicate included, the return ticket excluded). Removing the duplicate (27.20), the returned load (27.44) and the stored-tare overstatement (0.96) leaves 225.80 t, which is what the reconciled column bills. The draft invoices said 310.74 t because they also carried L8 at its nominal 30.00 t and the handwritten 28.00 t for L6.

Evidence to keep for each load

Keep what lets someone who was not there understand the load six months later. Keep it as long as your accounting, tax and contractual obligations require, which your accountant can state for your jurisdiction.

  • The weighbridge ticket as issued, with gross, tare, net, the tare's source (weighed or stored, marked PT where the instrument prints it) and both timestamps
  • The delivery ticket, signed, with the name of the signatory and the time; a photo of it when the driver brings back paper
  • The camera frames or plate reads at the deck and at the exit, if the site has cameras
  • The vehicle's stored tare history: each value, when it was weighed, who saved it
  • Voids, reprints and return tickets, each with its reason and the original it refers to
  • The corrections log: old value, new value, basis, who approved, when, and the customer notice it produced
  • The instrument's verification status on the day: the sticker or certificate and the logbook entry, where your jurisdiction requires them
  • For each invoice line, the ticket numbers it bills

Handling and approving anomalies

An anomaly is only handled when a named person has decided it, with the evidence in front of them, and the decision is recorded. Route each type to one owner and give the owner a deadline tied to the invoice run, so nothing waits past the date it would have been billed.

Anomaly types, owner, the evidence shown, the decisions available and the deadline (adapt to your delegation)
AnomalyOwnerEvidence shownDecisionsDeadline
Duplicate ticketWeighbridge operatorBoth tickets, times, weights, the camera frame if anyVoid one, with a reasonSame shift
Missing ticketQuarry manager, then financeDelivery ticket, exit camera or GPS, weighbridge event log, the customer's own weighing if it existsInvoice on the basis the contract allows, or not at all; log the outageBefore the period's invoices go out
ReturnWeighbridge operator, then salesOriginal ticket, return ticket, reason, photo of the materialNot billed, or credited; stock moved back; reason recordedSame day
Stored tare suspectQuarry managerStored tare and its date, the truck's weighed tares, today's grossCorrect the billed quantity, inform the customer, update or delete the stored tareBefore invoicing
Invoice line differs from ticketsFinanceTicket numbers behind the line, the line's sourceRebuild the line from ticketsBefore sending
Customer weight differsFinance or salesBoth weights, both instruments' verification status, the contract clauseApply the contract; credit or hold the line; record the decisionWithin the dispute period the contract sets
Anomaly types, owner, the evidence shown, the decisions available and the deadline (adapt to your delegation)

Review the decisions monthly by type. Many voids by the same operator, stored tares corrected for the same haulier, invoice lines keyed from orders: each pattern is a rule to change or a training gap, not a reason to add a reviewer.

The daily close

A short routine at the end of each working day catches most anomalies while the drivers can still be asked:

  • Count loads that left (exit camera, gate log or loader count) against valid tickets. The difference is a missing ticket or a duplicate.
  • List gaps in the ticket sequence and voids; each has a reason.
  • List tickets issued on a stored tare, and compare each with the truck's latest weighed tare.
  • List tickets with no signed delivery ticket yet.
  • Compare the draft invoice lines with the tickets they cite; any line without ticket numbers is rebuilt.
  • Carry every held load to the next day's list with its owner, until it is decided.

What can be automated, and where Mirage fits

Every check in this guide is a comparison between records the quarry already has, which is what makes it automatable: matching tickets to orders, delivery tickets and invoice lines, the sequence and duplicate checks, the stored-tare comparison, building invoice lines from tickets, and routing each anomaly to its owner with the evidence attached. The decisions in the anomaly table stay with people.

Mirage describes this on two capability pages: its weighbridge software reads the plate and the indicator, matches each weighing to its order and holds what does not reconcile before the ticket is issued, leaving the certified instrument and its ticket as they are; its quarry dispatch and TMS software follows each load from order to delivery and produces invoice and haulier lines from the reconciled record. Both pages say that Mirage has not published a weighbridge or quarry deployment on its own. The deployment at Mass Céréales Al Maghreb, a grain port operator, is in progress and connects its control layer to the terminals' weighing systems and weighbridges, among other systems; it publishes no result figure.

If you want to test the method on your own records, the document automation pilot guide sets out how to run one in parallel with your team before anything writes to billing. The fuel side of the same sites is covered in mine fuel reconciliation, and the wider picture on the mining and quarry operations page.

Questions readers ask

Sources and scope

Checked on . Scope: reconciliation of quarry loads sold by weight. The method, tables and example are Mirage's own, with invented figures. Legal statements are limited to what each cited text says, labelled by jurisdiction; they are not legal advice.

Related on this site

Send us a week of tickets

Send a week of weighbridge tickets, the delivery tickets and the invoice lines for the same loads. We return each load matched or held, with the reason and the evidence, so you can compare it with what your team found.

Prefer to talk it through? Book a call

We use your email to reply to you and, now and then, to tell you about Mirage. You can opt out at any time. Privacy policy