This report shows profit and additional financial summary for sales. Services, gift cards and non-inventory products are not included on the report. Use this report to see an overview of amount invoiced, paid, COGS, profit, markup, gross margin and FX gains/losses per order or per customer. The output does not show product details.
NOTE: Products with Type = Service, Gift Cards, or Non-Inventory are not included in this report.
Data from this report can be exported in Excel, PDF or RTF format.
|Time Period||Allow user to select the time period from a list of options are set custom a custom date range.|
|Show COGS||Choose whether COGS are calculated from only COGS with the selected time period or all COGS on record.|
|Layout||Set to the Default layout. Allows selection of saved layouts, if any.|
|Save Layout As||Allows saving of a layout for potential future use.|
|Reset Layout||Resets 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 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 sales representative associated with the sale|
|Due||Payment amount due (Invoice - Paid)|
|Due Date||Date when 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 sale document header|
|Ordered||Total of sale order including tax in base currency|
|Sale||Total of 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.