Páginas filhas
  • Substitute Bookkeeping Generation - ECD - Bookkeeping Center - CTBS001 - Managerial Accounting - P12

INDEX

01. OVERVIEW

Record J801: Verification Term to replace the ECD. It must be used when replacing an ECD file as stated in the RFB Normative Instruction no. 1,420/2013.

02. EXAMPLE OF USE

The entity must complete file J801 – Verification Term for ECD Replacement Purposes – detailing the errors that gave cause for replacement with the following information:

I – Identification of the bookkeeping replaced;

II – detailed description of errors;

III – clear and precise identification of records containing errors, except when these are due to another error already detailed;

IV – express access authorization by the Federal Accounting Council to information relevant to the modifications; and

V – a description of the pre-agreed procedures carried out by independent auditors, where appropriate, and when deemed necessary.


The Verification Term for Replacement Purposes must be signed (signer's data shall be completed in record J932, with signer's qualification codes 910 or 920), with the preponderant replacement purpose code (field available from layout_7) attached to an ".RTF" document saved (in RTF format) to be entered in the Bookkeeping Center Wizard.


The prerequisites of this routine comprise:

  • Registration of the accountant (CTBA015) with qualification code 910 or 920
  • Type the document you want to attach in Word, saved as RTF

03. BOOKKEEPING CENTER - ECD - CTBS001 

This screen makes up the data extraction from the ECD bookkeeping. 

1.Access the Managerial Accounting Module (SIGACTB) >Updates > Acct Bookkeeping > Bookkeeping Center (CTBS001)

2. Select the ECD option, and click Add.

3. Follow the steps by filling in the options according to the status of the company to be booked, paying attention to the following parameters:

3.1) Enter the indicator of the bookkeeping purpose 1-Substitute

3.2) Enter the Hash field of the Substitute Bookkeeping

4. In the ECD Replacement Term question, enter the .rtf file

5. In the Replacement Purpose question: Enter the code of the reason for the replacementAfter the file is generated, check the J801 record with the.rtf file, Document Type, and the replacement code.




04. SCREEN 


Example of completion:


|J801|001| Verification Term for ECD Replacement |001|1234567890ABCDEFABCDEFABCDEFABCDEFAB123456790|{\rtf1\ansi\ansicpg1252\uc1...|J801FIM| 

Field 01 – Record Type Identification: J801

Field 02 – Document Type: 001

Field 03 – Document Description: Verification Term for ECD Replacement

Field 04 – Replacement Purpose Code: 001 (Changes in account balances that cannot be made through extemporaneous entries).

Field 05 – Hash of the file added: 1234567890ABCDEFABCDEFABCDEFAB1234567890|.

Field 06 – Sequence of bytes representing a single file in Rich Text Format (RTF): {\rtf1\ansi\ansicpg1252\uc1...

Field 07 – Identification of the end of the file: J801FIM.




IMPORTANT!

The Replacement Purpose Field (CSF_MOTSUB) is only available from ECD layout 7.0

05. TABLES

Table From/To - CTx tables for CSx for ECD preparation

Functionality/Export

Accounting Source Tables

ECD Tables

Use Generic Function for Accounting Balance Extraction*

Company Data/ECD

SIGAMAT.EMP - Companies/Branches

CS0 – ECD – Revision
CS1 - ECD - Additional Revision Information
CS2 - ECD – Companies  
CSZ - ECF - ECF DATA                             

No

Ledger Account

CT1 - Chart of Accounts

CS3 - ECD - Chart of Accounts

No

Cost Center

CTT - Cost Center

CS5 - ECD - Cost Center

No

Reference Account

CVD - Referential Chart of Accounts

CS4 - ECD - Reference Chart of Accounts

No

Statement Management Plan

CTS - Management View

CS6 - ECD - Managerial View / Account

No

Default History

CT8 - Default History              

CS7 - ECD - Default History

No

Signee

CVB - Accountant Data

CS8 - ECD – Accountants

No

Participant

CVC – Participants

CS9 - ECD – Participant

No

SCP

CVS – SCP Record

CSR - SCP Bookkeep. - Rec. 0035         

No

Auditors

CVR - Auditors File       

CSP - Auditors Bookk. - Rec. J935   

No

Co-related Sub-accounts

CVT - Co-related Sub-accounts

CST - Co-related Sub-accounts Book.   

No

Accounting Transactions Export

CT6 - Batch Totals (P11)
CTC - Document Balances (P12)
CT2 - Accounting Entries         

CSA - ECD - Transactions Headers

CSB - ECD - Transactions items  
CSL - ECD - Referential transactions items

No

Export Trial Balances/Balances

CT7 - Chart of Accounts Balances (P11)
CT3 - Cost Center Balances (P11)
CT7 - Charts of Accounts Balances (P12)
CQ2 - Cost Center Balances (P12)

CSC - ECD – Trial Balance

CSK - ECD - Reference Account Balance

Yes

Accounting Statements:
ECD Balance sheet/ECD Income Statement/ECD DMPL

CTS - Management View
CTN - Accounting Ledgers Configuration 
CT7 - Chart of Accounts Balances (P11)
CT3 - Cost Center Balances (P11)
CT7 - Charts of Accounts Balances (P12)
CQ2 - Cost Center Balances (P12)

CSD - ECD - Balance Sheets header      
CSE - ECD - Balance Sheets items          
CS6 - ECD - Managerial View / Account 

Yes (use of managerial view)

Export of .rtf Files


CSF - RFT Balance Sheets ECD 300b

No