2.1 Introduction

2.2 Activating Interest Calculation for the Company

2.3 Accounting of Simple Interest

• 2.3.1 Accounting of Simple Interest Amount in the Books of Accounts
• 2.3.2 Recording Payment Voucher with Interest Amount to the Supplier

2.4 Accounting of Compound Interest

• 2.4.1 Accounting of Simple Interest Amount in the Books of Accounts
• 2.4.2 Accounting of Compound Interest Amount in the Books of Accounts
• 2.4.3 Recording Receipt Voucher with Interest Amount from the Customer

2.5 Accounting of Interest on Outstanding Balances

2.6 Interest Calculation Reports

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

3.1 Introduction

3.2 Enabling Job Order Processing in TallyPrime

3.3 Job Work Out Order Processing

• 3.3.1 Voucher Type Set Up
• 3.3.2 Auto Listing of Components Using Bill of Materials
• 3.3.3 Recording of Job Work Out Order Voucher

3.4 Job Work In Order Processing

• 3.4.1 Voucher Type Set Up
• 3.4.2 Auto Listing of Components Using Bill of Materials
• 3.4.3 Recording of Job Work In Order Voucher

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

4.1 Introduction

4.2 Features of Job Costing

4.3 Types of Business that use Job Costing

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

5.1 Introduction

5.2 Cheque Management

• 5.2.1 Configuring Cheque Books
• 5.2.2 Cheque Register

5.3 Post-Dated Cheque Management

• 5.3.1 Features of Post-Dated Cheque Management in TallyPrime
• 5.3.2 Advantages of Maintaining Post-Dated Cheque Management in TallyPrime
• 5.3.3 Recording & Maintaining Post-Dated Cheque in TallyPrime
• 5.3.4 Post-Dated Summary Report
• 5.3.5 Regularizing Post-Dated Vouchers
• 5.3.6 Accounting PDC Transaction for Notional Bank

5.4 Handling e-Payments in TallyPrime

• 5.4.1 One-Time Configuration for e-Payments Feature
• 5.4.2 Modes of e-Payments
• 5.4.3 Activation of e-Payments Feature in TallyPrime
• 5.4.4 Recording e-Payment Transactions
• 5.4.5 Viewing of e-Payments Report
• 5.4.6 Export and Uploading Payment Instructions to the Bank Portal

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

6.1 Introduction

6.2 Overview of Tally.NET Features

6.3 Remote Access in TallyPrime

• 6.3.1 Features of Remote Access
• 6.3.2 Connect Company to Tally.NET Services
• 6.3.3 Creation of Tally.NET Users for Remote Access
• 6.3.4 Modify Security Levels for Tally.NET User
• 6.3.5 Login to the Company in TallyPrime from Anywhere
• 6.3.6 Connectivity Status Report in TallyPrime
• 6.3.7 Logout from Remote Session
• 6.3.8 Disconnect the Company in Server
• 6.3.9 Disable Remote Access for the Company

6.4 TallyPrime Reports in Browsers (TRiB)

• 6.4.1 Features of TallyPrime Reports in Browsers
• 6.4.2 Getting Started with TallyPrime Reports in Browser
• 6.4.3 Creation of Tally.NET ID for the User
• 6.4.4 Create Tally.NET IDs from the Tally Portal
• 6.4.5 View TallyPrime Reports from Anywhere Using the Browser on Desktop/Mobile/Tab
• 6.4.6 Connectivity Status Report in TallyPrime
• 6.4.7 Disconnect the Company in Server

6.5 Data Synchronisation in TallyPrime

• 6.5.1 Features of Data Synchronisation in TallyPrime
• 6.5.2 Modes of Synchronisation in TallyPrime
• 6.5.3 Initializing of Synchronisation in TallyPrime
• 6.5.4 Specifying the Role of the Company
• 6.5.5 Connect Server Company to Tally.NET Server for Synchronisation
• 6.5.6 Defining Client Rules and Activate Server Rules for Synchronisation
• 6.5.7 Synchronising the Data
• 6.5.8 Synchronisation Reports
• 6.5.9 Snapshot Exchange in TallyPrime

6.6 Tally Virtual User (TVU)

• 6.6.1 Technology Options to Run Tally Virtually
• 6.6.2 Tips to Configure Tally for Virtual Usage
• 6.6.3 Virtual Use of TallyPrime
• 6.6.4 How to Avail Additional TVU Packs for Free Trial

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

2.1 Introduction

2.2 Activation of TDS in TallyPrime

2.3 Recording TDS Compliant Transactions

