Archive for the ‘performance’ Category

Government Resource Planning (GRP) Lessons Learned

Tuesday, May 7th, 2013

PDF & Storified version of presentation made by a FreeBalance team on May 7th. and links to relevant documents discussed.

2013 05-07 Lessons Learned on the Public Financial Management Front LInes from FreeBalance

On Total Cost of Ownership (TCP) for government financial management systems

http://www.freebalance.com/whitepapers/FreeBalance%2013-01%20Good%20Practice%20GRP%20TCO.pdf

Public Financial Management Good Practice GRP TCO by FreeBalanceGRP

On the use of GRP systems for Anti-Corruption

http://www.freebalance.com/whitepapers/FreeBalance%2013-03%20Good%20Practice%20Anti-Corruption.pdf

Public Financial Management Good Practice Anti-Corruption using Financial Systems by FreeBalanceGRP

On the advantages of GRP specialization

http://www.freebalance.com/whitepapers/FreeBalance%2013-07%20Good%20Practice%20GRP%20Specialization.pdf

Good Practices in Government Resource Planning Vendor Specialization by FreeBalanceGRP


Lessons Learned at the Innovation in Government Week

Friday, April 12th, 2013

Doug Hadden, VP Products

We attended a 2-day conference at the Inter-American Development Bank, Innovation in Government Week: Strengthening the Institutional Capacity of the State to Deliver. The conference was focused on lessons learned in Latin America but has wider applicability.

There are some very interesting trends in Latin American governance discussed:

  • Latin American governments are leveraging citizen engagement and transparency to show significant improvement in outcomes
  • Some of the most effective and innovative reforms are occurring at the sub-national level of government
  • High use of social media in Latin America has created more demanding citizens
  • Latin American governments seem to be on the forefront of changing political and public servant incentives


Lessons Learned at the IBM Government Analytics Conference

Friday, April 12th, 2013

Doug Hadden, VP Products

Our busy conference week began Tuesday at the IBM Government Analytics Conference in Washington. The conference was very US focused, but I think that there are some critical takeaways about big data and analytics for all government organizations:

  • Transparency and open data initiatives are helping to drive the need for analytics in government
  • Governments are leveraging analytics to address complex “horizontal” problems despite being organized in a “vertical” fashion
  • There remains cultural barriers to adoption including the view that analytics can’t help experts and that analytics exposes errors in government = political problems
  • Analytical results needs to change process and policy
  • Budget and performance management needs to be core to financial management systems, not something that is handled in some external data warehouse
  • Timeliness of data is often more important than quality of data


IBM Government Analytics Forum 2013 Takeaways

April 9 in Washington DC.

Storified by · Fri, Apr 12 2013 06:25:37

