Use cases

Etsy seller profit tracker: track your shop finances

Running an Etsy shop means juggling revenue, fees, materials and shipping. SheetLink syncs your bank account to Google Sheets when you press Sync now, so Etsy deposits, business expenses and profit margins live in one spreadsheet.

Free for one bank and your last 7 days. No card needed.

Press Sync now and new transactions land at the end of your Google Sheet.

Why Etsy sellers choose SheetLink

Most Etsy sellers use manual spreadsheets or expensive accounting software. SheetLink bridges the gap:

  • Sync Etsy deposits when you choose: track revenue as Etsy pays out to your bank account
  • Track business expenses: materials, shipping supplies, packaging, marketing
  • Calculate real profit: subtract fees and costs to see your actual profit per sale
  • Monitor cash flow: see what’s in your business account as of your last sync
  • Tax-ready records: organized transactions for Schedule C
  • Affordable pricing: Pro is $4.99/month, vs QuickBooks at $38-140/month

Why manual sync works for Etsy sellers

SheetLink only syncs when you press Sync now. Unlike tools that pull from your bank in the background, it gives you complete control over when your financial data reaches your spreadsheet. That’s a privacy feature, not a limitation.

Made for weekly or monthly reviews

Most Etsy sellers review their finances weekly (to track sales and inventory needs) or monthly (to reconcile expenses and calculate taxes). Manual sync fits that: press Sync now during your review, categorize the new transactions, and you’re done. No need for daily automatic updates.

How to set up your Etsy shop finance tracker

Get your Etsy bookkeeping organized in under 10 minutes:

1

Install the SheetLink Chrome extension

Add it from the Chrome Web Store.
2

Connect your business bank account

Link the account Etsy pays into, through Plaid.
3

Connect your business credit card (optional)

To track supply purchases and shipping costs.
4

Create your Etsy finance sheet

Start with a blank sheet or an Etsy seller template of your own, and paste its link into SheetLink. It writes a Transactions tab and an Accounts tab.
5

Press Sync now

Deposits and expenses land at the end of the Transactions tab. Rows already there are skipped.
6

Add custom columns

Tag transactions as revenue, COGS, fees, shipping or marketing.
7

Calculate profit

Use formulas to track profit per product or per month.

What expenses should Etsy sellers track?

SheetLink syncs your business transactions so you can track every cost that affects your profit:

Cost of goods sold (COGS)

Raw materials and suppliesWholesale inventoryPackaging materialsPrinting costsProduct labels

Operating expenses

Etsy listing feesEtsy transaction fees (6.5%)Payment processing fees (3% + $0.25)Shipping costsMarketing and adsSoftware subscriptions

Calculate your true profit per sale

Many Etsy sellers don’t realize how much fees eat into profit. Here’s how to calculate it accurately:

Example: a $50 handmade jewelry sale

LineAmount
Sale price$50.00
Etsy transaction fee (6.5%)-$3.25
Payment processing (3% + $0.25)-$1.75
Shipping cost-$5.00
Materials cost (COGS)-$15.00
Packaging-$2.00
True profit$23.00 (46% margin)

Build formulas in Google Sheets to calculate this for every sale.

Track multiple revenue streams

Many Etsy sellers sell on other platforms too. SheetLink can sync several bank accounts, so you can track:

  • Etsy shop revenue: your main income stream, from Etsy deposits
  • Shopify or your own website: additional sales channels
  • Craft fair sales: cash or card reader deposits
  • Wholesale orders: B2B sales to retailers
  • Custom commissions: one-off custom work

Separate transactions by source in your sheet to see which channels are most profitable.

Manage inventory costs with SheetLink

Track material purchases and match them to product sales:

1

Sync supply purchases

SheetLink brings in every charge to your business credit card for materials from suppliers like Amazon, Michaels or wholesale vendors.
2

Tag by product line

Add a Product column to your sheet and tag each material cost with the product it’s for (Earrings, Necklaces, Bracelets).
3

Calculate the cost per unit

Divide total material costs by the units produced. Example: $100 in beads makes 20 necklaces, so COGS is $5 per necklace.
4

Track profit by product

See which products have the highest margins, and focus your shop on the best-sellers with strong profit.

SheetLink vs. Etsy accounting tools

ToolCostBest for
SheetLink$4.99/month (Pro)Solo Etsy sellers, side hustlers
QuickBooks$38-140/monthMulti-channel sellers, inventory tracking
Manual CSVFree (time cost)Very small sellers, hobby shops

Tax season for Etsy sellers

Etsy sellers report self-employment income on Schedule C. Your synced sheet keeps you organized:

  • Track gross income: your Etsy deposits, synced when you press Sync now, plus the fees Etsy kept back
  • Categorize deductions: COGS, shipping, fees, marketing, home office
  • Quarterly estimated taxes: watch your profit to calculate quarterly tax payments
  • Year-end tax prep: income and expense totals for your accountant or tax software
  • 1099-K reporting: Etsy sends a 1099-K once your sales pass the IRS reporting threshold; check it against your SheetLink records

