Submind YouTube summaries
Thumbnail for Finance Committee Ad Hoc Budget Document Subcommittee Aug 28, 2026

Finance Committee Ad Hoc Budget Document Subcommittee Aug 28, 2026

Watch on YouTube

Video summary

The August 28th meeting of the Finance Committee's ad hoc budget document subcommittee was dedicated to refining the town budget based on previous feedback, with a primary goal of making the document more digestible, transparent, and structurally stable without increasing the overall workload. To achieve this, the group agreed to relocate critical data tables regarding staffing, reserves, and debt service to the front of the document while condensing the executive summary. They also considered removing or moving the lengthy letter from the Town Manager and budget guidelines to an appendix to reduce bulk, alongside implementing internal hyperlinks within the PDF for easier navigation between departments. Significant progress was made in enhancing financial transparency and simplifying complex reporting structures. The committee debated adding indirect cost rates or charts to the executive summary to better reflect total departmental costs, particularly regarding health insurance and pension benefits which are currently allocated rather than directly tied to specific departments. Furthermore, they decided to consolidate facility costs into a single "Facilities" organizational unit instead of maintaining separate accounts for each building, thereby simplifying reporting for department heads while ensuring external state Schedule A reports remain compliant. Additional structural improvements included expanding the grant section to clearly distinguish between general funds, special revenue funds, and revolving funds, as well as providing more granular breakdowns of operating expenses through uniform tables. To further streamline the process, the group committed to creating a consolidated spending table that links key challenges directly to the budget, developing a template for a staffing trends report using historical data, and generating detailed line-item revenue and expense reports modeled after formats used in other municipalities like Northampton. The committee adopted a pragmatic "live with" approach, accepting these significant changes immediately rather than waiting for annual overhauls, while acknowledging that minor tweaks will continue to occur each year. This strategy aims to replace existing clunky charts with clearer data visualizations and group key tables on consecutive pages to facilitate easier printing and reading. The meeting concluded with the establishment of a new timeline to ensure these enhancements are implemented effectively; the revised report is scheduled for submission to the Council by September 28th, allowing for a Finance Committee review on October 15th. While some proposed changes may require time to fully implement, the subcommittee remains focused on delivering a stable and accessible budget document that addresses community needs without disrupting current operations. The session ended with no public comments and a formal motion to adjourn, leaving Sean committed to drafting the necessary report for the Town Council by August 8th for subsequent review before forwarding it to the Finance Committee.
Read the full video transcript
continue. All right, you're good. This is the August 28th Finance Committee ad hoc budget document subcommittee. Um, so I will call on everyone to make sure they can hear me and be heard. Um, Kathy, >> yes, here. >> Councelor Breivik >> here. >> All right. And we have Sean here as well. >> Mhm. >> Great. Um, all right. So, we are called to order at 10:00 a.m. Um, how I don't know how folks want to proceed though. I I actually had to go back and listen to our last meeting because [laughter] it had been so long since we had met. Um, and it seems like where we left off was a whole long list of items that Shawn had that you were going to report back to us a bit about on those and whether they were, you know, feasible, um, whether they were going to add work, help things out a little bit. And then I had followed up with the charter review folks and Kathy, you had sent out another message to counselors. So, we sort of had those pieces to bring back together. Um, and then I just wanted to ask like time timelinewise, where are we hoping to be at the end of this meeting? Like we need to report back to council um and and submit a report. I'm just not 100% sure on what our, you know, where we need to be at the end of today. Yep. Go ahead, Kathy. >> Um, you know, just on responding to that, Kathleen, um, not on the earlier part, but in theory, we were supposed to report back to the council on the 31st. Yeah. So, but we can postpone that final date. So, you can you can write a very short email. >> Okay. that says um you know or you can make it an attached document for for that says um we've started meeting we have some and then when we finish today some thoughts >> okay >> but we need to bring it back to the finance committee so we're asking for an extension >> okay all right >> can I just add too that that 31st meeting is not a not a regular council meeting anymore anyway so it was um turned into a work session on Hampshire College. So, we wouldn't have been able to present at that meeting anyway. >> Okay. And then we won't have a finance meeting until the 15th. So, we can bring it to finance then and then subsequently to the council, >> right? So, we could um I don't know whether you have the council schedule, but we could expect to Well, Athena here, so I'm just looking at council. Um council meets on the September 28th. So, we could say we expect to be able to report back on the 28th. >> Okay. Yep. And the idea is that we would submit that I would draft um a a short written, you know, a written report with some of our conclusions and suggestions and our process and then we would we would bring that I could bring that to finance on the 15th and then look at it with everybody and then from there go to council. Does that sound right? >> Yes. >> Okay. and just let me know. I'm here as your backup to review or work on the draft. So, just >> Yeah. Yeah. Yeah. We can do that. We can work on that together. >> Yeah. Feel free to send it to me like just a, you know, a few days before the maybe before the finance committee meeting. I can take a look at it. >> Great. >> I thought your recall on where we would be today is is sort of in Sean's lap. And what I can't remember is way back at the very beginning of this I sent in some thoughts and and and it was around and I don't remember whether I ever shared it with the two of you. I sent it to Sean, you know, but it was like what things could potentially be in the executive thing and we did talk about it. We talked about it verbally and which tables I thought were particularly important and what tables might be missing. And then the other thing Sean had asked us to do is to go through the departments where they give that very detailed list of activities and he said that's time consuming. So >> identify those that we think are useful and I did that in that very first thing. So just as a refresher um >> Yeah. Yeah. And in our last meeting we talked about that document but I can't swear that I've actually seen that document that you drafted. So, if you could forward it to me and maybe Jill, then we could um I could make sure that you know that the details of I have the general sense from our verbal conversation, but I think maybe you have some specifics there that would be helpful. So, >> yeah, I did do specifics and >> Kathy, do you want me to see if I can find it quickly and send it to the group? >> And I sent it, you know, sort of shortly after that very first beating of ours, so in July. >> Yeah, I'll take a look for it and send it out to the group. You may have said I mean this this summer has been kind of a black hole. So >> well and and the the thing I tried to do when I said table I said the table on page X you know of you know so um sometimes I couldn't say page X because no there were always a page number you know so you know examples are things the count of employees. >> Yeah, >> you know they were pretty obvious kinds of tables to and they were things that I always searched for. where I knew they existed, but the current indexing and Mandy's one comment um one overarching was to the extent there were page numbers listed at a minimum, you know, she was sort of looking at when does uh safety start, you know, where is crest, you know, just and Sean had just talked about how because it's a collection of PDFs, it's difficult it page numbers after the fact, but it's difficult to index. And I don't know I don't know the capacity of word, you know, and the thing about the PDFs is they've got graphics in them. >> Yeah. >> So that also doesn't uh he just sent it to everybody. >> Oh, great. Okay. >> So anyway, that's what I did. I I would responded to as specifically as I could. And the one thing I noticed in the charter comments you got, >> yeah, >> I can't think of an easy way of addressing this is some people found it difficult to have to look at a capital plan report and you know capital is not buried in the current budget book. just shows up as total spending and shows you by cash versus debt exclusion, but it doesn't show you a list of projects, you know, and you know, so I have no idea um how to rectify that other than to make sure there's a hot link in a document because the capital plan gets way too detailed. And the thing about that is in the report since I'm on all these committees, the debt service schedule is in the report, the main report that drives a big chunk of capital spending every year. You know, how much have we already committed to is sitting there. Um whether people find it because I think it's the last page of the report, Sean, you know, so it was one of those >> and the capital plan is linked. Um that was one of Paul. So when I update you guys on the different things, Paul that was one of his comments was I mean we can add the school budget, we can add the library budget, we we link to them because they are in themselves long documents and if we add the school budget, you know, we'll go from 200 pages to 300 pages and they're different formats because they're different elected bodies that have, you know, kind of decide what format they want their budget in. So, it's it's going to be it's not I don't think there's ever going to be a way where we can force the schools to develop a budget in our our format, nor would we want to be forced to develop a budget in their format. Same thing with the library, right? Um but we could certainly add them as an appendix, but right now we just sort of link them. Um thinking that's probably the easiest. >> So, what I mean I I went to the charter folks, there was not substantial feedback in terms of anything specific. It was very general. And then Kathy, you had gone to council and it sounded like you got we had I know I saw the feedback from Mandy. There was no additional We don't have we don't have new information to bring to this group today, right? >> No. Sam sent comments right at the very beginning, but most of him was say was saying how much he likes the report. You know, like don't don't mut what he thinks is a very robust report. Um, >> yeah. >> And >> so, so what makes sense here today is Sean, do you wanna, you had left with that list. Um, Sure. >> Do you want to start with that and sort of tell us what what thoughts you have on those items and where we should go? >> Yeah. And let me um Jill, I don't think you were at the last meeting, so let me just quickly go through like the highlevel items first just to recap what are the major areas and then I'll I'll give the feedback on each one. So, um, the first high overarching recommendation was to relocate critical data. Um, you know, moving things forward to the executive summary, that kind of thing. Um, the next one was to condense the executive summary, making it easier to digest for the public, maybe not having, you know, the letter from the top manager in there, things like that. >> Um, third was to expand the grant section and include more information. Fourth was to have more detailed line information on the budget pages about you know more specific expenditure breakdowns. Um five was a consolidated spending table um for each department so that when someone looks at a department they can see general fund spending, capital spending, grant spending kind of all you know one spot. >> Can I just ask you on that would you be able to show >> pension and health insurance also? I mean I don't know that because it's because it's an >> we could and we used to but it's just an allocation. It's just an like we don't directly tie those they have a you know they're we have a health insurance account we have a pension account. So the only way we would do it is we'd say what are the salaries and then break it down proportionally and you know it wouldn't actually reflect do the people actually have health insurance in that account or it would just be a an allocation. So, um, we could do that, but it it it's up to you. Well, I think we have to talk about the value of it, I guess. >> So, so while we while we're on that, could you if you can't do that easily and it's particularly difficult, >> not hard. It's just is it meaningful because it's >> well the only thing >> not truly the cost associated with that department. Same thing with pension, right? a department might have um you know more or less pensionable employees or more >> just that if you have a $700,000 department and there's another $400,000 in health insurance and pension everyone thinks of it as just that little slice because they can't see it. So, and I know the um it varies because not everyone is p is benefited first of all the if the hours below 20 and health insurance it's it's a real challenge because it depends on what kind of plan they picked you know both individual or >> Yeah. And we wouldn't want to be we wouldn't want to get to that granular of a level um for budgeting because then that would be like budgeting each department's health insurance separately and we don't do that. >> Yeah. No. And that's too but you do do it for the enterprise funds. So I don't know if people have looked at it but when you do enterprise funds they carry the costs of the pension and the health insurance. So you can see benefit and it's just so you know if there's any way even in the executive summary where it's not specific it says on average >> of >> I mean we could give you a a cost uh a indirect cost rate for example I mean for every every dollar of of benefited salaries you know it's a 80 cents for health insurance and and pension we could easily give you that >> or you could just say adds you know adds 45% or do it you on average it adds. >> Yeah, we could definitely do that. >> Okay. And so it's just one that it's you don't see the total cost of a department when you've excluded something that adds I mean you can really see it in the enterprise funds. I think we're up to it adding almost 50%. I mean this is not a small ad >> and I'm just doing the whole thing workers comp and there's but the two biggies are health insurance and pension >> you know and then the so just when you're doing departments and schools the schools what we the this is mainly the elementary school the elementary school we carry the pension costs of the the the people who aren't teachers um you know the the non-eing And then we carry the pension cost for the library. And again, we've been getting those in the finance committee. And so it's a sentence in what was a 29page report last time. You know that by the way, you know, and and it's just because they're big when it's at $2.5 million. Um you don't see it in the school budget at all, you know. >> Yeah. But but similarly, you don't see it in the in the town budget, the town operating budget either, right? I mean there's so the way I like to think about it there there are some costs that are kind of off the top and pension is one of them oped is one of them state assessments um >> right so you don't see it embedded in the things but >> you don't see it in any of the operating budgets >> well in your municipal budget you do show where does pinch it does show up oh no it's a line it's a line in >> yeah because remember that that's not up in the operating right so the school operating the library operating the town operating I'll stressing. >> No, they're they're all treated pretty equally in terms of the costs. You know, the only thing that's really changed over the years that was a a decision by the town and, you know, to support the schools was the schools used to have to um budget for charter and choice and then we we stopped doing that. Um we we pulled charter and choice out and just kind of funded it through the state assessments. Um, so that that was kind of the last big structural change that was made. >> And we pay the town pays the charter assessment for the elementary school, correct? >> Yeah. Yeah, we pay it's part of our state assessments and then the town keeps the uh reimbursement, the reimbursement goes into the general fund as part of the overall picture. >> Okay. Councelor Breick, you had your hand up. >> Yeah. Yeah, I just want to make sure Sean, do you to to apply an even percentage like we're talking about, do you feel like that runs the risk of being more misleading in terms of >> percentage for um >> for benefits of the pensions? >> I think the percentage or or flat dollar amount I I mean it all depends what you're looking at it for. So we do provide that data in one of the financial indicator charts. We show like the percentage that benefits is of total salaries. So you can as sort of a trend over time. So you can see that it's basically growing as a as a percentage of you know salaries over time. Um and yeah I guess it it all depends who's using the data and for what purpose. Um I think it it's we can accurately say you know if our health insurance and retirement costs are $10 million and our salaries are hund00 million for example that you know for every dollar of salaries there's 10 cents of benefits or something like that. Um, and then people could do with it what they want. But >> so we Oh, go ahead, Joe. >> But if you're not tracking it by department, it does it runs the risk of being inaccurate and then and then one figure that I know. Yeah. And I just don't know how much if people will like easily understand that >> again the data it may be better in like the financial indicators presentation which is more planning and higher level and then again folks can use if they you know I get Cathy's point Kathy wants to be able to say the police department doesn't cost $5 million it costs $7.5 million right and crest doesn't cost $800,000 it costs you know 900,000 so I get wanting to understand the truth true total cost of a department right um so we can certainly provide that information but just I think your point is because we don't budget that deep I mean we do budget we know who gets it but in terms of our accounts we don't budget by department we budget total health you know total HMO plans total PO plans that kind of thing >> right so then maybe it's just making really clear that it's an allocation just getting a clear note >> they used to do it I mean it was it did that they did an allocation like that in the old town median budget books >> town meeting used to have it as a last couple pages, you know, just so you could see it. So I'm less I guess I'm less concerned about the department level and more so in the executive summary which we're shortening if that chart on benefits could go in there you know that you already have for indicators because the the issue for me is because of what's been happening with health insurance. It eats up >> it's been eating up almost half of our three and a half% revenue growth. You know, so giving people the public and the council a sense we think we're getting 5 million more a year or three and a half or whatever the number is. The projection and health insurance is about to take half of that is is is something people have to keep in mind when they're talking about um where the the crunch is coming from. >> Right. Okay. Well, re related to this, I was curious instead of having some of this detail in the departments, is there any benefit to having more detail in the employee benefit section? Like is there is are there any natural ways in which you do break down that employee benefits information that would like would it fit there better? or are there, you know, is there is there work you're already doing or buckets that it's already in that you could show us? Would that help at all? >> Yeah, I mean, I think we talked about getting rid of the staffing charts in the budget pages because, you know, they're not particularly informative and maybe replacing them with a different type of chart that keys in on a, you know, an important variable for that department. And so, um, you know, that chart we talked about percent benefits as a percentage of salaries might be a useful chart to put on the benefits budget page, um, for >> and the issue right now, Kathleen, I mean, I think that's in my my suggestion sheet, but pensions is under assessment and health insurance is under benefits, right? We we have two things in very if you want to find pensions you have to know that's called assessment and you have to you have to know that to find it because the first time I opened the budget book I thought benefits meant >> health insurance pensions and everything else and I said where where's pensions and it's just because it's funded in a different way. Um >> and then OPED is a similar thing and we know we know from the meeting um that you missed Jill um when we were having them explained is that there's a point at which the assessment for pensions going to drop dramatically and then OPED may go up during that time period but once we once we get to fully funded we still will have expense but we're not funding anymore you know so there's a different stream. So there's there's a benefit, but that's in a 10 that's a 10 year and fiveyear look. So I'm just saying that they're in two different places right now. So there may be >> a clever way with a chart in the executive summary or a chart leading. >> We could also do we talked about a more robust staffing section. So the staffing section could be like staffing and benefits, you know, it could have the FTE charts um and it could have the benefit information. >> Yeah. And then we also talked about how there's certain items that you know might might be in the presentation versus the budget book. And it may be that these are naturally completely separate sections in the budget book, but maybe there's an opportunity in the budget presentation to pull something together that shows all the benefits or you know just if if that's like an overarching question that people have um you know some things may live more naturally in that presentation than in the book itself. >> Yep. Yeah. Yeah, because there might be a year where health insurance is not a big topic. Hopefully, knock on wood that year will come soon, >> right? Yeah, it gives you a chance to highlight what what what's bubbles to the top that year. Um, so this was number five on your list that we got off. Um, do you want you want to continue with your >> Yep. Um, number six was highlight key challenges more and connect them to the budget. So that section and for departments um number seven was staffing trends report as we mentioned having something more similar to the schools that's right now we kind of give a a highle table but um and this would be I think at being more position specific eight was condensed revenue and expense reports with more line item detail similar to Northampton. So I it's basically the munish report that Northampton uses that gives a little more breakdown of revenues and expenses. Um and that's what I got. So I don't know do we want to start back at one and just see kind of go quickly each one and see if there's more discussion? >> Yeah, I think that would be helpful. >> So the first one was relocate critical data. Um so in terms of effort that's easy. I think the hard part is making sure that whatever we relocate is kind of like a shared everyone agrees, you know, um that that's a good thing to move, right? Because I think this is an area that could be kind of specific to the reader. Um, so you know, I think what we would do is we would look at your what you've provided Kathy and any other feedback we receive and then make a decision whether we feel like, yeah, that's a good thing to move for everyone or if we felt like it was maybe too, you know, issue specific for that year, we might not move it because we're trying not to we want the budget to kind of the structure to be stable whatever we move it to going forward. Um, but I think we're definitely open to moving things that are are helpful for folks. >> So, Sean, in terms of that one, like you we talked about Kathy's list. Do you feel like you need more information from this group in terms of relocate critical information or do you feel like you've gotten >> I would just suggest look at Kathy's list and if you totally agree with everything in her list, just send an emails um that effect and if and you could even send it just to me. I just want to make sure, you know, to avoid any deliberation. Um, and if there's anything in addition that, you know, or that you wouldn't do, you can include that feedback and that way I can pull it all together. >> Okay, [clears throat] great. >> So, I have a just a, you know, I'm I'm pulling mine up. >> Yeah, go ahead. >> But I did things like I gave key tables and so you'll see it in my first thing. So consolidated bundle, cut town staffing, long range financial outlook, pie chart showing the share of budget, reserves, assessments, debt service costs, you know. So I went down and said here are the pages of each. So it wasn't a huge list. The one thing I think I added, Kathleen, because you've asked about it more than once and to the extent we can find it, it's buried is the ambulance fund. >> You know, if we have these financial, you know, so it was the grants. So just on this, I had this vision of a short executive summary followed by these tables so that if you uh saw the first 10 or 15 pages of the budget book, you would have uh take you know a take-home kind of message and you'd have key tables. So that's when I went through it. I think total revenues, the allocation by departments. So that's what that was my thinking about moving them out of wherever they are. Um and so we just came up with staffing and benefits, you know. So it's it's a so I didn't know whether on the executive summary, Sean. Um right now it's got the town manager budget message which is like 17 pages long. Uh, we put all of the G goals and bud budget guidelines in there and you get the reason I'm looking is you finally get the spending summary on page 31. You know, I mean, you don't get to and then the other thing it has uh in it that I know was, you know, a guide to how to read the budget, you know, go here, go there. So, I don't know what your think your and Paul's thinking was um about how to shorten it. Yeah. No, I think definitely move the letter out. I think that's something we can do. And quite frankly, shorten the letter. The letter is one of those things that um gets a little longer every year, kind of like the budget guidelines, and every now and then you got to prune it, I think. And so I think we're at a place where I think the feedback we're receiving is maybe it needs to be pruned. Um and the um so we can move the letter out. I think we certainly can move more charts up. the you know the original intent was there's that budget in brief on the inside cover that gives you like the very high level overview of the budget the first page and total budget key changes yeah so we can keep that and then we can shorten up that executive summary to you know five pages or whatever might be >> people aren't I'm sitting here paging through but this is this kind of a thing where you you know see the whole budget and then it's got a list of big things that you might want to know about and the extent people read it by turning over the first cover to [laughter] find >> hope. Right. >> If you're reading it online, you definitely find it, you know. >> Yeah. >> So, um, so yeah, I mean, we're Yeah, we can do that. I think we just have to give some thought. I we've spent a lot of time trying to kind of clearly articulate how the council's goals tie to budget decisions, right? Um, and we just have to think about I we don't want to lose that. I don't believe, but we can pull some of that out of the executive summary. >> And and some of what I thought just so in my the memo that you I didn't share, I guess I should have shared it right away, but is it's not that I don't find that useful, it's that I'm thinking maybe it should be in an appendix. >> Yeah. >> You know, um because it it takes so many pages. Um but since some of what we have one voice who comes to the council meeting regularly saying that the town manager did this that or the other thing and often it's driven by council decisions. It wasn't the town manager often >> in his cave making a decision. Um, so drawing attention to the fact that there's been key points where the council has said what we want the manager to achieve and we've done budget guidelines, I think is useful. It's just it just bulks it up so much. Um, >> yeah. No, again, we could we can think about how to um make a section on on goals and budget guidelines, things that shape the budget. Um, and maybe it's near closer to the back. Um, so yeah, I think the, you know, one overarching piece of feedback that Paul gave and I agree with is we don't want to and and we talked about this last time, we still want the document to kind of conform to GFOA. >> Yeah. >> Uh, best practices around what's what's in the budget and what's not, but I think you have latitude to an extent about where it shows up. Um, we've always tried to, you know, there's usually four sections. You have um your executive summary. You have a um organizational section that describes the organization has the org charts how you know why things are the way they are. That's where a lot of your guiding documents are. Then you have your financial section and that's the meat of the budget with all the the numbers. And then at the end you have your organ umformational section where you just provide data that um can be useful. So there's those four sections are sort of the framework that GFOA and you know uh uh MASBO which is the school budget organization um recommend for how you structure it but even within that structure we you know we can move things around quite a bit. >> Yeah. Oh go ahead Kathy. >> No no you go. you. >> Oh, I was just I was just going to say that it may you know that it's great to have all the information about the council's decisions driving the budget, but it might actually be I don't know if it's at all possible, but it might actually be helpful to have within a department page something that says, "Oh, we added and I think you do this to some extent already where it's like we added these staff to meet council goal." you know, I mean, so that when you're looking at the fire department, you you there's no mystery as to that that's the staff have been added. You don't have to remember it from or have read the, you know, more dense narrative section elsewhere in the budget. You know, that information is there. It's just maybe not in the same place. >> Okay. >> Yeah, I [clears throat] feel like you see that sometimes and it's one of those things that you just wish I wish I saw in every section. I think that's right. And yeah, if there was a category or something that was required, I think that's >> Yeah, I think that that's and and Sean, the what you just did of the the general GFOA, I like that organization a lot. So that info section can be the dense tables. And so for the table nicks amongst us, you know, you know, it's just right now our info section is throughout the whole budget book. Um, so just when you're thinking about it, what And I I really do want to make sure this becomes easier rather than harder for you. >> Yeah, I get that. >> You know, so that if they're tables that you're naturally producing anywhere or that can be spit out of a system because Excel has got them all. >> Yeah. >> Yeah. So in any case, that's just my >> Okay. >> So I think these two first two, this one and the next one condensing the executive summary kind of go together. Um, so moving the more critical tables to the front and moving some of the the, you know, fluff out of the executive summary back. Um, and people can read it if they want to. >> Yeah. And also, I'll just say like having these tables all together. One person mentioned to me that it would be nice to be able to print like the things you want in color all together and then not have to work, you know, and then a lot of it you could just print and buy. So having tables on consecutive pages or in one section that you could then print it all in color and look at it nicely. You know, >> this is this is what I've been doing is literally finding the page I want, printing a page so that I don't have to find it again. Um and uh yeah, so and then I stick it in the cover of the book. >> Jill, Bill Jill, go ahead. One other thing on format and this maybe is not possible but something that a resident has brought up to me several times is having access to the numbers pieces in Excel >> and I know you can't share it in that out in that format but I don't know if there's if that's just maybe food for thought or there's any way to make it such that people can play with the numbers on their own. There are folks that want to do that. I know. I'm [laughter] um yeah, let me think. I mean, we can download budget reports um and that might be something we can just post online or something like that and then folks could grab it there >> if there's a table section and it's not overly formatted. Adobe now lets you go from PDF format to Excel, >> right? But but it loses everything if you've copied a picture in, you know, as opposed to uh import, you know. So there's Yeah. Having struggled with how do I take the table back to a table that I can >> Yeah. >> manipulate. >> No, we can I think one of the later recommendations is the is a report that would probably be something we could make available in Excel and it would give I think a level of that detail. All right, expand grant section and include more information. So, I think um I think the key here really, and we talked a little bit about this last time, is just um I think I definitely agree that we need to to spend some time on our grant section because it's even in the development of it, it's a little bit clunky and I think it's just a section that when we built the budget document, we didn't um you know, it was dep prioritized overall. Um, so I think we definitely need to spend some time there. Um, and I think just having more information about what would, you know, what is the information that we need should include and how, um, we can make sure we try to do that. >> Did I just speak to that or maybe the Kathleen? >> No, go ahead Kathy. >> It's never been clear to me and I'll just use one department or I'll use police. Please have two people funded by a contract and I and unless you go to the listen to them talk about it, it's it's a contract that we don't pay for. That's one example. Crest for a while had a person paid for by a grant. So I never knew whether the count of people >> in Crest included the grant-f funded one which was a precarious >> Yeah. position. So just two two quick distinctions there and and I think the staffing if we are able to do the staffing trends report the staffing trends report breaks it down between general fund grants and revolving so that would um I think resolve that right now we do I think we give a grant number but it's not by department so you wouldn't >> but that would be like what the schools do then you can see some positions are completely funded by >> Yeah exactly um and then but I do want to just uh make the point So, the police have a contract with an outside agency. I know it feels like they're two people that work for us, but they don't work for us. They work for the agency. >> Crest has somebody that we hired that actually works for us, and they're funded by a grant. So, it's it's um just a different >> They're really different. >> Yeah. >> Yeah. And at the time that you're producing the budget book, because the grant section as it exists now, like it has a time frame, right, of like these are the grants that we and and they have sort of a start and end date per grant, but at the time that you're producing that, you you don't necessarily know all the grant money that is going to feed in for that year, right? So that makes it challenging to say we might learn later, oh this department had this grant, but it wasn't necessarily 100% known at the time of making >> a few recurring grants. So I think most time of grants we'll do like a what do we have now and then a look back but there are some grants that we you know knock on wood get consistently the um the big one is um our senior center gets a formula grant from the state and that funds part of a position there um and we've gotten that for several years in a row. So um most of the other ones are you know sort of specific to additional initiatives that the departments are working on. Um, but no, yeah, the time frames are always a little bit staggered because they're not all on the same time frame. Some are federal, some are state, and they have different ones. Some are private. Um, but we'll figure out a way to consistently share that. >> Yeah. I mean I just I think just to the extent that it's possible to give everybody the best understanding possible the total amount of money coming in from various sources and how it's being applied that you know I mean that's the best we can do you know with >> and I think what I've heard previously too is being tying the grant to the departments more clearly so what department is you know where are those funds going what department is use utilizing those funds And I'm going to give some thought to that cuz maybe it's even the grant section or the grants are with the departments as opposed to broken out kind of on an island. >> Yeah. And I think the way it's just the way that the grant fund summary is inserted currently in the budget. I'm not sure it's even searchable like if you search the document. So maybe that's just >> I'm sure that's just a pain to try to figure out. But >> it is. and and where do we so an example of the money flowing in is community preservation act. We have early on we I think even this time we funded part of a planning staff person out of it. Um >> uh >> yeah it to work with housing and other thing you know in terms of housing development and um it it funded it for Sean, you can only remember it funed. >> Yeah, it's been I think it's been three years and then they might have just done the next, you know, the next year of another three-year plan or two-year plan. >> So, when you're talking about the columns, there's, you know, there's grant, there's revolving fund, and there's CPA where CPA only occasionally picks up. We would probably lump the way the schools do it is we we'd probably include CPA with grants um or or so there's usually general fund grants and special revenue funds. So it might be we probably would do maybe more appropriate to be special revenue um for the CPA. Um and we have a few rec department employees who also have a portion of their salary funded with um with the revolving funds. And so they would go in that special revenue fund section, >> but we can um what the schools do is they put a little tag that tells you what what it is. So like for schools, it's like title one, title 2 A. They put a little description next to the FTE so you know what program is funding it. >> I think that's how Northampton has it in their, you know, in their it's in in their budget. it's in the departments where they will show that it's from a grant or it's from and then it'll just have a little explainer and I do think it would be good to have CPA >> either in special funds or maybe not as grant because I think there's a confusing yeah >> yeah there's just a I think there's just a misunderstanding sometimes that CPA is money from outside of our community and you know a portion of it is but the largest portion of it really is originating from within our community so to call it a grant sometimes gives people I think the wrong idea about what it is, >> right? Yep. Absolutely. >> All right. So, are we good on the grant part then? The >> I think so. >> Okay. Do you want to move on to is it the more >> Yeah. So, the detailed line information one. So, um you know, this would probably be the most amount of effort depending on the structure that we go in. So, I've been thinking a little bit about, you know, what level of detail that's more than what we currently provide. Um, and you know, based on what Jill shared last time in terms of, you know, what would be helpful. Um, so I think it's really just going to be a matter of can we get it done this year. Um, and working with the town manager to make sure that he's comfortable with it. >> And can you give me So there's salaries, there's pay. What else are we talking about? >> So I mean, >> we just said we're not doing benefits. So what what's the >> well operate the other costs? Yeah. >> Yeah. I mean it would be breaking down the operating expenses into a more um a more granular breakdown. So there's some things that all departments have that are recurring that we could look to have like a a similar format for. So um utility costs for buildings for example could be a breakout. Um dues and subscriptions um could be a breakout. Travel C. you know, we could have I could think of probably five to 10 types of sub accounts that would cover 95% of the, you know, spending and then we could have an other for, you know, those kind of random one-off things that are department specific. Yeah, I think the idea was map it to how you are already categorizing expenses internally and just you know and and maybe you do it do that in more of a level of detail than you need to present and you can group some things together >> or maybe the other way around but but just that it would like the idea would be that it would line up with kind of how you're already tracking expenses. >> Yeah. And I think that is like, you know, I definitely understand how that can be helpful. Like some departments have to pay a lot for utilities and you don't necessarily know that by looking at the operating costs, but you know, if you look at Jeremiah's facility budget, for example, you know, probably 75% of it is electricity, oil, and water um usage. So you you'd be able to tease you'd be able to see that more clearly um in this. So it's I mean it sounds like for this one there's pretty broad agreement that this is something worth doing and we might just put into our recommendations that we're you're going to take a look at it and some it may come in this year it may come in next year depending on you know it sounds like it's worth taking the time to figure it out and change it once and you know um yeah >> think through it and see what you know and and if that doesn't happen for this budget cycle to me it makes sense to to take the time to figure it out and then change it even if it's two budget >> cycle. And I view it as um and just to again talk through this, I I view it as um replacing some information that's already there. And I'm hoping there might be a way for me to do this in a way that actually might be time neutral. So, right now, the way this is kind of done is there's a a narrative in each section that kind of like talks about the breakout of expenses in the budget. Um, and that's kind of a clunky section that takes a lot of like formatting and it's easy to miss um easy to miss like uh costs, you know, a type of cost in there. So, my thought is this would replace that section and be uniform across all departments. Um, and if we can do it, you know, do it set it up right, that it might be time neutral or save us on having to do a lot of um, you know, editing if we do it right. So, >> so I'm hopeful on that. >> Well, and I I'm just paging through. So, facilities is a good example that um, you break down um, $253,000 in a pie chart with a lot of words. >> Yeah. You know, so if you just had lines, it it would save you creating that picture. >> Yeah. No, exactly. That's that's the section I'm thinking of. We would potentially get rid of and that would give us some space to do something else. >> And then some of these have kind of nothing under that line. Uh it has a huge amount under that. And then >> subscriptions >> and then it's mainly subscriptions. So you look at it, there's an entire pie chart to say almost all of that is pres you know. So it you add just one line to the breaking down and and that I think that makes a lot of sense because it also is a picture >> one less picture. So and then you know the uh operating capital versus very few have operating capital you know so just trying to think through Sean again making it easier for you that you're already tracking it that way. Um and the level of when you see do we need someone operating expenses do we might need to break down $10,000. So so a few people few departments have or 5,000 you know a few have >> yeah very small yeah >> have almost nothing. So >> yeah, we would probably apply the same again the same framework to all departments in ter that would be the most time um effective for our time and the reason is is because we have you know our accounting system is an org and an object. That's the two pieces of our accounts. The org tells you what department and the object tells you the thing. And so like you know for example office supplies is the same object across all departments, right? So, um, it it would be having those objects will allow us to kind of break things into these categories once we settle on the categories. >> Does Jeremy's department, Jeremiah's department now pick up the utility costs for the police building and both of our fire stations? You know, one thing we might do as part of this is um I think we should decide how we want to handle facilities because it's a legacy of um town meeting and just um decisions that were made a long time ago, but it's not consistent. So, so police facility is almost treated like its own department. It's got its own like section. Um, fire is in the fire budget and then fire operating budget and then all the others are like on a building by building basis that we lump together for Jeremiah's facility section. So, it's not done consistently, but it's done the way that the chart of accounts was set up a long time ago. Um, and we've been talking for a while that at some point we should pull the facility costs out of fire and the facility costs out of police and treat them similar to other um, and I'm we were trying to think is there any reason why one reason why I talked to Sonia and they they didn't do that was because they wanted to when you do the schedule A um, for the state you report on public safety expenses and so they wanted those public safety those facility costs to be in the public safety bucket and so that's why it's kind of treated separately. Um everything else is just like a general government like a lumped in a big bucket. So that's why it's set up the way it is. It's trying to figure out there's a way we can for budget presentation not do it that way. Um but for reporting we still make sure we report it properly. >> So is that is that the case with with Mson then too? Like the with the schedule a you report >> you report library separately, right? Like does that >> so Mson is technically >> the the Mson town? >> Yeah. >> Memorial building that the library rents space from, right? Library. It's not their building. It's our building. >> So any of their utilities there would be accounted for in their in their rent, I guess. Yeah. Yeah. And then it's like it would be great at like the way you have it now. Some of these facilities are broken out differently on the quarterly reports, right? Like you see the child care facility and you see and a you know or the Ammer whatever the one of the school one of the old schools is there. >> So it would be good as you're thinking through this maybe to have those two things match you know so that we see it in the budget and we see it on the report. Ideally, what we'd like to do is create a facility section that then has accounts underneath it for each of the buildings. So, you could have one facility section and it would roll up and you could see totals and then break into the detail if you wanted to. And that would make Jeremiah's life a lot easier, too, because instead of managing, you know, 10 different little, you know, different account numbers and things like that, he could have it all in kind of one consolidated format. But um it's one of those projects that's we just have to find time to do it >> and and we sort of see that in JCPC when we get uh um across the buildings. >> Yeah. um he's been given >> that's why we can give you that information because and one thing you'll see new going forward that we're doing now is and this might be the beginning of what I just talked about is we're going to create a new block a new org kind of like just for facilities in general not specific to a building and that's where we're going to put the Wildwood fund funding for now which will be the only thing in that section at this point and it'll that's what'll allow us to give you you know monthly reports on spend ending in use. But if we set it up the right way, that could be like the beginning and then we could add to it over time um as we transition, you know, away from having it separated the way it is now. Um again, you'd still be able to get all the information you have now, but it' all be have the same or as opposed to right now it has 10 different orgs and it's complicated. All right. [sighs] So, the next one I think we spent some time already on consolidated spending table. So, unless there's anything else, but um that's definitely something that we can do. Schools do it. >> Um highlight key challenges more connect to the budget. Um Paul likes that, thinks it could be valuable. Um and that departments, you know, would would like to share that. So, we just have to think about and it'll happen in the next month or so, how we pose that question to department heads. Um, and so I might bounce that off you guys through email before we send that out. Um, staffing trends report. Again, we have a template for it. It's just about time to do it. So, um, if you know, if we can get it done this year, we will certainly try to do so. Um, and it might be, you know, it might be the case that we set up the framework this year, but we don't go back historically and we let it the history kind of roll in over time. That's how we did at the schools. We kind of did the first year and then built upon it from there. Um, so if we can get some history in there, which I know would be helpful, we will. But I think we'll start by just trying to get into the the more positional framework. Um, and then the last one, condensed revenue and expense reports with more line item details. Again, that's just a munish report. So, just got to um, you know, think about I think that's one of those reports that would probably go closer to the beginning of the budget document because it's a nice summary of the of the revenues and expenses. And again, that might be able to replace some of I think there's a a clunky chart in there on revenues that breaks things local receipts down. Um, this would do that. So, we might be able to get rid of that chart. >> Sean, is that something since it's a MUNS report, is that something that would be easy to generate like just a sample? I'm just just curious in terms of describing for our report. Like, >> if you look at Northampton, it's the same one that's in the Northampton report. Okay. If you look at the Northampton budget document near the beginning, you know, there's a very consolidated table that breaks down revenues, then has the their basically the org level, >> okay, >> of each of their revenues. So rolls up the smaller accounts into the orgs by so like fees versus um >> Okay, got it. I know which one that is. >> And then there's an expense version of that too, right after it. >> Okay, great. I can take a look that way I can describe it accurately and record. Okay. So, it sounds like a lot of this sounds like it's doable um either on this budget cycle or the two items I think were a possibility for the future if not for this one. >> Are there any other things that people wanted to bring forward, suggestions or questions? I don't have any other um and I like the fact that you said either this cycle or the next cycle so that we you know that and I think you know in terms of the goal of this is what I agree with what you said Sean is that the changes we make we're willing to live with you know it won't be that we'll think of something new and different next year you know it's it's an ongoing uh document it. And again, I you know, Sam keeps saying we love the budget book. There's It's not that the budget book isn't useful. I find it very useful. I just eight years in, I know where to look for things and I know I know I know if it's not there, I know where to look on the main website for it, you know, in terms of I can walk back and forth, but but that's that not every we shouldn't have to have that that background knowledge. Um for >> and for for new for anybody new to the council um uh you know it probably is a walk through the budget you know the first month you're elected just so you know what's in it you know the last year's budget book um >> and and quarterly reports you know Jill I I think you saw it but Sean has started adding what you asked for definitions of terms you know what what's in this bucket you rather than just a name of it. And I think that's extremely helpful for going back and knowing what we're talking about. Um, >> and Mandy's comments were about indexing the the budget document. I think we can definitely do that. I don't have a ton of experience indexing in PDF, but I know it's not super hard. So, we can right now the table of contents, you can click on the page number in the table of contents and it will bring you to the right page. But I think what Mandy's asking for is can you index like the departments within that? so you can get to the departments quicker and I'm sure um we can do that next time around. And then I just think in the in the report, you know, obviously this came out of the request from the charter review and we should be clear that as you say Kathy, we need to live with these changes that this is this is happening because of a process and we've formed a committee and a subcommittee and we're and this isn't going to be an annual I mean people can obviously always make suggestions but but this is our opportunity where we're making some maybe some big changes and it's not people shouldn't really expect this level of of change on an ongoing basis because of how much work it is um for Sean and his folks. >> Yeah. And when I say live with I mean like I mean every 5 years yeah is reasonable. I mean we can always we'll we will probably continue to make little tweaks here and there every year just based on what we hear from people but I think that you know not live with like we can never change it again but um yeah. >> Yeah. So does it sound so we're our goal is to bring some of this to finance on the 15th right to to take a look as as for the finance committee is the idea that the that the because it's the idea is that the finance committee would then forward on this report to the town council correct so Jill if I if I have a draft and I don't know Kathy you're welcome you know obviously can look at a draft too um I can circulate Jill I was thinking I would try to have a draft by the 8th um and then Maybe you then you could take a look at it and see what feedback you have before we get it to the finance committee on the 15th. Does that sound >> That sounds perfect. >> Reasonable. Okay. >> Thank you. >> And Sean is a quick read, Kathleen. >> Okay, good. So, I can send it to every I mean I can I'm happy to I just >> What does that happen? I don't just not sure of the process with >> No, I'm just mainly saying that if we captured what he what he is committing to I want to make sure we're capturing committed to and so it's just the word smithing of um that's that's that seems right. I mean he usually I shouldn't say this sh but usually [laughter] it's back in an hour you know because he doesn't bother >> depends on the time of the year. Yeah. what it is. But yeah, >> well, I won't expect to back in an hour, but I will definitely share it around so you can everyone can verify that it reflects the conversation and um and everyone's memory. >> I think that sounds great. Um and if you draft it in a way, you know, I don't really need to see it, you know, I've got it kind of um if you draft it in a way that it easily becomes a report to the council then. >> Yep. Yep. That's what I'll do. Then then you then you'll save yourself a lot of >> Yeah. Yeah. Yeah. I'll just I'll start it as a draft report to the council and we'll share that draft report with finance after you all have weighed in and then they can edit as you know at make additions or whatever and then we'll pass it along to council. So we don't need to convene again. It sounds like right. We've >> I think you know I I think we we just finished our work unless unless when we meet on the 15th people want us to now take a look at something else. No. >> Yeah. [laughter] Yeah. Yeah. >> No, no, no. I think I think we just finished our work. Um >> Okay, good. Well, thank you. So, I guess we'll take a vote to um we'll take a motion to adjourn. >> Just just a quick note that we're supposed to have public comment. There's no public in attendance, but so just to to note. >> Okay. So, we don't need >> public comments open. There's no public comment. >> No members of the public here. And now we can close. Thanks. >> All right. So, I'll repeat it. There's no We have public comment and no members of the public. So, public comment is closed. Opened and closed. >> And Kathy makes a motion to adjurnn. >> And I'll second it and then we'll take a vote. So, Kathy, >> yes. >> Councelor Breivik, >> yes. All right, I think