Unrealized G/L Account Filter

$ 50.00

v 19.0 Third Party

This module requires Odoo Enterprise Edition.

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	• Invoicing (account) • Discuss (mail)
Lines of code	83
Technical Name	`unrealized_currency_filter_account`
License	OPL-1
Website	https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse
Versions	18.0 19.0

You bought this module and need support? Click here!

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	• Invoicing (account) • Discuss (mail)
Lines of code	83
Technical Name	`unrealized_currency_filter_account`
License	OPL-1
Website	https://apps.odoo.com/apps/modules/browse?author=Odoo%20DevHouse
Versions	18.0 19.0

Description
License

Unrealized Multi-Currency Revaluation Filter Account

This Odoo Accounting module enhances currency revaluation reporting by providing granular control over which accounts appear in unrealized gain/loss calculations. Perfect for businesses with complex multi-currency operations requiring customized currency exposure reporting and precise financial statement preparation.

Key Features

Account-Level Configuration: Granular control over which accounts appear in currency revaluation reports
Smart Account Filtering: Toggle visibility for specific asset and liability accounts
Enhanced Report Accuracy: More precise calculation of unrealized currency gains/losses
Optimized Performance: Advanced SQL queries for efficient large dataset processing
Conditional Interface: Intelligent field visibility based on account types
Multi-Currency Expertise: Sophisticated handling of partial payments and exchange rates

How It Works

1. Configure Account Settings

Enable the "Show in Unrealized Currency G/L" option for specific accounts that should be included in currency revaluation calculations.

                    Account Configuration:

                     Navigate to Accounting  Configuration  Accounts

                     Edit any asset or liability account

                     Toggle "Show in Unrealized Currency G/L"

                     Save changes

2. Intelligent Account Filtering

The system automatically filters relevant account types (receivables, payables, assets, liabilities) and only shows the toggle for appropriate accounts.

                    Supported Account Types:

                     Asset Receivable

                     Asset Cash

                     Asset Current & Non-Current

                     Asset Prepayments & Fixed

                     Liability Payable

                     Liability Credit Card

                     Liability Current & Non-Current

3. Advanced Currency Revaluation

The module enhances the multi-currency revaluation report with sophisticated calculations for partially paid moves and unpaid transactions.

                    Calculation Features:

                     Residual amount calculations for partial payments

                     Currency rate adjustments using current exchange rates

                     Proper handling of debit/credit reconciliations

                     Exclusion of exchange moves to prevent double-counting

4. Generate Customized Reports

Run the Multi-Currency Revaluation report to see accurate unrealized gains/losses based on your configured account selections.

                    Report Generation:

                     Go to Accounting  Reporting  Multi-Currency Revaluation

                     Set report parameters and date range

                     Generate report with filtered account data

                     Export for financial analysis and compliance

Installation & Configuration

Install the Module: Install through Odoo Apps or manually via module manager
Access Account Configuration: Go to Accounting Configuration Accounts
Review Account Types: Identify asset and liability accounts for currency exposure
Enable Reporting: Toggle "Show in Unrealized Currency G/L" for relevant accounts
Generate Reports: Run Multi-Currency Revaluation report with custom filters
Monitor Results: Analyze currency gains/losses for configured accounts only

Guide: Using Advanced Currency Revaluation Configuration

Install the Module

After installation, all asset and liability accounts will have the new "Show in Unrealized Currency G/L" field available in their configuration.

Configuring Accounts for Currency Reporting

Navigate to Accounting Configuration Accounts and review your chart of accounts.
For each relevant account, enable the "Show in Unrealized Currency G/L" option based on your reporting needs.

Understanding Account Selection Criteria

The module intelligently filters accounts that are relevant for currency revaluation:

Included by Default: Asset and liability accounts with currency exposure
Excluded: Income, expense, and off-balance sheet accounts
Conditional: Field only appears for relevant account types

Advanced Calculation Methodology

The enhanced report uses sophisticated SQL calculations:

Partially Paid Moves: Calculates residual amounts considering partial reconciliations
Currency Rates: Uses current exchange rates for accurate valuation
Adjustment Formula: balance_current - balance_operation
Performance Optimization: Lateral joins and CTEs for efficient large dataset processing

Generating Customized Reports

Access the enhanced Multi-Currency Revaluation report:
- Set your reporting period and currency parameters
- The report automatically filters based on your account configurations
- View accurate unrealized gains/losses for selected accounts only
- Export for financial analysis and compliance reporting

Best Practice

Enable the reporting option only for accounts with significant currency exposure. This provides cleaner reports focused on accounts that materially impact your financial statements, reducing noise from minor currency fluctuations.

Module Screenshots

Account Configuration Form

Toggle the "Show in Unrealized Currency G/L" option in account settings form view.

Account List View

Quickly enable/disable accounts for currency reporting using the boolean toggle in list.

Multi-Currency Revaluation Report

View accurate unrealized gains/losses based on your configured account selections.

Multi-Currency Revaluation Report

View accurate unrealized gains/losses based on your configured account selections.

Report Configuration and Filtering Options

Account Type Filtering

The module intelligently shows the configuration option only for relevant account types.

Use Cases

Multinational Corporations

Companies with entities in multiple countries needing precise currency exposure reporting for specific asset/liability accounts.

Financial Institutions

Banks and investment firms requiring customized currency revaluation for specific financial instruments and accounts.

Import/Export Businesses

Companies with significant foreign currency transactions needing focused reporting on specific receivable/payable accounts.

Business Benefits

Enhanced Reporting Accuracy

Precise calculation of unrealized currency gains/losses for selected accounts only, eliminating noise from irrelevant accounts.

Customized Financial Analysis

Granular control over which accounts contribute to currency exposure calculations for tailored financial reporting.

Improved Compliance

Meet accounting standards for currency translation with accurate, account-specific revaluation reporting.

Performance Optimization

Advanced SQL queries ensure efficient processing even with large datasets and complex multi-currency transactions.

Do You Need Assistance or Have a Feature Request?

Contact Support

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

The author can leave a single reply to each comment.
This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
If you want to start a discussion with the author or have a question related to your purchase, please use the support page.