Etsy Seller Bookkeeping Spreadsheet Google Sheets Shop Fee Calculator Income Expense Profit Tracker Small Business Bookkeeping Template Tax

Your sale price is not your profit. This bookkeeping spreadsheet shows what you actually keep. 🛍️

Between transaction fees, payment processing, listing fees, and ads, a big chunk of every sale disappears before it reaches you — and that's before materials and shipping. The EasyVault Shop Seller Bookkeeping Spreadsheet reveals your true profit on every order and every month, with a built-in fee calculator, an auto-calculating order log, a categorized expense tracker, a full profit & loss statement, and 10 charts across 10 tabs — all in a warm, easy-to-use design.

✦ THE PROBLEM THIS SOLVES:
Most sellers track what came in but not what fees quietly took out. That makes it impossible to know your real margins, price with confidence, or set aside the right amount for taxes. This template does the math for you — set your fee rates once, log each sale, and watch your true profit calculate automatically.

✦ WHAT'S INSIDE (10 TABS):

🛍️ Welcome — The seller profit playbook, with a quick-start guide
🧮 Fee Calculator — Enter a sale → see every fee & real take-home ⭐
💰 Orders — Log each sale; fees & net profit auto-calculate
🧾 Expenses — Materials, shipping, ads & tools, sorted for tax time
📊 Dashboard — Revenue, fees, expenses & true profit at a glance
📈 Profit & Loss — Full P&L with true margins
🏆 Product Performance — See which products earn the most
🧯 Tax Summary — Deduction categories & quarterly set-aside
📉 Annual Trends — Revenue vs fees vs profit across the year
📒 Guide & Notes — The seller profit playbook, plus your notes

✦ KEY FEATURES:
• True-profit fee calculator — set your rates once, test any sale instantly
• Auto-calculating order log — enter price, shipping & cost; fees and net profit fill in
• Handles transaction fees, payment processing (% + flat), listing fees & optional ads
• Categorized expense tracker with 10 tax-deduction categories
• Full Profit & Loss statement built from your orders & expenses
• Product performance ranking — find your best earners
• Tax summary with quarterly set-aside estimate
• 10 charts total — pie, doughnut, bar & line
• Warm, friendly design that's easy to keep up with
• Works on desktop, tablet & mobile

✦ CHARTS & VISUALS (10 total):
• Pie — Where your sale dollar goes
• Doughnut — Fee breakdown per sale
• Pie — Expenses by category
• Doughnut — Where revenue goes
• Line — Revenue vs profit by month
• Bar — Revenue → net profit (P&L)
• Bar — Revenue by product
• Bar — Profit by product
• Doughnut — Deductions by category
• Line + stacked bar — Annual trends

✦ BONUS INCLUDED:
A prefilled SAMPLE spreadsheet shows the whole system working — 40 orders, real fees, expenses, a full P&L and annual trends for a healthy shop — so you can see it in action before adding your own numbers.

✦ HOW TO USE:
1. Purchase & download the PDF with your Google Sheets link
2. Click the link and go to File → Make a Copy
3. Set your fee rates once on the Fee Calculator (defaults included)
4. Log each sale on the Orders tab — fees & profit auto-calculate
5. Track expenses & watch your true profit on the Dashboard!

✦ WHAT YOU GET:
• 1x Shop Seller Bookkeeping Spreadsheet (Google Sheets — blank)
• 1x BONUS Sample Spreadsheet (Google Sheets — prefilled)
• Step-by-step instructions included

✦ REQUIREMENTS:
• Free Google account (works with Google Sheets)
• Also opens in Excel
• Works with any currency (enter your own fee rates)
• Works on any device with internet access

✦ PERFECT FOR:
Handmade sellers • Digital product shops • Print-on-demand sellers • Craft & maker businesses • Vintage sellers • Anyone selling online who wants to know their true profit after fees • New shop owners getting organized for tax time

✦ WHY EASYVAULT?
This isn't just an income list — it's a complete bookkeeping system with a real fee calculator, P&L, and tax summary, designed specifically for online shop sellers who want to understand and grow their profit.

⚖️ DISCLAIMER:
This product is for informational purposes only. EasyVault does not provide financial, tax, or legal advice, and fee rates and tax rules change — always confirm current selling fees with your platform and consult a licensed professional for tax guidance.

Please note: This is a DIGITAL product. No physical item will be shipped. Listing images show example data for demonstration; the template is blank and ready for your input (a prefilled sample is included too). Not affiliated with or endorsed by any selling platform.

© EasyVault. All rights reserved. Personal use only.
Thank you for supporting a small shop — just like yours! We'd love a ⭐⭐⭐⭐⭐ review!