Tally Assignment Book

CHAPTER - 1

Getting Functional with Tally.ERP 9

 

1.1.            Tally.ERP 9 Start-Up

1.2.            Tally.ERP 9 Screen Components

1.3.            Mouse / Keyboard Conventions

1.4.            Quitting Tally.ERP 9  

 

CHPATER – 2

Company Info

 

2.1.            Company Creation

2.2.            Opening (Loading ) of Tally.ERP 9

2.3.            Modification of Company

2.4.            Deletion of Company

2.5.            Shut (Close ) a Company

2.6.            Company Selection

 

CHAPTER – 3

Set-Up of Accounts

 

>>        Introduction

>>        Unit Objectives

>>        Assets, Liabilities, Income & Expenses

3.1.            The Group

      3.1.1.   Creating Group

                  3.1.1.1.            Creating a Group with Advanced Usage

                  3.1.1.2.            Creating Multiple Groups

3.1.2.   Altering or Modifying Group

3.1.3.   Permanently Deleting a Group

3.1.4.   Displaying a Group

3.2.            The Ledger

3.2.1.   Creating a Single Ledger

A-        Creating a Purchase / Sales Ledger

B-        Creating a Expenses / Income Ledger

C-        Creating a Party Ledger

D-        Creating Bank Account

E-        Creating Duties and Taxes Ledger

F-         Creating a Current Liabilities / Assets Ledger

3.2.2.   Creating a Multiple Ledger

3.2.3.   Displaying or Alter a Single Ledger Account.

3.2.4.   Deleting a Single Ledger Account

3.3.            Vouchers Types

3.3.1.   Accounting Vouchers

3.3.1.1.      Contra Vouchers (F4)

3.3.1.2.      Payment Voucher (F5)

3.3.1.3.      Receipt Voucher (F6)

3.3.1.4.      Journal Voucher ( F7)

3.3.1.5.      Sales Vouchers (F8)

3.3.2.   Pre-defined Voucher Types in Tally.ERP 9

3.3.2.1.      Alter a Pre-defined Voucher Type

 

 

CHAPTER – 4

Inventory / Items & Goods / Stock

 

>>        Meaning :

4.1.      Creating a Single Stock Group

4.1.1.   Modifying a Single Stock Group

4.1.2.   Displaying a Stock Group

4.1.3.   Deleting a Single Stock Group

4.2.      Creating a Multiple Stock Group

4.3.      Creation of Stock Units

4.4.      Alternation / Deletion of Stock Units

4.5.      Stock Items

4.5.1.   Creation of Single Stock Item

4.5.2.   Creation of Multiple Stock Item

4.5.3.   Modification and Deletion of Stock Item

___Summary

___Questions & Exercises

 

CHAPTER – 5

Features of Tally.ERP 9 and Their Uses ( F11)

>>        Introduction

>>        Unit Objectives

5.1.      Accounting Features

5.2.      Inventory Features

5.3.      Statutory & Taxation Features

 

 

CHAPTER – 6

Accounting Vouchers in Tally.ERP 9

 

>>        Introduction

>>        Unit Objectives

>>        Types of Vouchers

6.1.      Contra Voucher (F4)

6.2.      Payment Vouchers (F5)

6.3.      Receipt Vouchers (F6)

6.4.      Journal Vouchers (F7)

6.5.      Sales Vouchers (F8)

6.6.      Credit Note Voucher (Ctrl + F8) – Sales Return

6.7.      Purchase Vouchers (F9)

6.8.      Debit Note Vouchers (Ctrl + F9)- Purchase Return

6.9.      Memo Voucher (Ctrl + F10)

 

 CHAPTER – 7

GST ( Goods and Service Tax )  in Tally.ERP 9

 

7.1.   Introduction to GST ( IGST . CGST, SGST )

7.2.   Calculation of GST ( IGST, CGST & SGST) (Practical Assignment )

