All templates

Automated Mollie Payout Reconciliation

Every morning, WebRun opens Mollie, pulls the latest payout batch, matches each payment against your order log in Google Sheets, and drafts a Gmail note to accounting for any order that doesn't line up with the payout.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Mollie pull the payout batch
2 Google Sheets match payouts to orders
3 Gmail draft the mismatch note
In short

How do I reconcile Mollie payouts against my orders automatically?

WebRun reconciles your Mollie payouts every morning by matching each batch against your order log in Google Sheets and drafting a Gmail note to accounting whenever an order and payout don't line up. It never moves money itself, so discrepancies get caught and explained the same day instead of at month end.

  • Payout mismatches are caught the same morning, not at month end
  • Every payout batch has a matched, explainable total
  • Accounting gets a ready to send note instead of a spreadsheet hunt

Built for ecommerce merchants · European online sellers · bookkeepers · finance teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens my.mollie.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Mollie - pull the payout batch
    • Open Mollie and pull the latest payout batch
    • Capture the payout total, order references, and any fees
    • Note refunds or chargebacks included in the batch

    Done when The payout batch is captured with every order reference.

  3. 2
    Google Sheets - match payouts to orders
    google.com
    WebRun in Google Sheets: match payouts to orders
    WebRun opens Google Sheets to match payouts to orders.
    • Open the order log and match each order to its payout
    • Highlight any order missing a payout or payout missing an order
    • Update the running reconciled total

    Done when Every order in the batch is matched or flagged as a mismatch.

  4. 3
    Gmail - draft the mismatch note
    gmail.com
    WebRun in Gmail: draft the mismatch note
    WebRun opens Gmail to draft the mismatch note.
    • Draft a note listing every mismatched order and its amount
    • Address it to your accountant or bookkeeper
    • Leave it as a draft, WebRun never sends it

    Done when A mismatch summary is waiting as a Gmail draft.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
my.mollie.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Reconciliation sheet · Google Sheets
OutputWhat each run produces - A reconciled order log with any unmatched payouts highlighted, plus a draft mismatch note.
Report
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it issue a refund or move funds to fix a mismatch?

No. WebRun never sends a payment, issues a refund, or transfers funds on its own. It only matches records, flags what doesn't line up, and leaves any refund or adjustment for a human to approve.

What counts as a mismatch?

An order in your Sheet with no matching payout in the Mollie batch, or a payout with no matching order, so nothing gets missed on either side.

Does it email the accountant automatically?

No. It only drafts the note in Gmail. You review and send it yourself, so nothing goes out without a human checking it first.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.