Automated Razorpay Settlement Reconciliation
Every morning, WebRun opens Razorpay, pulls the latest settlement 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 settlement.
How do I reconcile Razorpay settlements against my orders automatically?
WebRun reconciles your Razorpay settlements every morning by matching each batch against your order log in Google Sheets and drafting a Gmail note to accounting whenever an order and settlement don't line up. It never moves money itself, so discrepancies get caught and explained the same day instead of at month end.
- Settlement mismatches are caught the same morning, not at month end
- Every settlement batch has a matched, explainable total
- Accounting gets a ready to send note instead of a spreadsheet hunt
Built for ecommerce merchants · Indian online sellers · bookkeepers · finance teams
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.razorpay.comin a real browser with your saved login - no setup, no API keys. -
1
Razorpay - pull the settlement batch
- Open the Razorpay dashboard and pull the latest settlement batch
- Capture the settlement total, order references, and fees deducted
- Note refunds included in the batch
Done when The settlement batch is captured with every order reference.
-
2
Google Sheets - match settlements to orders
google.com
WebRun opens Google Sheets to match settlements to orders. - Open the order log and match each order to its settlement
- Highlight any order missing a settlement or settlement missing an order
- Update the running reconciled total
Done when Every order in the batch is matched or flagged as a mismatch.
-
3
Gmail - draft the mismatch note
gmail.com
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.
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 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 settlement in the Razorpay batch, or a settlement with no matching order, so nothing gets missed on either side.
Does it email accounting 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.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.