In part 2 of our video series about college foundations, Dan Swanson, an assurance manager at CK, shares his expertise in supporting college foundations. With more than a decade of experience, Dan breaks down the complexities behind managing scholarship funds, maintaining accurate financial reporting and leveraging financial systems to ensure transparency and donor confidence. He explains how thoughtful accounting practices directly translate into real opportunities for students. He highlights why strong financial oversight isn’t just important, but essential to fulfilling a foundation’s mission.

Transcript:

Welcome everybody. I’m very excited to be here today. My name is Dan Swanson. I am an assurance manager here at Cray Kaiser. I’ve been with the firm for about 12, 13 years now. And I wanted to talk about a subject matter that I’m very passionate about. And that is college foundations and some of the important factors that we need to be considering, some of their hot topic issues.

I wanted to kind of talk about foundations and how we here at CK have helped foundations on a number of different areas. So when you think of college foundations, what do you think about? What are some of their big struggles? What are they, what’s their mission, what’s their vision, what are their values. So with college foundations, they get funds, they get dollars, they get money, they get to invest, and hopefully those earnings, it earns, returns, which then turn into scholarships, turns into real dollars for real students to pay for real education. So sounds simple, but when you have, if you only had like two or three scholarship funds, not a big deal, but some of our clients that we serve have over a hundred different individual unique scholarship funds or program funds, and they have millions of dollars of investments. So how do we ensure that everybody’s getting their fair share of these investment earnings? How do we ensure that the financial statements are telling an accurate story to the board, to the executive director, to the finance committee, to all those involved to make sure the end of the day, the maximum amount of dollars are going out to students to serve the mission. So that’s where we here at Cray Kaiser can come in and use all of our knowledge and experience to really help these foundations and a number of different factors.

You know, personally, I’ve helped just with the system setup. You know, what financial system are they using? Is there any setup issues we need to update, adjust, add to it, what type of modules does their system have? Timeliness of financial reporting, are they getting accurate financial statements monthly?

So some shared experience I have while working with foundations, some of the things that keep them up at night. I kind of touched upon this as individual scholarship funds or individual program funds. Your more sophisticated donors are going to ask, how’s my fund doing? How’s my scholarship doing? How much do I have left in that fund? How much did you spend in scholarship funds this year? What did it earn? Can we do better? You know, if my balance is running low, do I need to write another check to get my scholarship funds back up there? So in order to answer all those questions, what do you think we need to do? What’s super important? What’s super important is, you know, accurate financial reporting, both on an overall basis and by an individual scholarship and or project fund.

So the way I tell people is if you’re like a for-profit company, you have kind of one set of books that you need to monitor and track. With these nonprofit foundations, you could have 200 different trial balances or general ledgers that you have to track. Because each individual scholarship fund is its own kind of entity. So you can see where it’s not super simple and straightforward. You really got to be very careful and very meticulous about tracking this activity.

So how do we do that? How do we make sure it’s over cumbersome? Because we the goal is we want to give these donors financial reporting accurately and timely because that’s going to drive them to open up their checkbooks and bring in more funds and more opportunities to these to the students. Again what’s the goal? We want to give out scholarships to help educate young students.

So kind of where I come in, where I get passion is about, is we can see, you know, by accurate financial reporting, by accurate accounting, where it has a direct impact, you know, on America’s youth. So it’s pretty cool. So from that standpoint, it’s very cool. Accounting is cool, right? Accounting is cool, guys, you know, because it translates to real dollars to real students. You know, how do we pay it forward? Well, have good solid accounting records will pay it forward and increase scholarship funds.

Other issues I’m seeing, a lot of these foundations use the same type of software package. And over the years, I’ve gotten pretty good at learning the system and its full capabilities. So what I’m always trying to do is, I understand that this is the financial package that has always gone to the board each month, but what else can we do? What are they looking at? You know, I’ll sit in the board meetings or sit in the trenches. You know, what is it that you hone in on? What is it that you’re looking at? What’s important to you? And then I’ll try to see if the system can generate a better, more improved report to help them do what they need to do to keep the foundation on the straight and arrow. Again, transparency is your best friend. So how do I utilize that system to its fullest potential? Because it’s a powerful system, so let’s utilize it. So what is it that you need? What is it that you want? And then let’s work towards that. So that’s kind of fun. It’s fun to kind of see what, hear what they want, what they need, and then going back to the system and seeing if we can generate a new report and make it part of that standard monthly financial package. So that’s a lot of fun.

Some of the other issues I see is there’s different, like there’s like a dual-based system where one tracks all the donor information and all the contribution information. And then there’s a different system, which is your standard kind of general ledger accounting software. and they talk to each other and they’re integrated to each other. So making sure that both systems talk appropriately is super key. You know, if we have a bunch of donor information, a bunch of contributions in one system and it’s not being linked correctly to the other system, you can see how financial reporting can become out of whack and then you can see how come year-end. When it comes to audit time, it’s going to create a lot of headaches. So how do we get in front of that? How do we make sure the system is set up initially? So both systems are talking to each other and are integrated. So again, over the years, I’ve kind of learned both systems and we know how to make them work. Or at least know who to contact to help us when we notice issues.

If you have any questions that you would want to ask me, you know, please feel free to reach out. You can go to the Cray Kaiser website and you can find me. Again, I’m Dan Swanson. I’m an assurance manager here.