This page needs JavaScript activated to work.

Professional Training Certification in Computerized Financial Accounting Systems

Rating: 
Average: 3.4 (20 votes)

University of Kigali is one of the leading private higher institutions of learning in Rwanda. It is a fully accredited /chartered University by the Government of Rwanda. Started its operations in October, 2013.

 SCHOOL OF PROFESSIONAL & EXECUTIVE PROGRAMS (SPEP)

 SHORT COURSES

COURSE TITLE:

CERTIFICATE IN COMPUTERISED FINANCIAL ACCOUNTING SYSTEMS

COURSE CODE:

UOK/SPEP/PC/01/21

CONTENTS

Advanced Excel, Quick Books, Sage Pastel and Tally

START DATE:

28th June 2021

DURATION:

6 Weeks

OPTIONS

Both Full Time and Part time

VENUE:

University of Kigali, Kigali Campus

PRICING:

Rwf 250,000

  • Advanced Excel is free if undertaking the entire Certificate Course
  •  University of Kigali Students will get 60% discount on the listed price

TIME:

2PM – 6PM

Introduction

The Certificate in Computerised Financial Accounting Systems is a practical course which aims to provide an opportunity for interested candidates to develop accounting packages software skills that are becoming essential in every aspect of finance and accounting.

The one and a half months programme will benefit candidates who are interested in acquiring skills that will enable them adapt in a business setting in the field of accounting and also build their full potential as they build on accounting related experience

Advanced excel training will also be provided to all trainees at the introductory phase to enable all participants with diverse backgrounds to have a common ground to start off the program.

Scope and Timeframe of the Certificate Program:

The certificate in Computerized Financial Accounting Systems covers the following four major office application and accounting packages:

 

 

Dates (Year 2021)

Total Days

Total Hours

Price (Frw)

1

Advanced Excel

28th June – 2nd July

5

15

50,000

2

Quick Books

5th July – 9th July

5

20

85,000

3

Sage Pastel

12th July – 23rd July

10

40

85,000

4

Tally

26th July – 6th Aug

5

20

85,000

NOTE: There is an option of undertaking the sub units of the certificate (Advanced excel, Quick Books, Sage Pastel and Tally) separately and get certificates. Advanced Excel is free if undertaking the entire certification program.

The training fees should be deposited to the bank details of which are provided below.

Account Name: University of Kigali Ltd Promoters / Frw

Account Number: 4002211836245

Bank name: Equity Bank

1) ADVANCED EXCEL  

  • Training Objectives

This course is designed to continue learning aspects of MS Office Excel relevant to business, finance and accounting. The trainees will be taken through all the relevant functionalities of excel.

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

  • Master Microsoft excel from beginner to advanced;
  • Build a solid understanding of the basics of Microsoft excel
  • Complete a wide range of specialized and advanced excel functions
  • Target audience

Accountants in Private and public sectors and NGOs, bookkeepers, Accountants Graduates, Auditors, Tax advisors, and consultants, and all others who want to master the skills of advanced excel.

  • Quick Book Course Outline

Lesson

Topic

Contents of the Course

1

Data Analysis and Dash Board Reporting

  • Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016).
  • Understand and Identify the principles of data analysis
  • Effectively summarize and present data clearly
  • Use effective design principles when creating and presenting data

2

Excel formulas and Functions

  •  Excel Training-How to Use Formulas and Functions in Excel Spreadsheets-Learn on Excel 2010, Excel 2013, or Excel 2016
  • Identify formulas and functions and know the difference between the two.
  • Locate and use any of the functions in Excel using various methods, such as the Formula Tab.
  •  Use of the most important Excel functions in common spreadsheet computations.

3

Excel Charts

  • Gain Highly Advanced Excel Skills to Create Impressive Excel Graphs for your Management Reports
  • Significantly improve your Excel reports to create more powerful graphs that communicate your information in the best manner
  • Learn creative & simple techniques that allow you to create your own Excel charts from scratch
  • Create dynamic Excel charts. Why? To save time!

4

Excel Pivot Tables

  • Master Excel pivots & learn data analysis w/ advanced Excel cases
  • Learn how to use Pivot Tables and Pivot Charts to streamline and absolutely revolutionize your workflow in Excel
  • Master unique Pivot Table tips, tools and case studies
  • Workshop Date & Time & Venue

