Percentage Analysis in Financial Reports - Feature Description
Overview
The Percentage Analysis in Financial Reports feature enables you to create common-size financial statements in Odoo, showing each line item as a percentage of total revenue. This powerful analytical tool helps you understand the proportional contribution of each expense, income, or asset item relative to your total revenue, making it easier to identify trends, compare periods, and make informed financial decisions.
What is Common-Size Analysis?
Common-size analysis (also known as vertical analysis) is a financial analysis technique that expresses each line item in a financial statement as a percentage of a base figure. For income statements, this base is typically total revenue. This approach allows you to identify trends by seeing how expense ratios change over time, compare your business metrics to industry benchmarks, spot anomalies by quickly identifying items that are out of proportion, and make informed decisions by understanding which expenses are consuming the most revenue.
Key Features
Flexible Configuration: Add percentage columns to any financial report (Profit & Loss, Balance Sheet, etc.). Configure percentages only for the lines you need. Works seamlessly with existing report structures.
Grouped Line Support: When you expand grouped sections (e.g., by account), each item automatically shows its percentage relative to the parent total. Perfect for detailed analysis of expense categories or income sources. Maintains accuracy even with complex report hierarchies.
Automatic Calculation: Percentages are calculated automatically based on your configured formulas. Updates dynamically as your financial data changes. Supports multiple column groups for period comparisons.
How to Enable the Feature
Navigate to Settings → Silverdale Extensions → Silverdale Inventory Extension. Locate the "Percentage Analysis in Financial Reports" option. Enable the checkbox and click Save. The feature is now active and ready to configure.
Configuration Guide
Step 1: Add the Percentage Column
Go to Accounting → Reporting → Financial Reports. Select the report you want to modify (e.g., Profit and Loss). Click on the Columns tab. Click "Add a line". Fill in the column details: Name: % (or any name you prefer), Expression Label: percentage, Figure Type: Percentage. Click Save.
Step 2: Configure Percentage Expression for Report Lines
In the same report, go to the Lines tab. Select the line item where you want to show percentages (e.g., Operating Income). Click on the line to edit it. In the Expressions section, click "Add a line". Configure the expression: Label: percentage, Computation Engine: Aggregate Other Formulas, Formula: Enter your percentage calculation formula.
Step 3: Understanding the Formula
The formula uses line codes to reference other report lines. Here's the syntax: (LINE_CODE.balance / BASE_LINE_CODE.balance) * 100
Example Formulas:
Operating Income as % of Total Income: (OPINC.balance / INC.balance) * 100 where OPINC is the code for Operating Income line and INC is the code for Income line.
Cost of Revenue as % of Operating Income: (COS.balance / OPINC.balance) * 100
Net Profit as % of Total Income: (NET.balance / INC.balance) * 100
Step 4: Working with Grouped Lines
If you have a line with Group By configured (e.g., account_id), the parent line will show its percentage based on your formula. When you expand the grouped section, each individual account will automatically show its percentage relative to the parent line's total. Important: The parent line must have a percentage expression configured for the expanded lines to show percentages.
Example: Operating Income (parent) has percentage expression: (OPINC.balance / INC.balance) * 100. When expanded, each account under Operating Income shows: (Account Balance / Total Operating Income) * 100
Real-World Example
Let's say you want to analyze your Profit & Loss statement. Your Total Income line has code: INC, your Operating Income line has code: OPINC and is grouped by account_id, and your Cost of Revenue line has code: COS.
For configuration, add percentage column in Columns tab. For Operating Income line, add percentage expression: (OPINC.balance / INC.balance) * 100. For Cost of Revenue line, add percentage expression: (COS.balance / OPINC.balance) * 100.
The result will show Operating Income as a percentage of Total Income (e.g., 95.2%), Cost of Revenue as a percentage of Operating Income (e.g., 65.8%), and when you expand Operating Income, each account shows its percentage of total Operating Income.
Best Practices
Use Descriptive Line Codes: Make your line codes meaningful (e.g., OPINC for Operating Income, COS for Cost of Sales).
Start with Key Metrics: Begin by adding percentages to your most important lines (Revenue, COGS, Operating Expenses).
Consistent Base: Use the same base line (typically Total Income) for income statement percentages to maintain consistency.
Document Your Formulas: Keep a record of your formulas for future reference and training.
Test Before Production: Configure and test on a copy of your report before using in production.
Troubleshooting
Q: Percentages show as 0.0% for expanded grouped lines
Solution: Ensure the parent line has a percentage expression configured.
Q: Percentage column doesn't appear
Solution: Verify that you've added the percentage column in the Columns tab and that the feature is enabled in settings.
Q: Formula errors
Solution: Check that line codes in your formula match the actual codes defined in your report lines.
Q: Percentage shows incorrect values
Solution: Verify your formula syntax and ensure the base line (denominator) has a value.
Benefits
This feature provides better financial analysis by quickly identifying which expenses are consuming the most revenue. It helps with trend identification by spotting changes in expense ratios over time. You can benchmark your ratios against industry standards and make informed decisions based on proportional analysis. The automatic calculation eliminates manual percentage computations, saving valuable time.
Use Cases
Expense Management: Identify which expense categories are growing faster than revenue.
Profitability Analysis: Understand the contribution margin of different income sources.
Budget Planning: Use historical percentages to forecast future expenses.
Performance Monitoring: Track key ratios month-over-month or year-over-year.
Management Reporting: Present financial data in an easy-to-understand percentage format.
This feature transforms your financial reports from simple number displays into powerful analytical tools, helping you gain deeper insights into your business performance.
Percentage Analysis in Financial Reports