Bring the deposit in.
Download the payment account CSV from Etsy’s Finances and drop it in. A direct Etsy connection is in progress — meanwhile the CSV workflow covers everything, line by line, with a trail back to the source file.
Etsy to
QuickBooks Online.
Etsy’s Monday deposit mixes sales with listing, transaction and processing fees, Offsite Ads, labels and collected tax. TidyPayouts reads your payment account CSV, maps every line, and posts one reviewed journal entry that matches the deposit to the penny.
CSV · CONNECTION IN PROGRESS✓ Free during beta✓ Review before posting
EtsyPayment account CSV
TidyPayoutsBreakdown · mapping · review
QuickBooks OnlineOne journal entry per depositWHAT’S INSIDE AN ETSY DEPOSIT.The whole deposit,
The whole deposit,
line by line.
Small fees add up.
Give each one an account.
- ↳SalesItem and shipping revenue — physical and digital — for orders in the deposit.
- ⚖Transaction & listing feesThe 6.5% transaction fee and $0.20 listing fees, kept separate from processing.
- %Processing feesEtsy Payments processing on each order — and on refunds, where it applies.
- ✦Offsite AdsOffsite Ads fees when they apply, so ad spend never hides inside “Etsy fees.”
- ↩RefundsRefunded orders, with the fees Etsy returns tracked alongside.
- ◫Shipping labelsEtsy labels bought through the shop, mapped to shipping expense.
- ≋Sales tax & VATTax and VAT Etsy collects on your behalf — liability or pass-through, never income.
- ◎Deposit cadenceWeekly Monday deposits (daily for established shops), each reconciled to its bank amount.
FOUR STEPS. EVERY DEPOSIT.From deposit to
From deposit to
journal entry, in order.
Set it up once.
Then it’s just review and post.
Give every line an account.
Map each line type to an account in your QuickBooks chart of accounts — sales, listing and transaction fees, processing, Offsite Ads, labels, tax. Mappings are reusable: set them once, and every future deposit follows.
Check it against the deposit.
Resolve unmapped lines, look over Offsite Ads activity, and compare the net against the payment that actually arrived. Nothing posts until you approve it.
Send it to QuickBooks.
One balanced journal entry, dated the deposit date, nets to the penny of your bank feed. Reversible and re-postable if you change a mapping later.
WHAT LANDS IN YOUR BOOKS.One entry.
One entry.
Every dollar explained.
Your P&L shows real Etsy margins —
every fee named and counted.
Example: a $1,848.75 deposit
ILLUSTRATIVE · SAMPLE DATA| Account (as you mapped it) | Debit | Credit |
|---|---|---|
| Checking account the deposit itself | $1,848.75 | |
| Refunds & returns refunded orders | $74.00 | |
| Etsy fees listing, transaction, processing | $187.30 | |
| Advertising — Offsite Ads when it applies | $39.95 | |
| Sales — Etsy item and shipping revenue | $2,150.00 | |
| Totals | $2,150.00 | $2,150.00 |
One journal entry per deposit, dated the deposit date. The entry nets to $1,848.75 — the amount that hit the bank — so QuickBooks’ bank feed matches without manual reconciling. Labels and marketplace-collected tax or VAT, when present, get their own mapped lines. Made a mistake or changed a mapping? Entries can be reversed and re-posted without losing the trail back to the source report.
THE SETUP GUIDE.Set it up in
Set it up in
an afternoon.
Most of this is one-time work.
After that, a deposit takes minutes.
Create your TidyPayouts account
Join the free beta with your email — no credit card, every plan is free while we’re in beta.
Connect QuickBooks Online
In the app, go to
Settings → Account settingsand connect QuickBooks with your Intuit login. Owner access in TidyPayouts is required, and the connection syncs your chart of accounts so mapping uses your real account names. Availability is rolling out during beta; check connection status inside the app.Download your Etsy payment CSVs
In Shop Manager, go to
Finances → Payment accountand download the CSV for the deposit or date range you need. Import it into TidyPayouts; each deposit becomes its own review. A direct Etsy connection is in progress and will replace the download when it reaches your account.Map your line types
Assign each line type — sales, listing and transaction fees, processing, Offsite Ads, labels, refunds, tax and VAT — to an account. Sensible defaults get you most of the way; adjust anything to match your chart.
Review the deposit
Compare the net against the actual payment, look over Offsite Ads and refunds, and add product costs if you track COGS. Unmapped lines are held out (and clearly listed) rather than guessed into an account.
Post, then match the deposit
Send the journal entry to QuickBooks, then match the payment in your bank feed. Done — on to the next Monday deposit, with the whole trail kept for review.
How do I export my Etsy payment data?+
In Shop Manager, go to Finances → Payment account and download the CSV for the deposit or date range you need — monthly statements and the VAT statement are there too. Import it into TidyPayouts and the deposit is broken down into sales, fees, Offsite Ads, refunds, labels and tax.
Does it handle the sales tax and VAT Etsy collects?+
Yes. Where Etsy collects VAT or sales tax on your behalf, it is imported as its own line type and mapped to a liability account — or excluded as a pure pass-through, if that’s how your bookkeeper treats marketplace-collected tax. Either way it never inflates your income.
Are digital downloads included?+
Yes. Digital sales flow through Etsy Payments just like physical orders, so they appear in your sales lines with their fees attached. Product costs simply stay empty unless you assign them.
Is the QuickBooks connection available now?+
The QuickBooks connection is part of the beta and availability is rolling out by account. Etsy deposits use the CSV import workflow today, and a direct Etsy connection is in progress — you can move to it as soon as it’s offered to your account. Check connection status inside the app before relying on a live import or post.
Can my bookkeeper double-check before anything posts?+
Yes — that’s the point. Summaries, mappings and source records are all reviewable, and nothing posts until someone approves it. If a posted entry needs to change, it’s reversed and re-posted rather than edited behind the scenes.
OTHER CHANNELS, SAME IDEA.More pairs,
More pairs,
same tidy path.
Bring every channel into the same
QuickBooks workflow.
Amazon to QuickBooks
Settlement flat files or the beta connection: referral and FBA fees, storage, advertising, reserves.
Read the Amazon guide →
Shopify to QuickBooks
Payout reports from Shopify Payments: gross sales, refunds, processing fees and reserves.
Read the Shopify guide →
eBay to QuickBooks
Final value fees, Promoted Listings, labels and dispute holds from Seller Hub CSVs.
Read the eBay guide →
Walmart to QuickBooks
Referral and WFS fees, returns, adjustments and chargebacks from Seller Center.
Read the Walmart guide →Your deposits,
already sorted.
The next Monday deposit doesn’t have to be a mystery payment.
Start your free beta →Free during beta. No credit card. A little more breathing room.