Shopify P&L Automation Free (2026) — Live Profit and Loss in Google Sheets | Stack Architect
Updated March 2026 · ~12 min read · Free forever
★★★★★ Live P&L in 10 minutes · Updates on every order · $0 forever

Your Shopify P&L
should write itself.
Now it does. Free.

Every Shopify order automatically writes revenue, fees, and margin data to a live Google Sheets P&L. Make.com webhooks replace manual exports — your profit and loss updates in real time, costs nothing, requires no code.

Manual exports
Every time you want data
$19–$299/mo
P&L apps charge
Days old
Reporting lag
$0
This setup costs
Updates on every order — zero manual input Revenue, COGS, fees, net margin tracked live Refunds handled automatically Your data, your Google account forever
See how it works Build my live P&L free

Powered by Make.com — free up to 1,000 ops/month. Replaces TrueProfit, Lifetimely, and manual spreadsheets.

"I used to spend 3 hours every Monday morning doing manual exports and updating our P&L. This runs itself. Our gross margin is live in Sheets the moment an order lands. Game changer."
Real-time
P&L updates
10 min
Full deployment
$0
Forever cost
3 hrs
Avg time saved/week
What you get

Your P&L statement — live, in Google Sheets, writing itself

Every order appends a row automatically. Formulas calculate gross margin and net profit in real time.

Order Data P&L Summary COGS Table Live
Order IDDateChannelRevenueShopify FeePayment FeeCOGSGross ProfitGross Margin %
#584118 Mar 2026Online Store£127.00-£0.64-£4.03-£38.10£84.23=H2/D2
#584018 Mar 2026Online Store£89.00-£0.45-£2.85-£26.70£59.00=H3/D3
#583917 Mar 2026POS£245.00-£1.23-£0.00-£73.50£170.27=H4/D4
#583817 Mar 2026Online Store-£45.00----£45.00Refund
#583717 Mar 2026Online Store£67.00-£0.34-£2.14-£20.10£44.42=H6/D6
Row #5841 written by Make.com 47 seconds ago — next order will auto-append
The P&L Summary tab

A second tab uses SUMIF formulas to aggregate all rows by month — showing total revenue, total COGS, gross profit, operating expenses you enter manually, and net profit margin. This is your live management P&L, updating automatically as the Order Data tab grows. You own the formula structure and can customise every metric.

The problem

Why your current Shopify P&L process is costing you more than time

Manual CSV exports and static templates have three failure modes that compound as your store grows.

Most Shopify store owners track profit and loss in one of three ways: they pay $19–$299/month for a P&L app, they download monthly CSV exports and paste them into a template, or they wait for quarterly management accounts. All three share the same problem: the data is always behind, and decisions made on behind data are systematically worse than decisions made on live data.

The specific failure mode is inventory and ad spend decisions. A store owner who checks their P&L weekly rather than daily will run ad campaigns for an extra 4–6 days on products that are already margin-negative before the data catches up. At £5,000/month in ad spend, that lag costs measurable money every month.

3 hrs

Average weekly time Shopify operators report spending on manual P&L exports, spreadsheet updates, and financial reconciliation. After deploying Make.com webhook automation, this drops to zero for order-level data entry. The only remaining manual input is ad spend and fixed costs — everything revenue-side is automatic.

What Shopify’s built-in reports don’t tell you

Shopify’s native Analytics shows revenue, units sold, and average order value. It has no concept of your cost of goods, Shopify subscription fee, ad spend, or operating expenses. The gross margin figure that determines whether your store is viable is not available anywhere in Shopify’s dashboard without a third-party app or manual calculation.

Why every competitor either charges monthly or gives you a blank template

Search “shopify P&L template free” and you find two types of results. Paid apps like TrueProfit ($19+/mo), Lifetimely ($39+/mo), and Finaloop ($65+/mo) that automate everything but charge monthly forever. And free templates — static Excel files with no data connection. Nobody has built a genuinely free, live-updating, automated Shopify P&L that connects directly to order data via webhooks. Until now.

Build your live Shopify P&L for free

Make.com free · Google Sheets you own · Updates on every order

Build free →
How it works

Shopify webhook fires. Make.com writes. Google Sheets updates.

Three components. Zero manual steps. Every order handled automatically.

