If you sell on Etsy, the single most important habit you can build is recording every transaction the moment it happens—not at tax time when your memory and your receipts have both gone fuzzy. A good bookkeeping spreadsheet should capture four things for each sale: gross revenue, Etsy's layered fees (listing, transaction, payment processing, and any Offsite Ads cut), your cost of goods (materials, packaging, shipping labels), and the net profit left over. Tracking fees separately matters because Etsy quietly takes 6.5% plus payment processing on every order, and many sellers are shocked to learn their real margin is far thinner than the sticker price suggests. Add a monthly summary tab that rolls up income and expenses by category so you can see seasonal trends, set aside the right amount for self-employment tax (a safe rule is 25–30% of net profit), and walk into tax season with clean numbers instead of a shoebox of confusion. If building all those formulas from scratch feels overwhelming, a ready-made Etsy bookkeeping template can save you hours—it comes pre-built with fee calculations, profit-per-item tracking, and tax-ready summaries, so you just plug in your sales and let the spreadsheet do the math.
More tools by AM&PM: https://ampmgenius.gumroad.com
Top comments (0)