$ 100.00
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 1173 |
| Technical Name |
am_account_statement |
| License | OPL-1 |
| Website | https://idealitsetup.com/ |
| Versions | 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 1173 |
| Technical Name |
am_account_statement |
| License | OPL-1 |
| Website | https://idealitsetup.com/ |
| Versions | 17.0 18.0 |
Account Statement / Advanced Report
Professional Account Statement Report with PDF, Excel & HTML Export for Odoo 18
Banner
Screenshots
Wizard Form
Easy-to-use wizard with account, partner, tag filters and multiple grouping options.
Group By Options
4 grouping methods: Account, Partner, Cost Center (Analytic Account), and Analytic Plan.
Interactive HTML Report
Beautiful web report with summary cards, filter info, and color-coded transaction table.
Excel Export
Professional Excel export with all columns including Reference, Label, Debit, Credit, and Running Balance.
Overview
A comprehensive Account Statement module for Odoo 18 that generates detailed financial statements with multiple grouping options, running balance calculations, and professional export capabilities. Designed for accountants and financial managers who need clear, organized, and exportable account statements.
Use Case: Generate detailed account statements grouped by Account, Partner, Cost Center (Analytic Account), or Analytic Plan. Export to PDF, Excel, or view as an interactive HTML report. Perfect for audit preparation, client statements, and financial analysis.
Key Features
| ✔ 4 Grouping Options - Group by Account, Partner, Cost Center (Analytic Account), or Analytic Plan |
| ✔ 3 Export Formats - Professional PDF, Excel spreadsheet, and interactive HTML web report |
| ✔ Running Balance - Automatic running balance calculation with opening balance support |
| ✔ Smart Filtering - Filter by accounts, partners, partner tags, date range, and posted/all entries |
| ✔ Partner Tags - Auto-populate partners by selecting category tags for bulk selection |
| ✔ Analytic Integration - Full support for analytic distribution, cost centers, and analytic plans |
| ✔ Bilingual Support - Full Arabic & English bilingual interface and reports |
| ✔ Detailed Columns - Date, Journal Entry, Reference, Label, Partner/Account, Debit, Credit, Balance |
| ✔ Professional Design - Clean, modern design with color-coded debit/credit and summary cards |
How It Works
Step 1: Open the Account Statement wizard from Accounting > Reports > Account Statement
|
| Step 2: Select your filters - accounts, partners, tags, date range, and grouping method |
| Step 3: Choose your output - click "View Statement" for HTML, "PDF" for print, or "Excel" for spreadsheet |
| Step 4: Review the report with summary cards, detailed transaction table, and running balance |
Grouping Options
| Group By | Description |
|---|---|
| Account | Group transactions by GL account code. Shows partner in detail rows. |
| Partner | Group transactions by partner (customer/vendor). Shows account code in detail rows. |
| Cost Center | Group by analytic account (cost center) from analytic distribution on journal items. |
| Analytic Plan | Group by analytic plan, aggregating all analytic accounts under each plan. |
Report Columns
| Column | Description |
|---|---|
| # | Row number |
| Date | Transaction date |
| Journal Entry | Journal entry name/number |
| Reference | External reference |
| Label | Journal item label/description |
| Partner / Account | Dynamic column based on grouping |
| Debit | Debit amount (red) |
| Credit | Credit amount (green) |
| Balance | Running balance with color coding |
Technical Information
| Attribute | Value |
|---|---|
| Technical Name | am_account_statement |
| Version | 18.0.1.0.0 |
| Dependencies | account |
| External Dependencies | xlsxwriter (Python) |
| License | OPL-1 (Proprietary) |
| Odoo Version | 18.0 |
Contact & Support
$100 USD
Get professional support and customization services
| Developer: | Ahmed Magdy |
| Email: | qarsan4@gmail.com |
| Website: | idealitsetup.com |
| WhatsApp: | +966 509818413 |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module