FPFeeProofed

Guide

10 min readReviewed 2026-07-04

Bookkeeping for Etsy sellers

Good Etsy bookkeeping is a monthly habit, not a tax-season rescue. Track sales, refunds, fees, shipping labels, COGS, ads, and cash deposits separately.

Quick answer

Bookkeeping for Etsy sellers should separate gross sales, refunds, Etsy fees, shipping labels, product cost, packaging, ads, sales tax collected by Etsy, and bank deposits. The bank deposit is not profit because Etsy deducts fees, labels, ads, and refunds before money reaches the bank.

Test the answer with your own cost, fee, and margin numbers.

Open calculator

Decision checkpoints

  • Track the order and the deposit separately.
  • Etsy fees should not disappear inside net deposits.
  • COGS needs inventory records.
See worked examples

Use the numbers while you read

Etsy Profit Calculator

Open this guide beside the calculator and test your own cost, fee, margin, or ad assumptions. The examples below are useful, but your decision should use your own numbers.

Loading calculator...

Core formulas

The formulas to keep straight

Order profit = revenue - Etsy fees - COGS - shipping - packaging - ads
Monthly profit = total order profit - monthly overhead
Deposit reconciliation = Etsy available deposit + pending balance + fees and deductions
COGS = beginning inventory + purchases - ending inventory

What bookkeeping do Etsy sellers need?

Etsy sellers need records that explain revenue, deductions, and profit. A clean monthly workbook has tabs for orders, fees, shipping labels, inventory or COGS, expenses, deposits, and a summary.

The deposit tab matters because Etsy deposits are net of many deductions. A $500 sales week can produce a much smaller bank deposit without meaning anything is wrong.

Monthly Etsy bookkeeping tabs

TabPurpose
OrdersGross revenue, refunds, shipping charged.
FeesListing, transaction, processing, ads, Offsite Ads.
Shipping labelsPostage and fulfillment cost.
Inventory or COGSMaterials used by sold products.
ExpensesSoftware, supplies, mileage, professional help.
DepositsBank transfers and timing.
SummaryProfit, margin, cash, and tax-ready totals.

What should Etsy sellers do each month?

Close each month with the same checklist: export Etsy data, record non-Etsy expenses, update inventory, reconcile deposits, and review profit by product. Do it while the month is still fresh.

If a product sells often but shows weak profit, fix price or cost before adding more listings.

  • Export Etsy orders and payment account data.
  • Add supplier receipts and software charges.
  • Update inventory and COGS.
  • Match deposits to Etsy payment records.
  • Review profit by product and channel.

When should Etsy sellers move from spreadsheet to software?

Move when bookkeeping takes too long, inventory gets messy, or you need reports that a spreadsheet cannot produce reliably. For a small Etsy shop, a good spreadsheet can be the right first system.

Verified July 4, 2026, Stocksmith lists automatic COGS, materials, products, channel integrations, users, and order-line limits on its pricing page. That kind of software makes more sense when inventory and production are already bigger than a simple sheet.

Spreadsheet vs software

SituationBetter fit
Under 100 orders a monthSpreadsheet may be enough.
Lots of raw materialsInventory software may help.
Multiple sales channelsSoftware reduces manual updates.
Batch or lot trackingSoftware is usually better.
No monthly habit yetStart with a sheet first.

Decision table

Etsy bookkeeping decisions

QuestionRecord to checkWhy
Why was my deposit low?Payment account and labelsShows deductions.
Did the product profit?Order plus COGSShows product economics.
Can I raise ads?Profit by listingShows ad room.
What did I spend?Expense tabSupports tax records.
What changed?Monthly summaryShows trend.

Worked examples

Examples you can compare against your own numbers

Example: why the bank deposit is not profit

A seller has $1,200 in Etsy order revenue for the month.

Gross order revenue$1,200Buyer payments before deductions.
Etsy fees and ads$160Marketplace deductions.
Shipping labels$190Bought through Etsy.
Bank deposits$850Cash received before COGS.
COGS$420Materials and product cost.
Profit before overhead$430$850 - $420.

Takeaway: The deposit is a cash number. Profit still needs COGS and other expenses.

Action checklist

Before you use this number in the real business

  1. 1Export Etsy data monthly.
  2. 2Record outside expenses.
  3. 3Update inventory and COGS.
  4. 4Reconcile bank deposits.
  5. 5Review product profit.
  6. 6Back up the file.

Common mistakes

Mistakes that make the answer look better than reality

Using bank deposits as profit.
Missing shipping label costs.
Ignoring materials already used.
Not separating ads from fees.
Letting receipts pile up.

FAQs

Questions people ask before making the decision

Can Etsy sellers use a spreadsheet for bookkeeping?

Yes. A spreadsheet works if it separates orders, fees, shipping labels, COGS, expenses, and deposits, and if it is updated monthly.

Is my Etsy deposit my profit?

No. The deposit is cash after some Etsy deductions. Profit still needs COGS, packaging, outside expenses, and other costs.

What Etsy reports should I export?

Export orders and payment account activity at minimum. Sellers with inventory should also keep material purchases and finished-goods records.

When do I need accounting software?

Use software when inventory, multi-channel sales, or monthly reporting becomes too slow or error-prone for a spreadsheet.

Sources and notes

Where the assumptions come from

IRS: Understanding your Form 1099-K

Official IRS guidance for Form 1099-K, card payments, TPSO thresholds, and reporting income.

IRS: Guide to business expense resources

Official IRS resource map for business expenses, inventory, records, depreciation, and related forms.

Stocksmith pricing

Official Stocksmith pricing page for Indie, Business, Growth, and Craftybase Studio pricing.

FeeProofed methodology

FeeProofed source, calculator, and review methodology.