Monday 1 January 2018

TallyPrime/Tally.ERP9 with GST (Statutory and Taxation) - SYLLABUS

 

TallyPrime/Tally.ERP9 with GST (Statutory and Taxation)

1.    Tally history, basics and Company info

1.    Create company

2.    Select company

3.    Shut company

4.    Alter company

5.    Create group company

6.    Split company data

7.    Change tally vault

8.    Backup

9.    Restore

2.    Gateway of tally

1.    Maintain accounts only (F11 features)

2.    Date

3.    Year /period 

3.    Ledger and trial balance

1.    Single ledger

1.    Create

2.    Display

3.    Alter

2.    Multiple ledger

1.    Create

2.    Display

3.    Alter 

4.    Voucher and reports

1.    Contra

2.    Payment

3.    Receipt

4.    Journal

5.    Sales

6.    Credit note/purchase return

7.    Purchase

8.    Debit note/sales return

9.    Reversing journal

10.  Memorandum vouchers

Day book

Purchase register and sales register

Account books(cash/bank, other ledger accounts)

5.    Adjustments

1.    Outstanding expenses

2.    Prepaid expenses

3.    Accrued income

4.    Income received in advance

5.    Bad debt

6.    Depreciation

7.    Interest on capital and drawings

8.    Goods lost by fire or theft

6.    Stock / inventory creation and reports

1.    Inventory info

2.    Stock summary

3.    Inventory books  and statement of inventory

4.    Stock query

7.    Invoice / day books

1.    Purchase day book

2.    Sales day book 

8.    Cost centre and cost categories

9.    Pricing (multiple price levels)

10.  Budgets (compare actual with desired)

11.  Bank reconciliation

1.    Cheque printing

2.    Banking transaction

1.    Deposit

2.    Withdrawal

3.    Cheque/DD

4.    Net banking/NEFT or RTGS

12.  Order vouchers

1.    Purchase order

2.    Sales order

3.    Job work in order

4.    Job work out order

13.  Inventory vouchers

1.    Delivery note

2.    Receipt note

3.    Rejection in

4.    Rejection out

5.    Stock journal

6.    Physical stock

7.    Material in

8.    Material out

 

14.  Manufacturing journals

15.  Job costing / consignment accounts

16.  Foreign exchange / multi-currency

17.  Track additional cost of purchase

18.  Scenario management

19.  Interest calculation

20.  EMI based interest calculation

21.  Accounting features (company logo, multiple mailing details, income and expenditure a/c)

22.   Inventory features (batch wise details,  job order, cost tracking for stock item)

Statutory and Taxation

GST

1.    GST features

2.    HSN and  SAC

3.    Purchase

1.    Interstate and local purchases

2.    B2B , B2B unregistered

3.    Import goods and services

4.    Nil , exempted , non GST and composition

5.    Debit note

6.    Reverse charging

4.    Sales

1.    Interstate and local sales

2.    B2B, B2C

3.    Credit note

4.    Nil, exempted, non GST sales

5.    Export

6.    Advances

5.    e-Way bill

6.    GST reports

1.    GSTR 1

2.    GSTR 2

3.    GSTR 3B

4.    ITC

5.    Tax payment

6.    Tax adjustments

VAT

Enabling VAT in Tally

1.    Creating a Company

2.    Enabling VAT

1.    Quick Setup

Processing Purchases & Sales Entries

1.    Taxable Purchases and Sales

1.    Purchase of Taxable Goods

2.    Purchase Returns

3.    Sale of Taxable Goods

4.    MRP Based Sales

5.    Sale on Item Rate with Display of MRP In Invoice

6.    Sales Returns

2.    Purchase and Sale of Exempt Goods

1.    Exempted Purchases

2.    Exempted Sales

3.    Sales Returns

3.    Inter-State Purchases and Sales

1.    Inter-State Purchases Against Form C

2.    Interstate Purchases at Multiple CST Rates

3.    Inter-State Sales Against Form C

4.    Inter-State Sales at Multiple CST Rates

5.    Inter-state Sales under Sec. 10

4.    Purchase from Un-registered Dealers

5.    Exports

6.    Import

7.    Works Contract and Job Work

Reversal of Input Tax Credit

1.    Goods used for Civil Structures

2.    Goods used for Consumption

3.    Purchase – Automobile Spare Parts from Non-Dealer of Automobile

