Sales KPIs and Sales Reports: What to Measure, How to Calculate It and How to Automate Reporting

Short answer: Sales KPIs and sales reports should answer two questions for a manager: are we hitting the plan, and if not, where in the funnel is the money leaking? Five to seven core KPIs are usually enough: plan vs actual, conversion rate, average deal size, sales cycle length, activity (calls, meetings) and accounts receivable. Reports are most reliable when they are generated automatically from a CRM or ERP instead of being assembled by hand in Excel.

In many companies, sales KPIs and sales reports live in spreadsheets: at month end every rep sends a file, someone merges them, the totals do not match accounting, and the owner sees the result around the 10th of the next month, too late to fix anything. Bonuses are paid on revenue alone, so reps hit targets with discounts and credit shipments. This guide covers which KPIs you need, how to calculate them, report templates, commission schemes and how to automate reporting.

What is a sales KPI and how is it different from a regular metric?

A KPI (Key Performance Indicator) is a core measure that directly affects the sales team's goal and has a clear formula, a target value and an owner. "We sent 12 messages today" is just a metric until it has a goal, a target and an owner.

It helps to split KPIs into two groups:

• Lagging indicators (results): revenue, plan attainment, margin, number of closed deals. They tell you what already happened.
• Leading indicators (process): calls, meetings, proposals sent, first response time. They predict results, and a rep can influence them today.

A good system combines both: results alone surface problems too late, activity alone rewards busywork.

Which KPIs matter for a sales team?

Sales KPIs are chosen across four areas: financial results, funnel efficiency, activity and customer base quality. The most common, with formulas:

Financial results

• Plan attainment (plan vs actual): actual sales / target × 100%. For example, a target of 500 million sum and actual sales of 430 million sum mean 86% attainment.
• Revenue: the value of shipped or paid sales in the period. Agree in advance which one counts (more on this below).
• Gross margin: (selling price − cost) / selling price. When discounts are common, this matters more than revenue.
• Average deal size: revenue / number of deals.

Funnel efficiency

• Lead-to-sale conversion rate: won deals / total leads × 100%.
• Stage-by-stage conversion: for example, from "proposal sent" to "paid". This is what shows you where the funnel leaks. More on building a funnel: What a sales funnel is and how to build one.
• Sales cycle length: average number of days from first contact to payment.
• Loss reasons: price, timing, competitor, no response. A deal closed without a reason is useless for analysis.

Activity

• Number and duration of calls: outgoing and incoming, answered and missed.
• First response time: the time between a lead arriving and a rep making contact. A Telegram lead left waiting for hours often buys elsewhere.
• Meetings, demos and proposals sent.
• Overdue tasks: calls and reminders scheduled in the CRM that were not done.

Customer base quality

• Repeat revenue share: revenue from existing customers / total revenue.
• Accounts receivable and overdue debt: critical in wholesale, because goods shipped on credit are not money yet.
• Active customers: customers who bought in the last 30, 60 or 90 days.

How do you calculate conversion rate, average deal size and sales cycle? An example

The formulas are simple; what matters is that data comes from one source and is calculated with the same rules every month. Here is a hypothetical example (the numbers are made up and only illustrate the method).

A building materials distributor received 400 leads in a month: 220 via Telegram, 120 phone calls and 60 website form submissions.

1. Reps contacted 320 leads. Contact rate: 320 / 400 = 80%.
2. Proposals went to 150 customers: 150 / 320 ≈ 47%.
3. 60 deals were won. Overall conversion: 60 / 400 = 15%; proposal to payment: 60 / 150 = 40%.
4. Revenue was 540 million sum. Average deal size: 540 / 60 = 9 million sum.
5. Won deals took an average of 12 days from first contact to payment. That is the sales cycle.

The takeaway: 80 leads were never contacted. At 15% conversion that is roughly 12 lost deals, so fix lead handling before buying more ads. Calculate conversion by channel too: Telegram may bring volume while website leads convert better.

How do you choose KPIs for a sales rep?

Three to five KPIs per rep are enough; they should match the rep's role and measure what the rep can actually influence.

Choosing by role:

• Hunter (new business): new customers won, lead-to-sale conversion, meetings held, revenue from new customers.
• Farmer (account management): plan attainment, repeat revenue, average deal size growth, receivables.
• Inbound lead handler: first response time, missed call rate, conversion to qualified lead.
• Head of sales: team plan attainment, margin, sales cycle length, ramp-up time for new reps.

