Analytic Accounting Enterprise - Grid View
Visual cost analysis with time-based matrix and Fiscal Year support
Analytic Accounting Enterprise module adds powerful Grid View for Odoo Enterprise, enabling visual cost/revenue comparison over time in matrix format.
Automatically aligns with company Fiscal Year (not limited to Jan-Dec), supports Year or Month views to track trends and detect anomalies quickly.
Key Features
Key points
• Grid View matrix format: Rows = Analytic accounts, Columns = Time periods, Cells = Transaction amounts
• Automatic alignment with company Fiscal Year (e.g., 05/2025 - 04/2026 instead of 01-12)
• Year View: 12 month columns by fiscal year for long-term trend comparison
• Month View: Daily columns for detailed daily transaction inspection
• Integration with filters and grouping from Analytic Items/Reporting
Grid View Structure
Key points
• Rows: Analytic accounts (projects, departments, cost centers)
• Columns: Time markers (months in fiscal year or days in month)
• Cells: Transaction amounts - positive = revenue/increase, negative = cost/decrease, empty = no transactions
• Grid view is Read-only: Cannot edit directly, must return to List view for modifications
Terminology Reference EN/VI
| Fields | Trường dữ liệu | Description |
|---|---|---|
| Grid View | Chế độ xem Lưới | Matrix display of data over time |
| Fiscal Year | Năm tài chính | Company accounting period (may differ from calendar year) |
| Period | Kỳ | Time range displayed on grid (Year/Month) |
| Row | Hàng | Analytic account |
| Column | Cột | Time marker |
| Cell | Ô | Intersection of row and column, displays amount |
How to Use Grid View
Steps
1. Access Grid View: Go to Accounting → Analytic → Analytic Items or Analytic Reporting, click Grid icon in top right corner.
2. Select time range: Choose Year to view 12 months by fiscal year, or Month to view daily details.
3. Navigate time: Use navigation buttons to switch to previous/next fiscal year (Year mode) or previous/next month (Month mode).
4. Apply filters: Filter by analytic account, date, partner, company before viewing Grid to reduce number of rows displayed.
5. Analyze data: Compare amounts between accounts by period, detect months/days with abnormal transactions, track cost/revenue trends.
Fiscal Year View
Key points
• Fiscal Year is company accounting period, may match (01-12) or differ from calendar year (e.g., 05/2025 - 04/2026).
• Grid View automatically retrieves fiscal year configuration from company, displays 12 month columns in fiscal year order.
• Suitable for tracking project costs by month throughout year, comparing department costs, preparing management reports by accounting period.
• Easy to detect seasonal trends, which months projects incur high costs, which departments consume more budget.
Month View
Key points
• Each column represents one day in the month, displaying daily transactions for each analytic account.
• Suitable for checking daily cost transactions, identifying days with abnormal transactions, tracking monthly transaction progress.
• Useful when checking figures before month-end reporting, investigating causes of data discrepancies.
Real-World Scenarios
Grid View Applications
| Scenario | Implementation | Benefits |
|---|---|---|
| Track project costs by month | Go to Analytic Items → Grid view → Year. Filter by Projects plan. View costs per project by month. | Easy to detect which months projects incur high costs, compare between projects. |
| Compare department costs | Go to Analytic Reporting → Grid view → Year. Filter by Departments plan. Compare rows by month columns. | Useful for budget management and department cost control. |
| Check abnormal transactions | Grid view → Month. Focus on specific account. Observe days with abnormally large values. Switch to List view for details. | Easy to investigate causes of data discrepancies, detect data entry errors. |
| Management reports by fiscal year | Grid view → Year. Filter by related account groups. Export data or screenshot for presentation. | Reports align with actual business accounting period, easy to present to executives. |
Comparison with Other Views
When to Use Grid View
| View Mode | When to Use | Advantages |
|---|---|---|
| Grid | Compare over time, view trends by period | Visual, easy to compare by month/day, fiscal year support |
| Pivot | Multi-dimensional analysis, dynamically change grouping | Flexible, powerful aggregation, customize Rows/Columns/Values |
| Graph | Present trends visually | Easy for management reports, suitable for executive presentations |
| List | View detailed transaction lines | Suitable for checking and auditing data, editing |
Best Practices
Key points
• Understand fiscal year: If month columns don't start from January, check company fiscal year configuration before comparing figures.
• Grid is for analysis, not data entry: Grid view is read-only. If you need to edit data, return to List view or original screen.
• Filter before viewing: If too many analytic accounts, grid will be hard to follow. Filter by related account groups first.
• Use Year for management, Month for checking: Year suitable for management reports and trend analysis. Month suitable for daily detail checking.
• Combine with basic Analytic module: This module only adds viewing method. Creating plans, accounts, distributions still done in basic module.
• Combine views: Use Grid to detect abnormal months/days → switch to List for details → use Pivot if need to aggregate by different dimension.
Requirements
Key points
• System must have basic analytic module and account module
• Odoo Enterprise version with web_grid support
• analytic_enterprise module installed automatically when dependencies met
• Shares permissions with basic Analytic module (Accountant, Finance Manager)