Show TOC

Procedure documentationCreating Files

 

You use this procedure to create electronic accounting files as required by the Brazilian tax authorities.

Prerequisites

Before you execute the SPED ECD (electronic accounting file) report, you must

  • Make the settings described in Customizing for SPED ECD.

  • Perform the year-end-closing postings using the closing document type that you created for this specific purpose.

Procedure

To generate the file, enter the following data on the selection screen, as required:

  1. In the General Data group box, specify the company code the accounting file relates to, the fiscal year, the period the report will cover and the relevant ledger. For Bookkeeping B, specify the special ledger.

    Note Note

    The information for ledger is only relevant if the New General Ledger is active in the system.

    If you specify a ledger which has a fiscal year variant that is different from the one assigned to the company code, the system considers the fiscal year variant of the ledger. This setting also overrules the period selection.

    End of the note.

    The report processes all accounts maintained for the company code. You can define a different selection in the GL Account field.

  2. The File Creation Control group box contains the following tabs:

    • File Parameters

      Specify the parameters that control how the report creates the file, for example, the Accounting Bookkeeping Type that determines which registers appear in the output file and which do not.

      Caution Caution

      Note that if you restrict the range of accounts, it can cause unbalanced documents because the total credit and debit could differ. The restriction can also cause the total amount of the document shown in register I200 to differ from the sum of the lines shown in register I250.

      End of the caution.

    • Special Situation

      Specify the indicator, the initial date and the final date of the special situation.

      Note Note

      You fill out this tab only if the special situation occurred during the posting period.

      End of the note.

    • Closing Data

      Specify the document type used for closing activities, as well as the date that the closing occurred.

      Note Note

      You fill out this tab only if you are executing the report for a posting period that includes the closing period.

      End of the note.

    • Output File

      Specify where the file is going to be saved.

      Select the Test Output on Screen option to run the report in test mode. In test mode, no file is created.

      Note Note

      If you want to view a list of the possible directories to store the file in the application server, go to transaction AL11.

      Use transaction CG3Y to transfer the file from the application server to the presentation server, specifying the same path you entered in the option Write to Application Server of the selection screen.

      End of the note.

      Caution Caution

      If you execute the report in the background, you cannot choose the option Write to Local File.

      End of the caution.

  3. The Input Data group box contains the following tabs:

    Note Note

    The data you enter in this group box specifies the content of particular fields that appear in the output file.

    End of the note.

    • Company Data

      Specify official information of your company.

    • Accounting File Data

      Enter the number and the purpose of the journal.

    • Accounting Statement

      Enter information related to the identification of the accounting statement.

    • Attachments

      Attach the file containing complementary information, such as notes to the financial statements.

      You can attach a single file or multiple files. To attach multiple files, specify the directory where the files are stored.

      Note Note

      The report supports only files in the RTF format. If the report is executed in the background, the .rtf file must first be uploaded to the application server using the transaction CG3Z.

      On the test output on screen, only the first line of the attached file is displayed.

      End of the note.

    • Subledgers

      Note Note

      The tab is only available for bookkeeping types R and B.

      End of the note.

      Enter the number and the hash code of the subledger books.

      Note Note

      You can only enter values for the subledgers customized in the Subledgers view cluster. The number of possible subledgers is limited on the selection screen to 10. To fill the number and the hash code for more subledgers, use the method FILL_REGISTER_I012 of BAdI BADI_J_1BECD.

      End of the note.

Result

  • Account selection and display

    All of the accounts reported in the file are defined for the company code. The structuring of the accounts is based on the financial statement version (FSV). You can restrict the accounts to those defined in the FSV selecting the Show Only Assigned Accounts checkbox.

    If you need to report alternative account numbers, select the Alternative account number checkbox.

  • History

    Every time you execute the report, a history log is created. To view the history, choose the File History pushbutton in the application toolbar.

  • Error Log

    You access the error log through the File History pushbutton. If an error is found during the execution of the report, there will be a red flag in the ECD Log column in the file history, indicating that the file was created, but there was an error during its creation that requires attention.