Understanding Setup for GL Accounts for SPED Accounting

You must associate your GL accounts with a government recognized chart of accounts. Depending on your business, you might associate you GL accounts to the chart of accounts from the Secretaria da Receita Federal or the Banco Central do Brasil.

To set up your GL accounts with associations between your GL accounts and the government chart of accounts (referential accounts):

1. Import or manually add the referential accounts.

   You use the Referential Chart of Accounts program (P76B920) to import, manually add, or modify records for the referential chart of accounts. The system saves the referential chart of accounts to the Referential Chart of Account table (F76B920).

2. Import or manually add associations between your GL accounts and the referential accounts.

   You use the Ref Accounts by Account program (P76B926) to import, manually add, or modify the associations. The system calls the Ref Accounts by Account program from the Brazil Account Information program (P76B925). The system saves the data for the associations to the Ref Accounts by Accounts - BR table (F76B926) and Brazilian Account Information table (F76B925).

3. Import or use a global update function to group your accounts by type.

   You use the Brazil Account Information program to assign values from the Account/Group type code (76B/GA) UDC table to your GL accounts. The system saves the account group information to the Brazilian Account Information table (F76B925). The system uses the group type codes to determine which accounts are used for assets, liabilities, and so on.

4. Manually add associations between main accounts and related sub-accounts (Contas Correlatas).

   You can use the Related Accounts Revisions form in the Brazil Account Information program (P76B925) to manually add or modify associations between a main account and related sub-accounts. You can only associate existing accounts in your GL chart of accounts that are posting accounts.

   You must assign a unique account group ID code to every group formed by a main account and its related accounts. You must also identify each related account according to the list of nature codes that the fiscal authority provides listed in the Sub-Account Nature Code UDC table (76B/NC).

   The system saves the data for the associations to the Related Accounts - 7AB - BRA table (F76B927) and includes the accounts that you set up as related accounts in the register I053 when you work with Accounting SPED reports.