nouz vs Excel: is a spreadsheet still enough for your shop's daily P&L?

Almost every small-shop owner I have ever spoken to started with a spreadsheet. Excel, Google Sheets, a downloaded template from somewhere on the internet, a few formulas added over time. It is the obvious first move — free, familiar, no vendor to evaluate, no subscription to defend at month-end. And for the first 90 days of a new shop, it works. The honest question is not "is Excel bad for P&L?" — it is "at what point does the spreadsheet stop being enough?" This post answers that. No salesy slop, no pretending spreadsheets are useless. Five real strengths, five real failure modes, a side-by-side comparison, and a clean account of what nouz does that a spreadsheet cannot — and what it doesn't do that a spreadsheet still wins on.

TL;DR

Why owners pick spreadsheets first

Before listing what goes wrong, it is worth being honest about why owners reach for Excel or Google Sheets in the first place. These are not bad reasons. They are real strengths of the tool, and any P&L app that pretends otherwise is starting the conversation dishonestly.

It is free. Google Sheets costs nothing. Excel comes with the Microsoft 365 subscription most owners already pay for. Compared to a €19–79/month SaaS, that is a meaningful difference for a shop in its first year, when every fixed cost is being weighed against whether the doors will still be open in six months.

It is familiar. Most owners have used spreadsheets since school. There is no learning curve, no onboarding flow to sit through, no decisions about which plan to pick. You open a file, you type numbers, you write a formula, you get a result. The cognitive load of evaluating a new tool is zero because there is no new tool to evaluate.

It is infinitely customisable. If your shop has a weird cost line — a seasonal payment to a neighbour for shared bin collection, say — you add a row. If you want a tab for one location and another tab for the other, you add a tab. No product manager is deciding for you what fields exist. The sheet bends to the shape of your shop, not the other way around.

There is no vendor lock-in. The .xlsx file is yours. If you stop paying Microsoft, the file still opens in LibreOffice, in Google Sheets, in Apple Numbers. There is no risk that a SaaS company gets acquired, sunsets the product, and locks you out of three years of your own data. Owners who have been burned by vendor deprecation before take this seriously, and they are right to.

Your accountant can read it. Send the file. They open it. Done. No login, no shared seat, no permissions dance. For owners whose accountant relationship is "email a spreadsheet once a quarter," the spreadsheet is the path of least friction.

All five are real. None of them disappear when you switch to a SaaS tool — they get traded for different strengths. The question is whether the trade-off is worth it for your shop. That depends on which failure modes you have already hit.

When the spreadsheet breaks

There are five failure modes that show up in nearly every shop spreadsheet that has been alive for more than a year. They are not exotic — they are the boring, predictable ways that any human-maintained file degrades over time. The honest test is whether you have hit any of them in your current sheet.

Failure one: formula drift. You add a row in March. The sum at the bottom of the column does not automatically expand to include it because the formula range was hard-coded as =SUM(B2:B45). You only notice in May, when your "monthly revenue" looks suspiciously low and you start digging. By then you have made two pricing decisions on understated numbers. Formula drift is invisible in real time — it only surfaces when you cross-check, which most owners do not.

Failure two: version chaos. The file lives on your laptop. You email a copy to your accountant in February. They send back a "cleaned up" version. You make changes to your local file in March. You forget which is the source of truth. By June you have pnl_2026.xlsx, pnl_2026_v2.xlsx, pnl_2026_v3_FINAL.xlsx, pnl_2026_v3_FINAL_actual.xlsx, and one called simply pnl_use_this_one.xlsx that is two weeks out of date. Owners on Google Sheets dodge some of this with shared editing, but accumulate a different problem: nobody knows who changed what or when.

Failure three: one wrong delete. A staff member or family member is helping with admin. They click a cell, hit delete, save the file, close it. You discover three weeks later that the daily fixed-cost slice formula in cell K4 has been replaced with the number 0. Every day since then has been computing a flattering EBIT. The fix is to find the last good version (see failure two) and copy the formula back. The downstream damage — three weeks of decisions on bad numbers — has already happened.

Failure four: no daily nudge. A spreadsheet does not text you at 9 p.m. to ask if you forgot to log Saturday's sales. It does not turn red if Tuesday was skipped. It sits there, patient and silent, while the data gap grows. The most common way a shop spreadsheet dies is not formula breakage — it is the owner who skipped a busy Friday, told themselves they would catch up Sunday, then skipped Sunday, then realised they could not remember whether Friday's card mix was 70% or 80%, and quietly stopped opening the file. The sheet does not raise the alarm because the sheet does not care.

