Importing Data

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.

Data Import using Import Wizard

GL Account

Prepare your file

1. Create a CSV file with the following fields
   1. Account Name
   2. Account Number
   3. Type
   4. Balance
   5. Description
      
2. Fill each columns with the related data

3. 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

• Go to Setup -> Data Management (Left nav) -> Import Custom Object -> Start Import Wizard
• Follow steps to map your CSV fields to the GL Account Fields
• Import all data

Item List

Data Import using Data Loader (use when Hierarchy import is needed)

Importing GL Account using Data Loader

• Add all Parent GL Accounts
• Export all GL Accounts with Parent Salesforce Ids.
• Update your CSV import files and add a column "ParentAccountId". Update the ParentAccountId field with the related Ids. In Excel, you can use VLOOKUP to relate parent accounts.
• Use data loader to upsert all records, make sure you have added the ParentAccountId to point to the Parent GL Account field.
• Repeat for each level of GL Accounts

Item List

Configuration

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.

Remote Site Security Setting

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

Add that in Remote Security setting with name – "Instance"

Copy the first part of the URL address to the Remote Site URL. Refer the underlined URL in the picture

Click on Save button, it looks as below once saved

Once the Remote site is added in the settings, the page needs to be retrieved to do this follow the below steps

Click on the Admin/Get Started object, scroll down to Retrieve Page Layouts related detail and click on the button Retrieve Page Layouts 

Update Configurable Page Layouts

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.

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.

QuickLinks to Accounting Functionality

Enable Left side AccountingBook Links

Goto Setup menu

Click on Customize

Click on Home

Click on Home Page Layouts, a new page gets open

Click on the Edit link to open a new page

Tick the check box and close the page, this will create a short cut in the AccountingBook home page the links will take you to the statement of accounts. Refer picture below, each one is the link which will open up as described

Congratulations, You have completed AccountingBook Setup !!!