WIXLIB

Lower Local Government levelLLG processes only villages/Mtaa and wards are have been included in planning since the early2000s when O&OD was introduced as a means of capturing local level priorities and enhancingthe engagement of beneficiaries in participatory planning and budgeting processVillage/MtaaThe Village or Mtaa level is the lowest level of government included within the planning process,engaging with the population directly through focus groups to discuss local priorities. Identifiesopportunities and obstacles around the surrounding communities Derives priorities that addressesthe obstacles Submit the draft of priorities to Ward Development CommitteeWard Provide technical advice on village plans, discussing village/Mtaa priorities Approve thevillage/mtaa plans Submit approved plans of villages/Mtaa within the Ward jurisdiction to theCouncilFEATURES OF THE PLANREP WEBBASED SYSTEMPlanRep was developed as a system that acts as a planning, budgeting and reporting tool for LGAs.It was developed to assist LGAs in planning, budgeting, projecting revenue, and tracking fundsreceived, and in actual implementation and financial and non-financial reporting.PlanRep acts as the main information source for integration of community plans and the LGAstrategic plan for a specific financial year. Within PlanRep, councils are able define their MTEFsin relation to their SPs, which include objectives, targets, and activities. PlanRep is also used inpreparing the line items for councils’ development and other charges in the budget by identifyingfunding sources and amounts for each activity. It contains tools required for preparing theComprehensive Council Health Plan (CCHP).Despite these developments in reforming the government planning and budgeting framework, theprevious versions of PlanRep faced some challenges. Initially developed and distributed as astandalone tool, each user accessed the system locally on his or her workstation. As a result, usersoften have different versions of PlanRep, producing data in different formats and resulting ininconsistent database structures. Data inconsistency issues interfere with the uploading of budgetsinto the Strategic Budget Allocation System (SBAS), the MOFP’s budgeting system. Theinconsistencies also impact the data being uploaded into IFMS at PO-RALG. As a result, LGAs

had to manual upload their annual budgets into Epicor and the SBAS, a process that takes monthsand is riddled with human error.To address these issues, PO-RALG together with the USAID-funded Public Sector SystemsStrengthening Activity (PS3) project have worked to improve PlanRep in a way that will ensureefficiency, accountability, consistency, uniformity and quality of work. This joint team has adaptedPlanRep into an easy-to-use, centralized, web-based system for planning, budgeting and reporting,integrated with the current LGRCIS, HCMIS, DHIS2, IFMS –Epicor 9.05, MOFP-SBAS systems,and other sector systems.The key improvements made to the 2017 version of PlanRep are outlined in the sections belowIntroduction of Service OutputsThe improved web-based PlanRep system includes multiple key changes to the previous systemincluding the addition of service outputs. The concept of service outputs is relatively new inTanzania. It also has an impact on the chart of accounts, which have been updated so that whenplans and budgets are completed, they can be exported to Epicor for budget execution. Planningunits will now need to specify service outputs that will be delivered, and match these with the totalbudget that has been earmarked for this service output. Targets for each service output will bespecified immediately after outputs have been specified. In the redesigned PlanRep, serviceoutputs are defined as goods or services that a system or sector produces being education,agriculture, health and others. For this case, each planning and budgeting unit will clearly specifythe service outputs that it wants to deliver. Right after specifying the objectives, the planning unitswill need to specify service outputs that will be delivered, and match these with the total budgetthat has been earmarked for this service output.Enhanced Interoperability with other systemsPlanRep has the capacity to be integrated with key systems including: LGRCIS, HCMIS, DHIS2),IFMS-Epicor, and SBAS. The integration between these keys systems will enable auto exchangeof data to facilitate consistency and reduce human errors. System interoperability also providesreliable financial information during reporting on budget execution.The major expected result after integration of these systems is that LGAs and General Governmentwill receive financial data direct from execution point without human intervention and thereforeachieve accuracy and timely reporting to Funders, Sector Ministries and other stakeholdersExtension to the service provider levelAnother major new element is the extension of PlanRep to the service provider level. Both plansand budget now include individual service providers (facilities). Previous versions of PlanRepwere designed to prepare plans and budget from the higher local government (Council) while ward,

