Automated Amazon Pay Payout Reconciliation
Every Monday, WebRun signs in to Amazon Pay, pulls last week's captures, refunds, and fees along with the settlement amounts that were paid out, matches each payout to its underlying transactions in a Google Sheet, and emails you a short list of anything that does not reconcile.
Amazon Pay
pull transactions and payouts
How do I reconcile Amazon Pay payouts with my transactions?
WebRun signs in to Amazon Pay every Monday, pulls last week's captures, refunds, fees, and settlements, then matches each payout to its underlying transactions in a Google Sheet. It emails you and your bookkeeper a short exception list of anything that does not tie out, with amounts and dates.
- Payouts are reconciled weekly rather than at month end
- Unmatched transactions and fee differences are named with amounts
- Your bookkeeper gets one sheet instead of raw exports
Built for ecommerce finance teams · bookkeepers · online merchants · accountants
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
pay.amazon.comin a real browser with your saved login - no setup, no API keys. -
1
Amazon Pay - pull transactions and payouts
WebRun opens Amazon Pay to pull transactions and payouts. - Sign in to Amazon Pay and open your transaction reports
- Capture last week's captures, refunds, chargebacks, and fees with their dates and amounts
- Capture each settlement or payout with its date and total
- Read only. Never issue a refund, capture a charge, or change a payout setting
Done when Last week's transactions and every payout amount are captured.
-
2
Google Sheets - match payouts to transactions
google.com
WebRun opens Google Sheets to match payouts to transactions. - Open your Payment Reconciliation sheet in Google Sheets
- Write one row per transaction with type, amount, fee, and payout reference
- Add a payout summary block showing gross, fees, refunds, and net for each settlement
- Compute the difference between expected net and the amount actually paid out
- Highlight any row that does not tie to a payout
Done when Every payout has its transactions matched and any difference is computed.
-
3
Gmail - email the exceptions
gmail.com
WebRun opens Gmail to email the exceptions. - Draft an email to yourself and your bookkeeper with the week's reconciliation summary
- Lead with the net paid out and whether it matched the expected figure
- List every unmatched transaction and every payout with a difference
- Link the sheet and send only to your own finance addresses. Never email a customer
Done when The reconciliation summary and exception list are in your inbox.
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.
Amazon Pay
Sign in once
Every action is checked against this policy before it runs.
Questions, answered
Can it refund a customer or move money?
No. WebRun reads Amazon Pay reports only. It never issues a refund, captures a payment, or changes a payout setting. Everything it produces is a sheet and an internal email for a human to act on.
Does it email customers about payments?
No. The only email goes to the finance addresses you nominate. WebRun never contacts a customer, and any customer-facing message is drafted and left for a person to approve and send.
What counts as an exception?
Any transaction with no matching payout, any payout whose net differs from the expected gross less fees and refunds, and any chargeback logged in the period. Each is listed with its amount and date.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.