Card2Gold

How to Write a Sales Report: The 5 Numbers Your Manager Actually Wants

TL;DR

The sales report your manager wants isn't a diary of your week — it's 5 key numbers (new leads, pipeline by stage, forecasted revenue, sales-cycle length, overdue follow-ups) plus 1 concrete action plan.

Sales reports are one of the topics that resonate most — and draw the most complaints — whenever the Card2Gold team talks shop with salespeople. You were slammed all week: visited clients, worked up quotes, chased a few old accounts. But when Friday afternoon rolls around and you have to turn all that into a report, you stare at a blank document with no idea where to start, and end up writing a play-by-play diary — only to get a one-line reply from your manager: "So what's the point?" After years of leading sales teams and reading a mountain of reports, we've found the problem usually isn't that you're not working hard enough. It's that you're not tracking the numbers your manager actually cares about. This article walks through exactly which numbers those are.

You wrote a thousand words, and your manager just replied "So what's the point?"

The most common mistake salespeople make when writing a weekly or monthly report is turning it into a "work journal." Monday: visited a traditional-manufacturing client. Tuesday: called the purchasing lead at a tech firm. Wednesday: shipped samples. Thursday: worked on quotes at the office. This kind of blow-by-blow record does document your daily schedule in detail, and it proves you weren't slacking — but in your manager's eyes, it's a failing grade.

When a manager reads a sales report, what's on their mind isn't how busy you were. It's whether all that activity can be converted into revenue for the company. When the report is full of vague, subjective phrases like "the client said they'll think about it," "still following up," or "they felt the price was too high," the manager can't make any decision at all. They have no idea whether this deal will actually close next month, and no idea how much valuable opportunity is currently sitting in the team's pipeline.

This kind of information asymmetry often erodes the trust between salesperson and manager. The salesperson feels like they're out in the field grinding all day, then have to spend more time writing reports when they get back — and still don't get any understanding from the boss. The manager, meanwhile, feels like the rep is out running around all day but bringing back no useful market intelligence, writing pages of reports yet unable to say how much business will actually close next month.

To break the deadlock, salespeople have to learn to speak in data. A manager's time is precious; what they need are the key indicators that let them see the current state, forecast the future, and make a decision at a glance. When you shift the focus of your report from "what I did" to "current progress and how the numbers are changing," the value of that report changes completely.

Why traditional reporting always feels like twice the work for half the result

To produce a presentable report, salespeople try all sorts of methods — but the results often fall flat. The most common approach is to open a text document and manually stitch together the week's visit notes. This isn't just time-consuming; as the number of clients grows, the history becomes almost impossible to search, and no data analysis is possible at all.

Some companies ask reps to manage clients and revenue in an Excel spreadsheet. Excel does have basic tallying functions, but it relies heavily on manual entry. After a full day out in the field, the rep gets back to the office and faces a dense grid of cells, manually filling in client name, phone, visit date, estimated amount, and so on. That's not only error-prone; formulas often break from a single mis-keystroke. More importantly, Excel is static — it can't reflect the live movement of the pipeline in real time. Every time the manager wants the latest numbers, the rep has to rebuild the sheet again.

Some companies, chasing digital transformation, roll out a powerful CRM system. But these systems are often designed to be far too cumbersome. After every client visit, the rep has to fill in a dozen-plus required fields — from company background and industry classification to product needs and competitor analysis. The tedious workflow leaves reps grumbling. In the end, just to satisfy the company's performance review, reps fill in data carelessly, leaving the system full of garbage information and stripping away the very value data analysis was supposed to provide.

For small and medium-sized businesses — especially in markets like Taiwan — sales teams are usually small, and everyone has to wear multiple hats: developing new clients, maintaining old ones, even handling after-sales service and shipping. Under that intense pace, any reporting method that demands a lot of manual entry and cleanup eventually becomes an empty formality.

Reporting methodTime to prepareData accuracyManager satisfactionReal-world pain point
Text diary2-3 hoursLow, mostly subjectivePoor, misses the pointCan't forecast opportunities
Excel spreadsheet1-2 hoursMedium, formulas breakMedium, no live analysisVersion chaos, hard to maintain
Traditional CRM30 minutesHigh, but tedious entryMedium, low rep buy-inToo many fields breed resistance
Ideal automation5 minutesVery high, auto-compiledVery high, live & transparentNeeds the right tool + habit

Shift your thinking: speak in the 5 numbers your manager understands

A sales report that supports decisions should focus on the key data that reflects sales health and future revenue. Here are the 5 numbers your manager actually wants to see — and the business meaning behind each.

Number 1: New Leads

This number shows whether fresh water keeps flowing into the top of your sales funnel. If a sales team spends every day visiting existing clients but never adds a single new one, future revenue is heading for a cliff. In your report, spell out how many new leads you added this week — through trade shows, website inquiries, active outreach, and so on. This number lets your manager gauge the effectiveness of marketing campaigns and the intensity of your business development.

