◧ ShopTallyShopTally home

How to read your Etsy monthly statement CSV

Your Etsy monthly statement lists every sale, fee, tax line, refund and bank deposit for the month. Read it wrong and your profit looks bigger or smaller than it really is. This guide explains each column and each kind of row.

Where to download it

In Etsy, open Shop Manager → Finances → Monthly statements. Choose a month, then click Download CSV. You get one file per month. Open it in Excel, Google Sheets or any text editor. Etsy may change the layout of these pages over time, so if the menu names differ, look for Finances and then statements.

The columns

ColumnWhat it means
DateThe day the entry was recorded, not always the day the buyer ordered.
TypeThe kind of row: Sale, Fee, Tax, Refund, Marketing, Shipping, VAT, Deposit and so on. This is the most useful column for sorting.
TitleA short description, such as "Transaction fee: Ceramic Mug" or "Processing fee". Titles help tell apart fees that share the same Type.
InfoA reference such as an order number, listing number or label number. Use it to match fees back to a sale.
CurrencyThe currency of that row. Shops selling in more than one currency need to total each separately.
AmountThe gross money in. Usually filled for sales and refunds, and shown as "--" for most fees.
Fees & TaxesThe money taken out for fees, taxes and charges. Shown as "--" on rows that have none.
NetWhat the row does to your balance. For most rows this is Amount plus Fees & Taxes.
Tax DetailsExtra tax information where Etsy provides it. Often "--".

The row types

TypeWhat it isCounts toward profit?
SalePayment for an order, shown as "Payment for Order #...".Yes, as income (see the tax note below).
FeeTransaction fees, processing fees, listing and auto-renew fees, regulatory operating fees, Etsy Plus. Also fee credits.Yes, as a cost.
TaxSales tax or VAT paid by the buyer that Etsy collects for the government.No. It is not your income.
RefundMoney returned to a buyer.Yes, reduces income.
MarketingEtsy Ads and Offsite Ads charges.Yes, as a cost.
ShippingShipping labels bought through Etsy, and label adjustments.Yes, as a cost.
VATVAT or similar tax charged on Etsy's own fees, in countries where it applies.Yes, as a cost of the fees.
Deposit / PaymentMoney sent to your bank, or a payment you made to Etsy for a bill.No. It moves cash, it does not earn it.

Rows with an unfamiliar Type, such as an adjustment, deserve a manual look. Do not guess which bucket they belong in.

A small example

Here is one order, refunded later in the month, plus a bank deposit. It follows the layout of a typical statement (some columns trimmed to fit).

DateTypeTitleAmountFees & TaxesNet
Jan 3SalePayment for Order #3001234567$42.00--$42.00
Jan 3TaxSales tax paid by buyer---$2.80-$2.80
Jan 3FeeTransaction fee: Ceramic Mug---$2.55-$2.55
Jan 3FeeProcessing fee---$1.52-$1.52
Jan 3FeeAuto-renew sold---$0.20-$0.20
Jan 4ShippingUSPS shipping label---$6.15-$6.15
Jan 20RefundRefund to buyer for Order #3001234567-$42.00---$42.00
Jan 20FeeCredit for transaction fee--$2.55$2.55
Jan 20TaxRefund of sales tax paid by buyer--$2.80$2.80
Jan 25Deposit$1,000.00 sent to your bank account------

Exact signs and wording can differ between statements and countries. Treat this as an illustration of the pattern.

Why sales tax rows are not income

When a buyer pays sales tax or VAT, Etsy collects it and passes it on to the tax authority. It is not revenue for your shop. If you add up every positive number and call it sales, a tax-heavy month will make you look better off than you are. Keep Tax rows in their own pile and leave them out of income and costs. In the example above, the tax paid and the tax refunded cancel out.

Why deposits are not profit

A Deposit row is Etsy paying your earnings to your bank. Those earnings already appeared as Sale rows, less fees. A deposit also depends on timing and reserves, so a month's deposits rarely match that month's sales. Profit comes from sales minus fees, ads, shipping, refunds and your own costs. Deposits only tell you where the cash went.

Fee credits on refunds

A refund returns the buyer's money, and Etsy may credit back part of the fees on that order. In the example, the $2.55 transaction fee comes back as a positive Fee row, and the sales tax is returned too. Notice what is not returned there: the processing fee and the shipping label. A refunded sale can still cost you money. When you add up fees, include the positive credits so they offset the original charges.

A quick checklist for any month

Skip the sorting

ShopTally reads the CSV files, puts every row in the right bucket and shows your profit by month. Everything stays on your computer.

One-time $24. Runs offline in your browser. The free edition shows your latest month only.

Questions

Where do I download the Etsy monthly statement CSV?

In Shop Manager, go to Finances, then Monthly statements. Pick a month and choose Download CSV. Repeat for each month you need.

Is the Amount column my income?

Not by itself. For sales it includes the amount the buyer paid, which can contain sales tax that Etsy collects for the government. Fees, taxes, refunds and deposits sit in other rows.

Why does a deposit row not count as profit?

A deposit is Etsy sending money you already earned to your bank. The sale and fee rows already counted it, so counting the deposit again would double it.

Why do I see positive fee rows after a refund?

When an order is refunded, Etsy can credit back some fees, such as the transaction fee. These show as positive amounts in the Fees & Taxes and Net columns. Check each fee against your own records, because not every fee is returned.

Can I read the statement without a spreadsheet?

Yes. ShopTally reads the CSV files and sorts every row into sales, tax, fees, marketing, shipping, refunds or non-profit transfers, then shows profit by month.