Page History

GL Accounts
What are GL Accounts?

A general ledger contains user-defined account codes and related dimensional codes for recording different types of vouchers, invoices including on-balance-sheet, off-balance-sheet, post-balance sheet, financial and non-financial natures of Accounts.

...

If the Accounts are maintained by your organization are in the hierarchy method, to put it in other words if the accounts are in the parent-child relationship in a large number we need to use data loader to upload those accounts to the AccountingBook.
If you are setting up AccountingBook instance in sandbox or in SalesForce you need to have CSV files of the required data to be imported to the AccountingBooksAccountingBook. Open Data Loader package and click on the Insert button.

...

To proceed further you need to enter the credentials of your Sandbox or SalesForce in which the AccountingBooks AccountingBook is installed.

The next step is to select the object to which the data needs to be imported.

...

As we are setting up the AccountingBook the first thing we need to setup is GL Accounts or the Chart of Accounts, select GL Accounts from the SalesForce object from the given list. Browse the CSV file of Chart of Accounts which needs to be uploaded to the AccountingBooksAccountingBook.

Once you have selected the CSV file to import click on Next.

The App shows the number of records it is about to import into the AccountingBooks AccountingBook and you are suppose to click on OK button.

...

The last step is to finish the activity by clicking on the Finish button.

Click on OK button to conclude the operation of importing data to the GL Accounts of the AccountingBooks package. But this will only add the accounts to the GL Accounts.

To add hierarchy or the parent-child relationship to the accounts you need to export the GL Accounts data to the CSV file and identify the SalesForce ID. The second step is to identify the SalesForce IDs of the Parent accounts to map those to the Child acountsChild accounts. Insert Parent Account IDs next to the Child Account Names in the CSV file by V-lookup operation. Once you have the IDs of the Parent Accounts in CSV, you can perform the update operations on GL Accounts and map those respective parent accounts using Data Loader.