An Etsy shop's sales figure and its bank deposit never match, and bookkeeping for the shop is mostly explaining the gap. Between the two are Etsy's fees, the shipping label, and sales tax that Etsy collected from the buyer and sent to the state without it ever being yours. Then, outside Etsy, there's what the item cost you to make. A bookkeeping sheet for the shop has one row for each order with all of those on it, and one sum: what you keep. A second sheet adds the costs that don't belong to any one order (listing renewals, ads, the kiln or the printer) to show what the month left. In the made-up potter's month below, five orders and one refund brought $206 of item sales, and after fees, labels, materials and other costs, $36 was left. Below are the sheet, where each figure comes from, and the file.
The short version
- One row an order. One row a refund.
- Copy the fees from Etsy's own records. Don't calculate them.
- Sales tax Etsy collects isn't income. Record it and leave it out of the sum.
- Put your materials cost on each order: that's the figure Etsy can't know.
- Listing fees, ads and other shop costs go in by the month.
- TaroStack keeps the materials and what each piece cost to make. It doesn't connect to Etsy. More below.
A month of orders
| Date | Item | Item price | Shipping charged | Etsy fees | Label | Materials | You keep |
|---|---|---|---|---|---|---|---|
| Nov 3 | Stoneware mug | $38.00 | $6.50 | $4.63 | $7.85 | $6.40 | $25.62 |
| Nov 5 | Stoneware mug x2 | $76.00 | $9.00 | $8.72 | $11.40 | $12.80 | $52.08 |
| Nov 8 | Planter, small | $28.00 | $6.50 | $3.61 | $7.85 | $5.10 | $17.94 |
| Nov 12 | Serving bowl | $64.00 | $0.00 | $8.74 | $12.60 | $11.20 | $31.46 |
| Nov 15 | Stoneware mug | $38.00 | $6.50 | $4.63 | $7.85 | $6.40 | $25.62 |
| Nov 18 | Refund: mug arrived broken | −$38.00 | −$6.50 | −$3.91 | $0.00 | $0.00 | −$40.59 |
You keep is the item price plus shipping charged, less Etsy's fees, the label, and materials.
The serving bowl. Free shipping, so the $12.60 label came out of the $64. The buyer also found it through an ad, and the fee shows it. It kept $31.46, under half its price.
The refund. The mug, the label and part of the fees are gone, and the buyer has their money back: a row of its own, in negatives. A sheet that just deletes the original order hides what breakage costs. One broken mug wiped out one and a half good ones, which is the argument for better packing.
The month
| Item sales, less refunds | $206.00 |
| Shipping charged to buyers | $22.00 |
| Etsy fees on orders | −$26.42 |
| Shipping labels | −$47.55 |
| Materials and packaging in what sold | −$41.90 |
| Kept from orders | $112.13 |
| Listing fees and renewals | −$4.80 |
| Etsy ads | −$31.00 |
| Other shop costs: photo props, a share of kiln firing | −$40.00 |
| Left for the month | $36.33 |
| Sales tax collected and sent by Etsy (for your records) | $13.55 |
Shipping is worth a second look: buyers paid $22.00 and labels cost $47.55. This shop is paying more than half of its postage. That can be the right choice. It should be a choice.
And the $31 of ads brought one order that kept $31.46.
Where each figure comes from
Item price, shipping charged, sales tax. From the order itself.
Etsy fees. From the order's own fee lines or the monthly statement in the shop's payment account. There are several kinds of fee, they've changed over the years, and some depend on how the buyer found you. Copy the amounts. A formula with last year's percentage in it will be quietly wrong.
Shipping label. From the label purchase, which Etsy also lists on the statement if you buy labels there.
Materials and packaging. This is yours to know. For the mug: clay, glaze, a share of two kiln firings, the box, the padding. Work it out once for each kind of item and reuse it until a price changes. How is in how to price pottery and, more generally, craft pricing calculator.
Fees not tied to an order. Listing and renewal fees, ads, and any subscription are on the monthly statement. One line each, by the month.
Sales tax
In most US states Etsy collects sales tax from the buyer and pays it to the state itself. That money appears in the order total and never reaches you. Record it in its own column so the order adds up, and keep it out of your income. Whether you have any sales tax duties of your own, for sales made elsewhere, is a question for your state's tax office or an accountant.
At tax time
The sheet gives the year's totals: sales, fees, postage, materials, other costs. Etsy sends its own annual figures, and they'll show the gross amount buyers paid, which is larger than your income. The sheet is how you show the difference. Keep receipts for materials and tools. What counts as cost of goods for a maker is in craft business cost of goods sold.
This is general information, not tax or accounting advice.
Get the spreadsheet
Download the Etsy bookkeeping spreadsheet. An Orders sheet where what you keep works itself out, and a Month sheet that totals the orders and takes off the month's other costs. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A stock sheet for the same shop is in Etsy inventory spreadsheet.
Where this stops working
"Materials: $6.40" for a mug was worked out in the spring. Since then clay went up, the glaze changed, and a third of one firing cracked. The sheet still says $6.40, on every row, and the margin it reports is the margin you had in April. Meanwhile the shop shows six mugs in stock and the shelf has four.
How TaroStack does it
TaroStack doesn't connect to Etsy, so orders and quantities there are still entered by hand. What it keeps is the part Etsy can't: the materials and the making.
Each kind of piece is a recipe. Clay by weight, glaze, a box.
Each firing or making session is a batch. It takes the materials from stock at what they cost, and records how many good pieces came out. The cracked ones are in the cost of the good ones.
The cost of a piece is real, from the last purchases of clay and glaze, with a price-creep report by supplier.
Finished pieces are stock, counted on a phone, so the number you type into a listing is the number on the shelf.
"What could I make right now" says how many mugs the clay and glaze allow.
| The figure | On the sheet | In TaroStack |
|---|---|---|
| Materials in a mug | Worked out once | From what each batch used |
| Pieces lost in a firing | Not counted | In the batch's yield |
| Finished stock | What the listing says | A count |
| Etsy's fees and orders | Typed from Etsy | Still typed from Etsy |
TaroStack isn't an accounting system. Stock, recipes and costing are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
