Reconcile Etsy Deposits to Your Bank Statement

TL;DR An Etsy deposit on your bank statement is the net balance of your Etsy payment account at the time of the deposit, not a sum of orders. Sales go into the payment account; Etsy's fees, refunds, shipping labels, advertising and any reserve are taken out; and what's left is deposited on your schedule. To reconcile, match each deposit to the deposit line in your Etsy payment account, then rebuild what happened inside the payment account for the month: opening balance, plus sales, minus fees and other charges, minus deposits, equals closing balance. Record gross sales and each type of fee separately in your books, and treat any sales tax Etsy collects and remits as a marketplace as not your revenue.

Etsy is a great channel for makers, vintage sellers and small creative businesses, but its money flow confuses most people the first time they try to do the books. Sales come in one by one, fees appear in several different flavours, shipping labels are bought out of the same balance, and the bank only ever sees a handful of deposits with round-looking but meaningless numbers.

If you record each deposit as "Etsy sales", your income is understated, all of the fees vanish from your expenses, and you can't tell whether a product line is profitable. This guide shows how to reconcile Etsy properly: how the payment account works in general terms, what to download, a step-by-step method, a worked example, and the odd situations that trip people up. Etsy's Shop Manager and reports change over time and vary by country, so we describe them generally rather than giving exact click-paths.

How the Etsy payment account works

Think of your Etsy payment account as a small bank account that Etsy runs for your shop.

• Money in: customer payments for orders processed through Etsy's payment system, including the item price, shipping charged, and in some cases tax collected.
• Money out: Etsy's fees (such as listing, transaction and payment processing fees), refunds to buyers, shipping labels bought through Etsy, advertising charges, and other services you use.
• Holds and reserves: in some situations, part of your balance may be held for a period, for example on newer shops or after disputes.
• Deposits: on your chosen schedule, where available, Etsy sends the available balance to your bank account.

Because fees and labels are taken from the same balance as sales, a deposit is whatever was left after all of that. It doesn't line up with any particular set of orders.

There's also a possibility of money going the other way. If fees exceed sales in a period, Etsy may charge the card or bank account on file. Those charges appear on your bank or card statement, not as a negative deposit, so you'll need to look for them separately.

What to download

• Bank statements for the month, converted to a spreadsheet. SheetStatement converts PDF statements to Excel or CSV and checks opening and closing balances, so you know you have every deposit. The free plan covers 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans handle more.
• Your Etsy payment account activity for the month, ideally as a downloadable file. Etsy generally provides monthly statements or activity downloads that list sales, fees, refunds, labels, deposits and their dates.
• Your Etsy orders or sales report, which gives detail by order, useful for checking gross sales and tax.
• Your books, in accounting software or a spreadsheet ledger.

Make sure the bank statements reconcile first: opening balance plus all transactions equals closing balance. Our guide to reconciling a bank statement in Excel covers that check.

Step 1: match deposits

On the bank side, filter for deposits from Etsy. On the Etsy side, filter the payment account activity for deposit lines. You'll usually have only a few per month, depending on your deposit schedule.

The amounts should be identical. Bank dates are typically on or a few business days after the Etsy deposit date. If you have many deposits, use an XLOOKUP match within a date window; our guide to matching bank transactions with XLOOKUP shows how.

Any Etsy deposit without a bank match at month end is likely in transit. Check the first few days of the next statement.

Step 2: rebuild the payment account for the month

This is the step that turns a vague reconciliation into a reliable one. Using the payment account activity, summarise the month by type:

Then check it against the closing balance Etsy reports:

=ROUND(Opening + SUM(Movements) - Closing, 2)

If the payment account activity download has one row per entry, add a Type column and summarise with SUMIFS:

=SUMIFS(Activity[Amount], Activity[Type], "Transaction fee", Activity[Month], "2026-05")

How Etsy labels each type of line depends on the report; map its labels to your own categories once and reuse the mapping each month. Our guide to Excel formulas for categorizing transactions shows a lookup-table approach.