Number 2: Pipeline Stages

Clients pass through different stages on the way from first contact to closed deal — for example: first contact, needs confirmation, proposal & quote, contract negotiation, and closing. In your report, don't just write the total number of clients; clearly show how many sit in each stage. If most of your clients are stuck at "proposal & quote," your manager can immediately spot the bottleneck and provide resources to help you break through — instead of only reviewing it at month-end when the number falls short. For how to design these stages, see our sales pipeline design guide.

Number 3: Forecasted Revenue & Probability

This is the number your manager cares about most, because it ties directly to the company's cash-flow planning. Don't just write a vague revenue estimate — assign a reasonable probability of closing based on the client's current level of intent. For example, if Client A's purchase is NT$500,000 and they've already entered contract negotiation, you might estimate the close probability at 80%, which makes forecasted revenue NT$400,000. This kind of weighted calculation gives your manager a relatively precise forecast, rather than a gut-feel number pulled out of thin air.

Number 4: Sales Cycle Length

How many days, on average, does a deal take from first contact to signed contract? This number is critical for evaluating efficiency and forecasting revenue. If your average sales cycle is 90 days and you have a client you first contacted just two weeks ago, then no matter how keen they are, it's hard to include them in this month's forecast. Knowing this number helps you schedule your time and follow-up cadence more realistically.

Number 5: Overdue Follow-ups

In sales, the single most common way to lose an opportunity is simply "forgetting to follow up." Your manager wants to know whether you're maintaining clients according to plan. If the report shows many clients with no interaction logged for over two weeks, that's a warning sign — it means your energy may be spread too thin, or that some clients have slipped your mind entirely. Keeping this number low is the best way to demonstrate professionalism and execution (further reading: how to set your follow-up frequency).

Beyond these 5 key numbers, your report must end with "1 action plan." It doesn't need to be long-winded — just a concrete solution for next week that addresses the problems these numbers reveal. For example: "For the 3 clients currently stuck at the quote stage, I'll finish the spec adjustments and resubmit quotes by next Tuesday, which should lift close probability to 70%." A report like that — with data, analysis, and action — naturally earns your manager's trust.

Starting today, build professional trust with structured data

Writing a high-quality sales report comes down to accumulating data day by day. If you don't do the data collection along the way, come Friday afternoon you'll have no choice but to improvise from memory. So the first step is building a simple, effortless daily-logging habit.

First, learn to turn unstructured information into structured data. When you receive a client's card at a trade show, don't just toss it in a drawer — before the day ends, use a tool to digitize the card and immediately tag the contact with their industry, the product they need, and their expected purchase timing. A tool like Card2Gold can automate this flow, quickly converting paper into manageable digital data and saving you the hassle of manual entry.

Second, use Kanban-style thinking to track clients. Arrange your clients on a board by sales stage, and spend five minutes reviewing it before you leave each day: which clients need follow-up, which stages need updating. When your daily logging is solid enough, writing the report becomes trivial — you just open the board, total the numbers in each stage, and finish a clearly structured, data-rich professional report in ten minutes.

A sales report shouldn't be a chore to placate your manager. It's a tool you use to review your own effectiveness and win company resources. When you start replacing feelings with numbers and logic with excuses, you'll find you're no longer chased by your quota — you're in precise control of every opportunity. Next time you write a report, try setting aside the long work diary and showing your professional value with these 5 numbers and 1 action plan.

FAQ
Don't estimate close probability by feel — base it on objective facts. You can assign a fixed probability to each sales stage. For example: 10% when you've only sent a brochure, 40% once you've confirmed specs and provided a quote, 60% when the client actively requests samples or runs a trial, and 80% once you're into legal contract review. As long as the client hasn't advanced to the next concrete step, don't casually bump up the probability. Only then will your forecast carry real reference value.
A new rep's report should focus on "process metrics" rather than "outcome metrics." When you don't yet have much forecasted revenue, show your development progress instead. Emphasize new leads added, prospecting calls made, and actual visits completed. This lets your manager see your execution and drive, and proves you're working to feed new opportunities into the funnel — which makes managers more willing to offer guidance and resources.
The key is "log on the spot" and "keep the fields minimal." Don't try to recall every detail from memory at the end of the day — that costs far more time. Right after each visit, in the downtime while you're resting in the car, spend two minutes jotting down the essentials on your phone. Record only what matters most — the client's pain point, the next action, and the expected follow-up date — and skip the trivia that doesn't affect decisions. Lowering the friction is what makes the habit stick.
Make the change gradually. Keep your original narrative report, but put these 5 key numbers right at the top as a short data summary. Once your manager realizes they can grasp the whole picture in ten seconds from those numbers — without reading the long text below — they'll naturally come to prefer this efficient format, and may even ask other team members to follow suit.

Get started with Card2Gold — free

Scan cards, AI opportunity scoring, company background checks, CRM pipeline management

Try it free