How to Create Points to Remember | Tally erp9

Points to Remember 

• F11: Feature are company-specific. You are allowed to specify options that are specific to the selected company only.               
• The Accounting Features helps the user to create Budgets & Se D  Scenarios, Currencies, Cost Categories etc. in addition to Groups and Ledgers.                       
• The Inventory Features helps the user to create Stock categories Multiple Godowns, Use Tracking Numbers, Order Processing, Price levels etc. in addition to Stock Groups, Stock ltems and Units of measure.                                            
• The Statutory & Taxation Features helps the user to enable v Added Tax (VAT), Excise, Service Tax, Tax deducted at Source(TDS Tax Collected at Source (TCS), Excise Duty along with Tax in such as Local Sales Tax Number, Inter-state Sales Tax Number, PAN Income -Tax Number.                 
• F12: Configuration options are applicable to all the companies in the same data directory.                                         
• All financial entries are performed using ledgers or account heads.                           
• Group is a collection of Ledgers of the same nature.                                       
• You can delete a ledger by pressing Alt+D in the Ledger Alteration screen.

How to Create other Ledgers given in the Trial Balance | Tally Course

Create other Ledgers given in the Trial Balance 

1.Remember you have already input the ledger details for the two Sundry Debtors, the Trust Loan and Petty Cash 
2.Work from the Trial Balance, referring to the Chart of Accounts for the group to select, and ate the ledgers using the single or multiple options, depending on the number of ledgers create. 
3.For the ledgers under Sales Accounts and Purchase Accounts, set Inventory values affected? to No. Reset it to Yes when you start Inventory Vouchers. 
4.Please enter on the ledger names as per the Trial Balance 
5.Sundry Creditors should be set up using the multiple options in the same way au the Sundry Debtors, except that the opening balances will be credits.
6.Watch the debits and credits on the two accumulated depreciation ledgers as, Tally ERP assumes it to be a debit balance (Dr). You need to change this to Cr 
7. Creste a ledger for Bank Interest even though its balance is zero 

• tally course
• tally course fees
• tally course online

Verify the Ledgers and Opening Balances 

In practical situations, that is all you have, the Chart of Accounts and the Trial Balance You need to match the Trial Balance ledger accounts with the Chart of Accounts. You might put the opening balance figures in the chart of accounts itself. Tally ERP 9 needs to know the Group under which each account falls at the time you are creating the ledger account 
To ease your waik-through, the following Multi Ledger Alteration screen is taken from Tally ERP 9 after entering the data. You can use them to verify your ledger accounts 

Go to the Gateway of Tally> Accounts Info. > Ledgers > Multiple Alteration > Select All Items.

Multi-ALedger Alteration Screen

Press Y or Enter to accept the screen.

Altering Groups/Altering and Displaying Ledgers /Ledger Creation

The Group Creation Screen appears as :

Group Creation

10. Press Y or Enter to accept the screen.

Altering Groups.
Once created , groups can be altered by selecting the Alter option for single or multiple groups. The procedure is the same as used earlier to display groups, except that, here the data can be altered.



Deleting Groups 
You can delete a group via the Group Alteration (Single Mode) screen by pressing Alt+D However, you cannot delete Tally ERP 9's pre-defined groups, or groups with sub-groups or groups containing ledgers. The lowest level must be deleted first.  

Tally.ERP 9 walk through to create National Traders ledgers with opening balances 

Go to the Gateway of Tally >Accounts Info. >Ledgers> Create 

Adding Single Ledgers 
1. Name: IPPW Society Loan 
2. Alias: Skip this field 
3. Under: Secured Loans 
4. Inventory values are affected ?: No 
5. Opening Balance (on 1-April-2010): 50000 Cr

Ledger Creation

however, you can chaage t to debt (Dr) t roquired Al nohe Du Taly ERP 9 crrently dinpinys running total of the aiernco i the balancos have beon entered 

6. Press Y or Enter to accept the screen. 

Adding Multiple Ledgers 

• Under Group: Sundry Debtor 
• Name of Ledger Data Link Technologies 
• Opening Balance: 26000 Dr 
• Name of Ledger: Spectrum Computers 
• Opening Balance 12400 Dr 
• Name of Ledger Supreme Computers 
• Opening Balance 13500 Dr 
• Press Y or Enter to accept the screen. 

Altering and Displaying Ledgers 
The procedures for altering and displaying ledgers are similar to those of groups.Now try this out on National Traders by altering the Tally ERP 9 pre-defined ledger for Cash to Petty Cash and anteing the opening balance. 

• Select Alter from the Single Ledger option 
• Select Cash from the List of Ledgers 
• Change the Name from Cash to Petty Cash 
• Enter the Opening Balance of 500 Dr 
• Press Y or Enter to accept the screen. 

if you use Display in Single Ledger now, you will see that the List of Ledgers shows Petty Cash instead of Cash 

Deleting Ledgers 
You can delete a ledger,by pressing All+D in the Ledger Alteration screen. 
You will not be able to delete a ledger, once the financial transactions (vouchers) have entered (excluding the Opening Balance).If there is a need to delete a ledger with any financial transactions the lowest level must be deleted first by pressing Alt+D

How to Create Group ~ Tally erp9

We can access all the configuration options for the Masters from the Gateway of Tally > F12 Configure>Accts/Inventory Info 

Go to the Gateway of Tally>Accounts Info. > Groups> Create (Single Group) 

Click on F12: Configure button and set Yes to: 

• Allow ALIASES along with Names 
• Allow Language ALIASES along with Names 
• Allow ADVANCED entries in Masters 

Accept the configuration screen and Tally.ERP 9 displays the Group Creation Screen in which you will notice additional information like: 
1. Alias -This is a simple mechanism of identifying an account by another name. 

2.Group behaves like a Sub-Ledger -The group behaves like a Control Account for the ledg- ers it contains when set to Yes. Only the group balance will be displayed, not the individual edger balances. It is useful for groups such as Sundry Debtors and Sundry Creditors (which are pre-set to Yes) where there can be numerous ledger items 

3. Nett Debit/Credit Balances for Reporting-By setting this to Yes, amounts will be displayed as a net figure instead of separate debit and credit balances in reports. 

Create Group 
1. Name: Depreciation 
2. (alias): Type Deprn and press Enter. This allows you to refer to the group by either name. You will notice that there is a field to enter a second alias if required. If you enter a name here, another alias field will be displayed, and so on. Tally uses the main name on all displays and reports, but this multiple alias facility is extremely useful for data entry. 
3. Under: Select Primary from the list of Groups 
4. Nature of Group: Select Expenses 

N.B:-
Nature of Group is displayed when the new Group is created under a Primary Group. It helps to distinguish whether the group is a part of assets, liabilities, income or expenses, to identify the correct group for the Balance Sheet or Profit& Loss A/c 

5. Does it affect Gross Profits?: No Since these are Expenses (and the same is true for Income) which affect the Profit & Loss A/c, Tally.ERP 9 needs to know if the group affects the gross profit. This field will not appear if you are adding a group to an existing group.

N.B:-

• For Primary Income and Expenses Groups, the field Does it affect Gross Profit? tells Tally ERP 9 whether the item is above or below the line in the Profit& Loss A/c in terms of its effect on the gross or net profit. Direct items are pre-set to Yes and indirect items to No. 

6. Group behaves like a Sub-Ledger: No 
7. Nett Debit/Credit Balances for Reporting: No. 
8. Used for Calculation (eg. Taxes, Discounts): No 
9. Method to Allocate when used in Purchase Invoice: Not Applicable

LIABILITIES/Chart of Accounts in Balance Sheet Liabilities /Incomes | Tally erp9

LIABILITIES 

Current Liabilities (P) 
Duties &Taxes (P) 

• Sales Tax (L) 

Sundry Creditors (P) 

• Challenger Systems (L 
• Horizon Enterprises (L.) 
• Silverplus Computers (L) 
• Tax Deducted at Source (L) 

Loans (Liability) (P) 
Secured Loans (P) 

• Mutual Trust Loan (L) 

Capital Account (P)

• Equity Capital (L)                                                                                                                                                                                 Chart of Accounts in Balance Sheet Liabilities 

Revenue Accounts appearing in the Profit & Loss Account 

INCOME 
Sales Accounts (P) 

• Computer Sales (L) 
• Component Sales (L)
• Printer Sales (L) 

Indirect incomes (P) 

• Bank Interest (L)

EXPENSES

Purchase Accounts (P) 

• Computer Purchase (L) 
• Pinter Purchase (L) 
• Purchase (L) 

Direct Expenses (P) 

• Wages (L) 
• Freight Charges (L) 

Indirect Expenses (P) 

• Salary (L) 
• Office Costs (L) 

Depreciation (NPG) 

Chart of Accounts in Profit& Loss account Expenses 

Tally.ERP 9 Walk-through to Create Group Names for National 

Traders.Check the following: 
1. Check whether the Current Date is April 1, 2010. To change the Current Date, click F2: Date on the button bar.Note that Tally ERP 9 increments the date assuming that you want to change to the next day.You can accept it or change it.Type 1-4-2010 and press Enter to accept.
2.Press Esc, if you do not have the Gateway of Tally menu displayed.Let us now get familiar with Tally.ERP 9's Display functions.

Displaying groups in Single Group and Multiple Group in the chart of accounts. 
Go to the Gateway of Tally >Accounts Info.> Groups > Display (Single Group) Bank Accounts. 

You can now use the Page Up and Page Down keys to view different groups.  

N.B,

• The Groups. in Tally ERP 9, serve to both classify and identify Account heads (ledger accounts) according to their nature. This enables a presentation of summarized information.                        
• The Groups have a hierarchical organisation. At the top of the to hierarchy are Primary Groups where accounts are classified in capital or revenue, more specifically into assets, liabilities, income and expenditure to determine the entire accounting and their presentation ie, whether a ledger affects Profit & Loss Account (as a revenue item) or goes into the Balance Sheet.                                                                
• Tally ERP 9 provides a set of reserved groups, based on mercantile accounting principles, and allows you to modify their names or create sub-groups and primary groups. 

Let us now view the List of Groups in the Multiple Display Mode. Go to the Gateway of Tally > Accounts Info. > Groups Display (Multiple Groups) > Seled All Items

Trial Balance of National Traders/Chart of Accounts of National Traders | Tally erp9

Given below is Trial Balance of National Traders extracted from the Books of Accounts at the close business on March 31, 2010.


                                      Trial Balance

Particulars		Debit	Credit
Bank Account		35000
Deposit Account		40000
Petty Cash		500
Opening Stock		286150
Sundry Dedtors(Total)		57300
Compu Care Systems	5400
Data Link Technologies	26000
Spectrum Computers	12400
Supreme Computers	13500
Buildings		75000
Buildings Accum Deprm			8000
Office Equipment		25000
Office equip Accum Deprn			4500
Tax D educted at Source			4780
Sales tax			13600
Sundry Creditors(Total)			156000
Challenger Systems	65650
Horizon Enterprises	44750
Silveplus Computers	45600
Mutual Trust Loan
Equity Cap0ital
Pofil & Loss A/c
Total		518950	518950

The Chart of Accounts to be prepared is based on the above Trial Balance of  National Traders. This is assist you in understanding the classification of ledgers. To help you, each account has been marked as: 

• P - Pre-defined Tally.ERP 9 Group(no action)
• L - Ledger account required
• NG - New Group required
• NPG - NEW Primary Group required

Chart of Accounts of National Traders 
1. Capital Accounts as appearing in the Balance Sheet: 

i) ASSETS 

• Current Assets (P)  
• Bank Accounts (P) 
• Bank Account (L) 
• Deposit Account (L) 
• Cash-in-Hand (P) 
• Petty Cash (L)  
• Stock-in-Hand (P) 
• Stock (L)
• Sundry Debtors (P) 
• Compu Care Systems (L) 
• Data Link Technologies (L)
• Spectrum Computers (L) 
• Supreme Computers (L) 

ii) Fixed Assets (P) 

