How to Track Shopify Profit and Loss for Free — Live P&L in Google Sheets, Auto-Updated Every Order
- Every other free P&L guide gives you a static template — you enter numbers manually
- This guide sets up a live, auto-updating P&L — every Shopify order populates a new row automatically
- Powered by a Make.com webhook — same infrastructure as server-side tracking, $0/month
- Covers revenue, COGS, Shopify transaction fees, and net profit per order
- Replaces TrueProfit ($29/mo), BeProfit ($25/mo), and Peel ($199/mo) at zero cost
- Setup takes 8 minutes — no code, no app install, no subscription
Search "shopify profit loss tracking free" and you get two things: paid app trials, or static Google Sheets templates you fill in manually. This guide is neither. It sets up a live Google Sheet that populates a new row automatically every time a Shopify order is paid — capturing revenue, COGS, Shopify fees, and net profit without any manual data entry. The same Make.com webhook that powers your server-side tracking adds a P&L branch for free.
Why Shopify's Built-In Reporting Doesn't Show You Profit
Shopify's native analytics shows you revenue. It does not show you profit. The gap between those two numbers — COGS, Shopify transaction fees, payment processing fees, shipping costs, and ad spend — is the entire difference between a healthy business and one quietly losing money.
To see actual profit in Shopify's dashboard you need to manually enter cost per item for every product variant under Products → Edit → Cost per item. Even then, Shopify only shows gross margin — it doesn't subtract transaction fees, shipping label costs, or any ad spend. For a complete P&L you are either exporting CSVs and calculating manually in a spreadsheet, or paying a third-party app $19–$299/month to pull the same data and display it in a dashboard.
The paid tools are worth the cost if you need multi-channel attribution dashboards, deep ad spend integration per campaign, or SKU-level profitability analytics across thousands of products. For the majority of Shopify stores that want to know their profit per order without paying $300/year — the Make.com webhook does the same job free.
What the Live P&L Sheet Looks Like
Every paid Shopify order automatically adds a new row to your Google Sheet within 60 seconds of payment. The sheet becomes a permanent, real-time financial ledger — every transaction recorded the instant it happens, no manual input ever required.
Once the webhook is running, you never touch the sheet to add data. You only open it to read the numbers. Add a summary tab with =SUM() and =AVERAGE() functions on revenue, COGS, and net profit columns to get monthly totals. Add a pivot table to see profit by product. Connect to Looker Studio for visual dashboards. The underlying data is yours, in a format every tool can read.
Setup Guide — Live Shopify P&L in Google Sheets in 8 Minutes
The P&L Google Sheets module is a single additional branch on your existing scenario. It costs zero extra Make.com operations because it runs in parallel with your existing modules from the same webhook trigger. One order fires the webhook once — all branches execute simultaneously. Add the Sheets module, map the fields, done. Your P&L is live in under 3 minutes.
Full P&L Automation product guide
Complete Google Sheets template, field mapping reference, and monthly summary setup
What to Build Once Your P&L Data Is Live
The Google Sheet is the foundation — the real value comes from what you build on top of it once the data is flowing automatically.
Monthly profit summary
Add a Summary tab. Use =SUMIF(Data!B:B,"Mar 2026",Data!D:D) to pull monthly revenue. Same formula pattern for COGS and net profit. Add month-over-month comparison with simple subtraction. You now have a monthly P&L statement that updates itself every time a new order lands.
Product-level profitability
Add a pivot table grouping by the SKU or product name column. This shows you which products contribute the most profit — not just the most revenue. The distinction matters: a high-volume low-margin product may generate less total profit than a lower-volume higher-margin one. Shopify's built-in analytics doesn't show you this.
Looker Studio dashboard
Connect your Google Sheet to Looker Studio (Google's free BI tool) as a data source. Build a visual dashboard showing daily revenue, daily profit, and margin trend lines. Share it with a partner or accountant as a read-only link — no Shopify access required, no app subscription, complete financial visibility.
Low-margin order alerts
Use Google Sheets conditional formatting to highlight rows where Net Profit margin falls below a threshold — say 20%. Orders using large discount codes, orders with unusual shipping costs, or pricing mistakes become immediately visible in the sheet rather than buried in a dashboard you check monthly.
Free Google Sheets P&L vs Paid Shopify Profit Apps
| Solution | Monthly cost | Auto-updates | Data ownership | Custom formulas | Looker Studio |
|---|---|---|---|---|---|
| Make.com + Google Sheets | $0 | Yes — per order | Your Google account | Full control | Yes — free |
| TrueProfit | $29/mo | Yes | Their servers | No | No |
| BeProfit | $25/mo | Yes | Their servers | No | No |
| Peel | $199/mo | Yes | Their servers | Limited | No |
| Static Google Sheet template | $0 | Manual entry | Your account | Yes | Yes |
| Annual saving vs TrueProfit | $348/year saved | — | — | — | — |
The main advantage paid tools have is ad spend integration — TrueProfit and BeProfit can pull your Facebook, Google, and TikTok ad spend automatically and subtract it per order based on attribution. The free Google Sheets setup does not do this natively. You can add a manual ad spend row to your summary tab and subtract total monthly ad spend from total monthly profit — less granular but sufficient for most stores.
Shopify P&L Tracking in 2026 — Why Most Merchants Get This Wrong
The fundamental error most Shopify merchants make is treating revenue as a proxy for business health. Revenue goes up, everything feels fine. But revenue rising while margins compress — due to rising ad costs, increasing product costs, or discount-heavy promotions — creates stores that look healthy on the surface and are quietly losing money at the order level.
Automated P&L tracking changes the relationship you have with your numbers. When every order automatically lands in a spreadsheet with its profit margin calculated, you see problems in real time rather than discovering them at the end of the month. A promotion that drives volume but erodes margin is visible within hours. A supplier price increase that hasn't been reflected in retail pricing shows up immediately as margin compression across affected SKUs.
The complete guide to the P&L Automation setup — including the full Google Sheets template with pre-built formulas, the Make.com field mapping reference for all Shopify order fields, and instructions for the Looker Studio dashboard connection — is available at the P&L Automation product page. It slots into the same Make.com scenario as CAPI Shield and Stocky Swap — one webhook, three simultaneous outputs, $0/month total.
Frequently Asked Questions
Does Shopify show profit and loss natively?
Shopify shows revenue and gross margin if you've entered cost per item for your products — but not net profit. Transaction fees, payment processing fees, shipping label costs, and ad spend are not deducted in Shopify's native analytics. To see actual net profit per order you need either a third-party P&L app ($25–$299/month) or the free Make.com + Google Sheets automation described in this guide.
How is this different from downloading a free Google Sheets P&L template?
A static template requires you to manually enter every order's data — revenue, items, costs — which takes significant time and introduces human error. This setup uses a Make.com webhook to automatically populate a new row every time a Shopify order is paid. You never manually enter data. The sheet updates itself in real time, permanently, with no ongoing maintenance required.
How do I track COGS automatically in Google Sheets from Shopify?
Two approaches work. First, if you've entered cost per item in Shopify (Products → variant → Cost per item), Make.com can pass line item cost data from the Shopify order payload. Second, maintain a COGS reference tab in your Google Sheet with SKU and unit cost columns, then use a VLOOKUP formula in your COGS column to pull the cost for each SKU automatically. Most stores with under 100 SKUs find the VLOOKUP approach simpler.
Can I add this P&L tracking to my existing CAPI Shield or Stocky Swap scenario?
Yes — and this is the recommended approach. If you already have a Make.com scenario running with a Shopify Order Payment webhook, simply add a Google Sheets — Add a Row module as an additional branch. It runs in parallel with your existing modules at no extra Make.com operations cost. One order triggers the webhook once, all branches execute simultaneously. The P&L branch takes under 3 minutes to add to an existing scenario.
Does this replace TrueProfit or BeProfit completely?
For order-level P&L tracking, revenue, COGS, fees, and net profit — yes, completely and for free. Where TrueProfit and BeProfit have an advantage is automatic ad spend integration per order — they pull your Meta, Google, and TikTok ad costs and attribute them per sale based on their attribution models. The free Google Sheets setup requires you to manually subtract total monthly ad spend from total monthly profit in a summary tab. For most stores this is sufficient. For stores that need per-order ad attribution, paid tools justify their cost.
How many orders can Make.com handle for free?
Make.com's free plan covers 1,000 operations per month. The P&L branch uses approximately 1 operation per order. Combined with CAPI Shield (2–3 operations per order for Meta and Google branches) and Stocky Swap (1 operation), a fully deployed stack uses roughly 4–5 operations per order — covering stores processing up to 200–250 orders per month on the free tier. For higher volumes, Make.com's Core plan at $9/month handles 10,000 operations.
Every order. Live in Google Sheets.
$0/month. No manual entry. Ever.
The full product guide includes the Google Sheets template, field mapping reference, and Looker Studio dashboard connection. Adds to your existing Make.com scenario in 3 minutes.
Free forever · No code · Adds to existing scenario in 3 minutes · Replaces $29–$199/mo P&L apps