Receipt Tracking for Etsy & Shopify Sellers: COGS, Shipping, and the Inventory Question

Selling online is one of those businesses where you can be doing $60k a year in gross sales and still have no idea if you're actually making money. The 1099-K from Etsy or Shopify Payments shows a number. Your bank shows a smaller number. Your supplies cost something. Shipping cost something else. After taxes you might owe the IRS a chunk, or you might not. Most sellers find out which one in April.

Here's a setup that works for the typical solo Etsy/Shopify/Amazon FBA seller doing somewhere between $20k and $300k a year. Your accountant will love you for it. So will future you in March.

Your 1099-K lies. Sort of.

Every platform you sell on issues a 1099-K at year-end (assuming you cross the reporting threshold, which has been moving year to year). The number on that form is your gross sales. It includes the listing fee Etsy took, the 6.5% transaction fee, the 3% payment processing fee, the cancelled orders that got refunded, sales tax that the platform collected and remitted on your behalf, shipping you charged the customer that you then paid to USPS.

The actual money that hit your bank account is way less than that. Sellers who don't reconcile this end up paying tax on the gross amount, which is wildly more than what they earned. The IRS doesn't care that the math is unfair. They care that the number on the 1099-K matches what's on your return, with offsetting deductions on Schedule C for the platform fees you paid.

So every monthly Etsy statement, every Shopify payout report, every Amazon disbursement summary — forward it to your books the day it arrives. The year-end reconciliation between gross 1099-K and net deposits is one of the biggest deductions e-commerce sellers fail to claim properly.

COGS: the part that actually matters

Cost of goods sold is the IRS's name for "what you paid to make or buy the stuff you sold." For a soap maker on Etsy: lye, oils, fragrances, molds (if expensed as supplies), labels, packaging. For a dropshipper: what you paid the supplier per unit. For an Amazon FBA seller: inventory cost plus inbound shipping plus FBA prep.

COGS gets subtracted from gross sales to get gross profit. If your COGS line is sloppy, your gross profit is wrong and every margin decision downstream is built on bad numbers. Should you raise prices? Drop a SKU? Run a sale? Move to a different supplier? You can't answer any of those without clean COGS.

Get every supplier receipt into your books with a category tag of "COGS — Materials" or similar. Bulk purchases from Uline for packaging, AliExpress orders from suppliers, fabric from Joann, beads from Fire Mountain, whatever your craft requires. Email auto-forward catches most of this since these vendors all send digital receipts.

Inventory: the accounting choice that trips up most sellers

The IRS lets most small sellers (under $27M in average gross receipts, which is essentially everyone reading this) use the cash method for inventory. That means you can deduct the cost of materials in the year you pay for them, regardless of when you sell the finished product.

This is more generous than it sounds. If you bought $4,000 of supplies in December but won't sell the finished items until March, you still get the $4,000 deduction this year. It also means you don't need to do a formal year-end inventory count (no more counting beads on December 31st), though doing one informally helps you spot dead stock.

The accrual method, where you only deduct COGS when the product sells, is required for larger sellers and optional for smaller ones. Most solo sellers should stay on cash basis. Talk to your accountant if you're unsure.

Shipping is a wash, but you still need the receipts

The customer paid you $8 for shipping. You paid USPS $7.42. The $8 is income. The $7.42 is a deduction. Net is $0.58 of margin (or sometimes negative, if you under-charged). The income flows through your 1099-K automatically. The expense doesn't appear anywhere unless you record it.

Pirate Ship, ShipStation, Shippo, and Etsy's built-in postage tool all email receipts or generate downloadable statements. Get these into your books. Postage is a meaningful annual deduction for any seller doing more than a couple orders a week. Forget to track it and you're paying income tax on shipping revenue that never actually existed as profit.

Home office, deduction-rich and audit-flag-y

If you run the business from home, you may qualify for the home office deduction. Two paths: the simplified method ($5 per square foot up to 300 sq ft, so capped at $1,500 a year), or actual expenses (a portion of rent or mortgage interest, utilities, internet, insurance, prorated by square footage).

The actual-expense method is usually the bigger deduction but requires more documentation. The space has to be used regularly and exclusively for business. A spare bedroom that's also a guest room doesn't qualify. A studio that's exclusively for making and shipping product does.

The audit-flag thing is overstated these days. Home office deductions are common enough that they don't automatically flag a return. They do need to be substantiated if you're audited, which means utility bills and a measurement of the office vs the whole house. Keep the receipts.

The deductions every online seller forgets

• Subscriptions. Etsy listing fees in bulk, Shopify monthly, Erank or Marmalead for keyword research, Canva, Adobe Creative Cloud, Printful, Printify, Sprocket.
• Internet. Business-use portion of your home internet bill.
• Cell phone. Business-use portion.
• Photography props and backdrops bought specifically for product photos.
• Sample orders placed with your own shop to test the customer experience.
• Trade show fees and travel if you do any in-person markets or expos.
• Books and courses on running an e-commerce business.
• Business mileage to the post office, supply runs, photo locations.
• Bank fees. Most sellers should have a separate business account; the monthly fee, wire fees, and FX fees are all deductible.
• Credit card processing fees beyond the platform's cut, if you sell anywhere outside Etsy/Shopify.

Hobby vs business: the question lurking under all this

The IRS distinguishes between a business (which can deduct expenses against income) and a hobby (which generally can't, post-2017). Three years of losses in a five-year window starts the conversation about whether you're really running a business or just enjoying an expensive craft. Documented expenses, consistent recordkeeping, marketing efforts, and an honest intent to profit all matter when defending the business position.

The same receipt habits that maximize your deductions when profitable also defend your business status when you're not. It's the same set of records either way.