| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) • Contacts (contacts) |
| Lines of code | 831 |
| Technical Name |
l10n_ec_ice_artisanal_beer |
| License | OPL-1 |
| Website | https://www.bistro-pay.com |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) • Contacts (contacts) |
| Lines of code | 831 |
| Technical Name |
l10n_ec_ice_artisanal_beer |
| License | OPL-1 |
| Website | https://www.bistro-pay.com |
Ecuador ICE Tax - Artisanal Beer
Complete ICE (Impuesto a los Consumos Especiales) management for artisanal breweries in Ecuador
Overview
This module provides a complete solution for managing the ICE tax (Impuesto a los Consumos Especiales) for artisanal breweries operating in Ecuador. It integrates seamlessly with Odoo's Ecuador localization and handles automatic tax computation, SRI electronic invoicing (EDI), and the official SRI Form 105 (Anexo 105) report for regulatory compliance.
ICE Tax on Invoices
ICE tax is automatically computed and displayed on customer invoices.
Key Features
Automatic ICE Calculation
Computes ICE based on the official formula: liters of pure alcohol x rate per liter. Uses alcohol degree, product volume, and configurable rate tiers. Results are rounded to 2 decimals.
SRI Form 105 Report
Generate the official Anexo 105 report required by Ecuador's SRI. Export as PDF for internal records or as XML ready to upload to the DIMM platform.
EDI / Electronic Invoicing
Full integration with Ecuador's electronic invoicing system. ICE taxes appear correctly in EDI XML documents sent to the SRI with the proper tax codes (codigo=3, codigoPorcentaje=3023).
Configurable Rate Tiers
Manage ICE rate tiers with date ranges and alcohol degree thresholds. Easily update rates when SRI regulations change without modifying code.
Product Configuration
Set up your beer products with alcohol degree, volume, and the official SRI product code.
How It Works
| # | Step | Description |
|---|---|---|
| 1 | Configure Products | Mark your beer products as "ICE Applicable" and enter alcohol degree (%) and volume (ml). |
| 2 | Set ICE Rates | Configure ICE rate tiers under Accounting > Configuration > ICE Rates. Set the rate per liter of pure alcohol. |
| 3 | Create Invoices | When you create a customer invoice with ICE-applicable products, the ICE tax is computed automatically and added to the invoice. |
| 4 | Send to SRI | Electronic invoices include ICE tax data in the correct XML format for SRI validation. |
| 5 | Generate Form 105 | Go to Accounting > Reports > ICE Report 105. Select the period, then download as PDF or XML for DIMM upload. |
ICE Rate Configuration
Navigate to Accounting > Configuration > ICE Rates to manage tax rate tiers.
Configure rates per liter of pure alcohol, with date ranges and alcohol degree thresholds.
ICE Tax Calculation Formula
ICE = (Volume in ml / 1000) x (Alcohol Degree / 100) x Quantity x Rate per Liter of Pure Alcohol
Example: A 330ml beer at 5% ABV, quantity 100 units, rate $10/liter:
ICE = (330/1000) x (5/100) x 100 x 10 = $16.50
Product Configuration Fields
- ICE Applicable: Enable ICE tax computation for this product
- Alcohol Degree (%): Alcohol by volume (ABV) percentage
- Product Volume (ml): Volume per unit in milliliters
- ICE Product Code (SRI): Official SRI product code for Form 105 reporting
SRI Form 105 Report (Anexo 105)
Access the report from Accounting > Reports > ICE Report 105.
Select the reporting period and generate the report as PDF or XML.
PDF Report Output
Download a detailed PDF report for internal records and audits.
Form 105 XML Export
The XML export follows the official SRI XSD schema for the ICE Anexo 105. The generated file is ready to upload directly to the DIMM application. It includes:
- Company identification (RUC, legal name)
- Reporting period (year and month)
- Sales detail grouped by ICE product code
- Return quantities from credit notes
- Sugar content field (gramoAzucar) as required by SRI
SRI DIMM Validation
The generated XML file is validated and accepted by the SRI DIMM platform.
Compatibility
- Odoo 17 Community and Enterprise
- Requires: Ecuador localization module (
l10n_ec) - Optional: When
l10n_ec_edi(Enterprise) is installed, ICE taxes integrate automatically with SRI electronic invoicing - Compatible with existing tax configurations and accounting workflows
- ICE tax is added to the VAT taxable base (include_base_amount) as required by Ecuadorian tax law
Support
For technical support, bug reports, or feature requests, please contact us at soporte@bistro-pay.com. We are committed to resolving any issues in a timely fashion.
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
There are no ratings yet!
Podemos desarrollar este módulo para cualquier versión de Odoo bajo demanda. ¡Contáctanos!