Sales Reports: 8 Reports Every Owner Should Check Weekly

Quick answer

The sales reports an owner should check weekly are: new leads by source, lead response time, sales funnel with stage drop-off, pipeline value, overdue follow-ups, quotations sent and pending, revenue by product or region, and outstanding payments. Together they show whether enough demand is coming in, whether the team is acting on it and whether sales are turning into cash.

Key takeaways

  • Eight reports cover demand, activity, pipeline and cash
  • Look at trends week on week, not one-off numbers
  • Every report should lead to a question for a named person
  • Reports are only as good as the data your team enters

The sales reports a business owner should check every week are the ones that answer four questions: is enough demand coming in, is my team acting on it quickly, are deals moving towards orders, and is money actually being collected? Eight reports cover this well: new leads by source, lead response time, sales funnel, pipeline value, overdue follow-ups, quotation status, revenue by product or region, and outstanding payments. You do not need a large dashboard; you need these eight, reviewed at the same time every week, with a clear question for someone whenever a number moves.

Why should owners look at sales reports themselves?

Many SME owners in India rely on a weekly verbal update from the sales head. That is useful, but it is an opinion. Reports show the underlying facts, and they surface problems early: a lead source drying up, a salesperson falling behind, or payments quietly slipping. When the owner looks at the reports, the team also takes data entry seriously.

The 8 weekly sales reports at a glance

#ReportWhat it tells youQuestion to ask
1New leads by sourceIs demand coming in, and from where?Which source dropped, and why?
2Lead response timeAre we replying fast enough?Who is slow, and what is blocking them?
3Sales funnel with drop-offWhere are we losing buyers?Why do deals stall at this stage?
4Pipeline value (open and weighted)What sales are likely in coming weeks?Is the pipeline big enough for our target?
5Overdue follow-upsIs the team doing what it planned?Which buyers have been forgotten?
6Quotations sent and pendingAre offers going out and being chased?Which big quotations need my help?
7Revenue by product or regionWhat and where are we actually selling?What explains the change from last month?
8Outstanding paymentsAre sales turning into cash?Which dealers or buyers are past terms?

1. New leads by source

This shows how many enquiries came in during the week, split by IndiaMART, TradeIndia, website, Facebook or Instagram ads, referrals and so on. Compare it with the previous few weeks. A sudden fall from one source might mean a portal subscription issue, a paused ad or a website form that has stopped working. Over a few months, combine it with revenue by source to see which channels bring buyers, not just enquiries.

2. Lead response time

This report shows how long each salesperson takes to make first contact with a new lead. Buyers often contact several suppliers at once, so slow replies quietly cost you deals. If one person is consistently slower, check whether they have too many leads, are on the road, or are missing reminders. Read our full guide on lead response time.

3. Sales funnel with stage drop-off

The funnel shows how many leads moved from enquiry to qualified, quotation, negotiation and won, and where most of them fall out. A big drop between enquiry and qualified may mean poor-quality leads. A big drop after quotation may point to pricing, slow follow-up or unclear quotations. The funnel only works if your stages are well defined; see B2B sales pipeline stages.

4. Pipeline value: open and weighted

Open pipeline value is the total of all deals currently in progress. Weighted value adjusts each deal by how close it is to closing.

For example, as an illustrative calculation: a deal of ₹10 lakh at a stage you rate at 50% counts as ₹5 lakh weighted, and a ₹4 lakh deal at 25% counts as ₹1 lakh. Weighted value is a more realistic guide to what may close. If weighted pipeline is well below next month's target, you know early that you need more leads or faster conversion.

5. Overdue follow-ups

This list shows planned calls, visits and tasks that were not done on time. It is the single best indicator of whether the team is following its own plan. A long overdue list usually means one of three things: too many leads per person, poor discipline, or follow-ups being done but not recorded. Each needs a different fix. Our lead follow-up best practices guide helps here.

6. Quotations sent and pending

Track how many quotations went out, their total value, and how many are still awaiting a decision. Sort pending quotations by value and age. Large quotations older than a week or two deserve a call from the sales head or owner. If your system shows whether a buyer has opened a shared quotation, that tells you who is actively considering it.

7. Revenue by product or region

This is the report most owners already watch, but look at it by product and by region, not just as one total. It shows which products are growing, which territories are underperforming, and whether a single big order is hiding a weak month. Review monthly trends rather than reacting to one week.

8. Outstanding payments

A sale is not complete until the money is in the bank. This report shows how much each customer or dealer owes and how overdue it is. Review it with the salesperson responsible for each account, and agree actions. For dealer-heavy businesses, see dealer and distributor management.

How do you run a 30-minute weekly sales review?

  1. Look at the numbers before the meeting so the meeting is for decisions.
  2. Go through the reports in the same order every week: demand, speed, funnel, pipeline, activity, quotations, revenue, cash.
  3. For every problem, name one person and one action with a date.
  4. Check last week's actions first before discussing new ones.
  5. Keep it short. If a topic needs longer, schedule it separately.

What makes sales reports unreliable?

Reports reflect what people enter. Common issues are leads without a source, deals with old stages, values entered as zero, and follow-ups done on the phone but not logged. Fix these by making updates part of the daily routine, keeping fields few, and using reports in meetings so people see why accuracy matters. If your team still works mainly in spreadsheets, Excel vs CRM explains the trade-offs.

How SmartMorbi CRM helps

SmartMorbi CRM produces most of these reports from the work your team already records. You get a sales funnel with stage drop-off, lead response time per salesperson, revenue by lead source, product and region, and a deal pipeline showing open and weighted value. Quotations are tracked from sending to viewing to conversion into orders, and payments and outstanding are tracked against orders. Every report can be exported to Excel. Roles and team-level visibility mean managers see their team and the owner sees everything. Start a free trial and see the plans on our pricing page.

Frequently asked questions

Which sales report is most important for a business owner?

There is no single one, but if you can check only two, look at the pipeline value and the outstanding payments. One tells you about future sales and the other tells you whether past sales have become cash.

How often should sales reports be reviewed?

Weekly is a good rhythm for most SMEs, with a short daily look at new leads and overdue follow-ups by the sales head. Monthly reviews are useful for revenue by product, region and source.

What is the difference between a sales funnel and a sales pipeline report?

A funnel report shows how many leads move from one stage to the next and where they drop off. A pipeline report shows the open deals and their value at each stage right now.

Can I get sales reports without a CRM?

You can build some in Excel, but it takes manual effort and depends on everyone updating the sheet. A CRM produces them automatically from the work salespeople already record.

What is weighted pipeline value?

It is the value of open deals multiplied by the likelihood of closing at their stage. It gives a more realistic picture than simply adding up every open deal.

sales reportssales dashboardsales funnelbusiness ownerssales management

SM
SmartMorbi CRM Team

Keep reading

Related guides

Stop losing enquiries in WhatsApp chats and Excel sheets

Set up in a day. Import your existing leads from Excel and connect IndiaMART in minutes.