Tally Prime with Excel Course by Ravikiran Nitin Mishra

This online Tally Prime with Advanced Excel professional training is designed for students, job seekers, accounting beginners, and working professionals who want to build strong, practical skills in computerised accounting. The course is structured to help learners understand accounting fundamentals first and then gradually move into hands-on work with Tally Prime, GST transactions, inventory management, payroll processing, financial reporting, and day-to-day bookkeeping tasks. Advanced Excel concepts are also included to support accounting data management and reporting.

Overview

Tally Prime is one of the most widely used accounting and business management software tools in India and across the world. Combined with Excel skills, it opens up strong opportunities in accounting offices, corporate finance departments, audit firms, tax consultancies, and freelancing projects. This course focuses on concept clarity with practical implementation, so learners are able to confidently handle real-world accounting responsibilities.

Tally Accounting Course – Professional Syllabus

Module 1: Fundamentals of Accounting

• Basic accounting concepts and principles

• Types of accounts

• Debit and credit rules (Golden Rules of Accounting)

• Journal entries with practical examples

Outcome: Strong foundation in accounting concepts.

Module 2: Introduction to Tally & Company Setup

• Overview of Tally Prime

• Company creation and configuration

• Financial year settings

• Ledger creation and grouping

• Best practices for company setup

Outcome: Ability to independently set up a company in Tally.

Module 3: Day-to-Day Accounting Transactions

• Purchase and sales entries

• Receipt and payment vouchers

• Contra entries

• Debit notes and credit notes

• Voucher modification and correction

Outcome: Hands-on experience with routine accounting work.

Module 4: GST Accounting in Tally

• Basics of GST (CGST, SGST, IGST)

• GST configuration in Tally

• GST ledger creation

• Sales and purchase entries with GST

• Overview of GST returns (GSTR-1, GSTR-3B)

• Common GST errors and troubleshooting

Outcome: GST-compliant accounting and billing knowledge.

Module 5: Inventory Management

• Stock group and stock item creation

• Units of measurement

• Purchase and sales with inventory

• Godown and location management

• Stock valuation and reporting

Outcome: Effective inventory tracking and control.

Module 6: Banking & Bank Reconciliation

• Bank ledger setup

• Cheque and online transaction entries

• Bank Reconciliation Statement (BRS)

• Identification and resolution of reconciliation differences

Outcome: Accurate bank reconciliation and audit readiness.

Module 7: Payroll Processing (Optional)

• Employee master creation

• Salary structure setup

• PF and ESI basics

• Payroll voucher processing

Outcome: Understanding of payroll accounting.

Module 8: Final Accounts & Financial Reports

• Trial Balance preparation

• Profit & Loss Account

• Balance Sheet

• Outstanding and ageing reports

Outcome: Ability to generate and interpret financial statements.

Module 9: Practical Accounting & Case Studies

• Real-life accounting case studies

• Data entry from source documents

• Month-wise accounting practices

• Error identification and correction

• Data backup and restoration

Outcome: Job-ready practical exposure.

Module 10: Career & Freelancing Guidance

• Resume preparation for accounting roles

• Interview preparation

• Freelancing and client-handling basics

Outcome: Career readiness and professional confidence.

Benefits & Outcomes

By the end of the course, students will be able to:

• Perform complete accounting operations in Tally Prime

• Handle GST-compliant billing and accounting

• Work confidently with bank reconciliation and inventory

• Prepare financial statements and analyse reports

• Apply Excel functions in accounting-related work

• Improve employability in accounting and finance roles

• Build confidence for office jobs, freelancing, or business support

This training helps students become job-ready and practically skilled, rather than just learning theory. Whether you aim to start a career in accounting or strengthen your bookkeeping knowledge, this course offers a strong, structured learning path.