| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 754 |
| Technical Name |
financial_statement_annexes |
| License | OPL-1 |
| Website | https://www.ganemo.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 754 |
| Technical Name |
financial_statement_annexes |
| License | OPL-1 |
| Website | https://www.ganemo.com |
Financial Annexes
Receivables, Payables & Aging Reports
Generate precise audit-ready reports with historical cut-off dates and aging buckets in Excel. The missing piece for your Monthly and Yearly Closing.
What We're Solving
----------------
Accurate Historical Balances
Need to know exactly what a client owed you on December 31st of last year? Standard reports often struggle with "as of" dates when payments happen later. This module reconstructs the balance sheet exactly as it was on your chosen cut-off date.
Detailed Aging Analysis
Go beyond simple totals. Activate the Aging Option to split debts into buckets (1-30 days, 31-60 days, etc.). Perfect for cash flow analysis and identifying bad debts before they become a problem.
Setup & User Manual
Easy Reporting
1. Accessing the Report
No complex configuration needed. Just install and go.
- Go to Accounting > Reporting > Informes Financieros > Notas y Anexos (excel).
- This opens the reporting wizard.
2. Generating the Report
Customize your view:
Select Dates
Choose your Start Date and End Date. The End Date acts as your "Cut-off" date for balances.
Choose Accounts
Filter by specific Receivable or Payable accounts. You can select multiple accounts (e.g., Domestic Clients, Foreign Clients).
Aging Option
Check the "Reporte de Antiguedad" box. This adds columns to the Excel file categorizing debt by age (1-30, 31-60, 61-90, >90 days).
Excel Output
Click "Descargar en Excel". You get a clean, formatted file ready for your auditor or manager.
Global Ready | Multi-Language Support
This module is fully translated into English and Spanish (en_US, es_ES, es_PE, es_MX), ensuring a professional experience for international organizations.
Why Choose Ganemo?
----------------
Ganemo is the world's leading Odoo App developer and a multi-award-winning Gold Partner. For over 5 years, we have been recognized as the #1 seller of high-quality apps on the Odoo App Store. Trusted as the "Best Partner" in USA, Mexico, Chile, Spain, Colombia, Ecuador, and Peru, we deliver robust, secure, and localization-compliant solutions for global businesses.
Get a Quote & Resolve Commercial Doubts
Join thousands of satisfied clients on Odoo. Contact our sales team directly.
Official WhatsApp
Fastest response time.
LINK
+1 (828) 672-6150
Book a Demo
Let's explore your needs.
LINK
Schedule Meeting
Need More? We Do It All
Professional Odoo Services
ERP Implementation
Transform your business with a full Odoo implementation. We analyze, configure, and train your team to maximize productivity. From Accounting to Inventory, we handle the complexity so you can focus on growth.
Module Dev & Migration
Need a custom feature? Or stuck on an older version? We develop high-performance custom modules and migrate your existing code to Odoo 19 with zero data loss. Expert developers at your service.
QA / User Testing Scenarios
Enterprise Validation Plan
Scenario 1: Historical Cut-off Precision
Objective: Verify that payments made after the selected cut-off date are ignored, showing the debt as it existed historically.
- Create an Invoice (INV-2023-001) dated Dec 15th, 2023 for $1,000.
- Register a Payment (PAY-2024-001) dated Jan 15th, 2024 for the full amount.
- Run the report with End Date: Dec 31st, 2023.
- Expected Result: The report must show a balance of $1,000 (Open). The payment from Jan 2024 should be ignored.
- Run the report again with End Date: Jan 31st, 2024.
- Expected Result: The report must show a balance of $0 (Paid).
Scenario 2: Multi-Currency & Partial Payments
Objective: Ensure correct calculation of residual amounts in foreign currency.
- Create a USD Invoice for $10,000 (assuming company currency is EUR).
- Pay $3,000 on a date with a different exchange rate.
- Leave $7,000 open.
- Run the report including the "Amount Currency" column.
- Expected Result: "Amount Currency" column must show exactly $7,000 USD. The "Balance" column (EUR) should reflect the revalued (or historical, depending on config) residual amount.
Scenario 3: Aging Buckets & "Not Due"
Objective: Validate that debts are correctly bucketed based on Due Date.
- Create 3 Invoices with Due Dates: Today (0 days), 45 days ago, and Future (+30 days).
- Run report with "Aging Report" enabled.
- Expected Result:
- Invoice 1: Appears in "0-30" or "Current".
- Invoice 2: Appears in "31-60".
- Invoice 3: Appears in "Not Due" (Por Vencer).
Scenario 4: High Volume Performance
Objective: Ensure stability with 10,000+ records.
- Select a high-volume account (e.g., Receivable) with thousands of historical moves.
- Generate the report for a full fiscal year.
- Expected Result: The wizard should generate the Excel file within standard timeout limits (SQL optimizations are in place). Pivot view should load without browser freeze (using optimized grouping).
Scenario 5: View in Odoo vs. Excel Consistency
Objective: Validate the new "View in Odoo" feature.
- Configure report options (Date, Accounts, Aging).
- Click "View in Odoo".
- Click "Generate Excel" with same options.
- Expected Result: The Total Balance sum in the Odoo list view must exactly match the Grand Total in the Excel file. Link navigation (clicking on Account/Partner) should open the correct form views.
FAQ & Troubleshooting
Common Resolutions
Why is my balance different from Odoo's Partner Ledger?
Reason: Standard Partner Ledger might include different account types or unposted entries.
Fix: Ensure you are selecting posted entries only if that is your goal, and verify the Accounts filter matches exactly.
Does it support PDF?
Reason: This module specializes in Excel data dumps for auditing.
Fix: Use Odoo's standard reports for PDF. Use this module for data manipulation, pivots, and audits.
"Zero Division Error"?
Reason: Usually happens if exchange rates are missing (0.00) for a specific historical date in multi-currency environments.
Fix: Check your Currency Rates table for the date of the transaction.
Is it compatible with Multi-company?
Answer: Yes!
Detail: It respects record rules and only shows data for the currently active company.
Commercial & Sales
For inquiries about licenses, demos, or partnerships.
Official WhatsApp
Fastest response time.
LINK
+1 (828) 672-6150
Book a Demo
Let's explore your needs.
LINK
Technical Support
Existing customers regarding module functionality.
© 2026 Ganemo. All rights reserved. visit ganemo.com
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