{"id":15305,"date":"2020-11-05T10:24:00","date_gmt":"2020-11-05T09:24:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=15305"},"modified":"2020-11-05T10:24:00","modified_gmt":"2020-11-05T09:24:00","slug":"modele-de-rapport-de-vente-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/sales-templates\/sales-report-template-in-google-sheets\/","title":{"rendered":"Mod\u00e8le de rapport de ventes dans Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;54px|0px|2px|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Sales is a dynamic, high pressure, and fast-paced line of work. This means that when you&#8217;re busy chasing leads all day, there&#8217;s not much time to sit down and analyze your sales processes and results. But plowing ahead without proper analysis and reporting could cost you growth in the long term. Regular and accurate sales reporting is essential for creating forecasts and spotting trends.<\/p>\n<p>A good sales reporting system can help you monitor leads, identify potential bottlenecks in the sales funnel, and track which products or services are selling well.<\/p>\n<p>When you&#8217;re just starting out with a new business or project, planning and designing a smart sales process is the first step. If you want to launch an online business, take the time to research the sector before you start. Check out free online resources such as dropshipping app <a href=\"https:\/\/www.oberlo.com\/blog\/sales-process\" target=\"_blank\" rel=\"noopener noreferrer\">Oberlo<\/a>, which offers a helpful guide to selling online and other tips for new e-commerce entrepreneurs.<\/p>\n<p>There\u2019s a huge range of specialist sales software available to help you monitor sales. But for startups and SMEs, expensive software can be an unwise and unnecessary investment. Instead, it&#8217;s often better to focus your resources on getting new clients and selling your product or service.<\/p>\n<p>You can create an automated sales reporting system with the tool you already know and use every day: spreadsheets. Here&#8217;s how to get started with a sales report template in Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Why use Google Sheets to create sales reports?<\/h3>\n<ul>\n<li>Flexible: Google Sheets enables you to manage and analyze all of your sales data in the way that suits your business. Whenever you need to change the system you can simply adapt the spreadsheets \u2014 without accounting software or IT support.<\/li>\n<li>Accessible: Since Google Sheets is cloud-based and updated in real time, your sales reps can access and transfer their data at any time, even if they\u2019re on the road or out of office. All you need is an internet connection and a phone or laptop.<\/li>\n<li>Compatible with everything: Every piece of software on the planet integrates with Google Sheets. This means that if your team has data stored in other programs, you can easily import that information straight into Google Sheets.<\/li>\n<li>Easy to use: The majority of your colleagues probably already use spreadsheets and Google Sheets\u2019 intuitive interface is quick to get to grips with. Spreadsheets are easy to maintain and onboarding your team is quick and simple.<\/li>\n<\/ul>\n<p><em>Get an overview of all your sales metrics including <strong>top 10 clients<\/strong>, the <strong>number of closed contracts per month<\/strong>, <strong>sales leads at each stage of the funnel<\/strong>, and your <strong>best-selling products or services\u00a0\u2014 <\/strong>all in the automated dashboard.<\/em>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Sales-report-template-1.png&#8221; alt=&#8221;sales-report-dashboard&#8221; title_text=&#8221;Sales report template 1&#8243; _builder_version=&#8221;4.22.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.21.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to get started<\/h3>\n<p>This Google Sheets template allows you to pull together real-time sales data from your team. The template merges sales data from different tabs to generate automated reports on all your leads, clients, and contracts.<\/p>\n<p>The template can be used by sales teams of any size, selling any product or service. It provides your reps and account managers with a user-friendly way to record and share sales data. At the same time, it generates automated reports and dashboards.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.23.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>What you get with this template:<\/h3>\n<p>When you get a copy of the Sheetgo Sales Report template, a Google Sheets file is saved to your Google Drive. This file contains the following tabs: Instructions, Dashboard, Leads, Clients, and Contracts.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.23.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to get the Sales Report template<\/h3>\n<p><a href=\"https:\/\/app.sheetgo.com\/templates\/sales-report\" target=\"_blank\" rel=\"noopener\">Install free template by clicking here<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.21.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use the service sales report template<\/h3>\n<h4>Step 1: Check out the input tabs<\/h4>\n<p>Open one of the input tabs (Contracts, Clients, or Leads) and you will see that this worksheet contains sample data. This is to show you how the template works, so you (or your colleague) can simply delete or overwrite this information.<\/p>\n<p>In the input tabs (Contracts, Clients, or Leads) you can start entering data.<\/p>\n<p>In the designated <strong>Leads<\/strong> spreadsheet, you can enter and update their current leads. In each column you enter contact details, the funnel stage, and notes.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Sales-report-template-2.png&#8221; alt=&#8221;sales-report-enter-leads-data&#8221; title_text=&#8221;Sales report template 2&#8243; _builder_version=&#8221;4.21.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.21.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Whenever your colleagues sign a new client, you should log all the contact\u2019s details here in the <strong>Clients<\/strong> tab.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Sales-report-template-3.png&#8221; alt=&#8221;sales-report-clients-sheet-client-tab&#8221; title_text=&#8221;Sales report template 3&#8243; _builder_version=&#8221;4.21.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.21.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>In the <strong>Contracts<\/strong> tab, you should log every new contract that is signed.<\/p>\n<p>Here you can register the company, the service or product, the deal value, an estimated duration for the project, and a link to the contract PDF.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Sales-report-template-4.png&#8221; alt=&#8221;sales-report-contracts-sheet-contracts&#8221; title_text=&#8221;Sales report template 4&#8243; _builder_version=&#8221;4.21.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Sign up for Sheetgo and start analyzing your <span style=\"background-color: rgba(41,121,255,0.2);\"><span>sales data<\/span><\/span> automatically<\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/sales-report&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.21.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 2: Check the dashboard<\/h4>\n<p>The template will automatically generate a dashboard. With the dashboard, you can get a comprehensive report with the top 10 clients, contracts per month, leads per stage, contracts per state, and best selling services.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/Sales-report-template-1.png&#8221; alt=&#8221;sales-report-contracts-sheet-contracts&#8221; title_text=&#8221;Sales report template 1&#8243; _builder_version=&#8221;4.21.2&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Start analyzing your <span style=\"background-color: rgba(41,121,255,0.2);\"><span>sales data<\/span><\/span> automatically<\/h3>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/sales-report&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sales is a dynamic, high pressure, and fast-paced line of work. This means that when you&#8217;re busy chasing leads all day, there&#8217;s not much time to sit down and analyze your sales processes and results. But plowing ahead without proper analysis and reporting could cost you growth in the long term. Regular and accurate sales [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":43911,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[62],"tags":[61],"class_list":["post-15305","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sales-templates","tag-sales"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/15305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=15305"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/15305\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/43911"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=15305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=15305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=15305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}