Automated Checkout.com Payout Reconciliation
Every morning, WebRun opens the Checkout.com dashboard, pulls yesterday's settlements with their gross, fees, refunds, and chargebacks, writes one reconciled row per payout into Google Sheets, and posts a short summary to Telegram with anything that does not tie out.
How do I reconcile my Checkout.com payouts every day?
WebRun reconciles your Checkout.com settlements every morning. It reads yesterday's payouts with their gross, fees, refunds, and chargebacks, appends one row per payout to a Google Sheets workbook, recalculates month-to-date totals, and posts a Telegram summary leading with any payout that failed to tie out.
- Yesterday's payouts are reconciled before the finance team logs on
- Mismatched settlements are highlighted rather than discovered at month end
- Month-to-date fee and refund totals stay current every day
Built for finance teams · ecommerce operators · payment operations · controllers
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
dashboard.checkout.comin a real browser with your saved login - no setup, no API keys. -
1
Checkout.com - pull yesterday's settlements
checkout.com
WebRun opens Checkout.com to pull yesterday's settlements. - Sign into the Checkout.com dashboard and open the payments and payouts views for yesterday
- Capture the settled gross, the processing fees, refunds, and chargebacks for each payout
- Note the currency, the settlement date, and the payout reference
- Flag any payout still marked as pending past its expected settlement date
Done when Every payout dated yesterday has its gross, fees, refunds, chargebacks, and reference captured.
-
2
Google Sheets - write the reconciled rows
google.com
WebRun opens Google Sheets to write the reconciled rows. - Open the settlement workbook in Google Sheets
- Append one row per payout with the date, reference, currency, gross, fees, refunds, chargebacks, and net
- Recalculate the running month-to-date totals on the summary tab
- Highlight any row where gross minus fees, refunds, and chargebacks does not equal the net amount reported
Done when Yesterday's payouts are appended, totals are recalculated, and mismatched rows are highlighted.
-
3
Telegram - summarise what did not tie out
telegram.org
WebRun opens Telegram to summarise what did not tie out. - Post yesterday's reconciliation summary to your finance channel
- Lead with anything that did not tie out or any payout still pending past its date
- Give the net settled amount, total fees, and refund and chargeback counts in one short block
- Link to the Google Sheets workbook for the line detail
Done when The finance channel has yesterday's summary with exceptions listed first.
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
Can it move money or issue refunds?
No. WebRun only reads the payments and payouts views in Checkout.com. It never refunds a payment, never captures or voids a charge, and never initiates a payout. Every money movement stays a human action in your dashboard.
What counts as a payout that does not tie out?
Any row where the gross minus fees, refunds, and chargebacks does not match the net amount reported, plus any payout still pending past its expected settlement date. Both are highlighted in the sheet and lead the Telegram summary.
Does it handle more than one currency?
Yes. Each payout is written with its own currency and reconciled in that currency, so multi-currency settlements stay separate rather than being summed into one misleading total.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.