7.3.   GST on Tally.ERP 9 ( With Practical Assignment )

Step-1  :  Activating GST for Your Company

         Step-2  : Setting Up GST Rates

              A-        To Set GST Rates for Stock Groups and Stock Items

              B-        Updating Stock Items and Stock Groups for GST Compliance

              C-        Setting MRP Details

              D-        Mapping UoM to UQC

         Step-3  :   Updating/Creating Sales and Purchase Ledgers for GST                          Compliance

                        A-        Updating / Creating a Sales Ledger : GST Sales

     B-        Updating or Creating a Purchase Ledger :                 GST- Purchase

             C-        Updating or Creating a Inter-State Purchase Ledger :                     Inter-State Purchase

             D-       Updating or Creating a Inter-State Sales Ledger :                    GST-Inter-State Sales

         Step-4  :   Restarting Voucher Numbering for GST Transactions

         Step-5      :           Updating/Creating Party GSTIN/UIN

         Step-6      :           Creating GST Ledgers

         Step-7      :           Creating Party Ledgers for GST

         Step-8      :           Recording Purchase under GST

               A- Local Purchase  ( inside State)

               B- Inter-State Purchase ( outside State)

         Step-9 :   Recording GST Sales and Printing Invoices

              A – Local Sale

              B- Printed Invoice Format

              C- Inter-State Sales (Outside State)

              D- Sale of Goods and Services in a Single Invoice

    E- Ledgers for any Indirect Expenses like… Discount on Sale, Packing Charges etc. can be created and to be included in GST Sale Invoice

7.4.   Generate GSTR-1 Returns / Reports under Tally.ERP9

7.4.1.   Table-Wise Format (Department Format)

7.4.2.   Returns Summary ( GSTR-1)

            7.4.2.1.            Total number of vouchers for the period

            7.4.2.2.            Included in returns

            7.4.2.3.            Not relevant for returns

            7.4.2.4.            Incomplete / Mismatch in information (to be resolved)

                        (SUMMARY OF EXCEPTIONS – GSTR-1)

7.4.2.4.1.         No. of voucher with incomplete / mismatch in information

                        7.4.2.4.2.        UoM (S) Not Mapped To Unit Quantity Code                                                            (UQC)

                        7.4.2.4.3.         Country , State and Dealer Type not                                                             Specified

                        7.4.2.4.4.         Tax Rate / Tax Type not Specified

7.4.2.4.5.         Nature of transaction, taxable value, rate of tax modified in voucher

7.4.2.4.6.         Incorrect tax type selected in tax ledger

7.4.2.4.7.         Mismatch due to tax amount modified in voucher

7.4.2.4.7.1.      Voucher with incomplete / incorrect adjustment details ( SGTR-2)

7.4.2.4.8.         Information required for generating table-wise details not provided

7.4.2.4.9.         Exception Types

7.4.2.4.9.1.      Item Exceptions

7.4.2.4.9.2.      Ledger Exceptions

                7.4.3.   GSTR-1 Particulars ( Computation Details)

            7.4.3.1.            Outward Supplies

7.4.4.   Status Reconciliation (GSTR-1)

7.4.4.1.            Set Status

7.4.4.2.            Status-wise View

7.4.5.   Exporting GSTR-1

7.5.      Generate GSTR-2 Returns / Reports under Tally.ERP9

7.5.1.   Returns Summary

7.5.1.1.            Total Number Of Vouchers For The Period

7.5.1.2.            Included in the Returns

7.5.1.3.            Not Relevant for Returns

7.5.1.4.            Incomplete / Mismatch in information ( to be resolved)

[ SUMMARY OF EXCEPTIONS – GSTR-2 ]

7.5.1.4.1.         No. of voucher with incomplete /                         mismatch in information

7.5.1.4.2.         UoM not mapped to Unit Quantity Code                         (UQC)

7.5.1.4.3.         Country, State and Dealer Type not                         Specified

