Diploma in Computerized Financial Accounting Course in Kolkata

Computer Fundamentals & Windows (5)

1. Computer Fundamentals & Windows Basics
2. Hardware, Software & Windows Introduction
3. WordPad & Basic Text Editing
4. File Management & Paint Introduction
5. Paint Advanced & OLE

Microsoft Word (9)

1. Loading, Components, Title Bar, Ribbon, Tab, Bars, Layout
2. Find and Replace, Formatting, Font, Character Spacing, Text Effects
3. Alignment, Bullets & Numbering, Indentation & Spacing, Drop Capital
4. File Management & Document Themes
5. Styles, Columns & Track Changes
6. Quick Parts & Document Tools
7. Templates & Document Enhancement
8. Spelling, Tables & Graphics
9. Mail Merge & Macros

Microsoft Excel (12)

1. Excel Screen components, Title bar, Ribbon, Tab, Backstage, Formula Bar
2. Formulas & Worksheet Management
3. Rows, Columns & File Management
4. Cell Formatting
5. Comments & Practice
6. Cell References & Sorting
7. Excel Functions
8. Charts & Graphics
9. Data Query & Analysis Tools
10. What-If Analysis
11. Pivot Tables & Charts
12. Data Forms & Macros

Microsoft PowerPoint (2)

1. PowerPoint Basics
2. Animations & Multimedia

Internet & Connectivity (2)

1. Internet Fundamentals
2. Email Configuration & Video Conferencing

Google Workspace (2)

1. Google Forms
2. Google Docs Suite

Printing, Scanning & Security (2)

1. Printing & Scanning
2. Antivirus & File Transfer

Revision and mock test (2)

1. Quiz and doubt-clearing session
2. Mock Test

Accounting fundamentals (6)

1. Understanding the concept of Accounts, types of organization, accounting basis
2. Double entry system, Different types of Accounts, Golden Rule
3. Recording different accounting transactions
4. Meaning of Depreciation, Reserve and Provision
5. Trial Balance, Final Accounts and Different types of voucher
6. Subsidiary Books

Doubt-clearing sessions (3)

1. Doubt Clearing Session
2. Doubt Clearing Session
3. Doubt Clearing Session

Tally Level 1 (21)

1. Fundamental of Accounts
2. Recording Business Transaction, Trial Balance, Final Accounts
3. Subsidiary books, Depreciation
4. Introduction to Tally Prime
5. Company Information
6. Mock Test 1
7. Maintaining Chart of Accounts - Accounts Masters
8. Maintaining Chart of Accounts - Inventory Masters
9. Multi Masters creation and Display Chart of Accounts
10. Accounting Voucher - Contra, Payment, Receipt, Journal
11. Accounting Voucher - Purchase, Sales, Debit Note and Credit Note
12. Mock Test 2
13. Banking
14. Final Accounts reports in Tally and MIS Reporting
15. Mock Test 3
16. Introduction to Data Security
17. Different users, Tally Vault, Auto login option
18. Introduction to Company Data Management
19. Introduction to Goods and Service Tax
20. Mock Test 4
21. Doubt Clearing Class

Tally Level 2 (17)

1. Storage and Classification of Inventory
2. Price Levels and Price Lists
3. Accounts Payables and Accounts Receivables
4. Specifying Credit Limits for Parties
5. Mock Test 1
6. Purchase Order Management
7. Sales Order Management
8. Re-Order Level, Inter Godown Transfer for Stock
9. Introduction to Track Additional Costs of Purchase
10. Cost and Profit Centre Management
11. Mock Test 2
12. Introduction to Budgets
13. Introduction to Scenario Management
14. Generating and Printing various reports including MIS reports
15. Mock Test 3
16. Doubt Clearing Session
17. Doubt Clearing Session

Tally Level 3 (20)

1. Goods and Service Tax (GST) - Introduction
2. GST in Tally Prime - Intrastate and Interstate Purchase and Sales Entry
3. GST in Tally Prime - Invoice, Debit Note and Credit Note
4. Hierarchy of Calculating Tax in the Transactions
5. Recording GST Compliant Transactions, Multiple GST, Service inclusive of Tax
6. Input Tax Credit set off against Liability, GST Tax Payment
7. Introduction to E-Way Bill, E-Way Bill Report
8. GST e-Invoicing
9. Generating and Filing GST Returns for Regular dealer in Tally
10. Generating e-Invoice in Tally Prime
11. Quarterly Return and Monthly Payment Scheme
12. Composition Dealer under GST Regime
13. Mock Test 1
14. Introduction to TDS, TDS in Tally Prime
15. Recording TDS Compliant Transactions in Tally Prime
16. TDS Payment to Department, TDS Report
17. Mock Test 2
18. Managing Business Data
19. Open Database Connectivity (ODBC), Going forward to the next Financial Year
20. Mock Test 3