Component 01
Shopify order webhook
The moment an order is paid in Shopify, a webhook fires to Make.com containing the full order payload — revenue, line items, discounts, shipping, tax, payment gateway, and channel. No polling. No delay. Server-to-server.
Shopify → Make.com webhook
Component 02
Make.com data mapping
Make.com extracts the fields you need for P&L — order ID, date, channel, revenue, line item quantities — and calculates Shopify fees based on your plan tier. It writes a structured row to your Google Sheet and handles refunds via a separate scenario.
Make.com scenario — Google Sheets module
Component 03
Google Sheets formula layer
SUMIF formulas in your P&L Summary tab aggregate every order row by month — calculating total revenue, gross profit, COGS, and net margin automatically. You add fixed costs and ad spend in a separate tab. The P&L calculates itself.
Google Sheets SUMIF formulas
What requires manual input

The automation handles everything order-related. You still need to manually enter: monthly ad spend (Meta, Google, TikTok), fixed operating costs (Shopify subscription, app fees, salaries), and COGS per product (entered once in a COGS table, then looked up automatically).

Sheet structure

The exact Google Sheets structure to build

Three tabs. Copy this structure exactly and the formulas work immediately.

Tab 1 — Order Data (auto-populated by Make.com)

Make.com appends one row per order. Do not edit rows here — they are written by the automation. Set up these columns in row 1:

ABCDEFGHIJ
Order_IDDateChannelRevenueDiscountShipping_RevShopify_FeePayment_FeeCOGSGross_Profit
webhookwebhookwebhookwebhookwebhookwebhookformulaformulaVLOOKUP=D-G-H-I

Columns A–F are mapped directly from the Shopify webhook in Make.com. For column G (Shopify fee), use =D2*0.005 for Shopify Basic (0.5% transaction fee). Column I uses VLOOKUP against your COGS table. Column J is revenue minus all costs.

Tab 2 — P&L Summary (formula-driven)

SUMIF formulas aggregate Tab 1 data by month. Structure it with months as columns and metrics as rows:

MetricJan 2026Feb 2026Mar 2026
Gross Revenue=SUMIF(Orders!B:B,"Jan*",Orders!D:D)£24,810£31,240
RefundsSUMIF where D negative-£892-£1,104
Net Revenue=B3+B4£23,918£30,136
COGS=SUMIF(Orders!B:B,"Jan*",Orders!I:I)-£7,175-£9,041
Shopify Fees=SUMIF(Orders!B:B,"Jan*",Orders!G:G)-£119-£151
Gross Profit=SUM(B3:B7)£16,624£20,944
Ad Spend (manual)Enter monthly-£8,200-£9,800
Fixed Costs (manual)Enter monthly-£2,100-£2,100
Net Profit=B8+B9+B10£6,324£9,044
Net Margin %=B11/B326.2%29.0%

Tab 3 — COGS Table (one-time setup)

Enter your cost per SKU or variant in this tab. Make.com pulls the variant ID from each order. A VLOOKUP in Tab 1 matches each variant to its cost automatically. Update COGS here when supplier prices change — every historical order row recalculates.

Setup guide

Build your live Shopify P&L in 10 minutes

No developer, no paid app, no ongoing maintenance. Works on any Shopify plan.

