n-QuickBooks + Etsy Integration: Why Your Payout Never Matches Your Sales
Intuit has a native, if aging, Etsy Connector for QuickBooks Online that imports orders, fees, and taxes automatically. It's a real connector, not a workaround, but it doesn't reconcile your Etsy payout against your bank deposit. That's the hard part: Etsy deducts listing fees, transaction fees, and payment processing fees separately before it ever pays you out.
How people usually connect them
Intuit's own Etsy Connector. A native app for QuickBooks Online, not a third-party workaround, that imports Etsy orders, fees, and taxes automatically. It's listed as a legacy integration with a newer version in the works, and it covers the basics of getting sales data in without manual entry.
A2X, or a similar third-party sync tool. Built specifically for the job the official connector doesn't finish: it takes an Etsy payout apart into the sales, fees, and refunds behind it and posts a journal entry that matches what actually lands in your bank account, the way Intuit's own connectors for Square or PayPal already do for those platforms.
Manual entry from Etsy's own reports. Smaller shops sometimes still pull a CSV of orders or a payment account ledger from Etsy's Shop Manager and enter it by hand, workable at a handful of sales a month and a real time cost past that.
Where the payout stops matching the sales
Etsy doesn't pay out your full sale price. It deducts a listing fee ($0.20, charged when you list, renew, or sell a multi-quantity item), a transaction fee (6.5% of the sale total including shipping), and a payment processing fee (3% plus $0.25 per transaction for US sellers), plus an offsite ads fee on the rare sale that comes through one of Etsy's ads. Three separate fee types, each calculated differently, batched into one payout that doesn't correspond to any single day's sales.
Intuit's connector gets orders, fees, and taxes into QuickBooks. It doesn't match the resulting payout against what actually hits your bank feed, which means someone still has to confirm the deposit QuickBooks sees is really what that batch of orders, minus those three fee types and any refunds, should add up to. That reconciliation, not the basic order import, is the part that eats an afternoon every payout cycle.
What we've built on top of QuickBooks and Etsy
A shop selling handmade goods on Etsy had the official connector pulling orders into QuickBooks reliably, every sale showed up with its listing fee and transaction fee already logged. The payout itself was a different story. Etsy batches payouts every few days, after deducting payment processing fees and the occasional refund on top of what the connector had already recorded, so the deposit that hit the bank never matched any report the owner could pull directly, and figuring out whether a given payout was actually correct meant cross-referencing Etsy's own payment account page by hand, line by line, most weeks.
We built a sync that reads each Etsy payout as it's issued, breaks it into the orders, fees, and refunds that make it up, and matches the total against the deposit QuickBooks sees from the bank feed automatically. The owner stopped reconciling payouts by hand and started seeing, order by order, exactly what Etsy actually kept.
Selling on Etsy and still reconciling your payouts by hand?
Tell us where the mismatch actually shows up, listing fees, transaction fees, payment processing, offsite ads, whatever it is, and we'll tell you if it can reconcile itself. And if Etsy isn't the shop you're actually running, that's fine too, we build on top of whatever platform your sales come through.
Let's talk