Hello, 

There are 2 margin calculations in Odoo: 

Margins calculated from orders are calculated as: 

Products

income - cost of goods sold = margin

Services

income - cost of service = margin

This report takes into account the cost (at delivery or invoice) based on your product category setup (Standard, Average etc) and could be matched with GL/accounting as reporting can also show invoiced amount: 

However, since the report is based on orders, the filtering options provide only order date and not invoice date, making it impossible to match with GL. 

Margin analysis in Accounting is calculated from invoices (for income) and purchases (for expense) but this is a trivial approach to the matter as cost of good/services sold is recognised at the delivery of goods or invoice (Anglo-Saxon vs Continental). 

Has anybody figured out a way on how to match product margin report with P&L/accounting? Example: 

Profit and loss statement: 

Income - 100 

COGS - 80

—————

Gross margin - 20

Margin report: 

I was advised by Odoo support to use Spreadsheets but no further details on how to make the report (and there is no official documentation on Spreadsheets). 

Thank you very much.