TRIBHUVAN UNIVERSITY FACULTY OF HUMANITIES AND SOCIAL SCIENCE Lab report of Tally ERP.9 Submitted to: Department of Computer Application National College of Computer Studies Bishnu Prasad Khatiwada Submitted By: Name: Samriddhi Shakya Roll: 27 April, 2022Introduction to Manual Accounting System Accounting system in which all the accounting task are completed by an accountant with hand written and using paper documents, paper and accounts books. It is a traditional system and calculations are calculated manually by accountant. Different stationary items are used for record keeping (e.g. Journal, Ledger, Statements) and report is prepared by account manually. Limitation/Disadvantages of Manual Accounting System ¢ Time consuming ° Costly Errors No backups Loss of paper documents Lack of security Human errors calculations More human resources needed More spaces Introduction of Computerized Accounting System To overcome from limitation of manual accounting system, computerized accounting system is developed. This is an era of computer in which all functions are done using computer system. So, accounting task also can be done using computer applications and software. Computerized accounting system is an modern andscientific system in which computer hardware and software is used to perform accounting task and some task are completed automatically by software. In this system, software is developed in a way that it can perform accounting process automatically after giving accounting process automatically after giving some information instructions by users. Advantages/Needs of computerized Accounting System ¢ Time Savings Data Backup Cheaper Less human resources Less errors Secure e Accuracy « Low space consuming Financial Application and Accounting Software Financial application is the program which is used to record the financial transactions of the company/organization in order to keep the references for the future use. It helps to provide the information to the users technically. Mostly used Accounting Software in Nepal. MS-EXCEL: MS Excel isa commercial spreadsheet application that is produced and distributed by Microsoft for Microsoft Windows and Mac OS operating systems.Tally ERP9: Tally. ERP 9 is one of the most popular accounting software used in India. It is complete enterprise software for small & medium enterprises. Tally. ERP 9 is a perfect business management solution. Swastik : Swastik Software is a highly automated system for Invoicing, Inventory Control, and Accounting with Detailed Business performance Analysis. This program has been developed keeping in mind the common and ntial requirements of Manufacturing, Importers, and Distributors. Famas: FAMAS ‘Financial and Management Accounting System” is an integrated computer-based financial and management accounting system that is exclusively designed to meet each financial and management accounting standard of different specific sectors. Dolphin: Dolphin Enterprise is a fully web based accounting system using the latest PHP and MySQL Open Source Technology. Users can access Dolphin Enterprise locally or via secure VPN anywhere in the world. OMS Accounting: OMS software is a solution that enables retailers to automate and manage the entire order fulfillment process from a single platform. AccSwift: AccSWIFT isa vast messaging network banks and other financial institutions use to quickly, accurately and securely.Introduction to Tally ERP9 Tally ERP 9 is the Accounting software developed by Tally solution Pvt. Ltd. a multinational technology company, having headquartered in Bangalore, India. It is a Enterprise Resource Planning software used for business Accounting and Inventory Management. It meets the needs of small and medium businesses, and is easy to purchase quickly to install and easy to learn and use. Features and Functions e Supports multiple users e Easy to implement security e Multi-lingual e Synchronized record e Easy to use Opening Tally. ERP 9 Click on Start > Programs > Tally.ERP 9 > Tally.ERP 9 or double click on the Tally.ERP 9 icon on desktop. The screen as below will be appeared after clicking co Exit/Quit Tally. ERP 9 You can exit the program from any Tally. ERP 9 screen, but Tally.ERP 9 requires all screens to be closed before it shuts down. To quit working on Tally.ERP 9:Press Esc until you see the message Quit? Yes or No? Press Enter or Y, or click Yes to quit Tally.ERP 9.1.Alternatively, to exit without confirmation, press Ctrl+Q from Gateway of Tally. 2.You can also press Enter while the option Quit is selected from Gateway of Tally. Creation of a Company We should create our company to sign up (register) in tally. Go to Gateway of Tally > Company Info (Alt+F3) > Create Company? The screen as above will be appeared after clicking create a company: Directory: C:\user \ Tally.ERP9\Datat Name: Give the Company Name (e.g. ABC Pvt. Ltd.) ¢ Mailing Name: AutoZAddress: Location of Company (e.g. Kathmandu , Nepal) Statutory Compliance for: Nepal (None) Telephone No.: e.g. 01 43...... a Mobile Number: e.g. 9841 ...... a E-mail: (eg. company33 @gmail.com)+ Currency symbol : NPR Maintain : Account only or Account with Inventory ( if company have stock Item, have to chose account with inventory otherwise Account only.(we prefer account only for simplify) Financial Year : e.g, 2021-04-01¢ Books Beginning from: Same date (auto) Security Control Tally Vault Password (if any) :leave Empty Use security control : Yes Name of administrator :eg. ABC Password : e.g. nepall23¢ Repeat Password : e.g. nepall23 (Forget your password >Enter) 4 Use tally Audit features: If need Yes if not NowBase currency Information Base currency symbol: NRs.4 Formal Name: Nepalese Rupees? Number of decimal place: 27 If symbol suffixed to amount: yes“ Show amount in Millions: no~ Put a space between amount as symbol: yes7 Decimal place for printing amount in words: 2~ Accept ?? Press "y" or Enter+ or (CTRL + A) (Before working on the further transaction it will ask you to enter the name of user and tally password that you have entered) Name of User : ABC Tally Password: 12347 Shut Company (Sign out) Press Alt+F1 (to shut already open company) Edit Company Company Info (Alt+F3 )> Alter> Select Company(eg. ABC Company) + (You can edit or change company details as your required) Make require Changes (e.g. Name , Address , User ) Deleted Company Company Info (Alt+F3 )> Alter> Select Company (eg. ABC Company)ALT +D then system shows the Message > Deleted? : Yesare you sureyes (Company Permanent Deleted) Note: It will delete all data relating to this company. Aftter logging in to the company, the gateway of tally will be presented to you, from which you can choose what operation to perform. It contains four major headings: - Masters - Transactions - Import - Reports ‘Accounts info, Inventory info ‘Twaneactone ‘Accounting Vouchers= Inventory Vouchers Import Import of Data Reports Baiance sneet Proft § Loss Ale ‘Stock Summary Ratio analysis Display ‘Mutt Account Printing ‘aut Masters 1.Account Info 2.Inventory Info1. Masters a. Accounts Info Group Group is the group of ledgers with similar nature in accounting like direct incomes, direct expenses, sundry debtors etc. We can create additional groups as needed. How to Create Group Ledger (e.g. Sundry Creditors- Foreign) Gateway of Tally > Masters >Account Info >Group > Group Create. Name : Sundry Creditors-Foreign Alies: empty Under: Sundry Creditors Group behaviors like a sub ledger : Yes Accept : Yes Alter the Group Ledger Account Info >Group > Single Group > Alter You can change as your requirement.Ledger Ledger is the individual record of any title. It is the most useful part in tally. When using tally for the first time, we should create ledgers of all parties under different ledger groups . Creating a New Ledger Gateway of Tally> Masters> Account> Indo> Ledgers> Single Ledger/ Multiple Ledgers> Create Some of the ledgers we created for our purpose are: Under Sundry creditors ¢ BhatBhateni Supermarket A/c e Kathmandu Mall A/c «© ABC Suppliers A/c © M&M Wholesaler A/c © TT Distributors A/c Under Sundry Debtors © Ashna’s A/c e Sonali Ltd Pvt A/c ¢ Nandita’A/c © Sujita’s A/c «© ~Lumana’s A/c Under Indirect Expenses e Salary A/ce Rent A/c © Telephone & Bill A/c e Electricity A/c © Advertisement A/c Under indirect income © Rent Received A/c e Dividend Received A/c e Interest Received A/c © Commission Received A/c * Discount Received A/c Under bank Account e Sanima Bank A/c e Everest Bank A/c © NMB Bank A/c Under Fixed Assets e Land A/c ° Building A/c e Furniture A/c e Plant and Machinery A/c e Vehicles A/c Under Direct Expenses e Purchase A/c © Wages A/c © Carriage A/c© Factory Rent A/c ¢ Manufacturing Expenses A/c * Custom Duty A/c Under Direct Incomes © Sales A/c Under Capital Account e Share Capital A/c © Capital A/c Under Current Assets e Bills Receivable A/c e Accounts Receivable A/c © Cash A/c e Inventory A/c Under Current Liabilities « Accounts Payable A/c ¢ Bills Payable A/c e Loan A/c © Bank Overdraft A/c e Interest Payable A/c ¢ Tax Payable A/c 2.Transactions a) Accounting Voucher b) Inventory Voucher a)Accounting Vouchers: Gateway of Tally > Masters > Transactions> Accounting VouchersTypes of Accounting Vouchers in Tally ¢ Contra Voucher (F4) e Payment Voucher (F5) © Receipt Voucher (F6) e Journal Voucher (F7) ¢ Sales Voucher (F8) e Purchase Voucher (F9) e Credit Note or Sales Return Voucher (F8) e Debit Note or Purchase Return Voucher (F9) 1.Contra Vouchers (F4) Gateway of Tally > Accounting Vouchers > Press F4 Function Key Contra voucher is for recording all kind of banking Transactions related by cash with bank. Those kinds of transaction are will be contra entry I. Cash deposited into Bank We will received money from Many more Customers from retails Business , Those collected cash we will deposited into Bank account. Example: Sanima A/C......... Dr 5000 Cash A/C...... 5000 (Being Cash Deposited into Co-operative.)II. Cash withdraw from Bank for office use We will Cash withdraw from Bank for office use not only one subjects Expenses small payment will be done but not all use. Some cash are stay cash in hand at office. Example: «Dr. 10000 NMB ACC... Cr. 10000 (Being Cash withdraw for Office.) II. Transfer Fund from One Bank to Another Bank Some time we will shifted bank money into another’s Bank account. Cash transfer from NIBL to BOKL Bank . Example: Sanima A/C. 50000 NMB ACC...........Cr 50000 (Being NIBL bank money shifted into BOKL bank A/C.) 2.Payment Voucher Gateway of Tally > Accounting Vouchers > Press F5 Function Key> Payment Voucher records all kinds of cash or cheque payment except Purchase of Goods on cash.In this voucher always Cash or Bank are Credited (a/c Cr.) IfPayment done by Cash but Cash in hand is not sufficient for Payment, in that time Warn on Negative Cash Balance Example: Salary A/C.......... Dr 3000 Electricity bill A/( Cash A/C... Cr. 5000 (Being Various expenses of the Day.) Payment to Suppliers: Hari KumarA/C........ Dr.35000 BOKL ACC... 35000 (Being Payment done by Cheque.) 3.Receipt Voucher Gateway of Tally >Accounting Vouchers > Press F6 Function Key> In this vouchers all kinds of cash or cheque receipt are recorded except cash sales of goods Cash A/C... Dr 33000 A&B Co AVC......Cr 33000 (Being Cash Received from Receipt no.09.)Cheque Received as Foreign Currency (eg. A/C Payee Cheque Received from Markus-Germany amount $100) NIBL USD ACC........ Dr $100 Markus-GermanyA/C......Cr.$100 (Being Cheque Received from Receipt no..10 & Deposited into NIBL USD A/C.) 4. Journal Voucher Gateway of Tally > Accounting Vouchers > Press F7 Function Key This voucher is used for recording non cash transactions or outstanding transactions. Salary A/C........! Dr 10,000 Salary Payable A/c......Cr. 10,000 (Being Salary Payable for the Month of Bhadra-2073.) 5. Sales Voucher Gateway of Tally > Accounting Vouchers > Press F8 Function KeySales voucher is used to record transaction of sales of Goods whether it is cash sales or credit sales. Sales Account is always credited and if cash sales then cash or Bank A/c is debited and if credit sales then Customers (name) account is debited. Choose “As. Voucher” from right side panel for voucher if in “As invoice”. Example: Sales of Goods on cash Rs 15,000. Ref .... (invoice No.) Cash A/e......cceeeees Dr. 15,000 Cash Sales A/c........Cr. 15,000 (Being goods sold for cash) 6. Purchase Voucher Gateway of Tally > Accounting Vouchers > Press F9 Function Key Purchase voucher is used to record transaction of Purchase of Goods whether it is cash Purchase or credit Purchase. Purchase account is always debited and if Cash purchase then Cash or Bank A/c is credited and if credit purchase then Suppliers’ (name) account is credited. Choose “As Voucher” from right side panel for voucher if in “As invoice”.Example: Purchase of Goods on cash Rs 15,000 Ref.... (Invoice No.) Purchase A/c .......... Dr. 15,000 ash Ae Cr. 15,000 (Being goods sold for cash) 3. Reports Display and Print a. Balance Sheet b. Profit & Loss A/C c. Ratio Analysis a. Balance Sheet Gateway of Tally >Reports Balance Sheet > Choose Detailed from right side panel for detailed items under different heading inside balance sheet like fixed assets, current assets, current liabilities etc. b. Profit & Loss Account It shows the Trading and Profit & Loss Account for certain period as we choose period from right panel. Following are the six pre-defined groups that appear in the Profit & Loss Account.Sales Accounts Purchase Accounts Direct Incomes [Income (Direct)] Indirect Incomes [Income (Indirect)] Direct Expenses [Expenses (Direct)] Indirect Expenses [Expenses (Indirect)] c. Display Choose display to show and print various financial accounts, statements and records. a) Trial Balance b) Day Book c) Account Books d) Statement of Accounts e) Cash/Fund Flow f) Receipt and Payment Account Day Book The Day Book is a Primary recording book. It show the list of all transaction made in particular day. On Tally the day book shown last date of the vouchers entry. Ledger How to view the Ledger?DisplayAccount BooksLedger~then requirement Name (eg. Bank Name, Parties Name any types of Ledger you need to view) Period : F2 Change period (type your requirement date...) How to view the Group Summary? Display Account Books~ Group Summary then requirement Name (eg Display Account Books4 Ledger~then requirement Name (eg. Sundry Debtors, Sundry Creditors, Bank A/C, Indirect Expenses....etc as your Requirement) For Print Reports Open any reports from reports or Display options. It top of the panel (P: Print) option was shown then click this option. A dialogue box was open with different options for print. We can print by printer or make PDF file. To choose printer click on select printer from right side panel. Export You can export to Excel, PDF or other format from Tally to edit or print reports or statements as your required.Transactions Let us suppose that we are in a Company named Samriddhi Pvt. Ltd. as an accountant and we are keeping the records of daily transactions of the company using tally. Say we have the following transactions for two months: April and May of 2022. 01-04 Started business with cash Rs 500000. 03-04 Purchased goods from A&B Suppliers Rs 50000. 05-04 Opened Bank Account in Sanima Bank with depositing Rs. 50000. 07-04 Purchase a computer for Rs.25000 and paid by cheque. 10-04 Sold goods of Rs 40000 and Receive cheque. 29-04 Paid salary to staff of Rs 30000 30-04 Paid office rent of Rs 10000 by cheque. 02-05 Paid to Bhatbhateni Supermarket Rs 48500 in full settlement. 09-05 Sold goods of Rs 80000 on cash. 30-05 Rent due for the month Rs 10000.Exported Financial Reports from Tally 1.Daybook Dae Pariclars 14.2100 Capital Ne (ash 4.222 ABC Supls Ne Puchaso Ne 42002 Cash ‘Sarina Bank Ne 742802 Computer Ne ‘Sarina Bank Ne 1042022 Sanima Bank A Salis Ae ‘9.42002 Salary Ne (ash Ne 10.4.2022 Ret Ae ‘anima Bank Ne 25.202 ABC Supls Ne (cash Ne Discount Roche 175.202 Bahai Supematat Ne Puch Ne 6.202 Cash Ne Sale Ae 505-2002 ont Ae ‘ecu Pyale A Samviddi PVT LTO ‘dia Day Book 1-49-2022 to 30-May-2022 Pet Lape pha & = ‘nou 000.00 ‘0000.00 Page ‘Amount ‘0000000 5,000.0 5,000.0 ‘99000 aasongo 150000 200000 ‘wjgonmo2. Ledgers ‘Samriddhi PVT LTD nda Purchase Ale Ledger count Ae 202 20 My 002 aie Paniouars Var Type Veh No Debt 3-4-2022 Or ABC Suppliers We pucrase = 90,00000 75.2022 Gr BhatBhaten! Supermarket Ne Puctess = 2200000000 Dr Closing Balance 2.500000 ‘Samridahi PVT LTD nds Sales Ale Luge Acco ‘ap 202910 208k 2022 Date veh Typ0 Veh Ne Debit 40442022 Or Sanima Bank we ats : ‘S200 Dr Gan we Sct 2 cr chosing Balance 12000000 1120.00.00 ‘Samriddhi PVT LTD india Capital Ale edger Account 1400202210 90§ay 2002 ‘Date Particulars ‘Veh Type Veh No: abit 1-4:2022 Dr cash Ave cet 1 Cr Closing Batance 500,000.00 ',00,000.00 ‘20,000.00 creat Cresit $300,000.00 20,000.00‘Samriddhi PVT LTD. ncn Cash Ale Book ‘age z0z2 16 30 may 2022 Dato —Panioulars Veh Type 44.2022 Gr Capital Ne ecerpt 25-4208 Dr Salary Ae Paymont r Closing Balance 1-5-2022 Gr Opening Balance 25-2022 Dr (as per details) Payment ARSC Suppers Ae 50,0000 + Desoun Received Ae 1500.00 OF 9-5:2022 Cr Sales Ae sate Dr Closing Balance Samriddhi PVT LTD nda Sanima Bank Ale Book 1h 202 0 May 2022 ven Type Cash ‘ona 7.42008 Dr Computer Ae Parent foa2ier Or Sales ae ‘Sle, 3042022 Dr Rent We Payment Dr Closing Balance ‘Samriddhi PVT LTD india Discount Received Ale edger Account 1 ay 2021 90 ay 2022 Dale Particulars 25-2022 Dr (as por dotals var Type Payment Cr Closing Balance VohNo. § H 8 $50,000.00 '5:50,000.00 Veh No, ‘50,000.00 0,000 90 40,000.00 +140,000.00 ogg Grealt $00,000.00 4,500.00 501,800.00 50,000.00 age Great 25,000.00 10000.00 1.05,000.00, +.a0.000.00 Pope Croat 1,500.00 1,800.00‘Samriddhi PVT LTD nce ABC Suppliers Ale edger Account Date Particulars Vai Typ Vai No. 15.2022 Dr Opening Balance 252022 Cr (as per dtals) Payment 4 DacountRecees Ae 1500006" ‘Samriddhi PVT LTD india BhatBhateni Supermarket Ale ledger Account 149200210 90 May 2022 aie Pareles Veh Type Veh: 7.2022 Or urchase Ae Purenase 2 © Closing Balance ‘Samriddhi PVT LTD eda Computer Alc ledger Account| 1A 202 0 May 2002 Dato Pantculars ‘Veh Type _ Veh No. 7-4-2022 Gr Sanima Bank Ae Payment 1 Dr Closing Balance ge obit reait ‘5,000.00 0,000.00 50,000.00 0,000.0 Debit reait 290,000.00 290,000.00 200,000.00 200,000.00 2.00,.000.00 Page Debit Credit 2500000 5000.00 2500.00 5000.00 25,000.00‘Samriddhi PVT LTD irda Accounts Payable Ale edger Aes 1 he 20201 0 May 2022 Page Oa Parieuars Van Type Veh Dest Great 20202 Dr Rent We sours 1 10,900.00 ‘90000 Closing Balance 1900000 ‘000.00 ¥0000.00 3. Trial Balance ‘Samriddhi PVT LTD irda ‘Trial Balance {4g 2122 3a. 2022 Closing Glance abt ‘Cea ‘capital Account 00.0000 Capial te 5.0.000.00 ‘Curent abies 210.0000, ‘Suny Creditors 200,000.00 ‘Accounts Payable Ne 10,000.00 Fixed Assets 2500000 Computer Ale 2500000 Curent Assets 60650000 100,000.00 (Cahn hand ‘501,500.00 100,000.00 Bank Accounis 4105(00.00 ‘Sales Accounts 12000000 Sales Me 10,000.00 Purchase Accounts 250,000.00, Puchase Ne 25000000 Indirect Incomes 150000 ‘Discount Received Ne 1500.00 Indroet Expenses, 5000000 Rent Ae 2.00000 Salary Ac 99000.00 cra Total 9.31,50000 931,500.004, Profit & Loss Account Particulars Purchase Accounts Purchase Ae Gross Los bt Indirect Expenses ent Ae Salay Ae Total 5. Balance Sheet Liabilities ‘capital Account (Cantal ae ‘Loans (iabtty) Curent Labities Sundry Crodtors ‘Accounts Payable Me Tota ‘Samriddhi PVT LTD ela Profit & Loss Alc ‘age zczio 30M 2022 ‘igrzoznw 30 ayo Particulars 25,000.00 Sales Accounts ‘Sabs Ne 25000000 (ross Los 9 2000.00 1,3000.00 Indoct ncomes ‘Descour Fecetved Ae ssj000.00 nooo et Loes ‘neo000 ‘.ajc0000 Total ‘Samriddhi PVT LTD nda Balance Sheet ‘age 2tz2 30M 2022 ar may 2002 Assets '590.900.00 Fixed Assets ‘50a000.00 ‘Comput At Ccuront Assets (Cat vend 231000000 Bank Accounts moom00 Profit & Loss Ae ‘Opening Blanco Current Perd 73090000 Total oar ym ‘.z0gon00 13000000 25090000 150000 1730000 ‘veng0n.00 ar may 2002 00000 506500.00 ‘oseoos 17050000 710,000.00,6.Cash Flow ori May dune ‘hy ‘Ragust ‘Sopiombor October November December sanuary February March Grang Totai 7. Fund Flow ‘Samriddhi PVT LTD. India Cash Flow Monthly Summary 1A 200010 S0-may 2022 ‘carn ovement Iotow ‘uttow 4000000 65,000.00 ‘8750000 50,000.00 6.215000 _ 1,15,000.00 ‘Samriddhi PVT LTD rca Funds Flow Monthly Summary 1.Apr-200010 20 May 2002 ‘Working capa Opening Csing 425,000.00 Paget Fow 4,75000.00, '31500.00 506,500.00, Page| Fun 4,25000.00 42500000. 2:96,50000 (11,28,500.00 2,86 500.00 296,500.00Conclusion: We came to know how Tally became a partner for account and how it make easy and systematic for accounting tasks.