A spreadsheet for small online sellers, set up with Etsy's US fee rates. Every rate is an input you can change, so it keeps working when fees change or if you sell somewhere else.
What is inside
- Price Calculator: fees, profit per sale and margin for one product, the price you need for your target margin, and your profit if the order comes from an Offsite Ad.
- Orders: one row per order. Fees, profit and margin calculate for each order.
- Expenses: packaging, ads, subscriptions and other costs not tied to one order.
- Monthly P&L: sales, fees, shipping labels, cost of goods, expenses and profit by month.
- Fees: the fee rates used everywhere in the workbook.
- A sample copy and a blank copy.
Price calculator
Orders with fees
Monthly profit and loss
Editable fee rates
Not affiliated with Etsy. Record-keeping tool, not tax, legal or accounting advice. Sample numbers are examples.
The spreadsheet
$8
One payment, instant download of the sample and blank workbooks. Checkout is handled by Polar, our merchant of record. If it does not work for you, write within 14 days and we will refund it.
Get the spreadsheetSee one order worked through: what you keep from a $28 sale after Etsy fees.
How to use: in Google Sheets choose File, Import, Upload and pick the .xlsx file, or open it in Excel. Cream cells are for typing; green cells calculate.
© Lumineus Studio. Write to [email protected] with questions. Privacy Terms