Collier County Clerk of Courts Implements an Audit-Ready Invoice Processing Solution

governmentbuilding

The largest county in Florida wanted to centralize and automate the processing of more than 7,000 invoices a month. The county had implemented SAP ERP more than a decade before and used the software for many of its financial processes; however, the AP department still relied on a paper-based invoicing process. Vendors mailed invoices to the county’s various offices and departments, and these invoices were then routed for manual approval. For an organization that manages massive projects like constructing roads and buildings, accurate financial planning is crucial. Also, Florida Statute requires the Collier County Clerk of Courts to audit these documents to ensure legality of payment, which can increase the timeline for processing invoices. "We had manual processes in place for receiving and processing invoices," says Jane McDonald, Senior Project Manager for Collier County Clerk of Courts. "Workers used email and interoffice mail and didn’t always send the invoices to the AP department right away. We didn’t have visibility into an invoice’s status until it was approved and entered into SAP ERP at the very end of the process. Because our projects sometimes continue for months, workers often had to search through file cabinets (files are kept on site for two years) or warehouse archives to locate older invoices." The Clerk of Courts management information system (MIS) and AP organizations knew it was time to research new technology that would leverage the SAP workflow. A cross-functional team was assembled and began to evaluate how much work would be required to build and maintain a custom solution from scratch. At the same time, they also considered third-party vendors that might be able to provide an appropriate solution. Key capabilities the county identified include:

  • Ability to integrate the chosen technology with the organization’s current SAP environment
  • Digital storage of invoices
  • Easy extraction of information for auditors
Solution The county’s vendor selection team chose Dolphin’s Process Tracking System for Accounts Payable (PTS-AP), which went live in August 2012. The project involved instituting a new accounts payable workflow aimed at centralizing the AP process countywide. Key feature are:
  • Automated invoice capture, with scan and capture
  • Powerful InfoCenter to facilitate invoice processing and troubleshooting by the AP staff
  • Automated workflows to route invoices to the appropriate department that, in turn, can route it for additional approval(s).
  • Improved exception handling for If an invoice is rejected during that process, it can be easily returned to the vendor with a rejection code along, with any backup documentation to explain why it could not be paid.
"All of these steps in the invoice approval process have a predefined status within the system’s workflow," explains Frank Bodino, Senior Systems Analyst at Collier County Clerk of Courts. "In this new process, all of the steps are visible. We know where each invoice is at all times, we know who looked at it, what notes they put down, and when it was approved. If the invoice was rejected, we know why." After the invoice is approved, the goods receipt is matched, and the AP audit is performed, then the invoice can be posted to SAP ERP. "All the information we need to post the invoice is there, so there’s no dual-keying or duplication of data," McDonald says. "We just hit the button, and the invoice information posts." Improving the AP business process required changes across the entire organization. For example, since invoices now come into the AP department as the first step of the new process, the various departments within county government had to adapt to a new workflow where AP clerks scan the invoices. While the new workflow for invoice processing is much more streamlined and intuitive, it did require training users on the new system and getting their buy-in on the updated processes. "Just like with any training, some people caught on very quickly and others struggled with the new processes," says McDonald. "The project team created training documents to help explain the process in a way users could understand." Results According to McDonald, the new solution has delivered all of the benefits advertised and more.
  • Easy access to and cost effective storage of invoice documents
  • Simplified approvals process
  • Ability to track how many invoices are processed in a given period is helping the organization measure its own performance.
  • Improved visibility both internally and externally.
"Now, we can provide our external auditors with invoice information, purchase order (PO) information, and backup documentation more easily than we could with the paper-based system," says McDonald. "In the past, we had to go back to the paper files and dig out the invoice which was time consuming. A significant time and cost savings benefit was our ability to search by check number or the clearing document and instantaneously receive the information associated with the invoice." The improved metrics have also pinpointed any delays in the AP process. For example, the new process showed that many invoices are rejected because vendors don’t provide PO numbers on their invoices. Without the PO number, AP clerks were forced to try and find out which department and what purchase generated the invoice. By requesting that vendors provide the PO number on their invoices, the AP process has been streamlined even further. According to Bodino, the county has become more efficient thanks to the new solution. "We have been able to fix and change processes that, while they worked, were cumbersome at best," he says. Download_PDF

Back to Resource Library