• 2.3.1 Booking of Expenses & deducting TDS in the Journal Voucher
• 2.3.2 TDS Transaction for Purchase of Software
• 2.3.3 TDS on Sales Commission and Deducting TDS
• 2.3.4 Accounting TDS on Capital Expenditure
• 2.3.5 Accounting for TDS on Advance Payments and Adjusting Advances towards Bill
• 2.3.6 Purchase Escalation after Recording TDS Transaction
• 2.3.7 Reversal/Cancellation of Expenses with TDS
• 2.3.8 TDS on Works Contract attracting GST
• 2.3.9 TDS on Payments to Non-Residents (DTAA)
• 2.3.10 TDS on Income from Foreign Currency, Bonds or Shares of Indian Company
• 2.3.11 Accounting Direct Payment and deducting TDS
• 2.3.12 Accounting Multiple Expenses and Deducting TDS later
• 2.3.13 TDS on Reimbursement of Expenses (Pure Agent)

2.4 TDS Payment to Department

• 2.4.1 TDS Outstanding
• 2.4.2 Payment of Tax to the Income Tax Department
• 2.4.3 Generating TDS Challan (ITNS 281)
• 2.4.4 Interest Payment to Income Tax Department on Delayed Tax Payment

2.5 TDS Report

• 2.5.1 Challan Reconciliation
• 2.5.2 Form 26Q
• 2.5.3 Form 27Q

2.6 E-Return

• 2.6.1 Form 26Q
• 2.6.2 Form 27Q
• 2.6.3 TRACES Portal

2.7 Maintaining Books of Accounts as a Deductee

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

3.1 Introduction

3.2 Basic Concepts of TCS

3.3 TCS in TallyPrime

• 3.3.1 Activation of TCS in TallyPrime

3.4 Recording TCS Compliant Transactions

• 3.4.1 Sale of TCS Goods on Accrual Basis
• 3.4.2 Sale of TCS Goods at Lower Rate/Nil Rate
• 3.4.3 Sale of TCS Goods at Higher Tax Rate (Under Section 206CCA)
• 3.4.4 Accounting TCS Exemption for Buyers Deducting TDS
• 3.4.5 TCS on Transfer of Right to Use
• 3.4.6 Accounting for TCS on Advance Receipts and Adjusting Advances towards Bill

3.5 TCS Payment to Department

• 3.5.1 Resolving Uncertain Transactions
• 3.5.2 Payment of Tax to the Income Tax Department
• 3.5.3 Generating TCS Challan (ITNS 281)
• 3.5.4 Interest Payment to Income Tax Department on Delayed Tax Payment

3.6 TCS Reports

• 3.6.1 Form 27EQ
• 3.6.2 Challan Reconciliation

3.7 E-Return

3.8 Maintaining Books of Accounts as a Collectee

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

4.1 Introduction

4.2 Payroll in TallyPrime

• 4.2.1 Creation of Company and Activating Payroll
• 4.2.2 Introducing Capital into the Business

4.3 Creation of Payroll Masters in TallyPrime

• 4.3.1 Employee Masters
  • 4.3.1.1 Employee Categories
  • 4.3.1.2 Employee Group Master
  • 4.3.1.3 Employee Master
• 4.3.2 Creation of Units (Work)
• 4.3.3 Attendance /Production Types
  • 4.3.3.1 Attendance Type Creation
  • 4.3.3.2 Employees Paid Leaves
• 4.3.4 Pay Heads in TallyPrime
  • 4.3.4.1 Understanding on Pay Head Types of TallyPrime
  • 4.3.4.2 Understanding on Pay Head Calculation types in TallyPrime
  • 4.3.4.3 Understanding on Methods of Computation

4.4 Processing Payroll with Income Tax

• 4.4.1 Attendance Vouchers
• 4.4.2 Payroll Vouchers
• 4.4.3 Payment Vouchers

4.5 Payroll Reports

• 4.5.1 Pay Slip
• 4.5.2 Pay Sheet
• 4.5.3 Attendance Sheet
• 4.5.4 Payment Advice
• 4.5.5 Payroll Statement
• 4.5.6 Employee Pay Head Breakup
• 4.5.7 Pay Head Employee Breakup
• 4.5.8 Payroll Register

4.6 Payroll Statutory Reports

• 4.6.1 Summary
• 4.6.2 Provident Fund
• 4.6.3 Employee State Insurance
• 4.6.4 Professional Tax
• 4.6.5 Gratuity
• 4.6.6 Income Tax Reports
• 4.6.7 Challan Reconciliation (Income Tax Payment)

Conclusion

Key Takeaways

Shortcut Keys

Practice Exercises

• Introduction
• Telephone – Vocabulary & Practice Conversation
• Restaurant – Vocabulary & Practice Conversation
• Railway – Vocabulary & Practice Conversation
• Flights – Vocabulary & Practice Conversation
• Hotel – Vocabulary & Practice Conversation
• Deals – Vocabulary & Practice Conversation
• Office – Vocabulary & Practice Conversation
• Party – Vocabulary & Practice Conversation
• Appointment – Vocabulary & Practice Conversation
• Interview – Vocabulary & Practice Conversation
• Bank – Vocabulary & Practice Conversation
• Dealing with Customers – Vocabulary & Practice Conversation
• Practice Exercises