4.    Purchase of Air Conditioners from Non-Dealer of Air Conditioners

5.    Goods Distributed as Free Samples & Gifts

6.    Goods Lost on Theft, Loss Etc.

7.    Inputs Damaged in Transit or Destroyed before Manufacture

8.    Loss of Inputs by Fire or Accident

9.    Unavailed Credit on Capital goods (Time Barred)

10.  Consignment/Branch Transfers without Form F

1.    Consignment Transfers without Form F

2.     Reversal of Input Tax Credit on Consignment Sent without Form F

3.    Sales – Branch Transfers

4.    Reversal of Input Tax Credit for Stock Transferred without Form F

11.  Purchases for Production of Exempted Goods (Finished)

12.  Interstate Sale without 'C form

13.  ITC Availed for Finished Goods Subsequently Exempt

14.  Others (specify)

Payment of VAT Liability

1.    Advance Tax, Entry Tax and TDS Adjustment Entries

1.    Adjustment Towards Advance Tax or Refund

2.    Adjustment Towards Entry Tax Paid

3.    Adjustment Towards TDS

2.    Adjustment of ITC against Tax Payable

3.    Adjustment Towards CST Dues

4.    Payment of VAT

5.    Payment of CST

VAT Reports

1.    VAT Computation Report

2.    VAT Commodity Report

3.    VAT Registers

4.    Statutory Returns and Annexures

1.    VAT Return Form I

2.    VAT Return Form I-1

3.    Form W

4.    VAT Annexures

E–VAT

1.    Online Filing

2.    Uploading in Excel Format

Income tax

Configuring Income Tax

Income Tax Master Configuration

1.    Pay Head Configuration

2.    Employee’s Income Tax Declarations

1.    Rent Declaration for House Rent Allowance

2.    Declaration of Investments U/s 80C & 80CCF

3.    Other Deductions (U/s 80D, 80DD, 80E etc.)

3.    Override Income Tax

4.    Tax Configuration

5.    Previous Employer Details

6.    Pay Head Creation for Income Tax Deduction

1.    Creating Income Tax Pay Head

2.    Create/Alter Salary Details

Processing Payroll

1.    Recording Attendance

2.    Processing Payroll Vouchers

1.    Processing User Defined Pay Heads

2.    Processing Salary with Income Tax Deduction

3.    Processing Payments

Income Tax Reports

1.    Computation Report

1.    Salary Projection

2.    Challan Reconciliation

3.    Returns

1.    Form 24Q

2.    Annexure I to 24Q

3.    Annexure II to 24Q

4.    Form 16

5.    Form 12BA

6.    ITR-1

4.    E-Return

1.    E-24Q

2.    Print Form 27A

5.    Exception Reports

1.    PAN Not Available

2.    Other Records

3.    TDS Variance

TDS

Enabling TDS in Tally

1.    Enabling TDS in Tally

2.    Creating TDS Masters

1.    Master Setup

1.     Expense Ledgers

2.    Tax Ledger

3.    Party Ledger

TDS Transactions

1.    Transactions Involving TDS

1.    TDS on Expenses (Journal Voucher)

2.    Payment to Party

3.    Payment of TDS

1.Payment of TDS (Using TDS Helper)

2.Generating TDS Challan (ITNS 281)

TDS Reports

1.    TDS Reports

2.    Computation

3.    Challan Reconciliation

4.    Return

5.    E–Returns

1.    E–TDS

6.    Outstandings

7.    Exception Reports

TCS

Configuring Tally for TCS

1.     Enabling TCS in Tally

2.    TCS Statutory Masters

1.Collectee Types

2.TCS Nature of Goods

Creating TCS Masters

1.    Creation of TCS Masters

2.    Ledger Classifications

3.    Stock Item Classification

TCS Transactions

1.    Sale of Goods Subject to TCS

2.    Sale of Goods Subject to TCS @ Lower Rate

3.    Sale of Goods Subject to TCS @ Nil Rate

4.    TCS on Transfer of Right to Use

5.    Sales Returns

6.    Payment of TCS

7.    Challan Reconciliation

8.    Form 281 Reconciliation/ TCS Reconciliation

TCS Reports

1.    TCS Certificate

2.    Form 27D

3.    Form 27D Reconciliation

Excise

Excise for manufacture

Enabling Excise in Tally

1.    Enabling Excise in Tally