• Buildings (NG) 
• Buildings (L)
• Building Accum. Deprn (L) 
• Office Equipment (NG) 
• Office Equipment (L) 
• Office Equip.
• Accum. Deprn (L)

How to Create Group Creation | Tally erp9

Group Creation

Group Creation

Press Y or Enter to accept the screen. 

• Similarly create the following Groups. 
• South India Debtors under Sundry Debtors.
• Mysore Debtors and Secundrabad Debtors under South India Debtors. 
• North Delhi Debtors and Bhopal Debtors under North India Debtors.

Tally. ERP 9 allows you to create any number of groups under all the default group. We have new created two sub-groups under Sundry Debtors North India Debtors and South India Debtors Additionally we have created two sub-groups each under North India Debtors and South India Debtors as per the requirements 

Let us now create the ledgers for Renison & Co and Milton &Co under North Delhi Debtors 
Go to the Gateway of Tally> Accounts Info. >Ledgers> Center (Multiple Ledgers) 

• Create Renison &Co and Milton& Co under North Delhi Debtors Select North Delhi Debtors from List of Groups 
• Enter Renison &Co in the Name of Ledger field.
• Enter Milton & co in the Name of Ledger field.
• North Delhi Debtors s automatically prefilled in the Under press Enter to accept. 
• Press Enter to accept the screen. 

