Service supplier file generation

Use this function to generate:

• The Service Supplier File-Bilateral standard
• The 1099 declaration

The 1099 file is divided into two parts:

• Declaration of salaries paid during the fiscal year
• Declaration of fees paid during the fiscal year

You can generate the 1099 file amounts to be declared. Any person who paid fees, commissions, and other remunerations to a third party within the framework of their job must declare all these amounts.

1099 declaration

From the current issuing site, the assigned company of this site is moved up based on the extraction parameters. Typically the 1099 issuing site is the declaring site of the assigned company. This information is used to calculate the S10 segments.

Then, for each company to be processed:

• Based on the extraction parameters linked to this company, this information is used to calculate the S20 segments.
• Segments S70 are built from the extraction of the fee lines.
• Segment S80 ends the company sequence.
• The file ends with segment S90.

Important formatting considerations

As of 2024, the records are separated by a line break at the end of each TBSBI record, which lengthens the file. As a result, you need to modify the file format as described below.

See the PROCÉDURE BILATÉRALE DE TRANSFERT DES DÉCLARATIONS DE SALAIRES ET/OU HONORAIRES SOUS PROCÉDÉ INFORMATIQUE for more details.

Separating records with a line break

Open: Go to > Declarations > Fee Declaration > Others

In the Fee declaration parameters function (GESTFT) and for all TDSBI code records add a technical field with an alphanumeric length of 2 and enter this formula: Chr$(13)+Chr$(10)

• Start Flag
• Company Header (record 010)
• Establishment Header (record 020)
• Fee Lines (record 210)
• Establishment Total + (record 300)
• Company Total + (record 310)

Address format

For the Annual Declarations Collection Information System update, the address much match the postal format exactly. This applies to all address in France including overseas departments (DOM). Overseas territories (TOM) and foreign countries are exempt.

Two important address considerations:

• The postal code and the distribution office are required and must be in the appropriate positions in all records.
• The street number, repetition index (Bis, Ter...), and address supplement are existing details in the fee provider’s record. The type of road, which must follow a strict 4-character coding, is missing.

As a result, you have 2 options without changing the data structure:

Option 1 Adjust the bilateral TDS procedure file settings:

Change the file settings to only provide the 2 required pieces of address information.

In the Fee declaration parameters function (GESTFT), apply the changes in green to the cells of the TDSBI record - fee line.

This same configuration must be applied to the fields in positions 182 to 188 for the TDSBI record – Establishment Header, as well as to the fields in positions 131 to 137 and 288 to 294 for the TDSBI record – Company Header.

Option 2 Adjust the company and site addresses and DAS2 information:

Populate the addresses in the available fields so that this format matches the standardized format. This can be done in the Provider record, or via an export of the providers followed by restructuring of the addresses in a spreadsheet and re-importing.

Adjust the content of the Street number field (STREETNUM) in the Company, Site, and Provider records so that it contains the street number with four digits. For example, if the street number is 16, change it to 0016; if it is empty, fill it with 0000; and so on.

Adjust the content of the Street field (STREET) in the various Company and Site records to ensure it complies with the structure below. Refer to the administration’s documentation for more details. Note that the rules applicable to addresses outside mainland France and the overseas departments (DOM) remain unchanged.

Position	Length	Content	Comment
1	4	Type of road	This must match the postal format exactly.
5	1	= space
6	21	Street name

For the fee provider addresses, adjust the Street number and Street fields in the Fee Provider records as described above.

The standard PRV import/export template allows for the export and update import of fee providers. It may be advisable to make a copy of this template to retain only the necessary information: the provider code and all data related to the address.

Subsequent steps

A standardized management of addresses is essential in exchanges between companies, administrations, and banks. Sage X3 can implement this change, which requires modifying the data structure in upcoming releases of the current version.

As of the 2024 R1 release, the the DAS2 data was restructured by creating the Type of road field, linked to a miscellaneous table. The TDSBI file configuration was updated with the use of this new field and the new formatting.

Managing the 1099 declaration for the multisite option

The 1099 extraction works on the basis of a list of companies supplied upon starting. The extracted fee lines are those that are recorded either directly on the 1099 sites of these companies, or on financial sites attached to these 1099 sites. The site registration numbers should be entered for the latter. In the same way, it should be checked that there are fees to be declared on each of the 1099 sites.

Information on the contractors providing the services

The 1099 declaration conveys information on the contractors that the extractor cannot load from the suppliers. This information should be entered before the 1099 file is generated. It is especially the case for:

• The job title
• Whether the contractor is a physical person, and, if so, the required first and last name
• If there are expenses, refunds, or income in kind

The checks carried out on the 1099 file by the French administration are more extensive than for the Service Supplier File-Standard. Compliance with the standard is strict, and there are no controls for this. There are websites that can be used to download checking tools that should be implemented before submitting the file.

 

Prerequisite

Refer to documentation Implementation

Screen management

Entry screen

This function is used to control and generate the Service Supplier File (TDS).
Two types of Service Supplier File generation are possible:

• Bilateral Service Supplier File
• 1099 file

Service Supplier File

There are new structural rules for the file as of 2024. Each TBSI entry is now followed by a carriage return, this will mechanically lengthen the size of the file.

The file name is generated using this format: PRAAAAMMJJ-HHHHHX.EXT:

• PR: Prefix as defined in the Fee declaration file
• YYYYMMDD: File generation day
• TTTTT: File generation time
• X = "T" if the file is generated in test mode, "" otherwise
• EXT is equal to TDB for the Service Supplier file-Bilateral standard

Another file is created in parallel that is only used for processing: PRYYYYMMDD-TTTTTX.

1099 file

There are new naming rules as of January 2023. You need install the patch to be compliant with these new naming rules.

Two files are generated in the log file according to the naming rules.

You need to full file name, including the extension, to generate the DAS2 report.

The file name is generated using this format

• DASL: hardcoded
• YYYY: the year for the declaration
• SIREN: this SIREN number for the company
• 000: hardcoded
• YYYYMMDDHOUR: the year, month, date, and time of the generation; this matches the date in the log file header
• T: if your run a text generation, a T is added to the end of the file name
• txt: the file extension, that must be included when generating the DAS2 report

Error messages

• Generic messages

The only error messages are the generic ones.

Tables used

Refer to documentation Implementation