Sales report template in Google Sheets

by Sep 17, 2019

Sales is a dynamic, high pressure and fast-paced line of work—and when you’re busy selling all day, there’s little time to sit down and analyze your sales processes and results. But ploughing ahead without analysis and reporting could cost you growth in the long term. Regular, accurate sales reporting is essential to create forecasts and spot trends.

A good sales reporting system also helps you to identify:

  • Which products or services are selling well
  • Where people are buying your product
  • Potential bottlenecks in the sales funnel
  • The status of your leads
  • The value of your contracts

There is a huge range of specialist sales software available to help you track and monitor sales, but for startups and SMEs, expensive software might be an unwise and unnecessary investment. Instead, it’s often better to focus your resources on getting new leads, clients and selling your product or service.

When you’re just starting out with a new business or project, planning and designing a good sales process is the first step. If you want to launch an online sales business, take the time to research the sector before your start. Check out free online resources. Dropshipping app Oberlo has a helpful guide to selling online and other tips for new e-commerce entrepreneurs.

How can I create sales reports?

Rather than investing in expensive sales software, you can create a sales report system using the everyday tool you already know and use: spreadsheets.

To make it even easier for you to get started, we’ve created a free, ready-to-use sales report template in Google Sheets so you can:

  • Track all your sales department functions—in one place
  • Monitor all leads, clients, and contracts
  • View key metrics, such as best-selling services, in a visual dashboard

All in one spreadsheet.

What do I need?

We’ve created the template for you in Google Sheets, so all you need is a Google Account. It’s completely free.

Using this standalone template, you just enter the data and our spreadsheet does the work. Easy. We’ve written the formulas for you.

  • Free Sheetgo standalone Sales Report Template
  • No need for special software
  • Easy to use—in Google Sheets

To get a copy of the template, just click on the green button below:

How to use the sales lead tracking template

The template is saved to your Google Drive and it opens automatically. Now you just need to start entering your data. There’s an Instructions tab in the spreadsheet but we’ll cover the steps here too.

Step 1:

First, go to the green Leads tab. Here you need to fill out all information on your leads (just replace the dummy data we have provided as an example). Remember to assign each lead to the sale rep responsible (in the last column).

Step 2:

Enter your data in the following tabs: Clients and Contracts.

Step 3:

Check out your dashboard to view: leads per stage, top 10 clients per value, contracts per month, contracts per US state density and best-selling services.

Step 4:

If you want to customize this template to analyze different information and display alternative charts, just go to the hidden (Data Processing) tabs and make changes there. You can then create or modify the existing charts in the dashboard, based on the new information in the Data Processing tabs.

Congrats!

You’ve now got a centralized sales report system in Google Sheets. 

Get an at-a-glance overview of your sales progress in the dashboard tab:

Running a large and busy sales department?

Is someone else in your team responsible for overseeing sales leads, clients or contracts? If you have a big sales team, you might prefer to delegate tasks and give colleagues their own individual spreadsheets.

This can be a simpler system for staff, and there are data protection and privacy advantages when contact information is separated. Perhaps it’s only the sales manager who needs to have a complete overview of all sales leads, clients and contracts.

Spreadsheets are a brilliant, universal solution for tracking sales data but they do rely on time-consuming manual work and copy/pasting can lead to errors. Having a lot of “hands” touching the same spreadsheet can be problematic.

Want to use separate spreadsheets for your sales reporting system? We can help.

Sheetgo can connect your colleagues’ spreadsheets to your own master sheet. Each individual updates their own spreadsheet and you can view all the results—in one place. And the best part? The data flows automatically.

Sales Report Template Diagram

Connect spreadsheets with Sheetgo

If you are familiar with spreadsheets, you can use Sheetgo to automate sales reporting in your company. This means you can:

  • Separate and streamline data flows—individual colleagues or departments handle their own spreadsheet
  • Data is sent to your master spreadsheet automatically
  • Schedule updates when you want them
  • Create a simple and organized sales tracking system

Interested in more sales templates that help you automate the entire process? Take a look at this blog post about our Sales lead tracker template.

Share This