Audits find flaws in Palo Alto's purchasing policies

City Auditor finds duplicate invoices, inaccurate vendor records

As Palo Alto heads into what promises to be a challenging budget season, a new review from the Office of the City Auditor has found that the city may have spent about $800,000 on duplicate invoices between 2013 and 2015.

While much of the money had been subsequently recovered, the audit faults the city for lacking effective procedures to identify duplicate payments and recommends that the Administrative Services Department remove from its database thousands of vendors that are no longer used or that had provided erroneous information.

The audit relied on sampling and data analytics to determine the number of potential duplicate payments between July 2013 and 2015. After identifying several duplicate samples, the auditors used random sampling to get a more precise estimate of how frequent these are.

The data-analytics methods pointed to 295 potential duplicate payments during that period. The review also confirmed that the city paid duplicate invoices, totaling $57,000, for 23 of the 133 invoice groups that the audit had randomly selected. One of these groups also included two duplicate payments, raising the overall number to 24.

The audit found that nearly 94 percent of the city's 43,642 active vendor records are "unused, duplicates, inconsistent, and/or incomplete, which increases the risk of duplicate, erroneous and fraudulent payments, as well as incorrectly reported tax information."

"The City does not currently have monitoring procedures to identify duplicate or unused vendor records or effective procedures to prevent their entry to inactivate them in SAP (the city's enterprise software)," the audit states.

The bulk of these records, nearly 36,000, had not been used since before 2012. Furthermore, a large percentage of vendor records contained erroneous or incomplete information. Two-thirds did not have a phone number, according to the audit, and more than half of the city's roughly 1,800 corporate and sole-proprietor vendors did not provide either a tax identification or a Social Security number. In many other cases, these numbers were inconsistently formatted (the Social Security number, for example, did not follow the 999-99-9999 format) and had irregular address information.

While the monetary loss from these deficiencies appears to be minimal because of the city's ability to recover the funds, the audit notes that incomplete and inaccurate vendor records "raise the risk of incurring IRS fines for inaccurate tax forms, inefficiency associated with potentially misrouted payments and maintenance of inconsistent vendor records, and duplicate payments due to undetected duplicate vendor records."

"Duplicate invoice payments result in both financial loss and operational inefficiency associated with recovery efforts," the report states.

The audit recommends that the city implement a "continuous monitoring process" to identify duplicate invoice payments in the new Enterprise Resources Planning (ERP) system; that it updates its invoice-processing policies to require unique invoice numbers and credit memorandums to correct invoice errors. And given the high number of unused vendors, the audit also recommends that the city conduct annual reviews of its vendor master file and update its policies to provide clear guidance about the information vendors are required to provide.

In a response memo to City Auditor Harriet Richardson, the city's Chief Financial Officer Lalo Perez noted that of the 24 duplicate payments that the auditor flagged, 17 were identified by staff and resolved before the audit. He also noted that the potential value of the duplicates, if confirmed, is about $4,977, or 0.004 percent of the average value of checks issued and charge card purchases per year.

Yet Perez also concurred with most of the report's recommendations and wrote in a response to the audit that the department will "update policies and procedures to provide information needed to create complete and accurate vendor master records."

The Administrative Services Department, he wrote, currently detects and recovers duplicate payments through "periodic accounts analysis, contract monitoring and notifications from vendors." Based on the auditor's recommendations, the department will develop and document an "internal control process" to identify duplicates for the new ERP system.

"While it may be ideal to have zero duplicate payments, staff believes that to be unrealistic given the extended time frame such a review would require and the need to process all payments within a timely turn-around," Perez wrote. "However, staff believes with a new configuration in the SAP system there will be an enhanced ability to flag possible duplicate payments and for staff to intervene before making a payment."

Green-purchase audit

The report on duplicate payments is one of two audits that Richardson released this week. The second audit looked specifically at Palo Alto's record on "green purchasing." Just like the audit on duplicate payments, it found plenty of room for improvement.

Most of the transgressions that the auditor had identified — a list that includes drinking water out of plastic bottles, loading printers with non-recycled paper and using a paper towel with insufficient post-consumer fiber — probably wouldn't be deemed sins against Mother Earth in other communities. But in Palo Alto, these actions run afoul of the Green Purchasing Policy that the city adopted in 2008, according to the audit.

While the policy doesn't prescribe which office products should be bought, it commits the city to incorporating its "environmental, economic and social stewardship criteria into its purchases of products and services." It called on the city manager and managers from key departments to create a plan that identifies eco-friendly products, considers amendments to the Municipal Code to implement green goals and engages all city staff to "identify sustainable products and services that are not purchased centrally."

But in reviewing the city's purchasing policies, Richardson's office discovered a lack of awareness throughout City Hall about the city's green-purchasing policies. Several departments, for example, "may have purchased drinking water in plastic bottles because they were not aware of the policy and reasons for not buying it." This despite a 2009 policy prohibiting purchase, distribution and sale of single-use plastic water containers.

The audit noted that several departments had purchased water in plastic bottles "for training and other events." After the audit flagged the issue, staff blocked the purchase of drinking water in plastic bottles on the Staples website.

Another area in which the city's ideals clash with its actions is paper purchases. The city has had a policy since 2003 of buying paper products consisting of at least 50 percent "secondary and post-consumer waste," provided it meets the city's requirements. Yet between July 1, 2014 and June 30, 2016, only 62,100 pounds — or 59 percent — of the city's paper product purchases from Staples had met this requirement. Furthermore, only about 19 percent of the paper purchases from other office-supply vendors met (or most likely met) this requirement, the audit found.

