Automated Freight Factoring Payment Reconciliation
Every Monday morning, WebRun opens OTR Solutions to pull the week's payment remittances, compares each advance and reserve release against the matching invoice in QuickBooks, flags any gaps or shortfalls, and posts a reconciliation digest to your Slack finance channel.
How do I automatically reconcile OTR Solutions factoring payments with my QuickBooks invoices?
WebRun pulls every OTR Solutions remittance and reserve release each Monday, matches each payment to the corresponding QuickBooks invoice, and flags any discrepancy where the advance plus reserve does not equal the expected net. Your finance team gets a clean weekly digest in Slack within minutes of the run.
- Every factoring payment matched to an invoice within 24 hours of the week starting
- Discrepancies surfaced before they compound across multiple pay cycles
- Reserve releases tracked separately so nothing is missed
Built for trucking carriers · fleet owners · freight factoring clients · bookkeepers at trucking companies
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
client.otrsolutions.comin a real browser with your saved login - no setup, no API keys. -
1
OTR Solutions - pull weekly remittances and reserve releases
otrsolutions.com
WebRun opens OTR Solutions to pull weekly remittances and reserve releases. - Open OTR Solutions and navigate to the remittance or payment history section
- Download or read the week's advance payments and reserve releases
- Note each invoice number, gross amount, advance paid, fee withheld, and reserve amount
Done when All remittances and reserve releases from the past 7 days are captured with their invoice references.
-
2
QuickBooks - match payments to open invoices
- Open QuickBooks and locate each matching invoice by number
- Compare the amount received from OTR Solutions against the invoice total
- Flag any invoice where the advance plus reserve does not match the expected net
- Mark reconciled invoices as closed and note the discrepancy amount on flagged ones
Done when Every payment is matched to an invoice and discrepancies are flagged with amounts.
-
3
Slack - post reconciliation digest
slack.com
WebRun opens Slack to post reconciliation digest. - Post a weekly reconciliation digest showing total invoices submitted, total funded, total fees, and total reserves held
- List any discrepancies that need manual review with invoice numbers and amounts
- Include the count of invoices fully reconciled
Done when Your finance team has this week's reconciliation summary in Slack.
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 a discrepancy?
Any invoice where the OTR Solutions advance plus expected reserve release does not match the net amount in QuickBooks is flagged, including fee variances and partial payments.
Will it update QuickBooks entries automatically?
It reads and compares data but marks discrepancies for manual review rather than editing records automatically, so your books stay accurate and under your control.
Does it capture reserve releases separately?
Yes. Reserve releases are tracked as a distinct line item for each invoice so you can see exactly when reserves were returned and whether the amounts match.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.