Three spreadsheet sins, ranked. (And the one redemption.)

I've inherited hundreds of small-business spreadsheets — cafés, salons, hardware shops, kitchen-table Etsy sellers. They make the same three mistakes. Mixing gross and net. Hiding the rent. Never reconciling the till. Each one quietly inflates the "profit" number on the spreadsheet by 20-40%. Owners then make pricing and hiring decisions on a fantasy.

TL;DR

Sin one: mixing gross and net

This is the biggest one and it's in roughly 8 of every 10 spreadsheets I open. The "Revenue" column shows the gross amount — what was rung up at the till. The owner subtracts costs from that number and calls the result profit.

But the gross number contains two things that were never yours: VAT (which you owe the tax office) and transaction fees (which the card processor already kept). If your café did €1.247 yesterday at 20% VAT with €820 of it on card at 1,4%, the gross is €1.247 — but the money that actually belongs to the business is €1.027,69. Subtract costs from the wrong number and your "profit" is overstated by €219.

Multiply by 300 trading days. That's a €65.700 hallucination per year. I've had owners realise — in the same call — that the staff bonus they'd been paying for two years was coming out of money that was never theirs. Your accountant would call this "presenting turnover as revenue." It's a sin because it changes every decision downstream.

The fix is mechanical: split the column. One for gross, one for VAT, one for card fees, one for net. Or just use a tool that does this without asking — nouz logs revenue with the split built in, and the related gross vs. net piece walks through the maths.

Sin two: rent is invisible

The second sin: the spreadsheet has a "daily profit" tab, and rent only shows up on the last day of the month. So 29 out of 30 days look great. The 30th looks like a disaster.

This is technically not wrong — the rent is a real cost, and it did get paid. But it gives owners a false read of which days are pulling weight. The Tuesday that looks like it made €420 actually made €320 once rent is sliced into a daily €100. The Saturday that looks like a €900 hero made €800. Same shape, calibrated to reality.

Here's a concrete example from a Vienna café I worked with before joining nouz:

Sunday is the giveaway. Closed days cost money — rent is still dripping. Owners who don't slice the rent never feel the weight of the closed day; owners who do start asking sharper questions about Mondays.

The accounting term for this is fixed cost allocation. The right amount to allocate per day is monthly fixed cost ÷ trading days that month. Setting up fixed costs in nouz takes one entry per cost; the slicing happens automatically.

Sin three: never reconciling the till

The third sin is quiet. The owner trusts the POS total. They never count the actual cash in the drawer. They never compare card-machine settlements to till card totals.

Three things go wrong here, every single week, in every shop I've audited:

• Cash leaks. Wrong change, voided sales that were already given, the €5 the supplier was paid in cash that no-one logged. Median: €15-€30/week per location.
• Card-machine timing. A sale at 23:55 gets settled next-day. If you reconcile by calendar day without correcting for this, every Monday morning looks like a small miracle and every Sunday looks suspiciously thin.
• Refunds. Issued on the card terminal but never marked as refunded in the spreadsheet. The customer's money is back with them; the revenue number in your sheet says it isn't.

Owners ask me how their margin can be 18% on paper and 9% in the bank. Nine times out of ten, the till is the answer. Not theft. Just unreconciled paper.

The fix is a two-minute end-of-day count. Cash counted vs. POS cash total. Card terminal settlement vs. POS card total. Discrepancies logged, not ignored. The first week you do it you'll find a leak. The first month you'll have plugged it.

The redemption: daily close-out

All three sins have one shared cause: the spreadsheet is updated occasionally. Once a week. Sometimes once a month, on a Sunday afternoon, from memory and receipts. By then, the small errors have compounded into big ones.

The redemption is a five-minute daily close-out. Same time every day. Same checklist:

1. 01
   Count cash

   Physical count, compare to POS cash total. Log the variance, even if it's €2.

2. 02
   Settle the card terminal

   Press end-of-day on the terminal. Compare to POS card total. Note refunds.

3. 03
   Log the day's revenue

   Gross, split into VAT and fees, into your sheet or into nouz. If you took manual sales (a function or a one-off), log those too.

4. 04
   Log variable spend

   Petty cash, last-minute restocks, the driver's €15 tip. If it left the business today, log it today.

5. 05
   Read the EBIT

   After fixed costs are sliced in (automatic, if set up once), look at the day's EBIT. Three seconds. Done.

Five minutes. Daily. The compounding effect is enormous: the spreadsheet stays honest, the till stays tight, the rent stays visible. The 60-second close-out is documented in the help center if you want a printable version for behind the till.

When the spreadsheet stops being enough

Spreadsheets work fine for a single-location shop with one revenue stream and no products to track. Past that, they start to break — version conflicts, broken formulas, an intern who deletes a column.

My rough rule: when you cross €8.000/month in revenue, or you start tracking COGS at the SKU level, or you open a second location — that's when the spreadsheet starts costing you more time than it saves. That's where Café Vrba in Prague landed last year — they switched off a 14-tab Google sheet and have not looked back.

If you're still in spreadsheet phase: at minimum, commit to the daily close-out. The format doesn't matter; the cadence does. If you're ready to graduate, try nouz free for 14 days — the gross/net split, rent slicing, and till reconciliation are all baked in.

FAQ