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.
- Good: cheap or free, fully customisable, and you can see every formula.
- Not so good: the monthly paste-and-fix routine is yours to maintain. New or unusual row types can slip into the wrong total unnoticed, and a broken formula may not announce itself.
- Best for: people who like spreadsheets and want control.
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.
- Good: real inventory and COGS, which a statement cannot give you. If you make products from materials and need to know what each item costs, this is the right category.
- Not so good: more setup (materials, recipes, stock counts), a recurring cost, and your data lives on their servers.
- Best for: makers who need per-product costing and inventory.
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.
- Good: about a minute to set up, duplicate files are skipped, and unrecognised rows are flagged rather than guessed.
- Not so good: no inventory or per-product COGS. You enter monthly costs yourself.
- Best for: knowing what you actually kept each month.
Side by side
| Spreadsheet | Subscription | ShopTally | |
|---|---|---|---|
| Cost | Free to a one-time price | Monthly fee | $24 once |
| Getting data in | Paste each CSV | Connect your shop | Drop the CSV files |
| Inventory and COGS | Only if you build it | Yes, the main strength | No, monthly costs only |
| Your data | In your Google or Excel account | On their servers | Stays on your computer |
| Upkeep | You maintain the formulas | Keep inventory current | Add 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.
- Download the CSV. Shop Manager → Finances → Monthly statements → Download CSV. See the statement guide for what the columns mean.
- Paste it into a new tab. Keep the columns Date, Type, Title, Info, Currency, Amount, Fees & Taxes, Net.
- 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.
- Convert text to numbers. Statement values such as "$1,250.00" and "--" are text. Strip the symbol and commas, and treat "--" as zero.
- Total each category with SUMIF. For example:
=SUMIF(Category,"Transaction fee",Net). - Calculate profit. Sales plus refunds, minus fees, ads and shipping, minus your own costs. Leave out Tax and Deposit rows.
- Check it. The categories should add up to the sum of the Net column. If they do not, a row is uncategorised.
To estimate one order before it happens, try the fee calculator.
Which should you pick?
- You enjoy spreadsheets and want full control: use the manual method or a template.
- You need inventory and per-product COGS: choose a subscription tool.
- You want the answer to "what did I keep this month" without building or maintaining anything: ShopTally.
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.