Collier County Clerk of Courts Implements an Audit-Ready Invoice Processing Solution

The largest county in Florida wanted to centralize and automate the processing of more than 7,000 invoices a month. The county had implemented SAP ERP more than a decade before and used the software for many of its financial processes; however, the AP department still relied on a paper-based invoicing process. Vendors mailed invoices to the county’s various offices and departments, and these invoices were then routed for manual approval. For an organization that manages massive projects like constructing roads and buildings, accurate financial planning is crucial. Also, Florida Statute requires the Collier County Clerk of Courts to audit these documents to ensure legality of payment, which can increase the timeline for processing invoices.

“We had manual processes in place for receiving and processing invoices,” says Jane McDonald, Senior Project Manager for Collier County Clerk of Courts. “Workers used email and interoffice mail and didn’t always send the invoices to the AP department right away. We didn’t have visibility into an invoice’s status until it was approved and entered into SAP ERP at the very end of the process. Because our projects sometimes continue for months, workers often had to search through file cabinets (files are kept on site for two years) or warehouse archives to locate older invoices.”

The Clerk of Courts management information system (MIS) and AP organizations knew it was time to research new technology that would leverage the SAP workflow. A cross-functional team was assembled and began to evaluate how much work would be required to build and maintain a custom solution from scratch. At the same time, they also considered third-party vendors that might be able to provide an appropriate solution. Key capabilities the county identified include:

  • Ability to integrate the chosen technology with the organization’s current SAP environment
  • Digital storage of invoices
  • Easy extraction of information for auditors

Solution

The county’s vendor selection team chose Dolphin’s Process Tracking System for Accounts Payable (PTS-AP), which went live in August 2012. The project involved instituting a new accounts payable workflow aimed at centralizing the AP process countywide. Key feature are:

  • Automated invoice capture, with scan and capture
  • Powerful InfoCenter to facilitate invoice processing and troubleshooting by the AP staff
  • Automated workflows to route invoices to the appropriate department that, in turn, can route it for additional approval(s).
  • Improved exception handling for If an invoice is rejected during that process, it can be easily returned to the vendor with a rejection code along, with any backup documentation to explain why it could not be paid.

“All of these steps in the invoice approval process have a predefined status within the system’s workflow,” explains Frank Bodino, Senior Systems Analyst at Collier County Clerk of Courts. “In this new process, all of the steps are visible. We know where each invoice is at all times, we know who looked at it, what notes they put down, and when it was approved. If the invoice was rejected, we know why.”

After the invoice is approved, the goods receipt is matched, and the AP audit is performed, then the invoice can be posted to SAP ERP. “All the information we need to post the invoice is there, so there’s no dual-keying or duplication of data,” McDonald says. “We just hit the button, and the invoice information posts.”

Improving the AP business process required changes across the entire organization. For example, since invoices now come into the AP department as the first step of the new process, the various departments within county government had to adapt to a new workflow where AP clerks scan the invoices.

While the new workflow for invoice processing is much more streamlined and intuitive, it did require training users on the new system and getting their buy-in on the updated processes. “Just like with any training, some people caught on very quickly and others struggled with the new processes,” says McDonald. “The project team created training documents to help explain the process in a way users could understand.”

Results

According to McDonald, the new solution has delivered all of the benefits advertised and more.

  • Easy access to and cost effective storage of invoice documents
  • Simplified approvals process
  • Ability to track how many invoices are processed in a given period is helping the organization measure its own performance.
  • Improved visibility both internally and externally.

“Now, we can provide our external auditors with invoice information, purchase order (PO) information, and backup documentation more easily than we could with the paper-based system,” says McDonald. “In the past, we had to go back to the paper files and dig out the invoice which was time consuming. A significant time and cost savings benefit was our ability to search by check number or the clearing document and instantaneously receive the information associated with the invoice.”

The improved metrics have also pinpointed any delays in the AP process. For example, the new process showed that many invoices are rejected because vendors don’t provide PO numbers on their invoices. Without the PO number, AP clerks were forced to try and find out which department and what purchase generated the invoice. By requesting that vendors provide the PO number on their invoices, the AP process has been streamlined even further.

According to Bodino, the county has become more efficient thanks to the new solution. “We have been able to fix and change processes that, while they worked, were cumbersome at best,” he says.

Download_PDF