5 min read stedd.io Team

The 30-Minute Friday Review That Replaced All My Spreadsheets

I used to spend Friday afternoons in spreadsheets trying to figure out what state my business was in. A 30-minute weekly review replaced all of it.

Productivity Operations

I used to spend most of Friday afternoon trying to answer one question: “what state is my business in?”

I had spreadsheets. A pipeline tracker. A revenue forecast. A customer list with statuses. An invoicing log. A monthly P&L I updated by hand. By the time I’d reconciled everything and figured out where I stood, it was 6pm and I’d done nothing useful with the information.

Now I do a 30-minute Friday review. No spreadsheets. Same questions answered, same decisions made, in a fraction of the time. Let me describe exactly what it looks like, in case it’s useful to anyone else stuck in the same loop.

The five questions the review answers

The review is built around five questions. Every Friday, I want answers to these:

  1. How much money is owed to me, and how overdue is any of it?
  2. How many active opportunities do I have, and what’s their total value?
  3. What’s stuck — quotes that haven’t been responded to, jobs that haven’t progressed, leads that have gone cold?
  4. How does this week’s revenue compare to plan?
  5. What single thing should I focus on next week?

That’s it. Five questions. If I have honest answers to those five, I can make every important decision about the business.

The 30 minutes, broken down

Minutes 0-5: Money owed.

Open the dashboard. Look at the “outstanding invoices” view. Two numbers: total owed, and total overdue. If anything is more than 30 days overdue, I make a note to call (not email — call) the client on Monday.

That’s it. The system already knows who owes me what. I just look.

Minutes 5-15: Pipeline.

Open the pipeline view. Look at:

  • Total opportunities and total value
  • Anything that’s been in the same stage for more than two weeks (these need a nudge)
  • Anything in “quoted” longer than 10 days (probably a follow-up needed, even though automation should have handled it)
  • Anything in “won” that hasn’t progressed to “in progress” within a few days (chase the contract)

I make a list of any opportunities that need a personal nudge from me. Usually 2-4 per week.

Minutes 15-22: This week’s wins, losses, and lessons.

Look at what closed (won or lost) this week. For each:

  • Won: was the deal size and timing what I expected?
  • Lost: do I know why? Was it price, fit, timing, or something fixable?

This isn’t about beating yourself up. It’s about pattern recognition. Are you losing the same kind of deals repeatedly? Is the issue showing up in pricing, in your proposal, in your follow-up rhythm? After eight weeks of this, patterns emerge.

Minutes 22-27: Revenue check.

Look at the month’s revenue so far against the month’s target. Project where it’ll land based on the pipeline.

Three states are possible:

  • On track or ahead. Great. No action needed.
  • Behind, but pipeline says it’ll catch up. Trust the pipeline. No new action.
  • Behind, and pipeline says it won’t catch up. Now something needs to happen — usually accelerated outreach or pulling a deal forward.

This is the question I used to spend an hour on. Now five minutes.

Minutes 27-30: Next week’s focus.

Pick one thing. Just one. The single most important thing for next week.

It might be: “follow up personally with the three biggest open opportunities.” Or “deliver the Acme proposal by Wednesday.” Or “fix the new lead notification that’s been sending double emails.”

Whatever it is, it goes at the top of next Monday’s plan. Everything else is secondary.

What replaced what

Here’s what the 30-minute review replaced from my old workflow:

  • A pipeline spreadsheet I updated by hand → a live pipeline view
  • A revenue forecast I rebuilt every month → built-in dashboard
  • A customer list with payment statuses → outstanding invoices view
  • A “follow-up” tab in a spreadsheet → automated follow-ups + a “stuck” filter
  • A monthly P&L I updated weekly → I look at this once a quarter now, in detail, instead of badly every week

The old version took most of Friday. The new version takes half an hour. The actual information I got out of both is roughly the same. The difference is that one took two hours of admin and produced anxiety; the other takes thirty minutes and produces clarity.

Why thirty minutes, not longer

Important: this is a review, not a deep analytical session. Reviews should be short, regular, and ruthlessly focused. If you stretch it to two hours, you’ll start poking at things — analysing margins, redesigning the process, reading old emails. That’s a different exercise, and it should happen monthly or quarterly, not weekly.

The weekly review is for operational awareness. Where are we? What’s stuck? What needs a nudge? What’s the focus? Anything else is scope creep.

Why Friday

Friday afternoon, specifically. Not Monday morning. There are a few reasons:

  • The week is fresh. You can clearly see what happened.
  • You have the weekend to digest before acting on Monday.
  • Doing it Friday means you start Monday with a clear plan, not a scramble.
  • You leave the office (or laptop) with a sense of closure rather than carrying open questions through the weekend.

Try it. Not in some elaborate setup — just a calendar block at 3pm Friday and a list of the five questions. After four weeks, you’ll have a clearer picture of your business than you’ve ever had, and you’ll have spent ten total hours on it instead of forty.

stedd.io’s dashboard surfaces all five of these answers without you needing to dig. The review becomes the easiest 30 minutes of your week.