/
b+ LROE Conciliation ALV

b+ LROE Conciliation ALV

Access the Conciliation Monitor, where the system will display a screen with all the reconciliations corresponding to the previously performed filtering:

After execution, the system will display a screen with all the reconciliations corresponding to the previously performed filtering:

 

image-20240425-135226.png

 

The list of fields displayed will depend on the type of query selected in the filtering screen. For invoices issued with and without SG, the layout of the fields will be the same, but in the case of invoices received, some of these fields will be different.

The fields that will apply for each type of query are shown below.

 

Field

Type of conciliation

Description

Comments

 

Field

Type of conciliation

Description

Comments

 

Concilia ID

All

Sequential conciliation number.

 

 

Differences

All

If it appears with a green check, there is no difference.

If it appears with the exclamation mark, there are differences.

The differences icon will be navigable and will show us a screen where we will visualise the detail of the differences by different categories.

the detail of the differences by different categories will be displayed.

For more details, see the section Conciliation differences.

 

Company

All

Company for which the conciliation is carried out.

 

 

Type of enquiry

All

Type of consultation for which the conciliation is carried out.

 

 

Fiscal year

All

Financial year for which the conciliation is carried out.

 

 

Status

All

Status at the end of the conciliation performed. It is identified by colour:

Green - Conciliation completed

Yellow - Conciliation in process

Red - Conciliation not completed due to an error in the process. Allows the option to Restart

 

Log

All

Log generated by launching the conciliation.

The log icon will be navigable only in cases where the conciliation is in error status.

It will navigate to SLG1 and show the log generated in each case.

 

Date of issue from

All

Initial date of issue of the invoices taken into account for the conciliation.

 

 

Date of issue up to

All

Final issue date of the invoices taken into account for the conciliation.

 

 

Data received from

Received

Date of initial receipt of incoming invoices taken into account for reconciliation

These dates only apply and will be taken into account for invoices received.

 

Data received to

Received

Date of final receipt of incoming invoices taken into account for reconciliation

 These dates only apply and will be taken into account for invoices received.

 

Total AT

All

Sum of the gross amounts of all invoice items registered in the TA.

The total TA amounts of the invoices registered in the tabs

TA/SAP Differences - Orphans and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Total SAP

All

Sum of the gross amounts of all invoice items recorded in SAP.

The total SAP amounts of the invoices registered on the tabs

TA/SAP differences - SAP documents without TA and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Difference total amount

All

Difference between total TA and total SAP.

 

 

TA tax base

All

Sum of the taxable amounts of the invoices registered in the TA.

The TA tax base amounts of invoices registered in the tabs

TA/SAP Differences - Orphans and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

SAP tax base

All

Sum of the taxable amounts of the invoices registered in SAP.

The SAP tax base amounts of the invoices registered in the tabs

TA/SAP differences - SAP documents without TA and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Difference taxable base

All

Difference between the AT tax base and the SAP tax base.

 

 

VAT charged TA

Issued

Sum of the VAT shares of the items of the invoices registered in the TA.

The AT Reckoned VAT amounts of the invoices registered in the tabs

AT/SAP Differences - Orphans and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

VAT charged SAP

Issued

Sum of the VAT shares of the items of the invoices registered in SAP.

The SAP Reckoned VAT amounts of the invoices registered in tabs

AT/SAP differences - SAP documents without AT and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Difference VAT charged

Issued

Difference between AT Reckonable VAT and SAP Reckonable VAT.

 

 

VAT borne TA

Received

Sum of the input VAT shares of the invoice items registered in the TA.

The AT Input VAT amounts of the invoices registered in the tabs

AT/SAP Differences - Orphans and Documents consulted without differences.

Invoices marked as cancelled are not taken into account for the calculation of the ALV amount.

 

VAT borne SAP

Received

Sum of the input VAT shares of the invoice items registered in SAP.

The SAP Input VAT amounts of the invoices registered in the tabs

AT/SAP Differences - SAP Documents without AT and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Difference VAT borne

Received

Difference between AT Input VAT and SAP Input VAT.

 

 

Amount not subject to TA

Issued

Sum of the non-subject amount of all invoices registered in the TA.

Non-AT amounts of invoices registered in the tabs

TA/SAP Differences - Orphans and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Amount not subject to SAP

Issued

Sum of the non-subject amount of all invoices registered in SAP.

The non-SAP subject amounts of the invoices registered in the tabs

TA/SAP differences - SAP documents without TA and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Difference non-subject amount

Issued

Difference between the AT non-taxable amount and the SAP non-taxable amount.

 

 

Deductible VAT TA

Received

Sum of the deductible amount of incoming invoices registered in the TA.

The AT deductible quota amounts of the invoices registered in the tabs

TA/SAP Differences - Orphans and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Deductible VAT SAP

Received

Sum of the deductible amount of incoming invoices registered in the TA.

The SAP deductible quota amounts of the invoices registered in the tabs

TA/SAP differences - SAP documents without TA and Documents consulted without differences.

Invoices marked as cancelled do not count for the calculation of the ALV amount.

 

Difference deductible VAT

Received

Difference between AT deductible VAT and SAP deductible VAT

 

 

Date of dispatch

All

Date on which the conciliation was performed.

 

 

Time of dispatch

All

Time at which the conciliation took place.

 

 

User sending

All

User who performed the conciliation.

 

 

We will have access to the following functionalities:

TABLE OF AVAILABLE STATUS AND FUNCTIONALITIES BY STATE

ICON

STATUS

ARCHIVE

DELETE

DISCARD

RESTART

ICON

STATUS

ARCHIVE

DELETE

DISCARD

RESTART

Complete

X

X

 

 

With error

 

 

X

X

In progress

 

 

X

 

Discard

X

X

 

 

Delete

X

 

 

 

ARCHIVE

It will allow the filing of conciliations in COMPLETE, DELETED or DISCARDED status.

After selecting the relevant lines and clicking on the Archive button, the system will display a message confirming the action.

The "Archived" conciliations can then be consulted from the filtering screen by ticking the archiving checkbox:

 

 

From this screen, archived conciliations can be retrieved to reappear on the main Concilia monitor by selecting the conciliations and clicking on the Unarchive option.

The system will display a message confirming the action.

DELETE

It will allow the deletion of conciliations in COMPLETE OR DISCONTINUED status. This action is irreversible.

After selecting the corresponding lines and pressing the Delete button, the system will display a pop-up to confirm the action.

Once accepted, a message confirming the deletion of the conciliation will be displayed and it will disappear from the list of conciliations

The icon in the status field is modified to identify conciliations in Deleted status.

DISCARD

It will allow to discard the conciliations that are in status IN PROGRESS OR IN ERROR.

After selecting the corresponding lines and pressing the Discard button, the system will display a message confirming the action.

The icon in the status field is modified to identify reconciliations in Discarded status.

RESTART

It will allow re-launching the execution of the reconciliations that are in status WITH ERROR.

After selecting the corresponding lines and pressing the Restart button, the system will display a message that the reconciliation is being launched in the background again. Once the process has been completed, the reconciliation may end correctly or again with error, if the error has not been rectified.

 

NEW CONCILIATION

Allows you to launch reconciliations based on the selected criteria.

After clicking on the New reconciliation button, and selecting as reconciliation type Invoices issued with guarantor software 1.1 or Invoices issued without guarantor software 1.2, a screen with the following fields will be displayed:

 

In the case of selecting as Reconciliation type - Invoices received, the following fields will be enabled to launch the query to the Tax Agency.

REFRESH

The data on the screen will be updated.

 

 

 

 

 

Avvale 2024