Match Stripe payouts to your bank deposits
Each payout matched to a deposit, with fees and refunds, and the payouts that did not arrive.
- You start it: When you start it
What it does
The task
Open the payouts in my Stripe dashboard for month. For each payout, read the gross charges, the refunds, the fees and the net amount. Download the transactions of my bank account account for the same month and find the deposit for each payout. Put a table in the Google Sheet sheet url with the payout date, the amounts, the bank date and the difference. Put the payouts with no deposit and the deposits with no payout at the top.
- It works in Stripe, any bank site and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| month | The month to check | October 2026 |
| account | The bank account that receives the payouts | Nordbank business, 4471 |
| sheet url | The Google Sheet for the results | https://docs.google.com/spreadsheets/d/1StripeRecon |
What you get back
An example run with the example values above. Your run uses your own data.
October 2026: 22 payouts, 21 matched
Not found: the 30 Oct payout. Stripe shows it in transit until 3 Nov.
| Payout | Gross | Refunds | Fees | Net | In bank |
|---|---|---|---|---|---|
| 30 Oct | 5,240.00 | 49.00 | 152.21 | 5,038.79 | not found |
| 1 Oct | 4,812.00 | 0.00 | 141.85 | 4,670.15 | 2 Oct |
| 2 Oct | 3,966.50 | 120.00 | 115.43 | 3,731.07 | 5 Oct |
... 19 more rows
Totals: gross 98,410.00 EUR, refunds 1,230.00, fees 2,876.32, net 94,303.68
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 3 blanks
Type month, account and sheet url. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Open the payouts in my Stripe dashboard for October 2026. For each payout, read the gross charges, the refunds, the fees and the net amount. Download the transactions of my bank account Nordbank business, 4471 for the same month and find the deposit for each payout. Put a table in the Google Sheet https://docs.google.com/spreadsheets/d/1StripeRecon with the payout date, the amounts, the bank date and the difference. Put the payouts with no deposit and the deposits with no payout at the top."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Match Stripe payouts to your bank deposits" template with month = October 2026; account = Nordbank business, 4471; sheet url = https://docs.google.com/spreadsheets/d/1StripeRecon.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Open the payouts in my Stripe dashboard for October 2026. For each payout, read the gross charges, the refunds, the fees and the net amount. Download the transactions of my bank account Nordbank business, 4471 for the same month and find the deposit for each payout. Put a table in the Google Sheet https://docs.google.com/spreadsheets/d/1StripeRecon with the payout date, the amounts, the bank date and the difference. Put the payouts with no deposit and the deposits with no payout at the top."
}
}Related templates
All finance templatesFinance
Prepare the figures for your VAT return
Sales and input VAT by rate for the period, checked against your sales platforms, with the box values.
You start it: When you start it- Xero
- Shopify
- Stripe
- +1 more: Google Sheets
Finance
Prepare the numbers for your investor update
Revenue, growth, burn, runway and customer count for the month, each with its source.
On a schedule: On the 3rd of each month at 9:00- Stripe
- Any bank site
- Google Sheets
Data
Copy numbers from your dashboards into a sheet
One new row each week with the numbers from each of your dashboards, ready for charts.
On a schedule: Every Monday at 7:00- Stripe
- Google Analytics
- Any admin panel
- +1 more: Google Sheets
Finance
Find card payments that have no receipt
Each card payment matched to a receipt from your inbox or folder, with the missing ones listed first.
You start it: When you start it- Any bank site
- Gmail
- Google Drive
- +1 more: Google Sheets
FinanceAsks first
Answer a Stripe dispute with evidence
The order, the delivery proof and your messages for the disputed payment, with a draft answer.
You start it: When you start it- Stripe
- Shopify
- Gmail
- +1 more: Any carrier site
Finance
Convert foreign-currency invoices at the official rate
The official rate for each invoice date and the amount in your currency, ready for your books.
You start it: When you start it- Google Sheets
- Any website