Does QuickBooks Online sync with Etsy?

There are connectors that pull Etsy orders into QBO, and most of them work from order data rather than from the Etsy payment account statement. That is where the gap is, because listing fees, Offsite Ads, currency conversion, and label purchases are drawn against the payment account and never appear on an order. Closing from the payment account statement is what makes the deposit tie out.

How do I record Etsy Offsite Ads fees in QuickBooks Online?

As an advertising expense in its own account, dated when the fee posts to the payment account rather than when the order shipped. Attribution can attach the fee after the sale, so the charge and the order it relates to sometimes sit in different months. Keeping it separate from transaction fees means a spike in advertising reads as a spike in advertising, not as an unexplained rise in commission.

What's the difference between the Etsy deposit and the Etsy payment account?

The payment account is the running ledger where sales land and fees are drawn as they occur. The deposit is a sweep of available funds to your bank on whatever schedule you picked. Fees are already gone by the time the deposit happens, which is why the deposit is always smaller than sales and why the payment account statement, not the bank, is the document you close from.

Do Etsy listing fees belong in cost of sales?

Usually not, and this one is worth getting right. A listing fee is charged for having the listing, whether it sells or not, so it behaves like an operating cost of running the shop rather than a cost attached to a sale. The auto-renew charge on a sold item blurs the line, but keeping all listing fees in one selling-fees expense account keeps the treatment consistent and the trend readable.

Does QuickBooks Online import marketplace settlements natively?

No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.

Should I use a journal entry or individual sales receipts in QuickBooks Online?

Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Integrations

Etsy QuickBooks Online integration, reconciled to the penny

BeanHawk turns every Etsy payout into a clean, summarized QuickBooks Online journal: sales, fees, refunds, and taxes mapped to the right accounts, reconciled against the deposit that actually hit your bank.

Why Etsy books break in QuickBooks Online

•Etsy deposits net out listing fees, transaction fees, payment processing, and Offsite Ads, so a single 'Etsy income' line hides your real margin.
•Etsy is a marketplace facilitator for sales tax in most states, and facilitator tax must bypass your revenue.
•Offsite Ads fees only hit on attributed sales, so they swing month to month and deserve their own line.

How the integration works

1
Connect Etsy
Secure, read-only authorization in about 60 seconds. Multiple accounts and marketplaces supported.
2
Connect QuickBooks Online
OAuth connection with professional default account mappings you (or your accountant) can adjust.
3
Review the first journal
BeanHawk parses each payout line by line and builds one summarized journal that must balance to the penny, or it will not post.
4
Reconcile in one click
The net deposit lands in a clearing account that matches your bank feed exactly. Every Etsy payout, accounted for.

Where each Etsy payout line belongs in QuickBooks Online

On the payout	Account	Why it matters
Item sales	Revenue: product sales	The Etsy payment account records the sale in full before fees are drawn against it. Booking only the deposit understates revenue and buries every fee type in one unexplained difference.
Shipping charged to the buyer	Revenue: shipping income	Etsy charges transaction fee on shipping as well as on the item. Without a separate line you cannot see whether shipping is priced above the label plus the fee it attracts.
Listing fees, including the auto-renew charge that fires when an item sells	Operating expense: listing and selling fees	Listing fees are charged per listing whether or not it sells, so they behave like a fixed cost of shop size. Buried in commission they make a large, slow-moving catalogue look cheaper to keep than it is.
Transaction fee on item price and shipping	Cost of sales: marketplace commission	This is the per-sale cut and it belongs against the sale. In overhead it disappears from unit economics, which for low-priced handmade items is where the entire margin question lives.
Etsy Payments processing fee	Cost of sales or operating expense: merchant fees	It is a separate charge from the transaction fee and it varies by country. Merged together, you lose the ability to check either rate against the current schedule when something looks off.
Offsite Ads fee on attributed orders	Operating expense: advertising	It only charges when a sale is attributed to an Etsy-placed external ad, so it lands unevenly and can attach to an order after the fact. Mixed into commission it makes fees look erratic instead of explainable. Keep onsite Etsy Ads, which charge against a daily budget whether anything sells or not, in a separate account again, because the two behave nothing alike.
Shipping labels purchased through Etsy	Cost of sales: shipping and postage	Labels are drawn from the payment account rather than billed to a card. Unmapped, postage looks understated and shipping income looks like profit.
Refunds issued to buyers	Contra-revenue: refunds and returns	Netting them against sales erases return rate per listing. On handmade and personalised items that rate is your quality signal, not just an accounting detail.
Marketplace facilitator sales tax collected by Etsy	Pass-through tax account that nets to zero	Etsy collects and remits it, so it is not income and not your liability. In revenue it overstates the shop's earnings and pollutes any tax estimate built from the profit and loss.
Payment account balance held before deposit	Balance sheet: Etsy payment account clearing (asset)	Money sitting in the Etsy payment account is yours and it is not in the bank. Without a clearing account, every month end leaves a difference that nobody can prove.

How a month actually closes on Etsy

Etsy works differently from a settlement marketplace, and that difference drives the whole close. Sales and fees flow continuously into your Etsy payment account, and a deposit is just a sweep of whatever is available on your chosen schedule. Deposits are not periods. The monthly statement from the payment account is the source document, and the deposit is only evidence the cash moved.