Failure five: no comparison built in. A spreadsheet shows you today's EBIT — if you typed the right things in the right cells. It does not show you "this Tuesday vs last Tuesday vs the Tuesday before." Building that view manually means adding a chart, configuring the data range, choosing a comparison method, updating the range every time you add a row. Most owners do not build the comparison view, which means the daily P&L is a number with no context. A €312 EBIT day means nothing on its own. €312 today vs €428 the same weekday last week is a question worth asking.

What a P&L spreadsheet usually misses

Beyond the maintenance problems, the structural issue with most shop P&L spreadsheets is that the formulas themselves are usually wrong in five specific ways. These are not exotic errors — they are the same five mistakes in template after template, including the paid ones. Our three spreadsheet sins post covers the worst three in depth; here is the broader list as it applies to a daily P&L sheet specifically.

Card fees applied to cash by accident. The formula is written as "revenue × 1.4%" and applied to the whole revenue column — instead of being applied only to the card portion. Cash sales are not charged a card fee by anyone, but the spreadsheet quietly subtracts a fee from them anyway. On a shop with 50% cash mix, this overstates costs by a meaningful amount every single day. The opposite error is worse: the fee gets forgotten on card sales entirely, flattering profit by 1–2% of revenue.

COGS retroactively edited. You bought a new wholesale price list in April. You go into the spreadsheet, update the cost price of the espresso beans from €18/kg to €21/kg. Every cell that uses that cost price now recalculates — including the March entries, which now show a different COGS than they actually had at the time. March's "real" profit just changed in the spreadsheet, even though nothing changed in the actual shop in March. The history is no longer trustworthy. nouz handles this with a COGS snapshot: when a sale happens, the cost price at that moment is locked in and never edited retroactively, even if you change the master product price later.

No daily fixed-cost slice. Most spreadsheets put rent, salaries and insurance on the day they were paid — the 1st of the month, say. That makes the 1st look like a catastrophic loss and the other 29 days look like silent winners. The honest accounting is to divide monthly fixed costs by 30.4375 (the average days per month) and apply that slice to every single day, including Sundays you were closed. Almost no off-the-shelf P&L template does this; the few that try usually divide by 30 (off by 1.5% on average) or by "trading days this month" (which makes February look more expensive per day than March, which is not the point).

No separation of gross / net / EBIT. The spreadsheet has a "revenue" column and a "profit" column. There is no line in between for net revenue (after VAT and card fees). There is no separate gross profit (after COGS). There is no EBIT distinct from net income. Owners reading the sheet do not know which of three different "profit" numbers they are looking at. Pricing decisions get made on gross margin numbers; staffing decisions get made on something that is closer to EBIT but with no fixed-cost slice. The decisions are not bad because the owner is bad — they are bad because the spreadsheet does not surface the right number for the right question. Our EBIT explained post walks through why the operating profit layer is the one that drives day-to-day decisions.

No per-product cost tracking. The spreadsheet tracks revenue at the till total level, not per product sold. When margin slips, there is no way to see which SKU is the cause. The latte is still priced at €4 but the milk wholesale just went up 12%; the dress that was the season hero is now mostly being sold on markdown at 30% off. A spreadsheet can be built to do per-product tracking — but it requires a separate tab per product, formulas linking the sale row to the product cost, and discipline most owners do not maintain past month three.

Side-by-side: spreadsheet vs nouz

Ten rows on the things that matter for a small-shop daily P&L. Honest on both sides — there are columns where the spreadsheet wins and columns where nouz wins. Pricing reflects the publicly listed nouz rates as of 2026-05-24; spreadsheet costs assume Google Sheets (free) or Microsoft 365 (~€7/month for the office bundle most shops already pay for).

When a spreadsheet is genuinely the right tool

There is a real profile of shop owner for whom a spreadsheet is the better answer. It is not the underdog answer for every shop; it is the right answer for some shops. The profile, as honestly as I can name it:

• One owner, one location. No staff who need access to the file. No second site whose numbers need to be kept separate but comparable. Multi-tab spreadsheets for multi-location work in theory and crumble in practice past the first quarter.
• Under roughly €5k/month revenue. At this volume the maintenance burden is small — a handful of revenue entries per day, a handful of cost lines per month. The spreadsheet has not yet grown into a maintenance project of its own.
• You already love spreadsheets. Some owners genuinely enjoy the work of maintaining a sheet. They think in cells and ranges, they like building formulas, they treat the Sunday-evening close-out as a meditative ritual rather than a chore. For these owners the spreadsheet is not a workaround for a missing tool — it is the tool. The right tool is the one you will actually maintain.
• Your shop is new enough that the model is still moving. In the first 90 days of trading, you are probably still adjusting the menu, changing suppliers, adding and removing products weekly. A spreadsheet bends to that volatility better than a structured app does. Once the shape of the business settles, the structured tool earns its keep — but not before.
• You have a previous spreadsheet you maintained for years. If you can point to two years of clean monthly P&Ls in Excel and never abandoned the file, you are the rare owner whose habit will hold. Keep the habit; do not interrupt a working system to chase a slightly nicer interface.

For owners outside this profile — multiple locations, growing revenue, staff who help with admin, a previous spreadsheet you stopped updating — the maintenance cost of the sheet starts to bite and the case for a structured tool gets stronger every month.

When you've outgrown it

Five signs the spreadsheet has stopped working for you. None of these are universal; one of them is usually enough.

One: you skip days. Three or more missed days in the last month is the threshold worth taking seriously. The data gap is the most common failure of spreadsheet P&L tracking and it is rarely a discipline problem — it is a friction problem. If the tool requires 5 minutes per close-out and you have a busy week, you skip. If the tool requires 60 seconds and pushes a small reminder, you do not.

Two: your formulas argue with each other. The "monthly profit" number on the summary tab disagrees with the sum of the daily EBIT numbers on the detail tab. You are not sure why. You have been meaning to look into it. You have been meaning to look into it for four months. The fact that you have not is the signal — not because you are lazy, but because the cost of debugging the sheet is now higher than the cost of just trusting the wrong number, which is the worst possible place to land.

Three: you can't trust last quarter's numbers. If your accountant asks "what was your Q1 EBIT?" and your honest answer is "let me check the sheet and then re-derive it because I am not sure," the sheet has stopped being a source of truth. P&L tracking only matters if the historical numbers can be trusted as much as today's — otherwise every reading is just a snapshot with no context.

Four: you don't know today's EBIT without 10 minutes of clicking. The daily number is the whole point. If reading it requires opening the file, scrolling, filtering, re-checking a formula, summing manually because the auto-sum range never updates — you are not getting daily P&L visibility. You are getting "P&L visibility after 10 minutes of paperwork," which is a different and worse thing.

Five: you have created a v4. The file naming convention is the giveaway. pnl_v4_real.xlsx means three previous versions failed in ways that required a fresh start. Each version was a project. The accumulated time spent rebuilding the sheet has now exceeded what 12 months of a paid tool would have cost — except the sheet still has the same structural problems that broke v1, v2 and v3.

If two or more of these apply, the spreadsheet is no longer the right tool for your shop. The honest question becomes which structured tool to move to, and our comparison of five daily P&L trackers covers the options including nouz, QuickBooks, Xero and TrueProfit. The rest of this post is what nouz specifically does differently — for the subset of owners whose answer is "small physical shop, want tonight's profit tonight."

What nouz does differently

Six things, mechanically. Not "we believe" or "our mission" — what the product actually does on the days you use it.

One: the formula is purpose-built and locked. nouz uses one EBIT formula for every shop: Gross revenue − Tax − Card fees = Net revenue; then Net revenue − COGS − Variable costs − Fixed cost slice = EBIT. The formula lives in one file (/lib/calculations.ts) and is the same on every shop, every day. You cannot break it by deleting a cell. You cannot accidentally apply a card fee to cash because the data model separates cash and card revenue from the moment you enter them. The full breakdown of the formula and worked examples for café, retail, salon and e-commerce is in the EBIT explained post.

Two: COGS is snapshotted at the moment of sale. When a product sells, the cost price at that moment gets locked in on the entry. If you later edit the product's cost price to reflect a new supplier deal, past sales are not retroactively rewritten — they keep the cost they actually had. This is the single biggest reason history stays trustworthy in nouz where it drifts in a spreadsheet. You can change product prices freely without worrying that you are corrupting March.

Three: fixed costs slice automatically. Enter rent, salaries, insurance, software, accountant fees as monthly amounts with start and (optionally) end dates. The daily fixed-cost slice is calculated as monthly total ÷ 30.4375 and applied to every single calendar day, including weekends and closed days. You never see the line item "rent paid today €1,200 — disaster"; you see the daily slice that is the honest cost of being open that day. Closed Sundays show their real cost. Strong Saturdays earn against the same daily floor as quiet Tuesdays.