RT @IBMGovernment: Data driven government #omb – hearing how #bigdata and #analytics are needed now #ibmgov13 http://pic.twitter.com/D2oO7nI1TrRob Nijman
#ibmgov13 presentations on line for 30 days www-950.ibm.com/events/wwe/grp…FreeBalance
The conference was very much focused on the United States. 
Another #ibmgov13 takeaway: was talk of using US gov or commercial #bestpractices, only non-US gov mentioned (briefly)? UKFreeBalance
Theme: government problems horizontal but bureaucracies are vertical
Dustin Brown #OMB: governments have horizontal problems & vertical bureaucracy #ibmgov13FreeBalance
IMO: focused on agency goals does not create effective government performance management #ibmgov13FreeBalance
Theme: increase in data sources and the need for new tools:
David McClure @usgsa: collaboration platforms becoming rich mining field for knowledge capture #ibmgov13FreeBalance
Danny Werfel #OMB: urgency for data driven gov’t enabled thru new #bigdata technology #ibmgov13FreeBalance
Douglas Glenn: #accounting moving to #visualization #ibmgov13FreeBalance
Theme: some lessons learned were discussed and I was surprised at the extent to which ‘improper payments’ is a problem in the US Federal Government
.@iayers: if not using regression & randomized trials will result in bad #analytics #ibmgov13FreeBalance
Randomized trials to move from gut based to fact based decisions at #ibmgov13.IBM Government
.@iayers: predictive #analytics moved from dashboards to scoring #ibmgov13FreeBalance
.@iayers: crude algorithms often better predictors than experts #ibmgov13FreeBalance
David McClure @usgsa: often best to cut through data quickly & we know the critical issues, #analytics in bite sized chunks #ibmgov13FreeBalance
.@iayers: don’t beat up the data until it confesses everything #analytics #ibmgov13FreeBalance
Gobsmacked from #ibmgov13 that ‘improper payments’ is a pervasive US gov’t problemFreeBalance
RT @freebalance: David McClure @usgsa: recommends quick light #analytics wins #ibmgov13Dennis D. McDonald
Dustin Brown #OMB: don’t let perfect be enemy of the good when looking at #dataquality #ibmgov13 #analyticsFreeBalance
Dustin Brown #OMB: sees giving data back to stakeholders by showing where things are in progress important #ibmgov13FreeBalance
Scary: Learning more about the deficiencies of US federal gov financial management #ibmgov13FreeBalance
IMO: budget agility in gov & scenario planning is not for #anaytics apps, should be core & integrated with gov financial system #ibmgov13FreeBalance
Theme: analytics are great but shouldn’t delay decisions and ought to change policies.
.@iayers: the more important a question is, the more contentious it should be #analytics #ibmgov13FreeBalance
David McClure @usgsa: gov collects, analyzes data & writes reports but doesn’t change processes often #ibmgov13FreeBalance
David McClure @usgsa: perhaps #transparency can open up evidence-based gov decision-making #ibmgov13FreeBalance
David McClure @usgsa:the more data you collect,complexity can be introduced into decision-making processes #ibmgov13FreeBalance
Good #ibmgov13 question: is #bigdata #analytics becoming a decision-making crutch?FreeBalance
Theme: culture change needed to change risk-adverse views on transparency and the notion that opening up to non-experts is a good idea.
.@iayers: is an iron law of resistance, what I do is too idiosyncratic to be predictive in analytics #ibmgov13FreeBalance
Douglas Glenn: need to socialize rolling out #analytics, setting thresholds in gov #ibmgov13FreeBalance
Dan Chenok: need for incentives in gov & with contractors to change #analytics culture #ibmgov13FreeBalance
David McClure @usgsa: #analytics tools so good that can put up with some inefficiencies #ibmgov13FreeBalance
Dustin Brown #OMB: gov #accountability is about understanding why targets not being met #ibmgov13FreeBalance
Anne Altman: often need outsider viewpoint or front-line ‘non experts’ to get #bigdata insight #ibmgov13FreeBalance
Danny Werfel #OMB: vast universe of data & operational challenges in gov makes #analytics initiative #ROI difficult #ibmgov13FreeBalance
Douglas Glenn: in score carding, red is at risk, not wrong #ibmgov13FreeBalance
The theme of using analytics to overcome budget problems:
Anne Altman hopeful that #Sequestration crisis will improve gov prioritize toon #ibmgov13FreeBalance
@AnneAltman hopeful that #Sequestration crisis will improve gov prioritization through careful analysis of missions #ibmgov13IBM Government
Good #ibmgov13 question: #Sequestration about across the board cuts rather than prioriesFreeBalance
#ibmgov13 question on gov stovepipes & culture>wonder how 1yr budgets, congressional system, political appointees affect thisFreeBalance
Theme: Many cliches used, especially “best practices”:
#ibmgov13 cliche alert: "commercial #bestpractices"FreeBalance
Oh no, Ed Weber warns that we’ll be learning about #bestpractices (ie what the software does) #ibmgov13FreeBalance
Best practice in program management from @HUDNews – Make it matter, don’t let perfect get in the way of good #ibmgov13IBM Government
Performance improvement best practice @DeptVetAffairs – #analytics keeps focus on mission #ibmgov13IBM Government
RT @IBMGovernment: We don’t know what we don’t know – why #analytics is critical to understanding voice of constituents #ibmgov13Mohamed Karam
David McClure @usgsa: tech architecture great but doesn’t tell you how to consume data in government #ibmgov13FreeBalance
@AnneAltman finding the needle in the haystack by focusing on #analytics over architecture #ibmgov13IBM Government
That’s the second time today that ‘flat files’ brought up as #bigdata limiter #ibmgov13FreeBalance

Automating Good Governance, A Framework

Thursday, February 28th, 2013

Manuel Pietra, President & CEO

It was a privilege earlier today to engage in a graduate class at the Harvard Kennedy School of Government. One of our mandates at FreeBalance, as a for profit social enterprise, is to build and share good practices in Public Financial Management (PFM). This is a unique labor of love for us – to share our experiences to help countries grow. We do not restrict this knowledge to only our government customers.

The FreeBalance team has been building up our methodology on reform sequencing for the past few years based on our experiences in 20 countries and the engagement with the greater PFM community. This was our first opportunity to present an new and comprehensive framework for technology-enabled governance.


Can Good Governance be Automated?

Manuel Pietra, FreeBalance President and CEO, gave a class earlier today on the uses of Government Resource Planning (GRP) to improve governance. He discussed the advantages of technology to improve transparency, accountability and development outcomes.

Storified by · Thu, Feb 28 2013 13:10:31

