The free daily profit and loss template.
One row per day: revenue in, costs out, and tonight’s actual profit — with tax, card fees and a fair daily slice of your fixed costs already computed for you. Download it, open it, fill in five cells at close. No email address required.
Direct .xlsx download · no email required · Excel, Google Sheets, LibreOffice & Numbers
Start here
Four settings — your tax rate, card fee, monthly fixed costs and days open — typed once. Every formula reads from here.
Daily P&L
A month of day-rows. You type cash revenue, card revenue, COGS and variable costs; the sheet computes net revenue and EBIT per day.
The nouz formula
Gross revenue − tax − card fees = net revenue. Net revenue − COGS − variable costs − a daily slice of fixed costs = EBIT. The same formula the nouz app runs.
What a daily P&L template is (and what it isn’t)
A daily profit and loss template is not a shrunk-down monthly statement. It answers one question, tonight: did today pay? You log what came in and what went out today, and the sheet nets it against tax, card fees and one day’s slice of your rent, insurance and subscriptions.
Most P&L templates you’ll find — Smartsheet’s, your accountant’s — are monthly or annual. They’re for reporting, after the fact. This one is for deciding: whether to push tomorrow, cut a shift, or change a price while the week can still be saved. The maths is identical to a monthly P&L; the timing is the entire difference, and the timing is what changes what you do.
The template is deliberately five inputs wide. Anything you could add — a hundred expense categories, a chart of accounts, VAT-return fields — belongs in bookkeeping, not in a nightly habit. A daily P&L survives only if it takes under two minutes, so this one is built to take under two minutes.
How to use it (90 seconds at close)
Once: open the Start here sheet and type four numbers — your VAT/sales-tax rate, your card fee percentage, your total monthly fixed costs, and how many days a month you’re open. Every formula in the daily sheet reads from these four cells, so you never touch a formula again.
Every night: on the Daily P&L sheet, fill in today’s row — cash revenue, card revenue, what you spent on goods, and any variable costs that landed today. The sheet does the rest: today’s net revenue, today’s EBIT, and a running month-to-date total so a weak Tuesday shows up inside a strong week.
If a number looks wrong, it usually is — that’s the point of doing it daily. A daily P&L catches the quiet leaks (a creeping card fee, waste, a dead afternoon, a supplier price bump) within days, while a monthly statement would let them repeat for four more weeks before you ever saw them.
The two mistakes that break a daily P&L
The first is charging card fees to cash. Card fees only ever apply to card revenue — this template applies your fee percentage strictly to the card column and never to cash, because a euro of cash costs you nothing to accept. Getting this wrong quietly understates your cash days and overstates your card days.
The second is forgetting fixed costs. Rent doesn’t bill daily, so it’s easy to feel profitable on a day that didn’t actually clear its share of the overhead. The template slices your monthly fixed costs across your open days and subtracts that slice from every trading day, so the EBIT you read is the real one — the number after the day has paid its rent, not before.
When the spreadsheet stops being enough
A spreadsheet is genuinely the right way to start. It’s free, it’s yours, and it teaches you the formula in your own hands. Its single weakness is human: the night you’re tired, you skip it, and a skipped night becomes a skipped week becomes a “I’ll catch up later” that never closes.
If you can already name a tracker you abandoned once, that’s the honest signal a spreadsheet won’t stick this time either. nouz runs this exact same daily P&L — the same formula, the same five inputs — but keeps the history, does the maths, and takes the entry down to about 60 seconds on your phone at close. Try it with sample data in the live demo before deciding; no account, no card.
Common questions
Is this template really free? Do I have to enter my email?
Yes, free — and no email, no sign-up, no “work address” form. Click the button, get the .xlsx file. It works in Excel, Google Sheets (File → Import), LibreOffice and Numbers.
How is this different from a monthly P&L template?
A monthly P&L summarizes a month that already happened. This template computes profit per day — including a daily slice of your fixed costs — so you can react while the month is still going. The formula is the same; the timing is the whole difference.
What’s the formula behind it?
Gross revenue − tax − transaction fees = net revenue. Then net revenue − COGS − variable costs − (monthly fixed costs ÷ days open) = EBIT, your operating profit for the day. Every cell that computes is visible — no hidden macros.
Can I use it for more than one month?
Yes — copy the Daily P&L sheet for each new month, or duplicate the whole file per month. The Start here settings carry over. If you find yourself managing a folder of monthly copies, that’s usually the moment an app earns its keep.
Does it replace my accountant or bookkeeping?
No. This is an operating tool for you, not a compliance record. Your VAT return, year-end and payroll still belong with your accountant and their bookkeeping software. The daily P&L just means you’re not flying blind between their reports.
When do I outgrow the spreadsheet?
Usually the Tuesday you stop filling it in. A spreadsheet only works if someone updates it every night. nouz does the same daily P&L with the formulas, fixed-cost slicing and history handled for you — try the demo with sample data, no account needed.
Goes well with
Or skip the spreadsheet.
nouz runs the same daily P&L — formulas, fixed-cost slicing and history handled — for your small business. See it working with sample data first; no account needed.
Open the live demo