Tally -G.S.T & SAP Fico -Finance & Controlling & SAP MM Material Management" & "Quickbooks" Certification Training Chandigarh & Mohali

 Learn TallyPrime & TallyErp-GST Chandigarh Mohali | 

Courses- QuickBooks | Xero | Busy | Financial Modeling | Payroll | Excel Courses Training

Location  - Sctor 34-A Chandigarh &  Sector 115 , Mohali



 

Chapter 1: Fundamentals of Accounting
 Introduction
o Meaning of Accounting
 Terminologies used in Accounting
 Concepts of Accounting
 Double Entry System of Accounting
o Uses of Debit and Credit
o Rules of Debit and Credit
 Golden Rules of Accounting
 Recording of Business Transactions
o Journalising Transactions
 Trial Balance
 Financial Statements .
o Trading Account
o Profit & Loss Account
o Balance Sheet
 Subsidiary Books & Control Accounts
o Cash Book
o Petty Cash Book
o Purchase (Journal) Book
o Purchases Return (Journal) Book
o Sales (Journal) Book
o Sales Return (Journal) Book
 o Journal Proper
o Control Accounts
 Depreciation
o Methods for Depreciation
o Preparation of Depreciation schedule
 Computerised Accounting
o Advantages of Computerised Accounting
o Accounting Structure for Computerised Accounting

 

Chapter 2: Introduction to TallyPrime
o Introduction
o Features of TallyPrime
o Downloading and Installation of TallyPrime
o Types of Licenses in TallyPrime
o Activate New License
o Reactivate License in TallyPrime
o Use License from Network in a Multiuser Environment
o Working TallyPrime in Educational Mode
o Company Creation and Setting up Company Features in
   TallyPrime
o Getting Started with TallyPrime
o Navigating from Anywhere to Anywhere in TallyPrime
o F12 Configuration in TallyPrime
o Alter Company Details
o Shut the Company

 

 
Chapter 3:Maintaining Chart of Accounts
 Introduction
 Chart of Accounts
 Creation of Masters in TallyPrime
o Accounting Masters
o Inventory Masters
 Alteration of Masters in TallyPrime
 Deletion of Masters in TallyPrime
 Multi-Masters Creation and Display of Chart of Accounts
o Multi Groups Creation
o Multi Ledgers Creation
o Multi Stock Groups Creation
o Multi Stock Items Creation

 

Chapter 4: Recording and Maintaining Accounting Transactions
 Recording Transactions in Tally
 Recording Accounting Vouchers in TallyPrime
