What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Etsy QuickBooks Payouts
QuickBooks + Etsy

Etsy and QuickBooks: Where the Missing Money in Each Payout Went

Say the week's Etsy orders came to $696 and the bank got $574.78. Nothing was stolen. Etsy took a transaction fee, a processing fee, listing renewals, an Offsite Ads charge and a refund from an older order before the money left, and kept the sales tax it pays to the states for you. Getting Etsy orders into QuickBooks is the easy part. Making each deposit agree with them is where the hours go.

Twelve Etsy orders, one deposit

Each fee is worked out differently, and they all come off before Etsy pays you.

Example payout · US shop, 12 orders in one week
Item sales $612.00
Shipping charged to buyers (Counts toward the transaction fee) + $84.00
Transaction fees, 6.5% (On the order total, shipping included) − $45.24
Payment processing, 3% + $0.25 per order (US rate; other countries differ) − $23.88
Listing renewals after sale, $0.20 each − $2.40
Offsite Ads fee, one order (Only on sales that came from an Etsy ad) − $8.70
Refund on last week's order (Belongs to an earlier payout) − $41.00
Deposit to your bank $574.78

Sales tax isn't in this ledger because in most US states Etsy collects and remits it as the marketplace. It shows on the order, but it never reaches you and you don't file it.

Getting Etsy into QuickBooks: three ways, by shop size

Your shop A setup that tends to hold Still on your plate
A few dozen orders a month, one currency Intuit's Etsy Connector, added from the integrations in QuickBooks Online. It brings in each order's net amount, fees, taxes, discounts, products and customer, and you choose which accounts payments and fees post to. It works order by order, not payout by payout, so you still match each deposit yourself. Sales receipts don't import until the order is fully paid.
Weekly payouts and a bookkeeper who wants deposits to match A2X or a similar payout tool, which posts one summarized entry each time Etsy pays you out, so the entry equals the deposit. Summaries by payout, not item-level cost of goods. Inventory and product margin need another layer.
Etsy plus Shopify, wholesale or craft fairs, several shops, or sales in other currencies A custom sync that treats Etsy as one channel among several and posts to one set of accounts. This is the setup n-frames builds when off-the-shelf connectors disagree about stock, fees or currency.
Only a handful of sales a month Download the monthly CSV from your Etsy payment account and record it as one entry. Fine until it isn't. Past a few dozen orders, the hour a month becomes a day.

Etsy entries that throw off the QuickBooks numbers

Sales tax Etsy already paid, booked as your liability

How you'll know: Your sales tax report in QuickBooks shows tax owed on Etsy orders you never collected a penny of.

Fix: Map Etsy's remitted tax to a non-filing tax rate or clearing account, not the rate you file with the state. Get your accountant to confirm which states apply to you. Our paying sales tax guide covers the QuickBooks side.

Listing currency different from your bank currency

How you'll know: You list in dollars, get paid in pounds or euros (or the other way round), and every payout is off by a little more than the fees explain.

Fix: Etsy converts the money and charges for doing it, and that charge is easy to miss in the payment account. Book the conversion as its own expense line, and switch on multicurrency in QuickBooks before the first foreign deposit if you hold more than one currency.

Refunds landing in the wrong period

How you'll know: A month's sales look fine, then next month shows a refund for an order nobody remembers.

Fix: Etsy takes a refund from whichever payout comes next. Record it against the original sale's income account, dated when Etsy took it, so the deposit still reconciles.

Fees subtracted from sales instead of recorded as expenses

How you'll know: Revenue on your Profit and Loss is lower than Etsy's sales report, and you can't tell what Etsy costs you.

Fix: Post gross sales as income and each fee type to its own expense account. That way you can see what Offsite Ads or processing fees really cost in a year.

A handmade shop that stopped checking payouts line by line

A shop selling handmade goods on Etsy, books in QuickBooks Online.

Before

Intuit's connector was already bringing every order in reliably, with its listing and transaction fees attached.

Etsy paid out every few days after taking processing fees and the odd refund, so no deposit matched any report the owner could pull.

Most weeks the owner opened Etsy's payment account page and cross-checked each payout against QuickBooks by hand.

After

n-frames built a sync that reads each Etsy payout when it's issued and breaks it into the orders, fees and refunds inside it.

It matches that total to the deposit in the QuickBooks bank feed automatically.

The owner stopped reconciling payouts by hand and could see, order by order, what Etsy kept.

Etsy sellers ask about QuickBooks

Does Etsy integrate with QuickBooks?

Yes, through Intuit's Etsy Connector for QuickBooks Online, which imports order details, fees, taxes, discounts, products and customers, and lets you pick the accounts payments and fees post to. Intuit's help pages describe order import, not payout matching, so reconciling each deposit is still a separate step.

What is the best QuickBooks setup for Etsy sellers specifically?

QuickBooks Online with Intuit's connector for a small shop, plus a payout tool like A2X once matching deposits takes real time each week. Either way, set up separate expense accounts for each Etsy fee type and a clearing account for payouts before the first sync, because changing the mapping later means fixing everything already imported.

What accounting software should Etsy sellers use for bookkeeping?

Most sellers who outgrow a spreadsheet pick QuickBooks Online, largely because most bookkeepers and tax preparers already work in it. The bigger decision is the connector: it decides whether fees, remitted tax and refunds land in QuickBooks the way your accountant expects.

What is A2X, and does my Etsy shop need it?

A2X is a third-party app that turns each Etsy payout into one summarized entry in QuickBooks, so the entry equals what reached your bank. A shop with a few orders a week can usually manage with Intuit's connector and a monthly check. Once matching deposits eats an afternoon each cycle, it's worth adding.

Why doesn't my QuickBooks balance match my Etsy payout?

Because the payout is sales plus shipping, minus transaction, processing, listing and any ad fees, minus refunds that may belong to earlier orders, and sometimes converted to another currency. Sales tax Etsy remits never arrives at all. If your connector imports orders but not payouts, QuickBooks sees the orders and the deposit as two unrelated things.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.