FreeBalance President & CEO @PietraCEO facilitating seminar at #Harvard Kennedy School on automating good #governance http://pic.twitter.com/ia29FNRnfgFreeBalance
.@PietraCEPO asks #Harvard Kennedy School students whether #PFM #reform is continuous or something that needs to restart after successFreeBalance
.@PietraCEO: we need to question to status quo to achieve institutional reform in developing countriesFreeBalance
significant problems when trying to define good #governance in government & developing country context http://pic.twitter.com/pwG8AxrCk1FreeBalance
Good #governance concept tinged with #ideology & hard to measure- @PietraCEO: measurements critical to improving development outcomesFreeBalance
cash is the grease of #corruption, hard to follow the money when it moves to cash http://pic.twitter.com/PmSeo57MmgFreeBalance
Developing countries lose estimated $20-40B annually because of #corruption http://thepost-ng.com/developing-countries-lose-estimated-40bn-to-corruption-yearly-world-bank/ http://pic.twitter.com/IPwwimnsSHFreeBalance
Government efficiency? Single UK gov transaction ranges from 5p to £700 http://digital.cabinetoffice.gov.uk/2013/01/17/gov-transaction-costs-behind-data/ http://pic.twitter.com/lVDycMuS5lFreeBalance
US public sector #productivity is over 30% lower than Private Sector http://dupress.com/articles/gov-on-the-go/?id=us:el:pr:dup223:read:dup:021913 http://pic.twitter.com/t5zy7JhA8zFreeBalance
Manuel provided a short overview of FreeBalance. FreeBalance is a technology company that produces Government Resource Planning software (exclusively) and provides Public Financial Management (PFM) services. FreeBalance is based in Ottawa.
.@PietraCEO intros FreeBalance #socent focused on #GRP government resource planning in developing countries to Kennedy School attendeesFreeBalance
Ever wanted to know what a “free balance” is? Budget –commitments – obligations – actuals gov of #Canada terminology http://pic.twitter.com/vKcXKz9082FreeBalance
Manuel presented a framework for understanding where ICT solutions for governance operate.
.@PietraCEO introduces problem of linking #ICT like #GRP to automate good #governance & why this is important http://pic.twitter.com/Jv7jlT7cPEFreeBalance
FreeBalance has developed a framework to show where #GRP, #opendata, #transparency helps automate good #governanceFreeBalance
The framework is a bit complicated but can be explained.
Our #governance framework fits on a single page with very small letters :) http://pic.twitter.com/VHUvFN3NMBFreeBalance
1 of 6: technology used to automate financial functions in government (often called #GRP or #IFMIS) http://pic.twitter.com/2c33zHTfGJFreeBalance
2 of 6: #GRP provides set of tools: controls, front-office functions, decision-making & performanceFreeBalance
3 of 6: #GRP leveraged by institutions – mature institutions leverage #governance tools more effectivelyFreeBalance
4 of 6: positive or negative impacts of #governance effectiveness seen through credit ratings and other measurementsFreeBalance
5 of 6: real gov’t situation rolls up to measures like the World Governance Indicators #governanceFreeBalance
6 of 6:#governance get expressed in development outcomes like health and educationFreeBalance
Manuel navigated through parts of the FreeBalance governance framework by identifying opportunity sizes.
Developing countries receive $684B annually in Foreign Direct Investment #FDI http://unctad.org/en/PublicationsLibrary/wir2012_embargoed_en.pdf http://pic.twitter.com/cdRZaT7afYFreeBalance
Total annual worldwide #remittances to developing countries exceed $534B figures http://blogs.worldbank.org/peoplemove/remittances-to-developing-countries-to-reach-406-billion-in-2012 http://pic.twitter.com/UCxS08CyXfFreeBalance
Official Development Assistance, #ODA from #OECD Countries is 0.32% of combined #GNI or $129B http://www.oecd.org/newsroom/developmentaidincreasesbutwithworryingtrends.htm http://pic.twitter.com/DqDpV5xKEBFreeBalance
Official Development Assistance, #ODA from #OECD Countries is 0.32% of combined #GNI or $129B http://www.oecd.org/newsroom/developmentaidincreasesbutwithworryingtrends.htm http://pic.twitter.com/Ohxbo2PWtxFreeBalance
Given the size of #FDI & #remittances with #ODA budget %, @PietraCEO points out that #foreignaid is so highly politicized b/c wasteFreeBalance
About $37B of foreign aid annually is phantom aid #aideffectiveness http://www.huffingtonpost.com/caroline-anstey/technology-anti-corruption_b_1139022.html http://pic.twitter.com/mbgI53qgXBFreeBalance
.@PietraCEO: The problem of #aideffectiveness is but one of many spending effectiveness, value for money #v4m challenges in governmentFreeBalance
Gov #tax revenue ranges from 1.4% of GDP in #UAE to almost 1/2 in #Belgium, #Sweden & #Denmark http://en.wikipedia.org/wiki/List_of_countries_by_tax_revenue_as_percentage_of_GDP http://pic.twitter.com/ICt4MKbOfyFreeBalance
.@PietraCEO: tax evasion is a critical problem for government: revenue #transparency & #EITI support requiredFreeBalance
#Nigeria has lost $35B in #oil revenue in last 10 years = 10% annual budget thru #corruption http://www.guardian.co.uk/world/2012/nov/13/nigeria-oil-corruption-ridabu http://pic.twitter.com/99VWpHKZv3FreeBalance
Gov of #Greece owned €45B taxes, loses €15B annually b/c #taxevasion http://www.nytimes.com/2012/06/06/business/global/greece-warns-of-going-broke-as-taxes-dry-up.html?pagewanted=all http://www.transparency.org.uk/corruption/statistics-and-quotes/stolen-assets-a-tax-evasion http://pic.twitter.com/umOyqV1ynMFreeBalance
#taxevasion has cost USA $3T over last decade International http://www.transparency.org.uk/corruption/statistics-and-quotes/stolen-assets-a-tax-evasion http://pic.twitter.com/du5EVxUbmTFreeBalance
#taxevation through untaxed shadow economy = 17% of world economy, well over $2.5T http://images.businessweek.com/mz/10/32/1032_econtaxes16.pdf http://pic.twitter.com/aGRjB4P2l1FreeBalance
Illicit financial flows= at least $5.9T over the past 10 years http://www.economist.com/news/special-report/21571549-offshore-financial-centres-have-taken-battering-recently-they-have-shown-remarkable http://pic.twitter.com/Q7ovYK09KmFreeBalance
.@PietraCEO: countries with improving #PFM public financial management systems hurt by off-budget enabled #corruptionFreeBalance
Donors who go outside of country systems #GRP ensure that aid is fungible while not building government capacityFreeBalance
.@PietraCEO: capacity, pol. will, independent #audit & #civilsociety = force multipliers of tools for #accountability #governanceFreeBalance
#transparency, financial systems #audit trails changes behaviour, improves #governanceFreeBalance
.@PietraCEO: automated government financial systems significantly reduce opportunities for easy #corruption http://pic.twitter.com/6auutUdjFyFreeBalance
.@PietraCEO: great resistance to #GRP systems by those who recognize that systems can easily trap, uncover #corruptionFreeBalance
Controls in #GRP government resource planning to enable good #governance in a single slide http://pic.twitter.com/9GONIukKOGFreeBalance
.@PietraCEO: unfortunate when there is donor resistance to government fiscal #transparency initiativesFreeBalance
Screen shot from #timor #transparency portal at http://www.transparency.gov.tl http://pic.twitter.com/hqxINbXDFrFreeBalance
#corruption costs 20 to 25% of government #procurement in developing countries http://www.icgfm.org/forumsDocs/2008/MarPresentation_000.ppt http://pic.twitter.com/3nVibw52XiFreeBalance
.@PietraCEO summarizes impact of #transparency on waste, #accountability as precursor to improving gov’t performance http://pic.twitter.com/B9rnUWRvVkFreeBalance
Manuel used the framework to demonstrate the scenario of how GRP and controls could reduce the opportunity for corruption through the budget cycle of a hospital acquisition. (Public investment projects last multiple years and are complex so can be manipulated through graft and collusion.)
.@PietraCEO introduces automating good #governance ie use case of public investment #procurement such as a hospital http://pic.twitter.com/Fsf1z5KDiSFreeBalance
#anticorruption scenario 1 of 8 #GRP provides a an enterprise-grade infrastructureFreeBalance
#anticorruption scenario 2 of 8 #GRP ensures users, groups and roles have been defined & leverage IT securityFreeBalance
#anticorruption scenario 3 of 8 consider public investment program defined during budget planning that has been approved by parliamentFreeBalance
#anticorruption scenario 4 of 8 #procurement cycle begins in GRP, complex public investment such as a multiple year building of a hospitalFreeBalance
#anticorruption scenario 6 of 8: #GRP supports eprocurement with multiple bidders, review criteria and contract managementFreeBalance
#anticorruption scenario 5 of 8: integration in #GRP with the #procurement & expenditure system automatically generates an #RFPFreeBalance
#anticorruption scenario 7 of 8: #GRP systems ensure that payment is provided to the winning bidder based on the contract provisionsFreeBalance
#anticorruption scenario 8 of 8: further #GRP #governance controls: entire cycle is stored in #audit trailFreeBalance
Controls are built into GRP systems to reduce the opportunity for corruption and increases the potential of trapping graft in progress.
@PietraCEO describes control tools to manage the #procurement process in #GRP http://pic.twitter.com/oUz5Y2zchYFreeBalance
Proper #GRP planning and historical data can ensure that sample hospital budget is realistic without room for graft #anticorruptionFreeBalance
He also described the other factors necessary to leverage GRP tools to help achieve government objectives.
government #procurement payment in secure fashion – typically #EFT reduces the opportunity for graft that we see with cashFreeBalance
#GRP works thru standards, human capacity, #corruption enforcement, independence to improve gov’t #governance http://pic.twitter.com/E3usalCBN7FreeBalance
#GRP & gov’t #procurement rated in #PEFA assessments http://www.pefa.org, can improve #corruption perception http://pic.twitter.com/lDtlH7ELyZFreeBalance
Improved #transparency & #corruption perception leads to improved “control of corruption” #governance rating http://pic.twitter.com/iMRAgOSyr4FreeBalance
Improved “control of #corruption” leads to business trust, investment http://pic.twitter.com/IQbSszqD9dFreeBalance
All summed up by Afra Raymond at a recent Ted talk in Trinidad on the 3 myths of #corruption http://www.freebalance.com/blog/?p=3810 http://pic.twitter.com/msNAkKfDMtFreeBalance
GRP includes financial and non-financial systems such as  human resources (what we call “Civil Service Management’) to improve government productivity and effectiveness.
Government Employment exceeds 450 Million people http://www.ilo.org/public/english/bureau/stat/download/wp_pse_e.pdf http://pic.twitter.com/soA5YvAPp2FreeBalance
Government Employs 40% of workers in countries in transition http://www.ilo.org/public/english/bureau/stat/download/wp_pse_e.pdf http://pic.twitter.com/X81E44QyXHFreeBalance
45K ghost workers out of 153K screened found in #Nigeria MDAs #corruption http://pic.twitter.com/mR8GFk5hRmFreeBalance
There is some evidence that early implementations of GRP systems in post-conflict countries is important. Of the countries studied, only those countries that had implemented FreeBalance for at least 2 years had shown substantial improvement. This is indicative of the power of COTS GRP, whether from FreeBalance or other vendors, to enable governance reform.
Some evidence that good #GRP systems improve #PFM reform & #governance http://pic.twitter.com/DnaapKOm4HFreeBalance
We received a question over the weekend about why improvements to the Open Budget Index in Uganda had not resulted in noticeable improvements in service delivery. Of course, the impact of fiscal transparency is unlikely to have an immediate measurable effect. We answered the question by using the framework.
Do more open budgets=better spending? http://bit.ly/XMPTgi @tkb How open is your country’s budget? http://bit.ly/Qam8TE #openbudgetindexMatt Andrews
“@freebalance: @governwell @openbudgets @globalbtap hard to pluck out causality over time” sure but we should at least have a theory…Matt Andrews
“@freebalance: @governwell @OpenBudgets @GlobalBTAP theory will be presented later this week at Harvard” will be fantastic!Matt Andrews
Q via Twitter through @governwell on why @openbudgets improvement in #Uganda hasn’t resulted in improved service deliveryFreeBalance
A 1 of 5: isn’t a direct linkage without other factors from fiscal #transparency to service delivery http://pic.twitter.com/aFvIt2Mf1hFreeBalance
A 2 of 5: gov’t might not have the objective of improving service delivery in a particular sectorFreeBalance
A 3 of 5: #transparency doesn’t enable change without institutional #capacityFreeBalance
A 4 of 5: #decentralization is critical to improving service delivery at the local levelFreeBalance
A 5 of 5, multiple factors necessary to improve service delivery, fiscal #transparency but 1 factorFreeBalance
As a technology company, FreeBalance advocates technology. But, we recognize all of the factors necessary to improve governance. Most studies show that capacity building and political will are the most important determinants of success for GRP projects. As Manuel points out, capacity and political will can only go so far without appropriate tools.
.@PietraCEO concludes on automated good #governance with #GRP government resource planning http://pic.twitter.com/ft1oodfuDuFreeBalance

PFM Good Practice: Budget Formulation

Monday, February 4th, 2013

Doug Hadden, VP Products

We released a set of Public Financial Management (PFM) documents last week following on our mandate of sharing good practices for the community.

The second released document, embedded below, describes good practices in budget formulation. Governments are budget driven and use commitment accounting. Profit is the key concept in private sector accounting. Budget is the key concept in government.

That’s why budget formulation is so critical in government.

Budget is linked with policy and government objectives. It’s the formal and legal expression of government policy. That’s why many countries call a budget “the vote” or the “organic budget law”.

I’ve seen governments fall in Canada by losing the budget debate.

There are many budget formulation applications designed for the private sector. These software programs focus on fulfillment planning: logistics, manufacturing, assembly. Sure, financial planning is part of that. But the result of the planning is rarely multiple aggregate controls across different periods into the financial system. And, rarely handles supplemental budgets, virements, transfers, continuing resolutions and adjustments to tolerances.

And, let’s face it: budgets in the private sector are guidelines.

In government, the budget is the law.

Public Financial Management Good Practice Budget Formulation by FreeBalanceGRP

Good Practices in Budget Formulation

Tuesday, October 30th, 2012

Doug Hadden, VP Products

Why is budget formulation important in government?

How is the quality of government budget management evaluated?

The Public Expenditure and Financial Accountability (PEFA) Performance Measurement Framework highlights the four objectives for budget formulation:

  • Credibility of the budget – The budget is realistic and is implemented as intended
  • Comprehensiveness and transparency – The budget and the fiscal risk oversight are comprehensive and fiscal and budget information is accessible to the public.
  • Policy-based budgeting – The budget is prepared with due regard to government policy.
  • Predictability and control in budget execution – The budget is implemented in an orderly and predictable manner and there are arrangements for the exercise of control and stewardship in the use of public funds.

What is the budget formulation process?

Budget formulation differs among countries and levels of government. The budget formulation process typically starts economic analysis and prediction for government revenue. The process follows sets of budget rules during a budget calendar that includes a broad set of financial information.

How does budget planning fit into PFM processes?

Government budget planning begins during the fiscal year and leverages historical and current revenue and expenditure information.  Budget planning processes align, in theWorld Bank Treasury Reference Model, with economic forecasting, debt management and treasury systems. Liquidity and cash management is critical to understanding the expected revenue and expenditure variations in government.

What budget categories are used by governments?

Budget planning categories differ among countries. The processes used can be different depending on the categories. Typical categories include:

How do budget classifications enable budget formulation across categories?

Government budget formulation software can adapt to the planning workflow and categories used by governments through budget classifications. Government budget classifications, often called Charts of Accounts (COAs), represent the underlying meta data for Public Financial Management (PFM).

The COA is made up of a number of hierarchical data segments and is considered the lynchpin of a government’s accounting and reporting system and serves as a key tool to meet its business requirements.

The COA, although appears to be just concerned with classifying and recording financial transactions, is critical for effective budget management, including tracking and reporting on budget execution. The structure of the budget—in particular the budget classification—and the COA have a symbiotic relationship.

The COA structure can be used within the budget formulation software to map:

  • Users and roles to elements in the COA to ensure that planners are only able to see the correct sub-section of data
  • Workflow processes and that the budget formulation process follows government standards for different budget preparation categories
  • Revenue sources such as donors (aid), debt and government revenue can be shown in “fund” source segment or included in the accounting codes
  • Capital, recurrent and salary categories are typically modeled in the accounting (or object) codes
  • Program segment and can be combined with object codes can be used to model public investment projects
  • Organization or location segment can be used to control decentralized budgets across line ministries, government owned enterprises and sub-national governments

What are the major trends in government budget preparation?

How does budgeting differ among developing and developed country governments?

What is fiscal sustainability?

Governments need to develop credible budgets to ensure that long-term spending is sustainable.  Credible budget planning takes into account the four dimensions of fiscal sustainability:

How are credible budgets achieved?

What are Medium Term Expenditure Frameworks (MTEF)?

MTEFs represent rolling plans, normally over three to five years, which move forward each year with the first year representing the budget and the “outer” years representing projections of spending. The purpose of MTEFs is to enable more credible budgets, address fiscal sustainability and better link policy, planning and budgeting for meaningful shifts in spending priorities. However, although there is widespread recognition that this is a promising way forward, in practice establishing MTEFs is difficult, and implementation takes longer than is often anticipated.

MTEFs differ among countries depending on the fiscal context, capacity and tradition. MTEF is an aggregate term that can include:

  • Medium Term Macroeconomic Frameworks (MTMF) to provide a multiple year view on expected and relevant economic activity that can drive
  • Medium Term Fiscal Frameworks (MTFF) to predict the government revenue and expenditure envelop to inform
  • Medium Term Budget Frameworks (MTBF) that provide the basic structure of expenditures based on government priorities that can include
  • Medium Term Sectoral Strategies (MTSS) of specific programs designed to improve economic sectors whose performance can be managed by
  • Medium Term Performance Frameworks (MTPF) that align budgets with desired performance outputs and outcomes

Why are MTEFs challenging?

Traditional approaches to budget reform – multiyear budgeting, output based and accrual budgeting – have been particularly difficult to implement in developing countries and the development landscape is littered with failed reform strategies. Challenges to effective MTEF implementation include:

How does government budget planning software meet unique requirements?

Effective government budget planning software can be configured to meet unique requirements. There are numerous budget management software applications available but, in practice the World Bank and aid agencies have funded the introduction of private sector financial systems, which do not include core budgeting functionalities.

Government budget formulation software must support:

  • Financial functions including the ability to develop budgets in any combined top-down/bottom-up process. Effective budget preparation software can take previous data and adjust by formula (such as reduce by 5% all revenue categories or increase the cost of oil by 10%). The software enables linking budget justification directly with the budget classifications. The budget passed by the legislature, often called the “organic budget law” or “the vote” is automatically integrated with the budget execution/accounting system to ensure proper budget controls.
  • Content. Budget formulation software needs to use data from other sources including importing spreadsheet data directly to the financial budget plan, attaching narrative to budget requests and referencing documents.
  • Workflow: Flexible workflow functions are necessary to follow the government budget calendar and address budget categories. Multiple budget versions are required.
  • Performance: Governments with higher capacity can integrate output and outcome data to the COA and develop scorecards.

Component model for budget formulation automation software.

What are the inputs for government budget software?

Inputs in the budget formulation process include:

  • Financial transactions from previous years (and the active fiscal year) including the tracking of multi-year commitments that roll-over to subsequent years
  • Budget variances from previous budgets including changes that occurred to the budget during operation such as budget transfers and virements to provide trend information
  • MTEF year 2 and 3 budget estimates to provide a baseline for the working budget
  • Macroeconomic data that predicts government revenue, identifies risks, and creates baseline budget assumptions such as currency exchange rates
  • Cost drivers or established estimates for products and services so that budgets use credible assumptions and align with scenario planning such as analyzing the impact of changing energy costs and currency fluctuations
  • Documents like budget justification, policy information and reports
  • Integration with underlying systems and spreadsheets

What are the outputs for government budget software?

Outputs in the budget formulation process include:

  • Budget controls to be integrated with the treasury system components of the Government Resource Planning (GRP) software for commitment accounting including support for warrants, supplemental budgets, continuing resolutions
  • Scenario plans that enables government to quickly adjust budgets should risk factors come to fruition during the fiscal year
  • Documents generated from the system such as budget books

Why are flexible controls required?

Flexible controls in GRP software are critical for governments to match regulations and enable modernization:

  • Budget laws address high-level budget items in the COA. Therefore, strict control at details or “line item budgeting” is not material to the law
  • Capacity is critical when determining decentralization and needs to be flexible to support more discretion in spending and budget transfers to improve results
  • Allotments, appropriations, warrants and cash controls differ among countries based on legal frameworks, traditions and liquidity
  • Treasury departments provide more value to governments by managing liquidity and adjusting allotments based on surplus and deficit forecasts than approving commitments and transferring amounts among budget line items

What budget control functions are necessary in GRP software?

  • Multiple Controls: numerous controls can operate simultaneously such as cash warrants and annual appropriations
  • Periods: different controls can be active for different time periods, typically from a month to a year
  • Aggregate: controls can operate from detailed line item to high level and where the total of detailed line items could equal or not equal the total for the high level controls
  • Tolerances: discretion enabled for some controls such as the ability to overspend some monthly controls by a fixed amount or a percentage as long as aggregate controls are not overspent
  • Commitment Controls: where tolerances can be applied to commitments and obligations
  • Segregation of Duties: workflow controls to ensure proper separation of duties for spending approvals, payment approvals and budget transfer approvals that meet government fiscal regulations
  • Organization Configurations: support of different control schemes for different government organizations reflecting legal status and organizational capacity

Why not use spreadsheets or simple web applications for budget preparation?

Spreadsheet and simple web applications do not provide sufficient control, error management and integration for budget planning:

  • Version management and approval: versions of budgets and approvals for budgets require more sophisticated software that uses workflow control
  • Controls: budget formulation software is required to create controls, manage segregation of duties integrate with commitment accounting
  • Errors: validation on data input is not sophisticated in spreadsheet and simple web applications resulting in mistakes
  • Historical information: integrated budget preparation and budget execution software provides accurate analytical information for budget planners

What are good practices for budget formulation?

  1. Budgets are the legal embodiment of government policy and is critical in public financial management
  2. Budget formulation practices should match country conditions and human capacity
  3. The Chart of Accounts is critical for effective budget processes
  4. Budget formulation software can help to create more credible budgets that provide fiscal sustainability and internal controls

Government Resource Planning Training – Crown Agents

Tuesday, September 11th, 2012

Doug Hadden, VP Products

We just finished the one-day training course in London to a group of public financial management professions from Africa and Asia, held at the Crown Agents office. There was a lot of information squeezed into the course that I gave, as you can below. It had a bit of “drinking from a firehose” effect with so much information.

The primary focus of the training was on lessons-learned in implementing Government Resource Planning (GRP) systems in emerging economies. Participants in the course were from the national and regional levels of government and from donors. There was some interesting discussions about vendor governance, donor assistance and PFM sequencing that is almost universal and mostly vendor-neutral.

You can see the topics covered in the embedded document.

Slideshare.

What did I learn from participants?

  • General view from the PFM professionals was that the 3 most important PFM reform objectives are improved budget planning, procurement, debt and cash management
  • No one could guess how fast the fastest FreeBalance implementation was. Closest guess was 6 months which is slightly more that 6 times the fastest time.
  • Proper sequencing of reforms and the underlying technology remains a challenge in developing countries. Many participants expressed the view that donor representatives often have personal preferences.
  • Most participant agreed that it is difficult to make most commercial software solutions  self-sufficient in governments.
  • It was agreed that major enterprise software vendors rarely participate in Public Financial Management events. (And, when they do, show little interest in learning from conference sessions.)
  • One customer of one of the ERP vendors is pleased because there is direct manufacturer support. That happens infrequently (except for FreeBalance, of course.) Maybe that vendor is reading this blog and learning something ;)

