Gross Profit report lists all the sales documents (invoices, consignee reports) with item sales totals, item quantities, costs, and profitability (%).
VAT amounts are excluded from calculation if the Exclude VAT from Revenue option is selected on the Administration > Settings > General Settings.
The Report is located Sales > Reports > Gross Profit:
By default, the report has groupping by Items and Documents, other grouping like Characteristics or Batches can be applied as well:
The report is generated based on the Sales Register.
If the Document has the records in Sales Register, then it will appear in the report.
You can check the document's registers on button DR-CR at the header part of the workspace:
The explanation of the formulas and the documents that are included in the report generation are in as following:
| Column | Description |
|---|---|
| Item | All items (Inventory and Services) that have been sold during the selected period |
| Quantity | Quantity of the items sold |
| Document | All documents related to Sales (Sales Invoices, Consignee Reports, Goods Returns etc.) entered during the selected period. |
| Amount | Total Due Amount (Including VAT) from the document |
| Cost Price | Inventory Items' cost price for the selected period. The cost price is calculated automatically on the date and time of document posting later on it is corrected by the system of linear equations method on the Month–End Closing Process. |
| Gross Profit | Gross Profit is calculated by formula: Gross Profit = Amount (excluding VAT if Exclude VAT from Revenue option is enabled) - Cost Price. |
| Profitability | Profitability is calculated by formula: Profitability = Gross Profit / Amount (excluding VAT if Exclude VAT from Revenue option is enabled) * 100 |