Overview
The ICS Vendor Bill Report module provides comprehensive vendor bill reporting capabilities with detailed line-level analysis, grouped by GL accounts. This powerful reporting tool enables finance teams to analyze vendor bills with complete transparency, showing account-level breakdowns, VAT calculations, and analytic distribution.
Built for professional accounting teams who need detailed insights into their vendor bills, this module offers both on-screen reporting and multi-format export capabilities (PDF and Excel) with customizable layouts.
Key Features
Line-Level Analysis
View vendor bills broken down by GL accounts with detailed subtotals, VAT calculations, and totals for each account line.
Account Grouping
Automatic grouping of invoice lines by GL account, making it easy to see how amounts are distributed across different accounts.
VAT Breakdown
Clear display of VAT percentages and amounts per account line, with automatic calculation and validation.
Analytic Distribution
View analytic account distribution (cost centers) for each invoice line, supporting multi-analytic scenarios.
PDF Export
Professional PDF reports with proper formatting, merged cells for better readability, and company branding.
Excel Export
Export to Excel with proper column formatting, merged sequence cells, financial totals, and customizable layouts.
Selective Export
Export only selected records from both the report view and vendor bill list, giving you full control over what to export.
SQL View Based
Fast and efficient reporting using PostgreSQL views with proper indexing and optimized queries.
Payment Tracking
Track payment states directly in the report, showing which bills are paid, partially paid, or unpaid.
Report Structure
The report includes the following columns with intelligent data organization:
- Seq: Sequential number (merged for multi-line invoices)
- Invoice Date: Bill date (shown once per invoice)
- Invoice No: Bill reference number
- Vendor: Supplier name
- Reference Number: Vendor's invoice reference
- Total Invoice - Excl VAT: Invoice total without VAT (shown once)
- Total Invoice - Incl VAT: Invoice total with VAT (shown once)
- Payment State: Payment status (shown once)
- GL - Accounts: General ledger account name (per line)
- Subtotal (excl. VAT): Amount before VAT per account
- VAT %: Tax percentage applied
- VAT Amount: Tax amount per account
- Total (incl. VAT): Line total with VAT
- Analytic - CC: Cost center / analytic account
💡 Smart Cell Management
Invoice-level fields (Date, Totals, Payment State) appear only on the first line when an invoice has multiple GL accounts, reducing redundancy while maintaining data integrity. The Seq column is merged for visual clarity.
Excel Export Features
Professional Formatting:
- Properly sized columns for optimal readability
- Merged sequence cells for multi-line invoices
- Bold formatting for invoice totals
- Monetary formatting with 2 decimal places
- Centered headers with background color
- Borders for clear cell separation
- Frozen header row for easy scrolling
Financial Totals:
- Sum of Total Invoice amounts (Excl & Incl VAT)
- Sum of all Subtotals (excl. VAT)
- Sum of all VAT Amounts
- Sum of all Totals (incl. VAT)
- Count of total invoices
Technical Specifications
Module Components:
- Models: SQL view for efficient reporting with proper grouping
- Controllers: HTTP endpoints for Excel export with customizable parameters
- Reports: QWeb PDF templates with professional formatting
- Views: Tree and pivot views with integrated export buttons
- Security: Access rights and record rules for accounting users
Requirements
- Odoo Community/Enterprise 17.0 - Accounting module installed and configured
- Python Libraries: xlsxwriter (automatically installed)
- User Permissions: Accounting user access rights
- Database: PostgreSQL 12 or higher
Use Cases
Monthly Financial Close
Generate comprehensive vendor bill reports for month-end reconciliation and review.
Audit Preparation
Export detailed vendor bill analysis with complete GL account breakdown for auditors.
Budget Analysis
Review spending by GL account and cost center using the analytic distribution feature.
VAT Reporting
Analyze VAT amounts and percentages across all vendor bills for tax compliance.
Payment Planning
Track payment states and plan cash flow based on outstanding vendor bills.
Vendor Analysis
Analyze spending patterns by vendor with complete transaction history.
Menu Location
Access the report from:
Accounting → Reporting → Vendor Bill Report
Additionally, the Excel export button is available directly in the Vendor Bills list view (Accounting → Vendors → Bills) for quick exports.
Benefits
- Save time with automated report generation and export
- Improve accuracy with automatic VAT calculations
- Enhanced visibility into spending by GL account
- Better audit trail with detailed line-level reporting
- Simplified reconciliation with clear account grouping
- Professional reports ready for stakeholder presentation
- Cost center tracking through analytic distribution
- Flexible export options for various business needs
Support & Updates
This module is actively maintained and updated for Odoo 17.x versions. We provide:
- Regular updates for compatibility with new Odoo releases
- Bug fixes and improvements
- Technical support via email
- Customization services available upon request
- Integration with other accounting modules
Please log in to comment on this module
There are no ratings yet!
Amazing Module