The Governance Opportunity for Libya

Wednesday, July 25th, 2012

Hal Le, Director International Products

I had the opportunity to present some trends that we are seeing when working with our partner countries on themes of governance and transparency in Libya last week.  My keynote was at the at the International Libyan Conference on Electronic Government in Tripoli.

There are many decentralization models. All of these models can be enhanced with ICT technology like Government Resource Planning (GRP) to improve governance and transparency.  Capacity building in line with Public Financial Management (PFM) reform is necessary for sustained governance reform. That means that GRP tools need to adapt to the changing conditions.

2012-07 Decentralization, Governance and GRP Final

What Canada can learn from Developing Countries on Public Financial Management sustainability, [Part 6]

Tuesday, June 19th, 2012

Leverage “cognitive surplus” to improve public policy

Doug Hadden, VP Products

This is Part 6 of 6 parts detailing the content in my Financial Management Institute of Canada lunch presentation What can we learn about Sustainability from Developing Nation Governments?

Developing countries are adopting processes and technology designed to increase citizen trust while leveraging citizen and civil society cognitive surplus to improve public policy. If the Arab Spring, Tea Party and the Occupy movement has taught governments anything it’s crowdsource to improve public policy – or be crowdsourced.

Many define “democracy” as representative democracy rather than participatory democracy.  Indian MP Ruhal Gandhi suggested that the Anna Hazare hunger strike undermined democracy in India. Yet, it is clear that representative democracy is a thin form because citizens exercise the franchise only during elections.

