PRACTICAL Training ON EXCEL,QUICKBOOKS,SAGE 100   TAXATION AND DATA CLEANING&REPORT WRITING

Venue: CENTRE SAINT PAUL Near saint famille(kigali)

INTRODUCTION

SHAPPEN COMPANY Ltd is dedicated to provide different services including provision of capacity building in Accounting,finance,Taxation and Management in form of training and consultancy services. The services reserved to business operators, private sector and state owned agencies,Civil Society organizations and individual practitioners.Our clients are assisted to improve their knowledge and practical skills  to enable them to achieve their objectives for a sustainable result.

Program Description: our intention and  interventions rely on country perspectives as Rwanda is a growing country with aspirations of becoming a “knowledge-based economy” that provides services countrywide, regionally and internationally. To get there, the country needs to ensure its workforce can meet the needed capacity.

 Overview of the financial and management capacity building Program

The program aimed to strengthen the capacity of users on selected theme to cover up the gaps meet on daily basis in order to enhance their capacity for better performance.The program will shape significantly participants by reducing their pain and low productivity due to limited skills hold;  attending this program effectively led to proper use of selected programs, consequently improve the quality and quantity of work carried out.

The participants will be trained on Excel for finance, Taxation,Data cleaning&report writing, QuickBooks and SAGE100 softwares which simplifies financial tracking, budgeting, reporting, and compliance. The training will be 85% practical where participants will gain practical skills and be able to set up charts of accounts for QuickBooks and Sage100, perfoming transactions,recordings and produce reports. At the end of the training the participants will be able to make impact and drive their business and institutions productively.

Technical Approach and Targeted participants

The program were tailored with the purpose of  contributing to the enhancement of end-user of selected module to bridge the gaps in they daily use and adhere to the update and changes occurred.The course will be delivered by experienced trainers with extensive knowledge.program targeted all interested finance,accounting and management practitioners people Men,Women and Youth including people with disabilities 

Expected Impact: If skills of employees increased, the time spent to undertake their daily tasks will be reduced, poor performance eliminated, consequently the quality of produced work will be increased.

Program Objectives: The objective of the program is to strengthen capacity,skills and  knowledge clients have while use and manipulate the  selected packages;Specifically by: supporting participants to enhance their skills through proper use of packages and fill out the gap of participants in order to unlock their future power with required skills and ability to deliver as required.

Course Content

1. Excel for Finance

 Learning Outcomes

• Use formulas and functions for budgeting, reconciliation, reporting
• Create financial dashboards and tables
• Clean, organize, and validate data
• Perform trend analysis and forecasting

Training Topics

• Different formulas: SUMIFS, VLOOKUP, INDEX, IFCONDITIONS
• Data validation and drop-downs
• Charts and data visualization
• Working with large data (sorting, filtering, subtotals)

2. Accounting Software Packages (QuickBooks, Sage 100)

v  Learning Outcomes

• Ability to navigate the accounting system
• Post journal entries,  payments, and reconciliations
• Generate standard financial reports (ledger,P&L, balance sheet, cash flow)

v Training Topics

• Chart of Accounts setup
• Posting: Sales, Purchases, Expenses, Bank transactions
• Month-end closing procedures
• Report customization and exporting
• Backups and internal controls

3. Taxation & Related Accounting (Rwandan Context)

v  Learning Outcomes

• Understand types of taxes (VAT, PAYE, PIT, CIT)
• Calculate tax obligations based on transactions
• Fill out RRA e-filing forms ( EBMand  declaration cycles)
• Maintain proper supporting documents

v Training Topics

• Overview of Rwandan tax laws
• VAT input/output tracking
• PAYE and social contributions
• Annual profit tax and quarterly prepayments
• Penalties, audit readiness, and tax planning

4. Data Cleaning & Report Writing

v  Learning Outcomes

• Clean and structure financial
• Use Excel for data cleaning
• Write a clear, actionable financial  report

 Training Topics

• Data  cleaning and errors detection
• Report writing structure (Executive summary, development, findings&recommendations,tables, visualizations)

Certification: After completion the Participants will receive a certificate .

Training  Shedule details

For more infos contact us:Email:shappenhub@gmail.com

Phone: +250783099102 / 0795357619

Register now via this link   https://shorturl.bz/uKb 

Deadline: 08th August 2025

Bank Payment Details for payment

• Bank Name:Equity Bank
• Account Number:4200088500
• Account Name:Shappen Company ltd