In addition, the audit found that the janitorial contract that applies to most facilities "did not always use green products or provide reports of bulk chemicals as required by the contract, nor did the City monitor the products to ensure they were green."

In his response, City Manager James Keene agreed with the report's findings and laid out a range of actions staff plans to take to address the auditor's recommendations for better compliance with green-purchase policies. These include forming a stakeholder committee to recommend green-purchasing performance measurements, educating staff on green-purchasing policies on an ongoing basis and consulting with the City Attorney's Office to consider possible revisions to the Municipal Code.


Follow the Palo Alto Weekly/Palo Alto Online on Twitter @PaloAltoWeekly and Facebook for breaking news, local events, photos, videos and more.


8 people like this
Posted by senor blogger
a resident of Palo Verde
on Apr 21, 2017 at 11:06 am

So where did the $800,000.00 number come from????

12 people like this
Posted by citizen
a resident of Duveneck/St. Francis
on Apr 21, 2017 at 11:15 am

Some accountability please. Go over every single invoice especially the big ticket items instead of sampling. Take responsibility like this is your business. What good is paying high compensation to employ people doing lousy job. The person overseeing payment should be fired over this negligence if not fixing right.

3 people like this
Posted by Linda Craig
a resident of Menlo Park
on Apr 21, 2017 at 1:01 pm

Where is the copy of the audit posted? It would help to have the link before commenting.

3 people like this
Posted by Joe
a resident of Another Palo Alto neighborhood
on Apr 21, 2017 at 1:22 pm

Here's a link to the audit report:

Web Link

5 people like this
Posted by Terry
a resident of Midtown
on Apr 21, 2017 at 9:08 pm

Again, where does the $800,000 in the first paragraph come from? Click bate?

Think of all the businesses in Palo Alto, from small to large. How many do you think would tolerate duplicate invoice payments?

5 people like this
Posted by mattie
a resident of Crescent Park
on Apr 23, 2017 at 8:41 pm

How much are we spending on the auditor's office to tell us that someone bought plastic water bottles? THAT is the thing we should be auditing. I generally LOVE the independent audit function, but jeez these two results sure seem like a waste of energy for all involved.

Anyone that's ever worked as a bookkeeper in a medium-sized bureaucracy can tell you that sometimes things get unpaid (invoice lost in mail) or double-paid (invoice reissued while I check was on its way) without any ado, because the money trails are well established and errors along the way self-correcting. 0.004% ... that one four-thousandth of a penny on the dollar!

Much more interesting audit would be whether we're getting good deals on the contracts, or whether the folks managing contract oversight are earning their keep.

7 people like this
Posted by more needed
a resident of Another Palo Alto neighborhood
on Apr 23, 2017 at 9:19 pm

@mattie is on the right track. There should be an audit of all contracts given by the City.

1 person likes this
Posted by resident
a resident of Charleston Meadows
on Apr 24, 2017 at 9:45 pm

Does the city use an automated bookkeeping / finance system that records all payments against all invoices? People have commercial systems at home which track every transaction which prevents duplicate payments and provides a clear record of the transactions categorized by budget category. It is inconceivable to me why this would occur if a up to date commercial system is used. Sorry this does not make any sense.

2 people like this
Posted by resident
a resident of Charleston Meadows
on Apr 25, 2017 at 7:56 am

The Alum Rock School District is under audit by an outside agency for the double payments to a contractor for construction work to upgrade the buildings that does not get done. This is taxpayer money down the drain. And in this case the construction company is located in Southern California versus a local construction company that can be held more accountable for the progression of scheduled work and completion of the jobs paid for. So what is going on in city government and city school districts? If the current batch of people who are in the bookkeeping business cannot do the job then time to get better people and a commercial program that lays out the budgets, income statements, and balance sheets by month to track what is going on. And some monitoring of the awarding of contracts for construction and consultants who seem to be flourishing for projects to enhance a cities profile that should actually be accomplished by the regular employees who are hired for those jobs.

Like this comment
Posted by resident
a resident of Charleston Meadows
on Apr 26, 2017 at 9:14 am

Note that the contractor for the Alum Rock audit issue is Del Torro Group based in City of Industry. However they do have offices in San Francisco.
Audit of Palo Alto and San Jose school districts should list who they are working with and dollar value. Del Torro has lengthy list of complaints and law suits. The group focuses on school districts that have construction work financed by school bonds. I will move this file from Education to Gangs.

Sorry, but further commenting on this topic has been closed.

Greek restaurant Taverna opening in Palo Alto
By Elena Kadvany | 1 comment | 7,936 views

Food Party! 420
By Laura Stec | 0 comments | 1,038 views

Expanding the taxation of online sales
By Steve Levy | 7 comments | 874 views

Reader Guest Post: Life's Map
By Aldis Petriceks | 2 comments | 808 views

Couples: . . . “Joy is greater than sorrow,“ . . . “Nay, sorrow is the greater.”
By Chandrama Anderson | 1 comment | 629 views


2018 guide to summer camps

Looking for something for the kids to do this summer, learn something new and have fun? The 2018 Summer Camp Guide features local camps for all ages and interests.

Find Camps Here