Step 3: handle sales tax

In many places, Etsy is treated as a marketplace that collects and remits certain sales taxes on sellers' behalf. In those cases the tax the buyer paid may appear in your reports, but it isn't your money: Etsy sends it to the tax authority, and it's not part of your revenue.

How this appears in your activity depends on your location and the buyer's location. The practical rules:

• Don't count marketplace-collected tax as sales. If it shows up as part of an order total, back it out.
• Don't count it as an expense either. It passes through.
• If you're responsible for tax on some sales, for example sales tax in jurisdictions where Etsy doesn't collect, or VAT if you're registered, track that separately from the marketplace-collected portion.

Tax rules are complex and change, so treat this as general information, not tax advice, and check with an accountant for your situation.

Step 4: record it in your books

Use a clearing account, for example "Etsy payment account", that mirrors the real balance at Etsy:

1. Record gross sales (excluding marketplace-collected tax) into the clearing account.
2. Record refunds, each fee type, advertising and shipping labels out of the clearing account to the right expense accounts.
3. Record reserves as a movement within Etsy, or as a separate "Etsy reserve" asset if they're material.
4. Record each bank deposit as a transfer from the clearing account to the bank.

At month end, the clearing account balance should equal the closing balance in your Etsy payment account. If it does, your books contain every sale and every fee.

If you use an integration that syncs Etsy into your accounting software, still compare the clearing account to Etsy's closing balance, and make sure the bank feed isn't separately recording deposits as income.

A worked example

A small jewellery shop has one bank account and a weekly Etsy deposit. Here's May, with invented figures.

Etsy payment account summary for May:

Check: 142.30 + 2,860.00 − 64.00 − 186.20 − 97.35 − 18.40 − 42.75 − 211.60 − 2,190.00 = 192.00. The payment account reconciles.

Bank statement deposits from Etsy: four deposits of 512.40, 604.15, 488.05 and 585.40, totalling 2,190.00. They match the four Etsy deposit lines exactly, with bank dates one to two business days after the Etsy dates.

What the books should show for May:

• Sales: $2,860.00, less refunds of $64.00.
• Etsy fees: $186.20 + $97.35 + $18.40 = $301.95.
• Advertising: $42.75.
• Postage: $211.60.
• Transfers from Etsy to bank: $2,190.00.
• Etsy clearing balance at month end: $192.00, matching Etsy.

If the shop had simply booked the four deposits as sales, it would show $2,190 of income and no fees, postage or advertising. Profit might look similar on paper, but you'd have no idea what Etsy was costing you or whether postage was eating your margin, and if you're asked to reconcile your records to a payment processor's tax form, the numbers wouldn't line up.

Awkward cases

Fees charged to your card. If your balance didn't cover fees, Etsy may charge your card or bank. Find those charges on your statements and record them against the clearing account (they settle a negative balance), not as a separate unrelated expense, or you'll count the fees twice.

Reserves. If part of your balance is held, deposits will be smaller than your available sales suggest. Track the reserve as its own line so the clearing account still matches.

Refunds after a deposit. A refund for an order paid out last month reduces this month's balance. That's normal; it's why the clearing account approach works better than trying to match refunds to specific deposits.

Currency conversion. If your shop's currency differs from your bank's, or you sell in other currencies, conversion may happen before deposit. Keep the payment account in its own currency and record the deposit in your bank's currency, with any difference as a currency gain or loss. Our guide to the Wise multi-currency workflow covers similar issues.

Multiple shops. Reconcile each shop's payment account separately, even if they deposit to the same bank account. Add a Shop column on the bank side.

Other platforms. If you also sell through Shopify, Amazon or in person with a card reader, each platform has its own clearing account. See our guides to reconciling Shopify payouts, reconciling Amazon seller payouts and reconciling Square payouts.

Monthly routine

1. Convert and reconcile the month's bank statement.
2. Download the Etsy payment account activity for the month.
3. Match Etsy deposits to bank deposits; note anything in transit.
4. Summarise the payment account by type and check it against Etsy's closing balance.
5. Remove marketplace-collected tax from sales.
6. Post sales, refunds, fees, advertising, labels and deposits via the clearing account.
7. Confirm the clearing account equals Etsy's closing balance.

