Reconcile scale tickets against what you actually dispatched
Every evening, WebRun opens Trux, matches each scale ticket generated on load-out against the loads that were dispatched, cross-checks each against what has been invoiced in QuickBooks, and records an exceptions worksheet in Google Sheets covering dispatched loads with no ticket, tickets never invoiced, and weight or material mismatches so nothing slips before billing.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically reconcile scale tickets against the loads I dispatched?
WebRun opens Trux every evening and matches the day's scale tickets against the dispatched loads by truck, jobsite, and time. It cross-checks each against invoiced amounts in QuickBooks and records an exceptions worksheet in Google Sheets, flagging loads with no ticket, tickets never billed, and weight mismatches, so billing starts from clean, reconciled numbers.
- Missing scale tickets caught before they become lost revenue
- Hauled loads that were never invoiced flagged nightly
- A daily matched-tons figure against dispatched and invoiced tons
Built for hauling company owners · aggregate producers · trucking bookkeepers · operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.truxnow.comin a real browser with your saved login - no setup, no API keys. -
1
Trux - match tickets to dispatched loads
truxnow.com How to Automate Trux
WebRun opens Trux to match tickets to dispatched loads. - Open Trux and pull the day's scale tickets and the day's dispatched loads
- Match each scale ticket to its dispatched load by truck, jobsite, and time
- Note any dispatched load with no ticket, ticket with no dispatch, or weight and material mismatch
Done when Every scale ticket and dispatched load is matched or flagged as an exception.
-
2
QuickBooks - cross-check invoiced amounts
- Open QuickBooks and check whether each matched ticket has been invoiced
- Flag tickets that were hauled but never billed
- Note any invoiced amount whose tons do not match the scale ticket
Done when Each ticket is marked invoiced, unbilled, or mismatched against QuickBooks.
-
3
Google Sheets - record the exceptions worksheet
google.com How to Automate Google Sheets
WebRun opens Google Sheets to record the exceptions worksheet. - Open the reconciliation worksheet in Google Sheets
- Record matched loads and list each exception with its reason
- Total the matched tons against the dispatched tons and the invoiced tons for the day
Done when The worksheet shows matched loads, exceptions, and the tonnage variance.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
What counts as an exception?
A dispatched load with no scale ticket, a scale ticket with no dispatched load, a hauled ticket never invoiced, or a weight or material mismatch. WebRun lists each with its reason so billing starts from clean data.
Does it change any ticket, load, or invoice?
No. WebRun only reads and compares the tickets, loads, and invoices across Trux and QuickBooks and records the exceptions in Google Sheets. Any correction stays a human decision.
When should it run?
Run it each evening after hauling ends so the day's tickets are complete. That way the exceptions worksheet is ready before invoices are finalized the next morning.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.