2.    Enabling Excise in Tally

1.    Enabling VAT

2.    Tax Information

Creating Masters

1.    Creating a Customer Ledger

2.    Creating a Supplier Ledger

3.    Creating a Sales Ledger

4.    Creating a Purchase Ledger

5.    Creating VAT Ledgers

1.    Input VAT

2.    Output VAT

6.    Creating Excise Duty Ledgers

7.    Creating CENVAT Ledgers

8.    Creating an Expense Ledger

9.    Creating Excise Voucher Types

1.    Creating Purchase Voucher Type

2.    Creating Sales Voucher Type

3.    Creating a Voucher Type

4.    Manufacturing Journal Voucher Type

10.  Creating Tariff Classification

11.  Creating Stock Item - Raw materials

12.  Creating Stock Item - Finished Goods (MRP)

13.  Creating Stock Item - Finished Goods (Ad Quantum)

14.  Creating Stock Item - Finished Goods (Ad Valorem)

Excise Opening Balances

1.    Accounting CENVAT Credit Opening Balance

2.    Accounting Excise Duty Opening Balance

3.    Accounting PLA Opening Balance

Excise Transactions

1.    Purchase Order with Excise Details

2.    Recording an Excise Purchase Voucher – Not Availing CENVAT Credit

3.    Creating a Excise Purchase Voucher – Availing CENVAT Credit

4.    CENVAT Credit on Purchases from Manufacturer (Duty Value Alteration)

5.    Availing CENVAT Credit on Purchases from Excise Dealers

1.    Avail CENVAT Credit on purchases (in the same invoice).

2.    Avail CENVAT Credit on purchases (later by recording a separate Debit Note)

6.    CENVAT Credit on Capital Goods

7.    Creating a Manufacturing Voucher

8.    Manufacture of Multiple Finished Foods (with or without By-products)

9.    Creating an Excise Sales Voucher – Rule 11 Invoice

10.  Rule 11 Invoice for Stock Items Falling Under Different Valuation Type

11.  Rule 11 Invoice for Stock Items with Expenses

12.  Sales at Special Rate

13.  Removal as Such

14.  Captive Consumption

1.    Accounting Captive Consumption (Duty Chargeable Final Products)

2.    Accounting Captive Consumption (Products Exempted from Duty)

15.  Accounting Exports

1.    Export of Goods under Bond

2.    Export of Goods – Duty Chargeable

16.  Accounting CENVAT Reversal/Refund

17.  Exempt Sales

18.  Accounting Amortisation Sales

19.  Sale of Cement

20.  Excise Stock Transfer

21.  Creating a (Purchase Return) – Rule 11 invoice

22.  Advance Payment of Excise Duty

23.  Creating a Journal Voucher – Adjustment of Advances against the Duty Payable

24.  Creating a Journal Voucher – CENVAT Credit Adjustment

25.  Creating a Payment Voucher – GAR 7 Payment (Without using Auto Fill)

26.  Creating a Payment Voucher – GAR 7 Payment (using Auto fill)

Excise Reports

1.    Excise Computation

2.    Daily Stock Register

3.    PLA Register

4.    Form ER 1

5.    Form ER 5

6.    Form ER 6

7.    E-Return

8.    E-Filling of Form ER 1

9.    Generating ER 1 E-Returns fromTally.ERP9

10.  CENVAT Registers

11.  Credit Summary

12.  Credit Availed

13.  RG 23 Part I

14.  RG 23 Part II

15.  Annexure 10

16.  Abstract

Service tax

Enabling Service Tax in Tally

1.    Enabling Service Tax in Tally

Service Tax Transactions

1.    Purchase of Services

2.    Sale of Services

1.    Sale of Taxable Services

2.    Sale of Services covered under Negative List

3.    Sale of Exempted Services

3.    Adjustment of Input Service Credit towards Service Tax Payable

4.    Payment of Service Tax

5.    Accounting Opening Service Tax Bills

1.    Accounting Opening Balance of Service Tax Payables

2.    Accounting Opening Balance of Service Input Credit

6.    Sale/Purchase Order for Services

1.    Purchase Order for Services (Without Item)

2.    Purchase Order for Services (With Item)

7.    Purchase of Services and Partial Payment to Service Provider

8.    Purchase of Services - Inclusive of Service Tax

9.    Services Partly Subject to Service Tax

