Small Borough, Big Plans: Turning 100 Spreadsheets into One Clear Picture
Timestamps
Souderton Borough, PA | Session Overview:
Speakers:
Sara Jarrett‑Eaton | Borough Manager, Secretary & Treasurer, Souderton Borough
Jamie Schlesinger | Managing Director, PFM
Noah Leib | Solutions Engineer, Synario
Michael Nicolescu | Director of Client Success, Synario
Jim Arms | Director of Strategic Growth, Synario
- 1:22 – From 100 Spreadsheets to One Model
- 4:02 – Building a Five-Year Capital Plan
- 6:27 – Explain Feature and Initiative Builder
- 9:00 – Walking Through the Sewer Blower Project
- 12:20 – Personnel and Insurance Costs
- 17:20 – Sewer Rates and the Infrastructure Fee
- 25:30 – Up and Running in Weeks
Souderton Borough’s Move from 100 Spreadsheets to One Planning Model
In this Synario Lunch and Learn, Sara, Borough Manager of Souderton Borough, joined the Synario and PFM teams to show how a small borough with limited resources now plans its future in one place, and why that has changed the way she talks to council, department heads, and union representatives.
Sara originally came to Souderton as finance director and took on the borough manager role when the position opened up, so she carries both jobs. When she started, her work lived in roughly 100 separate spreadsheets. She handed those files and her existing reports to the Synario onboarding team, and the initial setup took about three weeks. From there, the team refined the model together.
A Capital Plan Built Around the Sewer Plant
Souderton had no formal capital plan when Sarah arrived, so her first budget year included a five-year plan for every department, with a focus on aging infrastructure, the biggest item being the sewer plant. The goal is a replacement schedule the borough can afford without doing everything at once.
Sara pitched the model to council, and she called this ability to toggle projects on and off the biggest selling point. With more than half of council new as of January, the team also built a dashboard designed for newly elected officials.
“Just showing them…the difference of what that means for us long term can really help you prioritize what is actually a need and what might just be a want.”
– Sara Jarrett‑Eaton, Borough Manager, Secretary & Treasurer, Souderton Borough
Personnel Costs, Backed by Data
Souderton is also working through an expired police contract and rising pension costs. The personnel dashboard lets Sara set salary growth by category, add new positions, and model insurance costs. In the base case, salaries rise 1%, and in the alternative, they rise 2%. She can toggle between the two and see the difference in real time.
The same approach applies to the sewer fund. Sara can adjust accounts, consumption, base charges, and fees across the roughly 4,000 residential and business customers the plant serves. The borough’s infrastructure fee of $10 per unit per quarter is entered as $40 per year, and any change flows straight into the reports. With a new trash contract under negotiation, Sarah can use the same model to analyze it.
Up and Running in Weeks, Not Months
Synario's Director of Client Success, Michael Nicolescu, explained that Synario starts with a client’s own data rather than templates or dummy data, so feedback can begin on day one. Historical actuals typically need to be loaded only about once a year, while assumptions can be updated whenever planning needs change. Excel and CSV files from any accounting system work. Sarah also noted that her training sessions doubled as working sessions: the team fine-tuned the model while she learned to make updates herself.

PFM’s financial modeling platform for strategic forecasting is provided through PFM Solutions LLC, d/b/a Synario. For more information about PFM’s entities or services, please visit pfm.com/disclosures.























