Three years ago, departments within the Metropolitan Government of Nashville and Davidson County, Tenn., (the Metro) relied on the limited tools available to them in a J.D. Edwards ERP system to submit annual budget numbers.

The information came to the Metro's Office of Management and Budget (OMB) in disparate forms, which made analyzing and preparing budget information for the Metro Council's approval a time-consuming process. To gather departmental data into one budget document, OMB staff managed a complex series of spreadsheets and downloads, which were difficult to control.

"Departments submitted their budget requests in any number of ways -- Word document, Excel spreadsheet, etc.," said Richard McKinney, CIO and director of the Metro's Department of Information Technology Services (ITS). "That was a problem. Taking all the different budgets and trying to roll them into a single budget document or database was impossible, so budget data had to be rekeyed by the budget office. Government budgeting is so unique and different that traditional ERP systems come up short."

The OMB worked with ITS to streamline the process. "Our goal was to create a virtually paperless system that would produce a very effective tool for agency input and allow us to manage the output of Web-based databases," said David Manning, the Metro's director of finance.

OMB Director Talia Lomax-O'dneal worked with ITS Project Manager Cassandra Davis to develop Web-based tools to make the budgetary process smoother for the OMB. The result is WEBudget, a secure, Web-based application built with Microsoft .NET and SQL Server that allows users to input data from any location and gives the OMB a way to monitor the departments' progress during the process.

Breaking Down WEBudget

WEBudget is organized into a series of wizards to help departments organize and report data needed for creating their budgets, such as revenue estimates, budget modifications, operating capital, performance measures, capital improvements, mayor's hearing sheets and position control.

Davis said users can extract the data they input to create a report by using Microsoft Word and Excel and can also see a list of the entries, as well as the details of each entry.

The jurisdiction saw immediate benefits after using WEBudget.

"With WEBudget, everyone's budget submittals are done on the same electronic forms, and upon submission, are automatically inserted into a single Metrowide budget database that, in turn, is capable of generating a single budget document," said McKinney.

The previous budget-reporting process elicited paper forms and spreadsheets that took time to wade through, Davis said. WEBudget collects data in one place for use by many, ensures a consistent format and provides upfront data validation. This process lets both OMB staff and agency staff view the data simultaneously.

Having the data in one document allows Manning's office to more closely monitor departments' progression during the process, and even get a jump on making budgetary decisions.

"The budget system has a methodology that allows me to look at it and understand what step in the process has been completed on what date," Manning said. "One of the values of WEBudget is it allows us to much more effectively and efficiently translate the work product into a document to publish the data on the Web."

This way, Manning can determine whether a department's input was completed or whether it's still in an earlier stage.

The key for the jurisdiction during the budget process was time. Before WEBudget, it was a Herculean effort to get budgets submitted on time and give the OMB a chance to scrutinize the numbers, McKinney said.

"By automating this consolidation of information, the OMB can spend more time analyzing the submitted budgets and preparing for the budget hearings with the finance director and the mayor that constitute

Eliot Cole  |  Contributing Writer