Report this item to Etsy

Seller Profit Tracker Spreadsheet for Excel, Fees, Shipping, Profit per Product

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Seller's description

See your real profit per order and per product, after fees and postage.

Log each order once: product, quantity, revenue, shipping charged and postage. Leave the fee blank and the sheet estimates it from your fee % and fixed fee, or type the exact fee from your payout statement.

WHAT IT DOES
- Setup once: currency symbol, fiscal-year start (any month), tax set-aside %, opening cash, payment terms, your own categories
- Monthly P&L: income, cost of sales, gross profit and margin, operating expenses, net profit, tax set-aside
- KPI dashboard (year to date): revenue, gross margin, net profit and margin, cash and cash runway, this month vs last month, unpaid and overdue invoices, charts, expense mix
- Invoice log: due date from your payment terms; status turns Paid, Due soon or Overdue by itself
- Rows dated outside your fiscal year are flagged and left out, so totals stay right
- Seller extras: Orders ledger (1,000 rows) with fees used, product cost and net profit per order; Products tab with units, revenue, fees, postage, cost, profit and margin per product; top 5 products by profit; orders and average order value

WHAT'S INSIDE
- Small-Business-Dashboard-Online-Seller.xlsx: filled example (a fictional ceramics shop, 6 products, about 250 orders)
- Blank copy
- 3-page PDF guide
Tabs: Instructions, Setup, Orders, Products, Expenses, Invoices (wholesale), P&L, Dashboard

WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice.
No macros, no add-ins. Formula cells are protected without a password, so you can't break them by accident, and you can still unlock them. Best edited on a computer; phone apps can view.

GOOD TO KNOW
- Instant digital download: a .zip with the filled example, a blank copy and a PDF guide. Nothing is shipped.
- Licence: for your own use and use inside your own business. Please do not resell or share the files.
- A problem opening the file? Message us and we'll help.
- Bookkeeping aid only, not financial, accounting or tax advice. The tax set-aside is a savings % you choose; ask a qualified accountant or your tax office what you owe. No VAT/sales-tax returns.

HOW THIS WAS MADE
We designed these workbooks and wrote the formulas, guide text and the scripts that build the files with the help of AI tools. Scripts recalculated each file in LibreOffice and compared it with a separate Python calculation across 10 test cases, including edge cases. The listing photos are real screenshots of the files (no AI-generated images).

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

NowPrice:$2.39

Original Price: $3.19

Loading

25% off

•

Sale ends on November 16

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: An Excel-based online shop profit dashboard for Etsy sellers by tobu/ab. The interface displays key figures, year-to-date revenue, net profit, and monthly revenue versus costs in a table and bar chart format.

See your real profit per order and per product, after fees and postage.

Log each order once: product, quantity, revenue, shipping charged and postage. Leave the fee blank and the sheet estimates it from your fee % and fixed fee, or type the exact fee from your payout statement.

WHAT IT DOES
- Setup once: currency symbol, fiscal-year start (any month), tax set-aside %, opening cash, payment terms, your own categories
- Monthly P&L: income, cost of sales, gross profit and margin, operating expenses, net profit, tax set-aside
- KPI dashboard (year to date): revenue, gross margin, net profit and margin, cash and cash runway, this month vs last month, unpaid and overdue invoices, charts, expense mix
- Invoice log: due date from your payment terms; status turns Paid, Due soon or Overdue by itself
- Rows dated outside your fiscal year are flagged and left out, so totals stay right
- Seller extras: Orders ledger (1,000 rows) with fees used, product cost and net profit per order; Products tab with units, revenue, fees, postage, cost, profit and margin per product; top 5 products by profit; orders and average order value

WHAT'S INSIDE
- Small-Business-Dashboard-Online-Seller.xlsx: filled example (a fictional ceramics shop, 6 products, about 250 orders)
- Blank copy
- 3-page PDF guide
Tabs: Instructions, Setup, Orders, Products, Expenses, Invoices (wholesale), P&L, Dashboard

WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice.
No macros, no add-ins. Formula cells are protected without a password, so you can't break them by accident, and you can still unlock them. Best edited on a computer; phone apps can view.

GOOD TO KNOW
- Instant digital download: a .zip with the filled example, a blank copy and a PDF guide. Nothing is shipped.
- Licence: for your own use and use inside your own business. Please do not resell or share the files.
- A problem opening the file? Message us and we'll help.
- Bookkeeping aid only, not financial, accounting or tax advice. The tax set-aside is a savings % you choose; ask a qualified accountant or your tax office what you owe. No VAT/sales-tax returns.

HOW THIS WAS MADE
We designed these workbooks and wrote the formulas, guide text and the scripts that build the files with the help of AI tools. Scripts recalculated each file in LibreOffice and compared it with a separate Python calculation across 10 test cases, including edge cases. The listing photos are real screenshots of the files (no AI-generated images).

  • Designed by
  • Item type
    Digital download
  • Digital file type(s)
    1 ZIP
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 25, 2026