Archive for the ‘IFMIS’ Category

The Frightening High Cost of ERP Customization

Thursday, March 28th, 2013

Doug Hadden, VP Products

A study sponsored by ERP vendor Unit 4 by Cindy Jutras is a sobering read.

I winced a few times.

Agility is part of the Unit 4 positioning. The fact that the sponsor is company positioned as agile found that ERP customization is costly doesn’t make the study incorrect. Or, the conclusions any less frightening.

High Total Cost of Ownership (TCO) and restricted business agility are the open secrets of the Enterprise Resource Planning (ERP) world. Why? The technology used by leading ERP vendors is, frankly, obsolete. Not all of it: just the core. The foundation.

So, it’s no wonder that methods developed in the 90s to solve pre-Y2K problems have started to show their age. Especially in cloud computing. And, the opportunities and threats that come from globalization.

The value of this report is that it goes beyond the impact of ERP customization as a high implementation cost that generates delays. This study looks at the impact of making changes to ERP customization to support compliance, reorganization, improved processes etc.

What is this “customization”?

Jutras doesn’t define customization. Many observers see customization as all adaptations to software from configuration through to software code development. My sense, based on the results of the study, that customization is defined as changes that require some element of coding. This includes Business Process Management (BPM) tools that requires elements of coding, scripting, call-outs from the ERP software to other code, and software code customization.

ERP vendors developed customization methods to enter new markets: different verticals, countries, customer sizes. And, customers needed to implement competitive differentiated practices. So, high cost and long implementation cycles. Which is why there is so much guff about implementing so-called “best practices” to reduce the customization hangover experienced by so many organizations.

No customization in FreeBalance?

FreeBalance provides Government Resource Planning (GRP) software. One of the characteristics of this software is that there is no customization as I have defined it with the exception of integration with sub-systems and some elements of business intelligence. (And, rather than make integrators or customers build functionality that we don’t have, we commit and put this functionality into the main line of the code.)

FreeBalance supports this no customization model because we can and we should. We can because we’re focused in one “vertical market”. We should because it is ethical. In my opinion, it is not ethical to force high costs to public organizations. As you can see from our government customer list , long-term financial sustainability is a critical factor. Our GRP software has to affordable in the long run to enable developing nations like Afghanistan, Kosovo, Sierra Leone, Suriname and Timor-Leste to grow and improve governance.

Government is the ERP customization canary in the coal mine

Jutras found that more than 1/3 of the organizations surveyed have implemented extensive ERP customization and almost 2/3 have experienced moderate customization. Only 4% of respondents reported little or no customization.

Which makes the “good practice” guff from ERP vendors a “buy case” and not a “use case”!

You may be surprised to learn that governments require more agile business systems than the private sector. Yes, governments are not known for agility. What they need are systems that enable change – more change than is experienced by the private sector including:

  • Legal reform that changes GRP configurations because governments cannot adopt new processes without a legislative approval. So, governments change configurations often.
  • Organizational structures change more frequently based on government objectives that includes merging ministries, eliminating ministries, splitting out ministries, and privatization.
  • Moves to transparency and accountability that are orders of magnitude more complex than compliance changes in the private sector.

ERP systems used in government tend to be more customized that in the private sector. One analyst commented on an ERP implementation in a G8 country as being so highly customized that it bore no resemblance to the original code. It’s frightening how much public money is wasted needlessly because of ERP adoption in government.

To be fair, there is only one publicly reported incident of Unit 4 failure in government and that could be explained through a number of factors. (And, from 2004) But, the leading 2 ERP vendors have a lot of explaining to do.

The other ERP open secret is that governments that have departmental level ERP systems have completely different customizations. So, the move to “shared services” to share a single ERP in these governments to save money is, frankly, a pipe dream . CIOs looking to implement ERP shared services using one or both of the 2 leading vendors need to read this report so that they are not complicit in wasting public money.

Good Practices in Cash Management for Developing Country Governments

Tuesday, March 19th, 2013