1
Create your P&L Google Sheet
Create a new Google Sheet with three tabs: Order Data, P&L Summary, and COGS Table. In Order Data add column headers in row 1: Order_ID, Date, Channel, Revenue, Discount, Shipping_Rev, Shopify_Fee, Payment_Fee, COGS, Gross_Profit. In COGS Table add two columns: Variant_ID and Cost_Price. Enter your costs per SKU.
sheets.google.com — new sheet — 3 tabs
2
Activate Make.com free
Sign up for Make.com free — 1,000 operations per month at no cost, enough for stores processing up to 500 orders per month (each order uses 2 operations: receive webhook and write to Sheet). Create a new scenario. Add a Webhooks trigger module and copy the generated webhook URL.
make.com/en/register — free tier
3
Add Shopify order payment webhook
In Shopify Admin → Settings → Notifications → Webhooks. Click Create webhook. Select Order payment as the event. Paste your Make.com webhook URL. Format: JSON. Save. Every paid order now fires to Make.com instantly.
Shopify Admin → Settings → Notifications → Webhooks
4
Add Google Sheets module and map fields
Add a Google Sheets module after the webhook trigger. Action: Add a Row. Select your Order Data sheet. Map fields: order.id → Order_ID, order.created_at → Date, order.source_name → Channel, order.total_price → Revenue, order.total_discounts → Discount, order.total_shipping_price_set → Shipping_Rev. For Shopify_Fee multiply total_price by 0.005 for Basic plan.
Make.com → Google Sheets → Add a Row
5
Add refund handling scenario
Create a second Make.com scenario with a Webhooks trigger. In Shopify Admin create a second webhook for Refund created. In Make.com add a Google Sheets module that appends a row with negative revenue — the refund amount as a negative number. This nets automatically in your P&L Summary SUMIF formulas.
Second Make.com scenario — Refund webhook
6
Build SUMIF formula layer in P&L Summary tab
In your P&L Summary tab set up monthly columns. For each metric row use SUMIF to aggregate from Order Data by month. Example for March revenue: =SUMIF(Order_Data!B:B,"2026-03*",Order_Data!D:D). Add rows for COGS, fees, refunds, gross profit, and net margin. Add manual rows for ad spend and fixed costs. Your live P&L is complete.
Google Sheets SUMIF formulas by month
The tools

Three free tools. One live P&L.

Everything you need is free to start. Upgrade paths exist as your store scales.

Automation hub
Make.com
The automation engine that routes Shopify order webhooks to Google Sheets. Free plan covers 1,000 operations per month — enough for most stores processing up to 500 orders per month. Visual scenario builder, no code required.
Start free — 1,000 ops/month →
 For scaling stores
Google Workspace
Free Gmail works for stores up to 500 orders per month. Google Workspace removes all Google Sheets API limits, adds collaborative controls, and lets you pull Google Ads spend data automatically via Apps Script. Recommended for 500+ orders per month or multi-user teams.
Start 14-day free trial →
 Email reporting
Systeme.io
Send automated weekly P&L summary emails to yourself or your team. Systeme.io’s free email automation pairs with Make.com — trigger a weekly email with your P&L highlights every Monday morning. Replaces Klaviyo for internal reporting at $0.
Free plan — no credit card →
When to upgrade Make.com

At 500+ orders per month you use approximately 1,000 Make.com operations on the free plan (2 ops per order). The Core plan at $10.59/month provides 10,000 operations — enough for 5,000 orders per month. At that scale this setup saves $188–$288/month versus TrueProfit or Lifetimely even on a paid Make.com plan.

Complete the stack

P&L is automated. Here is what else runs itself for free.

The same Make.com workflow that writes your P&L can also handle tracking, inventory, email, and stability.

Ad tracking — same webhook
CAPI Shield
The same Shopify order webhook simultaneously sends server-side conversion events to Meta CAPI and Google Enhanced Conversions — recovering 20–40% of lost attribution data at $0.
Saves $149–$299/mo →
Inventory ⚠ Aug 2026
Stocky Swap
The same webhook branches to an inventory ledger — tracking units sold per SKU in real time alongside your P&L. Replace Stocky before August 2026 and get live stock visibility for free.
Saves $29–$199/mo →
TikTok tracking
TikTok Events API
The same webhook branches to TikTok Events API simultaneously. Free CompletePayment events server-side — recovers 20–40% of TikTok conversions lost to iOS at $0.
Saves $39–$299/mo →
Email marketing
Replace Klaviyo
Systeme.io replaces Klaviyo entirely — unlimited emails, automations, and CRM on the free plan. 2,000 contacts, unlimited sends, $0/month forever. Cancel Klaviyo today.
Saves $150–$400/mo →
Stability
Autocrat Quota Fix
Stop Google Apps Script quota errors breaking your document workflows. Handles 10,000+ rows per day at $0 — keeps the entire automation stack running reliably.
Saves $49–$99/mo →
Free tool
App Cost Calculator
Before you can build an accurate P&L you need to know your actual app costs. Most stores find $500–$2,500 in annual waste — all inputs for your fixed costs tab. Takes 30 seconds.
Free — instant results →
Verified results

What operators say after automating their P&L

★★★★★

"I used to spend 3 hours every Monday morning doing manual exports and updating our P&L. This runs itself. Gross margin is live in Sheets the moment an order lands. Completely changed how I make scaling decisions."

Shopify DTC Brand — ~£80k/mo GMV
★★★★★

