Etsy to QuickBooks — your Payment account statement, summarized per month
Drop in the Payment account CSV from Shop Manager — get back a QuickBooks-ready .QBO (Web Connect) file.
- One Sales / Refunds / Fees / Other split per month
- Transaction fees, listing renewals, Etsy Ads and shipping labels all split out
- Every deposit reconciled against the activity it paid for
- Processed in memory, never stored — your report never touches a database
Drag & drop your Etsy Payment account CSV here
or
Your report is parsed in memory and immediately discarded — never stored, never logged.
Preview
License active ✓| # | Date | Description | Amount (USD) |
|---|
How it works
Download the statement
Shop Manager → Finances → Payment account → pick the month → CSV. One file covers one month; convert several months one after another (a license covers a whole week).
Check the totals
Each month shows one summary line, and the file-level line reconciles all activity against all deposits: whatever is left over is still sitting in your Etsy balance, not yet deposited.
Export & import
Download QBO, CSV, or XLSX and import into QuickBooks in a couple of clicks. Summary lines are dated on the last day of the month, like a bank statement.
What goes into each line
One month becomes 2–5 booked lines:
The four buckets
Sales — what buyers paid (item + shipping + tax collected at checkout). Refunds — refund amounts back to buyers. Fees — payment processing, the 6.5% transaction fee (including fee refunds), listing and renewal fees, Etsy Ads and Offsite Ads, shipping labels, regulatory operating fees, Etsy Plus. Other — sales tax Etsy remits for you, which washes against the tax included in Sales. Deposit rows are read from their title text ("Deposit $123.45 to your bank account…") and used only for reconciliation — never booked as income.
Frequently asked questions
Which Etsy file exactly does this page take?
The monthly Payment account statement CSV (Shop Manager → Finances → Payment account → month → CSV) — the file with Date, Type, Title, Amount, Fees & Taxes and Net columns. That is the statement your bookkeeping actually reconciles against; the per-order "Etsy Payments sales" export from Download Data is a different report.
Why doesn't a month's net equal that month's deposits?
That's normal, and it's how Etsy pays out: a deposit covers whatever balance had cleared when it was scheduled, so deposits lag the activity they pay for — often by days, across month boundaries. This is why the summary groups by month but reconciles at file level: activity − deposits = still in your Etsy balance. That leftover should match the "Available for deposit" number in Shop Manager.
Why summaries instead of one line per order?
Etsy deposits lump sums, not one payment per order. Per-order imports leave you matching a $51.55 bank deposit against dozens of sales, fees and ad charges — reconciliation never closes. Monthly summaries book the same totals with a few lines, and the deposit check proves nothing was missed.
What do I get for free, and what does the license add?
Parsing and the full preview are free, always. Free export covers the first 25 summary rows — enough to prove the totals end-to-end. A one-time $1.99 license exports all months for 7 days — no subscription, nothing to cancel.
Is my statement uploaded anywhere?
Yes — the report text goes over an encrypted connection to the parser, which runs in memory and discards it the moment your result comes back. Nothing is written to disk, a database, or logs. If a parse ever fails, one masked structural digest (every letter and digit replaced — no readable content) may be kept to fix the parser. Details in the Privacy Policy.
I already paid but lost my license key — what do I do?
Your license key is shown on your Gumroad receipt, which was sent to your inbox right after purchase — search for "Gumroad" and open that receipt to copy the key. Then use the "Enter license key" link in the top navigation to reactivate unlimited exports.