Bookkeeping for Etsy Sellers: A Simple System

Selling handmade jewelry, printable art, or vintage finds on Etsy is exciting, but the money side can quickly turn into a tangle of fees, refunds, and shipping charges. Sound bookkeeping for etsy sellers is what separates a hobby that loses track of cash from a real business that grows profitably and stays ready for tax season. If you have ever stared at an Etsy deposit and wondered why it does not match your sales, this guide is for you.

Bookkeeping for etsy sellers means recording every sale, fee, refund, and shipping cost so your books show true profit, not just the cash Etsy deposits. Keep business and personal money separate, track gross income against net payouts, log cost of goods, and save records for tax time.

Why bookkeeping for Etsy sellers is tricky

Etsy is not a simple cash-in, cash-out platform. Before a single dollar reaches your bank account, Etsy deducts transaction fees, payment processing fees, listing fees, and often advertising or Offsite Ads costs. Add in shipping labels purchased through Etsy, sales tax that Etsy collects and remits on your behalf, and the occasional refund, and a $40 sale might land in your account as $32 or less. The deposit you see is a net figure that bundles together many separate financial events. If you only record the deposit, your income looks too low and your expenses disappear entirely, which distorts your profit and can cost you deductions at tax time.

Separating business and personal finances

The single most valuable habit for any Etsy seller is keeping business money apart from personal money. Open a dedicated business checking account and, ideally, a business debit or credit card used only for shop expenses such as materials, packaging, and shipping supplies. This makes your records cleaner, your deductible expenses obvious, and an audit far less stressful. Commingling funds is one of the fastest ways to lose track of profitability and miss legitimate write-offs. Even if you operate as a sole proprietor, a separate account costs little and saves hours of untangling later.

Tracking income vs. Etsy deposits (gross vs. net)

This is where most shop owners go wrong. Your true revenue is the gross amount buyers paid, not the net amount Etsy deposited. Good bookkeeping for etsy sellers records the full sale price as income, then logs each fee as its own expense. For example, a $50 order should be entered as $50 of revenue, with separate line items for the transaction fee, processing fee, and any shipping label cost. Your monthly Etsy Payment account statement (downloadable as a CSV) breaks every deposit into these components, so reconcile your books against it rather than against the lump-sum bank deposit.

Cost of goods sold and materials

Cost of goods sold (COGS) is the direct cost of producing what you sell, such as beads, fabric, ink, blanks, or wholesale items you resell. Tracking COGS accurately tells you your real margin on each product and is essential for an honest profit figure. Keep receipts for every material purchase and note how much inventory you hold at the start and end of the year. The IRS provides guidance on inventory and COGS in Publication 334, Tax Guide for Small Business, which is worth reviewing as your shop grows. Even a simple inventory count protects you from overstating profit.

Deductible business expenses

Beyond materials, Etsy sellers can typically deduct a wide range of ordinary and necessary business costs. Common deductions include Etsy fees, payment processing fees, advertising, shipping and postage, packaging supplies, photography props, a portion of home internet and phone if used for the business, software subscriptions, and mileage for business errands. If you work from a dedicated space, you may qualify for the home office deduction. Record each expense as it happens and keep the supporting receipt, since reconstructing a year of spending from memory is unreliable and rarely captures everything you are entitled to claim.

Sales tax and the 1099-K

For most U.S. shops, Etsy automatically calculates, collects, and remits sales tax to states under marketplace facilitator laws, which removes a large burden from sellers. You should still record the sales tax Etsy collected so your books balance, and confirm whether you have any obligations for sales made outside Etsy. Separately, if your payment activity meets the federal reporting threshold, Etsy will issue a Form 1099-K summarizing your gross transactions. Thresholds have changed in recent years, so check the current rules directly with the IRS Understanding Your Form 1099-K page. Importantly, the 1099-K reports gross sales before fees, which is exactly why tracking gross income matters.

Software and spreadsheet setup

You do not need expensive tools to start. A clean spreadsheet with columns for date, order number, gross sale, each fee type, shipping cost, and net deposit can carry a small shop a long way. As volume grows, dedicated bookkeeping software such as QuickBooks or Wave, or an Etsy-focused integration, saves hours by importing transactions automatically and categorizing fees. Whatever you choose, the goal is the same: every transaction recorded, every fee separated, and your bank account reconciled to your books at least monthly. Consistent monthly upkeep beats a frantic year-end scramble every time.

Prepping for tax time

When your books are current, tax time becomes a review rather than a reconstruction. Pull a profit and loss summary showing gross income, total fees, COGS, and other expenses. Reconcile that against your annual Etsy CSV and your 1099-K if you received one. Set aside money for income tax and self-employment tax throughout the year so you are not caught short, and consider quarterly estimated payments if you owe enough. Organized records also make it far easier for a professional to file accurately and find every deduction you qualify for.

Etsy bookkeeping setup checklist

• Open a dedicated business bank account and card.
• Choose your tool: a spreadsheet or bookkeeping software.
• Download your monthly Etsy Payment account CSV.
• Record gross sales separately from each fee and shipping cost.
• Track COGS and keep all material and supply receipts.
• Log every deductible expense as it occurs.
• Note sales tax Etsy collected and remitted.
• Reconcile books to your bank account every month.
• Set aside funds for income and self-employment tax.

Mistakes to avoid

• Recording only the net deposit. This hides your real revenue and your deductible fees.
• Mixing personal and business money. It muddies your records and risks lost deductions.
• Ignoring COGS and inventory. Without it, your profit figure is fiction.
• Letting receipts pile up. Untracked expenses are unclaimed deductions.
• Waiting until tax season. A year of catch-up invites errors and stress.
• Forgetting to set aside tax money. A surprise bill can sink a small shop.

Frequently asked questions

Do I need to report Etsy income if it is just a hobby?

Generally, income from selling on Etsy is taxable whether you consider it a hobby or a business. How you report it and which expenses you can deduct depend on whether the IRS treats your activity as a business, so check current IRS guidance or speak with a professional about your situation.

What records should I keep for bookkeeping for etsy sellers?

Keep your monthly Etsy Payment statements, bank and card statements, receipts for materials and supplies, mileage logs, and any 1099-K you receive. Retaining these records supports your reported income and every deduction you claim.

Why does my Etsy deposit not match my sales?

Your deposit is a net figure after Etsy subtracts transaction fees, processing fees, shipping labels, and sometimes advertising costs. Recording the gross sale and each fee separately explains the difference and keeps your books accurate.

Do I have to handle sales tax myself?

In most U.S. states, Etsy collects and remits sales tax for you under marketplace facilitator rules. You should still record those amounts and confirm whether sales made off the platform create any obligations of your own.

When should I hire a bookkeeper or accountant?

Many sellers manage well with a spreadsheet early on, then bring in help as orders, fees, and inventory grow more complex or when tax filing feels overwhelming. A professional can also catch deductions and keep you compliant year-round.

Get your Etsy books in order

Clean books turn guesswork into a clear picture of what your shop actually earns, and they make tax season painless. If you would rather create than reconcile, Tranzesta can set up and maintain your records so every fee, refund, and deposit is accounted for. Explore our bookkeeping & accounting services and our guidance on e-commerce & sales tax, then book a free consultation to talk through your shop. Reliable bookkeeping for etsy sellers is the foundation of a business that grows with confidence.

Disclaimer: This article is for general informational purposes only and does not constitute tax, legal, or accounting advice. Tax rules and reporting thresholds change and vary by situation. Please consult a qualified professional or the IRS before making decisions for your business.