Advance Excel Course in Bangalore

Marathahalli Branch

Tally Prime with GST Course

Become an expert in accounting. Master Tally Prime, GST, Payroll, and Taxation. Join our comprehensive 2-month training to become a certified Tally professional ready for corporate jobs.

Duration
2 Months
Mode
Classroom & Online
Fee
₹18,250/-

    Enquire Now






    Enquiry Sent!

    We will contact you shortly.

    Course Curriculum

    1

    Accounting Fundamentals & Tally Prime Introduction

    • Introduction to accounting: double-entry system, debit and credit rules
    • Types of accounts: personal, real, and nominal accounts with golden rules
    • Understanding financial statements: Balance Sheet, P&L, and Trial Balance
    • Installing Tally Prime and navigating the interface – Gateway of Tally
    • Creating and managing a Company in Tally Prime
    • Company features (F11) and configuration (F12) settings
    • Creating, altering, and deleting Ledger accounts and Groups
    • Pre-defined groups in Tally and when to use them
    • Cost Categories and Cost Centres for department-wise tracking
    • Maintaining budgets and budget variance reports in Tally Prime
    2

    Voucher Entry & Day-to-Day Transactions

    • Types of vouchers: Contra, Payment, Receipt, Journal, and Sales/Purchase
    • Contra voucher: cash withdrawals and fund transfers between accounts
    • Payment and Receipt vouchers: recording cash and bank transactions
    • Journal voucher: adjusting entries, depreciation, and provisions
    • Sales voucher: creating invoices with item and account modes
    • Purchase voucher: recording supplier bills and purchase returns
    • Debit Note and Credit Note vouchers for returns and adjustments
    • Memorandum vouchers and post-dated cheque entry
    • Voucher narration, bill-wise details, and cost centre allocation
    • Reversing journal entries and understanding their use cases
    3

    Inventory Management

    • Enabling inventory features in Tally Prime (F11 configuration)
    • Creating Stock Groups, Stock Categories, and Units of Measure
    • Creating and managing Stock Items with opening balances
    • Godown (warehouse) creation and stock allocation across godowns
    • Purchase Order, Sales Order, and Delivery Note workflow
    • Receipt Note (GRN) and Rejection In/Out vouchers
    • Stock Journal: material transfers between godowns
    • Batch-wise and expiry date tracking for perishable items
    • Multiple price levels and price lists for different customer categories
    • Stock Summary, Movement Analysis, and Ageing Analysis reports
    4

    GST – Goods and Services Tax

    • Introduction to GST: CGST, SGST, IGST, UTGST – rates and applicability
    • GST registration: GSTIN structure, composition scheme, and reverse charge
    • Enabling GST in Tally Prime and configuring company GST details
    • Creating GST-compliant ledgers: input tax, output tax, and integrated tax
    • Configuring HSN/SAC codes for stock items and services
    • Recording GST Sales: B2B, B2C large, and B2C small transactions
    • Recording GST Purchases: local, interstate, and import purchases
    • Handling GST on advances received and advance payments made
    • GST Credit Note and Debit Note with reason codes
    • Nil-rated, exempt, and non-GST supplies – recording and reporting
    • Input Tax Credit (ITC): eligibility, blocked credits, and reconciliation
    • GSTR-1 filing: outward supplies return – generating and exporting from Tally
    • GSTR-3B: monthly summary return – preparation and reconciliation
    • GSTR-2A/2B reconciliation: matching purchase register with portal data
    • E-Way Bill generation and integration with Tally Prime
    5

    TDS – Tax Deducted at Source

    • Introduction to TDS: sections, rates, and threshold limits
    • Enabling TDS module in Tally Prime and configuring deductor details
    • Creating TDS Nature of Payment and TDS ledgers
    • Recording TDS on contractor payments (Section 194C)
    • TDS on professional fees (Section 194J) and rent (Section 194I)
    • TDS on salaries (Section 192) – computation and deduction
    • Lower deduction and NIL deduction certificate handling
    • TDS payment voucher entry and challan details recording
    • Generating Form 26Q and Form 24Q quarterly returns from Tally
    • TDS outstanding report and reconciliation with Form 26AS
    6

    Payroll Management

    • Enabling Payroll in Tally Prime and creating Pay Heads (earnings and deductions)
    • Creating Employee Groups and individual Employee masters
    • Defining Salary Structures: Basic, HRA, Conveyance, Special Allowance
    • Attendance and Leave management: present, absent, LOP, and overtime
    • Processing monthly payroll with Pay Slip generation
    • Provident Fund (PF): employee and employer contribution calculation
    • Employee State Insurance (ESI): applicability, rates, and contribution entry
    • Professional Tax (PT): state-wise slabs and deduction entry
    • Gratuity and bonus provisions in payroll accounting
    • Payroll reports: Pay Sheet, Attendance Register, and Employee Outstanding
    7

    Banking & Bank Reconciliation

    • Creating bank ledgers with account number and IFSC details in Tally
    • Recording cheque-based payments and receipts with instrument details
    • Post-dated cheque (PDC) management and clearing
    • Electronic Fund Transfer (NEFT/RTGS) entry in Tally
    • Bank Reconciliation Statement (BRS): purpose and process
    • Auto Bank Reconciliation using bank statement import (Excel/CSV)
    • Manual reconciliation: clearing matched transactions and identifying mismatches
    • Interest calculation on loans and overdraft accounts
    • Cash Flow and Fund Flow Statement generation from Tally
    • Maintaining petty cash book and imprest system in Tally
    8

    Manufacturing & Bill of Materials

    • Enabling manufacturing features and creating Bill of Materials (BOM)
    • Manufacturing Journal voucher: raw material to finished goods conversion
    • By-product and scrap accounting in the production process
    • Work-in-progress (WIP) tracking and costing
    • Job Work In and Job Work Out workflow in Tally Prime
    • Material consumption reports and production efficiency analysis
    • Costing methods: FIFO, LIFO, Weighted Average for stock valuation
    • Branch and Godown-wise stock management for multi-location businesses
    • Inter-branch stock transfer and accounting entries
    • Production Planning reports: material shortfall and reorder level alerts
    9

    Financial Reports & MIS Statements

    • Trial Balance: viewing, drilling down, and identifying errors
    • Balance Sheet: assets, liabilities, and capital analysis in Tally
    • Profit & Loss Account: gross profit, net profit, and expense analysis
    • Day Book, Cash Book, and Bank Book reports
    • Ledger and Group Summary reports with drill-down capability
    • Outstanding payables and receivables ageing analysis
    • Ratio Analysis report: liquidity, profitability, and solvency ratios
    • Multi-period comparative reports for trend analysis
    • Exception reports: negative stock, overdue bills, and budget variances
    • Exporting reports to Excel, PDF, and emailing directly from Tally
    10

    International Accounting & Multi-Currency

    • Enabling multi-currency feature and creating foreign currencies
    • Setting exchange rates: fixed, standard, and daily rate types
    • Recording import purchases in foreign currency with customs duty
    • Recording export sales with foreign currency invoicing
    • Forex gain/loss calculation and automatic journal adjustment
    • Letter of Credit (LC) and Bank Guarantee accounting
    • Currency filter for ledger and report viewing in foreign currency
    • Export of data in XML/Excel for ERP integration
    • Import of data into Tally using XML and third-party tools
    • Understanding FEMA compliance basics for import/export transactions
    11

    Tally Prime Security, Audit & Data Management

    • Creating Security Levels and user-wise access control in Tally Prime
    • Tally Vault: password-protecting company data with encryption
    • Restricting voucher creation, alteration, and deletion by user role
    • Tally Audit: tracking changes made to vouchers and masters
    • Backup and Restore of company data – best practices
    • Data migration from Tally ERP 9 to Tally Prime
    • Splitting company data for financial year-end processing
    • Year-end closing: opening balance carry-forward and new year setup
    • Tally.NET: remote access and sharing company data over the internet
    • Connecting Tally Prime with GST portal using Tally.NET ID
    12

    Capstone Project & Interview Preparation

    • End-to-end company setup: creating a trading/manufacturing company from scratch
    • Recording one month of complete transactions: purchases, sales, expenses, payroll
    • GST return preparation: GSTR-1 and GSTR-3B from live transaction data
    • TDS deduction, payment entry, and Form 26Q generation
    • Bank reconciliation with sample bank statement
    • Generating full financial reports: Balance Sheet, P&L, and Cash Flow
    • Identifying and correcting common errors in books of accounts
    • Year-end procedures: depreciation entry, provisions, and closing stock
    • Interview Q&A: frequently asked Tally and accounting questions
    • Resume preparation and placement support for Accounts Executive roles

    Why Choose RIA Institute?

    💻

    Industry Syllabus

    Our curriculum is aligned with Tally ERP latest updates (GST/TDS modules) ensuring you learn the most relevant features.

    💼

    Practical Training

    We focus on live scenarios, vouchers, inventory management, and real-time projects for hands-on experience.

    👨‍🏫

    Expert Mentors

    Learn from certified Tally consultants with 12+ years of industry exposure.

    💼

    Career Support

    We help you get placed in top firms like Infosys and Wipro.

    Call Now Button