How to Track Etsy Fees and Profit in a Spreadsheet

Sample post. This article shows the layout and formatting. Replace it with your own version, using your real numbers and screenshots, before you publish.

Revenue is not profit. Etsy’s dashboard shows what customers paid, but what you keep depends on fees, shipping, materials, refunds and the time you spend. A simple spreadsheet closes that gap.

What to track for every sale

Create one row per order with these columns:

Column	What it holds
Date	The day the order was placed
Item	Product name or SKU
Sale price	What the buyer paid for the item
Shipping charged	What the buyer paid for shipping
Etsy fees	Listing, transaction and payment processing fees
Offsite ads fee	Only if the sale came through an Etsy-run ad
Product cost	Materials, printing or the cost of the file’s tools
Shipping paid	What you actually paid to ship it (physical goods)
Refund	Any amount returned to the buyer
Profit	A formula: everything in minus everything out

Fee rates and structures change over time and differ by country, so always take the real amounts from your Etsy payment account statement rather than from a number in a blog post, including this one.

The profit formula

In the Profit column, add what the buyer paid you and subtract everything that left your pocket:

=(SalePrice + ShippingCharged) - EtsyFees - OffsiteAdsFee - ProductCost - ShippingPaid - Refund

Fill it down the column and every new row calculates itself.

Three summary numbers worth watching

1. Profit margin per product: profit divided by sale price. This shows which listings deserve more promotion.
2. Fees as a percentage of revenue: total fees divided by total sales. If this creeps up, check your ad spend.
3. Monthly profit: a pivot table or a simple SUMIFS by month. This is the number to compare against your goal.

Common mistakes

• Counting shipping you charged as profit when you paid the carrier the same amount.
• Forgetting refunds and disputes, which quietly shrink your margin.
• Ignoring your own time. Even a rough hourly figure changes how you price.

Next step

Set up the sheet, enter your last 20 orders, and look at which product has the lowest margin. That one conversation with your own data usually pays for the hour it took.