Cuiar
Sign inDownload

Break down the fees in your marketplace payouts

Sales, fees, ads and refunds for each product on each marketplace, with your net after fees.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Download last month's payment reports from my seller accounts on these marketplaces: marketplaces. For each product, add up the sales, the selling fees, the shipping fees, the ad costs and the refunds. Calculate the net amount and the fees as a percent of sales. Put the results in the Google Sheet sheet url, one tab per marketplace and one summary tab. Mark the products where the fees are more than max fee percent percent of sales.

  • It works in Amazon Seller Central, Etsy, eBay 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

BlankWhat to giveExample
marketplacesThe marketplaces where you sellAmazon, Etsy, eBay
sheet urlThe Google Sheet for the resultshttps://docs.google.com/spreadsheets/d/1MarketFees
max fee percentThe fee percent above which to mark a product25

What you get back

An example run with the example values above. Your run uses your own data.

October 2026, 3 marketplaces

MarketplaceSalesFeesAdsRefundsNetFees %
Amazon18,420 USD4,9711,84061010,99927.0%
Etsy6,230 USD1,012310954,81316.2%
eBay3,115 USD41001402,56513.2%

Products with fees above 25%

  • Linen apron, Amazon: 34% (FBA fee 7.80 USD on a 19.00 USD item)
  • Oak coaster set, Amazon: 29%

Saved to "Marketplace fees 2026-10".

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 3 blanks

    Type marketplaces, sheet url and max fee percent. Tab moves to the next blank.

  3. 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 "Download last month's payment reports from my seller accounts on these marketplaces: Amazon, Etsy, eBay. For each product, add up the sales, the selling fees, the shipping fees, the ad costs and the refunds. Calculate the net amount and the fees as a percent of sales. Put the results in the Google Sheet https://docs.google.com/spreadsheets/d/1MarketFees, one tab per marketplace and one summary tab. Mark the products where the fees are more than 25 percent of sales."

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/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Break down the fees in your marketplace payouts" template with marketplaces = Amazon, Etsy, eBay; sheet url = https://docs.google.com/spreadsheets/d/1MarketFees; max fee percent = 25.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Download last month's payment reports from my seller accounts on these marketplaces: Amazon, Etsy, eBay. For each product, add up the sales, the selling fees, the shipping fees, the ad costs and the refunds. Calculate the net amount and the fees as a percent of sales. Put the results in the Google Sheet https://docs.google.com/spreadsheets/d/1MarketFees, one tab per marketplace and one summary tab. Mark the products where the fees are more than 25 percent of sales."
  }
}

Related templates

All finance templates

  • 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

  • Finance

    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
    • Stripe
    • Any bank site
    • Google Sheets

  • Finance

    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

    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

  • Finance

    Build a 13-week cash flow forecast

    Weekly cash in and out from your bank, open invoices and bills, with the weeks below your minimum marked.

    You start it: When you start it
    • Any bank site
    • Xero
    • Google Sheets

  • Finance

    Build a mileage log from your calendar

    Each business trip with its date, purpose, route and distance, and the total claim at your rate.

    You start it: When you start it
    • Google Calendar
    • Google Maps
    • Google Sheets