How to track daily revenue for a small shop (no spreadsheet needed).

If you run a small café, retail store, salon or e-commerce shop and you want to know what your business actually made today — not the rough impression at close, not the number your accountant assembles in three weeks — nouz exists for that, but you do not need software to start. The method is three numbers, captured every evening, in two minutes: cash sales, card sales, variable spend. Tonight, on the back of an envelope. Tomorrow, the same. By day fourteen you will already see things in your business you have never seen before.

TL;DR

Why spreadsheets fail at daily tracking

Most owners who decide to start tracking daily revenue open Google Sheets, find a template, fill in the columns for week one with enthusiasm, week two with discipline, week three with patchy entries, and by week six the sheet is abandoned. The pattern repeats across café owners, boutique owners, salon owners, and Shopify shop owners. It is not a willpower problem. It is a friction problem.

The mechanics of the failure are predictable. The spreadsheet lives on a laptop you do not open at close. To enter today's numbers you must walk to the office, open the file, find the right tab, scroll past three months of old entries, work out which row is today, and remember the formula in the margin column. By the time you have done all that it is 9pm, the kids need attention, and tomorrow you will catch up — except tomorrow you also do not catch up, and now you owe the sheet two days of entries, then three, then a week. After a week missed, the gaps make the sheet useless and you stop.

A second failure mode: the sheet you copied online was built for a different kind of business. It has columns for inventory turnover, gross margin per SKU, contribution margin, fixed cost allocation, and twenty other things you do not yet need to see daily. The complexity stops you from filling it in because every entry feels like work.

The fix is not a better spreadsheet. The fix is to drop to the minimum viable tracker — three numbers, on whatever you have to hand, captured the same evening — and only upgrade once the habit is in your bones.

The minimum viable tracker (paper + envelope)

Take an A5 notebook, a manila envelope, or the back of a placemat. Draw five columns. Label them: Date · Cash · Card · Variable spend · Notes. That is it. That is the entire tracker.

Keep it under the till, or in the drawer with the float, or wherever you already go at close. The whole point is that the tracker lives where the work happens, not in a separate office, not on a laptop, not in an app that needs unlocking. At close, before you cash up, you write the four numbers and any one-line note ("birthday rush", "rain all afternoon", "new staff first shift"). The envelope catches the receipts for the variable-spend line — supplier receipts, the trip to the wholesaler, the printer ink — so when you total it up you have proof.

After a week you will have something like this:

Seven days. Twenty-eight numbers. About fifteen minutes total writing time across the week. And already you can see things: Tuesday's variable spend is a wholesaler hit and not really an operating cost (it bought next week's stock); Saturday is doing 3× a Sunday; loyalty promo on Thursday looks promising but needs another two weeks to be sure.

The 3 numbers you must capture every day

There is no shortage of metrics you could track. There are exactly three you must, because every other useful number is built from them. Skip any one and the rest collapses.

1. Cash sales

Total of everything paid in cash today. Count the till at close, subtract the float you started with, subtract any cash payouts (the supplier you paid in cash, the wages you handed over). The remainder is today's cash sales. For most small shops in 2026 this is the smaller of the two revenue numbers — typically 15-40% of total revenue, depending on country and clientele. Salons and cafés skew higher on cash, e-commerce is near zero.

2. Card sales

Total of everything paid by card today. Your card terminal — SumUp, Stripe, Square, Adyen, iZettle, whichever — prints or shows a daily total at close. Take the gross number, before the processor's fee is deducted. The fee shows up later as a deduction in your settlement payout; today's number is the headline gross. Card is the larger number in most shops: typically 60-85% of total revenue.

3. Variable spend

Everything you paid for today that is not a regular fixed cost. The bag of beans the barista ran out and bought from the wholesaler at lunch. The cleaning spray. The till roll. The replacement filter for the espresso machine. The taxi for the supplier pickup. The packaging tape, the parcel labels, the salon towels you grabbed from the cash-and-carry. Put the receipts in the envelope; at close add them up.