We have learnt to create ledgers in both the single and multiple mode under Tally ERP 9's predefined groups We have also created  own sub-groups under Tally ERP 9's predefined groups.

Return to the Gateway of Tally and shut Indus Enterprises and select National Traders.

Practice Exercise /Solution

Practice Exercise 
Two of the nine ledger accounts will be created by us. As a practice exercise you will be creating the remaining seven ledgers 

1. Proprietor's Capital Account under Capital Account with an opening balance of Rs. 25000 

• Enter Name as Proprietor's Capital Account 
• Select Capital Account from the List of Groups 
• Enter 25000 in the Opening Balance (on 1-Apr-2010) field.
• Press Y or Enter to accept the screen. 

Notice that Tally ERP 9 automatically capitalists the first letter for you 
2. Land & Building under Fixed Assets with an opening balance of Rs.60000 

• Enter Name as Land & Building 
• Select Fixed Assets from the List of Groups 
• Enter 60,000 in the Opening Balance (on 1-Apr-2010) field.
• Press Y or Enter to accept the screen. 

Tally ERP 9 displays the total debit and credit opening balances while the ledgers are being created in the Ledger Creation screen. This is to avoid differences in the opening balance. So far, we have used the default groups provided in Tally, ERP 9, but Tally ERP 9 does allow us to create our own groups. To know how to do so, let us explore the options available under t creation of Groups using Tally ERP 9's pre-defined groups. 

