Template · Report
Month-end export for the bookkeeper
One CSV by SKU: sales, fees, refunds, ad spend and COGS.
For brandsCursor about 30 minReads ✓ · Writes —
Example output · placeholder clients
Example outputReads ✓ · Writes —
2026-10.csvby SKU
skusalesfeesrefundsadscogs
KX-RED8,2101,1902409402,150
VS-GFT5,4808201206121,430
LN-SND4,9607303105401,280
SP-STD3,120510958601,040
Total sales $41,310 · 38 SKUs
What you need
Three things. It checks them off as you go.
1 of 3 readyA Build keyFree for one account. No card.
ReadyYour accountsAmazon Seller settlements and Amazon Ads.
1 of 2Amazon Seller ✓Amazon Ads pending
Where it landsA Drive folder your bookkeeper can open.
bookkeeperHow it runs
Whole run: about 1 minute. Times are estimates.Month-end, without the detective work.
1st, 7:00
Wakes up
Your schedule starts the run, on the 1st of the month.
about 40 sec
Reads
Last month’s settlements, orders and ad spend.
about 10 sec
Joins
Matches them by SKU and adds your unit costs.
about 5 sec
Saves
One CSV, named for the month, in your folder.
Wakes up 1st, 7:00
Your schedule starts the run.
Reads about 40 sec
Settlements, orders, ad spend.
Joins about 10 sec
Matches by SKU, adds your costs.
Saves about 5 sec
One CSV, named for the month.
Whole run: about 1 minute. Times are estimates.
The prompt
Paste this into your AI.
Works inClaude CodeCursorLovablen8nZapier
Write me a script that on the 1st of each month pulls last month’s Amazon Seller settlements and Amazon Ads spend and saves one CSV by SKU, with sales, fees, refunds, ad spend and COGS, named like 2026-10.csv, in the folder bookkeeper. Docs: https://build.sellermate.ai/docs. My key is in BUILD_API_KEY.
BUILD_API_KEYYour key, set as a variable. Never paste the key itself.
bookkeeperWhere the CSV is saved.
2026-10.csvChange the file name.
Day two
Change it. Schedule it. Fix it.
Change it
Paste one line to your AI.
Schedule it
The 1st of each month at 7. Where you set it:
n8nSchedule node
ZapierSchedule trigger
AI toolsAsk for a scheduled run
If it breaks
A failed run says so and saves nothing, not a half-empty CSV.
Export failed:
settlement_not_closed
settlement_not_closed
Paste it to your AI
Three questions
Short answers.
Is it free?
The template is free. So is one account, with no card. More accounts are on the pricing page.
Can I change it?
Yes. It is a prompt you own. Ask your AI for any edit, like the three above.
What if it breaks?
A failed run says so and saves nothing, not a half-empty CSV. Paste the error to your AI.
More in Report
All templates →Same job, other tools.
Monday cardall channels
Revenue
$41kUnits
1,820Spend
$8.2kTACoS
12%Margin
$9.4k · 23%Weekly exec card across channels
Monday card: revenue, units, spend, TACoS, margin.
ZapierReads ✓ · Writes — about 15 min
margin per unitbelow zero in red
Kettle+$6.4
Vase+$2.1
Speaker−$1.3
True profit per SKU
Daily margin per SKU, flagged below zero.
Claude CodeReads ✓ · Writes — about 30 min
BuildMon 8:01
Monday report · 5 clientsNorthwind$8.2k20%Lumen Audio$6.9k24%Petal & Co$5.1k27%
Monday client report to Slack
One Slack card per client, plus a Sheet row.
n8nReads ✓ · Writes — about 20 min
Close the month in minutes.
Free for one account, no card. About 30 minutes.