厄瓜多尔

介绍

With the Ecuadorian localization you can generate electronic documents with its XML, Fiscal folio, with electronic signature and direct connection to tax authority SRI.

The supported documents are Invoices, Credit Notes, Debit Notes, Purchase Liquidations and Withholds.

The localization also Includes automations to easily predict the withholding tax to be applied to each purchase invoice.

词汇表

Here are some terms that are essential on the Ecuadorian localization:

  • SRI: meaning Servicio de Rentas Internas, the government organization that enforces pay of taxes in Ecuador.

  • EDI: stands for Electronic Data Interchange, which refers to the sending of Electronics Documents.

  • RIMPE: stands for Regimen Simplificado para Emprendedores y Negocios, the type of taxpayer qualified for SRI.

配置

模块安装

Install the following modules to get all the features of the Ecuadorian localization:

名称

技术名称

说明

Ecuadorian - Accounting

l10n_ec

The default fiscal localization package, adds accounting characteristics for the Ecuadorian localization, which represent the minimum configuration required for a company to operate in Ecuador according to the guidelines set by the SRI. The module’s installation automatically loads: Chart of Accounts, taxes, documents types, tax support types. Additionally, the generation of forms 103 and 104 are automatic.

Ecuadorian Accounting EDI

l10n_ec_edi

Includes all the technical and functional requirements to generate and validate Electronics Documents, based on the Technical documentation published by the SRI. The authorized documents are: Invoices, Credit Notes, Debit Notes, Withholdings and Purchase liquidations.

注解

When you install a database from scratch selecting Ecuador as the country, Odoo automatically installs the base module Ecuadorian - Accounting.

Configure your company

To configure your company information, go to the Contacts app and search the name given to your company or activate developer mode and go to Company ‣ Contact and then edit the contact to configure the following information:

  1. Check the Company option on top

    • 名称

    • Address

    • 识别码

    • 纳税人类型

    • 电话

    • 电子邮件

  2. Upload company logo and save

Populate company data for Ecuador in Odoo Contacts.

电子文档

要上传电子文档信息,请访问 会计 ‣ 配置 ‣ 设置 并搜索 厄瓜多尔本地化

配置下一个信息:

  • 公司法定名称

  • Use production servers: check the checkbox if your company is going to do electronic documents in the production environment. If you want to use the testing environment for electronic documents then keep the checkbox unchecked.

  • Regime: select if your company is in General Regular or is qualified as RIMPE.

  • Forced to keep accounting books: check the checkbox if your company has this condition.

  • Default taxes for withholdings

  • Issue withholds: check the checkbox if your company is going to do electronic withholds.

  • Withhold consumibles: put the code of the withholding for when you buy goods.

  • Withhold services: put the code of the withholding for when you buy services.

  • Withhold credit card: put the code of the withholding for when you buy with credit card

  • Withhold agent number: put the company withholding agent resolution number, if applicable for your company.

  • Electronic Certificate File: upload electronic certificate and password, then save it.

  • Special tax contributor number: if your company is qualified as a special taxpayer, fill out this field with it’s corresponding tax contributor number.

Electronic signature for Ecuador.

注解

When configuring the withholdings in the configuration menu, these suggested withholdings are only for domestic suppliers when no withholdings are setup on their Taxpayer Type. Moreover, the Credit Card withholding set up is always used when a Credit or Debit Card SRI Payment Metho is used.

VAT withholding

This configuration only applies if you are qualified as a Withholding Agent by the SRI, otherwise skip this step. To configure your VAT withholding, go to Accounting ‣ Accounting ‣ Configuration ‣ Ecuadorian SRI: Taxpayer Type SRI.

You must configure the withholding percentage that applies for each type of taxpayer, specify the Goods VAT Withholding and the Services VAT Withholding.

Taxpayer Type configuration for Ecuador.

小技巧

In the case that the Taxpayer Type is RIMPE, also configure the Profit Withholding percentage.

Printer points

To configure your printer points, go to Accounting ‣ Configuration ‣ Accounting: Journals.

Printer points need to be configured for each type of electronic document that you need. For example: Customer Invoice, Credit Notes, and Debit Notes

For each printer point, you need to configure the following information:

  • Journal Name: in this format [Emission Entity]-[Emission Point] [Document Type], for example: 001-001 Sales Documents.

  • Type: refers to the type of journal, select Sales.

  • Use Documents?: this checkbox is automatically checked, leave it checked.

  • Emission Entity: configure the establishment number.

  • Emission Point: configure the printer point.

  • Emission address: configure the address of the establishment.

  • Default income account: configure the default income account.

  • Dedicated Credit Note Sequence: check the checkbox if Credit Notes are to be generated from this printer point - journal.

  • Short Code: This is the unique code for the sequence of accounting entries, enter a unique 5-digit code, for example: VT001

