Skip to main content

Advance Tally Syllabus (ACCA)

Tally Syllabus

Tally Beginner Syllabus

(Duration: 3 months OR 70 Hrs)

Module 1: Manual Accounting

About Tally, What is accounting, Types of accounting, Advantages of accounting, Transaction, Basic types of transaction, Step of accounting, Source Documents Journals, Methods of maintain journals, Rules of maintain journals, Types of accounts, Golden rules,  Important Journal entry transaction, Capital, Bank & Cash Entry, Fixed Assets, Purchase, Sales, Payment, Receipt, Discount, Goods Return Entries, Important Accounting Keyword, Types of Business (Service Organizations, Trading Organizations & Manufacturing Organizations), About ledger book & posting, Final Reports (Trial balance, Profit & loss & Balance sheet).

Module 2: Computer Accounting

Understand Tally Ledgers & Groups, Important Ledgers & Groups, Accounting Vouchers, Basic Accounting Vouchers, Introduction and History of Tally, Understand Different Version of Tally, About Tally Screen, Work on tally and Understand Basic Tally Operation Steps, Company (Creation/ Modification/ Delete), Ledger (Creation/ Modification/ Delete), Voucher Entry (Creation/ Modification/ Delete), Information About Basic Features & Configuration, Display and Print Financial Report (Trial Balance, Profit & Loss and Balance Sheet).

 Module 3: Inventory Concepts

Understand Inventory Management, Maintain Units, Stock Item, and Stock Group. Understand Stock Summary, Opening Stock, Closing Stock, AlterNet Unit (Use Rate in Alter Units), Godown, Godown Reports, Stock Journal, Stock Journal by class, Discount Column on Invoice (Separate Discount Column),  By & Get Scheme (Actual & Billed Quantity): Same Items Free, By & Get Free (Allow Zero Values Entries): Difference Items Free, Standard Rates on Sales: Rates fill automatic, Cost Center, Cost Center Report, How to Generate Invoice, Cash Invoice & Credit Invoice, Party's Details in Cash Bill, Print Invoice, Understand Cash & Credit Invoice and Invoice Printing, Understand How to Add Expenses in Invoice and paid. Add Expenses in Invoice, Trade Discount on Total Bill Amount, Generate Credit Notes for Discount, Interest & Goods Returns, and Debit Notes for Discount & Interest & Goods Returns.

Module 4: Foundation of GST

Tax System in India, Types of Tax in India, Introduction of GST, Rules of GST Registration, About GSTIN Number Format, Types of GST Registration, Type of Supply Person, Types of GST Percentage, About HSN & SAC Code, About GST Returns, HSN & SAC Code Rule for Invoice, Under Stand Local (Infra) and Inter State Sales & Purchase. Information about SGST, CGST and IGST.

Tally Executive Syllabus

(Duration: 3 months OR 70 Hrs)

Module 1: Computer Accounting

Ø  Understand Traditional Approach and Modern Approach.

Ø  Single Entry Mode and Double Entry Mode.

Ø  Single Entry & Compound Entries.

Ø  Debit & Credit Note Entries.

Ø  Learn Different types of feeding method.

Ø  Accounts Marathon.

Module 2: Final Reports & Excel Activity

Ø  Identify Ledger by Accounts.

Ø  Identify Ledger by Natures, Primary Groups and Sub Groups.

Ø  Understand and Create Manual Create Trial Balance.

Ø  Understand and Create Manual Create Profit & Loss.

Ø  Understand and Create Manual Create Balance Sheet.

Ø  Basic Excel Activity.

Ø  Maintain Trial Balance on Excel.

Ø  Maintain Profit & Loss on Excel.

Ø  Maintain Balance Sheet on Excel.

Module 3: Masters & Reports Activity

Ø  Single and Multiple Groups (Creation/ Modification/ Delete) on tally.

Ø  Multiple Ledgers (Creation/ Modification/ Delete) on tally.

