Difference between revisions of "Template Sales"

From TaticView
Jump to: navigation, search
Line 16: Line 16:
 
<!--T:5-->
 
<!--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.
 
[[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
 +
  
  
Line 71: Line 98:
 
[[File:state_analysis.PNG|link=]]
 
[[File:state_analysis.PNG|link=]]
  
 
<!--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
 
  
 
</translate>
 
</translate>

Revision as of 17:49, 16 May 2017

Through the Sales Management template, you can have total control of your sales by Branch, Products, Customers, Salesperson and more.

Know your billing, taxes, costs and profit margin through the many management dashboards available.


Donwload the Sales Spreadsheet and replace it with your data to start analyzing immediately and improve your business management.

If you do not have all the available data, leave the corresponding columns blank.


Share your information with Affiliates and Sellers by displaying only relevant information to them, while you have full access to all information.


Sales Spreadsheet Information:


  • 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


Analysis:


  • Annual Sales Informations

Annual sales information.PNG


  • Annual Information (Top 10)

Annual information.PNG


  • Branch Analysis by Quarter

Branch analysis quarter.PNG


  • Product by Customer Analysis

Product customer analysis.PNG


  • Product Sales

Product sales.PNG


  • Sales by Region

Sales region.PNG


  • Sales by Salesman

Sales salesman.PNG


  • Sales by State/Salesman/Product

Sales state salesman product.PNG


  • Sales Summary

Sales sumary.PNG


  • State Analysis

State analysis.PNG