Skip to content

Daily true profit and payout gap report

Turns yesterday's Shopify and Square exports plus your costs into true profit per channel. It also lists payouts that do not match what the sales say you should have received.

Ecommerce and resaleWorks with Claude Code · Claude Desktop with MCP+1Community example
Build your promptSee requirements

What it does

  • Reads the order, payment and item exports for one day
  • Subtracts fees, refunds on their refund date and cost of goods per SKU
  • Reports profit per channel
  • Lists payout discrepancies to look into
  • Stops with a clear error when a column is missing instead of guessing

Your approval boundaries

Read only

Reads connected data. It does not send messages or change records.

You decide what happens next.

More about this workflow

This setup is for online sellers and resale shops juggling listings, orders and buyers. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it reads the order, payment and item exports for one day. Next, it subtracts fees, refunds on their refund date and cost of goods per SKU. Then it reports profit per channel. After that, it lists payout discrepancies to look into. Finally, it stops with a clear error when a column is missing instead of guessing. It works with your store admin, payments and spreadsheets, each on its own login with limited access.

You get the finished work, ready to read. It only reads, so nothing is sent, changed or paid for. You decide what to do with it.

“yesterday's true profit across Shopify + Square, with payout reconciliation”
madlouse madlouse on GitHub · Oct 11, 2026
Before you startStore admin · Payments accessRead-only permissionsClaude Code or Claude Desktop with MCP
Explore required tools and model recommendations

Tools and access

  • Shopify

    Handles the store admin part of this job. Grant read orders and products.

    API required: Yes. Needs a Shopify app with an access token and the admin scopes you approve.

    Sign up: Shopify

  • Stripe

    Handles the payments part of this job. Grant a restricted read-only key.

    API required: Yes. Needs an API key. Stripe offers restricted keys that limit what a key can do.

    Sign up: Stripe

  • Google Sheets

    Handles the spreadsheets part of this job. Grant access to the single sheet it needs.

    API required: Yes. Needs a Google Cloud OAuth app or a service account with the Sheets API turned on.

    Sign up: Google Workspace

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

Gemini 3.8 Flash

Built for agent workflows, with a free tier to test on.

$0.75 per million input tokens and $3.75 per million output tokens through December 31, 2026. $1.50 and $7.50 from January 1, 2027.

Google docs as of October 11, 2026

Cheaper backup

Gemini 3.5 Flash-Lite

Low cost for many listings at once.

$0.30 per million input tokens, $2.50 per million output tokens.

Google docs as of October 11, 2026

Our own picks. Not sponsored, no affiliate links.

Build your prompt

Add your details, then copy the prompt into your tool.

1Your details

Fill these in and the prompt updates as you type.

e.g. Shopify and Square

cost per SKU

2Your prompt

4 of 4 still empty
Fill these in before you run it: [REPORT DATE AND TIME ZONE] [SALES CHANNELS: e.g. Shopify and Square] [COSTS FILE: cost per SKU] [EXPORTS FOLDER] You are the Daily true profit and payout gap report agent. Turns yesterday's Shopify and Square exports plus your costs into true profit per channel. It also lists payouts that do not match what the sales say you should have received. Use only the details filled in above. If any [BRACKETED] item is still blank or unclear, stop and ask for it first. Do not guess. What you do on your own: - Reads the order, payment and item exports for one day - Subtracts fees, refunds on their refund date and cost of goods per SKU - Reports profit per channel - Lists payout discrepancies to look into - Stops with a clear error when a column is missing instead of guessing What you must never do without a yes from a person: - Anything that writes, sends, or spends. This job only reads. Rules: - Before any step on the list above, stop and ask. Say in plain words what you want to do, who it affects, and whether it can be undone. - If something cannot be undone, say so first, in one short line. - Write drafts, not final actions. A person sends, pays, posts, or deletes. - Keep a short log of every action you took and every source you read. - If you are unsure, ask instead of guessing.
View run instructionsPaste into: Claude Code, Claude Desktop with MCP, Cursor

Your answers stay in this browser only.

Run your workflow

Connect your tools with only the access this setup needs, then follow these steps.

Steps

Do these in order. Test on old data before it touches live work.

  1. 1Connect Shopify with its own login, not yours. Grant read orders and products.
  2. 2Connect Stripe with its own login, not yours. Grant a restricted read-only key.
  3. 3Connect Google Sheets with its own login, not yours. Grant access to the single sheet it needs.
  4. 4Paste the prompt where your harness takes instructions. See the note under the Copy button.
  5. 5Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
  6. 6Read its log after the first real run. Only widen access once a week of runs looks clean.

Safeguards and trust score

The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.

Access30 / 30

Read only. It never writes, sends or spends.

Human approval30 / 30

Nothing to approve, it only reads.

Undo and logs20 / 20

No changes to undo. Reads can be logged.

Scope16 / 20

Runs on its own login across 3 tools. Fewer connections means a smaller blast radius.

How to raise it

Nothing major to fix. One polish tip: show a short daily log of what it read, so you can spot it reaching for anything new.

Reviewed by Trustcase (example setup). How scoring works

Embed badge

Show this trust score on your site or README. It links back here.

Trustcase trust score badge
Markdown
[![Trustcase trust score for Daily true profit and payout gap report](https://trustcase.dev/badge/daily-true-profit-and-payout-gap-report.svg)](https://trustcase.dev/use-cases/daily-true-profit-and-payout-gap-report)
HTML
<a href="https://trustcase.dev/use-cases/daily-true-profit-and-payout-gap-report"><img src="https://trustcase.dev/badge/daily-true-profit-and-payout-gap-report.svg" alt="Trustcase trust score for Daily true profit and payout gap report" height="20"></a>

More ecommerce and resale workflows

  • Monday store revenue leak readout

    Checks your store and ad exports for where money is leaking, from wasted ad spend to leaked discount codes and refunds. Each Monday it names the three things to fix first and changes nothing itself.

  • Lost checkout discount rules audit per store

    For a store whose old checkout scripts stopped running, it finds each discount, shipping and payment rule that quietly stopped and checks whether anything replaced it. You get one read-only report with fixes ranked by revenue impact.

  • Listing writer

    Writes marketplace listings from your photos and a model number.

  • Profit after fees check

    Tells you what you actually clear on a buy before you buy it.

Other workflows that use the same tools

  • Refund checker

    Support. Checks refund requests against your policy and lays out the facts.

  • Daily delivery app sales log

    Operations. Reads yesterday's sales from each delivery app and your point of sale every morning. Writes the totals into one sales sheet.

  • Weekly ops report

    Operations. Writes the Monday numbers summary so you do not build it by hand.