Etsy Inventory and Fees: A Simple Bookkeeping Method
09/22/2026
Written by KanderBooks Tali G.
Etsy sellers often face a deceptively simple bookkeeping question: when cash leaves the bank for supplies or merchandise, is it inventory, a marketplace fee, or an ordinary operating expense? Keeping those categories separate makes monthly results easier to understand and gives you a cleaner starting point for year-end tax work.
The practical goal is not to force every order into a complicated accounting system. It is to maintain a consistent trail from inventory purchase to sale, record Etsy charges separately, and use Etsy’s payout activity as a reconciliation check rather than as the only measure of sales. This article is educational only and is not tax, legal, or accounting advice.
Start with four separate buckets
Use distinct categories from the beginning. Combining inventory purchases, shipping-label charges, listing fees, and bank deposits in one catch-all category can make a shop appear less profitable or more profitable than it really is.
For a seller that buys or makes physical products, inventory is generally merchandise held for sale; for makers, it can include raw materials and components that become part of finished goods. The IRS explains that records should document the amount paid for inventory and help establish year-end inventory value. IRS Publication 583: Starting a Business and Keeping Records
- Inventory or materials for resale: merchandise, blanks, fabric, beads, packaging that becomes part of the sold item, and other product inputs.
- Marketplace and payment fees: listing, transaction, payment-processing, advertising, and similar platform charges.
- Fulfillment costs: postage, shipping labels, and non-product packaging, if you choose to track them separately.
- Cash movement: Etsy payouts, transfers to the business bank account, owner contributions, and owner withdrawals.
Maintain a product-cost record before recording the sale
Create a simple inventory worksheet with one line for each SKU, product batch, or purchase lot. For a vintage shop, a single item may be the unit. For a handmade shop, a batch of 20 identical candles or stickers may be more practical. The right level of detail is the one you can update consistently.
Record the purchase date, supplier, receipt or invoice reference, item or batch description, quantity received, total product cost, and unit cost. Keep the source document with the record. The IRS lists invoices, canceled checks, credit-card records, and receipts among documents that support inventory costs and other business transactions. IRS Publication 583: Starting a Business and Keeping Records
- Example: Buy 50 ceramic mugs for $300 plus $25 inbound freight. If the $25 is part of getting those mugs ready for sale, your tracked product cost is $325, or $6.50 per mug.
- When 8 mugs sell, flag 8 units as sold in the worksheet. The related product cost is 8 × $6.50, or $52.
- Do not reduce the $6.50 unit cost merely because Etsy withheld a transaction fee. The fee and the product cost answer different questions.
Record Etsy activity at the payout level without losing the gross picture
A bank deposit is only the net cash Etsy sent. It may reflect customer payments minus marketplace fees, refunds, postage labels, reserves, or other activity. To avoid understating sales, create a payout summary from the Etsy statement or export that identifies the components that produced the deposit.
Use a clearing account called Etsy Clearing, Marketplace Clearing, or Etsy Payments. Record the payout-period summary there first, then match the actual transfer from Etsy to the business bank account against the clearing account. This lets the books show sales and fees separately while the bank still reconciles to the exact net deposit.
- Illustrative payout summary: customer product sales $1,200; customer-paid shipping $120; refunds $75; Etsy fees $165; labels $90; net payout $990.
- One simple bookkeeping view: record $1,320 of sales-related receipts, record the $75 refund and the $165 in marketplace fees separately, record $90 of label cost, and clear the remaining $990 when it reaches the bank.
- Review the payout report period and payout date together. A sale can occur in one period while its cash transfer arrives later.
Move sold product costs out of inventory on a routine
When products are sold, the cost of those products should no longer remain entirely in the inventory total. For sellers using an inventory and cost-of-goods-sold approach, this is the point where the cost of the sold units is recognized as cost of goods sold, while unsold units remain in ending inventory.
The IRS states that businesses making or buying goods to sell generally use beginning inventory, purchases, other eligible costs, and ending inventory to determine cost of goods sold. It also describes special inventory options for qualifying small business taxpayers, so a seller should use a method that clearly reflects income and apply it consistently. IRS Publication 334: Tax Guide for Small Business
- Weekly option: update units sold and product cost every Friday.
- Monthly option: total units sold by SKU or batch and record the associated costs during the monthly close.
- Year-end minimum: count or otherwise substantiate what remains on hand, compare it with the inventory worksheet, and investigate material differences.
Use a monthly Etsy close checklist
A repeatable close prevents the common mistake of treating the payout as both sales income and the only transaction that needs recording. It also creates a concise package of records if you later work with a tax preparer or bookkeeper.
Keep the monthly reports, source receipts, and reconciliation together by month. The IRS advises businesses to keep supporting documents in an orderly fashion because they support entries in the books and tax return. IRS Publication 583: Starting a Business and Keeping Records
- Download the Etsy payout, orders, fees, refunds, and shipping-label reports for the month.
- Total the payout activity and tie it to the Etsy Clearing balance.
- Match each Etsy transfer to the business-bank deposit.
- Review refunds, chargebacks, and adjustments so they are not mistaken for ordinary fees.
- Update product quantities and identify the cost of units sold.
- File supplier invoices, purchase receipts, and Etsy reports in the same monthly folder.
- Compare the ending inventory worksheet with a physical count or a targeted count of high-value and fast-moving products.
Frequently asked questions
Should I record an Etsy payout as sales income?
Not by itself. The payout is net cash, while your records should separately show the underlying sales-related receipts, refunds, marketplace fees, and other deductions that explain why the deposited amount is lower than customer payments.
Are Etsy fees part of inventory cost?
Usually, it is clearer to track marketplace fees separately from the cost of the item purchased or made. Product cost helps evaluate gross margin by item; marketplace fees help evaluate the cost of selling through the platform. The appropriate tax treatment can depend on your accounting method and facts, so ask a qualified tax professional about your situation.
What if I make products instead of buying finished inventory?
Track the direct materials and components used in each item or batch, then calculate a consistent unit cost. Keep receipts and a simple production or batch record so you can connect materials purchased, units made, units sold, and units remaining.
How often should I count Etsy inventory?
A monthly review works well for many small shops, with more frequent checks for expensive, limited, or fast-selling products. At a minimum, make sure your year-end records support what was still on hand.
Can I use a spreadsheet instead of accounting software?
Yes. A spreadsheet can work when it consistently tracks inventory purchases, quantities, units sold, Etsy statement totals, fees, refunds, and bank payouts. As order volume rises, the most important improvement is usually a stronger review routine, not necessarily more software.
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.
About this author
Tali G. is KanderBooks’ AI editorial pen name. Articles are researched and checked using our automated editorial process. Editorial images are generated for the articles.