Chapter 1. Fundamentals of Accounting
Introduction
Accounting Terms
Accounting Assumptions, Concepts and
Principles
Assumptions
Concepts
Principles
Double Entry System of Accounting
Types of Accounts
The Golden Rules of Accounting
Source Documents for 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
Ledger
Need for Ledger
Differences between a Journal and a Ledger
Classification of Ledger Accounts
Posting from Journal
Trial Balance
Methods of Preparation
Subsidiary Books & Control Accounts
Cash Book
Single Column Cash Book
Double Column Cash Book
Three Column Cash Book
Petty Cash Book
Purchase (Journal) Book
Purchases Return (Journal) Book
Sales (Journal) Book
Sales Return (Journal) Book
Journal Proper
Control Accounts
Financial Statements
Trading and Profit & Loss Account
Trading Account
Profit & Loss Account
Balance Sheet
Types of Assets and Liabilities included in a Balance Sheet
Chapter 2. Maintaining Chart of Accounts in
Tally Prime Introduction
Getting Started with Tally Prime
Mouse/Keyboard Conventions
Company Creation
Shut a Company
Select a Company
Alter Company Details
Company Features and Configurations
F11: Company Features
F12: Configuration
Chart of Accounts
Ledger Group
Ledger Creation
Single Ledger Creation
Multi Ledger Creation
Altering and Displaying Ledgers
Group Creation
Single Group Creation
Multiple Group Creation
Displaying Groups and Ledgers
Displaying Groups
Display of Ledgers
Deletion of Groups and Ledgers
Chapter 3. Maintaining Stock Keeping Units (SKU)
Introduction
Inventory Masters in Tally Prime
Creating Inventory Masters
Creation of Stock Group
Creation of Units of Measure
Creation of Stock Item
Creation of Godown
Defining of Stock Opening Balance in Tally
Prime
Stock Category
Reports
Chapter 4. Recording Day to Day Transactions in Tally Prime
Introduction
Business Transactions
Source Document for Voucher
Recording Transactions in Tally Prime
Accounting Vouchers
Receipt Voucher (F6)
Contra Voucher (F4)
Payment Voucher (F5)
Purchase Voucher (F9)
Sales Voucher (F8)
Debit Note Voucher
Credit Note (Ctrl+F8)
Journal Voucher (F7)
Key Takeaways
Chapter 5. Accounts Receivable and Payable Management
Overview of Accounts Receivable in TallyPrime
Importance of managing AR effectively for cash flow
Understanding the impact of AR on financial statements
Configuring company settings related t
Accounts Receivable
Creating customer ledger accounts
Defining credit limits and payment terms
Generating sales invoices for goods and
services
Customizing invoice formats and layouts
Including taxes, discounts, and shipping
charges
Entering receipts against invoices
Handling advances and part payments
Managing unallocated receipts
Setting credit limits and credit periods for customers
Monitoring overdue invoices
Sending payment reminders and statements
Reconciling customer accounts with statements
Generating AR aging reports
Analyzing outstanding receivables
Overview of Accounts Payable in TallyPrime
Importance of managing AP for vendor relationships
Understanding the impact of AP on cash flow
Configuring company settings related to Accounts Payable
Creating vendor ledger accounts
Defining terms of payment and credit periods
Entering purchase bills and expenses
Allocating expenses to specific projects or departments
Managing vendor advances and credits
Recording payments against bills
Handling partial payments and advances
Managing unallocated payments
Reconciling vendor accounts with statements
Generating AP aging reports
Analyzing outstanding payables
Chapter 6. MIS Reports
Introduction
Trial Balance
Balance Sheet
Profit and Loss Account
Cash Flow Statement
Ratio Analysis
Books and Reports
Day Book
Receipts and Payments
Purchase Register
Sales Register
Bills Receivable and Bills Payable
Key Takeaways
Chapter 7. Goods and Services Tax (GST) in Tally
Introduction
Goods and Services tax (GST)
Key Takeaways
Chapter 8. Recording Vouchers with TDS (Tax Deducted at Source)
Introduction
Basic Concepts of TDS
TDS in Tally
Activation of TDS Feature in Tally Prime
TDS Statutory Masters
Configuring TDS at Group Level
Configuring TDS at Ledger Level
Booking of Expenses in Purchase Voucher
Busy Accounting
Module 1: Introduction to Busy Accounting Software
Overview of Busy Accounting Software
Features and benefits
Installation and Setup
System requirements
Installation process
Configuration settings
Navigating the User Interface
Dashboard overview
Menu structure and options
Customizing the interface
Module 2: Basic Accounting Concepts
Understanding Accounting Basics
Introduction to accounting terms (e.g., assets,
liabilities, equity)
Types of accounts (e.g., income, expenses,
assets, liabilities)
Creating Company Data
Setting up a new company
Company information setup (e.g., name,
address, financial year)
Module 3: Financial Management
Chart of Accounts
Creating and managing accounts
Types of ledgers (e.g., cash, bank, sales, purchases)
Recording Transactions
Entry of vouchers (e.g., sales, purchase, payment, receipt.
Voucher types and their uses
Bank Reconciliation
Bank reconciliation process
Managing bank accounts in Busy
Module 4: Inventory Management
Inventory Setup
Creating stock items
Units of measurement
Stock groups and categories
Inventory Transactions
Purchase and sales entries with inventory
Stock transfer between locations
Inventory Reports
Stock summary
Stock valuation methods
Module 5: GST (Goods and Services Tax) Compliance
GST Setup
Configuring GST details
GST rates and classifications
GST Transactions
GST-compliant sales and purchase entries
Generating GST reports (e.g., GSTR-1,
GSTR-(3B)
Module 6: Generating Reports
Financial Reports
Balance Sheet
Profit and Loss Statement
Cash Flow Statement
Accounting Reports
Day book
Ledger reports
Trial balance
Module 7: Utilities and Customization
Backup and Restore
Data backup procedures
Restore options
User Security and Access Control
User management
Role-based access control
Module 8: Advanced Topics (Optional)
Budgeting and Forecasting
Setting up budgets
Budget vs. actual analysis
Payroll Management
Employee setup
Salary processing and payroll reports
Financial Year Backup
Restore Backup
ZOHO BOOKS
Module 1: Introduction to Zoho Books
Overview of Zoho Books
Benefits of using Zoho Books for small businesses
Understanding cloudbased accounting software
Module 2: Getting Started
Creating a Zoho account
Setting up your organization profile
Exploring the dashboard and navigation
Module 3: Setting Up Your Account
Configuring company settings
Adding users and roles
Setting up chart of accounts
Module 4: Managing Contacts
Adding customers and vendors
Managing contact information
Setting up contact categories
Module 5: Recording Transactions
Creating and managing invoices
Entering bills and expenses
Managing payments and credits Module 6: Bank and Credit Card Feeds
Connecting bank and credit card accounts
Reconciling bank transactions
Managing bank rules
Module 7: Inventory Management
Setting up inventory items
Managing stock levels
Inventory tracking and adjustments Module 8: Reports and Analytics
Overview of reporting in Zoho Books
Generating financial reports (Profit & Loss, Balance Sheet)
Customizing reports and dashboards
Module 9: Security
Managing user permissions and security settings
Data backup and recovery Module 10: Additional Features and Tips
Multicurrency transactions
Handling taxes and compliance
GST Practical Course
Registration in GST
Registration is the first task every taxable person should when they are starting the business or starting a new office in another state. They can complete Part A and Part B for GST REG01 after filling necessary information and uploading relevant documents.
Payment of Taxes
You can make a GST payment either online or offline. Businesses must assess the tax that needs to be paid in cash after the offset of the input tax credit availed. Thereafter, it must generate a GST challan either before or after logging into the GST portal or while filing the GST return.
Eway Bill
A waybill is a document issued by a carrier giving details and instructions relating to the shipment of a consignment of goods. Typically it will show the names of the consignor and consignee, the point of origin of the consignment, its destination, and route. Eway Bill is required for movement of goods worth more than Rs. 50,000/ or as per rules. GSTR3B
GSTR3B is a selfdeclared summary GST return filed every month (quarterly for QRMP scheme). A separate GSTR3B must be filed for every GSTIN. The GST liability must be paid on or before the date of filing GSTR3B, earlier of its due date. GSTR1
GSTR1 is a sales return that is required to be filed by every GST registered person. Tax payers are to enter details relevant to their sales & outward supplies in the GSTR 1 sales return.
Advance Excel Course
Module 1: Introduction to Excel MIS Reporting
Overview of Management Information Systems (MIS) in accounting and finance
Importance of Excel in creating MIS reports
Understanding the role of MIS in decisionmaking
Module 2: Excel Basics for MIS Reporting
Introduction to Excel interface and navigation
Basic spreadsheet operations (entering data, editing cells, formatting)
Using formulas and functions (SUM, AVERAGE, IF, VLOOKUP)
Module 3: Data Organization and Cleaning
Importing data into Excel from various sources (CSV, text files)
Sorting and filtering data
Data cleaning techniques (removing duplicates, texttocolumns)
Module 4: Data Analysis Techniques
Performing data analysis with PivotTables
Creating PivotCharts for visual representation
Using slicers and timelines for interactive analysis
Module 5: Advanced Formulas and Functions for MIS Reporting
Nested functions (IF, AND, OR)
Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Statistical functions (COUNTIF, SUMIF, AVERAGEIF)\
Module 6: Designing MIS Reports
Module 7: Financial Modeling and Analysis Structuring MIS reports for accounting and finance purposes
Creating dashboards with interactive elements (buttons, dropdowns)
Using conditional formatting for data visualization
Building financial models in Excel
Forecasting techniques using whatif analysis
Scenario Manager for sensitivity analysis
Module 8: Automation and Efficiency Tools
Recording macros to automate repetitive tasks
Using Excel addins for enhanced functionality
Creating custom functions with VBA (Visual Basic for Applications)
Module 9: Data Visualization Techniques
Advanced charting options (combo charts, sparklines)
Design principles for effective data visualization
Creating dynamic charts linked to data Module 10: Collaborative Reporting and Sharing
Sharing workbooks and controlling access
Using OneDrive and SharePoint for collaborative
reporting
Protecting worksheets and workbooks with
passwords Module 12: Case Studies and Practical Exercises
Realworld scenarios in accounting and finance
using Excel
Practical exercises to build and analyze MIS
reports
Handson projects integrating Excel skills with
financial data
%20in%20Chandigarh%20-Mohali.png)
No comments:
Post a Comment