Contractor reconciliation against weighbridge records, and the data pipelines that maintain it.
Metron cross-checks contractor invoices against weighbridge records line by line and maintains the reconciliation workbook: unmatched trips, consumption anomalies, and the dispute documentation behind each flag.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Contractor | Period | Weighbridge (t) | Invoiced (t) | Variance (t) | Variance % | Rate (Rp k/t) | At risk (Rp M) |
| 2 | PT Karya Tambang | Sep W1-W4 | 128,400 | 131,200 | 2,800 | 2.2% | 85 | 238.0 |
| 3 | CV Bukit Perkasa | Sep W1-W4 | 96,100 | 96,400 | 300 | 0.3% | 82 | 24.6 |
| 4 | PT Andalan Jaya | Sep W1-W4 | 84,750 | 88,900 | 4,150 | 4.9% | 85 | 352.8 |
| 5 | PT Mega Sarana | Sep W1-W4 | 71,300 | 71,250 | -50 | -0.1% | 80 | -4.0 |
| 6 | CV Tunas Muda | Sep W1-W4 | 65,900 | 67,100 | 1,200 | 1.8% | 82 | 98.4 |
| 7 | PT Bumi Perdana | Sep W1-W4 | 58,200 | 58,300 | 100 | 0.2% | 85 | 8.5 |
| 8 | CV Lestari | Sep W1-W4 | 44,600 | 45,700 | 1,100 | 2.5% | 80 | 88.0 |
| 9 | PT Cipta Karsa | Sep W1-W4 | 39,850 | 40,100 | 250 | 0.6% | 82 | 20.5 |
| 10 | TOTAL | 589,100 | 598,950 | 9,850 | 1.7% | 826.8 |
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Ticket | Date | Contractor | Truck | Net (t) | Matched invoice |
| 2 | WB-118204 | 28 Sep 06:12 | PT Andalan Jaya | B 9241 KT | 31.4 | AJ-0922 · line 84 |
| 3 | WB-118205 | 28 Sep 06:31 | PT Karya Tambang | B 8817 KT | 29.8 | KT-1108 · line 12 |
| 4 | WB-118206 | 28 Sep 06:47 | CV Bukit Perkasa | B 7702 KT | 30.6 | BP-0341 · line 27 |
| 5 | · | 28 Sep, billed | PT Andalan Jaya | no ticket | 32.0 | AJ-0922 · line 85 · disputed |
| 6 | WB-118207 | 28 Sep 07:02 | PT Mega Sarana | B 6619 KT | 28.9 | MS-0770 · line 41 |
| 7 | · | 29 Sep, billed | PT Karya Tambang | no ticket | 30.5 | KT-1108 · line 13 · disputed |
Metron’s coding agents build and maintain the data joins behind the reconciliation (weighbridge exports to ERP invoice lines) with every change tested and reviewed before deployment.
$ metron task "extend weighbridge ingest to the new ticket format"
plan:
1. parse the new ticket layout in ingest.py
2. extend schema.sql with the added fields
3. update tests to cover both formats
reading sample exports … 240 tickets in the new format
writing changes …
files changed: +412 -38 across ingest.py, schema.sql, tests/
running test suite …
OK 14 tests passed
change PC-118 opened · diff and test log attached
review requested · ops engineer
OK approved 09:41
OK deployed · read-only grant unchanged
Contractor invoices, weighbridge tickets, and fuel logs live in three systems; site reports arrive as voice notes from the pit.
| Source | System | Volume | State |
|---|---|---|---|
| Contractor invoices | AP system | 214 pages | Unjoined |
| Weighbridge tickets | Scale feed | 21,846 tickets | Unjoined |
| Fuel logs | Depot system | 3 sites | Unjoined |
| Site reports | Voice notes | Daily | Unfiled |
"Do this month’s contractor invoices match what crossed the weighbridge?"
Checked line by line: two invoices bill trips the weighbridge never recorded, and fuel consumption at one site runs 18% over plan.
A dispute memo for the two invoices, and a standing fuel watcher for the outlier site.
Dispute memo for the two invoices (Rp 590.8 M combined) and a standing fuel watcher for Site Kutai.
Site leadership approves both; the recovered amount is material, and the watcher remains in force.
Bring the question your teams cannot answer quickly. We will answer it from your data, on your infrastructure.
Request a working session→