Stripe revenue after fees and refunds
Stripe's dashboard leads with gross volume. What reaches your bank is less: Stripe's fees, refunds and disputes come off first. OpenProfit reads the net figure, then subtracts the rest of your costs, so the number you see is what the product keeps.
What it reads
- Balance transactions: every charge, refund, fee and dispute, with its gross amount, fee and net. Payouts and transfers move money you already earned, so they don't count as revenue. Books records each payout on the day it reaches your bank.
- Invoices and Checkout Sessions: the sales tax or VAT on each payment, from the invoice or Checkout Session it paid. Payment Links count, because they run on Checkout. OpenProfit takes that tax out of the payment and shows it as Tax collected on the overview. A refund takes back the same share of tax. A payment with neither, such as a PaymentIntent your code creates, carries no tax figure, so its tax stays in revenue.
- Subscriptions: active subscriptions give your MRR and subscription count. Yearly and weekly prices are converted to a monthly figure. Metered prices are left out of MRR because their amount isn't known until the period ends.
Amounts in other currencies convert to your base currency at the European Central Bank rate for the day of the transaction. A workspace in Canadian dollars uses the Bank of Canada's rate instead.
Connect it
- In the Stripe dashboard, open Developers → API keys and create a restricted key with read access to Balance, Balance transaction sources, Charges, Checkout Sessions, Invoices and Subscriptions. Without Invoices or Checkout Sessions, the connection still syncs, but revenue from those payments includes tax.
- In OpenProfit, open Connections → Stripe, paste the key and press Test. The test shows your account's name.
- Press Connect. The first sync reads two years of transactions, or one year on the hosted Free plan.
A restricted key can't move money or change your account.
Revenue per product
Stripe revenue goes to the product you pick on the connection's page. If you run one Stripe account per product, connect each and point it at its product.
A Stripe payout arrives net of fees and refunds. Stripe to QuickBooks or Xero covers the entries your books need, and Stripe vs Polar vs Paddle vs Lemon Squeezy compares what you keep from each sale.