Doug Hadden, VP Products

We’re seeing increased interest in cash management among developing country governments. There are very few Public Financial Management (PFM) ‘best practices’ yet many good practices that are better depending on the country context.

 

Why is cash management important?

 

Effective cash management is enabled through effective budget formulation

What is cash management?

What are the differences between managing “cash” and “liquidity”

More developed countries make the distinction between cash management as a long-term planning and analysis function and liquidity management to ensure adequate cash is on hand. Short-term investments to ensure that there is effective use of the cash on hand are considered a treasury functionrather than a cash management function exercised through spending ministries.

How are GRP systems used to improve cash management?

 

What is the Treasury Single Account (TSA)?

A TSA can be defined as a unified structure of government bank accounts enabling consolidation and optimum utilization of government cash resources. It separates transaction- level control from overall cash management. In other words, a TSA is a bank account or a set of linked bank accounts through which the government transacts all its receipts and payments and gets a consolidated view of its cash position at the end of each day.

Why is the TSA critical to effectivecash management?

What problems do developing country governments face when implementing cash management?

What is the linkage between cash management and budget execution?

What are the characteristics of a good cash management system?

What are the stages to develop an effective cash management system in developing countries?

The sequencing of cash management functionality in developing country governments differs by context. Sequencing generally follows a pattern similar to this:

Stage 1: Addressing Fundamentals

Step 2: Forecasting capability

Step 3: Beyond prerequisites and basic cash planning

Step 4: Rough tuning  and fine tuning

How is cash forecasting accomplished?

 

How can GRP systems improve cash management?

  • GRP systems enable progressive activation enabling governments to sequence cash management functionality
  • Support for electronic funds transfer and integration among ministries provides up-to-date liquidity information
  • GRP systems support the migration to the TSA and numerous TSA methods
  • Comprehensive transactional information enables the development of cash requirements, cash flow and aging reports
  • Historical informationin GRP systems enable creating credible budgets using spending trend analysis
  • Through the use of commitment accounting, GRP systems track the entire procurement cycle from requisitions enabling improved prediction of cash requirements
  • Budget and commitmentcontrols can include warrants, or authorization to spend, over short periods of time based on cash forecasts
  • Cash controlscan set thresholds to limit spending should there be reduced liquidity
  • Workflowprocesses in GRP systems enable governments to adjust for temporary cash problems and alerts decision-makers on potential liquidity problems

What is a good practice approach to using GRP for good cash management?

  1. GRP software supports the use of the Treasury Single Account.
  2. GRP software provides the historical information necessary to make effective cash forecasting.
  3. GRP software provides budget planning and budget execution functionality to ensure creating credible budgets, managing against the budget and adjusting for cash availability.
  4. GRP software provides integration among revenue and expenditure systems including payment systems.
  5. GRP software can eliminate the poor practice of cash box budgeting.

Governance Scenario: GRP impact for Anti-Corruption in Procurement

Tuesday, March 12th, 2013

Doug Hadden, VP Products

FreeBalance has developed a framework to show where Government Resource Planning (GRP) software can help improve governance outcomes for governments in developing countries. This Governance Framework includes an overview of the governance question and a description of the methodology.

Manuel Pietra, our President and CEO, presented the case for using GRP to reduce procurement corruption at a seminar at the Harvard Kennedy School last week. This is an updated version of that presentation with more details.

Impact:Total global annual government procurement is estimated to be $9.5 Trillion .

Problem:Corruption is estimated to cost developing country governments 20% to 25% of procurement costs.

Other factors:Procurement efficiency, effectiveness and competitiveness are other important governance factors

Scenario:Lifecycle for an important multiple year public investment program such as the building of a new hospital.

Government Resource Planning

