ABOUT THE COURSE:

Launch your career in accountancy by learning and applying modern Accounting software. Gain the professional skills you need to succeed by learning bookkeeping, full accounting cycle, accounting terminologies, transactions recording process flow, use of double-entry accounting system till the publishing of Final Accounts report in a fully integrated computerized accounting software. The software covered in this training are Quickbook, Peechtree and MS Excel.

WHAT YOU WILL LEARN

    Create chart of accounts, record all business transactions relating to revenue, expenses, assets and Equity, liabilities in Quickbooks, Peach Tree and Tally.

    Posting voucher entries through bank receipts, bank payment, cash receipt and payment, journal voucher and other business transactions.

    Maintain the ledgers of share holders, vendors, employees and customers, inventory management system, enter sales transactions and maintain sales control system.

    Record purchase transactions, maintain purchase control system, payroll transactions and control system, and generate reports on inventory, sales, customer, purchase and vendors

    Record purchase transactions, maintain purchase control system, payroll transactions and control system, and generate reports on inventory, sales, customer, purchase and vendors.

    Perform bank reconciliation in accounting software.

    Controlling of trial balance.

    Learn how to use accounting software to streamline their workflow and save time.

    Ability to fetch Final Financial statements reports from accounting software and present to management for review.

COURSE OUTLINE:

    1.1 Accounting Defined

    1.2 Importance of Accounting.

    1.2 Use of accounting information.

    1.3 Types of accounting information.

    1.4 Generally accepted accounting principles.

    1.5 Conventions and Principles.

    1.6 Accounting cycle and its step

    2.1 Recording transaction.

    2.2 Preparing General Journal.

    2.3 Making Ledger

    2.4 Preparing Trial Balance.

    2.5 Making adjusting entries.

    2.6 Adjusted Trial Balance

    3.1 Balance sheet.

    3.2 Income Statements

    3.3 Statement of Cash flows

    3.4 Preparing Final Accounts

    4.1 Computerized Accounting Flow

    4.2 Data and Information

    4.3 Database and Types

    4.4 Database Relationships

    4.5 Importance and Characteristics of Database

    5.1 Introduction to MS EXCEL

    5.2 Main Parts of MS-Excel the Title Bar, The Menu Bar, Standard toolbar, Formatting Toolbar, Formula bar, the document Windows, Other types of Excel Documents.

    5.3 Introduction to basic functions Sum, Count, Max, Min, Count A, ,Average and its applications.

    5.4 Introduction to Relational Operators, (>,<,=,<>,>=<=)

    6.1 Introduction to Logical Operators (OR, AND, NOT),

    6.2 Concept of Simple Conditions and Critical Conditions

    6.3 Functions, IF, Sumif, Sumifs, Countif, Countifs

    6.4 Practical Preparation of Employee Salary Sheet

    7.1 QuickBooks Overview & Company Creation

    7.1 Understanding List

    7.1 list Menu

    7.1 Company Menu

    7.1 Reports Menu

    8.1 Charts of Accounts

    8.2 What is an Account?

    8.3 Types of Accounts

    8.4 Customers and Vendor Modules

    8.5 Customer centers

    8.6 Cash/credit/partial Invoice

    8.7 Receive Payments

    8.8 Sale return

    8.9 Vendors centers

    8.10 Create purchase orders

    8.11 Purchase Entry

    8.12 Pay bills

    8.13 Inventory Management

    8.14 Payroll & banking Module

    8.15 Payroll Employees

    8.16 Banking

    8.17 Write cheques

    8.18 Use registers

    8.19 Make Deposits

    9.1 Report centre

    9.2 Creation and Export of Different Reports

    9.3 Trial Balance

    9.4 General Ledger

    9.5 General Journal

    9.6 Balance Sheet

    9.7 Cash Flow

    9.8 Income Statement

    10.1 Peachtree Overview & Company Creation

    10.2 Understanding List

    10.3 list Menu

    10.4 Company Menu

    10.5 Reports Menu

    11.1 Charts of Accounts

    11.2 What is an Account?

    11.3 Types of Accounts

    11.4 Customers and Vendor Modules

    11.5 Customer centers

    11.6 Cash/credit/partial Invoice

    11.7 Receive Payments

    11.8 Sale return

    11.9 Vendors centers

    11.10 Create purchase orders

    11.11 Purchase Entry

    11.12 Pay bills

    11.13 Inventory Management

    11.14 Payroll & banking Module

    11.15 Payroll Employees

    11.16 Setup Payroll Items

    11.17 Banking

    11.18 Write cheques

    11.19 Use registers

    11.20 Make Deposits

    12.1 Report centre

    12.2 Creation and Export of Different Reports

    12.3 Trial Balance

    12.4 General Ledger

    12.5 General Journal

    12.6 Balance Sheet

    12.7 Cash Flow

    12.8 Income Statement

    13.1 Tally Overview & Company Creation

    13.2 Understanding List

    13.3 List Menu

    13.4 Company Menu

    13.5 Reports Menu

    13.6 Company Creation

    13.7 Charts of Accounts

    13.8 What is an Account?

    13.9 Types of Accounts

    13.10 Accounts Creation

    14.1 Customers and Vendor Modules

    14.2 Customer options

    14.3 Receive Payments

    14.4 Sale return

    14.5 Reports Menu

    14.6 Create purchase orders

    14.7 Purchase Entry

    14.8 Pay bills

    14.9 Inventory Management

    14.10 Banking

    15.1 ntroduction to Cost Centres

    15.2 Cost Centre Creation and management

    15.3 Report center

    15.4 Trial Balance

    15.5 General Ledger

    15.6 General Journal

    15.7 Balance Sheet

    15.8 Cash Flow

    15.9 Income Statement

    15.10 Creation and Export of Different Reports

TRAINER PROFILE

Muhammad Umair Alam

Computerized Accounting

Muhammad Umair Alam is an experienced Accounting and Finance Professional with 17+ Years of practical experience of working in Pakistan and in Middle East. He has been associated with many Industries like Manufacturing, Trading, Telecom, Servicing, E-commerce and Medical. During this time he has been engaged in trainings on many accounting software and involved in ERP designing. He possesses a very diversifi­ed industry experience and exposure which bring an experiential learning perspective that add value for the participants who attend his trainings. He is currently associated with Research Organization in the capacity of Assistant Manager Finance.

DURATION

  • 3 Months
  • 15 Modules
  • Training can be taken On-Campus in Karachi and via Zoom online sessions. Both training modes are available.

PRE-REQUISITE

Diploma/Degree holders in Commerce/Business Studies

VALUE ADDED SERVICES

  • Experience Professional Trainer with international practical working experience
  • State of the art IT Labs for practice of accounting software
  • Mock Assignments and case studies through real-life business environment simulation exercises to get professional working environment exposure
  • Guaranteed job interview to connect with job/internship opportunities in accountancy firms with free membership in YouExcel Alumni
  • Video recorded Lectures with LMS portal access (Course duration plus 2 months)
  • Lifetime access to exclusive YouExcel alumni via WhatsApp and Facebook groupsLife time WhatsApp community free access to get expert help and assistance on computerized accounting software

CAREER-PATHS

  • Accountant
  • Finance Executive
  • Management Accountant

REGISTRATION FORM