This report shows profit and additional financial summary for sales. Use this report to see an overview of the amount invoiced, paid, COGS, profit, markup, gross margin and FX gains/losses per order or per customer for a selected reporting period. The output does not show product details.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allows the user to select the time period from a list of options or set a custom date range.|
|Show COGS||Choose whether COGS are calculated from COGS with the selected time period only or all COGS on the record.|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving a layout for potential future use.|
|Reset Layout||Resets the layout to the default layout or selected saved layout.|
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
The following output fields are available for this report. You may have to open the More Fields dropdown menu to add some of them to your report.
|Order #||Sale Order number identifying the sale|
|Invoice #||Invoice number identifying the sale invoice|
|Invoice Date||Invoice authorisation date|
|Credit Note #||Credit note number if applicable|
|Credit Note Date||Credit note authorisation date if applicable|
|Sales Representative||Name of the sales representative associated with the sale|
|Due||Payment amount due (Invoice - Paid)|
|Due Date||Date when the invoice is due for payment|
|Customer Tags||Comma-separated customer tags|
|Customer Additional Attribute 1-10||Values of customer additional attributes|
|Shipment Date||Date of the shipment|
|Shipping Address 1||Shipment address line 1|
|City||Shipment address city|
|State||Shipment address state|
|Country||Shipment address country|
|Postcode||Shipment address postcode|
|Ship By||Required by date from the sale document header|
|Ordered||Total of the sale order including tax in base currency|
|Sale||Total of the sale order excluding tax in base currency|
|Invoice||Total of invoice - Total of credit note including tax in base currency|
|Paid||Total Paid - Total Refunded in base currency|
|COGS||Cost of Goods Sold in base currency|
|Journals||Total of all Additional Transactions associated with the sale in base currency|
|Profit||Profit = Sale - COGS (in base currency)|
|Profit less Journals||Profit - Journals in base currency|
|Gross Margin||Gross Margin = (Sale - COGS) * 100 / Sale. In base currency. If Sale or COGS is 0 it will show as N/A.|
|Markup||Markup = Gross Margin / (1 - Gross Margin). In base currency. If Sale or COGS is 0 it will show as N/A.|
|FX Gain/Loss||Foreign Exchange gains and losses|
NOTE: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.