Background & Description

VSO Pakistan intends to organize this training for the Administration & Finance team members of its implementing partners to help enhance their skills to utilize the resources effectively and efficiently, enabling them to advance in achieving their missions.

Purpose & Objectives: To conduct 2 day training session on Advanced excel, Income & Sales tax law (related to charitable organization in Pakistan) & fraud risk management for Finance & Admin staff of VSO Partner Organizations to build their capacity.

To ensure:

  • That the participants have updated knowledge about the Income & sales tax laws of Pakistan specifically related to the charitable organizations ,
  • To ensure that participants have understanding of the usage of advance excel techniques for reporting purpose.
  • Developing skills/SOP’s related to fraud risk management within their organizations.


  1. Training duration will be two days for 10-12 trainees expected to be delivered in mid of February 2018.
  2. Training will be conducted in Islamabad (hotel to be decided).
  3. Provide hand outs & training material to participants
  4. Conduct pre and post assessment of the participants.
  5. Develop report within 10 days of delivering workshop.

Following areas will be focused:

  1. Income & Sales tax
  • Scope and administration
  • Registration for Income & Sales tax
  • E- enrolment
  • Filling of income tax/returns (individuals/organization)
  • Tax exemptions
  • Income & Sales tax withholding agents
  • Withholding tax rates for current year & implications
  • Difference between federal & provincial Tax rates
  • Tax credits
  • Any other tax related to I/NGOs
  1. Advance Excel
  • Overview of basic excel
  • Conditional expressions(IFs)
  • Conditional formatting
  • Using logical functions(AND,OR,NOT etc)
  • Using Lookup & reference functions
  • VLookup/Hlookup with tables and dynamics ranges-index
  • Data validations
  • Pivot tables
  • Sorting & filtering data/Slicer
  • Useful shortcuts
  • Using Advance filter options
  • Basic Macros
  • Others for practical uses
  • Mail mergers
  1. Managing fraud risk in NPO’s
  • Fraud risk basics
  • Financial Statements frauds
  • Contract & procurement fraud
  • Asset misappropriation
  • Fraud examination techniques
  • Fraud reporting
  • Fraud prevention & control


  • Registered audit or consulting firms
  • Having previous experience in designing & delivering trainings in domain of excel, taxation & fraud risk management in context of I/NGOs


How to Apply

Guidelines for Application

Interested firms are required to share the following:

  • Submit the profiles of firm and trainer for this assignment.
  • Share the methodology and techniques to be followed to deliver this assignment.
  • List of previous similar assignments conducted


Note: all above documents should be submitted as one file on

Last Date to apply is 1 February 2018.

About Organization

Indus Consortium is a collaborative platform of three rights-based development organizations i.e. Laar Humanitarian Development Program (LHDP), Doaba Foundation and HELP Foundation. These three organizations have been active since long time mainly responding to natural disasters and other development needs of their respective operational areas along River Indus. These organization adopted an innovative approach to create a joint platform for learning, synergy, evidence based advocacy to address macro level structure causes of development problem on the basis of their field experience and create solidarity among communities living around river Indus and are vulnerable to natural and manmade disasters.

The joint platform is a manifestation of a joint force of the people living around Sindhu (Indus River) basin in Pakistan. The Consortium represents the unity among various groups of different ethnic, linguistic and geographic features and their determination to struggle for the development of the people around Indus River.

The concept of a joint forum of various organizations for the holistic socio-economic development of these least served rural, riverine, disaster-prone and marginalized communities was visualized by Doaba Foundation district Muzaffargarh and shared with LHDP in District Badin. This pragmatic and innovate idea got acceptance and proved a step towards joint thinking in 2004. . In 2005 another likeminded organization - HELP Foundation - from povertystricken district of Rajanpur in Punjab, joined the two organizations i. With the association of these three based organizations the thinking firmed up to create a development consortium for improved research and coordination.. For this transitional purpose, another prominent research & development actor - Rural Development Policy Institute (RDPI) based in Islamabad – became part of the consortium in 2008.

The idea was materialized in the form of establishment of Indus Consortium in 2008. The consortium being a joint platform form aimed to carry out socio-economic, environmental, DRR-centric and rights-based development initiatives primarily in proximity of the banks of historical River Indus in the districts like Thatta, Qambar-Shahdadkot, Ghotki and Kashmor in Sindh province, and Layyah, Jhang, Bhakkar, Muzaffargarh, D.G.Khan, Rajanpur and Rahimyar Khan in Punjab province. The consortium devised the Terms of Reference (TORs) with the consultation of the three founding organizations at field level work, and with the RDPI for research, collaboration and coordination.

Source: Strategic Planning Document of Indus Consortium (2014-2018)