SPARC public financial management database
The latest version of the PFM Database is dated December 2015 and contains budget data from 2004 to 2015 and actual data from 2004 to 2014 for the ten states where SPARC works (Kano and Katsina have up to 2013 actual data).
About this tool
A database is used for organising data systematically to allow for the quick processing and retrieval of information. The public financial management (PFM) database stores financial data for each SPARC state and enables easy retrieval for PFM analysis. The PFM database helps in the analysis and reporting of different PFM indicators, including sector expenditure and revenue performance, among others, across several years.
The PFM database has two versions which serve two different purposes:
- The Access database. The Access database is a management information system which is user-friendly. It can do some pre-programmed analyses and serves as a quick source for management decisions. It is easy to understand and access because it is like a 'form'
- The Excel spreadsheet. The Excel spreadsheet is meant for users who want to undertake more in-depth analysis or manipulate the data differently. It requires a basic knowledge of how to work with Microsoft Excel pivot tables.