It takes a little longer than booking deposits as income, but once the category mapping is set up, most months take only a few minutes, and you get a clear view of what each sale really earns.

Going further: what the reconciliation tells you

Once the payment account reconciles every month, the same data answers questions that deposits alone never could.

What Etsy really costs. Add up transaction fees, processing fees, listing fees and advertising for the month and divide by gross sales:

=SUM(Fees) / Sales

Tracking that ratio month by month shows whether a new advertising setting, a change in your average order size, or a run of cheap listings is quietly pushing costs up. You don't need any outside benchmark for this to be useful; your own trend is the point.

Whether shipping pays for itself. Compare shipping charged to buyers (from the order report) with shipping labels bought through Etsy. If labels consistently cost more than you charge, the gap is coming out of your margin.

Refund patterns. A Refunds line that grows faster than sales is worth investigating, perhaps a product with a quality problem or a listing that sets the wrong expectations.

Cash timing. The closing balance plus any reserve is money you've earned but not yet received. If it's growing, check your deposit schedule and whether a reserve has been applied.

Year-end checks

At the end of the year, a few extra checks make the accountant's job, and your own tax return, much easier:

1. Twelve clearing account balances that each equal Etsy's closing balance for the month.
2. Total deposits for the year in your books equal the total of Etsy deposit lines and the total of Etsy deposits on your bank statements, allowing for in-transit amounts at the start and end of the year.
3. Gross sales for the year in your books are explainable against any tax form you receive, with a short bridge showing refunds, marketplace-collected tax and any other differences.
4. Every card charge from Etsy for fees during the year has been recorded against the clearing account.
5. Original downloads and statements are saved by month, so any figure can be traced back.

If you're catching up on a full year at once, work month by month rather than trying to reconcile the year in one go. Our guide to catching up on months of bookkeeping shows how to break the job down.

Why this matters at tax time

Etsy and its payment partners may issue tax forms showing gross amounts processed, which will be higher than your deposits because fees, refunds and labels were taken out first. If your books only show deposits, the two won't match, and explaining the gap later is harder than recording it correctly now. In the US, our guide to reconciling 1099-K forms with bank deposits explains how to bridge the difference. For a wider view of what to gather for your accountant, see bank statements for tax preparation.

This is general information, not tax advice. Requirements depend on where you live and sell; check with a qualified accountant.

Get your bank deposits into a spreadsheet

The reconciliation starts with a complete list of deposits. Upload your bank statement PDFs to SheetStatement, confirm each statement's opening and closing balances, and export to Excel or CSV. The free plan includes 3 pages a month to try it on a real statement.

FAQ

Why doesn't my Etsy deposit match my sales?

A deposit is the available balance in your Etsy payment account after fees, refunds, shipping labels, advertising and any reserves have been taken out. It isn't a total of particular orders.

Should I record Etsy deposits as income?

Not directly. Record gross sales and each type of fee through a clearing account, and treat deposits as transfers from that account to your bank.

How do I reconcile the Etsy payment account?

Start with the opening balance, add sales, subtract refunds, fees, labels, advertising and deposits, adjust for reserves, and check that the result equals Etsy's closing balance.

Is the sales tax Etsy collects my income?

Where Etsy collects and remits tax as a marketplace, that tax isn't your revenue. Exclude it from sales. This is general information, not tax advice.

What if Etsy charges my card for fees?

Record the card charge as a payment into the Etsy clearing account, settling a negative balance, so the fees aren't counted twice.

Why is an Etsy deposit missing from my bank statement?

It may be in transit at month end, held in a reserve, or sent to a different bank account. Check the next statement and your Etsy deposit history.

Can I do this in Excel or Google Sheets?

Yes. Convert your bank statements, download the Etsy activity, match deposits, and summarise the activity by type with SUMIFS or a pivot table.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.