See every marketplace fee on every order and what you really keep: fee calculator, profit per order and product, monthly P&L and tax set-aside. Excel and Google Sheets.
$13.99
Buy on Etsy- Excel and Google Sheets
- Blank and filled-in example
- Instant download
- Secure checkout on Etsy
Know what you really keep from every sale. Log your orders and this spreadsheet works out every marketplace fee, your cost of goods and your true net profit, order by order, product by product and month by month. Set up with Etsy fee rates, and easy to change for any other platform.
What’s inside
4 files: 2 blank workbooks (Excel .xlsx) + 2 filled-in example versions
- Dashboard: sales, orders, fees paid, fees as % of sales, net profit and profit per order, with 3 charts
- Where each sale goes: fees, cost of goods, shipping labels, expenses, tax set-aside and take-home
- Orders log: listing, transaction, payment processing and offsite ads fees worked out on every order
- Fee Calculator: check a sale before you list it and find the price you need for the margin you want
- Monthly P&L: profit and loss for each month, with tax set-aside and take-home pay
- Fee breakdown: exactly how much each fee type costs you this year
- Products: units sold, sales, fees and net profit for every product
- Expenses: shop ads, supplies, packaging, software and more
- Setup: your fee rates, currency, year and tax set-aside %
- Start Here guide
How it works
- Download the files after purchase
- Open in Excel, or upload to Google Drive and open with Google Sheets
- Check the fee rates on Setup and add your products
- Log each order with its SKU and quantity. Type only in the yellow cells; every fee and profit figure updates by itself
Good to know
- Fee rates are filled in with common Etsy US rates (works for Etsy fees). Rates change and differ by country, so please check yours and edit them in one place
- Works for other marketplaces too: just change the rates
- Handles orders with several products, discounts, refunds and offsite ad orders
- Any currency
- Works in Excel 2016 or newer, Excel for Mac, Microsoft 365 and Google Sheets
- The tax set-aside is an estimate, not tax advice
- This is a digital download. Nothing will be shipped
- For use in your own business. Please do not share or resell the files
- Need help? Message us and we’ll get you set up
Made by YellowCellStudio, a product of QSE Advisory. Every formula is tested in Excel and Google Sheets, and every file is checked by QSE Advisory experts before release.
Questions
Do I need Excel?
No. It works in Microsoft Excel 2016 or newer, Excel for Mac, Microsoft 365 and free Google Sheets.
How do I get the file?
Buy on Etsy and the download link appears straight away. Nothing is shipped.
Is it hard to use?
You only type in the yellow cells. Totals, dashboards and charts update by themselves, and a Start Here tab explains each step.
What if something doesn’t work?
Message us on Etsy. We fix errors fast and will help you set up the file.
