Syllabus: Business Accounting & Taxation Course

 

Module I â?? Accounts

• Accounting concepts and terminology
• Types of ledgers
• Advance journal entries
• Payroll accounting
• Inventory accounting
• Depreciation and preparation of fixed assets register
• Year-end adjustments entries
• TDS, GST & Income Tax Accounting
• Bank Reconciliation Statement
• Company final accounts as per Companies Act

 

Module II â?? Income Tax & TDS

• Basic concepts & definitions
• Five heads of income
• Income tax deductions
• Computation of income for individual, firm & company
• TDS provisions including applicability, due dates, etc.
• Advance tax provisions, applicability, due dates, etc.
• Payment process for TDS, advance tax & self-assessment tax
• Return filing process for income tax and TDS
• Process for application for PAN & TAN
• Process for generating form 16 & 26AS
• Important tools and features of income tax and TDS website

 

 

Module III â?? Goods & Service Tax

• Basic concepts & definitions
• Scope of supply
• Time, place & value of supply
• Input tax credit provisions
• Composition scheme
• Reverse charge mechanism
• E-way bill
• Accounts & Audit
• Preparation of Tax Invoice, credit note, debit note, etc.
• Process for GST registration, tax payment, refund, return filing, etc.
• GST Rates for different goods or services
• Important tools and features of GST website

 

Module IV â?? Tally

• Entity/ Company Creation
• Accounting & Inventory Master
• Sales & Purchase Process
• Voucher Class
• Banking & bank reconciliation
• Printing 
• Accounts receivable & payable
• TDS reports
• GST Returns, GST Portal & GST Offline Tool
• GSTR 2 reconciliation
• Payment of Tax Liability
• Set off Tax Liability
• DSC â?? Return

 

Module V â?? Microsoft Excel 2013

 

• Introduction of Excel 2013 (New Features)
• Cell References - Relative, Absolute, Mixed & Circular
• Flash Fill (New Feature of 2013)
• Number & Conditional Formatting - Simple & Advance
• Name Range & Comment
• Statistical Functions- Average, Max, Min, Large (New Feature), Small (New Feature), Rank, Count, Count IF, Conta, Countblank
• Logical Functions â?? If, If and, If or, If not
• Data Validation â?? List, Date, Whole Number, Text Length, Custom
• Lookup Functions â?? V Lookup, Hookup
• Financial Functions â?? PMT, PPMT, IPMT, Rate, NPER, PV, FV
• Database Functions â?? Dmin, DMax, DCount, DCounta
• Goal Seek
• Data Table
• Filter â?? Auto & Advance
• Chart - Column (More types), Pie, Pivot
• Freeze Panes
• Protect Workbook & Worksheet
• Page Setup