What counts as variable spend versus fixed cost? A fixed cost is something you pay on a schedule regardless of how busy you were — rent, payroll, software subscription, insurance. Variable spend is everything else, every small operational outflow tied to actually running the business today. If you are unsure on a line, put it in variable for now. The categorisation can be tightened later; what matters tonight is that it is captured.

Why split cash and card

It is tempting to add cash and card together into one revenue number — "today did €1,500" — and skip the split. Three reasons not to.

One: card transaction fees. Your card processor takes a percentage of every card sale — typically 1.4% to 2.5% in Europe in 2026. That fee does not apply to cash. If you do not separate cash and card at the entry point, your fee calculation will be off by 30-50% depending on how cash-heavy you are. On a €1,500 day with €1,100 card volume at 1.7% the fee is €18.70. If you accidentally calculate the fee against the full €1,500 you would over-deduct by €6.80 — and over a year of busy days that is hundreds of euros of phantom cost that distorts your real profit picture.

Two: bank reconciliation. Cash either gets deposited at the bank (and you can match the deposit to the cash sales line) or it sits in the till float and rolls forward. Card settles automatically into the bank a few days later, net of fees. The two numbers behave differently in the bank statement and you need to reconcile each separately. Lumping them confuses you when the bank statement does not match your shop's daily total.

Three: future-proofing. Once you have six months of split cash-versus-card data you start seeing shifts that matter — card share rising from 65% to 78%, cash settling at a stable floor, the days where cash spikes (older clientele, market days, school holidays). These patterns inform terminal-rate negotiations, banking-fee decisions, and whether to keep accepting cash at all. If you mixed them you have nothing to look back on.

The deeper version of this argument lives in our piece on the seven leaks between sales and profit — leak three is card fees, and the fix begins with the cash-versus-card split.

The 2-minute close-out routine

The whole point of "daily revenue tracking" is the routine. If close-out is fifteen minutes you will not do it. If close-out is two minutes you will, every night, for years. Here is the literal step-by-step.

1. Print or read the daily total from your card terminal. Write the gross card number next to today's date.
2. Count the cash in the till. Subtract the float (the cash you started the day with). Subtract any cash payouts. Write the cash number next to the card number.
3. Pull every receipt from the variable-spend envelope. Add them up out loud. Write the total in the variable-spend column. Put the receipts back in the envelope (you may need them for VAT later).
4. Write one sentence in the Notes column: today's weather, any unusual event, anything that explains a number that looks off.
5. Close the notebook. Done.

Done properly, this is ninety seconds to two minutes. The card terminal already has the total; you are reading it, not calculating. The cash count is the same operation you already do for the float. The receipts are already in one place — the envelope — and you are just summing. The note is the part that creates the most value over time (it is what you will read in three months when you wonder why the second week of August was so quiet) so do not skip it even though it adds nothing to today's math.

From daily revenue to daily profit

