Shop Sales & Profit Dashboard | Google Sheets Template

Know exactly what your shop really earns after fees, product costs, shipping and expenses. Log each order in a few seconds and this Google Sheet works out the fees, profit and margin for you, then turns it all into a colourful dashboard with your best sellers.

WHAT'S INSIDE (7 tabs)

- START HERE: quick setup steps and tips

- Dashboard: pick a month or the full year to see revenue, net profit, profit margin, orders, average order value, items sold, top product and expenses, a sales goal bar, 5 charts (revenue vs profit by month, sales by channel, sales by category, top 10 products, expenses by type) and a best sellers table

- Orders: date, order number, channel, product, quantity, price, shipping charged, discount, shipping cost and status, with automatic category, revenue, fees, product cost and profit

- Products: your products with cost per item and usual price, plus automatic units sold, revenue, profit, margin and best seller rank

- Expenses: supplies, packaging, ads, software, market stall fees and more

- Monthly Summary: 12 months of orders, items sold, revenue, fees, product costs, shipping costs, expenses, net profit, margin, average order and sales goal progress, with a chart

- Setup: currency, shop name, year, monthly sales goal, your sales channels with their fee % and fixed fee, product categories and expense types

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.

3. Add your channels, fees and products on Setup and Products, then log each order. Everything else updates automatically.

GOOD TO KNOW

- Two versions included: one with sample data to explore and a blank one ready for your own shop

- Works for handmade, digital download and resale shops, selling online, on your own website or at markets

- Choose from 25 currency symbols or type your own

- Refunded and cancelled orders are handled for you

- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers

- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident

- A simple tracker for your own records, not tax or accounting advice

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, reply to your download email and I will be happy to help