When entering quotations, pro formas and sales orders, you can view the sales profit for the whole order and for each order line.
Note: Profitability is calculated on a line by line basis. For this reason, profitability figures reflect line discounts, but not order or invoice discounts.
Two profit values are calculated for sales orders; estimated and realised. On quotations and pro formas invoices, you can only view the estimated profit. On sales orders you can view the estimated and realised profit.
Estimated profits are calculated when a sales order, quotation, or pro forma is entered.
The following cost prices are used to calculate estimated profit:
The current cost price of an item is used to calculate realised profit. This cost price depends on the costing methodThe costing method is used to calulate the cost of sales of your stock items, the value of stock, and the transactions posted to your stock nominal accounts. There are four available costin methods. The costing method is specified for each product group. used for each item.
Realised profits are calculated either when the goods are despatched, or when the invoice is posted. This depends on the options you have chosen in the SOP settings.
Note: Returns and credit notes are not included on sales order or invoice profitability reports.
The profit percentage is calculated using:
Sales profit can be calculated as a percentage of revenue or as a percentage of cost. This depends on the options you have chosen in the Stock Control settings.
If you have chosen:
Calculate as percentage of revenue.
The profit percentage is calculated in the following way:
100 * (issue value - cost value) / (issue value).
Calculate as percentage of cost.
The profit percentage is calculated in the following way:
100 * (issue value - cost value) / (cost value).
|
Estimated profit. |
This is calculated when quotations and pro forma invoices are entered.
|
|
Realised profit. |
This is not calculated for quotations and pro forma invoices. |
| Estimated profit |
This is calculated when sales orders are entered. |
| Realised Profit |
The realised profit is calculated when the sales order is entered for certain types of stock item:
Note: The confirmation of despatch for |Service / Labour and Free Text items is set in the Stock Settings. |
| Realised Profit |
This depends on the options you have selected in the SOP settings. If you have chosen:
|
| Realised Profit |
This depends on the options you have selected in the SOP settings. If you have chosen:
|
| Realised profit |
This depends on the options you have selected in the SOP settings. If you have chosen:
|
| Realised profit |
For sales orders where the cost of the goods is not known, the realised profit is adjusted when stock is added into Sage 200 with a confirmed price. |