Daily revenue tracking is step one. The reason it matters is that revenue alone does not tell you whether today paid for itself. A €1,500 day that came with €380 of wholesaler restock plus the daily slice of your monthly fixed cost is not as good as a €900 day with no restock and the same fixed slice. To get from revenue to profit you need three additional numbers: VAT (it was never yours), card fee (the processor's slice), and your daily fixed cost slice (rent, payroll, etc., divided by 30.4375).

The full formula nouz uses is what powers same-day profit and loss in the product:

If you want to do the profit math by hand right now without committing to software, our free daily profit calculator runs the exact formula in your browser. Plug in today's three numbers plus your VAT rate, card processor rate, and monthly fixed cost total; it gives you the EBIT for the day. No signup. No spreadsheet.

For a longer treatment of why daily — not monthly — is the right cadence, see daily vs monthly P&L: which is actually better. The short version: monthly P&L from your accountant is a backward-looking record useful for tax filing. Daily P&L is what you use to make next Tuesday's decisions. The first is reporting. The second is running the business.

When to upgrade from paper to software

The paper-and-envelope tracker is a real tool, not a placeholder. Some owners stay on paper for years and it works fine. Most outgrow it for one of three specific reasons.

One: the math gets tiring. Once you want the profit picture daily, not just the revenue picture, you are doing the VAT division, the card-fee multiplication, the fixed-cost slice math every evening. That is no longer a two-minute routine. A calculator can help; software does it automatically.

Two: you want to look back. Three months in, you want to know what your average Tuesday looks like, or whether April was better than March, or how this June compares to last June. Flipping back through a notebook to total weeks by hand becomes its own job. A digital tool aggregates and graphs in one click.

Three: you want it from your phone. Sometimes you are at the shop and forgot the notebook. Sometimes you want to check yesterday's number from home. Paper does not move.

When one of those three things starts to matter, that is the time to switch. The honest pitch for nouz: setup takes about seven minutes — you enter your fixed costs once, your VAT rate, your card processor rate, and from that evening onward you have the same three numbers you were writing on paper, plus the profit math, in a daily view, on your phone or laptop. Cash and card go into separate fields. Variable spend is one tap per entry. The product is built specifically for non-technical solo store owners, no accountant required, monthly subscription only. Have a look at the live demo first — it runs in your browser with realistic sample data so you can see what the daily close looks like before signing up.

If you run a café, the vertical write-up of how the daily routine looks for hospitality is at solutions/cafe. If you run a small retail boutique, solutions/retail covers the retail-specific version — same three-number method, with notes on how to handle product inventory entries alongside manual revenue.

The 90-day picture

Daily revenue tracking pays back almost immediately — within a week you already see the cash/card split, within two weeks you see weekday patterns — but the real return is the 90-day picture. Three months of daily numbers gives you things no monthly report can.

The seasonality fingerprint. After 90 days you know your Mondays from your Saturdays. You know what "average" looks like for each weekday and you can spot a soft Saturday in real time instead of three weeks after the fact. You know which weeks of the month skew up and which down — payday weeks, school holidays, the dead week between Christmas and New Year, the Easter dip.

Drift detection. Variable spend that creeps up 8% month-over-month is invisible in a single bank statement but obvious in a daily tracker. You catch the wholesaler price hike, the packaging supplier rate change, the slow inflation of "miscellaneous" before it eats your margin.

Decision evidence. Promo on Thursdays — did it actually shift Thursday revenue or just shuffle it from Wednesday and Friday? After 90 days of daily data you can answer that. New supplier — did the cost change net out across the month or did it actually save you money? After 90 days you can answer that too. The numbers stop being a feeling and start being evidence.

Here is what a daily, weekly, and monthly view tell you, side by side:

Notice the timing column. Monthly reporting from an accountant lands two weeks after the month ends — useful for tax, late for action. Daily tracking lands the same evening — useful for next Tuesday's decision. They serve different purposes; you need both, but you cannot run a business on the monthly alone.

A note on other verticals

The three-number method (cash, card, variable spend) maps cleanly across small-shop verticals with small adjustments.

Salons add tips to the picture. Cash tips often run separate from till revenue and need to be tracked as part of total cash flow even though they pay through to the stylist. The cleanest approach: track tips as a fourth column and exclude them from the revenue calculation. They are income, not your income.

E-commerce has almost no cash — the cash column is essentially zero for a Shopify shop. The card column becomes the daily Shopify settled total. Variable spend includes shipping, packaging, returns processing, and per-order platform fees. The math is otherwise identical; the daily routine is identical.

Retail boutiques sometimes have a third revenue channel — invoiced wholesale orders. Track them separately from till revenue because the payment timing is different (invoices settle in 30 days). Daily till revenue is one line; wholesale invoices booked today is a different line.

Mixed shops — café with retail, salon with retail attach, e-commerce with pop-up — track the channels separately at the entry point. They will diverge in margin, in fees, and in seasonality; mixing them at entry erases information you will want later.

Start tonight

Tomorrow does not need to be different from today for this to work. Tonight, at close, write three numbers. Tomorrow night, write three more. By the end of next week you will have data, by the end of the month you will have a pattern, by the end of the quarter you will be running the business on numbers instead of feelings.

FAQ