Transparent and open government data enables developing nations to harness the power of citizens for audit. As I described recently in citizen audit use cases for Public Financial Management (PFM), there are compliance, fraud and performance citizen audit dimensions. Citizen audit is enabled through open data (proactive disclosure of public financial management information on the Internet) and social media collaboration (Internet enabled feedback and discussion.) I further suggested that it is the duty of citizens to leverage open government.

Auditing is expensive. Very expensive in developing countries. That’s why citizens, civil society and businesses are encouraged to help governments. For example, there is nothing better to uncover procurement fraud or poor procurement decisions than competitors.

We have world class external audit in Canada and improving internal audit, as I described in a previous post. David M. Walker, the former U.S. Comptroller General has pointed out that the US Government Accountability Office has a proven return on investment though trapping fraud, improving controls, proposing performance improvements etc. Yet, even audit agencies with proven returns are being cut back.

The Performance Problem

As I’ve pointed out before, performance management in the public sector is more complex than in the private sector. Private sector organizations have a bottom line: profit. There are established measurements like market share, and return on assets. Output measurements like the number of customer complaints handled, and outcome measurements like customer satisfaction survey ratings are factors that influence financials – profitability. If all the KPIs are green and the company is not making a profit, than the indicators are likely incorrect.

There is no bottom line in government. Outputs and outcomes are the results. Financial – in this case, budgets, is the input. This makes it very difficult to determine whether the KPIs are correct. There could be false positives and false negatives.

