How to Reconcile Quarry Weighbridge Tickets With Invoices
A customer disputes the total tonnage on an aggregate invoice. The weighbridge can show every load, but first confirm which tickets the invoice actually covers.
What to pull
Use Excel outbound and invoice logs, or export weighbridge tickets and invoice lines from your scale and accounting systems. Keep quarry, ticket, product, customer, weight and unit.
How to check it
Match quarry and ticket ID, then account for voids and replacements. If invoices group loads, reconcile the linked ticket set before comparing total tonnage.
Which outbound tickets have missing, duplicate or mismatched invoice coverage? Show ticket weights and source rows.
What to do with the result
Pull original tickets for unexplained differences. Send billing a list of affected invoices with the specific ticket references to verify.
Confirm reweighs, voids and agreed units before adjusting invoices.