Date: 28th June – 2nd July

Hours: from 2:00 PM to 6:00 PM

Venue: University of Kigali

  • Eligibility & Pricing

Training Price: RWF 50,000

Having own Computer will be preferred however the trainees can also use computers in the Lab.

  • Cost components include
  1. Access to training software
  2. Training Manual
  3. Certificate of Attendance
  • Registration

Register by sending e-mail to:

spep@uok.ac.rw or call: +250781833731

 NOTE: Advanced Excel is free if you register for the entire professional course.

 2) QUICKBOOKS ACCOUNTING

Online and Desktop Version

  • Training Objectives

This course is designed to continue learning the computerized accounting cycle and some of the more important aspects of Payroll and Taxes.

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

  • Run all accounting transactions by use of QuickBooks;
  • Perform possible accounting adjustments
  • Report with QuickBooks;
  • Complete a wide range of specialized and advanced QuickBooks functions in order to meet the bookkeeping needs of a typical small business or organization.
  • Target audience

Accountants in Private and public sectors and NGOs, bookkeepers, Accountants Graduates, Auditors, Tax advisors, and consultants, and all others who want to master the skills of QuickBooks.

  • Quick Book Course Outline

Lesson

Topic

Contents of the Course

1

Setting Up a Company

  • Creating a QuickBooks Company 
  • Using the Chart of Accounts 
  • Entering Account Opening Balances 
  • Creating Company Lists
  • Working with the Customers & Jobs List 
  • Working with the Suppliers List
  • Managing Lists 
  • Entering Products into Inventory
  • Manually Adjusting Inventory

2

Work with Customers Module

  • Create a quotation for the clien
  • To edit a quotation
  •  To Process customer invoic
  • To edit or revise customer invoice
  •  To Print or e-mailing customer invoice
  • To check Customers ageing report
  • To record payment from customers
  • To run customer Billing Statements
  • To make a deposit of customer payment
  • To make receipt for a Customer

3

Work with Suppliers Module

  • Create a Purchase order for a supplier
  •  To edit a Purchase order
  • To record supplier invoice
  • To edit or revise Supplier invoice
  • To check Suppliers ageing report
  • To pay bill or invoice from a supplier
  • To run supplier transactions statement
  • To check stock activities report
  • To run physical stock worksheet

4

Work with VAT Module

  • To set VAT rate (18%) in QuickBooks
  • To run & review VAT on purchases
  • To run & review VAT on Sales
  • To reconcile Monthly Due VAT
  •  Determining What You Owe to Tax Authorit
  • To file monthly Due VAT in QuickBooks
  • To know VAT accounts position in Balance sheet

5

Working with Banking Module

  •   To make a deposit of sales
  • To make fund transfers
  • To write checks
  •  Performing bank reconciliation
  • Allocation of Reconciliation discrepancies
  • Run Reconciliation report

6

General Journals & End year Adjustments with QuickBooks

  •  In this Lesson, trainee will learn how to:
  • To pass general journal entries into QuickBooks
  • To adjust for depreciation into QuickBooks
  • To deal with Prepayments into QuickBooks
  • To deal with accruals payments into QuickBooks
  • To imports bulk transactions into QuickBooks

7

Creating Reports

  • Creating Quick Reports
  • Modifying Quick Reports
  • Memorizing Quick Report
  • Running Preset Reports
  •  Modifying Preset Repor
  •  Exporting Reports to Microsoft Exce
  •   Printing Reports
  • Workshop Date & Time & Venue

Date: 5th July – 9th July

Hours: from 2:00 PM to 6:00 PM

Venue: University of Kigali

  • Eligibility & Pricing

Training Price: RWF 85,000

Having own Computer will be preferred however the trainees can also use computers in the Lab.

  • Cost components include
  • Access to training software
  • Training Manual
  • Certificate of Attendance
  • Registration

Register by sending e-mail to:

spep@uok.ac.rw or call: +25078183373

3) SAGE PASTEL ACCOUNTING

  • Training Objectives

