How Laserfiche Made a Difference in the Auditor’s Office

4 min read
  • Government
  • Accounting & Finance
  • Intelligent Data Capture

Contributed by: Inky Chandler-Mertz, Technical Trainer, Williamson County, TX

The Auditor’s Office at Williamson County, TX processes all of the accounts payable journal entries, accounts payable transactions and employee purchasing cards (p-cards) for both Williamson County and the Williamson County Community Supervision and Corrections Department (CSCD). Here is how Laserfiche Workflow, in conjunction with Laserfiche Quick Fields, streamlined the business processes in the Auditor’s Office.

Document capture

Each department at Williamson County submits its own purchase orders and receives its own invoices. The departments send these invoices and purchase orders to the Auditor’s Office. The Treasurer’s Office is responsible for cutting the check. A copy of this check is sent to the Auditor’s Office where it is attached to the supplemental documents such as invoices and scanned into Laserfiche with Laserfiche Quick Fields.

The Auditor’s Office created eight different Quick Fields sessions, each one corresponding to a different type of document:

  • ACH payments
  • CSCD checks
  • CSCD p-cards
  • CSCD wire transfers
  • Accounts payable journal entries
  • Williamson County checks
  • Williamson County p-cards
  • Williamson County wire transfers

Every document is separated by a coversheet with a barcode, which is removed during Storage Processing.

Williamson Document Capture

Here is a screenshot of the Quick Fields session that processes Williamson County p-cards.

Quick Fields Session
Click image to view larger in new window.

A Zone OCR process is used to extract the last eight digits of the credit card from the document. The Pattern Matching process extracts the relevant digits from the credit card number to create the p-card ID. This is how the Auditor’s Office configured this Pattern Matching process.

Williamson County P-Cards

Here is a screenshot of the Quick Fields session that processes Williamson County checks.

Williamson County Checks
Click image to view larger in new window.

In this session, the Zone OCR process is used to extract the transaction number. The Lookup process uses this number to extract related information from the Oracle accounting database. This information is used to populate the associated document template. This is how the Auditor’s Office configured the Lookup process.

Lookup Process

Document processing

Once documents are scanned with Laserfiche Quick Fields, they are picked up by Laserfiche Workflow. The Auditor’s Office has one main workflow, which—based on the template assigned to a document—invokes one of three other workflows.

Document Processing

If the document is a check, ACH payment or wire transfer, it gets processed by the “Auditor – AP Transactions” workflow.

“Auditor – AP Transactions” Workflow
Click image to view larger in new window.

This workflow:

  • Extracts the transaction number from the document template and converts it into a token.
  • Queries the Oracle accounting database to fill in the remaining template fields such as check date, entity, fund, transaction type, vendor name and vendor number based on the transaction number.
  • Uses the “Pattern Matching” activity to extract the year and month from the check date.
  • Uses the “Date Token Calculator” activity to calculate the previous and next years based on the current year.
  • Renames the entry to follow a uniform naming convention.
  • Routes the document to either the “General Transactions” or “Projects and Grants” folders based on the value of the “Fund” field.

Here is a screenshot of the “General Transactions” folder structure.

General Transactions” Folder

If the document is a p-card, it is processed by the “Auditor – P – Cards” workflow. This workflow works in a similar fashion to the one processing AP transactions.

Ap Transactions Workflow

The workflow processing AP journal entries works slightly differently. Since the CSCD has a different fiscal year from the rest of Williamson County, multiple “Route Entry to Folder” activities are used to distinguish the CSCD entries from the other entries to save them in different fiscal year folders. Here is what this workflow looks like:

Williamson Workflow
Click image to view larger in new window.

All of the documents processed by the Auditor’s Office are stored in records management folders with retention automatically applied. Checks need to be saved for 10 years while projects and grants are stored permanently.

Next steps

Williamson County plans on completely automating the invoice intake process to enable departments to scan in their own invoices directly without having to send them to the Auditor’s Office first. This is the first step in making the whole accounts payable process completely paperless.

Watch a 2-Minute Demo

Discover how your organization can go paperless, manage digital content, automate day-to-day processes and more.

WATCH A DEMO

Take a Product Tour

Enable the teams closest to your business processes to evolve and transform how your organization gets things done.

PRODUCT TOUR

Related Blogs

Can Generative AI and Content Services Increase Productivity and Transform Processes? Here’s How We’re Thinking About It.
Don’t Get Fined: SEC Rule 17a-4 Updates You Should Know About
Laserfiche Industry Experts Weigh in: Predictions for 2023
302? 404? Everything You Need to Know About Sarbanes-Oxley
Women in Tech | Life at Laserfiche Video

Book a Personalized Laserfiche Consultation Today

Privacy(Required)
Email Consent