Social media in government, or Government 2.0, can engage citizens and civil society to report on outputs or outcomes. For example, the Ushahidi platform is used to monitor elections, disaster response and corruption.

The next stage in citizen engagement is crowdsourcing through expert groups or the public. This shows promise when managed correctly. For example, an effort at the White House generated some unexpected ideas. The principle of using citizens to propose and vet solutions reduces the burden on governments and may generate ideas to solve important problems.

Participatory Budgeting to go virtual?

Participatory budgeting is a process originally developed in Brazil to engage citizens to improve budgets. Adoption of participatory budgeting has grown particularly at local government. My sense is that the immediacy of service delivery in local government can create a critical mass of participation. The use of neighbourhood and civil society meetings and government outreach may not be sustainable in large regional governments and many national governments.

My view is that participatory budgeting will become virtual in the future. We can learn from the lessons in participatory budgeting to improve outcomes.

There is some sensitivity in governments to crowdsource policy because policy is considered the purview of political wonks. There is a notion of budget confidentiality in Canada that may restrict the kind of openness enjoyed in developing countries.

Open Government Costs

Many argue that open government, social media, crowdsourcing etc. just costs money. I’ve summarized the business case for open government in a previous entry. A recent Transparency Camp Brainstorm identified the following benefit categories for open government:

  • Revenue, primarily in the form of increased tax collection through increased economic activity
  • Efficiency, effectiveness and productivity through reduced cost per unit of work including cost avoidance
  • Outcome improvements such as achieving higher levels of service delivery or improved health statistics