Practical rules:

1. Write down the formula and data source for every KPI. Everyone must mean the same thing by "conversion".
2. Make targets realistic. Base them on past periods, seasonality and the current pipeline.
3. Reps should see their numbers daily, not at month end.
4. KPIs should not work against each other. A bonus on revenue alone eats margin, so balance it with a margin KPI or a discount limit.

Which sales reports do you need? Templates

Sales reports fall into three levels by frequency: daily (operational control), weekly (pipeline review) and monthly (results and compensation). Adapt these templates to your business.

Daily sales report (for reps and the manager)

• new leads and their source (Telegram, Instagram, phone, website);
• unanswered leads and first response time;
• number of calls and missed calls;
• today's payments and shipments;
• list of overdue tasks.

Weekly pipeline report

• number and value of deals at each stage;
• stage conversion compared with the previous week;
• deals stuck in one stage for too long;
• lost deals and their reasons;
• next week's forecast: which deals are expected to close.

Monthly sales report

• plan vs actual by company, team, rep and product group;
• revenue, margin, average deal size, number of deals;
• leads and conversion by channel;
• share of new and repeat customers;
• accounts receivable, including overdue;
• KPI attainment and calculated bonus for each rep.

The monthly report must reconcile with accounting, or nobody will trust it. See also Management accounting: a guide for business owners.

How do you build a KPI-based commission scheme?

The most common and easiest to understand scheme is a fixed base salary plus a bonus tied to KPI attainment; the bonus share depends on how much the role drives results. Options you will see in practice:

• Percentage of sales: the simplest scheme. Downside: reps push volume even at the cost of discounts.
• Percentage of margin: protects company profit, but reps need to see cost and margin must be calculated correctly.
• Plan attainment multiplier: for example, no bonus below 70% attainment, a proportional bonus between 70% and 100%, and an accelerator above 100%.
• Weighted KPI matrix: the bonus is made up of several KPIs, such as plan attainment weighted 60%, margin 20% and receivables 20%. Each KPI contributes its share according to attainment.
• Team bonus: an extra payout for everyone when the team hits its target. It encourages collaboration but should sit alongside individual KPIs.

A key rule: calculate bonuses on payment received, not on shipment. Otherwise reps hit the plan by shipping on credit and the money never arrives. Count only amounts actually paid via Click, Payme, bank transfer or cash.

What mistakes do companies make with sales KPIs and sales reports?

The most expensive mistake is when nobody trusts the numbers in the reports; the usual cause is data kept manually in several places. Other typical mistakes:

1. Too many KPIs. A report with 12 indicators does not get read.
2. Measuring only revenue. Margin, debt and repeat business are ignored.
3. Reports prepared at month end. Problems are spotted too late to fix.
4. Calls are not tracked. Reps use personal phones, so activity can only be judged by what they say.
5. Loss reasons are not recorded. A deal is "closed", but nobody knows why it was lost.
6. Data entry is a burden. If a rep must fill in 15 fields per deal, data quality will be poor.
7. KPIs keep changing. If the rules change every month, reps stop trusting the system.

How do you automate sales reports?

Automating sales reports is not about Excel macros; it means every event (lead, call, deal, shipment, payment) lands in one system so nobody has to compile anything. Step by step:

1. Choose a single source of truth. Leads and deals in the CRM; shipments, stock and payments in the ERP. When they share one database, plan vs actual and margin reports need no manual reconciliation. More on CRM: What is a CRM system.
2. Define funnel stages and required fields. For example, a loss reason is mandatory when a deal is marked lost.
3. Connect every channel. Website forms, Telegram, Instagram and phone enquiries become leads automatically.
4. Track calls automatically. Through IP telephony or a dedicated solution for mobile phones. Details: No call center in your sales team? An ordinary phone will do.
5. Enter targets into the system. By rep, team and month, so plan vs actual is calculated in real time.
6. Set up dashboards and scheduled reports. The manager sees a ready report in the morning, and each rep sees their own numbers.
7. Reconcile during the first month. Compare revenue in the system with accounting and fix any gaps.

Still on Excel? See Moving from Excel to an ERP system and Business process automation: where to start.

How do sales reports and KPIs work in Odoo?

In Odoo, CRM, Sales, Inventory and Accounting share one database, so sales reports show the whole chain from lead to payment without manual consolidation. The main tools:

