Central Virginia
Albemarle County
Audit Committee Meeting 11/25/2024
Auto-scroll
Audit Committee Meeting
11/25/2024
Attachments
Agenda.pdf
Jim Andrews
Member, Audit Committee
00:00:01
All right, good morning, everyone.
Jacob Sumner
Chair, Audit Committee
00:00:02
We'll go ahead and it's 11 o'clock on November 25th.
00:00:06
We'll go ahead and have all the audit committee meetings ordered.
00:00:10
My name is Jacob Sumner, Chief Financial Officer for the county.
00:00:13
And we'll start off with our roll call.
00:00:18
From the schools, school member Ellen Osborne.
00:00:22
Yes, hi.
00:00:25
Chief Operating Officer Rosalyn Smith.
00:00:30
including the Board of Supervisors, Ned Gallaway, also representing the Board of Supervisors, Jim Andrews, County Executive's Office, Jeff Richardson, and myself, Jacob Sumner, Chief Financial Officer.
00:00:50
All right, so today on our agenda and including the packet in front of you all, we'll be talking about three different items.
00:00:57
We have Megan and Addison from Brown & Edwards to go over our audit results, about 24 audit results.
00:01:04
And then we have Shenandra Usher, our Chief Financial Officer, who's gonna give us an update on our upcoming new financial system project that will be going live later this fiscal year.
00:01:16
And then lastly, we have Laura Andrake, our chief enterprise risk management and shared services who will be giving us our regular update on the fraud, waste, and abuse program.
00:01:28
So with that, we'll go ahead and get started.
00:01:32
Megan, I'll turn it over to you to walk us through the 24 audit results.
Megan Argenbright
Partner
00:01:39
Hello, I'm Megan Argenbright.
00:01:41
I'm a partner at Brown Edwards.
00:01:42
Addison Roeschley is a senior associate and he's gonna talk about the real important stuff.
00:01:52
And I'm gonna go over just kind of an overview of what we do have for you today and what we don't have for you.
00:01:58
So thanks for having us.
00:02:01
And thanks, I will say, you know, this is our second year doing the audit.
00:02:06
And so we first came out in June and the deadline is December 15th
00:02:12
Sunday, so December 16th.
00:02:15
And our plan, we will be done on time.
00:02:19
I'm very confident that we will be done on time.
00:02:21
But what we do not have for you today is a draft of the ACFR.
00:02:25
And so the numbers part of this, I'm not going to be going over.
00:02:30
But however, you guys kind of know the numbers part.
00:02:32
So I feel like the important part is how did the audit go?
00:02:35
What findings did we have?
00:02:37
What federal compliance did we test?
00:02:38
That sort of stuff.
00:02:39
So that's what we're going to go over.
00:02:41
I will say that even though we don't have a draft of the act for you, it is prepared.
00:02:45
It's been through one review.
00:02:46
But it's not all of our review processes.
00:02:52
It has to go through a second review and then also a whole quality control footing 250 pages.
00:02:58
So it's a pretty involved process.
00:03:02
process.
00:03:02
However, we do know we can say with a good amount of confidence that we're going to be issuing a clean opinion, unmodified opinion and all the financials.
00:03:12
And then that is the opinion that you want.
00:03:14
And so when we're presenting to the full board of supervisors on December 11th, we should have a final version for them and be able to say with a lot of confidence on paper that it was an unmodified opinion.
00:03:27
What we are going to go over is mostly the yellow book and compliance testing and reporting that we are required to do.
00:03:37
These are drafts.
00:03:38
I made that very clear by putting a giant draft watermark on them.
00:03:43
But we wanted you to have a paper copy so that you could follow along as we went over things.
00:03:48
They have not, again, not been through our full quality control process, but have been reviewed.
00:03:53
And we've gone over these comments with the finance team, and also included management's responses.
00:04:01
Those are updated.
00:04:02
with their comments on these particular comments.
00:04:05
So at any point, you can interrupt us and ask any questions.
00:04:10
But with that, Addison, I'll start going over the letter itself.
Addison Roeschley
Senior Associate
00:04:12
Yeah, so the letter in front would be our yellow book letter or comments on government auditing standards.
00:04:22
The first page really covers the in relation to opinion or which financial statements we audited that kind of derived this page itself.
00:04:31
And then starting where it's report on internal control under financial reporting.
00:04:35
We don't actually dive into an audit of internal control itself.
00:04:40
We do kind of see a lot of those processes.
00:04:42
through reviewing financial statement balances, through going procedures that the APA has required of us to look at, but we don't actually design the audit to look at internal controls.
00:04:52
So it does kind of say there in one of the paragraphs that it's designed to notice some of the stuff, but not actually, we might not have seen everything.
00:05:00
And then starting with the very last paragraph on the bottom, it starts going over what we did see or kind of giving a little bit of forethought on what is to come.
00:05:09
So it does outline in that first part at the bottom in bold that we did see a material weakness.
00:05:15
I will jump into that in the future.
00:05:16
That's going to be with the schedule of findings and questions cost with everything you follow.
00:05:21
On the next page, there is another one.
00:05:23
That's going to be another comment relating to a significant efficiency.
00:05:27
Again, I will go over that as well.
00:05:30
and then a report on compliance and other matters, basically state procedures that are required of us to look at.
00:05:37
And in that instance, we didn't see anything this year for state commenting.
00:05:44
So that's great.
00:05:45
There will be a section for the county's response.
00:05:48
So we don't audit the county's response.
00:05:49
We do review them to kind of ensure that they're accurate.
00:05:53
But that is what management has wished to say or wished to respond to these comments for.
00:05:58
So then we have the summary of compliance matters.
00:06:01
This will kind of go over the Code of Virginia requirements that we do look at, that we do audit the procedures that are outlined by the APA.
00:06:08
and then there's federal compliance matters which come from the federal government and kind of guide our single audit over federal award programs.
00:06:19
So I'll speak to the next page.
00:06:22
This, again, is another summary for the outcomes of them.
00:06:24
It's going to specify that we did express an unmodified opinion on the financial statements or the cleanest opinion that we can give.
00:06:31
It is going to say that there is a significant deficiency in material weakness, again, just to summarize those back up.
00:06:37
No instances of non-compliance material to the financial statements, which is great.
00:06:42
Pretty clean there.
00:06:43
and then from that part down nothing federal related that we had any concerns over no audit findings over any major programs and then it's going to list the three programs we test these are kind of subject to the amount of revenues that are reported year to year but also we do have to test every program if it needs type-a thresholds of anything this year was anything over 926 dollars 926 thousand dollars makes it a type-a program
00:07:10
So some of those we do test once every three years regardless of whatever revenues are reported as long as they're over that threshold.
00:07:17
Kind of getting to where there might be more questions.
00:07:20
If you want to ask on any of these, feel free to do so.
00:07:24
The financial statement audit comments that we do have.
00:07:27
So we did see a material weakness in capital asset reporting.
00:07:31
A lot of times when we see stuff like this, it's related to audit adjustments that we're proposing with capital assets due to the larger nature of them.
00:07:40
They tend to immediately almost become more material.
00:07:43
So we did propose a couple audit adjustments relating to balances either for entries that weren't recorded to capitalize a balance or removals of items that might have been duplicated twice.
00:07:56
There was some turnover unfortunately in that role and so some of that might have been kind of leading to it but then also looking at balances for prior years where other items might have been not recorded.
00:08:07
And then also looking at construction and progress costs, we did see some instances there where we thought maybe there could be a little bit more clarity or accurate reporting of balances.
00:08:16
That's kind of what we saw.
00:08:17
There's condition criteria, cause-effect kind of recommendation.
00:08:23
And so we did kind of give those with management kind of in consideration of new eyes over what that process will look like.
00:08:32
And then lastly, the view of responsible schedules and planned corrective action, kind of how management feels to best address those issues that we didn't see.
Megan Argenbright
Partner
00:08:41
I will just say there's a lot of redundancy.
00:08:45
We are required.
00:08:46
This is not our wish to have criteria, condition, cause.
00:08:52
All of those things are required by the federal standards.
00:08:55
And so just know we weren't being redundant because we wanted to really get the point home.
00:09:00
It was because you have to have each of those attributes as part of the way you document a finding.
Addison Roeschley
Senior Associate
00:09:07
It is unfortunate.
00:09:08
I would prefer if it could be about one paragraph.
Megan Argenbright
Partner
00:09:11
Yeah, we could have said this in a lot more convinced way if we didn't have to have each of those.
Addison Roeschley
Senior Associate
00:09:20
So if you do have any questions, I'll be happy to answer them.
00:09:22
I can jump for you.
Ned Gallaway
Member, Audit Committee
00:09:25
It's for understanding.
00:09:26
So on 172, under criteria, you state with substantial impacts.
00:09:32
I'm just assuming that if we screw up and numbers are wrong, that's a substantial impact.
00:09:37
What other things fall under substantial impact?
Megan Argenbright
Partner
00:09:43
That would influence decision makers.
00:09:47
So knowing when things are like for capital assets in and of itself, knowing when things are placed in service, is a project done or not.
00:09:55
And if substantial can become if you don't place it in service, and it just sits, I'm trying not to talk with my
00:10:02
Countance, Lingo, but once you place something in service, you start depreciating it, right?
00:10:06
That's when you're using it.
00:10:08
You say, we'll have this for 10 years, 20 years, and you start using it.
00:10:11
If you don't do that, then you have a harder time knowing, okay, what kind of maintenance costs will I have?
00:10:17
How old are these, this equipment or these vehicles or this building?
00:10:21
What kind of maintenance do I have?
00:10:22
And then it could start impacting budgeting.
00:10:24
At the same time, or when do I need to replace this?
00:10:28
So not putting things in service could impact knowing when you need to have those capital costs going forward.
Addison Roeschley
Senior Associate
00:10:37
If I could add to that too.
00:10:38
Also another instance where we look at capital assets pretty heavily is when there is
00:10:42
New debt environments.
00:10:44
And that was certainly one this past year where there's new debt.
00:10:48
It's usually issued on behalf of specific capital projects.
00:10:51
So then we might look at specific projects more frequently, very similar to what a financial institution that's kind of overviewing those bonds might as well.
00:11:02
Anything else?
Jim Andrews
Member, Audit Committee
00:11:04
I'm trying to make sure I understand everything here.
00:11:07
The type A and type B you're saying
00:11:12
Yeah, so these three are type A.
Addison Roeschley
Senior Associate
00:11:17
The actual amount of $926,000 kind of fluctuates year to year based on actual reported revenues.
00:11:23
So there might be instances where we have to test the type B program, but it's not very frequent, especially given
00:11:29
the significant amount of revenues on very specific programs the county has so these are just the three that did meet the criteria of being over that amount and also either identified as high risk by OMB or hadn't been tested in the past two years and also it was the third year and it needed testing and uh fun facts uh if you guys are looking ahead
Megan Argenbright
Partner
00:11:52
OMB did change their threshold.
00:11:56
Right now, the threshold is actually $750,000 or a percent of your revenues, whichever really expenditures, whichever is higher.
00:12:06
So that's how you guys are getting to the 926, right?
00:12:09
Because you guys have far more federal funds than you don't have that minimum, but it's going up to a million in FY26.
00:12:20
The impact on the testing, hard to say, because they didn't change the rule that you have to test it every three years.
00:12:29
But it could, any grants that fall between that $750 and $1 million could come off that list and not have to be tested every three years.
00:12:38
So two years, well, two audits from now, we'll be able to maybe see some benefit of that.
Jim Andrews
Member, Audit Committee
00:12:46
And is there anything in the Capital Ads reporting
00:12:51
It wasn't tested last year, although it came out.
00:12:55
I mean, I'm trying to figure out how you discovered these weaknesses this year.
00:13:00
And then they arose.
Megan Argenbright
Partner
00:13:02
The best part about the compliance report is it covers all the things, right?
00:13:08
And it jumps back and forth.
00:13:09
So part A here, the summary of audit results, is pretty much all the things.
00:13:15
It has our financial statement audit, federal awards, and then state compliance.
00:13:20
And then part B is just about the financial statement audit.
00:13:24
So those items came up from procedures that we did on the financial statements themselves.
00:13:30
So we're still auditing all the numbers on the report we don't have for you today.
00:13:36
So that's where these came up was in our normal procedures of understanding controls and then also
00:13:43
just testing the items themselves so when we were looking at capital assets and and got the list of that that's where we saw these items and then the next part c is the federal compliance stuff which is you'll see there's no findings there so on the those three programs we tested we didn't have a final
Addison Roeschley
Senior Associate
00:14:04
And as it relates to kind of year-over-year procedures, we didn't change too much.
00:14:08
But as it relates to a difference in how we're reporting it, I will get to it.
00:14:12
But there is a part where we go over prior year comments as well and kind of what happened to them.
00:14:16
Were they resolved this year?
00:14:17
Did we see anything different?
00:14:18
We actually did have a comment last year, just some different things that we saw.
00:14:22
So I'll go over that.
00:14:23
But kind of when you look at something that's happening one or two years in a row is when we start maybe thinking there's a little bit more at hand there.
00:14:35
That's all.
00:14:35
I will go into the next one, revenue and expenditure recognition.
00:14:39
Again, there's quite a few paragraphs here.
00:14:41
I'll kind of gloss over them.
00:14:43
We did propose a couple of audit adjustments to record revenues and expenditures in the correct accounting period, or we didn't quite propose some base two on balances that we were seeing in testing.
00:14:53
Notably, most of them are surrounded in the grant process of just matching revenues to expenditures, both within the grant period, but also in the correct fiscal year that the audit covers.
00:15:05
So an award that I cover multiple years, you still have to have the revenues and expenditures in the same period.
00:15:11
And so that's kind of the meat and potatoes of what this comment was.
00:15:15
There were some other smaller transaction cycles where we did see that.
00:15:19
kind of stretching into capital assets and the timing of when those expenditures were actually recorded might impact when accounting goes in and records the capitalization of those assets.
00:15:30
So that's kind of the other thing that we didn't see there as well.
00:15:33
But most of it was, I would say, really around grant recognition and kind of the end of year true grips of that activity.
00:15:45
I'm happy to answer any questions on that or I can move forward as well.
Ned Gallaway
Member, Audit Committee
00:15:54
I will jump forward.
Addison Roeschley
Senior Associate
00:15:56
The next one is going to be major federal award program audit.
00:15:59
Pretty clean here.
00:16:00
There is nothing that we saw on the audit of the federal awards.
00:16:03
So not much to say about that one.
00:16:05
It was pretty clean.
00:16:06
That is with the three programs that we did test that were noted on that summary earlier.
00:16:11
And then lastly, findings for Commonwealth of Virginia or EPA procedures.
00:16:15
Again, nothing there.
00:16:16
So nothing to report on that one.
00:16:20
Then moving to the summary schedule prior audit findings.
00:16:23
There were a couple comments that we had in last year's act for and the attachments here that go with it.
00:16:29
So just a summary of it, we did see school grant reimbursements last year on a timeliness of some of their programs.
00:16:35
There have been some delays relating to implementation of new systems that were kind of extending when they could do their grant reimbursements.
00:16:43
So kind of under that current status there, we did note that the ones that we saw last year appeared to have improved and no longer applicable.
00:16:51
So that's a positive.
00:16:52
Kind of related to that earlier comment we did have though with revenue recognition.
00:16:58
We did see it in these specific grants, but it is possible that kind of because we saw it in one grant, we would say, well, maybe we could see it in another one.
00:17:05
So it could broadly define to this one, but nothing specific.
00:17:08
Getting to the capital asset reporting comment here, kind of as you were alluding to earlier, we did see some stuff relating to CIP expenditures last year that might have been missed.
00:17:17
So we did have a comment last year we had labeled it as a significant deficiency.
00:17:22
We kind of have three levels of what we can call a comment that we might see.
00:17:26
A controlled efficiency, which we usually don't include in this report, it's pretty minor, we just pass those comments to management.
00:17:31
a significant deficiency and then material weakness is really when we think that there's instances in place that or controls in place that aren't catching something or we see repeated activity where the controls haven't caught that that could really define what a material weakness is so last year we had it as a significant deficiency on that current year status comment we kind of bump it up to the material weakness and we recommend just reviewing the comments for the current year comment on capital assets
00:18:00
And then we had fiduciary fund reporting as well, which was a couple, it has the 84 requirements on funds that may not have been appropriately reported.
00:18:08
Last year we worked to get those all classified correctly.
00:18:11
So as such, that comment's no longer applicable.
00:18:16
And then we had nothing for federal award program audits last year, so that's great.
00:18:20
We did have two comments for Commonwealth of Virginia procedures outlined by the APA.
00:18:26
These can get pretty specific.
00:18:28
The APA kind of looks at some stuff a little more thoroughly than I would like, but because we're usually going through these processes, a lot of time they ask us as auditors to kind of tack these in with some stuff.
00:18:39
So last year, there was a comment relating to social services, where there is some information security policies that kind of has been maintained and updated appropriately.
00:18:50
We saw that last year, gave a comment on it.
00:18:52
This year, we went back to do the testing.
00:18:54
They had responded to that.
00:18:56
So as such, it's no longer applicable.
00:18:58
And then the annual school report comment would be the last one from last year.
00:19:02
We have to look at the annual school report submission that gets submitted to the Department of Education.
00:19:08
There's some things that they want us to verify over that.
00:19:12
Mostly the accuracy of revenues and expenditures that are submitted.
00:19:16
Last year it wasn't submitted by the time we concluded the audit, so we had a comment that it had not been submitted at the audit date.
00:19:22
This year it has since been submitted, so that comment would be no longer applicable.
Ned Gallaway
Member, Audit Committee
00:19:35
So on 172 under the capital asset report, the recommendation.
00:19:40
So this would have been launched.
00:19:41
Yes.
00:19:45
We recommend the opposite of counting the process with project managers to the CA prompt and accurate updates on projects to ensure they are placed in service.
Jim Andrews
Member, Audit Committee
00:19:54
So is this a breakdown from
Addison Roeschley
Senior Associate
00:19:59
So last year's comment was geared towards we saw projects in CIP that have been completed and not necessarily placed in service and so being accurate on the time that those are placed in service and depreciation expense begins on those projects.
00:20:20
Capital assets kind of hard from an accounting perspective when
00:20:23
A lot of what governmental accounting is geared towards is budget accuracy and ensuring that the board is appropriately responding to or approving the budget and results are accurately reported there with that as well.
00:20:39
So capital asset accounting kind of exists outside of that process and it's kind of a challenge for the accounting team because
00:20:46
They're receiving information only at the expenditure detail level.
00:20:50
And so those balances aren't necessarily given the same amount of controls in the same way that other transactions might be just when you make a payment or record an expenditure revenue when it comes in.
00:21:01
So our recommendation last year was if you can bridge that gap almost between accounting
00:21:05
and get them more involved with project managers or get them more involved with those who are going over the budget and looking at you know a five or six year trajectory on which plans are coming in or which new projects might be in service or you know planned for in the future that could be a positive.
00:21:22
another department that you could look at that would be treasury because they're kind of the ones that are going out and looking at debt management and which debt is going to be covering largely capital projects and so that can be helpful as well if they're looking at specific expenditures on the debt management side is the accounting team also kind of aligning the capitalization of certain projects in a way that is not only easily identifiable for the accounting perspective but also kind of consistent with both sides of that
00:21:50
so that's kind of what the comment is geared towards when we word it that way is like you can bring others into that equation it kind of gives a little bit more accuracy just out of having a counting look at those balances because they're only really aware of what they've seen being spent be spent or received in a certain year not necessarily what everybody else might be looking at so your comment about treasury is what you meant by performed by departments outside of the
00:22:14
Yeah, Treasury, project managers who might be overseeing specific projects or going out and kind of reviewing the more day-to-day activity on certain things or stuff like that, certainly.
Ned Gallaway
Member, Audit Committee
00:22:30
Jacob, do you have any, like if it's project management to account?
00:22:34
I guess I'm just, I got to tell you something.
00:22:38
I got to work hard with speaking audits when you all show up.
00:22:44
So for me, I'm thinking, all right, there's a project manager over a project.
00:22:50
I don't know if they're doing monthly reviews to say where are we at to communicate something to accounting or if they even noted.
00:22:58
And then vice versa on the way back.
00:23:00
So I'm just trying to
00:23:03
I'm trying to understand what the flow chart should be.
Jacob Sumner
Chair, Audit Committee
00:23:06
Yeah, so we do have regular conversations with the project managers, and particularly OMB, as we're looking at the capital budgets and how we're utilizing those funds throughout the year.
00:23:18
That's really where historically our focus has been on.
00:23:22
And I think it was relevant, particularly from the previous year's audit, that accounting was not a part of that conversation included in there, or included in the types of updates on projects that were talked about in those meetings.
00:23:37
So as we go through and refine these processes and make them better for the future, that's an element too that we're going to be adding into those processes.
Ned Gallaway
Member, Audit Committee
00:23:45
So each department's updating their item with a check-in to these other places.
Jacob Sumner
Chair, Audit Committee
00:23:52
It is, and it's really also for the county units to hear those conversations so they can then pick up on language about a project is winding down, we're going through punchless items, and that will be an indication of, okay, this is getting ready to be finished and should be used, be moved towards capitalization.
Megan Argenbright
Partner
00:24:10
Thank you.
00:24:11
I'll also add, not to overcomplicate it, but sometimes there are projects that are then abandoned, right?
00:24:16
So you start looking at things and you put it in CIP because it's supposed to be a future project.
00:24:21
And sometimes, and this didn't happen here, I'm saying it's one of those things that on the other hand, not just to place it in service, but when it's like, okay, we're going to go a different direction and then you need to take that off your capital asset.
00:24:33
It doesn't have future value for you anymore.
00:24:35
So some of those communications, not only from one is a project done, but one is a project no longer even a project.
Ned Gallaway
Member, Audit Committee
00:24:42
So like a placeholder three years later.
Megan Argenbright
Partner
00:24:45
Right.
00:24:46
Yeah.
Addison Roeschley
Senior Associate
00:24:48
And two, with the capital projects, there's kind of this like curve almost on it.
00:24:53
It starts off small, and then you hit about 20% of the way through that project as you're working through it, and costs tick up really quick.
00:25:01
And from the accounting perspective, it's really easy to see those contractor applications come in for a million or $2 million at a time.
00:25:08
And then as it gets towards the end, it tapers back down and things get
00:25:12
You know, pretty small as far as the transactions that come in.
00:25:15
Maybe you're doing a blue tape walkthrough or something.
00:25:17
At that point, you're really not paying much anymore.
00:25:20
And so from the accounting perspective, there's not much that they see at that point.
00:25:23
And that's kind of when a project at CIP can almost get forgotten about.
00:25:27
or inaccurately timed it's like they can almost see hey not much has come in at this point for us to capitalize it's probably finishing but what's the exact time on when truly we take you know possession of that asset it becomes usable and they can place it in service and that's not as much of like a detail you can get by just looking at the accounting ledger you have to talk with others about that and kind of know what's going on.
Jacob Sumner
Chair, Audit Committee
00:26:00
Any other questions?
Jim Andrews
Member, Audit Committee
00:26:04
It does seem like in most cases, material is in the material weeks and significantly deficient that a lot of the fixes and communication are between the different areas.
00:26:27
And I guess I would ask on material weakness whether we're looking at something that contributed to making it a material weakness because it was flagged previously as a significant deficiency or because it's changed in a significantly negative way or because the dollar amount is larger than all three.
Megan Argenbright
Partner
00:26:47
Yeah, it's kind of all of those things with
00:26:53
We kind of look at the whole picture when determining that, right?
00:26:56
And so, and part of that is like, if we hadn't come in to audit, do we think material errors would have happened?
00:27:02
And the answer is probably yes.
00:27:06
I don't think that we're ending with material errors, right?
00:27:09
But we did have to send the capital assets information back a couple of times.
00:27:13
And so just making sure it's right.
00:27:16
So it was a prior comment.
00:27:19
And again, like you'll see, I mean, it was not in a great situation this year with staffing.
00:27:25
And that was out of everybody's control.
00:27:28
And so it's unfortunate.
00:27:32
But that is part of what is your whole control environment?
00:27:36
What is the plan, the backup plan?
00:27:39
And that's part of it.
00:27:40
So we do kind of try to look at all of the things.
00:27:43
And the process is there.
00:27:46
And so if errors happened last year and they're happening this year, OK, what do we need to do?
Ned Gallaway
Member, Audit Committee
00:28:00
We've never had that legislated.
SPEAKER_08
00:28:23
conversation.
00:28:23
I have, Jackson and I have like, let's get some data on how many school divisions are not meeting this.
00:28:28
We know we're not the only one, but no, we've never, not as a priority.
Ned Gallaway
Member, Audit Committee
00:28:32
It seems like that's something that, you know, if it was just Albemarle, then that's a different thing.
00:28:39
But if a lot of school divisions are having issues hitting them, that would be an easy fight away and support fight between the SBA.
00:28:48
Yeah.
SPEAKER_08
00:28:49
So I think that, I think our next step on that is to get some hard data on,
Addison Roeschley
Senior Associate
00:28:53
And if you look at the state code as it outlines kind of that requirement on that submission and how the APA outlines the requirement of us to look at it historically they've always said that that report in state code should be submitted by September 15th this is actually the first year it kind of changed and they said it should be submitted by the deadline so I think it's not really an indicator that they're also looking at it that way but on our end that kind of does give the appearance of like
00:29:21
Maybe there are other localities that are struggling with this or they're looking at changing that deadline process.
Ned Gallaway
Member, Audit Committee
00:29:26
Do you know if there's something in the state code that requires the school division to hit that date because then they're trying to hit some other date?
Megan Argenbright
Partner
00:29:33
Well, the December 15th deadline of the localities, like it all kind of goes together.
00:29:39
So if you move back other deadlines, and we did move back the locality transmittals, right, which is not even a word we ever even talk about in our presentation, but we take our big report and put it in Excel for the state.
00:29:54
And so
00:29:55
It's essentially the locality equivalent of the annual school report are the transmittals.
00:30:00
That deadline used to be November 30th.
00:30:03
I don't want to age myself, but I feel like it was not that long ago, but I brought that up at a meeting on Friday and everybody was like, oh, it's as long as I've been here.
00:30:13
But when I started for sure, it was November 30th and the localities lobbied to get it moved to December 15th.
00:30:22
because with the Thanksgiving holiday, it was always a disaster.
00:30:25
It was a disaster.
00:30:26
And so December 15th is great.
00:30:29
However, we still have to present to every localities governing body by December 31st.
00:30:37
And so
00:30:39
There's, right, so every time we move a deadline back, it kind of just creates this other issue.
00:30:44
So the localities still have this 12-15 deadline.
00:30:47
I don't think it's ever going to get, I don't think it's going to get later than that, because then the data is already six months old, like the information, and so if they move the ASR back, is that going to impact
00:31:01
because the revenue and expenses that are in the ASR need to be reflected correctly in the locality report.
00:31:07
So I don't know.
00:31:09
This isn't all that to say, but our procedure is not so much to test that it's turned in timely.
00:31:15
Our procedure is to make sure that it is accurate.
00:31:18
So the only reason we had a finding for it last year is because we couldn't verify accuracy and now we can.
00:31:24
So to us, if you turn it in September 30th versus
00:31:29
November 15th, that's fine.
00:31:32
You won't hear a peep out of us if you turn it in by November 15th and we have it and we can test the accuracy.
00:31:40
So that's my unofficial two cents.
Jacob Sumner
Chair, Audit Committee
00:31:50
Anybody else for Megan Radisson?
00:31:57
All right.
00:31:58
Thank you all.
00:32:00
All right, Leandra, you're up next with an update on our new financial system.
Shenandra Usher
Assistant Chief Financial Officer for Operations
00:32:06
Thank you, Jacob.
00:32:07
Good morning, everyone.
00:32:08
This flyer, y'all should have copies, is to introduce our new and upcoming financial management system, which is Tyler ERP.
00:32:16
Many of you may already be familiar with this system.
00:32:19
For your awareness, Tyler will completely replace our current Great Plains, which is our financial system of record, and ePro,
00:32:29
which is our purchasing system that we use to integrate with Great Plains.
00:32:33
It'll completely replace both of those systems with a purchasing and procurement front end that will be unified with the financial and accounting back end.
00:32:41
So if you'll take a look at the left column of the flyer, you'll see some of the enhancements that should help us in the future have a cleaner audit.
00:32:51
Starting with purchasing and procurement, there's a greater integration of purchase cards into our system that will allow
00:32:57
allow for easier purchase order liquidation and a true linkage of purchase card expenditures without any manual intervention.
00:33:07
Currently, this is a manual process that will be eliminated with the new system.
00:33:12
By moving this to a single system, errors and issues with importing receipts, account codes, and securitization errors will be eliminated.
00:33:22
We'll scroll down to the reporting feature.
00:33:27
Oh, another highlight I like to highlight on that section, my apologies.
00:33:31
Additionally, all expenditure documentation can be pulled from one place.
00:33:35
Right now, things are located in various spaces.
00:33:38
We'll have one central repository for the collection of all the expenditure information for accountants or anyone else who have reviewed when it's time to sample for the audit.
00:33:48
On the reporting component, reporting will be greatly enhanced and any document connected to in any way
00:33:56
to any of our processes or procedures to include bids, contracts, requisitions, purchase orders, invoices and checks will be linked for easy access and verification by our accountants and also our auditors.
00:34:10
We should be able to provide read-only access if they like that so that they can actually go into our system to be able to review information.
00:34:20
There are large improvements underway to ensure that capital assets are easier to track and account for
00:34:26
such as an automatic review process that looks at purchases in a particular account codes and dollar thresholds and forwards them directly to an accountant for review.
00:34:36
So this should be an automatic process that will flag information so that the accountants can review the information so that we'll know whether or not we need to capitalize an asset and put it into the asset management module for the new system.
00:34:53
If we take a look at the right-hand side of the flyer, these are some key dates that have elapsed.
00:34:58
These are some key dates related to the project timeline.
00:35:00
If you notice, the first date has already elapsed.
00:35:02
This is our system procurement, July 2023 through December 2023.
00:35:08
Our go-live date is set for April 1, but in the meantime, we're currently in the phase of the implementation of the ERP system.
00:35:15
That started in January of 2024, and it will conclude in April of 2025.
00:35:23
To go live date, we'll be reaching out, doing some training, communicating to our partners and making sure that everyone is aware of the new system and how to use the new system.
00:35:31
As mentioned, April 1st will be our go live date.
00:35:34
And then we'll work on post deployment support from April 2025 through July 2020.
00:35:44
So these are some of the features that we wanted to highlight to you all.
00:35:49
That should help improve our financial reporting for the future and improve our consistency year over year as we continue to have audit and have our audit report.
00:36:01
I'd like to highlight that there's been a lot of staff that has worked diligently to include our partners, our partnership with schools on this project.
00:36:09
It's taken a lot of hours to get it to the stage where we're currently in and we are currently ahead of schedule.
00:36:16
So that's great news.
00:36:17
Looking forward to the implementation.
00:36:19
and just very appreciative for the staff that we have that's able to help us mitigate some of the risks that we face with our current system so that things will be better in the future.
00:36:31
Are there any questions?
00:36:33
Oh, I'd also like to highlight our lead on the project, which is Dennis Click.
00:36:35
He's one of our deputy controller.
00:36:38
He's the lead on this project for the Department of Finance and Budget.
SPEAKER_01
00:36:43
It sounds like that you think the implementation's going positively.
00:36:47
Yes.
Ned Gallaway
Member, Audit Committee
00:36:50
It sounds like a self-wagging is what's fitting this issue of the asset build-out.
00:36:56
You were probably explaining the last one when I was writing my note on that.
00:37:01
This non-reporting fund for comprehensive asset verification, what is that accomplishing?
Shenandra Usher
Assistant Chief Financial Officer for Operations
00:37:06
So that is going to be a component of the system that will show our additions or subtractions or depreciation calculations.
00:37:13
It's going to be like a
00:37:15
A repository for information related to the assets that are in the module.
00:37:18
It will not feed directly into the ledger or the trial balance, but it's a repository that an accountant can go to to verify information.
00:37:26
And also we can use it as a review to ensure that all the things that were flagged as a part of the process within the system, that we actually captured those items and that these things have actually taken place.
Ned Gallaway
Member, Audit Committee
00:37:37
And is the self-flagging programmed in there by a department?
00:37:40
Like I'm thinking of the staffing issue.
00:37:42
If I come in and I have to put my own self-flag in for a project and then I'm gone, the next person coming in might not.
00:37:49
So is the self-flagging being loaded in at a higher level so that whoever's working on it's going to get the flag?
Shenandra Usher
Assistant Chief Financial Officer for Operations
00:37:59
To a certain degree, yes and no.
00:38:00
So is flagged by the account code that's used and the dollar threshold?
00:38:04
So as long as the account code, which will be entered by an individual, is correct, it will be flagged.
00:38:09
We're having several training courses and classes to ensure that individuals know which account codes to use as it relates to these purchases.
00:38:17
So that will take place on the front end of the system when the item is actually procured to ensure that the proper account code is put in the system so that it will be flagged in the process.
00:38:26
So it's a combination of both the system and there is some...
Ned Gallaway
Member, Audit Committee
00:38:30
Still some manual.
Shenandra Usher
Assistant Chief Financial Officer for Operations
00:38:31
Yes.
Ned Gallaway
Member, Audit Committee
00:38:32
Is there a way that
00:38:35
I've worked with a lot of systems that you can make it do things, but sometimes software companies don't think of those subjective.
Jacob Sumner
Chair, Audit Committee
00:38:49
I don't think this one will have that type of capabilities as far as the coordination and communication effort that we need to have with project managers and those that work through the budget and the debt related to it.
00:39:05
But one of the good things is in the
00:39:09
Having at least the consolidated information is a good start.
00:39:13
So we know where we need to have those conversations with project managers and those that are on projects.
00:39:20
Thank you.
Jim Andrews
Member, Audit Committee
00:39:21
I did notice people nodding their heads.
Megan Argenbright
Partner
00:39:25
I'm excited.
Jim Andrews
Member, Audit Committee
00:39:26
OK. Do you think this is also something that could help with addressing this?
Megan Argenbright
Partner
00:39:31
Yeah.
00:39:32
And there's a lot of things.
00:39:35
We have a lot of other clients that use the same software.
00:39:38
And some of the things, it's meant for governments.
00:39:41
And so it's meant to capture the things that you're trying to capture and have those processes in place.
00:39:50
Optimistic.
00:39:51
This is why I stay on the audit side, though, because I have no desire to do an implementation.
Addison Roeschley
Senior Associate
00:39:59
It does make our lives a little bit more challenging, usually, in that first audit year with the new system.
00:40:06
We're definitely learning the new process, and almost other people are also learning that process.
00:40:10
With us, can we ask questions a little bit differently, usually, than an accounting head might?
00:40:16
So it does kind of create some
00:40:20
Problems in the future that we're looking at structuring into the audit, just as far as like communication and timelines.
00:40:26
But as Megan said, we see Tyler used very frequently, so.
Megan Argenbright
Partner
00:40:30
And it could be interesting for FY25's audit, just because April 1, April 1 is, you know, later in the fiscal year.
00:40:39
So I don't know, there's still gonna be heavy lift.
00:40:43
It's a whole heavier lift, because you guys are gonna be almost doubling up on efforts, but yeah.
00:40:49
I'm excited about the possibilities.
Ned Gallaway
Member, Audit Committee
00:40:54
So I see that the self flagging helps with the capital piece.
00:40:59
You again may have been saying this and I was thinking something else.
00:41:02
But how does it help with the grant piece being one year versus another year?
00:41:06
Is there something in this system that helps with that?
Jacob Sumner
Chair, Audit Committee
00:41:09
I think that the biggest component will be the reporting.
00:41:12
Right now, not only do we have
00:41:14
multiple systems, we have E-Pro, we have GP, but getting reports across those two systems is very manual and labor intensive.
00:41:27
With a fully integrated system like Tyler, you'll have all that all in one, but you also have access to the reports that can see across all those modules, all those systems, and that will be the easiest part.
00:41:38
Running the reports will, right now,
00:41:41
I would say it's very difficult to get an on-demand report out of our current system and current structure, but with Tyler, anybody that has access to the financial system will always run an on-demand report at any time.
00:41:54
Thank you.
00:42:04
I did just want to take a moment to thank all the folks that have been a part of this project.
00:42:09
This has been a long process to get where we are, but we're moving towards user acceptance testing and towards training.
00:42:17
There's been a lot of effort and partnership on documenting processes, looking at our data, looking at our systems, I think schools for their partnership and working through
00:42:29
areas where schools integrates and has most of their transactions in the financial system.
00:42:34
And then also as for Subaru housing members particularly, this is a result of the core systems modernization project.
00:42:43
And you expect to see a lot of efficiencies, a lot of better reporting and access reporting as a result of this.
00:42:50
So there's also a great thank you for that as well.
Ned Gallaway
Member, Audit Committee
00:42:56
Just as a side note, I would think it would be of interest if you're tracking it when the implementation happens.
00:43:01
Like, I get it.
00:43:02
At the report now, it's real time intensive to get an on-demand report.
00:43:07
It might be a nice little anecdotal bit of info to know how much time is saved once the system's up being used properly.
00:43:15
Just to justify.
00:43:18
We budget for things, we put them in place, we don't always do a good job of telling the story of what the savings were or the efficiencies are after they're realized.
00:43:28
That's true.
Jacob Sumner
Chair, Audit Committee
00:43:29
And I think what we'll see more is our staff is a
00:43:34
An integral part of the process in the current system because there's a manual nature to those elements with the new ERP that is automated.
00:43:45
And so we have the ability to then focus their efforts in other areas.
00:43:55
All right.
00:43:55
We'll move on to our last item on the agenda.
00:43:58
Ms. Lori Andrake will give us an update on the fraud waste and abuse program.
Lara Andrake
Chief of Enterprise Risk Management and Shared Services
00:44:03
Thank you.
00:44:03
Thanks for allowing me to present today.
00:44:06
This is the third report since the inception of this Broadway Sin Abuse program.
00:44:12
There is a paragraph here on the background.
00:44:15
We started this in January of 2023.
00:44:17
The Board of Supervisors has staggered this program.
00:44:21
And so each audit committee meeting presents the results from the prior meeting.
00:44:28
There is a little verbiage here about the process and procedure.
00:44:32
There's essentially
00:44:34
Four ways that someone can report alleged abuse, fraud, or waste.
00:44:41
And so the process involves the risk management team.
00:44:45
And then if it's deemed as a substantial issue, we'll turn that over to the internal person.
00:44:53
If the person is within the community, we'll turn that over to the appropriate officials for further investigation.
00:45:01
Since the last
00:45:04
audit committee meeting there's been three complaints reported two of those were general in nature and did not have much substantial information to actually investigate it's important
00:45:20
to know that this is an anonymous system.
00:45:23
And so if we're not given the person's information, it's very difficult to follow up and ask questions and gather more information.
00:45:30
So two of those were closed because of limited information.
00:45:35
The one there, number two, the employee payroll abuse, that was a phone call from a business in the community.
00:45:43
And we took internal steps to conduct an investigation.
00:45:50
Individual went through the disciplinary process of their organization.
00:45:55
The report has been closed with no further action.
00:46:01
So those are the three actual reports.
00:46:04
And then I wanted to highlight for this committee's awareness, there were some steps that were put in place by the Office of Investment and Dam Management, which is formerly known as Treasury.
00:46:16
They implemented a feature on our bank account called positive pay.
00:46:21
And so we intercepted two fraudulent checks that were a total of $17,402 that would have possibly otherwise been cashed had we not had this positive pay in place.
00:46:38
And so that was incorporated last July.
00:46:43
And so now we're very excited to be able to report those near misses and those attempted, intercepted fraud activities.
SPEAKER_08
00:46:57
I know when the system was first rolled out, we put posters and communication.
Lara Andrake
Chief of Enterprise Risk Management and Shared Services
00:47:01
I wonder if some of us need more.
SPEAKER_08
00:47:05
Is there an annual message?
Lara Andrake
Chief of Enterprise Risk Management and Shared Services
00:47:08
Yes.
00:47:08
So just moving around the spaces, I noticed the posters are still there.
00:47:14
But you're right.
00:47:15
There could be a reminder.
00:47:17
I would propose we do that kind of on the anniversary, maybe in January, the first start.
00:47:23
That'd be a great idea.
Ned Gallaway
Member, Audit Committee
00:47:28
These were checks that people tried to cash.
Lara Andrake
Chief of Enterprise Risk Management and Shared Services
00:47:33
They were.
00:47:36
They were checks.
00:47:37
They were actual valid checks.
00:47:40
The information was correct, but the person had switched the payee's name.
00:47:45
And so when it went through the bank, essentially, the bank does a verification for us now.
00:47:50
And so the payee and the amount match.
00:47:57
And so they didn't match and applied for investigation.
00:48:06
Nice.
Lara Andrake
Chief of Enterprise Risk Management and Shared Services
00:48:07
That's all if there's no other questions.
00:48:15
This is indicative of the system working, and so I'm really excited that there were only a few items to report.
00:48:23
All right.
Jacob Sumner
Chair, Audit Committee
00:48:27
Thank you, Laura.
00:48:28
That's all the items we have on the agenda for today.
00:48:31
Just wanted to circle back on the audit.
00:48:34
Just a reminder, the final financial statements were presented to the board of supervisors at their meeting on December 11th.
00:48:41
Megan will also be there to accompany Shenandra in that presentation.
00:48:48
But the formal results, and let me just talk about compliance today, compliance items, but the formal results will be, and the numbers will be right at the end.
00:48:58
All right, with that, we can adjourn until all our next meetings will begin in the spring.
Shenandra Usher
Assistant Chief Financial Officer for Operations
00:49:06
Thank you.
00:49:06
Thank you.