Ø  Voucher (Creation/ Modification/ Delete) on tally.

Ø  Multiple Stock Groups (Creation/ Modification/ Delete) on tally.

Ø  Multiple Stock Items (Creation/ Modification/ Delete) on tally.

Ø  Multiple Godowns (Creation/ Modification/ Delete) on tally.

Ø  Understand Opening balance and Opening stock on tally.

Ø  Types of Reports, Important Reports, Hierarchy Model of Reports & Column Reports.

Module 4: Job Work

Ø  How to work service providing firm.

Ø  How to work trading firm.

Ø  How to work GST trading firm.

 

Tally Advance Syllabus

(Duration: 3 months OR 140 Hrs)

Module 1: Advance Manual Accounting

Maintain Manual Books & Statement: Maintain Ledger book (Manual), Create Trial Balance (Manual), Create Final Statements (Manual), Maintain Stock register (Manual), Create Final Statements with Inventory (Manual) like as Trading report, Profit Loss report Balance Sheet report. Advance Journal entry: Bad debts, Bad debts Recover, Loss, Charity, Depreciation, Appreciation, Outstanding, Prepaid Expenses and Interest on Capital.

Module 2: Advance Accounts Management

Outstanding Management: Maintain bill wise details (Advance, New, Against, On Account), Default credit days, set limit amount of credit, Alter and Set credit limit and credit days of All Party. Display Outstanding Reports, Ageing by Due Date, Ageing by Bill Date, Understand Different Configuration in Outstanding Report. Maintain Outstanding for Non Trading Accounts.

Interest Calculation: Activate Interest Calculation, Basic Interest Calculation Concepts, Apply Interest Calculation in ledger, Calculate Interest Total amount of ledger, Calculate Interest Transaction by Transaction, Override Parameters for each transaction, Pass Credit & Debit Note (Manually), Pass Credit & Debit Note (by Voucher Class), Display Interest Calculation report.

Cost Centre Management: Maintain Cost Centres, More then One Cost Category, Pre Define cost centre allocation during entry.

Advance Activity for Accounts: Use of Post Dated Voucher, Use of Cancel & Insert Voucher Option, Exception Reports -Negative Stock, Negative Ledgers, Email IDs, Compound Entry, Change Financial Year or Period of Company, Multi currency, Use of Memorandum Voucher For unknown Expenses, Memorandum Voucher For the goods given for approval, Use Optional Voucher for Pro Forma Invoice OR Quotation, Reversing Journal Voucher, Separate Cash & Bank Receipt, Voucher Creation for Cash & Credit Sales, Ledgers Creation for Cash & Credit Sales.

Module 3: Advance Inventory Management

Order Processing: Sales order, Purchase order, Delivery Note, Receipt Note, Rejection In, Rejection Out, Credit Note (Invoice Mode), Debit Note (Invoice Mode) etc.

Manufacturing: Advance Entries in Stock Items, Part Numbers in Stock Items, Description in Stock Items, Remarks in Stock Item. Understand Manufacturing Organization, Raw Materials Purchase, Manufacturing Goods, Manufacturing Journal, Finished Goods, Maintain Multiple Godowns.

Advance Activity for Invoice: Entry of Discount given to Customers by Ledger, Party's Details in Cash Bill, Print Invoice, Create Voucher Class for Purchase & Sales Entry, Use Multiple Price levels, Inform Negative Cash & Negative Stock, Information about Customers Turnover, Track Additional Cost of Purchase, Create Compound Unit, Physical Stock, Create Point of Sale Invoice or POS Invoice, Maintain Batch wise details, Set Expiry Dates for Batches.

Module 4: GST in Advance Level

Understand Multiple GST Rate Ledger, Multiple Purchase Ledger, GST Entry on Service class business, Multiple GST Rate in one Invoice, GST Adjustment, GST Tax Pay, Understand B2C Large, B2C Small Invoice, GST Import Goods & Service, GST Purchase from URD, Purchase from Composition Dealer, SEZ Purchase & SEZ Sales etc.