"Was paying Lifetimely $39/month for a P&L I checked twice a week anyway. This is live, in Sheets where my whole team works, and costs nothing. Took 20 minutes to set up."

Health Supplements Brand — Shopify Plus
★★★★★

"Set this up for 3 client stores in one afternoon. All three now have live margin tracking. The COGS VLOOKUP approach is clever — update one table and every historical order recalculates."

Ecommerce Consultant — 8 Shopify clients
Common questions

Shopify P&L automation FAQ

Every question store owners ask before building their automated P&L.

Can I automate Shopify profit and loss reporting in Google Sheets for free?

Yes. Using Make.com’s free tier, every Shopify order automatically writes revenue, fees, and order data to a Google Sheet. SUMIF formulas in a summary tab calculate live gross margin and net profit without any manual entry. Make.com’s free plan covers 1,000 operations per month — enough for stores processing up to 500 orders per month.

What data does Make.com pull from Shopify for P&L reporting?

The Shopify order webhook payload includes order ID, date, channel, total revenue, subtotal, discounts, shipping revenue, tax collected, payment gateway, line item quantities, variant IDs, and customer details. For P&L purposes you use total revenue, discounts, shipping, Shopify transaction fees, and variant IDs that map to your COGS table via VLOOKUP.

How is this different from Shopify’s built-in financial reports?

Shopify’s built-in reports show revenue, units sold, and average order value. They do not calculate net profit — they have no concept of COGS, Shopify subscription fee, ad spend, or operating expenses. The automated P&L in Google Sheets adds all of these in a single live view you own and customise, with zero monthly fees.

How do I track COGS automatically in the P&L?

Store your cost price per variant in a COGS Table tab. Make.com pulls the variant ID from each Shopify order. A VLOOKUP formula in your Order Data tab matches each variant ID to its cost automatically. Update COGS in the table when supplier prices change and every historical order row recalculates.

How do refunds appear in the automated P&L?

A second Make.com scenario monitors the Shopify Refund created webhook. When a refund occurs, it writes a negative revenue row to the same Order Data tab. SUMIF formulas in your P&L Summary automatically net refunds against gross revenue with no manual adjustment needed.

How do I add ad spend to the automated P&L?

Ad spend is not in Shopify order data — it lives in Meta Ads, Google Ads, and TikTok. Add a manual Expenses tab to your Google Sheet and enter monthly spend figures there. Reference this tab in your P&L Summary to calculate true net profit after advertising. For automated Google Ads spend pulling, Google Workspace with a Google Apps Script can connect to the Google Ads API directly.

Does this work for multi-channel Shopify stores (POS, Amazon, etc.)?

Yes. The Shopify webhook payload includes source_name which identifies the sales channel — online store, Point of Sale, Amazon, TikTok Shop, etc. Add a channel column to your Order Data tab and use SUMIF formulas to break P&L metrics down by channel in your summary.

Is this suitable as a replacement for proper accounting software?

This is management accounting — live profit visibility for operational decisions. It is not a replacement for double-entry accounting, VAT returns, or statutory accounts. Use it alongside Xero or QuickBooks for compliance. The benefit is live margin data for daily decisions without waiting for monthly reports.

Do I need Google Workspace or does free Gmail work?

Free Gmail works for stores processing up to 500 orders per month. At higher volumes, Gmail API limits may throttle Make.com’s Google Sheets write operations during peak periods. Google Workspace removes all limits and adds shared workspaces — recommended for high-volume stores or teams.

What happens to my P&L data if I stop using Make.com?

Historical data stays in your Google Sheet permanently — it belongs to your Google account. Make.com only writes new rows as orders come in. Stop the scenario and existing rows stay intact with all formulas working. You simply stop receiving new order rows until you reconnect.

How long does the full setup take?

The Make.com scenarios and Shopify webhooks take approximately 10 minutes. Building the Google Sheet P&L structure with SUMIF formulas takes another 15–20 minutes. Entering your COGS per product takes 10–30 minutes for most stores. Total time to a live automated P&L: 30–60 minutes.

Ready to build

Your Shopify P&L
should write itself.

Every order writes to your live Google Sheets P&L automatically. Zero manual exports, zero monthly fees, deploys in 10 minutes.

Updates on every order Your data in your Google account $0 forever on Make.com free plan