Two example Etsy sellers

Sarah: handmade jewelry shop

Challenge: Sarah tracked sales in a spreadsheet by hand but couldn’t keep up with daily orders.

Solution: SheetLink syncs her Etsy deposits and the material purchases on her business card when she presses Sync now. She tags each transaction by product line.

Result: Her earrings had 60% margins while her necklaces had only 30%. She shifted her focus to earrings and increased her profit by 40%.

Mike: printable digital downloads

Challenge: Mike had no COGS but wasn’t tracking Etsy fees, so he overestimated his profit.

Solution: SheetLink syncs his bank deposits, which show net revenue after Etsy takes its fees. Mike added a formula to calculate his effective fee rate.

Result: Fees were 10% of revenue, not 6.5%, once payment processing was counted. He adjusted his prices to protect his margins.

Pricing

PlanPriceWhat you get
Free$01 bank, your last 7 days, Google Sheets
Pro$4.99/mo or $39.99/yrEvery bank you connect, up to 2 years of history, Google Sheets and Excel, priority email support
Max$10.99/mo or $99/yrEverything in Pro, plus investments, CLI automation, Postgres and SQLite output, and Claude

Compare every plan ›

Questions

How do I track Etsy shop finances in Google Sheets?

Install the SheetLink Chrome extension and connect the bank account Etsy pays into, through Plaid. Press Sync now and your Etsy deposits land in your Google Sheet along with business expenses like supplies and shipping. From there, categorize transactions, calculate profit margins and track cash flow. A sync before each weekly or monthly review keeps it current.

Can SheetLink track Etsy fees and shipping costs?

Partly. Etsy takes its fees, and shipping labels you buy on Etsy, out of your sales before it deposits the rest, so your bank sees the net deposit, and that’s what SheetLink syncs. Postage, supplies and anything else charged to your card come through as their own transactions. Add columns to tag Etsy-specific costs (listing fees, transaction fees, payment processing fees and shipping) and take the fee breakdown from your Etsy payment account statements, so you can calculate true profit per sale.

Do I need QuickBooks for my Etsy shop?

Not necessarily. For most Etsy sellers, Google Sheets with SheetLink is simpler and cheaper than QuickBooks: SheetLink Pro is $4.99 a month, QuickBooks paid plans $38 to $140 a month. You choose when to sync, and you get expense tracking and profit calculations without the complexity of full accounting software. Move to QuickBooks only if you need advanced inventory management or multi-channel selling.

How do Etsy sellers calculate profit margins?

Start with revenue (gross sales from your Etsy statements; your deposits arrive with the fees already taken out) and subtract cost of goods sold (materials, supplies), Etsy fees (listing, transaction, payment processing), shipping and other expenses (packaging, marketing). SheetLink syncs the transactions to Google Sheets, where formulas give you profit per product, profit per month and your overall margin. Formula: (Revenue - Total costs) / Revenue × 100 = Profit margin %.

See it work.

Free with one bank and your last 7 days. Pro and Max sync every bank, two years back. Add to Chrome ›

Keep reading.

Freelance income tracker: track client payments and expenses

Privacy-first freelance income tracker. Sync income and expenses to Google Sheets when you choose. Track 1099 income from multiple clients, organize deductible expenses, and prepare for quarterly taxes. Manual sync gives you control.

Dropshipping finance tracker: track Shopify, Amazon and ecommerce profit

Privacy-first dropshipping finance tracker. Sync dropshipping finances to Google Sheets when you choose. Track Shopify/Amazon revenue, supplier costs (COGS), shipping, ad spend, and profit margins. Manual sync gives you control.

Gig worker bookkeeping: track Uber, DoorDash and delivery income

Privacy-first gig worker bookkeeping. Sync gig economy income to Google Sheets when YOU choose. Track Uber, DoorDash, Instacart earnings, mileage deductions, and vehicle expenses. Manual sync gives you control.

Designer bookkeeping

Privacy-first designer bookkeeping. Sync your bank to Google Sheets when you choose, with Upwork, Fiverr and PayPal payouts as they land. Track Adobe subscriptions, design tool expenses, and client invoices. Manual sync gives you control.

Amazon FBA Bookkeeping in Spreadsheets

How to set up Amazon FBA bookkeeping in Google Sheets with automated transaction imports.

Reseller profit tracker: track your resale business finances

Privacy-first reseller profit tracking. Sync eBay, Poshmark, Mercari sales to Google Sheets when YOU choose. Track platform fees, shipping costs, and sourcing expenses with manual sync control.

Know your real shop profit.

Free for one bank and your last 7 days. No card needed.