Etsy Seller Spreadsheet, Fee Calculator and Profit Tracker, Shop Dashboard, Excel Google Sheets

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/Kqfl2qNrGKE

✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition.

Do you actually know how much you make on each Etsy sale? This spreadsheet works out every Etsy fee for you and shows your real profit per order, per product and per month. Works in Microsoft Excel and Google Sheets.

★ WHAT'S INCLUDED ★
• Clickable Start Here cover page with quick-start steps and a color key (yellow = you type, everything else calculates)
• Profit Dashboard: pick any month or the full year to see net sales, Etsy fees, net profit, profit margin, orders, average order value, profit per order, units sold, fees as % of sales, shipping gain or loss, Offsite Ads fees, shop expenses, tax set-aside, refunds, your best seller and profit goal progress
• Month-by-month table, top 7 products by profit and a 7-point shop health check (margin, fees, shipping, loss-making orders, low-margin products, refunds, goal pace)
• 4 dashboard charts: net sales vs. net profit, where every sale dollar goes, top products by profit, Etsy fees by type
• Orders log with room for 1,000 lines: product drop-down (leave the price blank to use your product price), shipping, discount, sales tax, sale source, label cost and refunds
• Every Etsy fee worked out per line: listing, transaction, payment processing (flat fee charged once per order), Offsite Ads (with the per-order cap) and an optional extra % fee, plus cost of goods, net profit, margin and a Healthy / Low margin / Loss / Refund flag
• Products tab (up to 60 products): materials, packaging and making time turn into a true cost per item, Etsy fees per sale, profit per unit, margin, units sold, net sales, net profit, % of profit and a status (Top seller, Healthy, Low margin, Losing money), with a chart
• Shop Expenses log with room for 500 entries, category drop-down and receipt check
• Monthly P&L: sales, discounts, refunds, each Etsy fee type, shipping labels, cost of goods, gross profit, every expense category, net profit, margin, tax set-aside, orders and average order value for all 12 months, plus a quarter-by-quarter summary and 2 charts
• Shipping & Ads: orders, sales, fees and profit by sale source (Etsy search, Etsy Ads, Offsite Ads, social media and more), and a monthly check of shipping charged vs. label costs, with 2 charts
• Goals: monthly sales, profit and order goals with % reached, Hit / Missed / On track / Behind / Upcoming status, profit still to go, and 2 goal vs. actual charts
• Fee & Price Calculator: try any price and see every fee and your profit for a regular sale and an Offsite Ads sale, the price that hits your target margin, your break-even price, a price ladder from -20% to +30%, how many sales a month cover your shop costs, and a chart
• Settings: shop name, report year, and editable Etsy fee rates pre-filled with Etsy's standard US rates (6.5% transaction, 3% + $0.25 processing, $0.20 listing, 15% / 12% Offsite Ads), hourly rate, tax set-aside %, warning levels, expense categories and sale sources
• 12 built-in charts, drop-downs, conditional formatting and progress bars throughout
• Sample data version plus a blank ready-to-use version

FEE RATES
Pre-filled with current US Etsy fee rates and fully editable, so you can update them if Etsy changes its fees or you sell from another country.

WORKS WITH Microsoft Excel and Google Sheets.
• 2 files included: an Excel version + a Google Sheets edition (Google-native progress bars)

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ SAVE WITH A BUNDLE ★
Get this template plus 4 more in the Small Business Spreadsheet Bundle and save 50%: https://www.etsy.com/listing/4600189442/small-business-spreadsheet-bundle

PLEASE NOTE
• DIGITAL download only. No physical item will be shipped.
• Fee calculations are estimates for planning. Check your Etsy payment account for exact amounts.
• Not tax advice. For personal or single-shop use only. Not for resale.