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. ✨ 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: p