village/mtaa and service providers (facilities) were not fully captured by the system. The improvedweb-based PlanRep is designed to capture plans and budget from service provider level and totrack budget and expenditure allocations. For now, these LLG plans and budgets will be enteredat LGA level from paper submissions received from the Wards.New Chart of AccountsThe new PlanRep has impacted the chart of accounts structure. This structure is a systematicarrangement of financial variables which provides a coding system to enable analysis of the budgetand expenditure by different variables, e.g. geographical location, development objective, andexpenditure item. The COA defines the segment structure and characteristics for each segmentused within an authority. The COA was updated in May 2017 and the redesigned web-basedPlanRep uses the improved COA below to accommodate changes made in IFMIS/Epicor QSbAxzCadOEVzOF9mS2tzcDg/viewS/N Name1Vote/RegionfromLGAsProposal andDesecriptionagrredtoMOFPA code representing an MDA or region as a3:050budget unit. In the case of a region, this codedoes not considerindividual LGAs2Council4:3014Each council has its own code whichrepresents the council identity within theconsolidated budget e.g., 3014 Kondoa DC3Cost Center4 :500ASub vote with the sector department, e.g.,507B Primary Education Operation4Sub Budget Class3:202Sub-Budget Class - a point of separation offunds according to beneficiaries regardlessof its source and nature5Serviceprovider/Service8 :11118907delivery putFacility code which represents name of thefacility as per Facility registration fromPORALG, MOHSW and MOFPNational predefined objectives will bespecified here (A,B,C,D,E,F,G).Specify Service Output to be produced byserviceproviderandTotalProgramme/Project/Service Output Budgetattached here

S/N NameTargetActivity-type and Activty78910TotalProjectFund SourceFund TypeInput/GFS codeLGAsProposal andDesecriptionagrredtoMOFPThe targets that will be defined as a2:01combination of objective and Service output(e.g., A0101, B0101)Activity codes are generated for each targetin the MTEF in which inputs are identified.3:S01It is a combination objective, Service output,and taget A0101S01.4: 4101Represents the project number attached toevery project e.g. 4101 Road Construction3:004Indicates provider of funds or programwhich finances the budget of the council,e.g., block grants (2), LGDG (4), RWSSP(N).1:1Nature of expenditure: recurrent andnonrecurrent. E.g., 1 is for Recurrent; 2.Development – Local8:21111101GFS is a code that counts for governmenteconomic activity as a means of compilationto determine the net worth of the country.46Administration and technical supportPlanRep operates on a web-based platform through a virtual private network (VPN) withencryption to connect users to the central server. The PO-RALG in Dodoma has a central serverthat will host PlanRep. Together with PlanRep , PO-RALG central server also hosts IFMS,HCMIS, Lawson, LGRCIS and and Basic Education Management Information System BEMIS.Ideally, LGAs and RSs can benefit from a stable Local Area Network (LAN) to access the systemin all departments, however it is not required as users can also access it via a VPN when not on aPO-RALG LAN.Administration support, routine operations and maintenance will be provided by PO-RALG inDodoma where a help desk system will be established to help provide solutions and respond toqueries from users.

LGA LEVEL USER INSTRUCTIONSIntroductionThe Council has a mandate to prepare plans and budget as per national policies, strategies,priorities, guidelines and directives. In the planning and budgeting process, LGA departments andunits have a role of creating PlanRep users, assess management, assessing submissions from LLGs,entering the data from LLGs and the council itself from which the LGA plan and budget isproduced, scrutinize plans and budgets of LGAs, submission of plans and budgets of LGAs to theRegional level, monitor and report activity implementation and budget execution on a quarterlybasis. A summary of roles and responsibilities of PlanRep users at the LGA level is as shown inthe table below.Creating user profilesCreating user profiles.Purpose: User profiles or credentials must be created to allow access to PlanRep. Each individualofficer has different rights and responsibilities within the system, and will therefore be able toaccess different screens and reports based on those rights and responsibilities. The different userprofiles at LGA level include: District Human Resource Officer (DHRO), District Medical Officer(DMO), Heads of departments/units, and Budget officers in each cost centre. A list of cost centrescan be found in Annex.Responsible user: The Council Information & Communication Technology Officer (CICTO) isresponsible for creating the various user profiles within a given LGA.Steps required:Go to Settings User Management Users