10.  Accounting Service Tax on Expenses (Journal Voucher)

11.  Accounting Cash Sale or Cash Purchase of Services

1.    Cash Sale of Services

2.    Cash Purchase of Services

12.  Service Tax Billing for Professionals

13.  Accounting Services as Inventory by Professionals

14.  Advances from Service Receivers and Adjusting Advance received towards the Service bill.114

1.    Accounting Advances from Service Receivers

2.    Adjusting Advance received towards the Service Bill

15.  Sale of Services with Inventory

16.  Accounting Export of Services

17.  Accounting Import of Services

18.  Accounting Pure Agent Services

19.  Account Services with Taxable Percentage

20.  Reversal of Service Amount with Tax

21.  Account Service Tax on total transaction amount including TDS

22.  Tax on Service Purchased (GTA etc.)

23.  Advance Service Tax Payment and Adjust Advance Service Tax Towards the Tax Liability .. 160

1.    Advance Payment of Service Tax

2.    Adjustment of Advances against the Tax Liability

24.  Accounting CENVAT Credit Adjustments

25.  Payment of Interest and Penalties

26.  Accounting Adjustments under Rule 6(3)

27.  Receipt/Payment of Normal Advances and Adjusting Advance against the Service Bill

28.  Accounting Sale/Purchase of Services at Lower Rate of Tax

29.  ST Expenses/Purchases in Payment Voucher

30.  Refund of Service Input Credit

31.  Reversal of Utilised Input Credit

Service Tax Reports

1.    Computation

2.    Service Tax Payables

1.Bill Date-wise

2.Realisation Date-wise

3.Tax on Service Received

4.Import of Services

3.    Input Credit

1.Summary

2.Reversal Details

4.    ST3

1.ST3 Report

2.ST3 E-filing

Excise for dealer

Enabling Dealer Excise in Tally

1.    Enabling Excise in Tally

1.    Create Company

2.    Enable Excise

3.    Enable VAT

Creation of Masters

1.    Sales and Purchase Ledgers

2.    Duties & Taxes Ledger

3.    Party Ledgers

4.    Tariff Classification

5.    Stock Items

6.    Creating Excise Voucher Type

Dealer Excise Opening Stock

1.    Accounting Excise Opening Stock

Transactions

1.    Purchase of Excisable Goods

1.    Purchases from a Manufacturer

2.    Purchases from Agent of a Manufacturer (Consignment Agent)

3.    Purchase From Agent of Manufacturer Purchase from Manufacturer Depot

4.    Purchase from First Stage Dealer

5.    Purchase From Agent of Dealer

6.    Purchases from Importer

7.    Purchases from Agent of Importer (Consignment Agent)

8.    Purchases From Agent of Importer

9.    Selection of Same Item Multiple Times in Excise Purchase

2.    Sale of Excisable Goods

1.    Excise Sales (Excise Invoice)

2.    Excise Invoice without Supplier Trader Information

3.    Excise Invoice cum Commercial Invoice

4.    Commercial Invoice

5.    Sale of Goods Purchased from Agent of Manufacturer (Consignment Agent)

6.    Sale of Goods Purchased From Agent of Manufacturer

7.    Sale of Goods Purchased from Manufacturer Depot

8.    Sales of Goods Purchased From Agent of Dealer

9.    Sale of Goods purchased from Importer

10.  Sale of Goods Purchased from Agent of Importer (Consignment Agent)

11.  Sale of Goods Purchased from Agent of Importer

12.  Selection of Same Item Multiple Times in Excise Sales

3.    Customs Clearance

1.    Full Clearance of Imported Goods

2.    Partial Clearance of Imported Goods

4.    Conditional Pass on of Additional Duty (Imports)

5.    Duty Charging on Excise Purchases and Sales

1.    Charging Duty on Excise Purchases

2.    Charging Duty on Excise Sales

Return of Goods

1.    Sales Returns

2.    Purchase Returns

Reports

1.    Excise Stock Register

2.    Excise Purchase Bill Register

3.    Excise Stock CENVAT Register

1.    Excise Stock CENVAT Register - All Items

2.    Excise Stock CENVAT Register - One Item

4.    Party Wise Duty Extract

5.    Customs Clearance Register

6.    Sales and Purchase Extract

7.    Form RG 23D

8.    Quarterly Return - Form 2

9.    E-Returns