Office Automation & Finance Accounting Course

Advance formulas

• Date time function
• Draw symbol and insert picture
• Emi calculation
• Page setup
• Array function
• Formatting cell and workbook

Business Accounting with Tally Prime

• Introduction Of Tally Prime
• Accounting Assumptions, Concepts and Principles
• Accounting Principles
• Double Entry System of Accounting
• Types of Accounts
• The Golden Rules of Accounting
• Recording of Business Transactions
• The Accounting Equation
• Recording of Transactions in Books of Original
• Entry/Journal
• Use of Debit and Credit
• Rules of Debit and Credit
• Recording of Business Transactions in Journal
• Accounting Vouchers
• Receipt Voucher (F6)
• Contra Voucher (F4)
• Payment Voucher (F5)
• Purchase Voucher (F9)
• Sales Voucher (F8)
• Debit Note Voucher
• Credit note Voucher

Maintaining Chart of Accounts in Tally. ERP

• Introduction To Tally ERP
• Getting Started with Prime
• Mouse/Keyboard Conventions
• Company Creation
• Shut a Company
• Select a Company
• Alter Company Details
• Company Features and Configurations
• F11: Company Features
• Ledger Creation
• Altering and Displaying Ledgers
• Display of Ledgers
• Deletion of Groups and Ledgers
• What is Ledger?
• Classification of Ledger Accounts
• Posting from Journal
• Financial Statements
• Trading Account
• Profit & Loss Account
• Balance Sheet
• Accounts Payables and Receivables
• Maintaining Bill-wise Details
• Activation of Maintain Bill-wise Details Feature
• New Reference
• Against Reference
• Advance Reference
• On Account Reference

Maintaining Stock Keeping Units (SKU)

• Introduction To Inventory Masters in Tally prime
• Creating Inventory Masters
• Creation of Stock Group
• Creation of Units of Measure
• Creation of Stock Item
• Creation of Go down
• Purchase cycle
• Sales cycle
• Stock Management In Tally

Storage and Classification of Inventory

• Godown Management
• Activating Godown
• Creating A Godown
• Recording Of Purchase, Sales And Stock
• Transfers With Godown Details
• Purchase Of Inventory
• Recording Stock Transfer Entry Using Stock
• Journal
• Sale Of Inventory
• Analyzing Godown
• Movements Of Goods In Batches
• Activating Batch-Wise Details In Tally Prime
• Using Batch-Wise Details In Purchase Invoice

TDS & GST Taxation

• Levy and exemption from Tax
• Current tax under GST Regime
• Overview Of Intra State Purchase & Sales
• Overview Of Inter State Purchase & Sales
• Overview GST Work Flow
• Electronic Commerce
• Explain E-Way Bill
• Overview E-Way Bill Work Flow
• Explain GST Number Code
• GST Registration Process
• Explain Composition Scheme
• How Will I File GST Return?
• GST Payments
• GSTN Portal Information
• Explain Ledger Of GSTN Portal
• Explain Input Credit Adjustment
• Explain ITC On Closing Stock
• Explain Late Fee & Fines & Cancellation Of GST No.
• Explain GST Rates
• Create Company And Active GST In Company Level
• Creating Masters And Set GST Rates
• Creating Tax Ledger
• Transferring Tax Credit Of VAT, Excise And
• Service Tax To GST
• Recording GST Sales And Printing Invoice
• Recording GST Interstate Sales And Printing Invoice
• Recording An Advanced Payment To Supplier
• Under GST
• Recording GST Local Purchase
• Recording GST Interstate Purchase
• HSN Code & SAC Codes
• Recording Vouchers with TDS
• Introduction To TDS
• Basic Concepts of TDS
• TDS Process
• TDS in Tally prime
• Activation of TDS Feature in Tally Prime
• TDS Statutory Masters
• Configuring TDS at Ledger Level
• Recording Transactions
• Activate of TDS During Voucher Entry

Advanced Tally Prime

• Payroll Accounting in Tally
• Payroll with Taxation Features
• Back up & Restore
• Interest Calculation
• Cheque Printing in Tally
• TCS – Tax Collected at Source
• Cost center and cost category
• Cost center with cost center class
• Budeget & Control
• Integrate Tally Prime with WhatsApp
• Integrate Tally Prime with Excel
• Integrate Tally Prime with Dashboard