Etsy Shop Bookkeeping Spreadsheet, Profit Tracker, Expense Calculator (Excel)

Description
✨ ELDON-Digital - Etsy Shop Bookkeeping & Profit Tracker ✨
Are you an Etsy seller tired of guessing where your money goes? Finally take full control of your shop finances with this gorgeous, all-in-one bookkeeping spreadsheet - designed exclusively for Etsy sellers like you.
📊 What You're Getting
This is not just another boring spreadsheet. This is a complete financial command center with a stunning color-coded interface, interactive dashboard, 3D charts, and one-click navigation buttons that make managing your shop feel effortless.
🖥️ 10 Beautifully Designed Sheets Include:
📖 Instructions Sheet - A detailed, beginner-friendly walkthrough so you'll never feel lost. Every feature is explained step by step, even if you've never touched a spreadsheet before.
⚙️ Settings Sheet - Personalize everything to YOUR shop. Enter your shop name, tax year, Etsy fee rates, tax rates, expense categories, and currency. Every other sheet updates automatically based on your settings - set it once and forget it.
📊 Dashboard - Your business at a glance. Six key performance indicators (Total Revenue, Expenses, Net Profit, Profit Margin, Total Orders, Average Order Value), one-click navigation buttons to every sheet, and beautiful monthly trend charts showing Revenue vs. Expenses and Net Profit over 12 months.
💰 Sales Log - Record every single Etsy order with auto-calculated fees. Just enter your order date, product, quantity, and price - the spreadsheet automatically computes your Listing Fee, Transaction Fee, Payment Processing Fee, Regulatory Operating Fee, Total Fees, Net Revenue, COGS, Profit, and Profit Margin for every order. Includes a 3D bar chart of your sales performance.
💳 Expense Tracker - Log all business expenses with categories, payment methods, receipt tracking, and tax-deductible flags. A beautiful pie chart breaks down your spending by category (Supplies, Packaging, Advertising, Software, Equipment, and more). Categories are fully customizable from the Settings sheet.
📦 Inventory Management - Track every product's stock level, unit cost, selling price, reorder point, and profit margin. Smart reorder alerts (⚠️ REORDER / ✅ OK) tell you exactly when to restock. Includes a 3D inventory value chart so you always know what your stock is worth.
📈 Monthly Profit & Loss Statement - A fully automated 12-month income statement showing Revenue, Cost of Goods Sold, Gross Profit, Operating Expenses, and Net Income with annual totals. Professional grouped bar charts compare all three metrics month by month so you can spot trends instantly.
🏛️ Tax Summary - Stop dreading tax season. This sheet gives you a complete annual income summary, estimated Federal, State, and Self-Employment tax calculations, quarterly payment tracking, and a remaining liability calculator - all aligned with Schedule C categories for easy filing. Includes a tax breakdown pie chart.
🧮 Fee Calculator - Thinking about listing a new product? Enter any price and instantly see every Etsy fee broken down - Listing Fee, Transaction Fee, Payment Processing, Regulatory Fee, and even Offsite Ads. See your exact Net Profit and Margin before you ever hit publish. A pie chart visualizes the fee split so you know exactly where your money goes.
📊 Product Analytics - Discover your top performers. Track units sold, total revenue, total COGS, gross profit, profit margin, average selling price, return rate, and customer rating for every product. 3D revenue charts and units-sold pie charts help you make smarter inventory and marketing decisions.
🎨 Why Sellers Love This Tracker:
→ Stunning visual design with unique color themes on every sheet → One-click navigation buttons on every page - never get lost → 700+ formulas that do all the math for you - zero manual calculations → Pre-filled with sample data so you can see exactly how it works → Works in both Microsoft Excel AND Google Sheets → Fully customizable - change your fees, tax rates, and categories anytime → Professional 3D charts and infographics on every sheet → Beginner friendly with a complete Instructions guide → Print-ready formatting with clean, grid-free design → Instant digital download - start organizing your finances today
🛒 Perfect For:
→ New and established Etsy shop owners → Handmade, vintage, and digital product sellers → Side hustlers tracking their creative business income → Anyone who needs a simple, beautiful way to manage shop finances → Sellers preparing for tax season without an accountant
📁 What You'll Receive:
One .XLSX file - instant digital download. Compatible with Microsoft Excel (desktop & online) and Google Sheets. Simply download, open the Settings sheet, enter your information, and you're ready to go.
⚠️ Please Note: This is a digital product. No physical item will be shipped. Due to the nature of digital products, all sales are final.
💛 Thank you for choosing ELDON-Digital - we're here to help your creative business thrive. If you have any questions at all, please don't hesitate to reach out. We'd love to hear from you!
⭐ If you love this tracker, a 5-star review means the world to us and helps other sellers find the tools they need.