The technical GRP lifecycle can be described as follows:

  1. Enterprise-grade ICT Platform as foundation including a secure infrastructure
  2. User group controls have been defined in the ICT Platform
  3. The hospital public investment program is defined during budget preparation, part of Government Performance Management functionality, and the budget has been approved by the legislature
  4. Core Public Financials part of GRP includes commitment accounting functionality used to ensures that the government does not overspend the budget (integrates with the budget passed by the legislature) and tracks all accounting transactions related to the hospital program
  5. Public Expenditure Management integrates with commitment accounting through a procurement cycle begins with the approval of a commitment from a purchase requisition that generates a Request for Proposal (RFP) to qualified bidders as part of the tendering process that results, in this case, a winning “turnkey” contract based on evaluation criteria to a winning bidder or consortium
  6. Proposal opportunities were presented via the web through e-procurement and the winner of the proposal and contract size is posted
  7. Payment is provided to the winning bidder through payment management based on the contract provisions typically based on the government acceptance that building milestones have been reached
  8. And the entire cycle is stored in an audit trail to improve Government Performance

Governance Toolset

The hospital acquisition scenario described provides multiple corruption opportunities:

  • Vendor collusion to provide only a single winning bid
  • Bribes by vendors to manipulate the process such as changing the evaluation criteria unfairly
  • Approval of a bid by family members
  • Payment for goods and services not received

GRP systems contain three classes of toolsets that can be used to overcome corruption opportunities:

  • Controls that prevent civil service users from manipulating the process
  • Transparency that expose inner government workings to provide oversight
  • Decision-making to enable tracking compliance and performance

Some governance tools from the FreeBalance Governance Framework can be leveraged in this scenario.

There are universal governance tools operating at every stage in the procurement lifecycle including:

Controls

  • Chart of Accounts that aligns all government financial activity to budgets, users, purpose, organizational structure and accounting types to reduce accounting manipulation
  • Segregation of Duties to ensure that multiple individuals are involved in the procurement cycle making manipulation more difficult
  • Integration to ensure that the commitment rules in use in the commitment accounting system are respected in the procurement system
  • Procedure Workflow that articulates the proper processes and prevents system user from changing rules such as the length of time that vendors have to respond to the RFP

Decision-making

  • Alerts from the workflow that notifies interested parties such as internal audit or the Minister of Finance about milestones in the tendering process providing more oversight
  • Dashboards that provides exception reporting to managers about the process

Some governance tools augment specific parts of procurement lifecycle:

  • Secure infrastructure is augmented by control tools such as data integrity that prevents manipulation in underlying databases, encryption that prevents people from accessing certain types of data, and general IT security such as virtual private networks to reduce ICT manipulation
  • User group controls is augmented by user management such as password controls
  • Budget preparation is enabled through structured multiple year planning decision-making such as MTEF that leverages historical data to ensure that the planned hospital budget is realistic
  • Commitment accounting is enabled through budget and commitment controls that ensures that obligations do not exceed commitments and that items not part of the hospital procurement are acquired
  • Procurement is enhanced through e-procurement transparency that enables comparing contracts over time to expose potential manipulation
  • Payment management is enhanced through secure payment controls such as Electronic Funds Transfer (EFT) that reduces the opportunity for the fungibility of cash and ensures traceability
  • Auditing is enhanced through decision-making tools that trace every function, transaction and approval in the system from payments back to the original plan through the audit trail

Governance Enablers

Institutions and institutional characteristics such as capacity and political will are necessary to effectively leverage the governance capabilities of GRP. However, there is evidence that GRP systems, by themselves, reduce corruption:

  • Controls prevent many corruption opportunity points
  • Transparency through front-office systems changes behaviour because of the embarrassment factor
  • Knowledge that all transactions are tracked changes behaviour because of the threat of being caught

Institutional governance enablers that are critical across the procurement lifecycle include:

  • Capacity of stakeholders including businesses, civil society, legislature, anti-corruption organizations and the civil service for management and oversight
  • Political Will by stakeholders such as the executive to support anti-corruption activities
  • Standards used in public financials that provides better information to stakeholders
  • Compliance processes and norms within the government

