Automated MCA ACH Remittance Reconciliation
Every morning, WebRun opens Centrex, pulls the prior day's ACH remittances for every active advance, matches each payment to its deal record, logs the results to a Google Sheet, and posts a digest to Slack flagging any amount that does not match the expected daily factor-rate pull.
How do I automatically reconcile daily ACH remittances for merchant cash advances?
WebRun opens Centrex every morning, pulls the prior day's ACH remittances for every active advance, and matches each cleared amount to the expected factor-rate pull. Variances are logged in Google Sheets, and a digest with all exceptions is posted to Slack before your team starts work.
- Every ACH mismatch is caught and flagged before the business day starts
- Reconciliation that took an hour of manual work is done in minutes
- Full audit log in Google Sheets with no manual data entry
Built for MCA funders · advance servicing teams · MCA operations managers · fintech ops
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.centrexsoftware.comin a real browser with your saved login - no setup, no API keys. -
1
Centrex - pull ACH remittance records
centrexsoftware.com
WebRun opens Centrex to pull ACH remittance records. - Open Centrex and navigate to the advance servicing dashboard
- Filter remittances to the prior business day
- Export the settlement list with deal ID, merchant name, expected pull amount, and actual cleared amount
Done when All prior-day ACH remittances are captured with expected and actual amounts.
-
2
Google Sheets - log and match each payment
google.com
WebRun opens Google Sheets to log and match each payment. - Append each remittance row to the reconciliation log sheet
- Calculate the variance between expected and actual for every row
- Mark rows green where amounts match and red where they differ by more than your tolerance
Done when Every remittance is logged, matched, and colour-coded in the sheet.
-
3
Slack - post reconciliation digest with flags
slack.com
WebRun opens Slack to post reconciliation digest with flags. - Post a summary to your ops channel: total cleared, total expected, count of mismatches
- List each flagged mismatch with deal ID, merchant name, and variance amount
- Include a link to the Google Sheet for the full detail
Done when Your team has the day's reconciliation result in Slack with all exceptions highlighted.
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
Will it automatically reverse or correct a mismatched payment?
No. WebRun only flags the mismatch and logs it. Any correction or reversal requires a human to review and action it in Centrex.
How does it know what the expected pull should be?
It reads the factor rate and agreed daily remittance amount stored on each advance record in Centrex, then compares that to the actual cleared ACH amount.
What if an ACH pull failed entirely?
A zero-cleared amount against a non-zero expected pull is treated as a mismatch and flagged in the digest, so your team can investigate the failed debit immediately.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.