| Info | ||
|---|---|---|
| ||
Conciliation of registries functionality will be available in the next release 1.7.9 |
Through the conciliation of registries, we will be able to obtain a comparison of the registries found in the Inland Revenue against the registries found in Dashboard.
Also, we will be able to locate registries with differences and orphans
| Info | ||
|---|---|---|
| ||
It will be necessary to configure from the Advanced Configuration tile, the new endpoints for Concilia It will be necessary to configure from the tile Management of Origins and Societies, section Societies, the Administration in each society to be able to reconcile. If a company applies to both Agencies (AEAT and Canary Islands) it will be necessary to configure the Administration with value = AEAT. The name and NIF of the company must be exactly the same as those sent to the Tax Agency. |
Accessing the Conciliation of Registries Tile, we will obtain the list of conciliations carried out
- Status - Status with which the reconciliation has ended: With errors / In progress / Completed with differences / Completed without differences
- Concilia ID: Sequential number that identifies the conciliation number.
- Origin: Origin from which the conciliation comes
- Company: Company from which the conciliation originates
- Version: Conciliation release. Currently available and default V 1.1
- Administration: Tax Agency to which the company is assigned (The Administration of the companies is managed through the Tile of Management and Origins of Companies and its completion is a mandatory requirement for the proper execution of the conciliation).
- Book: Type of conciliated book. Currently available books:
- Invoices issued
- Incoming invoices
- Investment Goods
- Intra-Community operations - Period: Conciliated period
- Year: Conciliatory Exercise
- Accounting differences: It will show the general data of the conciliation as well as the accounting differences that would have been detected in each case.
...
From the main screen of the tile pressing the button 
will show a pop up where we will introduce the data of the conciliation to make
...
When the selected company applies to both Agencies, pressing the button 
will show a pop up where we select the Agencies to concilate.
Once the selection has been made and confirmed, the conciliation(s) will be displayed on the monitor.
- SETTLEMENT ENDED WITH DIFFERENCES
The conciliation will be displayed with the status finished with differences on the monitor
In a conciliation with status Finished with differences, if we click on the button will show a pop up with the following information:
From the accounting differences we can see the differences in terms of totals, tax bases and fees passed on and borne
A pop-up will be shown with detailed information and the differences between the Administration and the Dashboard
In the section of Accounting Differences, we will be able to see the sum of the amount of the registers that are in the Tax Agency, the sum of the registers of the Dashboard and the difference between both.
We will be able to display both the Tax Base and the quotas to see the detail of the amounts by types of indicators.
We will be able to navigate to the detail of the conciliation. Clicking on it will show the following information:
We will be shown a screen with two tabs that we detail below:
- REGISTRIES WITH DIFFERENCES AND ORPHANS
From this view, we will be able to identify the following data:
- With some difference- Registries located in the detail of differences from the conciliation list
- Orphan - Registries that are in the Administration because they were manually registered but are not in the Dashboard.
- Dashboard status - State in which the record in the Dashboard is located
- Administration status - State in which the registration with the Tax Agency is located
...
Pressing the button 
we will be able to filter by the registries with differences or by orphan registries.
m
Concilia will make a comparison of the fields indicated in the attached table, leaving the rest of the fields outside the comparison:
Field to compare |
|---|
| Expedition date |
| Exercise |
| Period |
| Amount |
| Counterpart ID |
| Name reason counterpart |
| Accounting record date |
| Deductible fee |
| Counterparty Type ID |
| Special regime |
| External reference |
| Record type |
| Record subtype |
| Tax rate |
| Tax base |
| Fee passed on |
| Supported fee |
| Equivalence surcharge rate |
| Equivalence surcharge fee |
| REAGYP compensation percentage |
| REAGYP compensation amount |
- REGISTRIES THAT DO NOT EXIST IN THE ADMINISTRATION
...
Pressing the button 
will show an informative pop up to indicate us the system will navigate to the tile of Creation of batches to carry out the correction of the registry.
Pressing the button to navigate to the Batch creation screen
...
The treatment of the registry at this time is the same as that indicated in the section Batch Creation.
- MASSIVE SYNCHRONIZATION
The functionality of mass synchronization of records with differences or orphans is added. We can do it through the Mass Synchronization button
The system will display the following message
Once we press Synchronize, the system will create the records and batches marked as Orphans in the Dashboard from the information obtained from the Tax Agency. Likewise, the records that show differences will be overwritten in the Dashboard and updated with the data obtained from the Tax Agency.
We will visualize an informative pop up of the number of records created and the number of records modified
The records will automatically be marked with the Reconciled check to determine that they have been manually synchronized from Dashboard
What we achieve with this action is to create entries that have been previously registered in the AT manually and give consistency to those records that have also been modified manually in the AT to avoid inconsistencies in the reconciliation
We can identify the records and batches created by the mass synchronization process as follows:
All records will be marked with Book - Check Invoices Issued or Invoices received in each case
The external label of the batch will be generated with the structure: DASH_CONCILIA_202X_XXXXXX