1. Click on Create The following window ‘Create User’ will appear3 Add the relevant user particulars and assign the roles within the system, as per the fields set out.4 Click SaveGetting StartedIn order for you to use PlanRep, you will need a reliable internet connection, access to a computerinstalled with a web-browser (eg Internet Explorer, Mozilla Firefox, Google Chrome, Opera mini,

UC Browser etc) and your own user credentials (user name and password). You then need to followthe steps below: Logging on to PlanRepLaunch the browserType in the URL provided by your administrator or through the following application linkhttp://196.192.72.105.Once you have typed correctly the URL, the login page will appear as shown below; Note: PlanRepworks best on Google Chrome .Once you have successfully logged in into PlanRep, the Home Page will open automatically. Hereyou will be able to access various modules based on your permissions/user rights as given by theadministrator. The home page looks like this:

The home page will display the name of your Council and your department/unit/cost center basedon your permissions/user rights on the left and user name on the right top side of the browser.Menu icon (insert). At the top, to the left of the sector label, there is an icon [insert] which allowsyou to expand the page to cover the menu labels on the left hand sideEach of the menu headings on the left expand to give more detailed options.To log off the current session:1. Go to right top of home page2. Click your user name/drop down key3. Logout

Entering Plans and DocumentsPurpose: The council Strategic Plan is used as the source of medium term targets for a definedperiod, typically five years. The annual planning process sets out activities aimed at moving theLGA progressively towards the target each year. Targets are defined in relation to a limited numberof Objectives and Service outputs.Responsible officer: The DPLO is responsible for uploading the council Strategic Plan whichshould be in PDF format.Steps requiredEntering a Strategic Plan To enter a Strategic PlanFrom the Opening Menu, go to Planning - Reference DocumentsThen click create,A window for reference documents will appear as below. Enter the details in the required fields

Click on “Choose file” to access a directory list from which you will select the correct file for theStrategic Plan. Edit Document: The same procedure will be used to edit details of a reference document, forexample if the plan period has been extended. Other reasons for editing the document could includea change of address of the council or change the Name of council Director Delete document: If the document needs to be deleted, for example to be replaced with a newversion, select the [Delete] button on the page above.Entering information on LGA revenuesEstimates of expected LGA income from the various sources are required in order both todetermine the total expected resource envelope within which it should plan and budget, and tocapture the composition of the LGA resource envelope. Not all sources are captured at centralTreasury level. Some information required comes from ceilings handed down from centralgovernment, while others will be estimates based on recent experience and any contextual changes,depending on the specific source of revenue.Two different processes are used at LGA level. The first is to estimate the projections for thoseOwn source revenues accruing to or collected by the LGA, and included in the Local GovernmentRevenue Collection Information System (LGRCIS). These projections are approved by theFinance Committee, and are entered separately for each financial quarter (three months) to give anannual total. The second is an annual projection or ceiling for other funding sources.Revenue data may be amended during the planning process. However, after Budget approval bythe Parliament ceilings cannot be changed, with the exception of any reallocation during the midyear review of budget implementation as per the Budget act Ao.11 of 2015 and its regulations of2015