Module 5: Administrative Options

Opening Balance & Report, Multi Account Printing, Cheque Printing, Bank Reconciliation Statement, Maintain budgets and controls, Backup and Restore, Security Controls & Understand Multiple Security level, Audit Features, How to Import & Export Data in Tally, Understand how to Split Company, Group Company, Understand about Data Directory, Tally config file, How to send data by Email in Tally.

Module 6: Advance Excel Activity

Introduction, Entering, Editing and Formatting Data, Paste Special, Moving, Finding, and Replacing a Value, Comments, , Formatting Cells, Managing Worksheets, Modifying Rows and Columns, Understanding Formulas, Sort, Filter, and Subtotal, PivotTables, Data Tools, Introduction to Charts, Protecting Data, Lookups, Conditional Formatting etc.

Module 7: Job Work Practice

Challan feeding, Invoice feeding, Sales & Purchase feeding, Bank statement feeding, Bank Reconciliation, Payment feeding, Receipt feeding, Day to day entries feeding, Reports printing, Preparing Audit Plans, Analysis of Draft Financial Statements, Filing various reports to regulatory authorities like GST, Stock/Inventory Audits, Preparing daily sales invoice in tally/ Excel, Daily day to day accounting entries, Preparing Debit Note & Credit Note if any, Process accounts payable cheques, Prepare and handle petty cash vouchers and transactions, Debtors & Creditors Reconciliation, Maintaining & preparing payment voucher.



The End

Popular posts from this blog

Charity Entry, Distributed Free Samples and Loss by Fire

Journal Entry for Goods Given as Charity or Distributed as Free Samples Charity generally refers to the voluntary giving of help, typically in the form of money or goods to those in need.  Goods given as free samples are however a way of advertising . Both acts when performed by a company are required to be recorded in the books of accounts. Goods given to charity or goods distributed as free samples are  not to be  accounted  for as sales . Instead, they are accounted as expenses, simply because, in this case, the  outflow of goods  happen  without any consideration . Journal Entry  for  Goods Given as Charity When accounting for goods given as charity, purchases are reduced with the exact cost of goods contributed. Charity A/C Debit  To Purchases A/C Credit Example A company, Unreal Pvt Ltd.  gave  goods to charity which cost them 20,000. Journal entry for charity, in this case, will be posted as; Charity A/C 20,000  To Purchases A/C 20,000 Treatment of
Read more

Tally में Groups क्या होते है ?

