Free Shopify daily P&L template: the 12-column worksheet that gives you a real EBIT per day.

There is a specific kind of frustration that hits a Shopify operator around month four. Sales look fine on the dashboard. The bank balance does not match the energy. The accountant report for last month arrives in mid-month and confirms what the gut already knew — the month did not actually make money, or barely did. The owner says, out loud, for the third time that quarter: "I should really start a daily P&L spreadsheet." And then does not, because every template online is either built for an accountant, built for a US-only business, or built for a SaaS company and not a store that ships physical goods. This post is the small-shop version. Twelve columns, one row per day, real EBIT in the right-most cell, designed to be copied into any spreadsheet tonight and filled in two minutes tomorrow evening. It is the same shape nouz automates daily — but the math is the math, and a spreadsheet runs it free.

TL;DR

Why Shopify owners need a P&L template outside of Shopify

Shopify ships a reporting suite that is genuinely strong on the revenue side and silent on the cost side. The Home dashboard answers traffic and gross-sales questions well, the Analytics > Reports section adds segmentation, and on Shopify, Advanced and Plus plans the newer Profit Report multiplies units sold by Cost per item to give a gross-margin view. None of that closes the gap to real EBIT — and a Shopify operator who runs the store off the dashboard alone is missing the four largest cost lines in the business. Specifically:

1. Shopify Analytics does not subtract payment fees from your revenue line

When Shopify Payments processes a €100 order on a typical EU consumer card, the payout that lands in your bank is around €97.10 — €100 minus a fee that depends on plan, region, and card type but generally runs in the 1.5–2.9% range plus a small fixed component per transaction. That fee is real money leaving the business on every sale. It is visible inside Settings → Payments → Payouts (broken out per payout batch), but it does not subtract from Total Sales on the Home dashboard and does not appear in the standard sales reports. A €4,800 sales day at a 2.1% effective rate has paid roughly €100 in fees that never showed up where the owner actually looks.

2. COGS at the daily level is buried or missing entirely

Shopify has a Cost per item field on every product variant. If you have populated it for every SKU and every variant — and most stores have not, especially older SKUs and bundle products — the Profit Report can compute a gross-margin number for the period you select. The number you actually want at end of day (today I sold goods that cost me €X to acquire) is not on the Home dashboard. You have to navigate into the report, set a date range, and read it manually, which most owners do once a quarter and not once a day. And if your Cost per item field is patchy, the report silently treats missing-cost SKUs as 100% margin and overstates profit.

3. Ad spend lives in Meta, Google and TikTok — never in Shopify

Your daily ad spend is the second-largest variable cost in most DTC businesses (after COGS itself), and entirely invisible to Shopify Analytics. Meta Ads Manager shows Meta spend; Google Ads shows Google spend; TikTok Ads Manager shows TikTok spend. None of them reconcile cleanly to the orders Shopify itself records — each platform has its own attribution view of which orders it claims credit for, and the sum of platform-reported orders is almost always higher than your real order count. The €4,800 sales day on the Shopify dashboard might have been pulled forward by €1,400 of ad spend that morning, and the dashboard will show you the €4,800 without flinching.

4. Fixed overhead is not anywhere in Shopify

Your Shopify plan itself, your apps stack (most real stores run 6–12 paid apps for reviews, email, loyalty, upsells, SEO and three others nobody remembers installing), your 3PL or warehouse fee, your accountant, your salary if you take one — none of this lives inside Shopify. It is fixed cost that has to be allocated to each day before you can know whether the day was profitable. Shopify does not allocate it, because Shopify does not know about it. Full breakdown of what Shopify shows vs what it hides.

What this template gives you

Six concrete deliverables. Not a finance department, not an accounting upgrade — just a one-screen worksheet that answers the question Shopify will not.