Customer Invoice, Credit Notes and Debit Notes need to use the same journal as the Emission Point, and the Entity Point should be unique per journal.

Configuring a printer point for Ecuador electronic document type of Customer Invoices.

注解

In the Advanced Settings tab, check the Electronic Invoicing checkbox to enable it for Ecuador.

预扣税

必须定义预扣日记账,进入 会计 ‣ 配置 ‣ 会计:日记账,在此需要配置以下信息:

  • 日记账名称:格式为 [Emission Entity]-[Emission Point] [Document Type],例如:001-001 扣款

  • 类型:指日记账类型,选择`杂项`。

  • 预扣类型:配置采购预扣。

  • Use Documents?: this checkbox is automatically checked, leave it checked.

  • Emission Entity: configure the establishment number.

  • Emission Point: configure the printer point.

  • Emission address: configure the address of the establishment.

  • 默认账户:配置默认收入账户。

  • 短代码:这是会计分录序列的唯一代码,请输入唯一的 5 位数代码,例如:RT001

配置厄瓜多尔电子文件预扣类型。

注解

高级设置 选项卡中,选中 电子发票 复选框,启用发送预扣款电子发票。

Purchase Liquidations

使用采购清算时,必须创建特定的日记账,请转至 会计 ‣ 配置 ‣ 会计:日记账 并配置以下信息:

  • Journal Name: in this format [Emission Entity]-[Emission Point] [Document Type], for example: 001-001 Withhold.

  • 类型:指日记账类型,选择`杂项`。

  • Purchase Liquidations: check the checkbox to enable purchase liquidations.

  • Use Documents?: this checkbox is automatically checked, leave it checked.

  • Emission Entity: configure the establishment number.

  • Emission Point: configure the printer point.

  • Emission address: configure the address of the establishment.

  • 短代码:这是会计分录序列的唯一代码,请输入唯一的 5 位数代码,例如:RT001

Configuring purchase liquidations for Ecuador electronic document type of Withholding.

注解

高级设置 选项卡中,选中 电子发票 复选框,启用发送预扣款电子发票。

Configure master data

会计科目表

The chart of accounts is installed by default as part of the set of data included in the localization module, the accounts are mapped automatically in Taxes, Default Account Payable, Default Account Receivable.

The chart of accounts for Ecuador is based on the most updated version of Superintendency of Companies, which is grouped in several categories and is compatible with NIIF accounting.

您可以根据公司需要添加或删除账户。

产品

In addition to the basic information in your products, you must add the configuration of the withholding code (tax) that applies.

Go to Accounting ‣ Vendors: Products under the tab “Purchase”

Product for Ecuador.

联系人

Configure the next information when you create a contact:

  • Check the Company option on top if it is a contact with RUC, or check Individual if it is a contact with cedula or passport.

  • 名称

  • Address: Street is a required field to confirm the Electronic Invoice.

  • Identification Number: select an identification type RUC, Cedula, or Passport.

  • Taxpayer Type: select the contact’s SRI Taxpayer Type.

  • 电话

  • 电子邮件

Contacts for Ecuador.

注解

The SRI Taxpayer Type has inside the configuration of which VAT and Profit withholding will apply when you use this contact on Vendor Bill, and then create a withholding from there.

Review your taxes

As part of the localization module, taxes are automatically created with its configuration and related financial accounts.

Taxes for Ecuador.

The following options have been automatically configured:

  • Tax Support: to be configured only in the IVA tax, this option is useful when you register purchase withholdings.

  • Code ATS: to be configured only for income tax withholding codes, it is important when you register the withholding.

  • Tax Grids: configure the codes of 104 form if it is a IVA tax and configure the codes of 103 form if it is a income tax withholding code.

  • Tax Name:

    • For IVA tax, format the name as: IVA [percent] (104, [form code] [tax support code] [tax support short name])

    • For income tax withholding code, format the name as: Code ATS [Percent of withhold] [withhold name]

安装厄瓜多尔模块后,将自动配置最常见的税种。如果需要创建额外的税种,您可以根据现有税种的配置进行创建。

Taxes with tax support for Ecuador.

查看您的文件类型

有些会计交易,如*客户发票*和*供应商账单*,按文件类型分类。这些都由政府财政部门定义,本例中由 SRI 定义。