Groups can be created in the following manner 
Go to the Gateway of Tally> Accounts Info. > Groups. 
The Groups menu appears as shown below:


N.B
You an create one group at a time by pressing Enter on Create under single Group menu in case, you want to create multiple groups simultaneously you can create them by pressing Enter on Create under Multiple Groups. 

Create the following Sundry Debtors Ledger accounts 

• Groups -North Delhi Debtors and Bhopal Debtors under North India Debtors. 
• Mysore Debtors and Secundrabad Debtors under South India Debtors. 
• Renison & Co and Milton & Co grouped under North Delhi Debtors. 

Solution 
The solution is to first create two sub-groups North India Debtors and South India Debtors under Sundry Debtors.
Go to the Gateway of Tally>Accounts Info. > Groups> Create. Enter Name as North India Debtors 
Against the field Under select Sundry Debtors from the List of Groups. 

The Group Creation screen appears as shown below. 

How to Create Groups and Ledgers Drawing Under Group in Tally erp9

Drawing Under Group in Tally erp9 

N.B-(The Items in square brackets are aliases for the Group Names This is another powerful feature of Tally ERP 9, which allows you to refer to the Na same item under several different names)

Groups and Ledgers 

Group is a collection of Ledgers of the same nature. In a business, expenditures like expenses, electricity charges, conveyance etc., are commonly incurred expenditures are created to be used while accounting vouchers are entered. To know the total of  telephone d. Ledgers based on these expenses for any period (a week or a month), similar matured expense ledgers are grouped. Drawing Under Group in Tally. 