Four: 60-second close-out. At end of day, two screens. Enter today's gross revenue split by cash and card. Enter today's variable costs as a short list of one-line entries. Hit save. The EBIT is on the home screen before you put your phone back in your pocket. That is the whole daily routine. Setup is roughly 7 minutes once; the daily ritual is roughly 60 seconds from then on. The detailed routine is documented in the 60-second close-out help article.

Five: comparison cards out of the box. The home screen shows today's EBIT next to yesterday's and next to the same weekday last week. No chart configuration, no range selection. A €312 EBIT day is a number; €312 today vs €428 the same Tuesday last week is a question. The comparison is the part that actually drives the next decision — and it is the part most spreadsheets never build because it is fiddly to maintain.

Six: multi-location is real, not a tab. Every operation in nouz is scoped to a single location_id. Cash from the city centre shop never shows up in the suburb shop's totals. The fixed-cost slice for the city site is calculated on the city site's fixed costs, not a blended monthly total. Multi-location spreadsheets usually collapse into a single tab-per-site approach that becomes hard to compare across — nouz keeps the sites separate but lets you switch between them in one click.

For the things nouz does not do — POS integration, CSV export, languages beyond English, yearly billing — those are honest gaps and they are listed openly on pricing and in the comparison post. nouz is not the right tool for every shop, and the cases where a spreadsheet beats it are the cases listed above.

The honest cost trade-off

The thing every nouz vs Excel post tiptoes around: nouz is paid. The spreadsheet is free. That is a real difference and ignoring it would be dishonest.

nouz starts at €19/month, paid monthly only — there is no annual discount, no free tier, no introductory offer. Over a year that is €228. A Google Sheet is free; an Excel file inside the Microsoft 365 bundle most shops already pay for is effectively a marginal zero. On pure cash cost, the spreadsheet wins by €228/year. That is the truth.

The trade is your time. A well-maintained spreadsheet takes 3–8 minutes per day to update if the formulas are tidy, plus the occasional 30-minute session to fix something that has drifted, plus the bigger session every six months when you redesign the template because v3 has accumulated too many band-aids. That comes to roughly 30–50 hours per year of maintenance for the average single-shop spreadsheet. At the implicit hourly rate most owners would pay themselves if they were honest about their own labour (see the owner-salary trap in the EBIT post for that exercise), 30–50 hours is worth dramatically more than €228.

The honest framing is this: if your spreadsheet takes under 10 minutes per week and never needs maintenance — which is rare but does happen for a tiny operation with a simple template — the spreadsheet is genuinely the cheaper tool. If your spreadsheet is in any of the failure modes above, the time you are spending on it has already overtaken the cost of the paid tool, and you are paying for the spreadsheet without seeing the bill.

For owners who want to feel the nouz workflow before deciding, the free daily profit calculator runs the exact EBIT formula in your browser — no account, no signup. Plug in a real day. See the EBIT. Then look at the number your spreadsheet produced for the same day. The gap between the two is usually the cost of running on a slightly-wrong formula. The free daily P&L template post covers a spreadsheet you can build yourself if the answer for your shop is "stay on spreadsheets but fix them." And the daily vs monthly P&L explainer covers why the cadence question matters more than the tool question.

The honest summary

A spreadsheet is genuinely the right tool for some shops. One owner, one location, low revenue, owner enjoys spreadsheets, history is clean — keep it. The discipline of a daily close-out matters more than the tool you use to close out. Plenty of owners run profitable shops on a well-maintained Google Sheet for years.

For most owners who have been at it for more than a year, the spreadsheet is past its peak. The five failure modes (formula drift, version chaos, accidental delete, no nudge, no comparison) and the five structural problems (card fee on cash, retroactive COGS, no fixed-cost slice, no gross/net/EBIT separation, no per-product cost) have accumulated quietly. The numbers are still being read; they just are not as trustworthy as they were. The fix is either a serious afternoon spent rebuilding the sheet honestly, or a switch to a tool that handles those structural issues by default.

nouz is one of the tools built for that switch. It is opinionated about the formula, opinionated about the cadence, and honest about what it does not yet do. Monthly subscription, no POS integration, no CSV export, English only. For the owners it does fit — small physical shop, want tonight's profit tonight, do not want to become a bookkeeper — it does that one job carefully. The argument for the cadence itself sits in the master daily P&L primer. For everyone else, the comparison post covers the alternatives.

FAQ