David Eaves argued that open data can reduce the cost for reduce the costs of Freedom of Information processing

Social Media effects

The resistance to social media and open data in developed nation governments contrasts to the attitudes from many developing countries. I find a greater acceptance of the value proposition of open government in countries like Timor-Leste, whose transparency portal is an amazing achievement, than in G8 countries.  The commitments for the Open Government Partnership show that these countries are innovating beyond expectations. This could result in a more engaged population with a deeper form of democracy than we enjoy in Canada today.

As I’ve written before, social media will be transformational for Public Financial Management. The key driver in developing countries is the need to sustain reform. This doesn’t mean sustaining the PFM “status quo”. Or, tweaking processes. This means continuous modernization and reform. Catching up to developed countries. Leapfrogging developed countries. This effort requires citizen engagement.

Let’s hope that governments at all levels in Canada do not hold back and get leapfrogged.

What Canada can learn from Developing Countries on Public Financial Management sustainability, [Part 4]

Friday, June 8th, 2012

Part 4: Sustainable Planning

Value of medium-term budget planning

Doug Hadden, VP Products

This is Part 4 of 6 parts detailing the content in my Financial Management Institute of Canada lunch presentation What can we learn about Sustainability from Developing Nation Governments?

“Alphabet soup” of Government of Canada planning

