How Do I Reconcile Etsy Payments With My Bank Account?

Who needs this workflow, and what decision does it complete?

This method is for an Etsy shop owner or finance operator whose order sales, Etsy Payment account, and bank deposits do not agree. The decision is whether the Etsy channel can be closed for the month without hiding revenue, fees, refunds, tax collected by the marketplace, or cash still unavailable for deposit. It is designed for a seller using Etsy Payments; Square sales and other external payment paths require separate ledgers.

Search results usually explain how to download a CSV or promote an accounting connector. Etsy's own help pages explain balances and deposits. The missing operating layer is a control that proves the beginning balance, all activity, deposits, and ending balance together. That proof matters because fees can be funded from current sales, a reserve can delay availability, and a deposit schedule can split one accounting month across several bank dates.

What is the five-bucket Etsy payment-account map?

Create one Etsy clearing account for each legal entity and settlement currency. Tag each source line into one of five buckets before posting it. This five-bucket map is the first original-value component.

Do not infer these categories from the net amount. A negative line can be a fee, a refund, a transfer, or a correction; each has a different effect on margin and liabilities. Preserve the original activity type, description, currency, date, and transaction identifier as audit fields.

How do I prove the Etsy balance?

Run this control by month and currency:

Opening Etsy balance + earned credits + pass-through credits - spent charges - reversed amounts +/- reserve and manual movements - deposits initiated = closing Etsy balance.

Then split the closing balance into three states: current and available, pending because transactions have not become eligible, and reserved or held. A negative amount due is a fourth state when fees or refunds exceed available earnings. Etsy states that its Payment account shows current and pending balances and that sales funds can pay shop fees before the remainder is deposited. The ledger should reproduce those states rather than forcing the closing balance to zero.

For cutoff, use the accounting policy's event date for revenue and expense recognition, not the bank date. Record a deposit initiated before month-end but received after month-end in cash in transit. Reverse the transit balance when the bank receives it. This prevents September cash from becoming September sales when the underlying orders belonged to August.

Which mismatch should I investigate first?

Use the following exception ladder, the second original-value component. Level 1 is a bank mismatch: an Etsy deposit has no exact bank receipt after allowing for a reasonable processing window. Level 2 is a statement control gap: the sum of imported activity does not reproduce the Etsy statement movement. Level 3 is a duplicate or missing source ID, often caused by overlapping exports or a connector plus manual upload. Level 4 is an unlinked refund or chargeback. Level 5 is a classification question such as marketplace tax, reserve, currency conversion, or Etsy-funded buyer protection.

Investigate in that order because a missing bank transfer affects cash existence, while a classification issue may leave total assets correct but distort margin. Mark each exception green when it is a documented timing item, amber when the source event exists but treatment needs review, and red when money, entity, currency, or source ownership cannot be established.

Worked hypothetical example: weekly deposits and a reserve

Hypothetical example—not a customer result. Assume a US craft seller begins August with a $1,240 Etsy balance. August activity contains $18,600 of seller sales, $1,209 of transaction and processing fees, $410 of listing and advertising charges, $980 of customer refunds, $1,520 of marketplace-collected tax, a $900 new reserve, and a $300 reserve release. Etsy initiates deposits totaling $17,561; $16,100 reaches the bank during August and $1,461 arrives on 2 September.

The $600 closing balance must be identified from Etsy's pending or available detail; it is not an expense. The $1,461 initiated deposit is cash in transit at 31 August and matches the September bank line. The $1,520 tax movement is shown for control completeness, but its revenue and liability treatment depends on the seller's jurisdiction and accounting policy. Limits: the example assumes one shop, entity, and currency, and simplified fee groupings.

What data and steps produce a reviewable close?

1. Save the unmodified monthly statement CSV and deposit detail for every month touching the bank period.
2. Export order, refund, advertising, label, and tax detail using one timezone and currency convention.
3. Load unique activity IDs into the clearing ledger; reject duplicates rather than netting them.
4. Map the five buckets and reconcile the opening-to-closing equation.
5. Match each deposit ID and amount to the bank or cash-in-transit schedule.
6. Reconcile available, pending, reserve, and amount-due states to Etsy's interface.
7. Review revenue cutoff and tax treatment separately from payout matching.
8. Sign an exception log with amount, owner, evidence, next action, and due date.

Definition of done: source activity totals reproduce Etsy's statement; every deposit has one bank or transit match; the closing balance is composed of named states; and no red exception is buried in an unexplained plug.

What failure modes make a false reconciliation?

Posting the net deposit to revenue understates sales and hides expenses. Importing both order summaries and a connector can double revenue. Treating marketplace-collected tax as a fee can distort tax liabilities. Zeroing reserves to expense confuses delayed cash with a cost. Combining shops, entities, or currencies makes a tie possible without making it correct. Finally, changing raw CSV fields removes the evidence needed to diagnose later adjustments.

When an Etsy-funded refund or protection adjustment appears, do not assume the seller receives the same fee credits as a seller-funded refund. Etsy's Payments Policy describes how fee treatment can differ. Trace the specific activity lines and current policy rather than reusing an old journal rule.

When does this require a qualified professional?

Get professional review when the shop has multiple entities or currencies, uses Payoneer, has material marketplace-tax obligations, cannot establish its opening balance, receives large reserves or chargebacks, or needs revenue-recognition conclusions. Platform reconciliation proves amounts; it does not by itself decide legal tax ownership or financial-reporting policy.

Caigeek can use the monthly statement, order/refund exports, deposit detail, bank statement, chart of accounts, and prior closing balance as inputs. A useful output is a reconciled clearing ledger, deposit bridge, journal batch, and exception register—not a claim that every tax issue is resolved.

Self-check before sign-off

• Each source line has one stable identifier and one bucket.
• Gross sales are not replaced by net deposits.
• Deposits tie to bank or dated cash in transit.
• Pending and reserve balances remain assets until validly resolved.
• Tax and currency judgments are documented by entity.
• All red exceptions have an owner and escalation date.

Sources and last updated

Last checked: 17 August 2026.

• Etsy, Etsy Payments Policy
• Etsy Help, How to Calculate Your Etsy Payments Deposit Amount
• Etsy Help, How to Manage Your Payment Account

FAQ

Why does my Etsy deposit not match my sales?

Etsy deposits are net movements after fees, refunds, taxes, reserves, prior charges, and timing differences. Reconcile through a payment-account clearing ledger.

Should I record an Etsy bank deposit as revenue?

No. Record order activity and deductions from Etsy detail, then record the deposit as a clearing-to-bank transfer.

What report do I need to reconcile Etsy Payments?

Use the monthly statement CSV, deposit detail, order and refund data, and bank statement for each period and currency.

What proves an Etsy reconciliation is complete?

Every deposit matches bank or transit, activity ties to source detail, and the closing balance contains only identified pending, reserved, available, or due amounts.