Own Source ProjectionPurpose: To enter projections of Own source revenues which are captured in the LGRCISResponsible user: DPLO in collaboration with the Council Treasurer Prerequisites: Identification of all council revenue sources, ie review of both existing sources and new ones Projection of the amount to be collected by each source each quarter Approval of sources andamount to be collected by Finance CommitteeSteps required: ToenterrevenueprojectionsFrom the opening menu, go to Budgeting Projection Enter the projected values for each revenuesource by quarter Click button Repeat the process (1-3) until all applicable Own source revenuecategories are complete.Revenue AllocationRevenue allocation is an intermediate step between entering the Own source projections andcalculation of the total ceiling by Budget class. This assigns the total Own source between threeSub-Budget Classes (SBC): Recurrent Own source; Recurrent Personal Emolument (PE) Ownsource; and Development Own source.Purpose: Different officials are responsible for preparation and oversight of the PE, Other Charges(OC), and development budgets within the LGA. Revenue allocation ensures that the councildecision on how much of the total Own source revenue goes to each part of the budget is clearlyentered in PlanRep, from where it can be further allocated to the various departments and units tofund planned activities.

Responsible user: The DPLO is responsible for entering the Revenue allocations after a decisionmade by the Council Management Team, based on LGA priorities and higher level guidelines anddirectives.Prerequisites: The Finance Committee of the Council Management Team (CMT) meetingapproves the Revenue allocations based on council priorities and high level guidelines anddirectives.Steps required:Go to Budgeting ProjectionClick on thebutton. Enter the approved amount for each of the three Budgetclasses.Check that the “Total Allocated Amount” is the same as the “Total AvailableAmount”. If it is, click [Save] and [Close].If the totals in Step 3 are not the same, there will be a positive or negativeamount in the “Total Remaining Amount” cell.Adjust the allocation between the Budget classes until this is zero, checkingagainst the approved allocation.Once the “Total Remaining Amount” is zero, click on [Save] and then [Close].Entering CeilingsPurpose: Entering ceilings is required in order to determine the total expected resource envelopefor the LGA which it should plan and budget, and to capture the composition of the LGA resourceenvelope from central Government sources which has different conditions depending on thespecific source of revenue.Responsible user: The DPLO is charged with entering ceilings at the start of the planning process,and will amend these during the planning process. After Budget approval by the Parliament,ceilings cannot be changed. Budget reallocation may be done if necessary during the mid-yearreview of the Budget implementation as per Budget Act No. 11 of 2015 and its regulations of 2015.Prerequisite:Steps required:Go to Budgeting Ceiling AmountsSelect a Funding source in the left-hand columnClick thebuttonEnter ceiling amountClickbutton and then [Close]Repeat for all applicable Funding sources in your LGA.

Ceilings AllocationsPurpose: Ceilings dissemination is the name given within PlanRep to the process of assigning agiven Funding source between different Departments/Units. It is required in order to determine thetotal expected resource envelope of a given Cost Centre for which it should plan and budgetResponsible user: The DPLO/HOD are charged with disseminating ceilings at the start of theplanning process Prerequisites: Decision by the Finance Committee on how the different sourcesof funding should be shared between Departments/Units.Steps required: Go to Budgeting Ceiling Amounts Go to the first applicable Funding source andclick the button Enter the agreed ceiling for each respective department/Unit, then press [Save].Check that the “Total Assigned Amount” is the same as the “Total Available Amount”. If it is,click[Save]and[Close].If the totals in Step 3 are not the same, there will be a positive or negative amount in the “TotalRemainingAmount”cell.Adjust the assignment between the Departments/Units until this is zero, checking against theapprovedallocation.Once the “Total Remaining Amount” is zero, click on [Save] and then [Close]. Click buttonEntering and editing TargetsPurpose: To capture the desired outputs from the planning and budgeting process as they relate tolocal, sectoral and national development objectives so that levels of activity and spending, andprogress towards targets, can be monitored and analysed. Responsible user: Heads of Department(HOD) are responsib

Management and Good Governance. PO-PSMGG is primarily responsible for the employment and deployment of public servants across the MDAs, RSs and the LGAs. It provides support to LGAs, RSs, MDAs and public entities on the preparation of the Personal Emolument (PE) estimates within the plan and budget, using validated human resource information.