1. A real daily EBIT number. Not gross sales, not net sales, not gross margin — the operating profit number that ties to what your bank account actually keeps after every cost runs.
2. A running month-to-date total. Cumulative EBIT through today, recomputed every evening, so you stop being surprised by what the accountant says in mid-month.
3. A visible cost stack. Twelve columns mean you can see which line moved when EBIT moves — was it Ad spend up, COGS up, Refunds up, or Packaging up? The diagnostic is on the row.
4. Daily discipline. Two minutes per evening, every evening. The mechanism by which margin discipline actually happens — knowing the number is what changes the decisions.
5. A starting point for benchmarks. After 30 days you have your own baseline for EBIT %, Ad % of revenue, COGS %, and Refund rate. From there, any drift is visible the day it starts.
6. Zero software cost. Works in Google Sheets, Excel, Apple Numbers, Notion tables, anywhere. The template is shape, not software.

The template — one row per day

Twelve columns. The first three describe revenue, the next seven describe costs, the last two describe outcome. Copy this header into the first row of a fresh spreadsheet and you have the worksheet.

Two columns earn most of their keep on diagnostic days. Column 9 (Ad spend) is the column you look at on a day Net EBIT collapsed and revenue did not — because nine times out of ten that day was a CAC inflation event, not a sales event. Column 3 (Refunds) is the column you look at when net sales drop without a corresponding gross drop — refund lag from a week-old promotion or a quality issue on a recent batch usually lives here. Per-order math behind these columns.

How to fill it in — 2 minutes per day

Six steps, in this order, every evening. The discipline is the routine — same screens, same order, same time of day. Most operators settle into a 9pm close-out that takes longer the first three nights and roughly two minutes from night four onward.

1. 01
   Open Shopify → Home dashboard.

   Today's Total Sales is column 2 (Gross sales). It includes tax and shipping recovered. Write the number.

2. 02
   Switch the date filter to today only, scroll to the Finances summary.

   Read off Returns (or Refunds, depending on the report version). That is column 3. If zero today, write 0.

3. 03
   Open Settings → Payments → Payouts.

   Read off the fee on today's payout batch if it has landed, OR multiply Net sales (column 4) × your effective fee rate (computed once from a clean month — usually 1.6–2.9% for Shopify Payments). That is column 5.

4. 04
   Compute today's COGS.

   Either pull units sold × cost per item from the Profit Report for today's date range, OR apply your blended COGS % (e.g. 38%) to Net sales. That is column 6. Rule-of-thumb is fine — exactness is week-end work, not nightly work.

5. 05
   Estimate today's packaging + fulfillment.

   Orders shipped today × your per-order packaging cost = column 7. Orders shipped today × your per-order 3PL rate (or hours × hourly rate if in-house) = column 8. These rates are stable — derive once, reuse nightly.

6. 06
   Open each ad platform and write today's spend.

   Meta Ads Manager today's spend + Google Ads today's spend + TikTok Ads today's spend = column 9. Add any other-variable line if it occurred today (sample shipment, chargeback fee) to column 10.

The spreadsheet computes columns 4, 11 and 12 automatically once the formulas are in place. Total time from opening the sheet to seeing today's EBIT: roughly two minutes once the routine is learned. Less than the time it takes to make a cup of tea.

Where to find each number in Shopify

The exact admin path for every column that pulls from Shopify itself. The non-Shopify columns (Ad spend, Packaging, Fulfillment labor) pull from the platforms and suppliers named, not from Shopify.

The "Cadence available" column matters because some numbers lag. The exact Shopify Payments fee on today's orders technically lands when the payout settles 2–4 business days later — but the derived effective rate × today's net sales is accurate to within €1–€2 on a typical day, which is good enough for nightly tracking. The exact 3PL invoice lands monthly, but the per-order rate (e.g. €3.50/order) is stable and reliable for daily allocation. Wait for exact and the spreadsheet ages four weeks; use derived and you have a tight EBIT number tonight.

Worked example — DTC apparel, 7 days

