Difference between revisions of "Template Sales/en"
(Importing a new version from external source) |
(Updating to match new version of source page) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
| − | + | 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. | |
If you do not have all the available data, leave the corresponding columns blank. | If you do not have all the available data, leave the corresponding columns blank. | ||
| + | |||
| + | |||
| + | [[Special:FilePath/Sales.xlsx|Download Sample Worksheet]] | ||
| Line 39: | Line 42: | ||
| − | + | Analysis: | |
* '''Annual Sales Informations''' | * '''Annual Sales Informations''' | ||
| Line 47: | Line 50: | ||
* '''Annual Information (Top 10)''' | * '''Annual Information (Top 10)''' | ||
[[File:annual_information.PNG|link=]] | [[File:annual_information.PNG|link=]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| Line 79: | Line 78: | ||
* '''State Analysis''' | * '''State Analysis''' | ||
[[File:state_analysis.PNG|link=]] | [[File:state_analysis.PNG|link=]] | ||
| + | |||
| + | |||
| + | * '''Annual Products Comparison''' | ||
| + | [[File:annual_products_comparison.PNG|link=]] | ||
| + | |||
| + | |||
| + | * '''Customer Ranking''' | ||
| + | [[File:customer_ranking.PNG|link=]] | ||
| + | |||
| + | |||
| + | * '''Orders Monthly Analysis''' | ||
| + | [[File:orders_monthly_analysis.PNG|link=]] | ||
Latest revision as of 02:28, 5 October 2022
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.
Download the example worksheet, using the link below, replace with your data and update the datasource to start analyzing immediately and improve the management of your business.
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 Information (Top 10)
- Product by Customer Analysis
- Product Sales
- Sales by Region
- Sales by Salesman
- Sales by State/Salesman/Product
- Sales Summary
- State Analysis
- Annual Products Comparison
- Customer Ranking
- Orders Monthly Analysis
