Etsy Payout Reconciliation: Match Deposits to Sales
10/08/2026
By Talia. E
A recent Etsy seller discussion raised a practical version of a common bookkeeping problem: how to see real profit after listing, transaction, payment-processing, and advertising fees. The key is to stop treating the net deposit as the sale. Instead, reconcile each marketplace payout from the underlying sales activity to the amount that reached the bank.
This workflow is general financial education, not tax, legal, or accounting advice. It can help create organized records for your own review and for a qualified tax professional when needed.
Why the bank deposit is not your Etsy revenue
A marketplace payout is a settlement, not a complete sales record. One deposit can represent customer payments less marketplace fees, refunds, shipping-label charges, ad charges, reserve movements, or other items shown in the payout detail. Recording only the deposit as income hides those components and makes it difficult to explain the difference between sales reports and cash received.
This distinction also matters at tax time. The IRS explains that Form 1099-K gross payment amounts are not reduced for fees, credits, refunds, shipping, or discounts; sellers should use their records to identify the related income and deductible expenses. IRS: What to Do With Form 1099-K
- Gross sales: customer payments for products and, where applicable, shipping charged to customers.
- Reductions or offsets: refunds, discounts, marketplace fees, payment-processing fees, advertising charges, and shipping-label purchases.
- Net payout: the amount transferred from the marketplace payment balance to the business bank account.
Set up one marketplace clearing account
Create an account in your books called “Etsy clearing” or “Marketplace payments clearing.” It represents money that the marketplace has collected or is holding before it reaches your bank. It is not a new bank account; it is an internal bookkeeping account used to make the settlement trail visible.
Use separate income and expense categories for the important parts of the payout. At a minimum, use sales income, shipping income if you track it separately, marketplace fees, payment-processing fees, advertising fees, refunds or returns, and sales-tax payable when tax collected is not your income. Keep the account list simple enough that you will use it consistently.
- Do not record a $640 bank deposit as $640 of sales if the payout report shows $800 of sales and $160 of fees and refunds.
- Post the $800 of sales to income and the $160 of offsets to their appropriate expense, refund, or liability categories.
- The remaining $640 should be the balance in Etsy clearing, ready to match to the bank deposit.
Reconcile one payout from report to bank
Choose a completed payout period and save the settlement or payment-account detail alongside your bookkeeping support. The IRS says supporting documents for sales and expenses can include invoices, receipts, account statements, and other records that substantiate entries in the books. IRS Publication 583: Starting a Business and Keeping Records
Then enter one payout summary rather than trying to force every bank-feed deposit to stand in for a sale. The dates of individual orders and the date cash arrives in the bank may differ, so use the payout identifier and payout period as the common reference.
- Example payout detail: product and shipping sales of $1,250; refunds of $75; marketplace and processing fees of $145; advertising fees of $30; net payout of $1,000.
- Book the sales portion to Etsy clearing: debit Etsy clearing $1,250 and credit the applicable sales-income accounts $1,250.
- Book the offsets against Etsy clearing: credit Etsy clearing $75 for refunds and credit Etsy clearing $175 for fees, while debiting the appropriate refund and fee accounts.
- When the $1,000 arrives in the bank, debit the bank account $1,000 and credit Etsy clearing $1,000.
- The clearing balance for that payout should be zero after all activity belonging to that payout is posted. A remaining balance is a prompt to investigate timing, a reserve, a missing refund, a duplicate entry, or an unrecorded charge.
Keep inventory records connected, but separate from payouts
A payout reconciliation explains cash and marketplace deductions; it does not by itself establish the cost of the items sold. Keep purchase invoices, materials records, SKU or product records, and a count or value of inventory on hand. The IRS notes that inventory documentation should show the amount paid and that the purchase was for inventory, and that these records help determine year-end inventory value. IRS Publication 583: Inventory Records
For sellers that purchase, make, or resell merchandise, inventory treatment depends on the business’s accounting method and facts. The IRS states that merchandise businesses generally take inventory into account, subject to rules and exceptions for small business taxpayers. IRS Publication 334: Tax Guide for Small Business Keep your operating records detailed enough to support the method you use, and consult a qualified professional before changing an established tax accounting method.
- For each product or SKU, retain the purchase or production cost, quantities bought, quantities sold, and units on hand.
- Track packaging and shipping supplies separately from resale merchandise unless your chosen accounting method treats them differently.
- Review damaged, discontinued, or personal-use withdrawals from inventory before year-end rather than waiting until return preparation.
Use a weekly rhythm and a monthly proof
For a busy shop, reconcile each completed payout weekly. This keeps the work small and lets you find missing transactions while the marketplace detail is still familiar. At month-end, total the completed payout reports and compare them with the activity posted to sales, fee, refund, and clearing accounts.
Your goal is not for every order date to match every deposit date. Your goal is a clear, supportable chain: marketplace activity explains the payout, the payout explains the bank deposit, and the accumulated gross sales and offsets can be compared with year-end information reports and inventory records.
- Weekly payout checklist:
- Save the payout statement or export and label it with the payout ID and date.
- Post gross sales, refunds, fees, and other settlement items to Etsy clearing.
- Match the net payout to the bank deposit.
- Investigate any nonzero clearing balance for a completed payout.
- Monthly proof:
- Review whether the total clearing balance reflects only pending payouts, known reserves, or timing differences.
- Compare sales totals with marketplace reporting and scan for duplicate imports from connectors or bank rules.
Frequently asked questions
Should I record the Etsy bank deposit as sales income?
Usually, no. The deposit is the net settlement. Record the underlying gross sales and separately record fees, refunds, and other payout items so the net amount can be matched to the bank deposit through a marketplace clearing account.
What if one payout includes orders from more than one week?
Use the payout report as the reconciliation unit. Summarize all activity included in that payout, post it to the clearing account, then match the resulting net balance to the deposit.
Why does my 1099-K not match the total of my bank deposits?
Bank deposits are often net of marketplace deductions. The IRS explains that the gross payment amount on Form 1099-K is not reduced for fees, refunds, shipping, discounts, or credits. Your books should retain the records that explain those differences. IRS: What to Do With Form 1099-K
Can I use a spreadsheet instead of accounting software?
Yes, if it reliably records the payout components, links each payout to the bank deposit, and retains supporting documents. A simple system used consistently is more useful than an automated system that creates duplicate or unexplained entries.
Sources and further reading
This article provides general educational information and is not tax, legal, accounting, or investment advice. Rules and individual circumstances can change; consult an appropriately qualified professional for advice about your situation.