Teste<languages/> <translate><!--T:1-->Through the ''Sales Management'' template, you can have total control of your sales by Branch, Products, Customers, Salesperson and more. <!--T:2-->Know your billing, taxes, costs and profit margin through the many management dashboards available. <!--T:3-->Download the example worksheet, using the link below, replace with your data and update the [[Data Sources|datasource]] to start analyzing immediately and improve the management of your business. <!--T:4-->If you do not have all the available data, leave the corresponding columns blank. <!--T:22-->[[Special:FilePath/Sales.xlsx|Download Sample Worksheet]] <!--T:5-->[[Share dashboards|Share]] your information with ''Affiliates'' and ''Sellers'' by displaying only relevant information to them, while you have full access to all information. <!--T:7-->Sales Spreadsheet Information: <!--T:8-->* '''Order Date''': Date on which the sale was made* '''Delivery Date''': Date on which the order was delivered* '''Branch''': Affiliate which performed the sale* '''Group''': Group to which belongs the sold product* '''Product''': Name of the sold product* '''Customer''': Customer name* '''City''': City where the customer lives* '''State''': State where the customer lives* '''Region''': The region of the country where the customer lives* '''Salesman''': Name of the salesperson who performed the sale* '''Quantity''': Quantity sold of a product* '''Price''': The price of the sold product* '''Taxes''': The amount of taxes levied on the product sale* '''Net Revenue''': The net value of the product sale* '''Cost''': The value of the product purchase cost* '''Profit''': Profit obtained from the product sale* '''Avg Price''': The result of the price estimate divided by the quantity* '''%Profit''': Percentage of profit on the product selling price <!--T:6-->Analysis: <!--T:9-->* '''Annual Sales Informations'''[[File:annual_sales_information.PNG|link=]] <!--T:10-->* '''Annual Information (Top 10)'''[[File:annual_information.PNG|link=]] <!--T:12-->* '''Product by Customer Analysis'''[[File:product_customer_analysis.PNG|link=]] <!--T:13-->* '''Product Sales'''[[File:product_sales.PNG|link=]] <!--T:14-->* '''Sales by Region'''[[File:sales_region.PNG|link=]] <!--T:15-->* '''Sales by Salesman'''[[File:sales_salesman.PNG|link=]] <!--T:16-->* '''Sales by State/Salesman/Product'''[[File:sales_state_salesman_product.PNG|link=]] <!--T:17-->* '''Sales Summary'''[[File:sales_sumary.PNG|link=]] <!--T:18-->* '''State Analysis'''[[File:state_analysis.PNG|link=]] <!--T:19-->* '''Annual Products Comparison'''[[File:annual_products_comparison.PNG|link=]] <!--T:20-->* '''Customer Ranking'''[[File:customer_ranking.PNG|link=]] <!--T:21-->* '''Orders Monthly Analysis'''[[File:orders_monthly_analysis.PNG|link=]] </translate>
