Microsoft Excel Basic Course

UBS Accounting Course


Course Objectives

This Computerised Accounting programme is specially designed to equip participants with computer-based Accounting skills for examination or career advancement purposes. Participants do not need to have prior knowledge of Bookkeeping to undertake this programme.

 

Course Contents

  1. New Company and GL Entry
  • Set up company profile
  • Create chart of accounts
  • Debtor and creditor file maintenance
  • Maintain batches
  • Differentiate between single and fast entry
  • Print chat of account, general ledger, trading & profit & loss account
  • Learn to backup
  • Edit chat of account
  • Search, edit, delete a transaction
  1. AR and AP entry
  • Maintain Company profile
    • Set the Accounting Year
  • Debtor/Creditor
    • Maintain Debtor/Creditor accounts
    • B/F Transactions
    • Sales Invoice/Purchase Invoice
    • Receive Payment/Pay Bills
    • Knock-off Bills
  1. Cash Book Entry and Bank Reconciliation
  • Cash book entry
    • Payment/Receipts
  • Bank Reconciliation Statement
  1. Stock value maintenance
  • Maintain closing stock value

5. Departmental Accounts

  1. Manufacturing Accounts
  1. Reporting
  • View Report
    • Debtor Statement/Aging Report/Payment Due
    • Profit & Loss
    • Balance Sheet
    • Trial Balance
  • Year End Processing

Who should attend

Accounts Assistant, Accounts Clerk, Accounts Executives, Accountant, Director, Financial Controller

Learning Outcome

Upon completion of this course, trainee will be able to:

  1. Maintain accounts code and ledger.
  2. Update daily transactions into Cash Book, Purchases, Sales, Sales Return, Purchases Return and General Journal into UBS Accounting System.
  3. Process accounts payable and receivable.
  4. Process cheques for payments and issuing receipts upon collection.
  5. Close accounts at month end and year end.
  6. Perform bank reconciliation.
  7. Prepare financial and management reports such as Income Statement, Trial Balance, Balance Sheet, Statement of Account, Debtors and Creditors Aging Report etc.

 

All Our Courses

  • Microsoft Excel Course


    Read more: Microsoft Excel Basic

  • Million Payroll Course


    Read more: Million Payroll

  • UBS Accounting Course


    Read more: UBS Accounting

  • UBS Payroll Course


     

    Read more: UBS Payroll

  • ATC Practical Taxation Course


    Read more: ATC Practical Taxation

  • UBS Inventory & Billing Course


    Read more: UBS Inventory & Biling

  • ACCA Foundation In Accountancy (FIA) Course


    Read more: ACCA Foundation In Accountancy (FIA)

  • ATC Full Sets of Accounts Course


    Read more: ATC Full Sets of Accounts

  • Amazing Andromeda Galaxy

    Certificate in Accounting (SKM 3)


    Read more: Sijil Kemahiran Malaysia SKM Accounting

  • SQL Accounting & Billing Course


    Read more: SQL Accounting & Billing

  • SQL Payroll Course


    Read more: SQL Payroll

  • Microsoft Word Course


    Read more: Microsoft Word

  • ACCA Diploma (RQF Level 2)


    Read more: ACCA Diploma in Financial & Management Accounting (RQF Level 2)

  • ACCA Diploma (RQF Level 3)


    Read more: ACCA Diploma in Financial & Management Accounting (RQF Level 3)

  • ACCA Diploma (RQF Level 4)


    Read more: ACCA Diploma in Accounting & Business (RQF Level 4)

  • Million Accounting Course

     


    Read more: Million Accounting

  • Million Inventory & Billing Course

     


    Read more: Million Inventory & Billing

  • UBS Certificate Course


    Read more: UBS Certificate

  • SQL Certificate Course


    Read more: SQL Certificate

  • Autocount Accounting & Billing Course


    Read more: Autocount Accounting & Billing

  • Microsoft Office Certificate


    Read more: Microsoft Office Certificate

  • SKM & DKM


    Read more: SKM & DKM

  • Million Certificate Courses

    Read more: Million Certificate

  • LHDN E-Invoicing Course 


    Read more: LHDN E-INVOICING COURSE