Tally में Groups क्या होते है ? टैली में Group, Ledgers की Grouping करने के लिए होते है या इसको Ledgers का समूह भी कहा सकते है | टैली में किसी भी Ledger को Create करते समय Ledger के Nature को समझ कर किसी न किसी Group में रखना पड़ता है | इसलिए हमे सभी Groups व उनके Nature के बारे में जानकारी होनी चाहिए | टैली में Groups बहुत Important Topic है | अगर हमने Groups को समझ लिया तो टैली की Basic Working के बारे में समझ जायेगे | टैली में टोटल 28 Group होते है | जिनमे से 15 Primary और 13 Sub Group होते है | Primary 15 में से 9 Groups Assets / Liabilities Nature के होते है, जिनका Use Balance Sheet बनाने के लिए किया जाता है और 6 Groups Expenses / Income Nature के होते है, जिनका Use Profit & Loss बनाने के लिए किया जाता है | Primary Group According to Nature 1.      Assets 1.      Current Assets 2.      Fixed Assets 3.      Investments 4.      Miscellaneous Expenses (Asset) 2.      Liabilities 1.      Capital Account 2.      Current Liabilities 3.      Loans (
Post a Comment
Read more

Depreciation and appreciation

Depreciation and appreciation In finance and accounting, terminology is everything. Depreciation and appreciation are two sides of the same coin. Depreciation is when the value of assets goes down, and appreciation is when the value of assets goes up. Another type of depreciation that can confuse people is asset depreciation. This is an accounting term used to describe a certain type of write-off. 1.         Depreciation and appreciation of Fixed Assets: Depreciation : Depreciation is decreased in the value of fixed assets.  It is decreased due to the various reasons.  It is a loss, therefore, depreciation is debited. It decreases the value of fixed assets; therefore, fixed asset account is credited. For example; provide depreciation on furniture Rs. 5,000 p.a. Appreciation : Appreciation is the opposite of depreciation. It increases the value of assets, therefore assets account is debited and appreciation account is credited as a gain of the business. For example; the val
Read more

Tally में Ledgers क्या होते है ?

Tally में Ledgers क्या होते है ?  टैली में किसी भी लेनदेन (Transaction) की एंट्री को करने के लिए Ledger का होना बहुत जरुरी है | क्योकि जब हम टैली में किसी Transaction की एंट्री करते है, तो वो उसकी  एंट्री Ledger में ही करता है | इसलिए टैली में एंट्री करने के लिए Ledger का होना बहुत जरुरी है | अगर हम टैली में Ledger नहीं बनायेगे, तो हम उसमे एंट्री पास नहीं कर सकते है | उदहारण के तौर पर अगर हम बैंक में अपने रुपये जमा करने जाये, तो बैंक में रुपये जमा करने से पहले हमारा उस बैंक में एक खाता (Account) होना चाहिए | ताकि वो उस खाते में हमारे दिए गए रुपये की एंट्री कर सके | मतलब की Transaction करने से पहले हमे उस बैंक में खाता Open (Create) करना पड़ेगा | ठीक ऐसे ही टैली में Ledger होता है, और किसी Ledger में एंट्री करने से पहले उसे Create करना पड़ता है | ताकि हम उस Ledger से होने वाले सारे Transaction की एंट्री उसमे कर सके और जरुरत पड़ने पर हम उस Ledger से सम्बंधित सारी एंट्री को देख सके | 
Post a Comment
Read more

About Prepaid Expenses

What are Prepaid Expenses? Prepaid expenses represent  expenditures that have not yet been recorded by a company as an expense, but have been paid for in advance. In other words, prepaid expenses are expenditures paid for in one  accounting period, but that will not be recognized until a later accounting period. Prepaid expenses are initially recorded as  assets, because they have future economic benefits, and are expensed at the time when the benefits are realized (the  matching principle). Common Reasons for Prepaid Expenses The two most common uses of prepaid expenses are rent and insurance. 1.  Prepaid rent  is rent paid in advance of the rental period. The journal entries for prepaid rent are as follows: Initial journal entry for prepaid rent: Dr     Prepaid Rent                10000 Cr      to Cash                                             10000 Adjusting journal entry as the prepaid rent expires: Dr     Rent Expenses             10000 Cr      to Prepa
Post a Comment
Read more

Interest on Capital

Interest on Capital Owners may seek a return on investment in form of fixed rate of interest to the extent of amount employed by them in the business. In order to ascertain a true picture of the business’ profitability, it is a common practice to provide interest on capital. Journal entry for interest on capital includes two accounts;  Capital A/c  &  Interest on Capital A/c Interest on capital is an expense for the business  and is added to the capital of the proprietor thereby increasing his total capital in the business. It is not paid in cash or by the bank. Journal entry for interest on capital is; Interest on Capital A/c Debit Debit the increase in expense   To Capital A/c Credit Credit the increase in capital Example Provide 10% interest on capital at the end of the year to Raman. His contribution to the business is 1,00,000. Interest on Capital A/c 10,000  T
Read more

About Bad Debts and Bad Debts Entry

Bad Debts Bad debts means that money which we could not acquire from our debtors . We may give the goods or money on credit to our debtors. Same debtor or debtors has to give us the money of his taken debt. But when will not give the debt, it will be the loss of our business , so, we have to pass the entry for bad debts like the entry of any other business loss. All losses account will be debited and any asset which will decrease, will be credited. In case of bad debt following journal entry will be passed. 1. Journal Entry for Bad Debts Loss  For showing this journal entry, it is very necessary that  a debt must be uncollectible. We have done all the efforts but we did not collect the debt. After failure of final notice to the debtor, we will convert our debt in bad debt.  Bad Debt Account Debit Particular Debtor Account Credit Example :  Shyam did not pay us our Rs. 5000 debt and Ram did not pay us our Rs. 10000 debt up to end of the financial year. This receivable am
Post a Comment
Read more

Table of Content in MS Word

Table of Content टेबल ऑफ़ कंटेंट्स आप्शन इन रेफ़रेन्स मेनू इस आप्शन से आप अपनी हैडिंग का इंडेक्स बना सकते है | जैसा कि किताब कि स्टार्ट में हर चैप्टर का इंडेक्स व पेज नंबर दिया जाता जिससे कि आप चैप्टर में आसानी से पहुच सके | इंडेक्स क्रिएट करने का तरीका स्टेप 1: क्रिएट हैडिंग इन डिफरेंट पेज .              सबसे पहले वो टेक्स्ट लिखे जिसे आप हैडिंग बनाना चाहते , फिर उस हैडिंग को सेलेक्ट करके होम मेनू के हेडिंग 1 स्टाइल पर क्लिक करे , इससे आपका लिखा टेक्स्ट हैडिंग बन जायेगा | इसी तरीके से हर पेज पर एक – एक हैडिंग बना ले , और कम से कम 5 पेज बना ले | हैडिंग बनाने के साथ - साथ हैडिंग का मैटर लिख दे या कोई इमेज लगा दे | स्टेप 2: क्रिएट इंडेक्स इन फर्स्ट पेज . अब आप फर्स्ट पेज पर जाये या जहा आप इंडेक्स बनाना चाहाते है , और रेफ़रेन्स के टेबल ऑफ़ कंटेंट्स आप्शन पर क्लिक कर दे | इससे आपका इंडेक्स बन कर आ जायेगा | इंडेक्स अपडेट करने का तरीका आप अपनी फाइल में अब चाहे तो और भी हैडिंग बढ़ा सकते है , और आपकी इंडेक्स आटोमेटिक अपडेट हो जाएगी बस आप को रेफ़रेन्स के अपडेट टेबल आप्शन पर
Post a Comment
Read more

Cost Centres in Tally

Cost Centres Cost Centers का यूज़ हम Ledger के Amount को Break करने के लिए करते है | या इसको इस तरह से भी समझ सकते है कि Cost Centers का यूज़ हम ledger के अमाउंट की Casting करने के लिए भी करते है | माना की हम जिस कंपनी के लिए एकाउंटिंग करते है | उस कंपनी में हर माह 20000/-  रुपये सैलरी दी जाती है | जो कि कंपनी के चार कर्मचारियों में अलग – अलग दे दी जाती है | जिसका विवरण कुछ इस तरह है | Rohan-7000, Aman-5000, Saurabh-4500, Sundar-3500 ऊपर दी गयी एंट्री को अगर हम सीधे सैलरी का ledger बनाकर कर देते है, तो Rohan, Aman, Saurabh and Sundar के अमाउंट को कैसे मेन्टेन करेगे | क्योकि ledger में तो केवल 20000/-   रुपये के एंट्री ही होगी | इस प्रॉब्लम को Solve करने के हम ledger में Cost Centres का यूज़ करेगे | Step1:   Activate Cost Centres Press F11 --> F1 --> Maintain Cost Centres --> Yes Step2:   Create Cost Centres Go to Gateway of Tally --> Accounts Info --> Cost Centres --> Create Create Cost Center. List is given below.           Rohan        
Read more