N.B-(Make sure all the options in the F12: Configure (Master configuration) are set to No The function of each option will be explained as and when the topic is covered) 

Ledger account heads are the actual account heads with which we identify the transactions. All voucher entries have to be passed using ledgers. To Understand the concept of Groups and Ledgers, let us create Ledgers and Groups in Indus Enterprises. Drawing Under Group in Tally.

1. Proprietor's Capital Account -under Capital Account with an opening balance of Rs.25000 
2. Land & Building- under Fixed Assets with an opening balance of Rs.60000 
3. Milton & Co- under Sundry Debtors because we have sold some goods to them - with an opening balance of Rs. 15000 
4. Kaltronic Ltd - under Sundry Creditors - because we have purchased some goods from them with opening balance of Rs. 85000 
5. Local Sales- under Sales Account with no opening balance,
6. Local Purchases- under Purchase Account with no opening balance. 
7. State Bank of India - under Bank Accounts with an opening balance of Rs. 35000 
8. Conveyance- under Indirect Expenses with no opening balance. 9. Bank Interest- under Indirect Income with no opening balance 


Notice that we have mentioned ledger names under groups i.e., under Capital Account, under Sundry Debtor, etc. which are referred to as GROUP names. Drawing Under Group in Tally. 

Ledgers are created in the following manner: 

Go to the Gateway of Tally >Accounts Info. > Ledgers> Create. The Ledger Creation screen appears as shown below. Drawing Under Group in Tally. 

Pre-defined Groups of Accounts in Tally ERP 9

Pre-defined Groups of Accounts 

There are 28 predefined groups in Tally.ERP 9, which are widely used in the Chart of Accounts of many trading organizations. Out of these, 15 groups are Primary Groups and the rem 13 are Sub-Groups. 
Among the 15 predefined groups, 9 Groups are Balance Sheet items and the remaining & groups are Profit & Loss A/c items. However, you may also alter the nomenclature of these predefined 28 Groups 

The List of Accounts: screen is displayed as shown 
1.Capital Account: Reserves & Surplus (Retained Earnings] 
2.Current Assets: Bank Accounts Cash-in-hand Deposits (Asset) Loans & Advances (Asset) Stock-in-hand Sundry Debtors 
3.Current Liabilities: Duties & Taxes Provisions Sundry Creditors 4.Fixed Assets: 
5.Investments: 
6.Loans (Liability): Bank OD A/c [Bank OCC A/c] Secured Loans Unsecured Loans 
7.Suspense A/c: 
8.Misc. Expenses (Asset)
9.Branch/Divisions 

Out of the 15 pre-defined primary groups, the following are the six pre-defined groups that appear in the Profit & Loss Account. 
1. Sales Accounts. 
2. Purchase Accounts. 
3. Direct Incomes [Income (Direct)] 
4. Indirect Incomes [Income (Indirect)] 
5. Direct Expenses [Expenses (Direct)] 
6. Indirect Expenses [Expenses (Indirect)]

Invoice /Orders Entry/ Setting up Account Heads

Invoice /Orders Entry
The Invoice entry and Order entry screens can be configured for additional information such export details, shipping derails, etc 


Printing 
This configuration helps the user to configure the printing screens for the reports and transactions. 

Data Configuration 
This configuration helps the user to define location of Language Files, Tally Configuration File Export Files, Data Files and details of the companies to be loaded on startup, 

TDL Configuration 
This screen provides details regarding TDL Configuration viz.,, Local TDLs, Account TOLs& Remote TDLs enabled for the product. 

