P&L template for an Etsy shop
A free, self-calculating profit & loss spreadsheet set up for an Etsy shop: type your statement lines on one tab and the monthly P&L builds itself, with guidance for the categories this trade actually uses.
- Free Excel file preloaded for an Etsy shop; works in Google Sheets and Numbers too.
- Type transactions once; twelve monthly P&L columns calculate themselves.
- Category guidance for this trade: materials (cogs), shipping supplies & postage, etsy fees (where separate), and more.
- Transfers, card payments, and owner draws get an excluded section so they never inflate or deflate profit.
- Prefer not to type? RapidPnL builds the same P&L from your statement PDFs in minutes, reconciled to the penny, for $49.
Excel format (.xlsx), about 25 KB, free, no email required.
Download the templateWhat income looks like for a Etsy shop
Etsy Payments deposits arrive under names like ETSY INC or ETSY DEPOSIT, on whatever schedule the shop settings choose: daily, weekly, biweekly, or monthly. Each deposit is a batch of sales minus Etsy's fees (listing, transaction, payment processing, and any Etsy Ads or Offsite Ads charges taken from the payment account) and minus refunds issued in the period. The bank therefore sees settled cash, not gross sales, and the P&L says so in its basis note. Craft-fair and market sales appear only when the cash or the card-reader batch (Square, PayPal Zettle) gets deposited, and direct sales through a standalone site show as separate processor patterns. Each stream is a recurring name, categorized once.
In the template, every deposit gets entered as a positive amount and categorized as Sales & Services Revenue (or Other Income when it genuinely is not sales). The monthly columns then show your revenue pattern at a glance, which is the first thing a lender reads.
The expense categories that matter
Fabric, beads, clay, wood, packaging that ships inside the product. Joann, Michaels, Hobby Lobby, and wholesale suppliers are the recurring merchants, and this line is the shop's cost of goods.
Boxes, mailers, labels, and postage bought outside Etsy. Labels purchased through Etsy are usually deducted from the payment account instead, so they never debit the bank separately.
Most fees net out of deposits, but a shop with thin sales can see Etsy bill the card on file for an outstanding fee balance. Those debits get their own visible line.
Design tools, photo editing, a standalone-site subscription, bookkeeping apps. A small stack that grows one tool at a time.
Craft-fair tables and market stalls, often paid weeks ahead of the event. Cash basis puts them in the month paid.
The part most templates get wrong
Transfers between your own accounts, credit card payments made from checking, owner draws, and loan principal are cash movements, not income or expenses. A homemade P&L that counts them reports the wrong profit, and it is the first thing an experienced reviewer notices. This template gives those categories a dedicated excluded section below the P&L: the cash stays tracked, the profit stays honest.
The honest test of any hand-built P&L is reconciliation: for each account and month, the beginning balance plus every line you entered must equal the printed ending balance. The Start-here tab walks through the check. If typing and checking a year of statements is more weekend than you want to spend, the Etsy shop P&L guide shows what the finished product looks like, and RapidPnL builds it from your statement PDFs in minutes.
Upload the PDFs and get a management-use profit & loss in minutes, with every statement reconciled to the penny. $49 for 3 months, then $9 each additional month. Full refund if we can't reconcile.
The free statement is read, categorized, and reconciled on screen before you pay anything. One per person; no card required.
Common questions
Materials (COGS), Shipping supplies & postage, Etsy fees (where separate), Software & subscriptions do most of the work on this trade's P&L. The template's Start-here tab explains each one, and the dropdown carries the full chart of accounts so nothing gets forced into the wrong bucket.
Record what actually lands on the bank statement. Etsy Payments deposits arrive under names like ETSY INC or ETSY DEPOSIT, on whatever schedule the shop settings choose: daily, weekly, biweekly, or monthly. Enter each deposit as a positive amount under Sales & Services Revenue; processor fees that appear as separate debits get their own expense line.
Same engine and formulas, tuned for an Etsy shop: the Start-here tab lists the categories that matter for this trade and why, and the Transactions tab opens with example entries that look like this business's real statement lines.
Other industries
- Cleaning business →
- Contracting business →
- Restaurant →
- Food truck →
- E-commerce business →
- Landscaping business →
- Trucking business →
- Salon →
- Consulting practice →
- Handyman business →
- Photography business →
- Auto repair shop →
- Amazon business →
- Rideshare or delivery business →
- Short-term rental business →
- Real estate practice →
Written by a licensed CPA. This guide is general information, not tax, legal, accounting, or financial advice, and does not create a professional relationship. Lender requirements and bank websites change; confirm specifics with your lender and financial institution. RapidPnL reports are cash-basis summaries generated from customer-provided data for management use only, not audited or CPA-reviewed. © 2026 RapidPnL LLC.