• Importing Data

•  Home Page<Get Started<Import GL & Items or Sample
•  Get Started with AccountingBook
•  Setup my AccountingBook<Setup GL Account<Setup Products
•  Import Sample Data (for testing)

...

• Setup GL Account
  
• Setup Products
• Import Sample Company Data
• New Account Type

Importing Data

Data Import- The For Importing the data, there are three options available arenamely:

      A. Setup GL Account under Setup my AccountingBook- You can Import the GL Accounts through this option

...

      C. Import Sample Data- You can Import a sample data to see the flow of AccountingBook-"How it works".            

Setup GL Account 

A. Setup GL Account

...

                      Follow the steps

                       1. Click on Import GL & Items or Sample (Home page)                    

Image Added

 

                        2. Click on Setup my AccountingBook

                     3. Setup GL Accounts

Image Removed
Image Removed

...

Image Added

 

                               

...

                   

                        3. Once you click on Setup my AccountingBook, You will get Three options for importing the GL Accounts

 

                                                           a) Select Industry Type

                                                           b) Import GL Accounts from CSV

                                                           c) Create Manually

Image Added

                                     

 

a) Select Industry Type- Select your Industry Type. Once you select the Industry Type, related GL Accounts will display. Click on save, all the GL accounts will get imported and message will be displayed as

...

“GL Account Details

...

Imported”.

Image Removed 

Image Added

 

b) Import GL Accounts from CSV-

Prepare your file

1. Create a CSV file with the following fields
   1. Account
   2. Type
   3. Description

...

       1. Download the GL Account Import Template

...

 

       2. Fill

...

the following fields

1. 1. 1. 1. 1. Account
            2. Type
            3. Description

       3. Make sure the Type field match to the Pick list Value of "Account Type" in 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

 

      4. Select the file from Choose file button. The data will display once the file is selected

      5. Click on Import GL Accounts, all the GL accounts will get imported and message will be displayed as "GL Account Details Imported.

...

Image Added

c) Create Manually- Link is given which will directly take you to GL Accounts tab, wherein GL Accounts can be created manually

Image RemovedImage Added             

Setup Products

...

B. Setup Products

...

Image Removed

...

                      Once you click on Setup Products, You will get Two options for importing Product

                                                        a) Import Products from CSV

                            b) Create Manually

 Image Added 

a) Import Products from CSV-

Prepare your file

...

      1. Download the Product Import Template

      2. Fill the following fields

a)  Name

b)  Price

c)  Income Account

d)  Type

e)  Cost

f)   COGS Account

g)  Description

            "Product Import Template is available for Download"

      2. Fill each columns with the related data

...

       3. Make sure the Type field match to the Pick list Value of "Type" in AccountingBook. The values are:

• • • • Service
      • Non-Inventory
      • Inventory
      • Payment
      • Discount
      • Group
      • Sales Tax Item
      • Sales Tax Group
      • Other Charge
      • Expense

      4. Select the file from Choose file button. The data will display once the file is selected

      5. Click on Import Items, all the items will get imported and message will be displayed "Products Import Successful".

Image Removed 

Image Added

b) Create Manually- Link is given which will directly take you to Items tab, wherein Items can be created manually

Image Removed

           Image Added

Import Sample Company Data

C. Import

...

Sample Company Data

...

1. For testing purpose, download the sample data.

2. Click on import Sample Data and then click on Import. All the data will get imported and message will be displayed "Sample Data Import Successful".

Image Added

3. The sample data imported can be deleted by using Delete option

4. For Delete option go to Admin/Get Started Tab, at bottom there is button "Mass Delete Records"

5. Once you click on "Mass Delete Records", all the records except Account will get deleted.

    Warning- "careful before you click on Mass Delete Records".

6.This delete option will be available to all the users initially. But if you want this option only for the Admin user, it can be blocked by a trigger for the other users.

Image RemovedImage Added Image Removed

New Account Type

              You can add the following Account types manually:          

1. 1. Inventory
   2. Deferred Tax Asset
   3. Investments
   4. Deferred Tax Liability
   5. Long Term Liability
   6. Credit Card- Credit Card as an Account type is added in the Refund screen as well as under GL account field for Bill Payment Object. This will allow to process Refund and make payment through Credit Card as well apart from Bank.
      
      
       Note: Make sure that the naming convention is same as mentioned above.
   
      To add new Account types, follow the steps:
2.       1. Click on GL Accounts Object
3. Image Added

1.      2.Expand Force.com Quick Access Menu
2. Image Added

1.      3. Click on View fields
2. Image Added

1.      4. Click on Account Type
2. Image Added

               5. Click on New tab and enter the new Account type name therein

Image Added