Financial Reports — Complete Suite (P&L + BS + CF + SCE)
by Alphasoft http://www.alphasoft.co.id$ 178.99
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 9536 |
| Technical Name |
aos_financial_reports |
| License | OPL-1 |
| Website | http://www.alphasoft.co.id |
| Versions | 15.0 16.0 17.0 18.0 19.0 |
Financial Reports — Complete Suite
8 standard accounting reports for Odoo 18 Community.
Profit & Loss, Balance Sheet, Cash Flow, Equity Changes, Trial
Balance, General Ledger, AR Aging, AP Aging.
No Enterprise license required.
Standard reports —
one bundled license
Output formats —
PDF, HTML, XLSX, CSV
Quick range presets —
Today, YTD, This Quarter…
Companies, users —
flat license, no per-user fee
Eight standard reports — one module
Organized like Odoo Enterprise's Reporting menu: Statement Reports · Ledgers · Partner Reports.
Statement Reports
- Balance Sheet — dual-column Assets | Liabilities + Equity, BALANCED ✓ sanity-check footer, current-year earnings auto-injected.
- Profit and Loss — formula-driven hierarchy (GROSS_PROFIT = INCOME − COGS), period-over-period comparison, optional analytic split.
- Cash Flow Statement — direct method, 3 sections (Operating · Investing · Financing), proportional counterpart attribution.
- Statement of Changes in Equity — per-component roll-forward (opening → movement → closing), memorized net-income row.
Ledgers & Partner Reports
- Trial Balance — per-account opening / debit / credit / closing, configurable optional columns.
- General Ledger — raw-SQL fast (50k-line safety cap), 10 built-in + unlimited custom columns, fold/unfold per account, drill to source move.
- Aged Receivable — bucketed by overdue days (Current / 1-30 / 31-60 / 61-90 / 91-180 / 180+), partner drill-down to invoice level.
- Aged Payable — same as AR but sign-flipped for payables; identical drill-down UX.
Filter pills & toolbar — built for speed
Every report shares the same interactive top bar. Click a pill, pick a value, hit Apply — or use a quick range preset. Saved per company in localStorage so your last view is one click away.
Mockup of the live report toolbar — actual UI renders identical in your Odoo instance.
Why teams pick this module
Real-time interactive view
OWL-based report renders in <2s. Change a filter, click Apply, see updated numbers instantly. No PDF round-trip needed.
Drill-down everywhere
Click any aggregate row → opens
account.move.line with the filter already applied.
GL drills to move form; Aging drills to invoice.
Formula engine
Reference other lines algebraically:
GROSS_PROFIT = INCOME - COGS.
Safe AST eval — no __builtins__ exposure.
Multi-company aggregation
Consolidate 2+ companies in one report via the Companies pill. Mixed-currency warning auto-displayed. Per-company filter scoping prevents data leakage.
Charts built-in
Toggle the chart pane: P&L bar, BS donut, CF section comparison, EQ component roll-forward. Chart.js, locale-aware tooltips.
Period-over-period
Comparison pill auto-fills prior-year range. Side-by-side column shows variance. Works on PL, BS, CF, SCE. Split by month/quarter/year for trend analysis.
Configurable columns (GL / TB)
Add custom columns to General Ledger
without code: Due Date, Matching #, Product, Qty, Unit Price
pre-built; user-defined fields work too via
account.move.line field path.
4 output formats
PDF (wkhtmltopdf) · HTML (new tab) · XLSX (styled with merged headers + colored highlights) · CSV (locale-formatted numbers). One filter state, all exports.
Multi-tenant safe
Defensive _validate_companies()
guards RPC against company_id outside env.companies.
Per-company localStorage scoping. No cross-tenant data leak.
How it compares to Odoo Enterprise
| Feature | Odoo Community + this module | Odoo Enterprise |
|---|---|---|
| P&L / BS / Cash Flow / Equity reports | ✓ All 4 | ✓ All 4 |
| Trial Balance, General Ledger | ✓ | ✓ |
| AR Aging / AP Aging | ✓ with invoice drill-down | ✓ |
| Configurable line structure (formulas, prefixes) | ✓ data-driven | ✓ |
| Multi-company aggregation | ✓ | ✓ |
| Configurable GL optional columns + custom fields | ✓ rename · reorder · add custom | limited preset |
| Aging drill-down to invoice line | ✓ inline expand | click-through |
| Source code access | ✓ full source | closed (Enterprise) |
| License model | USD 179 one-time unlimited users · all features |
per-user / year scales with team size |
Balance Sheet — built-in sanity check
Footer shows ✓ BALANCED when Assets = Liabilities + Equity (within rounding), or ⚠ DIFFERENCE with the gap amount when out-of-balance. Catch CoA misconfigurations instantly.
Multi-company in one click
Run any report across multiple companies via the
Companies pill — appears automatically when
env.companies contains more than one. Tick the
companies to include, hit Apply, and totals aggregate across all
selected entities.
- Defensive
_validate_companies()guards every RPC against IDs outsideenv.companies - Per-company localStorage scoping
(
afr_${reportType}_${cid}) — switching active company never leaks the previous report state - Journal options refresh when company set changes (so you don't accidentally pick a journal from a now-excluded company)
- Mixed-currency warning banner if selected companies use different currencies (totals would sum raw — flag for review)
Configure without code
Click the gear icon (⚙) in any report toolbar to edit line definitions as standard Odoo records. No Python, no XML, no module restart.
Line records (account.pl.report.line)
INCOME (line_type: accounts, prefix: 4xx) ├ OPERATING_REV (line_type: accounts, prefix: 401-403) ├ OTHER_REV (line_type: accounts, prefix: 404-405) TOTAL_INCOME (formula: INCOME) COGS (line_type: accounts, prefix: 5, display: -) GROSS_PROFIT (formula: TOTAL_INCOME + COGS, highlight) OPEX (line_type: sum_children, display: -) ├ SELLING_EXP (prefix: 601) ├ ADMIN_EXP (prefix: 602) OPERATING_PROFIT (formula, highlight) NET_PROFIT (formula, highlight)
Display options per line
- line_type: header · accounts · sum_children · formula · current_earnings (BS only)
- account_code_prefix: comma-separated (e.g., "401,402,403")
- account_type_filter: by Odoo account_type (e.g., "income,income_other") — CoA-prefix-agnostic
- display_style: normal · bold · highlight (yellow background, larger font)
- display_negative: flip sign (expenses shown as negative)
- hide_zero: client-side suppress when balance ≈ 0
Formula syntax (safe AST)
INCOME - COGS ·
(REV + OTHER) * 0.5 ·
-EXPENSES
Whitelist: +, −, ×, ÷, parens, unary ±.
No __builtins__, no eval, no
import.
See it in your Odoo
Live screenshots from production-style data (PT ALPHASOFT ISP, ~Rp 115 Miliar assets). Same colors, same pills, same drill-down in your environment.
Balance Sheet — Summary · dual-column Assets | Liab+Equity, ✓ BALANCED sanity-check footer
Profit & Loss — Summary · GROSS_PROFIT / OPERATING_PROFIT / NET_PROFIT auto-highlighted
Balance Sheet — Detailed · expand any line to its constituent accounts
Profit & Loss — Detailed · every account contributing to each line
Balance Sheet — Period Split · monthly snapshots side-by-side
P&L — Period Split · per-month columns reveal seasonality at a glance
P&L — Analytic Split · per-cost-center / per-project / per-department columns
Balance Sheet — Chart · toggle the 📊 icon for instant donut visualization
Cash Flow Statement · direct method, 3 sections (Operating · Investing · Financing)
Trial Balance · per-account Opening / Debit / Credit / Closing + configurable columns
General Ledger · per-account fold/unfold, 10 built-in columns + unlimited custom
Aged Receivable · overdue buckets per partner, expand to invoice rows
Aged Payable · overdue buckets per vendor, identical drill-down UX to AR
P&L — Chart Toggle · 📊 icon switches to horizontal bar breakdown
Cash Flow — Period Split · per-month columns showing seasonal cash flow patterns
Trial Balance — Period Split · per-period (Debit, Credit) pairs between Opening & Closing
Want at-a-glance KPIs & trend charts?
Check out our companion module — Financial Dashboard — a one-screen overview with KPI tiles + 12-month visualization charts for P&L, Balance Sheet, and Cash Flow.
aos_financial_dashboard
- ✓ 3 tabs — P&L · Balance Sheet · Cash Flow
- ✓ 18 KPI tiles (6 per tab, business-ready)
- ✓ 4 Chart.js visualizations (combo + stacked)
- ✓ 1-2 SQL queries per tab (optimized)
- ✓ Multi-company aware
- ✓ Source code included (OPL-1)
Standalone module, sold separately.
Depends on aos_financial_reports
for its data layer — same wizards, no duplication.
Installation — 3 minutes
- Purchase & download the module from the Apps Store.
- Extract into your Odoo addons path.
- Open Apps → Update Apps List.
- Search Financial Reports → click Install.
- Python dep:
xlsxwriter(usually pre-installed). If missing:pip install xlsxwriter - Navigate to Accounting → Reporting — Statement Reports, Ledgers, Partner Reports sections appear.
Dependencies: account, analytic (both
ship with Odoo Community).
Zero custom modules required.
One license · All features · Free updates
One-time license
USD 179
All 8 reports · unlimited users · single fee
- ✓ 8 standard accounting reports
- ✓ Multi-company aggregation
- ✓ Configurable line structure + GL columns
- ✓ PDF · HTML · XLSX · CSV output
- ✓ Charts, drill-down, comparison
- ✓ Source code included (OPL-1)
- ✓ Free updates within Odoo 18.x
- ✓ Email support (1 business day)
Need help?
We respond within 1 business day to support requests.
- Email: info@alphasoft.co.id
- Website: www.alphasoft.co.id
- Docs: README.md + USER_GUIDE.md inside the module
Custom development
Need bespoke financial reports? Branch consolidation, Indonesian Coretax integration, custom XBRL output, multi-jurisdiction templates — we do custom Odoo work. Get in touch.
License: OPL-1 (Odoo Proprietary License v1.0) | Author: Alphasoft | Version: 18.0.7.0.13 | Odoo: 18.0 Community / Enterprise
Trademarks & logos: Odoo® is a trademark of Odoo S.A. Alphasoft is not affiliated with or endorsed by Odoo S.A.
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