Generation of the Bookkeeping of Layout 9 - ECD - Bookkeeping Center - CTBS001- Managerial Accounting - P12

INDEX

01. OVERVIEW

This documentation aims to assist in the generation of the ECD layout 9. For this layout, the following records were changed:

• Record I051; 
• Record I157

For more information on layout 9.00, access the documentation: ECD_SPED_CONTABIL_Alteracoes_para_Leiaute_9_00

02. EXAMPLE OF USE

In the Bookkeeping routine (CTBS001), enter, in the question "Has the chart of accounts changed? 1-Yes"

In Record 0000, the bookkeeping information must be generated for changing the mapping of the chart of accounts. (Field 22 of record "0000")

From the period displayed, if the codes of the internal chart of accounts are changed, this field must contain the indicator = 1 (changes occurred).

In the Autom. Accounting Entries routine (CTBA102) in Other Actions > Balance Transf. Entry, enter the previous ledger account and its balance indicator.

The I157 record should be used to enter the balance transfers from the analytical accounts of the previous chart of accounts plan to the analytical accounts of the new chart of accounts when accounting entries are not made transferring the balance from the old analytical account to the new analytical account in records I200 and I250. 

Thus, Record I157 should be generated with the information of the previous ledger account or cost center.

In the Chart of Accounts routine (CTBA020), in the Referential Chart of Accounts grid, enter only one referential account for a bound cost center.

If the same cost center is linked to different referential accounts, the system will present a validation message when generating a revision through the Bookkeeping Center routine(CTBS001).

Record I051 implies that a ledger account (I050)/cost center (I051) can only be mapped to a referential account. This means that each cost center of a ledger account must match only one referential account.

The preconditions of this routine comprise:

• Having an annual or quarterly accounting calendar;(CTBA010)
• Having a referential chart record (CTBA025)
• Having a cost center record (CTBA030)
• Having a record of accounting entries (CTBA102)
• Having a managerial view record;(CTBA161)
• Having ledger configuration binding (CTBA130);
• Performing the calculation of the annual or quarterly results (CTBA211);
• Having the XML of layout 9 in the correct folder.

03. Step by step - ECD - CTBS001 

This routine consists of extracting data 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 In the step of "Enter the data of the company chosen for bookkeeping", pay attention to the following parameters:

1. 1. Bookkeeping Type? With centralization (centralized bookkeeping) or without centralization (Decentralized bookkeeping)

b. A change occurred in the chart of accounts? 1-Yes or 2-No   

c. Binding with a referential chart? 1-Yes or 2-No  

4. Follow the steps by filling in the options according to the status of the company to be booked

5. Click Finish 

6. Select the generated Revision, Generate TXT File

After the file is generated, check that records 0000, I051, and I157 are displayed correctly.

04. Example of Completion

|0000|LECD|01012015|31122015|TEST COMPANY|11111111000199|AM||3434401|99999||0|1|0||0|0||N|N|0|1|1|

Field 01 - Type of Record: 0000

Field 02 – File Identification: LECD

Field 03 – Start Date: 01012015 (corresponds to 01/01/2015)

Field 04 – End Date: 31012015 (corresponds to 31/12/2015)

Field 05 – Business Name: TEST COMPANY

Field 06 – EIN: 111111111000199 (corresponds to 11.111.111/0001-99)

Field 07 – State: AM

Field 08 – State Registration: In the example, there is no state registration. Therefore, the field was left blank.

Field 09 – City Code 3434401

Field 10 – City Registration: 99999

Field 11 – Special Status: In the example, there is no special status. Therefore, the field was left blank.

Field 12 - Status Indicator at the Beginning of the Period: 0 (corresponds to the beginning of the regular period, on the first day of the year - 01/01/2015)

Field 13 - NIRE Existence Indicator: 1 (Company has registration in the Commercial Board)

Field 14 – Bookkeeping Purpose Indicator: 0 (Original Bookkeeping) Annex to the Cofis Executive Declaratory Act in the 64/2019 ECD Update Layout 8 Guidance Manual: November 2019

Field 15 – Replaced Bookkeeping Hash: Since the bookkeeping is original (field 14), there is no need to enter the hash of the replaced bookkeeping.

Field 16 – Company is not subject to independent audit.

Field 17 – ECD of company not participating in SCP with an ostensive partner.

Field 18 – SCP Identification: none.

Field 19 – Functional Currency Identification: N (No)

Field 20 – Identification of Consolidated Accounting Bookkeeping: N (No)

Field 21 – This indicates the booking mode: centralized or decentralized. 0 (Centralized Booking).

Field 22 – This indicates a change in the chart of accounts. 0 (No change in the chart of accounts).

Field 23 – Code of Referential Chart of Accounts 1 (Legal Entity in General – Taxable Income).

Record I051

Example generated in the .txt file

|I050|01012020|01|A|1113|111|CaixaZ

|I051|123|101010102 (Branch Cash Reg.)

|I051|456|101010102|I051|789|101010102

I051||11100009|

Field 01 – Type of Record: I051

Field 02 – Cost Center Code: none.

Field 03 – Code of Chart of Accounts according to the Referential Chart of Accounts: 11100009.

Record I157

Example generated in the .txt file

|I150|01012020|31012020
|I155|1.01.01.02.03||400,00|D|500,00|500,00|400,00|D|
|I157|1.01.01.02.98||400,00|D| 

I157|2328.1.0001||1000,00|D|

Field 01 – Type of Record: I157

Field 02 – Code of Previous Chart of Accounts' Analytical Account: 2328.1.0001

Field 03 – Code of the Cost Center of the Previous Chart of Accounts: none

Field 04 – Initial Balance Value for the Period: 1,000.00 (corresponds to 1,000.00)

Field 05 – Indicator of Initial Balance's Status: D

05. TABLES

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