Handmade Business Bookkeeping Planner - Etsy Seller Excel Tracker

Running a maker or Etsy shop means juggling income and expenses, materials on the shelf, what each item actually costs to make, and sales scattered across different platforms. This single Excel file brings all of it into one spreadsheet, with the math done for you.

What's included (1 file, 7 tabs):- Income & Expenses — log every transaction with category and income/expense dropdowns; total income, total expenses and net profit are added up automatically.- Inventory — one row per product or material, with quantity on hand, reorder point and stock value; Low Stock and Out of Stock are flagged in color on their own.- Product Costs — break down materials, labor hours and packaging for each item; total cost per unit is calculated for you.- Sales Log — record every sale with the platform it came from (Etsy, Shopify, craft fairs, Instagram/DMs or other); platform fees and shipping are factored in automatically for a real net revenue per sale.- Profit Margin per Item — pulls your cost and sales data together for each product automatically and shows units sold, profit and profit margin %, color-coded so thin-margin items stand out.- Dashboard — income, expenses, inventory value, units sold and overall profit margin, pulled together automatically from the other tabs. Nothing to fill in here.

Works in Microsoft Excel, Google Sheets and LibreOffice Calc. Only the highlighted input cells are meant to be filled in — every other cell (including all formulas) is protected so nothing breaks by accident.

Important note: this is an organizational template, not accounting, tax or legal advice. Please check your own bookkeeping, sales tax and business license obligations with a local accountant or tax authority; requirements differ by country, state and marketplace.

Made with the help of AI tools; all designs are original, not copied from another creator.

Because this is a digital file, returns and exchanges are not accepted. If anything is wrong with your file, contact us through this store and we'll fix it quickly.