MRR
Subscriptions normalized to one monthly figure, with quantity-based plans counted by quantity and split by product and variant.
Lemon SqueezyChartsy data sourceLemon Squeezy analytics for indie SaaS makers
Connect your Lemon Squeezy stores and get MRR, churn, LTV and net revenue after fees and surcharges - across subscriptions and one-time sales, answered in plain English instead of CSV exports.
Needs one Lemon Squeezy API key.
MRR$9,360+22% since Apr
Monthly churn4.6%Logo churn, Sep
Average LTV$287All paid plans
Net revenue$25,410Last 90 days
How did MRR change by billing interval since April?
MRR grew 22%, from $7,650 to $9,360. Annual plans grew fastest (+30%); monthly grew 18%.
MRR by billing interval
MonthlyAnnual
$7.7k
$7.9k
$8.3k
$8.6k
$9.0k
$9.4k
What you get
The four numbers Lemon Squeezy sellers ask about most
Chartsy turns your Lemon Squeezy orders, subscription invoices and refunds into SaaS metrics you can trust.
Churn
Cancelled subscriptions by product, counted when paid access actually ends - so a cancel at period end never churns early.
LTV
What a subscriber is worth over their lifetime, compared across products and monthly versus annual billing.
Net revenue
Payments minus tax, Lemon Squeezy’s fee and surcharges, and refunds, by month - so a refund spike never hides inside a good-looking total.
Works across every way you sell on Lemon Squeezy:SubscriptionsOne-time
How it works
From Lemon Squeezy data to plain-English answers in four steps
- Step 1
Connect your Lemon Squeezy stores
Paste an API key and check the fee rate. Chartsy imports each store’s products, customers, subscriptions and payments, and adds the webhook for you.
Create the key in Lemon Squeezy under
Settings → API. - Step 2
Ask your questions
Type questions in plain English - about MRR, churn, LTV, refunds or any metric that matters to you.
“Which product churns the most?”
- Step 3
Get actionable insights
Every answer comes with a chart and the numbers behind it, so you can check the reasoning.
Charts split by product, variant and billing interval.
- Step 4
Export & share
Download reports as PDF or PNG and share them with your team or investors.
PDF and PNG export.
Ask a question
Questions your Lemon Squeezy dashboard can’t answer
Pick a question to see how Chartsy answers it. All figures are sample data.
Which product churns the most?
Your Starter plan churns the most at 6.1% a month - three times the Team plan (2.0%).
Monthly churn by product, SepSample data
One-time purchases can’t churn, so they’re excluded.
Built for Lemon Squeezy
Net revenue with every surcharge counted
Lemon Squeezy’s API doesn’t report the fee it takes from each payment. Chartsy computes it from your base rate plus the surcharges that apply to that payment, and keeps only recurring revenue in MRR.
- Surcharges per payment+0.5% on subscriptions, +1.5% for buyers outside the US and +1.5% on PayPal subscription payments are added to the payments they apply to.
- Every store, one keyAn API key sees all your stores. Each one becomes its own data source, and All Accounts adds them up.
- Churn waits for access to endA subscription cancelled at period end stays active until its paid period runs out, and churns on that day.
Revenue mix, last 90 daysSample data
SubscriptionsCounted in MRR
$22,88080%
One-timeOne-off revenue, kept out of MRR
$5,72020%
Your data
Your key stays private. Your Lemon Squeezy data stays as it is.
Reads, never edits
Chartsy reads your products, discounts, customers, subscriptions, invoices and orders. The only thing it adds in Lemon Squeezy is the webhook that sends it new events.
Key stored encrypted
Your Lemon Squeezy API key is encrypted at rest and used only to read your stores and keep their webhooks running.
Delete anytime
Delete the data source in Chartsy and it is permanently removed, together with all the data imported from it.
FAQ
Questions about the Lemon Squeezy connection
Step-by-step setup is in the Lemon Squeezy connection guide.
What do I need to connect Lemon Squeezy?
One Lemon Squeezy API key. With test mode off, go to Settings → API, create a key and copy it - Lemon Squeezy shows it only once. Keys expire after a year, so note the date. Chartsy adds the webhook to your store itself, so there is no URL or secret to copy.
I have several Lemon Squeezy stores. Can I connect them all?
Yes. One API key sees every store on your account, and each store becomes its own data source with its own name. Leave the Store ID field empty to connect them all, or enter the IDs of the ones you want. All Accounts adds them up with any Stripe, Paddle, Freemius, Polar or Creem accounts you connect.
Why does Chartsy ask for my Lemon Squeezy fee?
Lemon Squeezy’s API doesn’t say what fee it took from each payment, so Chartsy computes net revenue from your rate. It’s prefilled with the standard 5% + $0.50, and the published surcharges - +0.5% on subscriptions, +1.5% for buyers outside the US, +1.5% on PayPal subscription payments - are added for each payment automatically. Change the base rate if you agreed a different one.
Do one-time sales and upgrades count as MRR?
No. Only subscription invoices that start or renew a period count toward MRR, with quantity-based plans counted by quantity. One-time purchases and upgrade prorations count as revenue and net revenue, never as MRR.
How much history does Chartsy import?
Everything from 1 January two years ago - at least 24 months - plus every subscription that’s still running, right after you connect. After that, the Lemon Squeezy webhook delivers new orders, subscription payments, refunds and subscription changes as they happen, and Sync now re-reads your store whenever you want a full check.
Can I see which marketing channel brought each Lemon Squeezy customer?
Yes. Set each product’s Confirmation Modal and Email Receipt button link to a page on your site with the Chartsy tag, ending in ?order_id=[order_id]&order_identifier=[order_identifier], and Chartsy credits the order to the visit behind it - even without a signup. Creating checkouts from your server? Add the chartsy_visitor_id cookie to the checkout’s custom data. Buyers are also matched by email to people who signed up.
Does GDPR mode work with Lemon Squeezy?
Yes. Turn it on when you connect and Chartsy keeps customer emails, names, countries and cities out of the sync. MRR, churn and revenue stay the same, and button-link and custom-data attribution keep working; breakdowns by country and matching payments to visitors by email are what you give up.
Stop exporting CSVs. Start asking questions.
Connect your Lemon Squeezy stores and get your first answer in a few minutes.
Connect Lemon SqueezyLemon Squeezy is a trademark of its respective owner.
