Etsy Seller Bookkeeping Spreadsheet POD

SHOP LEDGER: ETSY POD BOOKKEEPING WEB APP FOR GOOGLE SHEETS

Etsy tells you your "net profit." But it leaves out what you paid Printify, Printful or Gelato.

Shop Ledger shows your REAL profit. Drop in your Etsy monthly statement and your print-on-demand order export, and it matches every Etsy order to its print cost automatically. No copying and pasting between tabs.

Real example from our own print-on-demand shop: Etsy said September's net profit was $1,513. After our Printify costs, we actually made $931. Shop Ledger matched all 10 orders on its own.

━━━━━━━━━━━━━━━━━━━━
✦ HOW IT WORKS
━━━━━━━━━━━━━━━━━━━━

1. Download your Etsy monthly statement (Finances → Monthly statements → CSV)
2. Download your Printify, Printful or Gelato order export
3. Drop both files into Shop Ledger
4. See your profit per order, per product and per month

Safe to re-import anytime. Shop Ledger skips anything it already has.

━━━━━━━━━━━━━━━━━━━━
✦ WORKS WITH
━━━━━━━━━━━━━━━━━━━━

✓ Printify (auto-detected)
✓ Printful (auto-detected)
✓ Gelato
✓ Any other POD company: pick the columns once and Shop Ledger remembers
✓ Digital or handmade orders too (mark them as having no print cost)

━━━━━━━━━━━━━━━━━━━━
✦ WHAT'S INSIDE
━━━━━━━━━━━━━━━━━━━━

✓ Profit dashboard for any date range, compared with last year
✓ "Etsy says" vs. "you actually made"
✓ Monthly sales and profit chart
✓ Where each sale goes: POD costs, Etsy fees, ads, expenses, profit
✓ Monthly profit goal
✓ Every order with fees, print cost, profit and margin
✓ Alerts for orders that lost money or are missing a print cost
✓ Manual matching for replacements and samples
✓ Profit and margin for every product
✓ Etsy fee breakdown: transaction, processing, listing, Offsite Ads, Etsy Ads, subscriptions
✓ Payouts to your bank
✓ Expenses with monthly or yearly repeats (Canva, mockups, samples, ads)
✓ Tax Center: quarterly profit, suggested tax set-aside and estimated payment dates
✓ Schedule C-style summary for your tax pro
✓ Sales tax collected by Etsy kept separate from your income
✓ Accountant-ready Orders, Monthly Summary and Tax Summary tabs that update on their own
✓ CSV downloads
✓ Sample shop to explore before you import
✓ Works on desktop, tablet and phone

━━━━━━━━━━━━━━━━━━━━
✦ PRIVATE AND SECURE
━━━━━━━━━━━━━━━━━━━━

• No passwords. Shop Ledger never asks for your Etsy or POD login
• No API keys. You download your own files
• Files are read in your browser and saved only to your own Google Sheet
• Buyer names and addresses are skipped on import

━━━━━━━━━━━━━━━━━━━━
✦ YOU WILL RECEIVE
━━━━━━━━━━━━━━━━━━━━

This is an instant digital download with 2 PDFs:
1. How to Access: your link to make your own copy of the Shop Ledger Google Sheet
2. Setup Guide: where to download each file, the one-time Google permission step, a tour, tax time, and how to use it on your phone

━━━━━━━━━━━━━━━━━━━━
✦ GOOD TO KNOW
━━━━━━━━━━━━━━━━━━━━

• You need a free Google account. A computer is easiest for importing files
• The first time you open it, Google shows a "Google hasn't verified this app" screen. This is normal for every Google Sheets script. Your guide shows exactly what to click
• Built for US Etsy sellers. Other currencies work, but tax lines follow the US Schedule C
• Shop Ledger is a bookkeeping tool, not tax, legal or financial advice. Please review your numbers with a tax professional
• Shop Ledger does not connect to Etsy or your POD account. You download and import your own files
• Digital product only. No physical item will be shipped
• Because this is a digital download, returns and exchanges aren't accepted. If anything isn't working, please message us and we'll gladly help

For use in your own shop. Please don't share, resell or redistribute the template link.

Questions? Message Muse & Make Co anytime. We're happy to help.

Thank you for supporting our small shop! ✦Created by Muse & Make Co with the help of AI tools.