We often accuse the American government of having an incomprehensible list of acronyms. An “alphabet soup”. We’re falling behind in the acronym arms race in the Government of Canada. Consider the following set of planning and regulatory concepts:

The state-of-the-art of budget planning in the Federal Government includes strategic tools like MAF, MRRS and PAA that attempt to connect objectives with programs and performance. There is standard bottom-up budgeting to maintain existing programs. And, there are different review methods to cut expenditures: reviews looking for efficiencies, reviews to reconsider strategic priorities, reviews to cut costs. It’s difficult to “connect the dots” among these frameworks, structures, architectures and reviews. Even more difficult to connect government objectives with policy, budgets and outcomes across these frameworks, structures, architectures and reviews.

Sustainable planning in developing countries

Medium term” planning is considered the best practice in developing countries. This is typically a rolling 3 year budget plan. This might sound a bit like the return to the 5 year plans used for central planning, primarily in Communist countries. Medium term planning uses rolling plans rather than separate 5 year discrete plans that operate in series.

The outcomes from government programs often take more than a fiscal year to accrue. Single year budget planning is too short a horizon to affect change. Results can be evaluated and programs adjusted to meet objectives. Medium term planning also takes into account multiple year commitments such as capital expenditures and subsequent recurrent costs. This introduces financial sustainability calculations into budget plans. Developing nations may receive grants for capital expenditures but may not have the operating budget to sustain those capital assets. Long-term financial implications become better understood to policy-makers.

Medium Term Expenditure Frameworks (MTEF) aligns economic realities with revenue and expenditures.

Peaks and valleys of government spending

The Government of Canada has fiscal space. We have a good credit rating and reputation for good fiscal management. The government debt to GDP ratio is manageable. Yet, it wasn’t that long ago that the Wall Street Journal referred to the Canadian dollar as the “peso of the north”.

Political realities often encourage short-term thinking. The focus on inputs: the amount spent in a particular riding or Province rather than long-term performance thinking. This short-term thinking can also result in creating financially unsustainable programs.

Short-term thinking often means not considering the real lifetime costs of major government initiatives. The current debate in Canada over the F-35 acquisition by the Royal Canadian Air Force has resulted in the fall of a government for “contempt of Parliament”. The press continues to torment the government about alleged underestimated budget miscalculation or deliberately misleading the House of Commons.

The emergence of a crisis such as the recent financial market melt-down can also introduce short-term cuts that cannot be sustained. For example, cuts to some programs may result in not meeting legal minimum levels of citizen services. So, spending increases in subsequent years. Cuts to other programs may result in high initial costs to dispose of property or for civil service severance.

Long-term financial sustainability is better achieved when fiscal sustainability is built into the process.

“Medium term” alphabet soup

There is no lack of acronyms for medium planning. Medium Term Expenditure Frameworks (MTEF) can consist of  MTMF, MTFF, MTBF, MTSS and MTPF. Governments apply some of these methods. The methods used typically depend on the government context, for example, countries with lower capacity will typically not use MTPFs. The methods are adapted for the country context – these are frameworks.

Frameworks link the economic realities (MTMF) to revenue and expenditure realities (MTFF) to budget planning (MTBF) to achieve objectives in multiple programs and sectors (MTSS) in the most effective ways (MTPF).

The advantages of this approach in a developed country like Canada include:

  • Improved long-term planning
  • Aligning government objectives and sector strategies across departments and agencies
  • Exposing the impact of economic impact to revenue and results during the fiscal year and during planning
  • Performance feedback loops that also show impact of economic changes on results
  • Integration of economic factors in planning and performance factors directly into the Chart of Accounts

The big advantage of the MTEF approach is to integrate strategy and review into day-to-day management and periodic planning. The alignment of performance to economics will enable the Government of Canada to model the effects of any major economic change to performance results. To service delivery. The decision of where to cut expenditures with the least negative impact and optimizing positive impact becomes less of a mystery. And, less of a complex management exercise. That is easier to communicate to citizens.