2022
Page History
- Importing Data
- Home Page<Get Started<Import GL & Items or Sample
- Get Started with AccountingBook
- Setup my AccountingBook<Setup GL Account<Setup Setup GL Account
- Setup Products
- Import Sample Company Data (for testing)
- New Account Type
Importing Data
Data Import- For Importing the data, there are three options available namely:
...
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
...
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-
Prepare your file
- Create a CSV file with the following fields
- Account
- Type
- Description
...
1. Download the GL Account Import Template
...
2. Fill
...
the following fields
- Account
- Type
- 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
...
b) Create Manually
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".
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:
- Inventory
- Deferred Tax Asset
- Investments
- Deferred Tax Liability
- Long Term Liability
- 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.
To add new Account types, follow the steps:- 1. Click on GL Accounts Object
- 2.Expand Force.com Quick Access Menu
- 3. Click on View fields
- 4. Click on Account Type
5. Click on New tab and enter the new Account type name therein
Overview
Content Tools