A small DTC apparel store, EU-based, average order value around €58, running paid traffic on Meta and Google with a small TikTok test. Single SKU category (women's apparel). 3PL fulfillment at €3.20/order. Packaging cost €2.30/order (branded mailer, tissue, sticker, thank-you card). Effective Shopify Payments fee rate: 1.85%. Blended COGS: 34%. Monthly fixed overhead: €1,640 (Shopify Advanced plan + 9 apps + 3PL base fee + accountant + email tool). Daily fixed slice: €1,640 ÷ 30.4375 = €53.88/day. Seven days of the worksheet, fully filled in:

7-day totals: Gross €23,145; Refunds €1,000; Net sales €22,145; Shopify fees €410; COGS €7,529; Packaging €954; Fulfillment €1,323; Ad spend €5,711; Other variable €60; Daily fixed total (7 × €53.88) €377. Net EBIT for the week: €5,782. EBIT % of net sales: 26.1%. That is an unusually strong week for DTC apparel (the seasonality of the example helped — weekend volume was high and CAC stayed disciplined). A more typical week for a comparable store would land 12–18% EBIT margin.

What the numbers tell you

After 14–30 days of filling the worksheet, four patterns emerge that no Shopify dashboard will surface. Each pattern is a decision lever the operator can pull.

Pattern 1: Ad spend % of revenue drifts before EBIT collapses

Compute Ad spend ÷ Net sales daily. In a healthy DTC store this number sits in a band — say 22–28% — for weeks at a time. When it starts climbing (28 → 31 → 34 over a fortnight) without a matching revenue lift, the campaigns are saturating and CAC is rising. The Shopify Total Sales line will not flag this; the ROAS view in Meta will look "okay" because the platform-reported ROAS only tracks ad-attributed revenue, not total store revenue. The Ad-spend-% column on the worksheet flags it three weeks before the monthly P&L would. Why CLV matters once CAC starts drifting.

Pattern 2: Weekday EBIT vs weekend EBIT separates real signal from volume

Most DTC stores have a weekend-heavy revenue pattern. The honest question is not "did we sell more this weekend" — it is "did we keep more per euro this weekend." Often the answer is no, because weekend volume comes with higher CAC (more prospecting), heavier packaging spend (peak orders to pack), and worse refund rates (impulse purchases return more often). Tracking EBIT % by day of week tells you whether your weekend is genuinely more profitable or just busier. Operators frequently discover their best-margin day is Tuesday or Wednesday — and that knowing this changes how they plan promotion timing.

Pattern 3: Refund-lag windows are visible 7–14 days after the trigger event

A promotion on day 1 typically pulls refunds 7–14 days later (apparel sizing returns, "I changed my mind" reflection). Tracking refunds in their own column means you can correlate today's refund spike to that promotion two weeks ago, which is the only way to learn whether the promotion was actually net-positive once returns are factored. The Total Sales view of the promotion week looks great; the EBIT view two weeks later tells the truth.

Pattern 4: Cumulative MTD EBIT is your runway signal in real time

On the 15th of the month, you can read MTD EBIT off the worksheet and project: is the month on track, ahead, or behind plan? On a 30-day month at €5,000 EBIT target, you need to be at €2,500 MTD by day 15. If you are at €1,200 you have 15 days to find €3,800, which is a different decision than discovering on day 35 that you missed by €1,800. Cumulative MTD turns end-of-month surprise into mid-month decision-making.

5 common mistakes

Operators who start a daily P&L worksheet and abandon it within a month usually trip on one of these. None are fatal if caught early.

1. Treating Shopify "Total sales" as revenue when it includes tax

Total Sales on the Shopify Home dashboard includes the tax / VAT collected from the customer at checkout. That money is not yours — it belongs to the tax authority and will be remitted later. If you book it as Gross sales in your worksheet without separating tax, every cost-percentage you compute (COGS %, Ad spend %, EBIT %) is understated against a number that includes money you do not keep. The fix: either log Gross sales excluding tax (most reports let you toggle this view), or add a tax column right after Gross and subtract it before computing Net sales. The shape of the template above assumes Gross is the customer-paid number and tax is invisible; if your store is in a tax-inclusive market (EU) treat it carefully.

2. Not snapshotting COGS at the moment of sale

If supplier prices change in October, the orders you shipped in August did not retroactively get more expensive. The COGS for an August order is the supplier cost at the moment that unit was sold, not the current cost. Operators who recompute historical rows when supplier prices move end up rewriting their own history and losing the ability to compare months. The fix: lock the COGS rate by month and never re-edit prior months. More on why snapshot COGS matters.

3. Forgetting to allocate the monthly fixed slice every day

It is tempting to only track variable costs daily and add fixed overhead at month-end. The problem: every day looks profitable in isolation ("we made €280 today!"), but the month-end reconciliation reveals that the daily fixed slice (€54 in our example) was a real cost on every one of those days, and the apparent €280 was actually €226 of EBIT. The fix is in the formula: subtract Monthly fixed ÷ 30.4375 in the Net EBIT calculation every single day. The same-day truth is what makes the worksheet worth doing.

4. Excluding owner labor from fulfillment cost

The most common reason a solo Shopify store looks profitable on paper but feels broke in real life: the owner packs every order themselves, runs customer service themselves, and never books those hours as a cost. If you would have to hire someone at €18–€25/hr to do those tasks, that is the real labor cost of the orders going out the door. Booking honest owner-labor often discovers true EBIT is 30–60% lower than the unlabored version — which is the number that actually matters for sustainability. A profitable store that runs on €0 owner labor is not a profitable store; it is a job that does not pay you.

5. Skipping nights and trying to catch up

Three nights in a row of skipped close-out means the fourth night requires looking up four days of ad spend, four days of refunds, four days of packaging counts — at which point most operators give up and the worksheet dies. The fix is operational, not analytical: pick a fixed time (8–9pm works for most), do the close-out before the laptop closes, and accept the two-minute discipline as non-optional. nouz exists partly because manual worksheets die in week three for exactly this reason. The math is identical; the workflow built into a tool you open every evening survives nights the spreadsheet does not.

When you outgrow this template

The 12-column worksheet works indefinitely for a single-location DTC store doing under roughly €40k/month — past that point, three operational frictions accumulate that the spreadsheet starts to handle badly.

Friction 1: the daily fixed slice changes more often than once a year. You add an app, you change 3PL pricing, your accountant raises rates, you take a salary. Each time, you have to re-derive the monthly fixed total and re-apply ÷ 30.4375 across past and future rows. A tool that stores fixed costs once and recomputes the daily slice automatically saves the friction.

Friction 2: per-SKU COGS variation matters once your catalogue diversifies. A blended COGS % is fine when 80% of revenue is from 5–10 SKUs at similar margins. When you launch a higher-COGS product line and the catalogue mix shifts week to week, the blended rule-of-thumb stops being accurate and per-SKU COGS at sale time becomes necessary. A worksheet that stores cost-per-item per variant and applies it at sale time gets unwieldy in plain spreadsheets fast.

Friction 3: you want benchmark comparisons against same-day-last-week, MTD vs same-period-last-month, EBIT % trend across 90 days. The worksheet has the raw data but reading it as a trend across hundreds of rows in a spreadsheet becomes its own job. A daily P&L tool turns the same data into the comparison views automatically.

This is where nouz fits — same math, same EBIT formula, same one-row-per-day shape, but with the fixed-cost stack stored once, the daily slice computed automatically, the COGS snapshot held at sale time, and the comparison views built in. The worksheet teaches the discipline; the tool removes the parts of the discipline that have become administrative. DTC operator page walks through what the daily close-out looks like for a Shopify store inside the product.

For more context on the math behind the columns: per-order cost stack walked through line by line, what Shopify Analytics shows vs what it hides, the AOV your store needs to clear daily fixed costs, and CLV math for DTC operators. The true profit calculator runs the full single-order math in your browser; the AOV break-even calculator tells you the order value you need given your cost stack; the card fee calculator derives your effective rate cleanly. For the complete strategic context, the Shopify profitability pillar connects everything.

A worksheet does not transform a struggling store into a profitable one on its own. What it does is collapse the gap between when something changes in the business and when the owner sees it — from six weeks (the accountant report cadence) to one day (the evening close-out cadence). That collapsed gap is the entire reason daily P&L works. The number on the right edge of tonight's row is the number the bank will tell you about three weeks later; knowing it tonight is what gives you three weeks of decisions back. Copy the template, fill it tomorrow evening, and the first surprise will arrive within a week.

FAQ