Odoo Analytic Accounting
Multi-dimensional cost and revenue management by projects, departments, and cost centers
Analytic Accounting is a multi-dimensional cost and revenue management system in Odoo that enables detailed tracking by projects, departments, cost centers, or any analytical dimension you need.
Automatically distribute costs from customer invoices, vendor bills, and employee expenses to analytic accounts with intelligent distribution models. Support concurrent multi-dimensional analysis with visual reports through graphs and pivot tables.
Key Features
Key points
• Create multi-level Analytic Plans (Projects, Departments, Cost Centers) with Optional/Mandatory configuration
• Automatically distribute costs/revenues from invoices, purchase orders, and employee expenses to analytic accounts
• Automatic Distribution Models by partner, category, or company with flexible percentage allocation
• Concurrent multi-dimensional analysis (e.g., Project + Department) with List, Graph, and Pivot reports
• Real-time tracking of balance, Gross Margin, Debit/Credit across all analytic accounts
System Structure
Key points
• Analytic Plans: Define analytical dimensions like Projects, Departments, Cost Centers
• Analytic Accounts: Specific accounts to track costs/revenues within each dimension
• Analytic Items: Detailed transaction lines from invoices, orders, and expenses
• Analytic Distribution: Widget to allocate percentage splits on each invoice/order line
• Distribution Models: Rules to automatically populate distributions based on conditions
Terminology Reference EN/VI
| Fields | Trường dữ liệu | Description |
|---|---|---|
| Analytic Plans | Kế hoạch phân tích | Analytical dimensions (Projects, Departments, Cost Centers) |
| Analytic Accounts | Tài khoản phân tích | Specific accounts within each plan to track costs/revenues |
| Analytic Items | Hạng mục phân tích | Detailed transaction lines from business operations |
| Analytic Distribution | Phân bổ phân tích | Percentage allocation of costs/revenues across multiple accounts |
| Distribution Models | Mô hình phân bổ | Rules to automatically populate distributions based on conditions |
| Gross Margin | Biên lợi nhuận gộp | Total Credit - Debit of analytic account |
Basic Workflow
Steps
1. Create Analytic Plans: Go to Accounting → Analytic → Analytic Plans, create dimensions like "Projects", "Departments". Choose Default Applicability: Optional (flexible), Mandatory (must = 100%), or Unavailable (hidden).
2. Create Analytic Accounts: Go to Analytic Accounts, create specific accounts for each plan (e.g., Website, Mobile, Consulting for Projects plan). Fill name, code, select plan and company.
3. Distribute on Invoices/Orders: When creating customer invoices, vendor bills, or employee expenses, fill Analytic Distribution field on each line. Select accounts and adjust % with slider. Mandatory plans must total = 100%.
4. Configure Automatic Models (optional): Go to Configuration → Analytic Distribution Models, create rules to auto-populate distributions by partner, category, or company. System will auto-fill when creating invoices/orders.
5. View Analytic Reports: Go to Analytic Items, switch to Graph (Bar/Line/Pie charts) or Pivot (spreadsheet) to analyze costs/revenues by account, time, partner. Click Gross Margin on account to view detailed transaction lines.
Real-World Scenarios
Industry Applications
| Scenario | Configuration | Benefits |
|---|---|---|
| Track project costs | Create "Projects" plan, accounts for each project (Website, Mobile, Consulting). Distribute costs when creating invoices/expenses. | Know exact costs per project, calculate project profitability, report to clients. |
| Allocate department costs | Create "Departments" plan (Mandatory), accounts for each dept. Office costs split: Sales 50%, Accounting 30%, Admin 20%. | Control department budgets, compare costs between departments, management reporting. |
| Multi-dimensional analysis | Create 2 plans: "Projects" + "Departments" (both Optional). Distribute both dimensions on invoices. View Pivot with Rows = Projects, Columns = Departments. | Know costs per project by department, identify which department spends most on which project. |
| Auto-distribute by partner | Create Distribution Model: Partner = Company A, distribute Project X 60% + Project Y 40%. When creating invoice for Company A, distribution auto-fills. | Save data entry time, ensure consistent distribution for frequent partners. |
Reporting Views
View Comparison
| View Mode | When to Use | Advantages |
|---|---|---|
| List | View detailed transaction lines, audit and verify data | Shows complete info: date, account, amount, partner, user |
| Graph | Present trends visually for management reports | Visual with Bar, Line, Pie charts. Easy for executives to understand. |
| Pivot | Multi-dimensional analysis, dynamically change grouping | Flexible, powerful aggregation. Customize Rows/Columns/Values. Export to Excel. |
| Kanban | View analytic accounts as cards | Suitable for visual project management by stage |
Best Practices
Key points
• Use clear plan names (e.g., "Projects", "Departments", "Cost Centers"). Use hierarchy for specific projects/departments.
• Choose "Mandatory" for critical plans (must total = 100%), "Optional" for supplementary plans.
• Distribute promptly when creating invoices, don't wait. Verify total % = 100% for mandatory plans.
• Create automatic distribution models for frequent partners to save data entry time.
• Filter by date, group by plan when viewing reports. Export data to Excel for further analysis.
• Always verify distribution before posting invoices. Review analytic reports monthly to check accuracy.
• Only accountants can create/edit analytic accounts. Only finance managers can configure plans.
User Groups and Permissions
Access Control
| Group | Permissions |
|---|---|
| Accountant | Create/edit analytic accounts, use distribution on invoices, view reports |
| Finance Manager | Full access: configure plans, accounts, distribution models, reports |
| Project Manager | View project analytic accounts, view project costs |