Download the spreadsheet (.xlsx)
Free, no sign-up, no macros. Opens in Microsoft Excel, Google Sheets and LibreOffice.
What it does
- Orders sheet. One line per order: item price, shipping charged, whether it was an Offsite Ad sale, the buyer's sales tax rate, and your item, postage and packaging costs. The sheet fills in Etsy's fees, what Etsy pays you, your profit and your margin.
- Summary sheet. Total sales, total Etsy fees, total costs, net profit, average margin and the share of your sales that went to Etsy.
- Rates sheet. Etsy's US rates with their source and the date they were checked. Change them here for your country and every order updates.
The formula inside
Etsy pays you = price + shipping − Etsy fees
Profit = Etsy pays you − item cost − postage − packaging
It is the same formula as the Etsy fee calculator. The first example line in the sheet is the $25 mug with $5 shipping from that page: fees $3.30, profit $15.40.
How to open it in Google Sheets
- Download the file.
- Open sheets.google.com and start a blank spreadsheet.
- Choose File › Import › Upload and pick the file.
- Choose Replace spreadsheet and press Import data.
Selling outside the US?
Open the Rates sheet and type your country's payment processing rate and fixed fee from the Etsy fees by country table. If your country has a Regulatory Operating Fee, add it to the transaction fee percentage (for the UK, 6.5% + 0.48% = 6.98%).
Prefer to work in the browser?
The free Etsy shop monthly profit planner does the same job without a download: it saves in your browser, prints, and exports a CSV file.
Rates in the file verified 8 Nov 2026 · By Muhammad Shujah Uddin Qazi · Share it freely; please link to this page rather than re-uploading the file.