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:
Product | Invoiced Qty | Delivered Qty | Invoiced amount | Cost of goods/services sold | Margin |
Chair | 10 | 10 | 100 | 80 | 20 |
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.
I haven't.. but following in case you get an answer.
I've been making painful manual reports for awhile now..