每种文档类型都可以为其所在的每种日记账设定一个唯一序列。作为本地化的一部分,文件类型包括文件适用的国家/地区;安装本地化模块时,数据也会自动创建。

文件类型所需的信息默认已包含在内,因此用户无需填写任何内容。

厄瓜多尔文件类型。

工作流

配置数据库后,您可以注册文档了。

销售文档

客户开票

:guilabel:`客户发票`是电子文档,一经验证即发送至 SRI。这些文件可以根据销售订单创建,也可以手动创建。它们必须包含以下数据:

  • 客户:输入客户信息。

  • 日记账:选择与客户发票打印点相匹配的选项。

  • 文件类型:按此格式键入文件类型 (01)发票

  • 付款方式(SRI):选择发票的付款方式。

  • Products: specify the product with the correct taxes.

Customer invoice for Ecuador.

Customer credit note

The Customer credit note is an electronic document that, when validated, is sent to SRI. It is necessary to have a validated (posted) invoice in order to register a credit note. On the invoice there is a button named Credit note, click on this button to be directed to the Create credit note form, then complete the following information:

  • Credit Method: select the type of credit method.

    • Partial Refund: use this option when you need to type the first number of documents and if it is a partial credit note.

    • Full Refund: use this option if the credit note is for the total invoice and you need the credit note to be auto-validated and reconciled with the invoice.

    • Full refund and new draft invoice: use this option if the credit note is for the total invoice and you need the credit note to be auto-validated and reconciled with the invoice, and auto-create a new draft invoice.

  • Reason: type the reason for the credit note.

  • Rollback Date: select the specific options.

  • Reversal Date: type the date.

  • Use Specific Journal: select the printer point for your credit note, or leave it empty if you want to use the same journal as the original invoice.

Once reviewed, you can click on the Reverse button.

Add Customer Credit Note for Ecuador.

When the Partial Refund option is used, you can change the amount of the credit note and then validate it. Before validating the credit note, review the following information:

  • 客户:输入客户信息。

  • Journal: select the printer point for the customer Credit Note.

  • Document Type: this is the document type (04) Credit Note.

  • Products: It must specify the product with the correct taxes.

Customer Credit Note for Ecuador.

Customer debit note

The Customer debit note is an electronic document that, when validated, is sent to SRI. It is necessary to have a validated (posted) invoice in order to register a debit note. On the invoice there is a button named Debit Note, click on this button to be directed to the Create debit note form, then complete the following information:

  • Reason: type the reason for the debit note.

  • Debit note date: select the specific options.

  • Copy lines: select this option if you need to register a debit note with the same lines of invoice.

  • Use Specific Journal: select the printer point for your credit note, or leave it empty if you want to use the same journal as the original invoice.

Once reviewed you can click on the Create Debit Note button.

Add Customer Debit Note for Ecuador.

You can change the debit note amount, and then validate it. Before validating the debit note, review the following information:

  • 客户:输入客户信息。

  • Journal: select the printer point for the customer Credit Note.

  • Document Type: this is the document type (05) Debit Note.

  • Products: It must specify the product with the correct taxes.

Customer Debit Note for Ecuador.

Customer withholding

The Customer withholding is a non-electronic document for your company, this document is issued by the client in order to apply a withholding to the sale.

It is necessary to have a validated (posted) invoice in order to register a customer withholding. On the invoice there is a button named Add Withhold, click on this button to be directed to the Customer withholding form, then complete the following information:

  • Document Number: type the withholding number.

  • Withhold Lines: select the taxes that the customer is withholding.

Before validating the withholding, review that the amounts for each tax are the same as the original document.

Customer withhold for Ecuador.

Purchase Documents

供应商发票

The Vendor bill is a non-electronic document for your company, this document is issued by your vendor when your company generates a purchase.

The bills can be created from the purchase order or manually, it must contain the following information:

  • Vendor: type the vendor’s information.

  • Bill Date: select the date of invoice.

  • Journal: it is the journal for vendor bills.

  • Document Type: this is the document type (01) Invoice

  • Document number: type the document number.

  • 付款方式(SRI):选择发票的付款方式。

  • Products: specify the product with the correct taxes.

Purchases for Ecuador.

重要

When creating the purchase withholding, verify that the bases (base amounts) are correct. If you need to edit the amount of the tax in the Vendor bill, click the Edit button. Otherwise, from the Journal Items tab click the Edit button and set the adjustment to go where you want.

Purchase liquidation

The Purchase liquidation is an electronic document that, when validated, is sent to SRI.

