◧ ShopTallyShopTally home

Etsy profit and loss spreadsheet: templates, subscriptions or ShopTally?

There are three common ways to turn Etsy statements into a profit and loss report. Each suits a different seller. Here is how they compare, a manual method you can do for free, and where ShopTally fits.

Option 1: a spreadsheet or template

A template gives you tabs and formulas to fill in. Each month you download the statement CSV and paste it in, and the sheet totals the result.

Option 2: an inventory or accounting subscription

Tools in the Craftybase style connect to your shop, track materials and finished goods, and work out cost of goods sold per product. They typically charge a monthly fee.

Option 3: ShopTally

ShopTally is a single file that opens in your browser. You drop in your monthly statement CSVs and it sorts each row into income, refunds, tax passed to the government, fees, marketing, shipping, or not part of profit. It then shows profit by month. It is $24 once, with no account, and the free edition shows your latest month only.

Side by side

SpreadsheetSubscriptionShopTally
CostFree to a one-time priceMonthly fee$24 once
Getting data inPaste each CSVConnect your shopDrop the CSV files
Inventory and COGSOnly if you build itYes, the main strengthNo, monthly costs only
Your dataIn your Google or Excel accountOn their serversStays on your computer
UpkeepYou maintain the formulasKeep inventory currentAdd each new month's CSV

How to do it manually (free)

Whichever tool you choose, this method shows what a good report must do. It needs a spreadsheet and about half an hour per month once set up.

  1. Download the CSV. Shop Manager → Finances → Monthly statements → Download CSV. See the statement guide for what the columns mean.
  2. Paste it into a new tab. Keep the columns Date, Type, Title, Info, Currency, Amount, Fees & Taxes, Net.
  3. Add a Category column. Use Type first: Sale, Tax, Refund, Marketing, Shipping, Deposit and Payment. Then use Title to split Fee rows into transaction, processing, listing or renewal, regulatory and other. Offsite Ads is a Marketing row with "Offsite" in the title.
  4. Convert text to numbers. Statement values such as "$1,250.00" and "--" are text. Strip the symbol and commas, and treat "--" as zero.
  5. Total each category with SUMIF. For example: =SUMIF(Category,"Transaction fee",Net).
  6. Calculate profit. Sales plus refunds, minus fees, ads and shipping, minus your own costs. Leave out Tax and Deposit rows.
  7. Check it. The categories should add up to the sum of the Net column. If they do not, a row is uncategorised.
Refund-related fee credits are positive Fee rows. Keep them in the same category as the original fee so they cancel out.

To estimate one order before it happens, try the fee calculator.

Which should you pick?

These also combine. Some sellers use an inventory tool for costing and run their statements through ShopTally as a second check.

Try it on your own statement

The free edition reads your latest month so you can see whether the numbers match your records before you buy.

One-time $24. Runs offline in your browser. The free edition shows your latest month only.

Questions

Can I track Etsy profit in a free spreadsheet?

Yes. Paste each monthly statement CSV into a tab, tag every row with a category, and total the categories with SUMIF. It works well if you are comfortable with formulas and do not mind the monthly routine.

When is a subscription tool better than ShopTally?

When you need inventory, materials and cost of goods sold (COGS) tracked per product. Tools of that type are built for makers who need to know what each item costs to make. ShopTally only reads the statement and shows what you kept.

Does ShopTally track my materials and COGS?

Only at the month level. You can enter your costs, such as materials and packaging, for each month to see profit and margin. It does not do per-product inventory or recipes.

Is my data uploaded?

No. ShopTally is a single file that runs in your browser. Your statements stay on your computer.

What does the free edition do?

It shows your latest month only, so you can check that it reads your statement correctly before paying $24 once for unlimited months.