• Pipeline analysis: deals by stage, rep and source, expected revenue, won and lost deals and loss reasons.
• Activities analysis: calls, meetings, tasks and overdue items per rep.
• Sales analysis: revenue, quantities, products, customers and reps in pivot tables and charts, with export to Excel.
• Sales teams and targets: each team can have a monthly invoicing target, with progress visible in the interface.
• Gamification (Challenges): a standard module for setting goals and running competitions between reps.
• Commissions: Odoo 18 and later include commission plans in the Sales app based on targets and achievements (official documentation). Features vary by version and edition, so check them at the start of a project.
• Dashboards: management views with plan vs actual, margin and receivables on one screen.

Bonuses can be calculated on paid invoices, and Inventory shows what shipped but is unpaid. More: Odoo Sales and Purchase and Odoo CRM.

How can Deep Vision help?

Deep Vision is an official Odoo Gold Partner in Tashkent; we analyze your sales process, set up KPIs and reports in Odoo and connect call tracking.

• Process and KPI review: we map your funnel, data sources and commission scheme and define which KPIs can be automated.
• Odoo implementation: CRM, Sales, Inventory and Accounting, funnel stages, targets and dashboards. Our team has 7 certified specialists, and 26 of our client projects are listed in the Odoo partner directory (partner page).
• dooCall: turns an ordinary phone into a sales call-center tool, so calls are tracked and activity KPIs are based on facts rather than self-reporting.
• Timelines: standard Sales and Inventory modules often go live in 6–8 weeks; broader projects take 2–6 months.

Our clients include Optika.uz, Timsoll (7,000+ SKUs in Odoo) and RockBeton; more projects are in our portfolio. Learn more about Odoo implementation. If you want to see how your sales reporting could be automated, fill in a short brief.

Checklist: sales KPIs and reports

• Each rep has 3–5 KPIs with a written formula.
• Targets are entered in the system by rep, team and month.
• All leads (Telegram, Instagram, phone, website) flow into the CRM automatically.
• Calls are tracked automatically.
• A loss reason is mandatory.
• Daily, weekly and monthly reports are generated automatically.
• Revenue in the sales report matches accounting.
• Bonuses are calculated on payment, and reps can see them.
• The KPI system is reviewed at least once a quarter.

Frequently asked questions

Why do you need sales reports?

Sales reports show plan attainment, funnel problems and each rep's results. Managers use them to decide which channel to invest in, who needs coaching and which products to push harder.

How many KPIs should a sales rep have?

Three to five KPIs are usually enough. They should combine result indicators (plan attainment, margin) with process indicators (calls, conversion, response time). With more than that, reps lose focus.

How is sales conversion rate calculated?

Overall conversion is the number of won deals divided by the number of leads, multiplied by 100. For example, 60 sales from 400 leads is a 15% conversion rate. It is also useful to calculate conversion for each funnel stage.

Should bonuses be based on revenue or on payment?

Payment is safer. Bonuses on shipment push reps to sell on credit, and the company pays a bonus before receiving the money. This requires the CRM to be connected to accounting and payments.

Can you keep sales reports in Excel?

For a small team with few deals, yes. But once you have more reps and leads coming from several channels, Excel reports arrive late, errors multiply and the numbers stop matching accounting. That is the point to move to a CRM or ERP.

How do you automate sales reports?

Leads, calls, deals, shipments and payments must all be recorded in one system. Plan vs actual, conversion and margin reports then update on a dashboard automatically. In an ERP like Odoo this is easier because CRM and accounting share one database.

How can you measure activity if reps call from ordinary phones?

You need a solution that tracks calls automatically. For example, Deep Vision's dooCall turns an ordinary phone into a sales call-center tool and makes calls visible and measurable.

How long does it take to set up sales KPIs in Odoo?

If you already use Odoo, configuring reports and dashboards is relatively quick. For a new implementation, standard Sales and Inventory modules often go live in 6–8 weeks, and broader projects take 2–6 months.

Conclusion

Good sales reports give fast answers to the right questions: are we on plan, where is money leaking and what can each rep influence. Choose a few precise KPIs, tie bonuses to payment and bring all data into one system. Then the report stops being a file compiled at month end and becomes a daily management tool.

Let's design KPIs and reports for your sales team together: fill in a brief for a free consultation or call +998 77 093 00 07.