The free weekly P&L template.
If nightly is too often for your business, weekly is the honest minimum. One row per week — revenue, costs, and the profit after a fair slice of fixed costs — across a full quarter, so a soft patch shows up in week three, not at the year-end.
Direct .xlsx download · no email required · Excel, Google Sheets, LibreOffice & Numbers
Start here
Tax rate, card fee, monthly fixed costs and weeks open per month — typed once. Fixed costs are sliced to a weekly share.
Weekly P&L
Thirteen week-rows (a quarter): cash and card revenue, COGS, variable costs, weekly fixed slice → net revenue and EBIT per week, with a quarter total.
Trend at a glance
A quarter on one screen. Profit rising, flat or slipping is obvious across thirteen rows in a way a stack of monthly statements never makes it.
Weekly is the honest floor, not a compromise
Not every business suits a nightly number. A quiet studio, a workshop, a service business with a handful of larger jobs — for these, daily P&L is noise, because a single day tells you almost nothing. But monthly is genuinely too slow: by the time a month closes and reconciles, a bad patch has run for five or six weeks unchallenged.
Weekly is the sweet spot for a lot of small businesses. A week is long enough to smooth out a dead Tuesday and a bumper Saturday into a real signal, and short enough that you catch a downturn while there’s still a quarter left to fix it. This template makes weekly the path of least resistance: one row, once a week, thirteen weeks to a page.
A quarter on one sheet, so the trend is unmissable
The reason monthly statements fail owners isn’t the maths — it’s that each one arrives alone, a month apart, and the human brain is terrible at comparing a number today with a number it half-remembers from six weeks ago. Thirteen weeks in a column fixes that. Profit rising, holding or slipping is a shape you can see in a glance, not a comparison you have to reconstruct.
That shape is what changes decisions. Three flat weeks in a row is a conversation about pricing or costs while you can still have it. The same information spread across three monthly PDFs usually gets noticed a quarter too late — which is the difference between adjusting and scrambling.
How to use it (Sunday night, ten minutes)
Once: in Start here, enter tax rate, card fee, your monthly fixed costs and how many weeks a month you trade. The sheet converts your fixed costs to a weekly slice so each week is charged its fair share of rent and overhead.
Every week: total the week’s cash and card revenue, what you spent on goods, and variable costs, and drop them into the week’s row — ten minutes on a Sunday from your till and bank. The sheet returns the week’s net revenue and EBIT, and a running quarter total.
If a particular week begs for a closer look, the daily templates (café, salon, retail, restaurant, barbershop, food truck) break the same maths down day by day — and the free daily profit calculator checks a single day on its own.
From a weekly sheet to a live picture
A weekly spreadsheet asks for discipline once every seven days, which is much easier to keep than a nightly one — this is a template that tends to survive. Its limit is the same as any spreadsheet’s: it only knows what you enter, and it can’t nudge you when a bad week is forming mid-week.
nouz keeps the profit picture live as the days go in, then rolls it up to the week and the quarter for you — so you get the weekly trend this template gives, without waiting until Sunday to see a problem that started on Wednesday. The demo shows it on sample data; no account, no card.
Common questions
Is it free and ungated?
Yes — a direct .xlsx download, no email, no form. Opens in Excel, Google Sheets, LibreOffice or Numbers.
Who is a weekly P&L for, versus a daily one?
Weekly suits businesses where a single day says little — studios, workshops, appointment-led services, quieter shops. Daily suits high-transaction businesses like cafés, restaurants and retail where each day is a real signal. Weekly is the honest minimum; monthly is usually too slow to act on.
How does it handle fixed costs on a weekly basis?
You enter monthly fixed costs and how many weeks a month you trade; the sheet charges each week a weekly slice. So each week’s profit is after its fair share of rent and overhead, just like the daily templates do per day.
How many weeks does it cover?
Thirteen — a full quarter on one sheet, which is what makes the trend visible. Copy the sheet for the next quarter; the Start here settings carry over.
Can I switch to daily later?
Easily — the daily templates use the identical formula, just per day instead of per week. Many owners start weekly to build the habit, then move to a daily template (or the app) once they want a sharper picture.
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