Download the monthly payment account statement and group rows by type: sale, fee, tax, refund, shipping label, deposit. Post a summarized journal for the month from those groups, and let the deposits clear the payment account clearing balance. That clearing balance at month end should equal the balance Etsy shows in your payment account on the same date, and it is worth checking that literally rather than assuming.

New shops and shops with a policy flag often have a hold or a longer deposit schedule, and sellers can choose daily, weekly, biweekly, or monthly deposits. All of those change when cash arrives and none of them change when the sale happened. If you switch deposit schedules mid-month, expect the clearing balance to jump, and expect it to be correct.

Offsite Ads is the line that breaks month comparisons. The fee only applies to orders Etsy attributes to an ad it placed, and attribution can land after the order date, so a quiet month for ads can carry fees from a busy one. Give it its own account, expect volatility, and resist the urge to smooth it, because the volatility is the information.

Listing fees accrue on a rhythm of their own. A listing renews when it expires or when it sells, so a shop with a big catalogue posts listing fee charges continuously regardless of sales. Comparing listing fees to revenue in a slow month is how sellers discover that catalogue size, not sales, is driving that cost.

The closing test is that item sales plus shipping income, minus fees, minus refunds, minus labels, minus tax passed through, equals the change in the payment account balance plus deposits taken. If the number is close but not exact, look at currency conversion rows first on international shops, and at refunds that crossed the month boundary second.

What QuickBooks Online does well, and where it needs help

BeanHawk posts into QuickBooks Online as a summarized Journal Entry per settlement period rather than as individual sales receipts. A QBO journal entry carries one date and has to balance to the penny, so we date it at the period end, put the settlement identifier in the memo, and keep SKU-level detail in our own subledger. That keeps QBO fast and keeps an auditor able to trace any number back to a source document.

The step people get wrong is the bank feed. When the marketplace deposit appears in QBO, it must be matched to the entry already sitting in the clearing account, never added. Clicking Add creates a second income transaction and doubles revenue for that deposit. If your revenue looks roughly twice what you expect, this is almost always the cause, and the fix is to find the added transactions and undo them rather than to adjust the journal.

Class and location tracking, which is how most sellers separate channels inside one company file, is available on the higher QuickBooks Online plans rather than every plan, and Intuit has changed plan naming and inclusions over time. Check what your current subscription includes. If classes are not available to you, the workable alternative is a separate set of income and fee accounts per channel: uglier in the chart of accounts, but it works on any plan and it reports cleanly.

QuickBooks Online's built-in inventory uses FIFO and has no native landed cost handling, so freight, duty, and prep costs cannot be pushed into unit cost inside QBO itself. High-volume sellers usually stop fighting this and keep perpetual SKU valuation in a subledger, posting a periodic inventory and cost of goods sold journal instead. That is the approach BeanHawk takes, which is also why our journals stay small enough for QBO to handle at scale.

Automated Sales Tax in QBO is built for tax you collect and owe. Marketplace facilitator tax is neither, so routing it through the sales tax module invites QBO to include it in a liability you do not have. Send facilitator tax to a pass-through account that nets to zero within the same journal, and keep your own nexus tax, if any, in the sales tax module where it belongs.

One reporting quirk worth knowing before you panic: journal entries are accrual transactions, so a cash-basis profit and loss in QBO can present summarized marketplace journals in ways that look wrong at first glance. Run the accrual view when checking a settlement, and reconcile the clearing account rather than reading the bank balance, since the clearing account is where the timing difference is supposed to live.

Frequently asked questions

Does QuickBooks Online sync with Etsy?: There are connectors that pull Etsy orders into QBO, and most of them work from order data rather than from the Etsy payment account statement. That is where the gap is, because listing fees, Offsite Ads, currency conversion, and label purchases are drawn against the payment account and never appear on an order. Closing from the payment account statement is what makes the deposit tie out.
How do I record Etsy Offsite Ads fees in QuickBooks Online?: As an advertising expense in its own account, dated when the fee posts to the payment account rather than when the order shipped. Attribution can attach the fee after the sale, so the charge and the order it relates to sometimes sit in different months. Keeping it separate from transaction fees means a spike in advertising reads as a spike in advertising, not as an unexplained rise in commission.
What's the difference between the Etsy deposit and the Etsy payment account?: The payment account is the running ledger where sales land and fees are drawn as they occur. The deposit is a sweep of available funds to your bank on whatever schedule you picked. Fees are already gone by the time the deposit happens, which is why the deposit is always smaller than sales and why the payment account statement, not the bank, is the document you close from.
Do Etsy listing fees belong in cost of sales?: Usually not, and this one is worth getting right. A listing fee is charged for having the listing, whether it sells or not, so it behaves like an operating cost of running the shop rather than a cost attached to a sale. The auto-renew charge on a sold item blurs the line, but keeping all listing fees in one selling-fees expense account keeps the treatment consistent and the trend readable.
Does QuickBooks Online import marketplace settlements natively?: No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.
Should I use a journal entry or individual sales receipts in QuickBooks Online?: Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Connect Etsy to QuickBooks Online free

Start with the free reimbursement audit, then flat all-channel pricing from $19/mo. No per-channel fees.

Also see: Amazon + QuickBooks Online · Amazon + Xero · eBay + QuickBooks Online · eBay + Xero · all guides