• Introduction
• Reading Comprehensive – 1
• Reading Comprehensive – 2
• Practice Exercises

Chapter 4: Business Idioms

• Introduction
• Business Idioms
• Practice Exercises

• • Introduction
  • Terms

• Abbreviations
• Practice Exercises

• Introduction
• Some Easily Confused Words
• Practice Exercises

• Introduction
• Articles
• Demonstratives
• Possessives
• Quantifier
• Practice Exercises

• Introduction
• Types of Verb Tenses
• Practice Exercises

• Introduction
• Modal Auxiliaries
• The ‘To Be’ Verb
• Phrasal Verbs
• Practice Exercises

• Introduction
• How to form the Plural
• Commonly Used Opposites
• Comparative and Superlative Degrees
• Practice Exercises

• Introduction
• Guidelines to Subject-Verb Agreement
• Practice Exercises

• Question Words and Question Tags
• Practice Exercises

• Direct and Indirect Speech
• Active and Passive Voice
• Practice Exercises

• Introduction
• End of Sentence Punctuation
• Mid-Sentence Punctuation
• Other Punctuation Marks
• Practice Exercises

• Introduction
• What is Perceived as a Problem?
• Type of Problems
• Decision Making
• Practice Exercises

• Introduction
• What is a Group Dynamics?
• Group Problem Solving
• Strategies to Manage Group Dynamics
• Practice Exercises

• Introduction
• Causes of Conflict
• Types of Conflict
• Functions of Conflict
• What is Negotiation?
• Personal Traits to Remember while Negotiating
• Practice Exercises

• Introduction
• Leadership Styles
• Qualities of A Good Leader
• Leaders’ vs Managers
• Practice Exercises

• Introduction
• Personal time management skills include
• Importance of Time Management
• Effective Time Management
• Practice Exercises

• Introduction
• Attributes of Emotional Intelligence
• Importance of Emotional Intelligence
• Effects of Emotional Intelligence
• Developing Emotional Intelligence
• Practice Exercises

• Introduction
• Types of Stress
• Causes of Stress
• How to manage Stress?
• Practice Exercises

• Introduction
• File and Folder Management
• Uses of Wild Card
• Recycle Bin
• Notepad
• Practice Exercise

• Introduction
• Creating and Setup of New Document
• Page Setup
• Formatting Text
• Copy & Paste Using Clipboard
• Save and Save As
• Open Saved File
• Practice Exercise

• Introduction
• Paragraph Formatting Features
• Bullets & Numbering
• Border and Shading
• Format Painter
• Practice Exercise

• Introduction
• Change Case
• Page Break and Section Break
• Understanding Columns
• Auto Correct
• Find and Replace
• Spelling and Grammar Check
• Tracking Changes
• Watermark
• Protect Document
• Practice Exercise

• • Introduction to MS Excel
  • Entering Data in Cell
  • Types of Data
  • Moving Around a Worksheet
  • Format Data
  • Best Fit or Auto Fit
  • Data Editing
  • Working with Worksheet
  • Basic Mathematical Calculation
  • Saving a Workbook
  • Opening and Closing Workbooks
  • Practice Exercise

• Introduction
• Rows and Columns Management
• Change the Colour of Text
• Worksheet Management
• Table Style
• Custom List
• Format Painter
• Practice Exercise

• Introduction
• Filling Series
• Flash Fill
• Number Formatting
• Conditional Formatting
• Name Range
• Adding Comments
• Practice Exercise

• Introduction
• Basic Concept of Formula
• Math and Trigonometry Functions
• Statistical Functions
• Date and Time Function
• Practice Exercise

• Introduction
• IF Function
• Nested IF
• SUMIF
• COUNT and COUNTIF
• COUNTBLANK
• Practice Exercise

• Introduction
• PMT Function
• PPMT Function
• IPMT Function
• PV Function
• FV Function
• Rate
• NPER
• Practice Exercise

• Introduction
• VLOOKUP
• HLOOKUP
• Practice Exercise

• Introduction
• Charts
• Creating Pivot Table
• Pivot Table Formatting
• Pivot Chart
• Practice Exercise

• Introduction
• Data Filter
• Remove Duplicates
• Paste Special
• Data Validation
• Splitting Work Sheet
• Freeze Pane
• Page Setup
• Workbook Protection
• Practice Exercise

• Introduction
• How to Open PowerPoint
• Creating a New Presentation
• Applying Theme, Effect, Quick Styles, and Transition
• Insert a Blank Slide and Creating Text Box
• Custom Animation, Applying Sound, and Speed
• Set Advance Slide and Recording a Narration
• Setting up Slide Show
• Inserting a Picture, Word Art Text, Content Slide Layout, and Background Style
• Save and Reopen PowerPoint Presentation
• Practice Exercise

• Introduction
• Creating Presentation Using Templates
• Slide Master
• Inserting Slide Number, Header and Footer
• Different Views
• Delete Slide, Protecting a Presentation with a Password