2022
Data import can be done either using Data Loader or Import Wizard. For most situations, Import Wizard works in case you don't have heirarchies in GL Account or Item list.
When to use Data Loader
Only when you want to import data with Hierarchy.
Prepare your file
Make sure the Type field matches to the Picklist Value of "Account Type" is AccountingBook. The values are:
Account Type Values
Income
Expense
Equity
Cost of Goods Sold
Other Income
Other Expense
Bank
Fixed Asset
Accounts Receivable
Accounts Payable
Other Current Asset
Other Current Liability
Import data
In case there are hierarchy involved, you can use Apex Data Loader to import the date. See Importing GL Account using Data Loader for more details.
The steps for importing heirarchial data is as follows -
Prepare file
Discount
Group
Sales Tax Item
Sales Tax Group
Other Charge
Expense
Non-Inventory
Income Account
Import data
Item List
Click on Admin/Get Started object
Select the appropriate accounts from the drop down menu
From the dropdown menu select the Default Revenue Account
From the dropdown menu select the Default Cash GL Account
From the dropdown menu select the Default Bank GL Account
From the dropdown menu select the Default CC Account
From the dropdown menu select the Default Revenue Account for Accounts Payable
Once you have Setup the defaults, click on the Save GL Defaults button.
Common Issues Found
What is "Remote Site Settings" ?
Goto Setup> under Security Controls Tab> Click Remote Site Setting.
In the new page click on the New Remote Site button
In the new page save the remote site settings by clicking Save button
Page Layout for Enhanced Entry Screens
One of the most requested features that we have in is a much better data entry screen for Receivable, Payable and Journal Entries. The data entry for standard force.com requires a lot of clicks and so we have created a module that makes it simpler for users to enter these documents.
Once the Remote site is added in the settings, the page layout for needs to be retrieved to do this follow the below steps
The module is a Visualforce component and the component can be re-configured or updated by clicking the "Retreive Page Layout" button on Admin Setup. This retrieve all the Page layout and re-configures the Visualforce component.
On Clicking the button Retrieve Page Layouts the following page pops up and takes you back to the same page
Retreive page layout updates page layouts for edit screens for Receivables and Payables objects to organize all the controls(Field) in one layout. Which enables to either add or remove the feilds from the page layout.
Enable Left side AccountingBook Links
Congratulations, You have completed AccountingBook Setup !!!