2022
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".
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
3. Make sure the Type field match to the Pick list Value of "Account Type" in AccountingBook. The values are:
Account Type Values
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
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:
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
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.
You can add the following Account types manually:
5. Click on New tab and enter the new Account type name therein