There are other institutional characteristics that are important during the lifecycle include:

  • Accounting procedures used by the government that provides appropriate fiscal discipline using good practices and integrated with controls
  • Access to transparency technology and maturity of civil society institutions during and after public investment procurement which can extend back to budget preparation to hold the government to account
  • The independence and enforcement options for internal and external audit institutions to trap corrupt practices

It can be argued that appropriate institutional arrangements for anti-corruption will have limited impact without an effective underlying technology system:

  • Auditors will be forced to track spending and compliance violations through paper files or across incompatible information systems
  • Transparency mechanisms could result in publishing only the information that procurement officers wish to be published
  • Manipulation of procurement processes will be difficult to uncover without an audit trail “smoking gun”
  • Disconnection with the original budget process could result in the purchase of goods and services that have little to do with the intention to build a hospital
  • Cash payment will reduce the ability for auditors to “follow the money”

Governance Signs

There are numerous signs that are used to measure the governance effectiveness of PFM in this scenario:

  • Public Expenditure and Financial Accountability (PEFA) assessments are widely accepted as showing the PFM state-of-the-art in any country. PEFA provides detailed analysis of the comprehensiveness, efficiency and quality of PFM processes
  • Transparency International Corruption Perception Index that uses surveys to determine the perception of corruption in a country
  • Actual incidents of procurement corruption and prosecuted procurement corruption that becomes well-known in the country

Governance Linkages

In this anti-corruption scenario:

  • GRP systems support automated transparency in the form of an e-procurement portals
  • Governance tools within the GRP help to control corruption
  • Transparency through the e-procurement portal changes stakeholder behaviour reducing corruption
  • Procurement transparency improves the perception of corruption such as the Transparency International Corruption Perception Index
  • Improved corruption perception and corruption processes will result in improved rating in the meta World Governance Indicator, Control of Corruption

PEFA Impact

Although PEFA assessment lack some detail on procurement processes, a GRP with tools and enablers will help to improve ratings for:

PEFA B Comprehensiveness and Transparency

  • PI-5 budget classification could be improved to show objectives and sector programs within the government books
  • PI-6 increase in the comprehensiveness in budget documents thanks to improved planning and accessibility of procurement details
  • PI-10 increase in the availability of financial information to the public via the e-procurement portal and through improved reporting

PEFA C(ii) Predictability and Control in Budget Execution

  • PI-19 improved value for money through increased competition and improved commitment and procurement controls
  • PI-20 effectiveness of controls for non-salary expenditures through budget, commitment and process controls integrated across accounting and procurement systems
  • PI-21 effectiveness of internal audit through improved capacity, independence and access to audit trails

PEFA C(iii) Accounting, Recording, Reporting

  • PI-22 improved timeliness of accounts reconciliation via integration and automation including bank reconciliation from payments made to the vendor providing the hospital
  • PI-24 improved quality and timeliness of in-year reports through integration, automation and the use of international standards and good practices in accounting procedures that shows potential gaps between the proposed budget and actuals
  • PI-25 improved quality and timeliness of in-year reports through integration, automation and the use of international standards that shows the impact of public investment projects like the hospital to the government books

PEFA C(iv) External Audit and Scrutiny

  • PI-26 improved scope of external audit through independence, capacity and access to the procurement audit trail

Governance Indicators and Outcomes

The improvement of meta governance indicators like the Control of Corruption improves trust and investment in countries. These indicators are used by credit agencies. Foreign Direct Investment (FDI) can increase. “Doing Business” ratings can improve based on the transparency of government procurement that represents significant portions of business opportunities within developing countries.

The procurement “output” – the acquisition of a hospital through a process that reduces corruption can enable a small developing country to improve health outcomes. Some health outcomes are used by donors such as the Millennium Challenge Corporation (MCC) when evaluating funding decisions. Other health outcomes are tracked as part of the Millennium Development Goals (MDGs).

These health outcomes are not trivial. MDGs are highly politicized and play a significant role in donor and government priorities.

It is true that exogenous factors can prevent the smooth transition from GRP systems to improved health outcomes. Yet, it is clear that a lack of corruption controls in the hospital procurement will negatively impact any governance outcomes.