7.5.1.4.4.         Tax Rate/ Tax Type Not specified

7.5.1.4.5.         Nature Of Transaction, Taxable Value, Rate Of Tax Modified In Voucher

7.5.1.4.6.         Incorrect Tay Type Selected in Tax Ledger

7.5.1.4.7.         Mismatch due to Tax Amount Modified in Voucher

7.5.1.4.8.         Voucher with incomplete / incorrect Adjustment Details (GSTR-2)

7.5.1.4.9.         Information required for Generating Table-Wise details not Provided

                 7.5.1.4.9.1.      Party Ledger Level Corrections

                 7.5.1.4.9.2.      Voucher Level Corrections

7.5.1.4.10.         Exception Types

7.5.1.4.10.1.      Item Exceptions

7.5.1.4.10.2.      Ledger Exceptions

7.5.2.   Status Reconciliation ( GSTR-2)

7.6.      Generating Form GSTR-3B

7.6.1.   Default View

7.6.2.   Table-wise View

7.6.3.   Generate GSTR-3B and File Returns

7.7.      Challan Reconciliation Report for GST Payments

7.8.      Creating Income and Expenses Ledger in GST

7.9.      Reverse Charge on Purchase from Unregistered Dealer (URD) | Reverse Charge in GST in Tally

Step-1:   Create Supplier Ledger i.e. Supplier (L) URD – Local

Step-2:   Similarly.. Create Supplier Ledger of Outside State i.e. Supplier                           (O) URD- Interstate

Step-3:   Create  Local Purchase Ledger i.e. “Purchase from URD-Local”

Step-4:   Similarly.. Create  Outside Purchase Ledger i.e. “Purchase from URD-Interstate

            Step-5:   Recording an Invoice for Purchase from Unregistered                           Dealer- Local

            Step-6 :  Similarly, You can Record an Invoice for Purchase from                Unregistere Dealer-Interstate (Outside State)

Step-7 :  View Total Tax Liability under Reverse Charge GST in GSTR2

Step-8 :  Recording a Journal Voucher Transaction for Increase in Tax Liability on Purchase from Unregistered Dealers

7.10.    GST On Advance Payment Received From Customer in Tally | GST in Tally             ERP 9

7.10.1. Advance Receipt exclusive of tax adjusted against Sales Invoice in the same month

7.10.1.1.          To record a receipt voucher for advance receipt from customer exclusive of tax

7.10.1.2.          Sales Invoice Linked to an Advance Receipt Voucher in the same month as above.

7.10.2. Advance Received and Sales Invoice recorded in different months.

                        7.10.2.1.          Advance Receipt Voucher

                        7.10.2.2.          Journal Voucher to Raise the Liability

7.10.2.3.          Sales Invoice against Advance Receipt of Previous                                     Month

7.10.3. Journal Voucher to Reverse the Tax Liability raised  for the Advance Received of the Previous Month

                        7.10.3.1.          To exclude a transaction

7.10.3.2.          To reverse the liability on cancellation of a                                     transaction

7.11.    Recording An Advance Payment To Supplier Under GST

7.12.    Transferring Tax Credits of VAT, Excise, and Service Tax to GST

7.13.    Recording Sales of Composite Supply under GST ( Expenses Apportioning)

7.14.    Nil-Rated Sales

7.15.    Exempt Sales

7.16.    Adjustment & Set-off  the Liability of GST (Tax) Credit under GST

 

CHAPTER – 8

Advanced Inventory Vouchers in Tally.ERP 9

  • Introduction
  • Unit Objectives
  • Standard Vouchers

8.1.      Order Processing

            8.1.1.   Purchase Order Processing

            8.1.2.   Altering a Purchase Order

            8.1.3.   Sales Order Processing

            8.1.4.   Altering a Sales Order

            8.1.5.   Display Order Position

            8.1.6.   Display Columnar Orders & Stock Details

            8.1.7.   Adjusting Orders

