All templates Free template · Excel · Weekly cadence

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

Sheet 1

Start here

Tax rate, card fee, monthly fixed costs and weeks open per month — typed once. Fixed costs are sliced to a weekly share.

Sheet 2

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.

Built in

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.

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.

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