DIPLOMA IN FINANCIAL MANAGEMENT
Financial accounting professionals are responsible for the public reporting of a company or organization’s financial status. This work involves collecting and maintaining data, detecting trends and forecasting future needs. In addition, financial accountants prepare detailed statements and communicate financial information to company leaders and audiences that do not have an extensive accounting background.
MODULE – 1
- Computer Fundamentals
- Windows
- Using scanner, webcam, printer
Pen-drive, System tools, accessories, etc - Ms-Office
- Word & Excel
- PowerPoint & MS Access
- Internet & Email
Module – 2
Advance Excel with MIS
- INTRODUCING EXCEL
- EXCEL FUNCTIONS
- Conditional Formatting
- USEFUL RIBBON COMMANDS
- PIVOT TABLES & Pivot Charts
- PROFESSIONAL REPORT CREATION
- PAYROLL PROCESSING
- ESI ACT- 1948 & PF ACT-1952
- GRATUITY ACT-1972 & BONUS ACT-1965
- PAYROLL PROCESSING TAX PLANNING FOR SALARIED EMPLOYEES
Module – 3
- DBMS with Access, SQL
- Introduction to Database
- Creating Tables, Forms, Reports
- Importing Data from Excel and SQL
- Creating Queries with Functions
Module – 4
BASICS OF ACCOUNTING & TALLY
Basics of Accounting
- Types of Accounts,
- Golden Rules of Accounting,
- Double Entry System of Book Keeping,
- Financial Statements,
- Recording Transactions
Fundamentals of Tally.ERP 9
- Getting Functional with Tally.ERP 9
- Creation / Setting up of Company in Tallly.ERP 9
- F11: Company Features
- F12 : Configurations
- Chart of Accounts
- Groups
- Ledgers
Inventory in Tally.ERP 9
- Stock Groups
- Stock Categories
- Godowns / Locations
- Units off Measure
- Stock Items Creation
- Voucher Entry in Tallly.ERP 9
- Accounting Vouchers
- Inventory Vouchers
- Invoicing
Generating Basic Reports
- Financial Statements
- Accounting Books and Registers
- Inventory Books and Reports
Technological Advantages of Tally.ERP 9
- Security Controls
- Backup and Restore
- Split Company Data
- Export Report in Excel, PDF & JPEG Format.
- Printing Reports
Advanced Accounting in Tally.ERP 9
- Bill-wise Details
- Cost Centers and Cost Categories
- Voucher Class and Cost Centre Class
- Banking
- Interest Calculations
- Budgets & Controls
- Scenario Management
Advanced Inventory in Tally.ERP 9
- Order Processing (Purchase Order / Sales Order)
- Batch-wise Details
- Bill of Materials (BOM)
- Price Levels and Price Lists
- Stock Valuation
- Zero Valued Entries
- Different Actual and Billed Quantities
Job Costing
- Configuring Job Costing In Tally.ERP 9
- Creating Masters for Job Costing
- Recording Transactions
- Job Costing Reports
TAXATION
- Basic concepts of Tax
- Direct Tax and Indirect Tax
- Overview of Income-tax Law in India
- Components of Income Tax Law
Tax Deducted at Source
- Basic concepts of TDS
- Configuring TDS in Tally.ERP 9
- Processing Transactions
- Printing TDS Reports
- Returns and E-TDS Returns
GST (Goods & Service Tax)
- Basic concepts of GST
- Components of GST
- Concept of CGST, SGST and IGST
- Section 3 of IGST Act, 2016
- GST on Goods & Services
- Section 4 of IGST Act, 2016
- Exempt supplies, non-taxable supplies and zero-rated supplies
- Enabling GST in Tally.ERP 9
- Recording Interstate Transactions in Tally.ERP 9
- Exempt Transactions under GST
- Purchases from Unregistered Dealers
- Inter-State Branch Transfers
- Accounting for Return of Goods
- Rate Difference in Purchase / Sales
- GST for Composite Dealers
- Payment of GST
Tax Deducted at Source
- Basic concepts of TDS
- Configuring TDS in Tally.ERP 9
- Processing Transactions
- Printing TDS Reports
- Returns and E-TDS Returns
Payroll Accounting and Compliance
- Configuring Payroll in Tally
- Creating Payroll Masters
- Processing Payroll in Tally
- Accounting for Employer PF Contributions
- Accounting for Employer ESI Contributions Payment of Professional Tax
- Generating Payroll Reports
Point of Sale (POS)
- Features of Point of Sale (POS) in Tally.ERP 9
- Configuring Point of Sale in Tally.ERP 9
- Entering POS Transactions
- POS Reports
Module 5: BUSY 3.9
- Creating Master
- Account Group
- Item Group
- Material Centre
- Unit (Unit Conversion)
- Bill Of Material
- ST (Sales Tax) Form
- Sales Type Creation
- Purchase Type Creation
- Configuration
- Features / Options
- Masters configuration
- Voucher configuration
- Warning Alarms
- Maximum entries in Vouchers
- Printing
- Columnar Reports
- Email-SMS configuration
- Utilities
- Data freezing
- Reference Management
- Deactivate Account/ Item
- Block Account/ Item
- Data Import Exports
- From Excel
- From SQL
- From Text
- Transactions
- Sales & Purchase Invoice
- Payment & Receipt
- Debit Note/ Credit Note
- Contra Voucher
- Stock Transfer
- Production
- Stock Journal
- Material Issued and received from Party
- Display & Printing
- Balance Sheet & Trial Balance
- Interest Calculations
- Bank Reconciliation
- Stock Status
- Inventory Books
- Sales & GST reports
- MIS Reports
- Purchase & Sales analysis
- Consumption analysis
- Query System