Fastest Growing City in the U.S. Gains One Source for the Truth in Revenue Management
In this iNovah Case Study, we present to you the very unique situation of the City of Seattle, Washington.
City of Seattle Profile:
- System Innovators client since: 2007
- 18th most populous city in the U.S
- Population: 745,000
- Annual budget of $5.9 billion
- 38 city departments, approximately 10,000 employees
iNovah Implementation Fast Facts
- Offices: 14
- Cashiers: 64
- Workstations: 34
- Interfaces: 17
- Receipt Volume: 4.1 million
The City of Seattle is a vibrant urban community of over 745,000 people on the West Coast of the United States. The seaport city’s economic appeal, beautiful environment, and unique culture creates a thriving area often described as a “melting pot” of people from around the globe. This appeal leads Seattle to being fastest growing city in the nation.
Catalyst for Change
The City of Seattle’s population began exploding in the early 2000’s with people flocking to the city for exciting careers and lifestyle changes. The city experienced phenomenal growth, with a massive population increase of over 120,000 people between 2010 and 2017. Although the economy was taking off, the region was left with many challenges to overcome as a result of this unprecedented growth. Many of those challenges proved costly.
When taking a deeper look to maximize budget dollars and address their growth, the city found their homegrown cashiering system was costly, relying heavily on IT support. Payment methods were evolving and their existing system couldn’t keep up. Seattle’s citizens expected online opportunities to conduct their business and, with the heightening of credit card incentive programs, credit card payments were at an all-time high.
With a mission to decrease IT support, replace outdated technology, and improve research capabilities, the City began the search for a new solution.
The City’s Goals
The City of Seattle holds a strong vision of developing a single system to meet the needs of the entire enterprise. To simplify operations and improve their revenue management practices, they sought an Enterprise Revenue Management (ERM) hub to provide one place to handle, research and report all financials.
With the search for a new solution, the City aimed to meet the following objectives:
- Replace out of date technology
- Lessen IT support of administrative activities
- Standardize interfaces between the cashier system and other internal/external systems
- Limit customizations to help control cost and support standard business practices
- Integrate with PeopleSoft financials
- Improve customer service by providing access to receipt and disbursement data
- Provide tools for self-administration
- Integration with PeopleSoft
- Timely and accurate reports
- Data integrity and security
- Lifespan of approximately 10 years
One City. One System.
As the city chose iNovah, they realized the solution they were searching for. Today, Seattle uses iNovah to accept and manage payments across the enterprise. iNovah is in 14 offices around the city, processing over four million receipts in 2017. Their revenue processes have been fully centralized, with 17 interfaces to the iNovah hub. iNovah’s real-time updates, research and reporting capabilities have provided them with an electronic fingerprint for visibility and accuracy into all audit data.
When discussing how iNovah has impacted their revenue management, the City identified seven key benefits.
Benefits of implementation
- Detailed transactions from imports.
- Improved reporting and research tools.
- New process efficiencies including in receipting and managing the employee transit benefit.
- Configurations that provide immediate updates as business needs are identified.
- New self-administration capabilities.
- Enhanced data with improved accuracy as well as default allocations and new chartfield validation.
- Direct interface to an employee database that provides immediate information into employee actions. This includes access to employee activity with the ability to validate an employee’s status plus qualifications for transit benefit. There is also the ability to record all financial transaction information by employee.
The Results – iNovah
The City of Seattle government abides by a “First touch, right touch” approach, particularly in the case of financial management. The adoption of iNovah plays an integral role in allowing the city to accomplish this.
Seattle’s Treasury department is responsible for ensuring all incoming and outgoing funds are recorded to the General Ledger (GL). Because they handle funds from across the city, it’s important for payments to be posted correctly the first time for maximum efficiency.
With the “First touch, right touch” approach, each finance activity is only handled once.
iNovah makes this a reality. From mail to over the counter, City staff have a single place to determine how to apply payments. Utilizing iNovah’s centralized, fully-integrated approach, the City easily accepts and manages payments, eliminating the misdirection of funds, avoiding errors, and saving staff time.
As a 12-year iNovah user with 17 interfaces city-wide connecting to the hub, the City of Seattle masters the concept of Enterprise Revenue Management.
iNovah’s integration to PeopleSoft
In 2018, the City made a giant leap forward in their overall approach to accounting. Their “First touch, right touch” philosophy transforms financial management to one modern, streamlined process. Seattle partnered with System Innovators to build an integration from iNovah to PeopleSoft 9.2. Thus eliminating multistep processes plus the risks and errors associated with using clearing accounts or not validating the GL. Instead of using clearing accounts and moving funds through journals, the City now applies funds accurately at during the transaction.
To accomplish this, a new GL validation is necessary to ensure accuracy across the board. In one easy step, iNovah speaks to the PeopleSoft-GL to validate that chart field values exist, validate all combo edits, and validate project attributes for every transaction. When a cashier enters a payment, iNovah automatically checks the GL and sends a message back to the cashier communicating if the transaction is clear or if there is an error. This process helps the City of Seattle prevent posting and keying errors by catching them as they occur.
Having GL validation prior to the completion of a transaction also prevents any invalid strings from exporting to the ledger or financial system. The benefits of the iNovah/PeopleSoft integration extend beyond transactions. Cashiers or administrators can run an export at the end of the day to update and report all activity, centralizing all GL activity in one hub. According to the City’s Treasury Cashier Manager, Katrina Gabrielson, this integration plays a key role in gaining consistency and centralization across all departments. “This implementation moved us to a project centric approach where our complex chart of account values could really tie revenue to expense. iNovah’s robust chart field validation has also allowed us to simplify reporting and eliminate entry errors, providing us better, more accurate data.”
“Projects are created by our Central Accounting team so all activity across all departments involved in a project are linked. With the iNovah/PeopleSoft integration, we can now report from a Project level and have all activity included,” said Katrina.
Trust Accounts with iNovah
Like many governments, the City of Seattle encounters a variety of scenarios when holding funds are necessary. With iNovah’s Trust Account Module, the City has a tool to handle these financials, without risking avoidable errors in entry and lost funds.
Seattle’s use of Trust Accounts grants the ability to hold and successfully manage all city deposits in one central place. Including cases where funds are unidentified. The city uses two types of Trust Accounts, also known as Escrow Accounts, for their financials.
The most commonly used is the Treasurer’s Clearing Account. This account houses unidentified funds pending coding, allowing the city to hold money for deposit until its correct placement is determined. Although the funds are unidentified, the City is able to record them in the General Ledger for deposit. The Treasurer’s Clearing Account simplifies tracking as iNovah manages all movement from the time of deposit until the time it reaches the right “bucket.” By handling the journaling of funds, iNovah controls the deposit and movement process, eliminating manual journal entry errors.
The City also utilizes Guaranty Deposit (GD) Accounts to hold money for the completion of a project or activity. For example, Seattle’s Department of Transportation requires funds held pending completion of permit work. Once completed, a deposit refund is performed using a customer interface from iNovah to PeopleSoft via the PeopleSoft single supplier upload. This implementation eliminates the need for the Treasury office to manually process refund checks for deposits held.
“iNovah has simplified many of our processes by adding a single interface. This has greatly improved accuracy, plus we have the ability to add new interfaces as needed. Things that were previously done manually can now be done inside the system, saving us time and potential errors. iNovah’s vast capabilities have improved the management of City-wide funds, helping us provide the best service to our citizens.”