Etsy & eBay Seller P&L Spreadsheet β Track Sales, Fees & Profit
π₯ Etsy & eBay Seller P&L Spreadsheet: Instant Download
See sales, marketplace fees, ad spend and product costs side by side every month.
A seller P&L in one Excel workbook: 5 working tabs plus Instructions and Disclaimer, in one file that is yours to keep.
β¨ What It Does for You
- Net Sale calculated for each order
- See every fee and ad cost with a running total
- Track unit cost, stock and reorder points per SKU
- Compare three months of P&L side by side
π¦ What's Inside
- Instructions and Disclaimer: shop name, primary platform, and currency, a 7-step how-to, a sheet map, and a plain-language disclaimer
- Sales Log: order-by-order date, platform (Etsy, eBay, Shopify, Other), order ID, item, quantity, sale price, shipping charged, and refunds; Net Sale calculates for you
- Fees & Ads: listing, transaction, processing, final value, ads, promoted listings, and subscription fees, with a running total
- COGS Inventory: unit cost, quantity on hand, reorder point, last ordered date, and supplier for each SKU
- Monthly P&L: three months side by side: gross sales, shipping, refunds, net revenue, COGS, platform fees, ad spend, packaging, other expenses, and estimated contribution
- Products: a SKU catalog with platform, list price, unit cost, category, and active yes/no

π‘ Who This Is For
- Etsy and eBay sellers who want a clear monthly profit picture
- Handmade and resale shops selling on more than one marketplace
- Sellers who want one organized file to share with a bookkeeper or tax pro
π Before and After
- Before: Fees buried in marketplace statements. After: A Fees & Ads log by fee type with a running total
- Before: Guessing what you made each month. After: A Monthly P&L with net revenue and estimated contribution for three months side by side
- Before: Running out of stock without warning. After: A COGS Inventory tab with quantity on hand and a reorder point for each SKU
β‘ Get Started in Minutes
- Download the .xlsx and open it in Excel or Google Sheets
- Set your shop on Instructions
- Log sales and fees
- Review the Monthly P&L
- Pick from the dropdowns as you fill it in
Organization tool only: NOT tax or accounting advice. Fee structures change; verify with your Etsy/eBay statements and your tax pro.
Sample data is fictional. Replace it with yours.
π Instant Access
Once you purchase, you get immediate access to your file. It is yours to keep.
Weβre a new store, but our digital tools are built to save you time, simplify your workflow, and help your business grow. Your trust matters β and every product is designed to deliver real results.
Thank you for supporting a growing brand.
β Kyle P. Herrick, Founder
βοΈ Satisfaction Guarantee
If this template doesnβt help you save time or improve your workflow, message me and Iβll make it right. Your success matters.
π¬ Need Help?
Message me anytime. Iβm here to help you get the most out of your templates. Email herrickkyle87@outlook.com.
See your real shop profit this month. Click Buy Now.