Companies issue this type of electronic document when they purchase, and the vendor does not issue an invoice due to one or more of the following cases:

  • Services were provided by non-residents of Ecuador.

  • Services provided by foreign companies without residency or establishment in Ecuador.

  • Purchase of goods or services from natural persons not registered with a RUC, who due to their cultural level or hardiness are not able to issue sales receipts or customer invoices.

  • Reimbursement for the purchase of goods or services to employees in a dependency relationship (full-time employee).

  • Services provided by members of collegiate bodies for the exercise of their function.

These types of electronic documents can be created from the Purchase Order or manually from the Vendor Bills form view. It must contain the following data:

  • Vendor: type the vendor’s information.

  • Journal: select the journal for the Purchase Liquidation with the correct printer point.

  • Document Type: this is the document type (03) Purchase Liquidation

  • 文档编号:键入文档编号(序列),只需键入一次,接下来的文档将自动分配序列。

  • 付款方式(SRI):选择发票的付款方式。

  • Products: specify the product with the correct taxes.

Once you review the information you can validate the Purchase Liquidation.

Purchase liquidation for Ecuador.

Purchase withholding

The Purchase withholding is an electronic document that, when validated, is sent to SRI.

It is necessary to have an invoice in a validated state in order to register a Purchase withholding. On the invoice, there is a button named Add Withhold, click on this button to be directed to the Withholding form, then complete the following information:

  • 文档编号:键入文档编号(序列),只需键入一次,接下来的文档将自动分配序列。

  • Withhold lines: The taxes appear automatically according to the configuration of products and vendors, you should review if the taxes and tax support are correct, and, if it is not correct, you can edit and select the correct taxes and tax support.

Once you review the information you can validate the Withholding.

Purchase withhold for Ecuador.

注解

You can’t change the tax support for one that was not included in the configuration of the taxes used on the Vendor Bill. To do so, go to the tax applied on the Vendor Bill and change the Tax Support there.

A withholding tax can be divided into two or more lines, this will depend on whether two or more withholdings percentages apply.

Example

The system suggests a VAT withholding of 30% with tax support 01, you can add your VAT withholding of 70% in a new line with the same tax support, the system will allow you as long as the total of the bases matches the total from the Vendor Bill.

财务报告

In Ecuador, there are fiscal reports that the company presents to SRI. In Odoo, we have two of the main financial reports used by companies. These are the reports 103 and 104.

要获取这些报告,请进入 会计 应用程序,选择 报告 ‣ 报表报告 ‣ 税务报告,然后按 `税务报告 103税务报告 104 进行筛选。

报告 103

该报告包含特定时期的所得税预扣信息,可按月或半年报告一次。

您可以看到报告所需的信息,其中包括基数和税额,还包括括号内的税号,以便向 SRI 报告。

Report 103 form for Ecuador.

报告 104

该报告包含特定时期的增值税税款和增值税预扣税款信息,可以是每月一次,也可以是每半年一次。

您可以看到报告所需的信息,其中包括基数和税额,还包括括号内的税号,以便向 SRI 报告。

Report 104 form for Ecuador.

ATS report

Install the ATS Report (l10n_ec_reports_ats) module to enable downloading the ATS report in XML format.

注解

The Ecuadorian ATS Report module is dependent on the previous installation of the Accounting app and the Ecuadorian EDI module.

配置

To issue electronic documents, ensure your company is configured as explained in the electronic invoice section.

In the ATS, every document generated in Odoo (invoices, vendor bills, sales and purchases withholdings, credit notes, and debit notes) will be included.

供应商账单

When generating a vendor bill, it is necessary to register the authorization number from the invoice that the vendor generated for the purchase. To do so, go to Accounting ‣ Vendors ‣ Bills and select the bill. Then, enter the number from the vendor’s invoice in the Authorization Number field.

Credit and debit notes

When generating a credit note or debit note manually or through importation, it is necessary to link this note to the sales invoice that is being modified by it.

注解

Remember to add all required information to the documents before downloading the ATS file. For example, add the Authorization Number and the SRI Payment Method on documents, when needed.

XML generation

To generate the ATS report, go to Accounting ‣ Reports ‣ Tax Report and choose a time period for the desired ATS report, then click ATS.

The downloaded XML file is ready to be uploaded to DIMM Formularios.

ATS report download for Ecuador in Odoo Accounting.

注解

When downloading the ATS report, Odoo generates a warning pop-up alerting the user if a document(s) has missing or incorrect data. Nevertheless, the user can still download the XML file.