Declarations > Fee declaration > France > Processes > TDS 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 infiormation 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.

Managing the 1099 declaration for the multi-site 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 The Service Supplier File-Standard. Compliance with the standard is strict, and there are no controls for this in Sage X3. There are wesites that can be used to download checking tools that should be implemented before submitting the file.
    • http://www.net-entreprises.fr/Html/SpecialEditeursLogiciels.htm
    • http://www.net-entreprises.fr/Html/pre-controle_dadsu.htm

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Presentation

    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

    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_YYYY_SIREN_000_YYYYMMDDHOUR.txt

    • 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

    Close

     

    Fields

    The following fields are present on this tab :

    Selection

    • Test file (field TEST)
    Select this checkbox to generate a test file. The letter "T" is added to the end of the file name.
    • All companies (field ALLCPY)

    Select this checkbox to include all companies. To run this process for a single company, do not select this checkbox.

    • field TDSFLG

    Select this option for the type of 1099 file to generate. Only the normal declaration is possible.

    Grid Companies

    Enter or select the company code.

    DADS-U

    • Group (field GRP)
    Enter the structure for the 1099 file to be used.
    • Type (field TYPFIL)
    This is the type of declaration and cannot be modified.

    Block number 4

    Enter the declaration site issuing the 1099 file. It needs to be one of the companies in the list. 
    • TDS year (field YEA)
    Enter the year for the declaration.

    File generation

    • field TYPEXP
    Select the location where the file is saved:
    Client: on your local machine
    Server: a location on a shared server
    • Back-up directory (field VOLFIL)
    Enter the directory path.

    Close

     

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation