Profit & Loss By Product Report

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.

Prerequisites

Managing Cin7 Core Reports

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 authorization 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 Cin7 Core when the ship tab is authorized 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 authorized. COGS will show as 0 until the purchase invoice is authorized.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core 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 authorized) in the selected reporting period.

Why does Profit and Loss by Product not reconcile with the Profit/Loss being shown in Cin7 Core 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 Cin7 Core support.

Profit & Loss By Product Report

Profit & Loss By Product Report

Prerequisites

Input:

Output:

FAQs

Was this article helpful?

Thank you for the positive feedback! Could you please share what was most helpful?

Sorry that this wasn't helpful! Can you tell us more?