1. Excel Features, Cell referencing, Name ranges, Rearranging data, Cut, Copy, Paste Special, AutoFill, Transpose
2. Subtotals, Protection of cell, sheet, workbook, Excel file
3. Compute and analyze data with: SUMIF, SUMPRODUCT, COUNTA, COUNTBLANK, COUNT, COUNTIF, IF, AND, OR
4. Information functions: CONCAT, TEXTJOIN, MAXIFS, MINIFS, IFS, COUNTIFS, SUMIFS
5. Numeric functions: CELL, ABS, CODE, MAX, MIN, FIXED, FLOOR, ROUND, MOD, ODD, EVEN, POWER, SIGN, PI
6. String functions: CHAR, UPPER, LOWER, LEFT, LEN, MID, RIGHT, Logical functions: ISBLANK, ISERROR, ISLOGICAL, ISNUMBER, ISTEXT
7. Database functions: DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DSUM, DGET
8. LOOKUP, VLOOKUP, HLOOKUP, VLOOKUP & HLOOKUP with SUM, INDEX, MATCH, INDEX + MATCH
9. DATEVALUE, WEEKDAY, DATEDIF, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, WORKDAY, YEAR
10. Financial functions: PMT, PV, FV, NPER, IPMT, PPMT, RATE, NPV, IRR, Statistical: STDEV, MODE
11. Goal Seek, Scenario, Solver, Forecast Sheet, Import data from Access, Text, Web, Others, existing connection
12. Advanced filtering, Sorting data, Custom sorting, Summarizing data, Grouping. Data validation, Sparklines
13. Utility of Excel Table, Reporting hierarchical data, New Query, Power Query function, Query Editor, Power Map
14. PivotTable, Editing the PivotTable, Advance PivotTable, Summarizing, PivotTable from existing connections
15. Charts and graphs, Slicer, Timeline, Forecasting, Dashboard management, Donut chart, Progress chart
16. Introduction to Macro, Recording, understanding code behind, Adding other add-ins, Macro with buttons
17. Excel AI tools (built in), Formula writing with ChatGPT
18. Data summary & reports with AI, Forecasting & trend analysis with AI, Dashboard creation with AI help

GST (10)

1. Input Tax Set-off (including changes implemented by GOI), Carry-forward of ITC and liability set-off
2. Concept of ITC eligible & ineligible. Block Credit with case studies, capital assets, consideration of depreciation etc
3. Detailed Concept of RCM, Self-invoicing
4. Debit & Credit Notes, raising Supplementary Invoice. E-Invoice
5. All about Export taxable, exempted. LUT, SEZ, Deemed Export.
6. GST on service sector. E-commerce operator. Accounting treatment of all the above topics in Tally.
7. Rectification of various GST related errors Practical transaction basis. Portal overview. GSTR-1, 1A, 2B, 3B, Cash Ledger, Credit Ledger
8. TDS under GST: concept and applicability
9. TCS under GST: concept and applicability
10. Consequences for being default in GST

Payroll (4)

1. Definition and Concept of Salary, Allowances, Professional Tax
2. Concept of PF, ESIC, Accounting Treatment
3. Generation of PAY SLIP. Auto-calculation of contributions.
4. Portal overview, Consequences for being default in various ACTs.

TDS (5)

1. Definition and Concept
2. Accounting treatment. Generation of Challan & reports, Rectification of various errors,Practical transaction basis
3. E-payment of TAX, Concept & overview of Form 24Q, 26Q, 27EQ
4. Preparation of TDS & TCS Return in RPU
5. Portal overview. E-payment, Challan download, .fvu creation, Due dates & Consequences for being default

Income Tax (11)

1. Definition & basic concept, Income Tax Slab under various Tax Regime.
2. Exempt Income, Tax Rebate, Chapter-VI, Clubbing of Income.
3. Calculation of Leave Encashment, Leave Travel Allowance, Payment under Gratuity Act.
4. Perquisites, Computation of Income. Calculation of Tax Liability
5. Capital Gain Property & Stock Market. Exemption & Set-off.
6. Concept of ITRs. Generating .json file with excel utility provided by the Dept.
7. E-payment of Tax, Applicability of Tax Audit.
8. Practical approach to final accounts.
9. Filing of return on Presumptive Income basis.
10. Filing of return on regular income.
11. Concept of Form 10IE-A, Tax Planning of Individuals.

MCA (3)

1. Searching of Master Data Companies, Directors, Index of Charges, Concept of Capital Structure, inter-relation & difference between Promoter, Shareholder and Director
2. Concept of Forms Spice+A & B, INC-33, INC-34, AGILE PRO, INC-9
3. Concept of AOC-4, MGT-7 & 7A, ADT-1.

Doubt-clearing sessions (2)

1. Doubt Clearing Session
2. Doubt Clearing Session