Report this item to Etsy

Etsy Seller Spreadsheet: Fee Calculator, Bookkeeping, Inventory Tracker and Profit Dashboard | Google Sheets & Excel | Profit Tracker

Price:$17.00

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by BitWorksShop
  • Digital download
  • Digital file type(s): 1 ZIP

The problem: You sell on Etsy and the fees eat your margin in ways that are hard to see: a 6.5% transaction fee, 3% plus $0.25 payment processing, a $0.20 listing fee, and maybe a 15% Offsite Ads fee with a cap. Guessing at your real profit per sale means pricing blind, and inventory tracked in your head runs out at the worst time.

What it does: One spreadsheet built for Etsy and craft sellers. Log an order and it works out every fee, your cost of goods, and your real net profit. It calculates every fee per order: the 6.5% transaction fee, 3% + $0.25 payment processing (the $0.25 applied once per order), the $0.20 listing fee, and an optional 15% Offsite Ads fee with the $100 cap per order (shared across lines with the same Order #). Fee rates live in a Settings tab, so if a fee changes you edit one cell. It works out the true cost per product from materials, packaging, and labor at your hourly rate. Inventory updates automatically from your sales, with LOW - REORDER and OUT OF STOCK alerts. Expenses log by category from a dropdown. A monthly P&L with margin and an income-tax set-aside estimate builds itself, and a dashboard shows year-to-date sales, fees, profit, average order value, most profitable product, and 3 charts. Sales tax collected stays out of your profit and shows for reference. The Check column flags rows with a missing date or an unknown SKU. You get the blank tracker (opens in Google Sheets or Excel), the same tracker filled with example data, and a quick-start setup guide. 9 tabs: Instructions, Dashboard, Settings, Products, Inventory, Order Log, Expenses, Monthly P&L, and More Tools. No macros and no subscription. Your data stays in your own file.

Limits: This is a digital download. Nothing physical is shipped. You need a free Google account or Microsoft Excel. Fee amounts are estimates using Etsy US default rates, which you can edit. This is not tax or accounting advice. Not affiliated with, sponsored or endorsed by Etsy, Inc., Google or Microsoft.

Price: $17, one-time. Works in Google Sheets and Excel, no macros needed. Single-user license.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 16, 2026