To be able to upload minors via Excel, it is necessary to download-the upload template file that we find a Cupload files i fill in all the fields for a each of the contracts that are entered.

You can download the blank template with only l'column structure o you can download the template for a a specific contracting agency. In this case you will see a l'file filled in the column with l'specified contracting agency, i a more in some fields you will have a drop-down with its possible values.

A An Excel file of instructions is also available, where all the fields are described i their mandatory nature is defined, and the codes a to be entered for the fields in which the coding of the same is necessary are also reported.

General information

When uploading the file, if the “flag” of Cupload with submission a the JCCA is checked, the contracts that are uploaded to the system i that do not have errors will go directly a l'Consultative Board status for a validation.

If you make the submission by unchecking the “flag”, the contracts will also be loaded into the RCP program, but in this case, they will all remain in the Contracting Organization status, i it is necessary to submit them a to the Advisory Board.

In the case of file uploads with errors in which there are also correct contracts, it is advisable to delete the contracts already uploaded correctly from the file at the same time as making the next upload with the corrections. If this is not done, when you return a and try to upload the correct contracts, the system will give you an error message saying that “A contract cannot be modified by a the JCCA”.

In the l'load results section you can see if the load has finished o is pending execution - (loads of up to 200 llines are done instantly), if the load result is correct o with errors i the error result reports i.

In the event that the result of the upload is “with errors” it may be that all the contracts in the file have errors i therefore there will only be an error report o that also contains correct contracts in the file. In this case a more than l'error report there will be a result report indicating which contracts in the file have been uploaded correctly into the Public Contracts Register Pú.

In the case of file uploads with errors in which there are also correct contracts, it is advisable to delete the contracts already uploaded correctly from the file at the same time as making the next upload with the corrections. If this is not done, when you return a and try to upload the correct contracts, the system will give you an error message saying that “A contract cannot be modified by a the JCCA”.

When filling in the data in the Excel template to upload, you must keep in mind:

  • The “type of supply” field must only be reported in the case of supply contracts.
  • The field “pricing method” must only be reported in the case of service contracts.
  • The field “municipality of l'awardee” must be filled in with the INE code (in case you do not know the code of the municipality in question there is a list with all the codes in the municipality tab of the instructions excel)
  • In the case of foreign bidders, the country of l'bidder must be reported i in the field “municipality of l'bidder” must be entered as a code: 99999
  • The term data (in years, months i days) are only mandatory in the case of not reporting the expected end date of execution of the contract.
Common errors when uploading l'excel for minors
  • The Settlement date field is mandatory : If a settlement amount has been indicated, it is mandatory to also inform the date.
  • The Batch Deadline i and the Expected End Date are inconsistent : to avoid problems in the case of deadlines, it is best to put the execution start date i and the end date o as the deadline but not both dates.
  • A contract validated by the JCCA cannot be modified: it is not really an error, simply the contract (o a contract with the same file code) is already reported, via i validated i, therefore, it cannot be a loaded again.
  • L'execution of the contract must begin-and iend in different years : you would need to look at the specific template probably for l'year of execution of the contract that they have put i the rest of the dates.
  • The Country of origin of the product field is mandatory: it refers to a where it was manufactured i is mandatory only in the case of supply contracts
  • The reported municipality does not exist: a valid municipality code has not been reported in the “Municipality of l'awardee” column. S'must report a code of type 17061 from the incorporated a the Municipalities tab of l'excel instructions.
  • The reported NIF/CIF is incorrect: it must not have a NIF/CIF format.
  • Incorrect CPV code: check that there is no blank space at the end of the CPV code.
  • The contract type has an invalid value : it is possible that the contract type field is blank o is not informed with the indicated values a instructions for filling out the excel of minor contracts.
  • L'contract bid amount cannot be lower than a l'award amount excluding VAT for the lot: it is necessary to review the bid amounts iaward to verify that a bid amount lower than the award amount has not been set in any of the contracts in l'excel.
  • The TYPE field of the loaded Excel does not have any of the allowed formats, 'CODE' o 'CODE – Description : check that the contract type field is one of those established in the template (it is necessary to follow the established codings in the Excel instructions that are downloaded from the tool)
  • The ADJUDICATARI PROVINCE field of l'loaded excel does not have any of the allowed formats, 'CODE' o 'CODE – Description ': the province codes are not correct (they do not follow the established codings a the instructions)
  • The field AWARDEE MUNICIPALITY does not have the format 99999; a valid municipality code has not been reported in the column “Municipality of l'awardee”. S'must report a code of type 17061.
  • The sum of the award amounts of the annuities is less than the award amount of the lot ; it must be taken into account that the amounts must be distributed so that the sum of the amounts of the annuities coincides with the reported bid amount. The entire bid amount awarded in the first annuity should not be included.
  • Year of start of execution must coincide with l'year of execution of the contract: it must be taken into account that the problem is not with l'award, but rather that l'year of the start of execution date must coincide with l'year of the year column.
  • The NIF as a mandatory field. In the case of self-employed persons, the NIF is the ID number of the úcontractor.

A take into account (Recommendations):

  • VAT on all invoices for that contract: the settlement date is the date on which payment of the last invoice is approved.
  • Extensions: the minors charge is for reporting minor contracts, not extensions. In fact, minor contracts cannot be extended. Extensions are reported individually.
  • To a upload documents that weigh more than the allowed size (10MB), you must divide-them since it is not possible to compress-them.