Conclusions

Public investment programs are critical in developing countries. Infrastructure is needed to improve the transportation of goods to market. Hospitals and schools are needed to improve health and education.

Public investment programs are also fraught with corrupt practices even in developed countries. GRP systems are leveraged to reduce procurement corruption and to trap incidences of procurement corruption through:

  • ICT security techniques to reduce manipulation
  • User management integrated with GRP controls
  • Audit trails and alerts to track manipulation of GRP systems
  • Integration among systems to prevent corruption at interface points
  • Transparency through e-procurement to enable civil society and competitors to monitor procurement
  • Workflow that ensures that government procedures are used

These tools and techniques are best leveraged by governments with anti-corruption political will, good civil service and civil society capacity and audit organizations with sufficient capacity, independence and enforcement.

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

No Coincidences? Similar experiences in financial software among developed and developing countries

Friday, February 22nd, 2013

Doug Hadden, VP Products

We started a sharing good practices white paper series last month. This is part of our mandate, as a social enterprise, to share lessons learned in technology and good governance to the broad Public Financial Management (PFM) community. We published our latest good practice document to coincide with the upcoming East and South Africa Association of Accountants-General conference next week in Botswana.

The genesis for this good practice document is interesting. FreeBalance is a Canadian company based in Ottawa with a large installed base in the Canadian Federal Government. So, we have some insight into the complexities of public finances and human resources in a G8 country. Canada is considered to have one of the most advanced structures for governance in the world. And, our Canadian customers, thanks to the governance of “clusters”, have driven our products for almost 30 years.

Our mission has been to take our robust Government Resource Planning (GRP) software to less developed countries. Good governance, in my opinion, is not a “zero sum game.” It has a network effect in that improved governance in one country has positive effects in other countries.

The dark side of success?

In the course of events in the past decade, procurement cycles for government Integrated Financial Management Information Systems (IFMIS), as they are often called, were accelerated for post-conflict countries. The international community recognized that software and capacity building was necessary to rebuild government. And, FreeBalance software that was highly flexible for government, and only government with support for Canadian government requirements from decades past, gained a foothold.

The ultimate reward for success in fragile states – the only COTS vendor to have success under these difficult conditions – was an assumption that our software and expertise was only viable for “underdeveloped countries”. That’s certainly been the fallacy that major Enterprise Resource Planning (ERP) like to propagate.

There are some interesting observations that I have made from our on-going research into the PFM domain that may be of interest to you:

  1. Many developing countries have leapfrogged developed countries particularly with the support for International standard, budget transparency and multiple year planning. Some might say that there is a double standard where donor countries and multilateral financial institutions expect better governance mechanisms in post-conflict countries than they support themselves.
  2. The success rates for ERP software in government is meager. In very developed countries with high human capacity and good project methodologies. We encounter so many stories of ERP problems in government that we often fail to realize that ERP does not have a good track record in the private sector. The “enterprise” sector. It’s true that we update our ERP failure ERP Fail page as we learn about problems that have been reported publicly. We learn about far more failures and issues that are not reported. Which stands to reason – it is very embarrassing to country governments or IFIs to expose these problems.
  3. The term “innovation” is frequently used in the enterprise software domain to the point where it’s lost all meaning. Vendors tout mobile technology yet the core of their software is client/server. They throw hardware (in-memory) to accelerate processing as if this hasn’t been done before by anyone. And, they continue to present the fiction that the larger the company then the lower the risk to customers.

Good Practices in Government Resource Planning, Developed vs Developing Countries by FreeBalanceGRP

Using GRP Systems for Anti-Corruption

Thursday, February 7th, 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 fifth released document, embedded below, describes good practices in anti-corruption through the use of Government Resource Planning (GRP) systems. Back and front-office GRP systems can be powerful tools to prevent and uncover financial corruption such as ghost employees, tax evasion and procurement collusion. It’s clear that political will and accountability mechanisms are required to leverage tools. Independent audit and the rule of law are clearly required.

