Importing Data

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

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

B. Setup Products under Setup my AccountingBook- You can Import the Products 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)

2. Click on Setup my AccountingBook

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

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

b) Import GL Accounts from CSV-

1. Download the GL Account Import Template

2. Fill the following fields

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.

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

Setup Products

B. Setup Products

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

a) Import Products from CSV

b) Create Manually

a) Import Products from CSV-

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

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

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

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

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.

New Account Type

You can add the following Account types manually:

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:
1. Click on GL Accounts Object