This course is designed to continue learning the computerized accounting cycle, learn the difference between quick books and sage pastel and some of the more important aspects of sage pastel.

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

  • Run all accounting transactions by use of Sage Pastel;
  • Perform possible accounting adjustments
  • Report with Sage Pastel;
  • Complete a wide range of specialized and advanced sage pastel functions in order to meet the bookkeeping needs of a typical organizations
  • Target audience

You should choose the Sage Pastel Partner Practitioner Course if:

  • You are an Accountant or in a Financial Management / Senior Position in your company (or are aspiring to move into such a position), OR
  • You want to master Sage Pastel Partner from an end-user perspective, OR
  • You are a business owner that wants to know how to use the software from end to end OR
  • You want to become a Pastel Trainer or Consultant (once you have completed the Practitioner course you can study further to becomea Trainer or Consultant)
  • Sage Pastel Course Outline

Lesson

Topic

Contents of the Course

1

Installation

  • Preparing for installatio
  • Working in a demo company
  •  Navigate in sage pastel partner

2

Supplier Processing

  •  Create a purchase order
  • Supplier invoices
  • Supplier Journals

3

Customer Processing

  • Create a quotation
  • Tax Invoices

4

Cash Book Processing

 

  • Setting
  • Processing in the cash Book
  •   Inter account transfers
  •  Bank Reconciliation
  •  Petty cash processing

5

Other Processing

  •  Monthly depreciation Journal
  • Accruals and Automatic reversals
  •  Tax Manager for VAT Returns
  • Workshop Date & Time & Venue

Date: 12th July – 23rd July

Hours: from 2:00 PM to 6:00 PM

Venue: University of Kigali

  • Eligibility & Pricing

Training Price: RWF 85,000

Basic Computer Literacy

  • Cost components include
  • Access to training software
  • Training Manual
  • Certificate of Attendance
  • Registration

Register by sending e-mail to:

spep@uok.ac.rw or call: +250781833731

4) TALLY ERP 9 ACCOUNTING

  • Training Objectives

This course is designed to continue learning the computerized accounting cycle and some of the more important aspects of ERP 9.

  • Target audience

Accountants in Private and public sectors and NGOs, bookkeepers, Accountants Graduates, Auditors, Tax advisors, and consultants, and all others who want to master the skills of ERP.

  • Tally ERP 9 Course Outline

Lesson

Topic

Contents of the Course

1

Fundamentals of Tally ERP 9

Introduction of Tally ERP

Versions of Tally ERP

Company Features

Configurations

Getting Functions with Tally

Creation/Setting up a company in Tally ERP 9

2

Accounting Masters in Tally

  •  Chart of Group
  • Groups
  • Multiple Groups
  •   Ledgers
  •  Multiple Ledgers

3

Inventory Masters in Tally

  •  Stock Groups
  • Multiple Stock Groups
  • Stock Categories
  • Multiple Stock Categories
  • Units of Measure
  • Go downs
  • Stock Items

4

Vouchers Entries in Tally

  • Introduction
  • Types of Vouchers
  • Charts of Voucher
  • Accounting Vouchers
  • Inventory Vouchers
  •  Invoicing

5

Advanced Accounting in Tally ERP

  • Bill wise details
  • Cost centers and cost categor
  • Multiple currencies
  • Interest calculation
  • Budget and Control
  • Scenario management
  • Bank Reconciliation

6

Advance Inventory in Tally

  • Order processing
  • Reorder level
  • Batch wise details
  • Bills of Materials
  • Different actual and billed Quantities
  •  Price List
  • Zero Valued Entries
  •  Additional Cost Details
  •  POS

7

Taxes in Tally ERP 9

  •   VAT
  •  VAT Reports
  • CST
  • TDS
  • TDS Reports
  • Excise
  • Excise Reports
  • Workshop Date & Time & Venue

Date: 26th July – 6th Aug

Hours: from 2:00 PM to 6:00 PM

Venue: University of Kigali

  • Eligibility & Pricing

Training Price: RWF 85,000

Having own Computer will be preferred however the trainees can also use computers in the Lab.

  • Cost components include
  1. Access to training software
  2. Training Manual
  3. Certificate of Attendance
  • Registration

Register by sending e-mail to:

spep@uok.ac.rw or call: +250781833731