PFM Database Version 3.0

Author: PERL

The PERL-ARC Public Financial Management (PFM) Database consists of budget and actual financial data of the Federal Government of Nigeria, and the states that PERL works in – Jigawa, Kaduna, Kano and Yobe. The database enables easy retrieval of government financial data for various types of PFM analyses and reporting on different indicators such as sector expenditure and revenue performance across several years (from 2004 for states, and from 2012 for the Federal Government). The data is based on the published budget documents and financial reports (Auditors General, and Accountants General reports) of these governments with necessary adjustments to remove distortions to legitimate revenues and expenditures, clear identified errors in the data, and presented in a consistent manner to enable comparison across governments and years. The database does not recognize opening cash balances as revenues earned but, as part of cash available in a particular financial year. Likewise, it does not recognize loan (principal) repayment as expenditure for the financial year it is paid, since such loan repayment does not contribute to the provision of goods and services in the years it is repaid. The database is organized on ‘Administrative Classification’ (for recurrent and capital expenditures only), Economic Classification (for revenues and recurrent expenditures only), and Functional Classification (for recurrent and capital expenditures only). The PERL-ARC PFM database has two versions that serve two different purposes. These are the MS Access database, which is a user-friendly management information system. It can perform some pre-programmed analyses and serve as a quick source for management decisions. It is easy to understand and access because it is like a 'form'. The second version is the MS Excel spreadsheet, which is meant for users who want to undertake more in-depth analysis or to manipulate the data differently. It requires a basic knowledge of how to work with Microsoft Excel pivot tables. This PERL PFM Database V3.0 release has datasets updated to 2022 originally approved budgets for the Federal, three of our states - Jigawa, Kaduna and Kano plus Yobe. The Federal Government’s actual data are up to 2019, while the states’ actual data are up to 2020. A unique and improved feature of this version is the functionality to provide and present capital expenditure data and analysis on MDAs that have a poverty reduction focus (tagged poverty spend). This functionality can be activated by checking the box at the right-hand corner of the Access Database or selecting the poverty spend in the Pivot Table Field.