How to Track Your Etsy Revenue Properly (Not Just What Etsy Shows You)

Etsy says I made $4,800 last month. My bank says otherwise.

I got an email from Etsy last month. "Your shop earned $4,800 in March! Great job!" Felt good for about two seconds. Then I checked my actual bank deposits from Etsy and they totaled $4,011.

That's a $789 difference. Almost $800 that Etsy counted as "my revenue" but never showed up in my bank account. Where did it go? Fees. All kinds of fees. Transaction fees, listing fees, payment processing, offsite ads, a refund I'd forgotten about, and Etsy's sales tax handling (which they collect and remit but still show in your gross number on some reports).

This is not a bug. Etsy's dashboard is designed to show gross revenue — the total dollar amount buyers paid. It's technically accurate. But it's a terrible number to run your business on.

Why the gross number is dangerous

I know sellers who set their quarterly tax estimates based on their Etsy dashboard revenue. They look at the big number, estimate 25-30% for taxes, and send a check to the IRS.

The problem: they're paying estimated taxes on revenue they never received. If your dashboard says $20,000 but you actually kept $17,000 after fees, and you're estimating taxes at 25% of $20,000, you're paying $750 more in estimated taxes than you should.

Over a year, that's $3,000 sitting with the IRS instead of in your business. Yeah, you get it back when you file, but that's money you could have used for six months.

Beyond taxes, the gross number distorts how you think about your business. If you see $4,800 and think "I'm almost at $5,000/month!" you might make decisions — like quitting your part-time job or investing in expensive equipment — based on a number that's 16% higher than reality.

Where to find your real numbers in Etsy

Etsy does give you the real data. They just don't make it easy to find. Here's where to look:

Payment account page. Go to Shop Manager > Finances > Payment account. This shows your actual deposits — the money that hit your bank. This is your real net revenue. But it's shown as a list of individual deposits, not a monthly total. So you have to add them up yourself.Monthly statements. Go to Shop Manager > Finances > Monthly statements. Pick a month. This PDF breaks down your gross revenue, every fee category, and your net proceeds. This is the most accurate single document Etsy gives you. Download it every month and actually read it.CSV export. Go to Shop Manager > Finances > Payment account > click "Download CSV." This gives you a spreadsheet with every transaction, every fee, every deposit. It's messy — columns for item price, shipping, tax, transaction fee, listing fee, processing fee, and more — but it has everything.

How to read Etsy's CSV export without losing your mind

The CSV export is powerful but ugly. Here's what you're looking at:

The file has a row for every transaction. Sales show up as positive amounts. Fees show up as negative amounts. Deposits show up as separate rows. Refunds are negative sales.

To get your real monthly revenue, you need to:

1. Filter to a specific month 2. Sum the "Amount" column for rows where Type is "Sale" 3. Sum the "Amount" column for rows where Type is "Fee" (this will be negative) 4. Sum the "Amount" column for rows where Type is "Refund" (also negative) 5. Add those together

The result is your net revenue before deposits. It should roughly match the total of your bank deposits for that month (give or take timing differences at the beginning and end of the month).

Sounds simple, right? It is, the first time. Try doing it for 12 months when you're trying to file your annual taxes. Or try doing it weekly to track your business trends. Or try doing it when you also sell on Gumroad and need to combine the numbers.

The spreadsheet trap

Here's what I did for about eight months. I set up a Google Sheet with monthly tabs. Every month, I'd download the Etsy CSV, clean it up, paste it into my sheet, and add formulas to calculate net revenue, fee totals, and per-product breakdowns.

Month one: took about 45 minutes. Fine.

Month two: same thing. I also added a comparison to month one. Now my sheet has two tabs.

Month three: I added a "yearly summary" tab with charts. Took 90 minutes because I had to fix the chart formatting.

Month six: my sheet had 8 tabs, the formulas were breaking because Etsy changed a column name in their CSV export, and I spent an entire Sunday afternoon fixing it instead of making products.

Month eight: I missed two weeks of updates because I was busy. Went back to catch up and realized I'd been double-counting some transactions because of how Etsy splits orders with multiple items across rows.

I know sellers who have maintained these spreadsheets for years. I respect the dedication. But I also know that most of them have errors they don't know about, because the Etsy CSV format is just weird enough to create subtle mistakes.

The numbers that actually matter for your business

Once you have your real net revenue (however you track it), here are the numbers worth watching:

Net revenue trend (monthly). Not "did I make more than last month?" but "what's the 3-month average doing?" Monthly numbers bounce around. Trends tell you if your business is growing.Fee percentage. Take your total fees, divide by gross revenue. For most Etsy digital product sellers, this should be 11-15%. If it's higher, check your offsite ads rate — you might be getting hit more than average. If it's above 18%, something might be wrong.Net revenue per product. Which products actually make you money after fees? A $10 product with a 14% fee rate nets you $8.60. A $25 product with the same fee rate nets you $21.50. But if the $10 product sells 5x more often, it might still be your best earner. You need the real numbers to know.Refund rate. This one's easy to ignore because refunds are relatively rare for digital products. But if your refund rate is above 2-3%, you have a product quality or customer expectation problem. And every refund costs you — you don't get the listing fee back, and you lose the revenue.Revenue per hour. This is the one nobody tracks but everybody should. Take your net revenue for the month. Divide by the hours you spent on your Etsy business (creating products, managing listings, customer service, social media). If the number is below your day job hourly rate, that's useful information.

Why this matters for taxes (seriously)

I'm not a tax professional and this isn't tax advice. But here's what I've learned from my own experience and my accountant's repeated frustrated sighs:

Etsy sends you a 1099-K if you exceed $600 in gross sales (this threshold dropped from $20,000 to $600 in recent years). The 1099-K shows your gross revenue. The IRS gets a copy.

If you report a lower number on your tax return than what the 1099-K shows, you'd better have documentation for the difference. That documentation is your fees. Every transaction fee, listing fee, processing fee, and offsite ads fee is a deductible business expense.

If you've been running a spreadsheet, you need those numbers to be right. If they're wrong, you either overpay taxes (common) or underpay them (risky). Most sellers overpay because they don't bother deducting all their fees and just report the gross number as income.

On $60,000 in gross Etsy revenue, your fees might be $8,000-9,000. At a 25% tax rate, properly deducting those fees saves you $2,000-2,250 in taxes. That's real money.

A better approach than spreadsheets

I'm biased here, so take this with a grain of salt. But after spending eight months on the spreadsheet approach and burning entire weekends on data entry and formula debugging, I built Anlyzo specifically to solve this problem.

It connects to your Etsy (and Gumroad) accounts, pulls in transaction data automatically, and calculates your net revenue after every fee type. No CSV downloads. No manual data entry. No formulas that break when Etsy changes their export format.

It's not the only way to solve this. You could use a bookkeeping tool like Wave or QuickBooks, though those require manual categorization of Etsy fees. You could hire a bookkeeper, though that costs $200-500/month. You could keep maintaining a spreadsheet if you enjoy it.

But if you want accurate net revenue numbers without the weekly homework assignment, that's what Anlyzo does. The fee calculations alone — knowing exactly what Etsy took from each sale, including the offsite ads charges — have saved me from making pricing mistakes that would have cost me more than the tool.

Whatever method you use, please stop running your business on the gross number Etsy shows you. Your real revenue is lower. Know how much lower, and make decisions based on that.