8.2.      Re-Order Levels

            8.2.1.   Defining Re-Order Levels

            8.2.2.   Display Re-Order Status

8.3.      Tracking Numbers

            8.3.1.   Using Tracking Numbers

            8.3.2.   Display Purchase Bill Pending

8.4.      Batch-wise Details

            8.4.1.   Activating Batch-wise Details

            8.4.2.   Using Batch-wise Details in Sales Invoice

8.5.      Bill of Materials ( BoM)

            8.5.1.   Creating Bill of Materials

            8.5.2.   Creating a Manufacturing Journal

            8.5.3.   Using Bill Of Materials

8.6.      Price Levels and Price Lists

            8.6.1.   Activating Price Lists and Defining Price Lists

            8.6.2.   Using Price Lists

8.7.      Zero Valued Entries

            8.7.1.   Creating Zero Valued Entries

8.8.      Inventory Ageing Analysis

            8.8.1.   View Inventory Ageing Report

8.9.      Different Actual and Billed Quantities

            8.9.1.   Using Different Actual and Billed Quantities

8.10.    Physical Stock Voucher ( Alt + F10)

8.11.    Rejection In ( Ctrl + F6)

8.12.    Rejection Out ( Alt + F6)

8.13.    Stock Journal ( Alt + F7)

 

CHAPTER – 9

 

9.1.      Advance Usage of Vouchers

9.2.      Maintain Bill-wise Details

9.3.      Cost Center and Cost Category

9.4.      Interest Calculation

9.5.      Reversing Journal

9.6.      Post-Dated Voucher

9.7.      Memo (Memorandum) Voucher

9.8.      Optional Voucher

 

CHAPTER – 10

Tally.ERP 9 Reporting

 

  • Introduction
  • Unit Objectives

10.1.    Modifying Reports (Options)

10.2.    Balance Sheet

10.3.    Profit & Loss Account

10.4.    Stock Summary

10.5.    Trial Balance

10.6.    Day Book

10.7.    Books of Accounts

10.7.1. Cash Book

10.7.2. Petty Cash Book

10.7.3. Bank Book

10.7.4. Journal Register

10.7.5. Ledger

  • Group Summary
  • Group Voucher

10.7.6. Purchase Register

10.7.7. Sales Register

10.8.    Statement of Accounts

10.8.1. Outstanding

            10.8.1.1.          Ledger-wise view of Outstanding Reports

            10.8.1.2.          Group (Outstanding)

10.8.2. Interest Calculations

10.8.2.1.          Interest Receivable

10.8.2.2.          Interest Payable

10.8.3. Cost Centers

10.8.3.1.          Cost Category Summary

10.8.3.2.          Group Break-Up

10.8.4. Statistics

10.9.    Inventory Books

10.9.1. Inventory Group Summary

10.9.2. Stock Transfers

10.9.3. Physical Stock Register

10.9.4. Sales Order Book

10.9.5. Purchase Order Book

10.10.  Statutory Reports

10.11.  List of Accounts ( Chart of Accounts)

10.12.  Exception Reports

10.12.1. Negative Stock

10.12.2. Negative Ledgers

10.12.3. Overdue Receivables

10.12.4. Overdue Payable

10.12.5. List of Memorandum Vouchers

10.12.6. List of Reversing Journal

10.12.7. List of Optional Voucher

10.12.8. List of Cancelled Vouchers

10.12.9. List of Post Dated Voucher

10.13.  Printing Reports

10.13.1. Using the Print Button

10.13.2. Multi-Accounting Printing

 

Беккер отчаянно давил на тормоз, но покрышки потеряли всякое сцепление с полом. Спереди на него быстро надвигалась стена. Такси все еще продолжало крутиться, и в ожидании столкновения он сжался в комок.

0 thoughts on “Tally Assignment Book

Leave a Reply

Your email address will not be published. Required fields are marked *