Anti-corruption initiatives tend to focus on creating special commissions. This is critical. But, it seems to me that there is a general assumption that technology, but itself, does not have any particular effect on corruption. There’s also the suspicion that automation can automate corruption – make corruption more efficient.

Our experience suggests that setting up controls and an audit trail dramatically changes behaviour. Controls can prevent circumventing the system. Audit trails and reports can expose corrupt activities.

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

Government of Suriname Accelerates Public Financial Management Reform with FreeBalance

Thursday, February 7th, 2013

Good governance solutions to help achieve sustainable growth through the progressive activation of GRP functions in line with improved public service capacity in Suriname

FreeBalance today announced that the Government of Suriname is deploying a comprehensive FreeBalance solution including software, services, support and capacity building. FreeBalance Accountability Suite software is being deployed throughout the government starting with the Ministry of Finance. The implementation will include all line ministries, sub-national governments and parastatal entities (public works and education).

The FreeBalance solution will enable the Government of Suriname to achieve its Public Financial Management (PFM) reform objective to sustain economic growth. “The highest priority for the Government of Suriname is to sustain economic growth. Sustainable growth will enable us to increase public sector development and citizen service delivery. PFM reform is considered a foundation for these objectives,” said Adelien Wijnerman, Minister of Finance of the Republic of Suriname. The Government of Suriname will be using a modified “platform” approach to PFM reform consisting of four overlapping phases. This approach ensures that there is not an overwhelming “change management” burden and recognizes the need for “small” wins to socialize change. This good practice is a key part of the FreeBalance i3+qM methodology designed for sequencing PFM reform based on the country context.

FreeBalance is also extending its operations in Suriname to include a permanent presence in Paramaribo to support the project and the Government of Suriname. “We are fully committed to supporting the PFM reform objectives of the Government of Suriname. We recognize the need for a strategic partnership is required,” said Manuel Pietra, President & CEO of FreeBalance. “This method ensures financial sustainability as information systems are adapted to the sequence of PFM reform appropriate to Suriname. “The permanent presence in Paramaribo is bolstered with the support of FreeBalance staff and resources from service, support, sales, project, and development offices around the world. This global workforce brings an additional and unique blend of experience, lessons learned, and good practices to the project.

Government of Afghanistan and the Open Budgets “controversy”

Wednesday, February 6th, 2013

Doug Hadden, VP Products

I had a few interesting exchanges on twitter yesterday, the first concerning the improvement from 21% to 59% made by the Government of Afghanistan on the Open Budgets Survey . (See below for the “storiefied” version)

The International Budget Partnership provided links to news stories about this achievement.

My sense is that many are incredulous that Afghanistan has a rating just below Italy.

The point is that Afghanistan makes 6 of the 8 documents that should be public by the OBI public. The other 2 are used internally. Public engagement was rating weak and there is room for improvement. Publishing the additional 2 document and increasing public engagement will improve the rating.

The Government of Afghanistan uses the FreeBalance Accountability Suite. This enables the government to publish budget information if there is political will to do so. The Government of Timor-Leste publishes information directly from our software in a Transparency Portal and the Government of Liberia has announced an electronic billboard project to show government expenditures. I suspect that Liberia will also be using FreeBalance back-office software to support this initiative.

The governance news from Afghanistan is usually grim, as I have said in the past. The truth is that there have been achievements in Afghanistan including a good Public Expenditure and Financial Accountability (PEFA) assessment in 2008, rating of achieving substantial PFM progress and evidence of how software reduced corruption in Afghanistan.

To be clear, I am not saying that our software is a magic anti-corruption/good governance pill. I’m saying that the tool, when there is political will and commitment can be used for transparency and accountability. And, the governments of Afghanistan, Honduras and Liberia should be acknowledged for their governance achievements.


Open Budgets Controversy?

