Lemon Squeezy orders to dashboard
Your Lemon Squeezy orders, net of VAT and fees.
Export orders from the Lemon Squeezy dashboard, drop the file here, and you get the number that actually matters to a solo software business: net after tax and fees. Every money column is in cents, tax is collected by Lemon Squeezy as merchant of record so it was never yours, and the fee is deducted before payout. All three are handled on load.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
Merchant of record changes what revenue means
Most payment exports leave tax to you. Lemon Squeezy does not, because it sells as merchant of record, which means the VAT charged to a customer in Germany is collected and remitted by Lemon Squeezy rather than by you. That is the whole appeal of the model, and it is also why the Total column in this export is not your revenue. Total includes tax you will never see. Subtotal minus discount is the sale, and Net is what lands.
The other half is geography. Because tax depends on where the buyer is, the Country and Tax Name columns are unusually load-bearing here. A quarter where European sales grew looks like flat revenue if you read Total, because more of the total is VAT. Reading Net instead makes the same quarter look like growth. This page shows both lines together so the gap is visible rather than confusing.
How to export from Lemon Squeezy
- Open your Lemon Squeezy store dashboard Sign in at app.lemonsqueezy.com and pick the store from the switcher at the top left. Each store exports separately, so a multi-product setup means more than one file.
- Go to Orders Orders in the left sidebar gives one row per order. Subscriptions is a different report with a renewal-centric shape, so start with Orders unless you specifically want churn.
- Set the filter and click Export The export honors whatever filter is applied, including the status filter. Clear it before exporting or refunded orders will be missing and your refund rate will read as zero.
- Take the CSV by email Lemon Squeezy mails the file to the account owner rather than downloading in the browser. It arrives within a minute or two for typical stores.
- Drop it on this page Product and Variant become breakdown chips, Country feeds the map, and the net line is drawn from Total minus Fee.
The Test Mode column is worth checking first. If it contains any true values, filter them out before reading anything, because test orders carry realistic amounts and will quietly inflate the quarter.
Try with sample Lemon Squeezy data (the same columns, 96 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Lemon Squeezy names it.
- Net revenue over time. Created at as the axis, Net as the value, so what you see is what reaches your bank rather than what the customer was charged.
- Gross against net. Total and Net as two lines. The widening gap is VAT plus fees, and it grows as your European share grows.
- Product and Variant. Two levels: which product sells, and whether Monthly, Annual or Lifetime is carrying it. For a solo business that second question decides the roadmap.
- Country and tax regime. Country on the map, and Tax Name as a filter, so you can see exactly which sales carried VAT.
- Discount impact. Discount summed against Subtotal, which tells you what your launch coupons actually cost.
- Refund rate. The Refunded flag and the refunded status together, as a share of orders and of value.
Order ID,Order Number,Created at,Status,Customer Name,Customer Email,Product,Variant,Quantity,Currency,Subtotal,Discount,Tax,Total,Fee,Net,Tax Name,Country,Refunded,Test ModeWhat to watch in a Lemon Squeezy export
- Every money column is in cents. Six of them. A 29 dollar order reads 2900 in Subtotal, and the Fee on it is around 195. Nothing in the header hints at this.
- Total is not your revenue. It includes tax collected on your behalf as merchant of record. That money is remitted to a tax authority, so counting it as income overstates a Europe-heavy quarter substantially.
- Tax Name is blank for most non-EU sales. An empty Tax Name means no tax regime applied, not missing data. It correlates with Country, so check them together.
- Test Mode orders look completely real. Same products, same amounts, a true in one column. Filter them out first or your best month will be imaginary.
- Order Number restarts per store. It is a per-store sequence, not a global id. Two stores merged into one file will collide on it, so join on Order ID instead.
- Refunds have both a status and a flag. Status becomes refunded and the Refunded column goes true. Partial refunds only move the flag, so relying on status alone undercounts them.
The one-sentence version: read Net, not Total, and throw out the test orders. Do those two things and a Lemon Squeezy export is a genuinely honest picture of a small software business.
Frequently asked questions
Why is Total higher than what I got paid?
Two deductions sit between them. Tax is collected from the customer and remitted by Lemon Squeezy as merchant of record, so it was never your money. Fee is Lemon Squeezy's cut plus payment processing. Net is the column that reflects both and is what your payout is built from. For an EU-heavy quarter the gap between Total and Net can be over a quarter of the headline number.
Are the amounts in dollars or cents?
Cents, in every money column: Subtotal, Discount, Tax, Total, Fee and Net. A 49 dollar annual plan appears as 4900. This is the same convention Stripe uses, and for the same reason, but the Lemon Squeezy header gives you no hint of it. The dashboard divides by 100 on load and shows the currency from the Currency column.
How do I exclude test orders?
Filter on the Test Mode column, which is true for anything created while the store was in test mode. Test orders carry real-looking products and amounts, so they are easy to miss and they distort everything. This page surfaces Test Mode as a filter chip and flags it in the summary when any true values are present.
Can I see revenue by country net of VAT?
Yes, and that combination is the most useful view in the file. Group by Country and set the metric to Net rather than Total. Countries with a VAT regime will show a larger gap between the two, which is exactly the effect you want to be able to see, since it explains why a growing European share can look like flat revenue on a gross chart.
What is the difference between the Orders and Subscriptions exports?
Orders has one row per transaction, including first payments, renewals and one-off purchases, and it carries the money columns. Subscriptions has one row per subscription with its current state, so it is the right file for churn and MRR but the wrong one for revenue. Most questions about what you earned belong to Orders.
Does this page store my customer list?
No. The CSV is read in your browser and held in memory for as long as the tab is open. Customer Name and Customer Email are in the file, which is precisely why there is no upload step. Nothing is written to a server, and nothing persists between visits unless you deliberately export something back out.
Related tools
See net revenue instead of gross
96 orders in cents, a realistic mix of VAT and non-VAT countries, discounts, refunds and a fee on every row. Load it and compare the two lines.
Open the sample Lemon Squeezy dashboard