← Back to MaineScanner

Ellsworth Finance Committee Updates Procurement Policy and Bank Reconciliation Plans

2026-10-26 · 56m · Source: Finance Committee Meeting - October 26, 2026 (City of Ellsworth (YouTube))
Speakers labeled via automated voice-based diarization + AI name-matching against the city's official roster. Automated transcription can still mis-hear a name during fast speech (e.g. a rapid roll-call vote) -- clear near-misses are auto-corrected, but this is not manually verified line-by-line. Treat names as a strong best guess, not an official record. Home addresses that residents give are left out of this page.
[0:05] Speaker A (unidentified): this too great thank you all so much for being here today I am going to try to join the Finance Committee meeting virtually as well so there with me I'm going to see if I can share one of my, it always does this, it's continuing the browser, then it should work. I'm going to talk about procurement this morning. You've got a procurement policy in front of you and you might go, what in the world? This is not what we've been looking at for the last five or six months as we've been developing a much more robust modern policy in conjunction with the development of the new OpenGov procurement system. [1:07] Speaker B (unidentified): Procurement system. I'm actually going [1:11] Speaker A (unidentified): to pull it up online, Tabby, so you'll be able to see what we're looking at. [1:23] Speaker C (unidentified): I don't know if that helps. At least you can see it. [1:29] Speaker A (unidentified): so you're gonna be like okay now this is like one page we just went from like 75 to 1 we had some discussions our legal counsel on main law procurement law we want to obviously be in line with everything but then also not necessarily opens ourselves up to a zillion lawsuits with a 75 page policy that you know any bit of web no procurements can oftentimes be really difficult policies to oversee and to run we want to be as prescriptive as possible but we want to have some level of flexibility in the system and really you know the legal counsels noted that with home rule and our ability we really as long as there's no fraud or conflicts of interest or anything like that or procurement policy is really up to the council and we really felt like it's it's probably best to separate the two and I'll come to the City Council meeting maybe in November to certify this where we don't have us the City Council approved policy it seems as though it's just been an internal city manager group kind of a copy of a paste for a while so to make one that's a little bit broader on sort of the general guiding principles the $15,000 dollars or more threshold and some of the general procurement pieces and then a note that along with it there's procurement manual and guidelines which then we can be extremely specific so that you know and also stop sharing kind of just this the short run policy and so you know attached to it would be the guidelines and prim and manual just share again which will be are much more detailed what you've been going over for the last five or six months on you know exactly how to use this manual every little piece on if you're doing an RFP or request for proposals of requests for bids what the definitions of those are you know having all of our staff trained in each of these tomorrow and the next day we're doing our final end user training on the OpenGov system with all of our department heads. Many of our department heads have already issued plenty of RFPs and RFBs through the system, but we want to make sure everybody has been fully trained now that the system is fully implemented. So that's kind of where we're going with this. It talks about council access and boundaries to make sure that the competitive bidding process remains neutral, the thresholds of what triggers various council actions versus staff actions, selecting the appropriate procurement method, when informal quotes and, you know, when staff are sort of trying to design their procurements, how the workflow should go through the finance systems, market research, how to evaluate proposals, the creation of evaluation committees, the negotiation and awards. I think in an ideal world, we have somebody like Sarah Devlin on staff in perpetuity who has done hundreds of procurements from main DOT, Turnpike, now Citi, and then in transportation. But we also wanna make sure we're sort of taking her great procurement brain and turning that into a procurement system that all of us can learn from and it has some level of flexibility when sole-sourcing could be used emergency procurements if something has to go forward how that works so that's really where we're where we're moving is to do an official City Council sort of streamlined policy and then a reference to an attached guidelines and principles and manual much more prescriptive for myself for myself and for the staff to go by so I'll switch over now from the any questions on that before I just get into the system itself yes just in recent [5:51] Speaker D (unidentified): meetings with the Cemetery Commission we've talked about putting it for the work they're doing is it clear enough in the policy it says the city of Ellsworth purchases goods but do we need to reference commissions as also falling under this policy or is that clear enough you know i assume that they'll have access to it through the staff person who is their connection to the city but is it helpful to add that commissions are also under [6:15] Speaker A (unidentified): this you know we have yeah we don't have the committee's is it just a finance committee i like the idea of giving some guidance to commissions for that exact purpose you know some of them do receive funding right for their projects obviously goes to the budget process but the cemetery Commission also has its own as its own or the juniper portions so yeah you know it's on our work plan for consideration for 2027 on boards and commissions standardization processes and procedures so I could see that as part of this but some reference to how that should work here as well I think is a really good at it I'll talk to you okay to lay in the team just so that there's some guidance on how that [7:07] Speaker C (unidentified): moves forward which should all commissions committees boards need to follow direction from the City Council yeah you know this because if you had a procurement over this threshold or whatever i mean we need to with us with the finance committee and you and the finance director we need to keep track on yeah [7:38] Speaker A (unidentified): i'm trying to think you know we in the budget process not none of the i could be wrong but i'm pretty sure none of the boards of commissions have over 15 000 that's allocated to theirs the cemeteries might be the want exception because of their own funding piece but no single procurement [7:54] Speaker D (unidentified): I think when to put out bids for things even I think if the second sentence were you know by the city of Ellsworth we mean and then fill in the blanks here's all the city officials to just for that extra clarity for the folks who were on the Commission's and committees who maybe don't really do is just for [8:14] Speaker C (unidentified): that clarity I think would be important I agree with you on that everybody needs [8:18] Speaker A (unidentified): needs to be and just have it clear typically they work through a person so [8:26] Speaker D (unidentified): it's well it takes a bit of the burden off that day designated staff person if they can just say you are you do fall under right here it is in writing here [8:33] Speaker A (unidentified): here's where it is in writing but at least it gives I know we oftentimes come into this with the Board of Commission it's like what's the rules around here what's this there's not exactly like you know press play fortunately we're getting there with a lot of our other things but yeah let me definitely consider any other questions before i go into the system itself i just want to show kind of what we're the upgrade that has happened which i'd say is one of the most significant financial changes for the city so you know upon arrival here i was pretty awestruck by how procurement was handled it was really you know there was a procurement policy that was clearly very old actually a lot of departments at the time said we don't really have we don't have a procurement policy nice you know we do it is and it was kind of just this rule of thumb of 15,000 that was like you know anything else besides that was you put together a Microsoft Word document you get Jason to put it on the website and then you know you kind of bring it before Council and if I was to ask what were the last 15 to 50 procurements in the city over the last five years nobody would be able to tell me that in fact we'd have to do a ton of research to even figure that out obviously besides staff salaries what we procure in many ways government is kind of a pass-through entity to the private sector for most of the work we do so having a system that is very transparent that is rigorous that is competitive but also that gets a lot of bids on things as well I think when you're always as we talked with Chris who's not here today our new finance director about being a pricemaker and not a price taker if you are always just sitting out sending out a procurement you know three weeks before you're hoping to get that service you are gonna be paying top dollar and you know and you might be late to the party on things getting started off I think in some ways we were a victim of that this year in some ways because we transition to the system we got we're a little late to getting out procurements for our cemetery mowing and for our line striping it's one of those things it's like oh yeah now that it's in this system we can just replicate those bids send them out they're on schedules so that we can get best prices moving forward but i just wanted to kind of just show you a little bit of the system itself kind of from the back end side of things i'm right now working on a request i see a spelling error for that requester that's not a technical term for municipal legal services and city attorney representation you know i think it's been a very long time since Oh, interesting. We've gone out to bid on that. Part of the procurement piece was, hey, if we're doing in the aggregate more than 15,000, maybe it's not at an individual level. And I think what it incurs in this category from an engineering standpoint, we use some local engineers and surveyors. That's allowed the procurement policy to sole source through experts for that type of work. We still have to go to council over 15,000. But that doesn't mean we shouldn't be sending out some of these long-term contracts with the city or long-term agreements with the city to make sure we're still getting best price and best service, of course, as well. So I love Redmond Winchell. I think they do incredible work for us, but so far as I can tell, it's been at least probably a decade since that's been out. So we're working to put out an RFP and get some bidders for that. That's one of the other big changes that we've seen in this cycle is we have a vendor sign-up form for anybody to bid on our projects. We now have 481 vendors that are in the system, so the way we put out bids online is now much,, much easier to search, to find from bidders. We're seeing a huge uptick in bids on our projects, so that's excellent. [12:50] Speaker D (unidentified): How many vendors did you say? You did say that. That's the number of towns in Maine. [12:55] Speaker A (unidentified): Yeah, so interesting. interesting so you know our team did a big you know they just kind of scraped everything and invited everybody that was already in our system so that was part of it but as RFPs get out there in order to even bid on something you have to be a vendor so we also have a contracting system that's a lot more formalized now so that the city isn't just up to whatever somebody else's contract they send to us and that was sort of part of the process too it's like all right now we need an agreement and we were relying on the vendor themselves to have a contract and maybe there'd be legal review maybe there wasn't so now we have standard terms and conditions standard contract we kind of really move the ball forward and in fact in this system you can't even after an awarding about a bid going through the whole process coming to counsel for approval if it's over 15,000 you literally have you have to go to of contracting it has to be in the system and then all of those materials are there I think so this is some this one world parts vendor that's just a sample one we're not doing $500,000 for a world apart services but and now so I can look at all of our projects that have been done and I think this is this is really considering we're not officially really launching until later this month, but after the full training, but considering we had no system before, we were already in the mix. OpenGov was very impressed with the way our team was like, dove right in, started working on the system. Let me see if I can. [14:32] Speaker C (unidentified): From what I've been seeing, because we can all agree, I've seen things evolve for the better. [14:43] Speaker A (unidentified): I agree and I it's in kind of an unexpected ways to kind of like with getting the tax bills out on time of course it's like just you need to do that we've got to get the tax this is ridiculous our customers are citizens of Ellsworth that creates you know but I didn't realize that by doing that we were gonna save our clerk's office staff tons of time I'm just having to feel angry constituent calls people coming in and this is the first time in a while it's like oh wow it's there's these ripple effects same thing with RFP process I was talking to Amanda our Public Works administrator and she noted that how much easier her life has gotten with this system because all the time private vendors reach out with a freedom of access request saying can I have any bid that you've done over the last blank period of time and she'd have to because they're looking for competitive pricing that's one of the interesting things about phoa when you do a little bit of the research on it the biggest beneficiary fo has been private sector because they're able to just take you know they're consuming information to try to get competitive bids most folks if you're at your house you don't have to tell somebody what one bid was for the next in the government you do have to tell everybody so you're able to get how much that asphalt costs how much does this cost so we're constantly being requested and they and all [16:06] Speaker C (unidentified): these vendors they all talk from contractors yeah everything parts and I [16:15] Speaker A (unidentified): know we talked about that too is like what's the bid secret City Hall what it's like it's never trying to be a secret for anything it's just a really laborious cumbersome process and now we're able to just have it be so much more transparent in a platform if anybody wants to sign up and see any bid that comes out you literally can't do a bid secretly here in city hall it's you would have to i mean maybe somebody i know it would be impossible they'd have to go before city council and i'd say why haven't you gone at opengov why haven't i seen it i guess you could try to copy and paste and figure out some fake opengov things but highly unlikely and when we go into these processes too i don't see these things our staff are working on them until the evaluation and scoring committee have moved forward with things i might give some advice on the details of a proposal but we really tried to keep a very independent aspect to each step of the process so you can see municipal legal services street lighting maintenance and support pump station motor remediation just all these fun the city seal removal stabilization some of the ones that have already passed on the maryland side of things what's the color coding Charlie since I can't see the word evaluation closed draft open yep so the city seal removal that one's actually I think probably our only active one that's open right now you know the mineral screening we just we just went through so that'll go to a different area I think some of the original ones for tax-acquired properties Thank You Sue for being one [18:02] Speaker C (unidentified): of our test pilots here on the system everybody's gonna be a guinea pig you know what i mean well no you know i mean it could have could have been somebody else you know yeah and line [18:17] Speaker A (unidentified): striping obviously now this one can be you know it's awarded but geez awarded created 317 released 324 like not like no this is dead probably a January release I think at latest and now we can go into this can replicate it very easily you can set timers on it so it'll trigger an automatic renewal makes it much less laborious I mean I've been here three times where this one out and they literally invented the wheel three different times so looking through Google's emails was that the right version was that the final version that went out you know now like that was the final version any edit is in there all the audit trail and any changes that are made there Ashley was some of the tan financing that have been done and it also makes it really easy for let's say let's see those insights this is gonna get better over time obviously we're so new in here but over time you'll be able to again this includes that 500,000 we should probably change it at some point in time but you'll be able to see like all of the actual awarded that have gone in you'll be able to see so a lot of these are not great right now because there's just not a ton of information in the system what are we looking at these are all the insights like the vendor dashboards on you know I say I haven't even the vet the sourcing funnel and contract I don't even know what that is so we've created [19:58] Speaker C (unidentified): a missile yeah it's a kind of a giraffe yeah so [20:11] Speaker A (unidentified): i'm just now i'm just interesting so you can really and again this is going to take a lot of time before these insights become much better but you'll be able to really break down your kind of spends and then for projects one of the things I like as well is so let's say for mine just this new project here let's say for the new attorney RFP you know I kind of want to look for I want to look for some new vendors or so I'm trying to develop my process all right let me find did a whole preview of this morning at 4 30 in the morning I'm sorry to plan for this and now there's like a development of the project it basically allows me to look at other anybody who's a city or town and then nationwide that wants to that has bid on anything I'm able to just look up their project just such a cool feature. Browse library, here it is. So I could say, so I want to go to legal. Doing an RFP, I'm probably not the first city or town that's ever tried to get legal services, so let's do some research. But instead of just trying to go into Google and find these contracts and who knows where I'm at, I can actually see ones that have actually been done by OpenGov. I can copy the scopes into the new projects. X second so [22:27] Speaker C (unidentified): it would save you from reinventing the wheel it will yeah it's [22:41] Speaker A (unidentified): work this morning sharing let's not go to that one let's see so the city of Chowchilla California actually I really like that one but I look to a couple other ones as well, so I look to Municipal Legal Council, North Brunswick, New Jersey, all right well I will not bore you, this would be my own boring pieces for myself, but it really is able to kind of, I didn't like the New Jersey one, I did like the California one, and I looked through a couple other ones, but that Chow one was really good, they did an excellent job on that, I can just kind of copy and paste some of these services pieces tailored for the city of Ellsworth really get a good head start of that obviously include a lot of our own pieces and then get that out to RFP and move that forward and then put timelines on for it hey in five years somebody should redo this again yeah so you don't get in these places where I know when I did a government turnarounds class once and I think it was like Chicago Illinois or some place placed out in the Midwest and they brought in their, it was like a plowing contract. It was literally like this tall. And because, and the vast majority of it was just, like literally 40 years of just giving it to the same vendor and like same terms as like a 10% kicker, a blank kicker, a blank kicker. And it's just, you know, when something becomes extremely laborious and manual like that, you can see the, real built-in structures for the government to say, like i don't want to have to send that back out to bid i don't want to have to do all the process we're really trying to make it as streamlined as possible and like required that you're going to have to keep getting best price for the city so huge thank you to leia who from our finance team who's taken the project management lead on this the vast majority of everything i just went through is her work and obviously in coordination myself and then a big thanks to sarah and amanda and mike harris who have really been kind of living these procurements in many ways too and whose input has been invaluable to creating the system so it's again another big team effort and really excited about the new system i think it's going to be again another big step in restoring trust in city government on how we do these policies and procedures and processes that are so important to the taxpayer so and i think ultimately not just financially but better quality of product too I think is gonna be another big win for us as well so with that I'm gonna send it over to Ashley for the next few steps who's stepping in for Chris as she stepped in for many finance directors before all right so we're just going to [25:54] Speaker B (unidentified): talk about the bank recs and what it looks like for us moving forward to try to bring this back in-house sorry Tabitha I did not bring my computer with me to share this with you but I can send it to you after the meeting afford is here right now okay thank you so we're just looking at like understanding Ellsworth's bank recs where we begin looks like our starting point is going to be the June 30th 2024 and the way forward taking control of our future What is bank recs? Municipal bank recs are it's a monthly process of comparing local government internal general ledger cash records with external bank statement balances to ensure accuracy, detect fraud, and maintain public accountability. In other words, we're verifying, editing, and adjusting to ensure that our books match our bank on a month-to-month basis. The importance of this can't be overstated having a clean reconciled general ledger is the single most important element for us to be able to report plan and budget with any degree of confidence it provides the definitive snapshot of where we stand financially and this is where it's going to get a little tricky our Ellsworth Bank recs municipal bank reconciliation is always notoriously different difficult exercise so in the first group it shows basically your core municipal challenges and what we have and then what we have for Ellsworth we're two years behind so we're having to dig through and reconstruct history we're using multiple systems we have trio Casale there was one for solid waste I'm so I don't know the name of it waste works just different things like that we have multiple bank accounts our systems change over from Munis to Cassell the many different ways that we collect revenue so the cash in versus the cash out and utilizing sweep accounts so we have a sweep account for every bank account that we have so we have to reconcile double the bank accounts because you have to reconcile the sweep accounts and the actual the checking accounts as well and [28:25] Speaker A (unidentified): can you explain a little bit more in the sweep account [28:27] Speaker B (unidentified): like what that is yes so the sweep account is where at the end of the day when the banks close it takes all of our money out of whatever checking account it sits in and it disperses it to how many checking accounts it needs to for the insurance or only it's only $25,000 I think federally insured so it disperses all the money out to different accounts so if the market crashes if somebody hacks the account anything like that we're federally insured and we get our money back so and then it's also a higher interest as well so we get interest earned on that sweep and it just protects us in the long run so [29:13] Speaker A (unidentified): that's what a sweep account is yeah and so in some ways like it's obviously it's complicated for all of our ledgers all of our different items coming in and kept to what we have in our internal systems to what's in the bank systems the bank is also you know to stay under the FDIC limits is also farming out our cash to earn forty nine thousand dollars at a time sending it out every night interest is accrued in higher areas it comes back together interest is made that's actually good for the city we get additional funds for that there's processes but then that also all has to be reconciled so it's one of those things that's just it's another fun part of our yeah and almost reckon [29:53] Speaker B (unidentified): and almost to do the recons on those is almost impossible because of the timing that the money moves out versus the time the money comes back it's a timing issue so especially at the beginning of the month or the end of the month you the month previously they could have taken money out and it doesn't hit back technically on a statement like two days later into the new month so it's there's [30:14] Speaker D (unidentified): a timing issue too and would you talk actually about this is a normal thing that happens for accounts with large money so that you can actually make more interest on them. It's not just municipal money. It's not just Ellsworth. Correct. How widely? This is a normal global financial practice. Yep. [30:32] Speaker A (unidentified): In some ways, ours is kind of, and this is a recurring theme I think we're seeing, is the complexity that we've made it on the multiple accounts on some of these pieces. And the processes for how we do analyze those pieces. it's been outsourced multiple times and we'll get to that in a second so we don't necessarily have an internal here's how it needs to go so this in some ways it's not it's not abnormal for these things to occur it's just difficult to reconcile in the near term and have a process for it and then once you figure it out it's kind of actually one of the easier things to do but send [31:07] Speaker B (unidentified): it back over to Ashley all right so the next page basically shows all of our 49 total GL cash accounts these are just our cash accounts so as you can see 49 is quite a bit we don't even have room to show you what it actually looks like in the system on this page because it's so intense it's a lot and this is our elsewhere general ledger cash accounts so this basically shows the checking accounts the sweep accounts all of the cash accounts that we need to break everything out into the system it's 49 that we have to track and reconcile and then this is the bank side basically showing you from those 49 cash accounts we have 32 total bank accounts in our system right now that's the sweep accounts and the regular checking accounts and then the next page just tells you a little bit more about the sweep accounts again and basically the timing issue that we have with the sweep accounts coming in and coming out the next page is step two where we plan to begin while we're initially hopeful about the consultants progress there's a couple of snapshots in there where Chris joins the Ellsworth team 731 Charlie welcomes onboarding we have a status and then there's some comments in there from our consultant, Sue Lessard. I'm going to send this to Charlie to touch on. [33:15] Speaker A (unidentified): Yeah, I'd say just, you know, I think we were hopeful about that, the consultant keeping us up to date on these pieces, as noted in my e-mail in July. It had already been delayed several times. I was hoping to have that finalized by the time the finance director onboarded. we met with the consultant that first week they'd noted that they were currently in May 2025 so it's almost 11 of the 12 months completed since that time we had a fair amount of back-and-forth requesting updates and five or six moving of deadlines on when work product would be handed it over finance director made multiple five or six times requests just to see work progress to date and I think as they note in this area that there's no actual level of progress to date we were hoping that week you know I think we had a pencils down discussion at the last finance committee meeting noting that we'd said pencils down just show us what you got we haven't received anything so we are our I guess I'll send it back over to you and where we're beginning and we're bringing it in house now we can't we can't wait for something [34:35] Speaker B (unidentified): that we haven't seen so as a result of not receiving any of those documents we've decided to serve our consultant relationship and pull the bank recs back in-house we're confident that this is not only the right decision but we'll have many important benefits for us going forward it also means that we're starting from our own goal line which is july 1 of 2024 so now we have to work from july 1st of 2024 because we don't [35:05] Speaker D (unidentified): have any of the work that was completed and that's the beginning of fiscal year 2025 which is why you chose that date yeah and [35:16] Speaker B (unidentified): that's the year so we're 25 and 26 are the two years that we're behind because now we're in fiscal year 27 yeah all right so we have an approach to tackle this critical project working calls with auditors our HR so those have already started we've had meetings with them multiple times multiple emails have gone back and forth they have sent us what they did previously from fiscal year 23 so we have that so we have the clarifying starting point GL balances reconciling adjustments, et cetera, from RHR. We have an understanding of how and what the extent we might simplify our reconciliation exercise. Obtain the auditor's approval for the finance director, Chris, to reconcile template. So he's got one from Surrey when he was in Surrey of how he did his recon, so we're going to try to mimic that here the best that we can. [36:12] Speaker D (unidentified): And if I can interrupt, you mentioned that fiscal year 2023. We're starting with 2025. What about fiscal year 2024? MR. That's in. MS. That's in. Okay. Because you said... MS. Sorry. [36:22] Speaker B (unidentified): So fiscal year 24. The auditors, yes. [36:25] Speaker D (unidentified): MS. That's what I wanted to keep a chance to say that. MS. Yes. [36:27] Speaker B (unidentified): We're reconciled up to fiscal year 24. So we have 25 and 26. Sorry. Yes. MS. Yep. MS. So we're looking to onboard a financial analyst to better utilize the existing internal resources talented internal candidate with firsthand large corporate recon experience so we do have a couple internal candidates for this position there's a redesign and a streamline of accounts payables to free up our finance team and that is we are doing the bi-weekly warrant now and we are also asking department heads we're starting with the police department first we're asking them to start inputting their own invoices and then when they come to the finance team we'll review them for accuracy and then approve them from there create a clear accountability as well as reporting transparency for this project so the CFO and financial analyst when we obtain one is going to lead the recon project with support from the broader finance team meetings set with both accountants which is our HR as well as the bank team again we've already started those we do have meetings on the books with the bank I think this week actually and a regular report outs the Finance Committee regarding the project status and where we stand with it we'll start to happen so that is the goal for the recon process and hopefully we can start it sooner than later get that in [38:03] Speaker D (unidentified): going can you have any sense of the timeline no you know I put [38:14] Speaker A (unidentified): my performance review April 1st to be fully caught up on both cycles I you know I think we're gonna have to move mountains 25 and 26 to an overuse point we can't do these budget cycles without the previous we can but we shouldn't and you know, I was hopeful, not just as a previous consultant, but in the city spent probably close to half a million dollars over a couple year period of time with our accountants doing our reconciles in the year before I arrived. And, you know, we were hoping for a much cheaper consulting, much,, much, a small fraction that hasn't worked out either. But the hope has always been to get us live reconciled to date so that the team can switch over. I know talking to Chris and he'll have a lot more like this is gonna really lead the Finance Committee you know and progress here and it's no more I mean that's the way it's been the entire time I've been here and even when I was watching these meetings before I arrived was we're waiting for the consultant or waiting for the consultant or waiting for the and that's not good enough for the taxpayer so in future meetings we're gonna say you know now that we're doing it internally we're in february 2025 we're in june 20 and hopefully there'll be a an exponential progress here as our systems get better from moving forward as chris notes out he's he's done this work before in surrey now granted we're more complicated much more complicated than surrey but we have a lot more resources to bring to bear so he's putting together a project plan and to me when i you know this is this is where everything needs to be resourced towards i don't see us adding a lot for the budget next year I think it's gonna be very similar to this year in terms of I'm gonna like to say no to just about everything but finance resources in terms of getting the kind of beating heart of the system and live reconciled is the most important project the city has it's also probably one of the larger ones that the city's ever attempted we've actually mentioned some of the restrict structuring internally I'm also holding backfills in areas across government to look if we can redeploy some additional resources into the finance department I've cancelled the grants management system which I think has a big potential to help subsidize a lot of our capital improvement plan through better grant seeking and grants management it was actually an audit finding about reconciling our grants But I think we can do that through a much cheaper like project management add-on within our finance system And we really before we're chasing any new grants for new projects as I've mentioned before We really needed to get a lot of blocking and tackling in order and then we could consider that so that'll save Some funds that could potentially be reapplied to this process. We're looking to claw back some of the consultant fees For this the reconciliation project. Hopefully we can apply to this piece We've also been in contact with our bank that we have all these accounts at that does all the sweeping pieces Because our you know, our bank can play a big role in this too on making their report outs and the matching the reconciliation. So what assets can we use within our banking? Arrangement to help us attack this and it's gonna be kind of an all hands on deck approach And you know, I apologize. We haven't gotten here sooner. And all I can do is promise that you'll have my every effort, Chris's every effort. I know Ashley, hopefully with the new arrangement, she's just got so much of the day to day to make sure that the ship stays afloat, that hopefully this is going to give her the space she needs. I mean, she was doing some stuff with some technology changes, like the incredible manualness just of the payroll process is intense but you know it's it's what I love about this finance department too is they are very mission driven trying to create a best-in-class system under very difficult circumstances and always like hey how can we do this better how can we do a new process let's like every single person in that finance department is just top-notch high degree of ethics, high degree of competence. It's just a resourcing and a catch-up on I don't think probably it's probably since the day Tammy Moat left, maybe that lasted a couple months later, but it's really been six years since 2020. As Nate has mentioned that the city is like closed out a month and been live reconciled to the month. It's probably six years since that's been happened so we're always playing catch-up and to me this isn't just for the finance department but myself personally in my leadership journey here in Ellsworth this is like the final piece I just stay here for a lot longer but this is the one piece as I've mentioned before worth and you can truly Mary Poppins head and say leave with my umbrella and my little satchel and you know everybody will still be in really good shape but this is the one piece where I just I don't see the path of clarity yet but we'll we'll be getting there much Great. [43:35] Speaker D (unidentified): Pat, did you have anything else? [43:38] Speaker C (unidentified): I just kind of wish that probably the same goals that the two of you and everybody else here, is if those programs would all talk to each other. That would be a perfect world and it's not going to happen. You know what I mean? [43:53] Speaker A (unidentified): Oh, there's so much. I've seen it. [43:55] Speaker C (unidentified): My wife used to work for Maine Revenue Services and they brought on a new line program to take care of income tax 1040 you know and it didn't mesh and they work through it and they work through it for quite a few years before they worked out all the most bugs I guess now all the bugs who worked out of it but I remember her coming home and it's like oh it's just a huge pile and it's you know it's hard you know you do we do on our individual cells we do a budget okay and what's hard is not sometimes certain things don't get cashed or paid or you're not getting it on your statement and then you're digging around to find this stuff yeah i wish it was as easy as then you multiply that by a million times and that's the government okay multiply that by a 20 billion you might have a county budget you know county financing and it just goes to infinity yeah I think what we [45:21] Speaker A (unidentified): have going for us to choose we do have the people especially enough by 25 the people that are here now were in FY25. So they, because in many ways it's kind of like a treasure hunt where you're just, or you know, a mystery you're trying to solve on like, what is this piece? I keep seeing this thing that happens every three weeks and it's like, oh, that's that blankety blank from that system that hits that system at this time and it creates this little, and then you solve that and okay, now I've solved for this piece, move it forward. You can solve all those pieces of it. So, we actually do have a lot of internal, I think, resources and skill that'll help us there. But to your point, yeah, I wish more than anything we never went from munis to gazelle in the middle of a budget cycle, how that kind of broke. But that's the system we have. I've been a part of a couple of reconciliations with the unemployment trust fund. That was a $2.6 billion reconciliation that numbers that kept getting sent out to the feds were like off by a hundred million dollars or more to what our internal numbers at any different time and every time we try to capture that like what's the difference between these two deltas it was like impossible to figure out it was a two-year process with multi consultants of some of the best in the world trying to figure that out and it's just a giant pile of Excel sheets that you're trying to make a line to each other but I also as Chris mentioned, too, and Gus, he's such an optimistic person, and I am as well. Like it's kind of exciting because you get to get an MBA in municipal finance through this process. I think one of the nice things about when we had a budget that was just Microsoft Word documents and random Excel sheets from departments and like that niceness of that process for me was getting to know the finance team, six weeks of just, you know, hard-nosed, figure everything out get an input in the system and now you know I'm sure it'll be complicated but you know I've a lot of confidence in our budget processes now and how it'll move forward to the next cycle so this is this is the real big last piece and I'm pretty excited about this is big steps could [47:29] Speaker D (unidentified): exactly we have enough time anyone from the public have any comments right [47:39] Speaker E (unidentified): Raymond Williams 56 Hancock Street the only the only comment that I have to make it basically it's a request that I've been I taught have talked to Nate before happy no I don't know if I asked him before he left or anything but I've had some conversations last spring with Ashley about it and then I've even mentioned it to Chris and it's these monthly reports that Nate started putting out and I have what I checked sometime over the weekend so I would have anything that came floating in on Thursday or anything that even though City Hall is theoretically closed, there are people floating around that are doing some people in here working on Fridays because I've seen stuff comes popping up on Friday or over the weekend on the city about certain things, which I have a problem with that, but that's not what I'm talking about today. So I checked to see on the finance page the last monthly report on there of expenditures and income and everything, and you know what I'm talking about, the big thing, is May of this year. There's been nothing. And the previous one before that was March of this year. And I've had, and I understand, you know, I had discussions of this with Ashley and also some other things in the business, But I think that at the last one of these meetings that Chris mentioned that he had sent a monthly report, and I don't know what month it was for, whether it was for June 30th at the end of last fiscal year or whether it maybe was for the July or August in this fiscal year, had sent counselors copies of that report. And I realize that there are problems with that report as it mates it. But I think it can go to councilors. It can also be put on there and sent to interested people. And I'm an interested person, and I've talked to Chris about it, and I think in the past I've talked to Ashley about it and asked about it. And I think that I know what some of the problems with it is, and I've had talks with Nate about those back there and brought some of them up here, is that they added up in each department, they added the income at the top and then the expenditures, and everything was added up to a crazy total at the bottom, and I realize that problem's there. But I have certain accounts and things that I want to look at and see what's going on, and I know what I'm looking for, and I know where I think the major problem to that is. I think it's a good idea that it works, but I think you've got to start doing it. And I realize it's probably to some extent tied into your whole reconciliation problems, but I would basically like to see a printout and placed on the page for June 30, 26, which is the ending of fiscal year 26, and then I can't believe that you are not in a point. this is the nearly the end of the month of October that you also do not have available and to put online the printout for fiscal year, whatever one this we were in, 27. Is that what we're in now? Yes. Fiscal year 27 through September 30 of 2026. So that's just what I think those should be put on. And I realize that there are problems, but you actually have actual figures you know what you I hope you know what you printed out from what you've been paying out for every month and that you were able to have those figures available at least thank you thank you [51:41] Speaker D (unidentified): right so [51:44] Speaker B (unidentified): I have not been preparing those reports because two of the major projects I've been on one that Charlie mentioned is the payroll so we have discovered that paychecks the payroll company that we use their general ledger report that I print out I have to go in and manually basically remap everything and it takes about eight hours a day like just to go in and do it [52:11] Speaker D (unidentified): and eight hours a month or no a week just to go in and remap and then I have [52:17] Speaker B (unidentified): to input everything to the scent that we've paid like federal taxes Social Security, like everything that we've paid out and the employees as well for their benefits and then I have to get it to total out. That's 200 and something thousand dollars a week and if you just type in the wrong amount just once, you're in there another eight hours trying to find that error. error. So Nate and I from IT have been working on a program to streamline that process and we're close. It's not ready but we're close. Once I get payroll done, like I said that's the major project I've been on, we will be able to have those reports again. I just don't feel like I can post those reports online with such a huge chunk of money not accurately being available because those accounts are way off currently. [53:15] Speaker A (unidentified): Yeah, and to the point about the council being provided, that was at a finance committee meeting. I'm pretty sure there was printouts here. There was no intention to just provide them to council or not to provide them to somebody else. [53:28] Speaker B (unidentified): Yeah, it was for a finance committee meeting. It was for a finance committee meeting. [53:31] Speaker A (unidentified): We can do some moving forward now. I'll bring it up with Chris on the next finance committee meeting on how he wants to handle this. I think there's one aspect of me that's, you know, until this reconcile piece is done, until those errors are rectified, you know, there's going to be inaccuracies in those reports, and I wouldn't, you know, feel comfortable necessarily producing them as gospel, or maybe there's a caveat at the top that we're still reconciling these, and there's no, and obviously for June 26, that's the final closeout month, so that's when everything has to be towards to move into the next cycle so but let's talk to Chris at the same time like you know if it makes people feel better that they can see the reports that nobody's hiding anything with a big caveat that they're not good data and that we're trying to solve that reconciled piece with the payroll I don't necessarily have a problem with that but I'd want to talk to Chris before I made any promises there when [54:31] Speaker E (unidentified): I would just want to note that when was your last finance committee? It was a month ago, wasn't it? There hasn't been one mid-month, I don't think. [54:42] Speaker B (unidentified): We didn't have one two weeks ago because it fell on a holiday. [54:45] Speaker E (unidentified): Oh, okay, that's right. So the last one was a month ago, and that is when Chris made the statement that he had sent something, one of these monthly things, to council members, but there was not a copy of it present at this meeting on the 28th of September. [55:04] Speaker B (unidentified): I would have to look to see when I provided those reports to him. I think it was not last. I don't think it was last month. I think it was the month previous to that. But I'd have to look. I don't know exactly when it was. [55:17] Speaker E (unidentified): I think I have been to most of the last finance committee, and there has not been one. and the Latin and I couldn't say the date but I remember looking through a hard copy with the well but you know you would have been being city manager you would have you would have got it the council has got it and I don't know who [55:35] Speaker B (unidentified): else got it online how about I email you the last report that we did that Chris would have sent out counselors I can email you that report okay yeah I'm [55:47] Speaker A (unidentified): I'm happy that 's fine. Let's talk to Krista before we put up some public information that may be knowingly inaccurate. I think I have a problem with doing that. As much as I'd like to be transparent about all the data that's out there, I also don't like to knowingly put out inaccurate information, so. [56:09] Speaker D (unidentified): Anything else? I was just looking through, okay. All right, see you all in two weeks. Two weeks. [56:23] Speaker C (unidentified): Good work, I know it's not easy. [56:25] Speaker A (unidentified): Oh, it's the fun stuff.