o Receipt Voucher (F6
o Contra Voucher (F4)
o Payment Voucher (F5
o Purchase Voucher (F9
o Sales Voucher (F8
o Debit Note Voucher (Alt+F5
o Credit Note Voucher (Alt+F6)
o Journal Voucher (F7

 

Chapter 5: Banking
 Banking
 Cheque Printing
o Single Cheque Printing
o Multi Cheque Printing
 Deposit Slip
o Cheque Deposit
o Cash Deposit
 Payment Advice
 Bank
o Manual Bank
o Auto Bank

Chapter 6: Generating Financial Statements and MIS Reports
 Introduction
 Final Accounts Reports in Tally
o Trial Balance
o Profit and Loss Account
o Balance Sheet
o Cash Flow & Fund Flow Analysis Report
o Receipts and Payments
 MIS Reports in Tally
o Stock Summary Analysis
o DayBook
o Cash and Bank Book
o Purchase Register
o Sales Register
o Journal Register.

 

 
Chapter 7: Data Security
o Introduction
o Security Control
o Activation of Security Control
o Creation of Security Levels (User Roles)
o Creation of Users And Passwords for Company
 Accessing the company using Security Levels
o Change User
o Login to the company using the Security Level - Data Entry 1  and    check the user Roles
o Login to the company using the Security Level - Data Entry 2 and   check the user Roles
o Login to the company using the Security Level - Accountant and     check the user roles.

Chapter 8: Company Data Management
 Introduction
 Backup of Company Data
 Restoring of Company Data
 Company Data Repair
 Migration of Tally.ERP 9 Company Data to TallyPrime

 
Chapter 9: Goods and Services Tax (GST
 Introduction to GST
o Why GST? 317
o GST Tax Structure
o Determination of Tax
o GST Registration
o Managing HSN CODE/SAC
o GST Rate Structure
o Supply of Goods and Services
o Invoicing
o Input Tax Credit
o E-Way Bill
 GST in TallyPrime
o Creation of Company and Activating GST at Company Level
o Introducing Capital into the Business
o Creation of Masters in TallyPrime
 Recording GST compliant transactions
o Accounting Intrastate Supply of Goods
o Accounting Interstate Supply of Goods
 Input Tax Credit Set Off against Liability
 GST Tax Payment
o Timeline for payment of GST
o Modes of Payment
o Challan Reconciliation
 Generating GST Returns for Regular Dealer in Tally
o GSTR-1
o GSTR-3B
o GSTR-9 – GST Annual Computation

 



Inventory Management in TallyPrime

Chapter 10: Storage and Classification of Inventory
 Introduction
 Supply Chain
o Types of Suppliers
 Inventory Management
o Terms Used in Inventory Management
 Inventory Masters in TallyPrime
o Company Creation in TallyPrime
o Introduction of Capital into a Business
o Creation of Inventory Masters in TallyPrime
 Tracking of Movements of Goods in Batches/Lots
o Activation of Batches/Lots for Stock Items
o Batch Reports
 Price Levels and Price Lists
o Activating Price Lists and Defining of Price Levels
o Creation of Price List
o Price Level &Price List usage in Sales Voucher
o Revise Price List

 Chapter 11: Accounts Receivable and Payable Management
 Introduction
 Accounts Payable and Receivable
 Maintain Bill-wise Entry
 Activation of Bill-wise Entry
o Usage of Bill-wise entry in Purchase and Payment Voucher
o Usage of Bill-wise entry in Sales and Receipt Voucher
o Usage of Bill-wise entry in Payment and Receipt Voucher
o Usage of Bill-wise entry - On Account
 Specifying of Credit Limit for Parties
o Specifying Credit Limit for Individual Ledger
o Specifying Credit Limit for Multiple Ledger
o Sales Voucher Restriction Based on Credit Limit
 Splitting of Credit Sale Into Multiple Bills
 Payment Performance of Debtors
 Bills Payable and Receivable Reports in TallyPrime
o Bills Receivable
o Ageing Analysis of Outstanding
o Generating Reminder Letter in TallyPrime
o Generating Confirmation of Accounts in TallyPrime
o Bills Settlement
o Bills Payables

Chapter 12: Purchase and Sales Order Management
 Introduction
 Purchase Order Processing
o Recording of Purchase Order
o Recording of Receipt Note Voucher
o Recording Rejections Out Voucher
o Recording Purchase Voucher
o Recording Debit Note Voucher
o Recording Payment Voucher
 Sales Order Processing
o Recording of Sales Order In TallyPrime
o Recording Delivery Note Voucher 
o Recording Rejections In Voucher
o Recording of Sales Voucher
o Recording Receipt Voucher
 Order Outstandings
o Sales Order Outstanding
o Purchase Order Outstanding
o Pre-Closure of Orders
 Reorder Level
o Display Reorder Status
 Godown Transfer in TallyPrime


Chapter 13: Tracking Additional Costs of Purchase
 Introduction
 Configuration of Additional Cost of Purchases in TallyPrime
o Purchase Transaction with Additional Cost Details in Voucher
    Mode
o Purchase Transaction with Additional Cost Details in Item Invoice
   Mode
o Debit Note Voucher with Additional Cost

Chapter 14: Cost/Profit Centres Management
 Introduction
 Cost Centre and Cost Categories
o Activation of Cost Centre
o Allocation of Expenses and Incomes using Cost Centre
o Cost Centre Classes (Automatic Allocation)
o Allocation of Expenses to Multiple Cost Centres and Cost Categories
Cost Centre Reports
o Category Summary
o Cost Centre Break-up
o Ledger Break-up
o Group Break-up

Chapter 15: Budgets and Scenarios
 Introduction
 Creation of Budget
 Recording Transactions
 Display Budgets and Variances Reports for Group Budget
 Scenario Management
o Creation of Scenario
o Temporary Inclusion of Reversing Journal Voucher In the Reports.
Chapter 16:Generating & Printing Reports
 Introduction
 On the Fly Reporting
o Bird’s eye View/Drill Down Display
o Drill Down Display
o Date/Period Based Reporting & Comparing
 Inventory Reports
 Stock Summary
 Godown-wise Stock Availability
o Movement Analysis
o Stock Query
 Financial Reports
o Balance Sheet
o Profit & Loss A/c
 Books & Registers
 Printing of Invoice and Report


www.gberp.com Contact No -9988113578




  Classroom Training & Online 
WhatsApp at – 9988113578 |7888919083

Advanced Excel Course Content

1. Fundamentals of Computer

    • Introduction
    • Definition of a Computer System
    • Classification of Computers
        • According to Technology
        • According to Individuals
        • According to size and Capacity
    • Peripherals
        • Input Devices
        • Output Devices
    • Memory
        • Main Memory
        • Secondary Memory
    • Central Processing Unit
        • Control Unit
        • Arithmetic Logic Unit
    • Computer Software
        • System Software
        • Application Software

2. Miscellaneous Windows 7/10 Features

    • Introduction
    • Understanding Windows Explorer
    • Exploring Windows Explorer in Windows 7
        • Address Bar
        • Search Box
        • Toolbar
        • Navigation Pane
        • Content Pane
        • Details Pane
        • Preview pane
        • Menu bar
    • Creating Files and Folder in Windows Explorer
        • Creating Files and Folders
    • Renaming Files and Folders
        • Copying a File or Folder
        • Moving a file or Folder
        • Deleting a File or Folder
    • Using Basic Programs
        • WordPad
        • Paint
        • Calculator
        • Snipping Tool
        • Copying, Moving and Deleting Files and Folders

3. Launching Internet Explorer

    • Introduction
    • Launching Internet Explorer
    • Browsing the Web with Internet Explorer
        • Visiting a Website
        • Enabling the Pop-up Blocker Features
        • Restricting a Website
    • Setting the Home Page
    • Creating an E-mail Account
    • Finding Information Through a Search Engine
    • Downloading from the Internet

4. Introducing Microsoft Office 2010

    • Introduction
    • Installing Microsoft Office 2010
    • Introducing the Microsoft Office 2010 User Interface
        • File Tab
        • Title Bar
        • Status Bar
        • Quick Access Toolbar
        • Ribbon
        • Key Tips
        • Mini Toolbar
    • Using Office Online Help

5. Getting Started with Microsoft Word 2010

    • Introduction
    • Working with Ribbon
        • Exploring the Ribbon
    • Creating a New Blank Word Document
    • Saving as MS Word Document
    • Applying Basic Formatting
        • Setting Indent for a Paragraph
        • Adding a Paragraph Border
    • Setting Tabs
    • Using the Cut, Copy and Paste Commands
    • Using the Find, Replace, and Go To Commands
        • Using the Find Commands
    • Printing a Word Document
    • Closing A Word Document
    • Opening an Existing Word Document
    • Quitting the MS Word 2010 Application

6. Working with Graphics and Tables

    • Introduction
    • Working with Basic Graphical Objects
        • Inserting a Picture
        • Inserting a Clip Art
        • Inserting a Shape
          • Inserting a SmartArt
    • Modifying a Picture
        • Cropping a Picture
        • Removing the Background of a Picture
        • Changing the Color of a Picture
        • Applying Artistic Effects to a Picture
    • Editing Graphical Objects
        • Arranging Objects
        • Aligning Objects
    • Grouping Objects
    • Working with Tables
        • Inserting a Table
        • Inserting Columns and Rows
        • Deleting Columns and Rows
        • Merging Cells in a Table

7. Designing ad Reviewing a Word Document

    • Introduction
    • Inserting Header and Footer
    • Inserting Footnotes and Endnotes
    • Changing Page Setup Option
        • Setting Page margins
        • Changing Page Orientations
        • Inserting Page Breaks
    • Performing Spelling and Grammar Check
    • Inserting and Deleting Comments
    • Tracking Changes
    • Accepting and Rejecting Changes
    • Inserting the Table of Content
    • Inserting a Caption
    • Inserting a Citation
    • Inserting a Bibliography
    • Using the Bookmarks
    • Creating Hyperlink
    • Marking a Document as Final

8. Using Mail Merge

    • Introduction
    • Using Mail Merge
        • Setting the Environment for Mail Merge
        • Adding and Editing Recipients
    • Inserting Merge Fields
    • Previewing and Finishing Mail Merge

9. Getting Started With Microsoft Excel 2010

    • Introduction
    • Exploring New Features in MS Excel
    • Launching MS Excel 2010
    • Creating a New Blank MS Excel Workbook
    • Saving an Excel Workbook
    • Adding Data to Cells
    • Modifying Cells, Rows, Columns, and Worksheets
        • Setting the Environment for Mail Merge
        • Adding and Editing Recipients
        • Inserting Merge Fields
        • Previewing and Finishing Mail Merge
    • Inserting a Cell
    • Inserting a Row
    • Inserting a Column
    • Inserting a new Worksheet
    • Removing a Cell
    • Removing a Row
    • Removing a Row
    • Removing a Column
    • Removing an Entire Worksheet
    • Renaming a Worksheet
    • Adding Border to Cells
    • Applying Conditional Formatting
        • Applying a Conditional Formatting
        • Applying a Color Scale
        • Inserting Data Bars
        • Inserting Icon Sets
    • Closing an MS Excel Workbook
    • Quitting the MS Excel Application

10. Working with Tables and Charts

    • Introduction
    • Working with Tables
    • Creating a Table from a Blank Cell Range
    • Creating a Table from an Existing Data Range
    • Formatting a Table
    • Converting a Table into a Range of Data
    • Working with a Chart
        • Creating a Chart
        • Changing the Chart Style
        • Changing the Chart Layout

11. Getting Started with Microsoft PowerPoint 2010

    • Introduction
    • Creating a New Blank Presentation
    • Exploring the Tabs
        • The Home Tab
        • The Insert Tab
        • The Design Tab
        • The Transition Tab
        • The Animation Tab
        • The Slide Show Tab
        • The Review Tab
        • The View Tab
    • Saving a Presentation
    • Adding Slides
    • Adding Text to a Slide Using Boxes
    • Setting Up and Running a Slide Show
    • Broadcasting a Slide Show
    • Recording a Slide Show
    • Packaging a Presentation on a CD
    • Closing a Presentation and Quitting PowerPoint

12. Enhancing PowerPoint Presentations

    • Introduction
    • Changing the Layout of a Slide
    • Applying Background to a Slide
    • Applying Themes to a Presentation
    • Working with Basic Graphical Objects
        • Inserting a Picture
        • Inserting a Clip Art
        • Inserting a SmartArt Graphic
    • Working with Audio and Video Clips
        • Inserting A Sound Clip
        • Inserting Videos from a File
        • Inserting Videos from a Website
        • Formatting ad Editing Videos
        • Adding Actions to a Slide
        • Creating a Photo Album

13. Building Dynamic PowerPoint Presentations

    • Introduction
    • Adding and Removing Animation Painter Tool
    • Copying Animation Using the Animation Painter Tool
    • Working with Transitions
        • Inserting a Picture
        • Inserting a Clip Art
        • Inserting a SmartArt Graphic
    • Working with Audio and Video Clips
        • Inserting A Sound Clip
        • Inserting Videos from a File
        • Inserting Videos from a Website
        • Formatting ad Editing Videos
    • Adding Actions to a Slide
      • Creating a Photo Album
    • Exploring New 3D Transition
    • Adding Transition Effects to a Slide
    • Removing a Transition Effects from a Slide
    • Advance Office Automation

14 .Working with Formula and Functions

  • 1.Introduction 
    • Working With Formula
    • Creating a Formula
    • Explaining Cell Reference
    • Creating a Formula Absolute Cell References
    • Referencing Cells from Other Worksheets
    • Working with Functions
        • Explaining the Function Syntax
        • Exploring New Functions in MS Excel 2010
        • Copying a Function
    • Applying Built-in Functions
    • Mathematical and Statistical Functions
        • Using the SUM Function
        • Using the COUNT Function
        • Using the AVERAGE Function
    • Text Functions
        • Using the CONCATENATE Function
        • Using the LEN Function
        • Using the REPLACE Function
        • Using the FIND Function
        • Using the SUBSTITUTE Function
        • Using the SEARCH Function
    • Working with the Date and Time Functions
        • Using the NOW Function
        • Using the DAY Function
        • Using the WEEKDAY Function
        • Using the NETWORKDAYS Function
  • 2. Advance Functions in Excel
    • Logical Functions
        • Using the AND Function
        • Using the IF Function
        • Using the OR Function
    • Financial Functions
        • Using the PV Function
        • Using the FV Function
        • Using the NPER Function
        • Using the RATE Function
    • Working with Lookup & Reference Functions
        • Using the COLUMN Function
        • Using the ROW Function
        • Using the LOOKUP Function
        • Using the VLOOKUP Function
        • Using the HLOOKUP Function
    • Some Functions that Meet Specific Criteria
  • Working with Auditing Tools
        • Using the Trace Precedents Tool
        • Using the Trace Dependents Tool
        • Using the Remove Arrows Tool
        • Using the Show Formula Tool
        • Using the Evaluate Formula Tool
        • Checking Errors
        • Using the Watch Window Tool
  • 3. Understanding PivotTable, What-if Analysis, and Solver
    • Working with a PivotTable
    • Creating a PivotTable
    • Creating a PivotTable Chart Based on a PivotTable Report
    • Using the Slicer to Filter PivotTable Reports
    • Using the Slicer to Filter PivotTable Reports
    • Understanding What-if Analysis
    • Using the Data Table Tool
    • Using the Scenario Manager Tool
    • Using the Goal Seek Tool
    • Understanding Solver
    • Summary
  • 4. Validating and Protecting Data
    • Understanding Data Validation
    • Setting the Criteria for Data Validation
    • Understanding Describing the Commonly used Types of Data Validation Criteria
    • Understanding Data Protection
        • Protecting a Worksheet
        • Protecting a Workbook

  • 5. Importing Data, Linking and Consolidating a Worksheet
    • Importing Data
    • Importing Data from a Microsoft Word Document
    • Importing a Microsoft PowerPoint Presentation
    • Importing Data from Microsoft Access Database
    • Linking Worksheets and Workbooks
    • Consolidating a Worksheet
        • Consolidating Data by using the Paste Special Command
        • Consolidating Data by using formulas
        • Consolidating Data by using the Consolidate Command


www.gberp.com Contact No -9988113578




  Classroom Training & Online 
WhatsApp at – 9988113578 |7888919083

Financial Modeling & Valuation Analyst Training Chandigarh & Mohali

Duration: 3 Months
Mode: Online/Offline (Chandigarh and Mohali)


Whether you’re a B.Com, M.Com, MBA Finance student, or simply looking to sharpen your financial skills, Our 3-month comprehensive course is tailored to equip you with in-demand skills like financial analysis, 3-statement modeling, business valuation, and more. You’ll gain hands-on experience with real-world case studies, build professional-grade financial models, and become proficient in advanced tools like Excel, data visualization, and scenario analysis.

Module 1: Financial Analysis Fundamentals

Objective: Introduce students to core financial statements and essential analysis techniques.

  • Key Topics:
    1. Understanding the Balance Sheet, Income Statement, and Cash Flow Statement
    2. Financial Ratios (Profitability, Liquidity, Efficiency, Solvency)
    3. Trend and Common Size Analysis
    4. Interpreting Financial Statements
    5. Case Studies: Financial Health of Companies

Deliverables:

  • Real-world case study analysis
  • Financial ratio interpretation report

Module 2: Introduction to 3-Statement Modeling

Objective: Teach students to build an integrated financial model from scratch.

  • Key Topics:
    1. Linking the Income Statement, Balance Sheet, and Cash Flow Statement
    2. Forecasting Revenues and Expenses
    3. Building Financial Assumptions
    4. Circular References and Iteration in Excel
    5. Building and Auditing Models

Deliverables:

  • Fully functional 3-statement financial model

Module 3: Introduction to Business Valuation

Objective: Provide an understanding of valuation methodologies and their application.

  • Key Topics:
    1. Overview of Valuation Approaches (DCF, Comparable Analysis, Precedent Transactions)
    2. Valuing Startups vs. Mature Companies
    3. Equity Value vs. Enterprise Value
    4. Market Capitalization and Multiples
    5. Applying Valuation in M&A Transactions

Deliverables:

  • Valuation of a sample company using multiple methods

Module 4: Operational Modeling

Objective: Develop operational models to assess company performance.

  • Key Topics:
    1. Revenue and Cost Drivers
    2. Building Assumptions for Operational Models
    3. Operating Metrics (ARPU, LTV, CAC, etc.)
    4. Capacity Planning and Cost Control
    5. Sensitivity of Operational Assumptions

Deliverables:

  • A detailed operational model for a case company

Module 5: DCF Valuation Modeling

Objective: Deep dive into the Discounted Cash Flow (DCF) model for valuation.

  • Key Topics:
    1. Free Cash Flow (FCF) Calculation
    2. Terminal Value Estimation (Growth and Exit Multiple Method)
    3. Weighted Average Cost of Capital (WACC)
    4. DCF Sensitivity Analysis
    5. Common Pitfalls in DCF Models

Deliverables:

  • Complete DCF model of a public company

Module 6: Comparable Valuation Analysis

Objective: Teach students to perform relative valuation using comparable companies.

  • Key Topics:
    1. Identifying Comparable Companies
    2. Selecting and Normalizing Financial Metrics
    3. EV/EBITDA, P/E, and P/S Ratios
    4. Pros and Cons of Comparable Valuation
    5. Building a Comparable Analysis Template

Deliverables:

  • Comparable company analysis report

Module 7: 3-Statement Modeling (Advanced)

Objective: Build more complex and dynamic financial models with scenario analysis.

  • Key Topics:
    1. Advanced Forecasting Techniques (Revenue, COGS, CAPEX)
    2. Handling Different Capital Structures
    3. Scenario Planning and Sensitivity Analysis
    4. Circular Reference Management
    5. Stress Testing Financial Models

Deliverables:

  • Advanced 3-statement financial model with scenario analysis

Module 8: Budgeting and Forecasting

Objective: Equip students with skills to prepare budgets and forecasts.

  • Key Topics:
    1. Budgeting Techniques and Variance Analysis
    2. Rolling Forecasts and Strategic Planning
    3. Revenue and Expense Forecasting
    4. Integration of Budget and Financial Models
    5. Case Study: Corporate Budget Process

Deliverables:

  • Annual budget for a case company

Module 9: Monthly Cash Flow Modeling

Objective: Develop cash flow models to predict and manage liquidity.

  • Key Topics:
    1. Cash Flow Drivers (Working Capital, Debt, etc.)
    2. Monthly Forecasting for Cash Flow
    3. Short-Term vs. Long-Term Cash Flow Projections
    4. Managing Surplus and Deficits
    5. Cash Flow Stress Testing

Deliverables:

  • Monthly cash flow projection model

Module 10: Scenario & Sensitivity Analysis in Excel

Objective: Build robust models with flexible inputs to test different business scenarios.

  • Key Topics:
    1. Sensitivity to Key Assumptions (Growth, Margins, WACC)
    2. Building Scenario Managers in Excel
    3. Best Case, Worst Case, and Base Case Scenarios
    4. Monte Carlo Simulation (Basic)
    5. Excel Tools for Scenario Management

Deliverables:

  • Scenario analysis report based on a financial model

Module 11: Dashboards & Data Visualization

Objective: Create dashboards for financial data visualization.

  • Key Topics:
    1. Best Practices for Financial Dashboards
    2. Data Visualization Tools in Excel
    3. KPI Dashboards and Performance Tracking
    4. Dynamic Dashboards using Pivot Tables
    5. Case Study: Building an Executive Dashboard

Deliverables:

  • Interactive financial dashboard

Module 12: PowerPoint & Pitchbooks

Objective: Prepare professional presentations to communicate financial analysis res

  • Key Topics:
    1. Key Elements of Financial Pitchbooks
    2. Structuring Financial Presentations
    3. Designing Effective Charts and Graphs
    4. Tailoring Content for Different Audiences (Investors, Management)
    5. Storytelling with Data

Deliverables:

Financial pitchbook presentation

www.gberp.com Contact No -9988113578




  Classroom Training & Online 
WhatsApp at – 9988113578 |7888919083


SAP FICO  Training in Chandigarh/Mohali

 

o Introduction Of SAP

o Types Of SAP Projects

o ASAP Roadmap Methodology Or Project Phases

o Project Preparation

o Business Blueprint

o Realization

o Final Preparation

o Go-Live And Support

o Types Of Document Prepared By Function Consultant

 

ENGTERPRISE STRUCTURE & BASIC SETTINGS: (PRACTICAL SESSION)

o Define Company
o Define Company Code
o Define Business Area
o Assign Company Code To Company
o Maintain Controlling Area
o Assignment Of Company Code To Controlling Area
o Maintain Fiscal Year Variant
o Assign Fiscal Year Variant To Company Code
o Define Posting Period Variant
o Assign Posting Period Variant To Company Code
o Maintain Open And Close Posting Periods
o Define Field Status Variant
o Define Tolerance Groups For Employees
o Define Tolerance Groups For G/L
o Assign Field Status Variant To Company Code
o Document Types
o Posting Keys
o Define Number Ranges For Document Typeso

 

GENERAL LEDGER ACCOUNTING
o Define Chart Of Account
o Assign Company Code To Chart Of Account
o Define Accounts Groups
o Define Retain Earning Accounts
o Create G/L Master Data
o Change G/L Master Data
o Block/Unblock G/L Master
o Delete G/L Master
o Transaction Posting To G/L Account
o Normal Posting
o Reversal Posting (Individual)
o Hold Document
o Park Document
o View G/L Report
o Foreign Currency Settings
o Cash Journal
GB Training
An Institute of Advance Accounting, Payroll & HR
o Setup Cash Journal Account
o Document Type For Cash Journal
o Number Range For Cash Journal
o Setup Cash Journal Transaction

o Cash Journal Posting And Reports


ACCOUNT PAYABLE

o Define Vendor Account Groups

o Create Number Ranges For Vendor Account Groups

o Assign Number Ranges To Vendor Account Groups

o Define Tolerance Groups For Vendors

o Create Vendor Master Data

o Modify Vendor Master Data

o Block/Unblock Vendor Master Data

o Post Vendor Invoice

o Post Credit Memo

o Vendor Accounts Balances (Open Item Report)

o Vendor Outgoing Payment With Clearing

o Terms Of Payment

o Terms Of Payment (Normal)

o Terms Of Payment (With Discount)

o Terms Of Payment (Fixed)

o Terms Of Payment (Installment)

o Vendor Down Payment

o Create Down Payment Reconciliation Account

o Link Down Payment Recon. Act With Vendor Recon. Act

o Post Vendor Down Payment

o Post Vendor Invoice

o View Vendor Report

o Clear Down Payment

o Make Vendor Payment

o View Vendor Report

o Automatic Payment Program

o Step1: All Company Code

o Step 2: Paying Company Codes

o Step 3: 'Payment Methods In Country

o Step 4: Payment Methods In Company Code

o Step 5: House Bank

o Step 6: 'Bank Determination

o Step 7: Update Vendor Master

o House Bank And Bank Account Set Up

o Withholding Tax Configuration

o Check Withholding Countries

o Define Withholding Tax Keys

o Define Reasons For Exemption

o Define Withholding Tax Type For Invoice Posting

o Define Withholding Tax Codes

o Activate Extended Withholding Tax

o Creation Of G/L Account For TDS Posting

o Define Accounts For Withholding Tax To Be Paid Over

o Activation Of CIN In Vendor Master

o Maintain Company Code Settings

o Assign Withholding Tax To Vendor Master

o TDS Posting Scenario

o TDS Posting With Exemption Scenario

o Update Exemption Details To Vendor Master


ACCOUNT RECEIVABLE

o Define Customer Account Groups

o Create Number Ranges For Customer Account Groups

o Assign Number Ranges To Customer Account Groups

o Tolerance Groups For Customer

o Define Customer Accounts

o Post Customer Invoice

o Post Customer Credit Memo

o Customer Accounts Balances (Open Item Report)

o Customer Outgoing Payment With Clearing

o Display Posted Document

o Customer Down Payment

o Create Down Payment Reconciliation Account

o Link Down Pyt Recon. Act With Cust. Recon. Account

o Post Customer Down Payment

o Post Customer Invoice

o View Customer Report

o Clear Down Payment

o Make Customer Payment

o View Customer Report

o Dunning Configuration

o Define Dunning Procedure

o Run Dunning Program

o Bill of Exchange

o Post bill of exchange

o Present bill of exchange

o Discounting bill of exchange

o Tax On Sales/Purchase (GST)

o Define Condition Type

o Create G/L Accounts

o Create/Copy Transaction Key

o Assign G/L Accounts

o Create Tax Procedure

o Assign Tax Procedure To Country

o Creation Of Tax Codes

o Edit Sales Revenue G/L

o Post A Customer Invoice

ASSET ACCOUNTING:

o Copy Reference Chart Of Depreciation

o Assignment Of Chart Of Depreciation To Company Code

o Creation Of 0% Tax Codes For Sales And Purchased

o Assignment Of 0% Tax Code To Company Code

o Specify Account Determination

o Creation Of Screen Layout Rules

o Define Number Range Intervals

o Creation Of Asset Class

o Creation Of G/L Accounts

o Assignment/Integration Of G/L Account For Automatic Posting

o Specify Document Type For Depreciation Posting

o Specify Interval And Posting Rule

o Determination Of Depreciation Area In The Asset Class

o Specify Rounding Of Net Book Value

o Define Screen Layout For Asset Master Data

o Specify The Screen Layout For Asset Depreciation Area

o Define Depreciation Calculation Methods

o Maintain Depreciation Key

o Creation Of Asset Master Records

o Edit Asset Master Records

o Asset Purchase

GB Training

An Institute of Advance Accounting, Payroll & HR

o Asset Explorer

o Depreciation Run

o Acquisition Of Fixed Assets

o Sale Of Fixed Assets

o Sale Of Asset With Customer

o Sale Of Asset Without Customer

o Transfer Of Assets

o Intercompany Transfer

o Intracompany Transfer

o Asset Scraping

o Depreciation Run

Closing down procedures

Integration

o Integration with FI & MM

o Integration with FI & SD

o Integration with FI & HR

Reports

o Various reports of customers vendors and assets

OTHER IMPORTANT TOPICS

o Sensitive Fields For Dual Control

o One Time Vendor Concept (Prerecorded Session)

o Validation Rule

o Substitution Rule

o Legacy System Migration Workbench (LSMW)

o Financial Statement Version

New GL Accounts

o Configuring new GL

o Configuring multiple ledger

o Document splitting

o Configuring leading and non-leading ledger

 

CONTROLLING MODULE

COST ELEMENT ACCOUNTING:

o Creation Of Primary Cost Element

o Edit Primary Cost Element

o Mass Creation Of Primary Cost Element

o Generation Of Batch Input Session

o Run Batch Input Session

o Creation Of Secondary Cost Element

o Edit Secondary Cost Element

o Display Secondary Cost Element


COST CENTER ACCOUNTING:

o Activate Cost Center Accounting

o Cost Center Standard Hierarchy

o Creation Of Cost Center Categories

o Creation Of Cost Center

o Edit Cost Center

o Display Cost Center

o Deletion Cost Center

o Cost Center Report

PROFIT CENTER ACCOUNTING:

o Activate Profit Center

o Maintain Controlling Area Settings

o Define Dummy Profit Center

o Set Control Parameters For Actual Data

o Maintain Plan Versions

o Create Profit Center

o Edit Profit Center

o Display Profit Center

INTERNAL ORDER

o Define Settlement Profiles

o Define Order Type

o Define And Assign Number Range

o Create Internal Order

o Create Internal Order


o Display Internal Order o ***** Join Our Free Demo Class ******* o

o Whatsapp No – 7888919083

o 8528110190

o www.gberp.com



Offce Address
SCO 85-86, 4th Floor, Sector 34A,
Chandigarh, 160034.

Location: Chandigarh, India

Comments

Post a Comment