This report shows the profits made per product within the specified period of time. It uses inventory movements to record sales proceeds from invoices related to fulfilment. It will include sales invoices regardless of date as long as the ship date falls within the specified date range. Use this report to see detailed financial information such as COGS, sale proceeds, amounts for non-sale operations (transfers, assembly, etc.) and profit.
Users need the Financial Reporting permission to access this report.
Prerequisite:
Table of Contents
Data from this report can be exported in Excel, PDF or RTF format.
Input:
| Reporting Period | Allow user to select the reporting period from a list of options or set a custom date range. This report is filtered by ship tab authorisation date. Orders that have not been shipped will not show in the report. |
| 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. |
NOTE: COGS transactions are generated by DEAR when the ship tab is authorised for a sale. As dropship products do not have a ship tab, COGS for dropship products are generated when the purchase invoice for the products are authorised. COGS will show as 0 until the purchase invoice is authorised.
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.
Output:
The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.
| Fields | |
| Location | Location name |
| SKU | Product SKU |
| Product | The name of the product |
| Unit | Product unit of measure |
| Tags | Comma-separated product tags |
| Category | Product category |
| Brand | Product brand |
| Family | Product family name |
| Batch # | Batch or Serial number if applicable |
| Expiry Date | Batch Expiry Date if applicable |
| Year | Year of stock movement date |
| Quarter | Quarter of stock movement date |
| Month | Month of stock movement date |
| Product Additional Attribute 1-10 | Values of product additional attributes |
| Data Headers | |
| COGS | Total cost of goods sold amount |
| Sale Proceeds | Sale proceeds for the product |
| Production / Inventory / Transfer | Cost of the product spent on non-sale transactions |
| Profit | Profit = "Sale Proceeds" - "COGS" |
NOTE: If you have added an Additional Attribute set to your sale process, the attributes will appear as additional report fields.
FAQs
I am getting different Sale values from my Profit & Loss Report, Sale Profit Summary, and Profit & Loss Report. What is happening?
The source of data and conditions are different in these reports. Profit & Loss By Product report uses inventory movements where we record sales proceeds from invoice related to fulfillment. In the Profit and Loss report, source of data is financial transactions, so it will include sales that are not yet fulfilled. So it's not expected that these will exactly match. First is product level report, second is financial report.
I need to understand better the Profit & Loss by Product Report and need some assistance/ explanation please. What is actually happening in the Production/Inventory/Transfer column? What has to happen to create values here? Does the report reflect if goods were sold within the date range but purchased prior to the date range?
The Production/Inventory/Transfer columns will show cost for products that have been used in an assembly, issue to production or during a stock transfer between warehouses, so this column shows costs due to non sale related transactions.The profit will still be reflected in this report even if the purchase date of the good falls outside the date range.
Will this report show every purchase - ie COGS of every product during the time period regardless of whether it has been sold ?
The report will only show COGS for products that were sold (ship tab authorised) in the selected reporting period.
Why does Profit and Loss by Product not reconcile with the Profit/Loss being shown in DEAR balance sheet?
The numbers won't match due to the additional charges. For example if you charge customers for freight - these won't be included on the profit & loss by product. Additional charges on purchases also will be excluded unless they are added as a landed cost to the items purchased.
Why are figures different between Sales by Product Details and Profit and Loss by Product Report?
These figures are not supposed to match, because the source and conditions for them are different.
In Sales by product details, the source is invoice, and data is filtered by invoice date.
In Profit and loss by product, source is stock movements, and date of sale proceeds will match Shipment date if it is greater than invoice date.
Still no answer to your question? Please do not hesitate to get in touch with DEAR support.