Advanced Configuration
The configuration helps the user to specify Client/Server Configuration, Connection configuration and Proxy configuration for ODBC connectivity and Synchronization of  Data.   

Licensing 
This configuration helps the user to update, surrender, reset license and also configure existing License. 

Setting up Account Heads 
Tally.ERP 9 allows you to create Account heads and groups as per your requirements. The flexibility and ease of creating user-defined Account Heads and groups (Chart of Accounts) as per nature of business or business practice makes Tally.ERP 9 suitable for businesses across industries, verticals and geographies, without changing the way they do their business. 

 Chart of Accounts 
Tally.ERP 9 follows the Double Entry system of Accounting. It records accounting information by debiting and crediting different Ledger Accounts using different voucher types depending upon the nature of transaction. It automatically collates the debit and credit amounts and arrives at the closing balance of each ledger / group /report. 

Voucher Entry / Accounting Vouchers / Inventory Vouchers

Voucher Entry
Both the Accounting and Inventory Vouchers can be configured from this menu for additional information. 

Voucher Configuration screen 

Accounting Vouchers 

• Skip Date field in Create Mode (faster entryl): Set to Yes, the Tally ERP 9 cursor goes directly to the Dr or Cr field depending on the voucher type. However, if set to No, the Tally ERP 9 cursor goes to the Date field. It is advantageous to set this option to Yes for a faster entry if there are many entries to be made on the same date.
• Use Single Entry mode for Pymt/ Rcpt/Contra: This configuration helps in selecting multiple debits or credits depending on the type of entry. 
• Use Payment/Receipt as Contra: To indicate the transfer of funds from bank to cash, bank to bank and cash to bank, Tally ERP 9 provides a voucher type called Contra. This configuration is activated while using payment and receipt vouchers for a 'Contra' transaction.
• Use Cr/Dr instead of To/By during Entry: This configuration gives the flexibility to use Cr Dr or To/By in Vouchers as per the requirement or the understanding of the user.
• Warn on Negative Cash Balance: This option in Tally.ERP 9 displays a warning if the cash balance is NIL. 
• Pre-Allocate Bills for Payment/Receipt: This Configuration en ables the user to select first before the total amount can be updated in the amount field. This option extremely useful while Cheque Printing.
• Allow Cash Accounts In Journals: Journals are adjustment entries. However, in many cases companies require journals to account for day-to-day transactions involving cash bank accounts.
• Allow Expenses/Fixed Assets in Purchase Vouchers: This configuration helps the user to enter the details of purchase of fixed assets in the Purchase Voucher.
• Allow Income Accounts in Sales Vouchers: This configuration helps the user to allocate the income accounts in the sales voucher.
• Show Inventory Details: This configuration when set to Yes shows the name of the stock item, quantity, rate and value details.
• Show Table of Bills Details for Selection: This configuration displays a table which lists out the references of the pending bills.
• Show Bill-wise Details: This configuration enables the user to view the bill-wise details in the voucher.
• Expand into multiple lines: This configuration displays the due date of repayment based on the credit days given.    
• Show Ledger Current Balances: This configuration displays the current balance of ledger selected while an entry is made. This is a convenient feature to use since it helps to get the information without referring to the report. 
• Show Balances as on Voucher Date: Set to Yes, a voucher that is viewed in the alteration mode displays the ledger balances on the voucher screen based on the voucher date. 

Inventory Vouchers

• Use Ref. Number in Stock Journal: This configuration provides an additional field called Ref. in the Stock journal, where the user can enter the reference number 
• Warn on Negative Stock Balance: This configuration warns the user in cases where the item selected reaches a negative balance in the Invoice mode 
• Honor Expiry Dates usage for Batches: This configuration hides the batch details that are redundant and have expired 
• Show Balances as on Voucher Date: This configuration enables the user to view the inventory balances according to the voucher date  
• Show Godownwise Details: This configuration enables the user to view Godown details 
• Show Batchwise Details: This configuration enables the user to view Batch details