Interesting exchanges from the launch of the "increasing the Pace of Budget Transparency" event at the World Bank (http://live.worldbank.org/increasing-pace-budget-transparency) yesterday.

Storified by · Wed, Feb 06 2013 06:10:12

The index is available at http://internationalbudget.org/what-we-do/open-budget-survey/. I listened into the web cast and tweeted.

Cases from Afghanistan, Brazil, Honduras and Liberia were highlighted. Mustafa Mastoor, Deputy Minister of Finance, Afghanistan; 
Eliomar Wesley Rios, Deputy Secretary of the Budget Planning Ministry, Brazil; and Amara Konneh, Minister of Planning and Economic Affairs, Liberia spoke via video conference.

Countries which "improved budget transparency dramatically" include: Afghanistan, Burkina, Honduras, Mozambique, Pakistan #openbudgetindexFelipe Estefan
Vivek Ramkumar, Director of International Advocacy and the Open Budget Initiative, was one of the main speakers. Vivek is a strong advocate for budget transparency. I remember him speaking at an ICGFM (www.icgfm.org) event a few years ago. Some representatives of the Government of Honduras were upset about their rating. Vivek explained the methodology and that the International Budget Partnership was not besmirching their quality of public financial management. At any rate, it looks like Honduras has dramatically improved.
Brazil, of course, is the international poster child for budget transparency. Afghanistan and Liberia leverage the FreeBalance Accountability Suite to support budget transparency. Given the overwhelming narrative in the press about corruption and mismanagement in fragile states, I think that it is important to recognize any governance achievements.
The OBI for Afghanistan improved from 21% in 2010  to 59% (Country Summary – English) while Liberia improved from 2% in 2008 to 43% (Country Summary – English). 
Anyway, this generated some interest from Edward Rees who has significant first-hand experience in fragile states. I find the engagement on social media to be particular valuable because it can enable understanding the situation better. That’s why I follow @ReesEdward and, if you care about fragile states, you should too.
RT @OpenBudgets: Mastoor: increase in #OpenBudgetIndex score has created confidence in government and public of improving situation in AfghanistanFreeBalance
#Afghanistan improved dramatically in the #openbudgetindex for publishing the pre-budget statement, budget proposal, and citizen budget.Felipe Estefan
@freebalance r u serious?Edward Rees
@ReesEdward yes, he was speaking about how they were able to increase #openbudgetindex to 59 points – that’s just below Italy at 61FreeBalance
@ReesEdward #openbudgetindex is set by actions not by perceptionFreeBalance
@freebalance that confuses the average punter. Either way. You know as well as I do that those guys in Kabul are in a world of trouble.Edward Rees
@ReesEdward #governance ratings never fully representative – saying that, budget transparency can’t be a bad thingFreeBalance
My tweets also got noticed by a public financial management expert from the UK on the applicability of publishing internal government documents. 
@freebalance i agree but writing for ext audience is diff’t so public bodies would have to change their prep of internal docsGary Bandy
@garybandyuk shouldn’t assume that these docs are completely obscure to everyone, so needs civil society pressure to make accessibleFreeBalance
.@freebalance: #openbudgetindex many budget docs produced for internal use only, easy to make available #transparency > but understandable?Gary Bandy
@garybandyuk 1 of 2: @OpenBudgets provides full details on how to develop a citizen-centric budget (so does http://www.agacgfm.org/)FreeBalance
@garybandyuk 2 of 2: internal budget documents has policy narrative & chart of accounts operates as good metadata for analysisFreeBalance
A few other tweets about the importance of budget transparency and the process used to develop the Open Budget Index.
Rios: Creation of transparency portals which show amount and objective of federal transfers to state and municipal govts #OpenBudgetIndexOpen Budgets
Sanjay Pradhan: budget is the most important policy document, and the lives of ordinary citizens depend on it #OpenBudgetIndex #wbliveOpen Budgets
step 1: #openbudgetindex doesn’t use consultants, has to be civil society, 2: independent review, 3: government reviewFreeBalance

PFM Best Practice: The Total Cost of Ownership of Government Resource Planning (GRP) Systems

Sunday, February 3rd, 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 first released document, embedded below, describes methods of calculating the Total Cost of Ownership (TCO) for Government Resource Planning (GRP) systems. I think that this could also be used in general TCO analysis for Enterprise Resource Planning (ERP) systems in the private sector.

TCO is a critical concept in GRP because of the high risk of IT failure in the public sector
and the high failure rate of ERP in government . The monitoring of upgrade costs, employee retention, customization burden and electricity draw is an early warning system for IT failure. And, TCO tells you whether your GRP project is financially sustainable.

FreeBalance Good Practice GRP and TCO by FreeBalanceGRP

FreeBalance International Steering Committee: FreeBalance Product Update

Thursday, January 31st, 2013

Doug Hadden, VP Products

FISC 2013 is our Seventh Annual FreeBalance International Steering Committee conference. The FISC approach differs from the traditional technology user group conference in many ways – good ways, we think

For one thing, FISC is about enabling customers to influence FreeBalance, not the other way around.

In the spirit of transparency, we were live tweeting from FISC last week and we’ve ‘storified’ it below.


FISC7 Product Discussion

The FreeBalance International Steering Committee sets the product direction for FreeBalance. FISC members come from governments around the world. The 7th annual FISC conference is being held in Ottawa. FISC members change the FreeBalance product roadmap unlike the practice from large vendors.

Storified by · Wed, Jan 30 2013 10:37:07

Integration, technology and custom needs were discussed.
Sagastume: #integration in government = where gov never asks citizens the same question twice, ever #FISC7FreeBalance
many software vendors talk about #integration, but is it really integrated after all the acquisitions? #FISC7FreeBalance
new V7 of #FreeBalance software is more extensible: discussion ensuing about extending treasury functions significantly #FISC7FreeBalance
Also Sagastume: in #PFM, context matters yfrog.com/h2rivdvpj public financial managementFreeBalance
Aldo Sagastume: lesson from #SAP #France implementation is that you need to change all the government processes in your country #FISC7FreeBalance
Aldo Sagastume: critically important that your #GRP follows the government legal processes #FISC7FreeBalance
Aldo Sagastume: V7 supports more flexible commitments, multiple year COA to support government financial processes #FISC7FreeBalance
FreeBalance V7 supports hiding fields of information, selecting mandatory fields & flexible workflow all b/c of FISC feedback #FISC7FreeBalance
Aldo Sagastume: government financial management different from private sector, flexible budget & commitment controls required #FISC7FreeBalance
Payroll and Human Resources discussion revolved around the problem of ghost workers and predicting wage bill costs over time.
Sagastume: good government #payroll system can help you predict long-term salary budgets #FISC7FreeBalance
Sagastume: government #payroll is often >50% of the #budget, so civil service management is critical #FISC7FreeBalance
Government procurement and public investment management wer important discussions..
Sagastume: significant % of government #budget goes through #procurement, the entire cycle should be automated #FISC7FreeBalance
how to handle % complete in public investment projects across multiple years is generating #FISC7 discussionFreeBalance
interesting discussion on integrating legal office into #procurement process & proof of progress/inspections at #FISC7FreeBalance
need multiple year #procurement processes even when not using multiple year #budgets #FISC7FreeBalance
milestone definition for % complete checked through inspections can be linked to #procurement payment & contracts #FISC7FreeBalance

Also see:

  • Customers Gather in Ottawa for 7th Annual Steering Committee Meeting
  • Introduction to the FreeBalance International Steering Committee conference, FISC7 in Ottawa
  • FreeBalance International Steering Committee: FreeBalance Product Update
  • Customer Centric Processes in Operation at the FreeBalance International Steering Committee Conference
  • PFM Good Practice Discussions at FISC
  • What are the Incentives for Transparency in Developing Country Governments?
  • 7 Highlights from the past FreeBalance International Steering Committee Conferences
  • 7 Things about the 7th FreeBalance International Steering Committee
  • Top 7 Lessons Learned at FISC7