0:08The time is now 101 p.m.
0:11on September 2nd, 2025, and the meeting of the audit committee is now called to order.
0:16Madam Clerk, can you call the roll?
0:18Councilmember Mesa Gonzalez.
0:27Chair, we have quorum.
0:30First item on the agenda is approval of the minutes.
0:33Are there any corrections to the minutes?
0:38Can I get a motion and a second to approve the minutes?
0:43I got a motion and a second.
0:46All in favor say aye.
0:53Madam Clerk, are there any members of the public signed up to speak?
0:57We have no members of the public signed up to speak.
1:01There are four final internal audit reports on the consent agenda agenda.
1:07Do any members wish to pull an item on consent for discussion?
1:12Yes, uh Chair, I'd like to pull item three.
1:14All right, item three.
1:18Okay, so we will approve uh motion for which the remainder of the remainder of the consent agenda, except that except item three.
1:35I have a motion and a second.
1:36All in favor say aye.
1:40So we'll start with the individual item.
1:43Uh did you want to just ask some questions?
1:49Uh this is the Greater SATX audit.
1:53And um I have some, I think significant concerns.
1:59Uh, you know, the first line here in the summary is that EDD's service agreement with Greater SATX is appropriately monitored.
2:07Um, but then if you read further into the audit uh into the audit, I'm not sure how that statement can really uh be made because uh it says here that our ED, our economic development department cannot sufficiently validate greater SATX performance metrics because Greater SATX does not provide sufficient support documentation for validation.
2:35And so my concern here is we are giving a significant amount of funding to Greater SATX.
2:46I believe in the mission of Greater SATX, it does a lot of good things, but we need to make sure that just like with every organization that we give money to that we are getting uh the bang for our buck, if you will.
3:01And so I don't know who's here to to perhaps answer questions on what we are going to do uh differently moving forward.
3:09And in I guess my first specific area where I guess the or that that we need to address is that it looks like one of the reasons we're saying we don't have the appropriate documentation uh chair is that these uh these businesses that Greater SATX is is is counting as wins, these these deals a lot of them are what they're they're calling non-incentive businesses, and these folks don't have I guess documentation requirements that they have to give us, and so we can't really determine you know if if our service agreement is is being um if we're getting I guess what we've bargained for.
3:56So what are we doing there?
3:58Uh and thank you for that.
3:59Um Brenda, is anyone from Greater SATX here today?
4:05Um yes, uh one of their team members just walked in the door, ma'am.
4:11Um I am because we have a new uh board uh committee member.
4:19I am thinking that if we had a motion to take this up next month that we we could have them that we could have you present um next month, and then that way more of the greater team, because I know they just went through a leadership change too, so I don't want to put them in a position where they can't, and then that way uh Trisha can kind of uh get some more information on this also and um get briefed by you, buddy, if you haven't uh briefed Trisha yet, if you could brief her on this issue.
4:53Can I get a motion to move this to uh next audit committee meeting?
5:00next month and then that way more of the greater team because I know they just went through a leadership change too so I don't want to put them in a position where they can't and then that way uh Trisha can kind of uh get some more information on this also and um get briefed by you buddy if you haven't uh briefed Trisha yet if you could brief her on this issue is it can I get a motion to move this to uh next audit committee meeting yeah motion made I've got a motion do I have a second all right all those in favor say aye aye aye okay so uh item the I the audit item on greater sat will be moved to the next audit committee meeting and buddy you have your directions on uh briefing with our new uh trust uh committee member and hopefully our we'll get a second community representative and they can be briefed also and then greater SATX thank you for coming in today but let your team know we we expect you to be here to answer questions next month all right now we're going on to our individual items that's item six is audit of the finance P Card program can we get a staff presentation hello oh sorry just checking for good afternoon my name is Abigail Esteves I was the audit manager for this project and I'll be presenting the results over the finance P Card program audit overall our objective was to determine if the P Card program was managed in accordance with the department's policies and procedures we determined that finance had adequate controls to provision P Card program participants.
6:18This included both providing participants uh the initial required training as well as having their credit limits authorized by the appropriate individuals they also had adequate controls to ensure accurate payment is made to Chase Bank on a monthly basis.
6:33However we did identify um opportunities for improvement as it pertained to policies and procedures transaction monitoring and analysis and P card controls.
6:45Our first recommendation was over policies and procedures we determined that the P card user guide was outdated so we recommended that the guide be revised and periodically updated as needed our next recommendation was over transaction monitoring we selected a sample of transactions and identified a few that were either not approved either in the Chase bank system or as part of the transaction logs which were required at the time or um were not appropriately supported by itemized receipts.
7:17For this next item we had a recommendation over transaction analysis to provide some context regarding the work we performed here we performed data analytics over a data set it was um at the time eight months worth of data which was approximately 2000 transactions and we performed various data analytics to try to identify potential anomalous activity and three of the potential items that we identified were potentially restricted purchases for the subsect we performed keyword searches to see if any potentially restricted purchases were identified.
7:52We also identified the opportunity for use of contracts this was based on an analysis both within and across departments to determine whether there were purchases in excess of 3,000 with the same merchants.
8:08And lastly we determined that there were credits limits that were significantly higher than average spending for certain card holders so they're recommending that finance review these results as well as develop controls moving forward to identify potential issues such as these recommendation was over P card controls we identified a blocked merchant category code being used without approval additionally we determined that access to both P cards and system access was not adequately monitored monitored or delimited timely and this was specific to employees that had since been separated and no longer required access to either the system or an active P card but to clarify there were no purchases made on those P cards finance agreed with our recommendations and developed corrective action plans with a tentative completion date of June 2025 and we're currently working with finance to confirm implementation.
9:13That concludes my presentation but both myself and finance are available to answer any questions you may have all right before we discuss can I get a motion in a second motion I've got a motion in a second I'll entertain uh discussion does anyone have any questions Councilman White Thank you Chair so Buddy when we do these executive summaries right it's they they always it seems to me start with everything's being adequately done and then it goes into but you know here's all the list is another one where I'm not sure how we can say that this P Card program is being adequately monitored.
10:02And when when you when you when you look through this report, I mean let's let's start with the some, you know, these transactions having supporting documentation, right?
10:1245%, almost half, no support didn't have the the requisites uh supporting documentation.
10:20We look at the transaction reports, right?
10:22You guys looked at three months of of uh unapproved transaction reports and found that 502 out of the 1135, 44 percent again remained unapproved uh for for three or more months.
10:39I mean, you you you keep going and you look at you look at the uh the issues here, and I think there was a summary play page here uh somewhere somewhere.
10:51Um you got sixteen hundred and forty-four questionable transactions plus hundreds uh exceeding the three thousand dollars that should have been under under contract.
11:03You have a hundred and twenty-three uh cardholders that had limits significantly above their actual spending, and then maybe most concerningly to me, you have employees that are no longer working with the city of San Antonio whose cards, if I'm reading this right, remained remained active.
11:28Um they they still had system access for 99, an average of 99 days, with seven still holding active cards.
11:42I mean, again, this is taxpayer money.
11:48Um they trust us to spend it appropriately, they trust us to monitor uh how the money is being spent, not just by the external groups that we give money to that we talk about all the time, but certainly um our own employees as well.
12:09And so I guess um all that is to say moving forward, we've got a plan to rectify this, right?
12:18How many of you have council member?
12:19Let me speak to your your initial question.
12:23The way we answer our objectives, and I'm gonna use extremes to illustrate, uh, is it's either going to be a no.
12:31So if you look at the if you look at the objective, it says determined if P Gar program is managed in compliance with policies and procedures.
12:39I'm gonna use uh because I can use it, it's been published.
12:42So I'll use the NHSD home rehab audit.
12:45That was a a no overall.
12:49So overall, the entire process is a no.
12:51So we have three options when we answer our objective.
12:54We answer it as a no that the program is not, in this case, that the program is not effective or adequately monitored.
13:01Then we have the affirmative, obviously, right?
13:04Um if the majority of the items are being executed as intended, and you have issues, i.e.
13:09what we're gonna discuss next month, um, from a greater SA Texas from a compliance monitoring perspective, overall they're monitoring components of the contract, with the exception of performance matrix.
13:24So we're not gonna give them a conclusion that overall they're not monitoring, because overall they're monitoring effectively, because there's a component that they're not monitoring, which is a performance metrics.
13:35Then you have the ones that fall in between.
13:37This is a specific example of audits that fall in between.
13:41What we typically do is we give the conclusion on the affirmative first, that's with the first paragraph, and then the items that need improvement.
13:50The reason we categorize this as needed improvement is one from a volume perspective, we're talking about thousands and thousands and thousands of transactions.
14:00We don't take in consideration materiality the way an external auditor would, because we're program procedural related in terms of testing.
14:13Secondly, is some of these are anomalies that we didn't confirm.
14:18So they're potential uh areas, and what we're our our direction is we took a sample of the anomalies and confirmed that X amount were probably uh uh shouldn't have been executed.
14:31Well, we're telling Troy's team to go re research the remainder to see if you can confirm if that's a condition that currently exists with the remainder of those transactions.
14:41We're not necessarily necessarily saying each one of those transactions should have not taken place.
14:47So I just wanted to give context behind our results.
14:51But but that your first initial uh question, and and I'm expanding simply because we had new committee members.
14:57Um you'll see audits, and I use NHSD an example, which overall it's a no.
15:02Then you'll see audits that overall it's a yes.
15:05And then that's why you don't see us answering the direct objective directly directively, because we have two components here, what they're doing well, what they're not doing well, and we're also taking consideration the volume of purchases.
15:19So just to give you some context, and then I believe Troy can speak to the and just if I can just just ask a uh clarifying question.
15:27So you you guys are not auditing the efficacy of the program.
15:32It's just whether or not they're they're following the procedures.
15:40In this case, yes, you there's there's controls in place and there's procedures that they should be following, i.e.
15:47the results of the audit, and we're looking at it from a control procedure perspective when it comes to approvals, procedures, and then uh the one you mentioned from an access perspective.
15:58We have uh we have employees that that still have that card.
16:03We we take we take the next step and we take a look to see if there was any purchases on those cards that those uh employees that still have cards to see if there's any purchase activity, and there was not.
16:16So um the control there is a user access control.
16:20There's a there's a tail to this test because potentially somebody can make a purchase because now they have a card.
16:26So and just just the la last follow-up point is that so I'm always talking about wasteful spending.
16:34You your audit wouldn't necessarily tell us if money was being spent wastefully, but just rather whether internally we're following proper procedures and correct.
16:50And councilman, just to add to your last question.
16:52I think your last question was is there a plan in place?
16:55Yes, sir, there's a plan in place.
16:57When we look at this, and to Buddy's point, this is looking at controls, just kind of put in context.
17:02There's 26,000 transactions that run through this program in less than a year.
17:07Of that, Buddy, and we're appreciative of what he pointed out because he did point out some deficiencies, and we're grateful for that.
17:14And we went back and Melanie Keaton, our deputy finance director and her team went back and went through every transact transaction that they identified and looked at it from the perspective.
17:24You know, I think the reference there they're unrelowed.
17:27Well, we went back and there's some reasons they were unallowed from a systems perspective, because we were in the process of converting from Wells Fargo to Chase, which is a new system.
17:37There were some limitations in the old system that we had put things in place.
17:40This new system actually gives us some opportunities to actually build some additional controls in to make sure one that they're approved and they're allowed.
17:47Um we had some duplicate things in place under the old system that we can do away with now.
17:52When we went through all the transactions, we did not see anything that gave us concern or pause as far as what was being purchased.
17:59Um the last issue I think I'll say is that we talked about the um the issue on the card holders that were not terminated.
18:07We did go back and look at that.
18:08We had a process in place that wasn't working.
18:11We strengthened that process.
18:13Now, whenever there is a termination through our payroll or through our HR process, they're gonna notify us proactively so we can discontinue their participation in the program.
18:23So we we've taken a look at it, look at it, we've strengthened it across the board, and we actually have a new procurement guide.
18:29It is, I'll be transparent.
18:30It is a little bit late.
18:31We're supposed to come out the end of June 30th.
18:33We lost three of our individuals that were actually administering the program, but that will be coming out this week, and it's the program guide has actually been modified to actually strengthen some of our processes and our controls.
18:44So there is a plan in place.
18:46Um, and this is a program then working with Buddy and Abigail that we want some frequency on looking at it because it is a high volume and high potential for um high risk area.
18:57So hopefully we'll be coming back with the auditor's office more frequently on this type of program.
19:03And I appreciate that, and and I don't I don't want to I don't want to belabor the point, but um it should, it seems to me be easier to monitor ourselves internally uh than it is to monitor some of these out outside groups.
19:22Um we need to do both, certainly.
19:26Uh and so, you know, but I'm happy that we're taking steps to to try to rectify some of this because when it comes to public perception, I mean this is the this is the kind of thing that just it doesn't look right.
19:43And I think Ben, you want to speak a little.
19:45This is well, Troy and and your uh kind of department, and I know P Cards I you know you there might be wasteful spending at City Count at City Hall.
19:57I don't know, because I know our uh our teams have access to that.
20:01But Ben, you want to share a little on the procedures and how we're moving forward on that.
20:07I'll just add a couple of comments.
20:08I think Troy covered it well.
20:09Appreciate your comments, Councilman.
20:11Certainly something we want to be very vigilant of.
20:14Um as Troy mentioned, the program is really meant to take away some of the bureaucracy and burdensome processes of doing small dollar purchases.
20:22So as Troy mentioned, you know, for the year that Buddy was looking at, we're talking about 7.3 million dollars, 26,000 transactions.
20:31So we're talking about less than 300 on average.
20:34Um the things that Buddy noted and kind of went through are I think some transitional stuff that occurred between us moving from the uh Wells Fargo platform over to the Chase platform.
20:47You know, there's certainly some technology things that we need to use the system to track better and allow us to catch things a little bit quicker.
20:54But I did want to note for you that in the management response, so buddy mentioned the 1600 and what was it, 44 potentially unallowed transactions.
21:04Troy had finance to go back and look at every one of them to make sure there was not an issue, wasteful spending, something else going on.
21:11Found the documentation, cleared most of them, all of them, didn't find any what I would call disallowed costs, but still concerning that those things were there, and that you know, again, we want Buddy to come in and navigate to come in and say, Hey, can I see these things?
21:26We want that to be a five-minute process.
21:28Here are these things, we're cleared, we're done.
21:30Um that didn't happen in this case, so we've got some work to do and some improvement to do.
21:35But I think there are transitional things that occurred.
21:38There's certainly things that we can do better.
21:40We can certainly take advantage of the platform that we now have fully implemented and is in place.
21:46So I think a lot of the issues that we talked about here we can address and and shouldn't have these issues going forward.
21:53So and I and I I don't know, buddy, if this isn't on your follow-up plan, but we want to follow up.
21:57This is one we want on our kind of a regular basis because it's just a lot of volume and it's a lot of transactions, a lot of different kinds of transactions.
22:06There's some efficiencies that come out of it too.
22:08He mentioned a couple of things in here, and I lost the page.
22:12Um that talked about um some of these things could be on annual contracts.
22:18Well, we can potentially get a better price.
22:20We want to do that too.
22:21So there's a lot of value in the data analysis, really looking at that.
22:26It changes, so we want to be monitoring in that, looking at that, so that we can implement and follow that and making sure we're we're going getting the best price we can for items as well.
22:35So there are a number of things that came out of it that we'll follow up on.
22:38Ben, just to touch, we are this is we follow up on each one of our audits, but this is a cycle audit.
22:44So this is one that we consider repeating every three to five years.
22:47Uh, but we will follow up on each one of the recommendations, and then it it is in our cycle uh audits uh to complete every depending on the severity every three to five years.
22:59I think on this one, uh sorry, Cheryl, on this one bit and buddy, maybe there's a consideration to move it up a little bit sooner.
23:04And we had a few issues.
23:05I know it's like on a three or four-year cycle.
23:08Uh I'd be happy if Buddy comes back next year and says, hey, I want to make sure all this stuff is is implemented and that we're taking advantage of the technology where we can great.
23:18Councilman uh uh Messagonzales.
23:29Are there specific departments that I guess more departments and others that were using this or of the of the 26,000?
23:37Was it coming from any specific no councilman?
23:41I think this is kind of a citywide.
23:43It's all over the place, all across the board.
23:44Okay, so it's really meant to be a process again that that takes a lot of small dollar purchases and doesn't have us go through the formal formal process.
23:52So um still have controls in place, so want to make sure we're tracking it, but it's available to all departments to use.
23:58Yeah, um, so there wasn't any one particular area that I saw that was that was a specific issue.
24:03No, and the only thing I would add to that is just to give you some more context, is about today there's a little over 400 of these cards are out across the city wide.
24:11But it's not really there are some departments going to be higher volume users than other, but this is not something that was isolated of one department and other is across the board.
24:23All right, thank you.
24:24We've got a mo uh any other questions.
24:28We've got a motion and a second.
24:30All those in favor, uh say aye.
24:38We're on to item seven.
24:40Uh this is a this is for briefing only, but because this is the audit committee that we are going into 2026 with.
24:48I wanted to make sure that you all were briefed on this item before we started with our regular meetings, uh, which Debbie will send out and we will have the time.
25:00So uh Buddy, go ahead and present.
25:03All righty, uh for those uh new folks.
25:05My name is Buddy Vargas, I'm the city auditor.
25:08Uh again, uh great to be back.
25:10Uh welcome to the new folks.
25:12I'm gonna be presenting the proposed 26 uh annual audit plan.
25:16Buddy, before are you gonna need us to accept this or this is just it's a briefing.
25:21It the actual approval is uh the plan is to have it on the A session October 9th for council approval.
25:28All right, well, so I'm sorry, we will need to.
25:30I will need a motion in a second after this to send it forward to an A session.
25:36Uh again, our audit plan is uh required to be presented to the audit committee and also council.
25:41Right now, tentatively it's uh scheduled.
25:44Our goal is to schedule it on the October 9th uh council meeting.
25:49Uh to touch base on just uh some background on our methodology, we uh solicit input from management from mayor and council.
25:56Uh we also do a high-level risk assessment uh to prioritize audits.
26:01Uh we start anywhere between 80-ish audits on a potential plan, uh and we take a uh a high-level risk approach to uh whittle that down to a manageable number.
26:13Uh our plan can be modified throughout the year.
26:16There's significant changes, risk change, controls, procedures change, and we uh modify appropriately.
26:23I wanted to touch base on four of those uh that were on the 25 plan that are modified.
26:28We have two that uh are were postponed that rolled over to 26.
26:33Uh one of them is the uh aviation um parking operations audit.
26:37We started that audit.
26:39There were some significant uh opportunities with the vendor that aviation got involved with.
26:44Also uh Troy's team was also involved.
26:46Uh they made some significant process and procedural changes, so we decided to let that uh those uh modifications run for a while, and we added it to the 26 plan.
26:58Uh same uh methodology for the SAP upgrade.
27:02There were ours allocated in 25.
27:04However, the first phase just got implemented last month in July.
27:08So we're gonna let that process run, and we put that on the 26 plan.
27:12A couple of audits that did not make it uh for consideration to 26, two that were considered for rollovers was the CCDO parking operations.
27:22Uh, but during the year we learned that there's an RFP uh probably mid-late spring, and it really doesn't make sense for us to audit that when uh it may be outsourced.
27:33So we're gonna take a look at that at probably 27-28.
27:36Uh the last one is the LGC audit.
27:39That's uh from a risk standpoint, considering our our uh budget shortfall, that was probably one of the priorities we actually focused on for what gets included for 26.
27:53Very low risk, uh very small in scope.
27:56So we rolled that over to 26, but even during our risk assessment process, it didn't make the 26 plan.
28:04Uh just an overview, what our audit include our plan includes is 32 performance audits.
28:10We have three consulting projects, uh we have special project requests.
28:15We have some hours that are reserved throughout the year again to either add our uh audits or adjust audits where needed.
28:21Uh we have follow-up work, we have audits uh that we have to follow up on, so we have hours allocated for that, and then we also have hours for our data analysis function that we do uh throughout the year.
28:33Um the one thing I wanted to mention again is we started with around 80 audits.
28:37Our priority for 2026 was to add as much value as possible for 26 and to try to impact hopefully 27 from a revenue and expenditure perspective because of our budget shortfall, uh, the economic uh position that we're in right now.
28:54So you'll see that the majority of our audits, a good chunk of them approximately 10 uh have a significant revenue component.
29:03Uh we do have a couple that are related to safety uh from a uh uh because of the recent flooding that happened here in San Antonio, so you'll see that.
29:12Uh there's a new homeless service department, so you'll see a couple of homeless um audits that are on the plan.
29:18Uh and really just want to kind of highlight that again.
29:21We start with around 80 and then we whittle it down to a manageable number.
29:26Um, and again, we we uh take a uh a risk-based approach.
29:30So to give you uh just a quick example, if it was a compliance-based audit uh versus a revenue or expenditure component, it probably didn't make the 26 plan.
29:43And that's actually my presentation list.
29:45Anybody wants to discuss the anything on the plan or the plan in general?
29:56All right, thank you, buddy.
30:00approach so so to give you uh just a a quick example if it was a compliance based audit uh versus a revenue or expenditure component it probably didn't make the 26 plan and that's actually my presentation list anybody wants to discuss the anything on the plan um or the plan in general all right thank you Betty so we have if you look on your slideshow there is 30 eight three consulting projects and then the 35 uh 35 including um the ones I think I think the one we're uh what I'm happy to see on there or what is our um is our workforce our workforce development regarding project quest and of course the uh homeless service and strategies as we move make the move to the new um the new department currently uh just to touch on that council member we are right now in there and ready to work but we're looking at the ready to work as a whole okay and it's a uh these are cycle audits we'll take a deep dive uh with a particular vendor particular contract so that's why that made it to 2026 now I think this looks good with the input of the council I I feel like this looks good uh do any of my committee members have any questions uh count Councilman uh Mesconzals yeah I was just wondering if you could maybe add a call on that kind of I guess maybe last time it was an audit took place in that department or if this is I I can definitely do that I can probably add that to the next audit committee as an informational item if you like uh I have it with me but it's not something I added to the presentation because this was a very short meeting I guess just when you take it to a session right we would have to take this yes and maybe you can include just a so I have I have uh we have a matrix that has every department that's been audited for the seven years over seven years yeah I guess of these 38 oh okay yeah these 38 that were this is a plan for this next fiscal year right exactly right so just when the last audit was done now some of them are are our new audit so yeah they wouldn't be honored okay yeah we can definitely add that okay thanks councilman white yeah I just want to say thanks for your work um this is important stuff always but especially now when we're in a in a place of of budget deficits and money being very very uh tight around here it's it's extremely important that we know that we're spending the taxpayers money appropriately and uh I hope that through your work we will uh um you know nothing's gonna be perfect so we're gonna find areas where we can do better and we owe it to the citizens to do that thanks thank you any other questions all right uh I think the one thing is uh making sure we have that um that third column that lets us know the last time that department was audited if it's a new department with a new uh audit or a new feature because some of them look like new um products that we may have purchased uh so this might be new if you could include that so that when we get um when the council gets it they'll and they'll see that on there uh so all I need is a motion and a second to take this to um a session on uh September ninth October night October 9th second okay we have a motion and a second all in favor say aye aye any opposed I have it motion carries um there being no further discussion we have a motion a second all in favor the time is now 135 p.m and the meeting is now adjourned thank you