Shopify Profit Tracker Spreadsheet, Excel and Google Sheets, Ecommerce Profit and Loss, ROAS Calculator, Dropshipping Inventory Tracker

Shopify Profit Tracker Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. See your store's real profit every month: product margins, ad spend and ROAS, break-even ROAS, inventory, refunds, apps and cash flow in one file. Perfect for Shopify store owners and other online stores.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/I18ulIQIErs

✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers).

★ WHAT'S INCLUDED ★
• 15 tabs with a clickable Start Here page
• Dashboard with a month picker: 16 KPI tiles (net sales, orders, AOV, conversion rate, ad spend, MER, net profit and net margin for the month, each vs last month, plus revenue, net profit, gross margin, CAC, break-even ROAS, refund rate, stock value and cash on hand for the year), a month by month table, top products by profit, reorder alerts and 5 charts
• Daily Sales (366 days, dates fill in): sessions, orders, new customers, units, gross sales, discounts and shipping charged, with net sales, payment fees, AOV, conversion, units per order and a by-weekday summary with a chart
• Products (80 rows): price, product cost, freight, shipping, packaging and other costs, with payment fees, landed cost, profit per unit, margin, markup, break-even ROAS, max cost per sale and this year's units, sales and profit
• Product Sales: units per product per month, with sales, landed costs, profit before ads, margin and share
• Ad Spend (600 rows): spend by channel and campaign with platform sales, purchases, clicks and impressions, plus ROAS, cost per purchase, CTR, CPC, CPM and a check against your break-even ROAS
• Marketing ROI: every channel's spend, ROAS, CPA, CTR and CPC, plus MER, CAC and ad cost per order month by month, with 4 charts
• ROAS Calculator: pick a product or use your store average to get your break-even ROAS, max cost per order and target ROAS for your profit margin, profit per order at 10 ROAS levels, a price and product cost what-if grid and your store-wide break-even MER
• Inventory (80 rows): stock on hand from opening stock, received, sold and returned, with days of stock left, reorder point, a status (reorder now, out of stock, overstock), suggested order quantity, run-out date and stock value
• Purchase Orders (150 rows): restocks with landed cost per unit, arrival flags and days late
• Returns (400 rows): refunds, reasons, resolution, restocked or not, return shipping and written-off stock, with a by-reason summary and chart
• Fixed Costs & Apps (40 rows): store plan, apps, tools and contractors billed monthly, yearly or one-time, spread across the 12 months
• Profit & Loss: orders, net sales, shipping, refunds, product costs, shipping and packaging, payment fees, return costs, gross profit, ad spend, apps, net profit, margin, goal progress and MER by month, with 2 charts
• Cash Flow: money in vs stock purchases, ads, shipping, apps and owner pay, with closing cash by month and 2 charts
• Setup: payment fees, target margin, sales goal, lead time, safety stock and all drop-down lists
• Sample data from a pet products store so you can see how it works

★ PERFECT FOR ★
✓ Shopify store owners and other online stores
✓ Dropshipping, print on demand and DTC brands
✓ Store owners running Meta, Google, TikTok or Pinterest ads
✓ Anyone who wants to know their real profit, not just sales

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, add your payment fees, goals and lead times, then add your products and their costs.
3. Type your daily sales and ad spend from your store and ad dashboards, plus restocks, returns and apps.
4. The dashboard, P&L, cash flow, marketing ROI and inventory alerts update themselves.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• You type in your numbers: the file doesn't connect to your store or ad accounts. Not affiliated with Shopify or any ad platform.
• This is a tracking and math tool, not tax or financial advice.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.