Kim Fellman @ JMT Consulting: All right, we'll go ahead and get started. Hello again everyone and welcome to today's webinar. The Ultimate Guide to improving your FQHC's bottom line with Sage intacct.

My name is Kim fellman and I'll be moderating today's session.

We appreciate you taking the time out of your day to join us and today we are going to show you how sage intact can be a great year P solution for a federally qualified health center.

Before we get started, I have a few housekeeping items to cover first. Today's webinar will be recorded and we will email you the recording and the slides within 24 hours for on demand access

And we pull up to hear from you. During today's presentation. So if you have a question about anything, send it to the Q AMP. A tab at the bottom of your control panel.

We will dedicate a few minutes at the end of the presentation to answer any questions you can send them in at any time and we will save them for the end

Leading Today's webinar is Mark Braisher, I'll go ahead and give the Florida marks so he can properly introduce himself to you all and get us started. So, over to you, Mark.

Mark Braisher: Thank you. Let me share my screen.

It's good to be with you today.

I'm look forward to sharing some of the things that intacct can do for

We have spent significant amount of time studying and interviewing various CFO CEOs and other staff with FQHCs. And so we hope today, just be a brief overview, but it'd be a chance for you to see what sage intacct and JMT can do for you.

First, let me just introduce myself and Mark raise your sales engineer at j empty. I spent most of my adult life and nonprofits.

The last 13 years as a CFO at a nonprofit and so I know somewhat of although every CFO and every organization is different. I know somewhat what is you're going through and your side of the table. If you work in a business office or a CFO of a nonprofit.

tell a little bit about JM t from the very beginning JMT was built to help nonprofits achieve their missions.

We as a team, as a company, dedicate ourselves to serving the nonprofit's that's that's our only client. And that was from the beginning.

Jackie Tiso is our CEO and the founder and before she began JMT, she served as CFO and controller for numerous nonprofit organizations.

And she found that oftentimes there weren't good solutions for nonprofits and so therefore, she began to launch out and to provide this consulting for them.

To give them the top quality best incorrect technology for their particular organization. And that's been our heart, ever since she began almost 30 years ago.

Your mission is our business. We have thousands of happy nonprofit clients we

pride ourselves and work very hard to have rapid and affordable implementations going through an implementation of new software is always a

Big task and we want to make that as streamlined as possible. What you'll find it GMT is a deep nonprofit expertise, you'll find personalized service at the same time, you'll see us partnering with world class cutting edge technology companies for the benefit of your organization.

We have clients all over the country. In fact, around the world, now we have an office in Melbourne, Australia as well. And here in the United States we have offices in New York, Tennessee, and in Texas, but we have clients. As you can see, all over the United States.

Here's a just a smattering of a few of our clients in all kinds of industries within nonprofits in all over the country.

We are an independent consulting firm that should be important to you, because as a independent consulting firm, we, we do not sell

Software that is not what we do, or we did not. We are not a software publisher. We sell software. We're not a software publisher. We look for the best to to serve you. Our commitment is to you.

We curate only the best solutions, whatever area might be in the back office, whether it be accounting or planning or whatever area. It might be that is our goal is to find the very best solutions.

we assemble a perfect for you solution from our ecosystem of best in class partners. Our goal is to find the best in these different areas. So as you see here JMT as the hub of this. Will you can see non profit financial reporting grant management.

Close management AP automation, etc, all the various things that you deal with on a day by day basis. And our goal and our intent.

And our success has been in finding for you the best software that fits for you and for your organization. Here is an example of some of those limited example. But here's an example. The limit of the some of the software that we have used to make that happen.

One of the best things to for any potential client would be what one of other said about

This particular company and for GMT. We have a number of testimonials of people who have found that we are truly a partner in their particular organization.

In this particular case that cancer care the CFO john Galliano said the onboarding process was really the crowning achievement after it was done, I couldn't imagine doing it without them we are going to

Come in beside you and we're going to walk you through each of the steps and we're going to make sure the implementation is done and done well. So let's talk particularly about

For just a few minutes we, as I mentioned in the beginning, has spent some time we've had FQ HC

Clients for many years, but over the last several months we have began to study them.

Directly and intently to find out what it is that they need and what what what we need to provide to become the one stop shop for them for their back office. And so with. There are some things that we have discovered

This is not comprehensive by any exhaustive by any

Stretch the imagination, but we have discovered a few things. And I want to use this kind of is our agenda for today. First of all, let me say up front. We understand that no to FQ agencies are alike.

One of the things we found out as we interviewed various CFO is is is that they all work with the federal government, they all follow this call in this category of FQ HC

But the fact is, each of your organization's missions are unique to you and your particular area. Your particular mission is unique to you and we are fully aware of that. That's the reason a consulting firm like JM t is so valuable to you.

Secondly, and this may be the biggest piece and I'll spend time today on this one is there are having reporting needs for government agencies and other stakeholders.

Particularly with federal government with such things as the hearse UDS reports, we understand that that is a very time consuming task to pull together the various bits of data from various software to

To put together reports that have to be done and I hope by the time we finished today that you'll see that we think that we can put together a solution for you that will streamline that significantly for you and save

Hours and save dollars and that's allowed more dollars and more energy to go into your mission, rather than filling out reports for the government.

We understand that it's a changing landscape and healthcare. The last few months with coven has act accentuated that even more, but it is a changing landscape. It is a challenging it is a fast moving is in changing one of the

We also, in addition to intact provide software that can help in that planning and we have found many of our clients.

Coming to us and we need to move quicker with our planning quicker and quicker with our budgeting and changing the budgets and we understand that and we have solutions that can help you with that.

We understand that many if not most of FQ sees have multiple locations in those multiple locations. They need to be able to manage all those things and doing that they need to be able to consolidate that data.

From the various locations and intact is is sets prime position to be able to do that for you.

Finally, we understand that there's also, in addition to financial which will spend most of our time today.

Intact is set up and is can handle statistical data and it can handle statistical data just like a handles financial data.

Actually a journal entry for statistical data. And by doing that, you're able to

Get ratios. You're also able to put into reports the various data that needs to be provided to the federal government or other stakeholders that you might have. And so we'll look at that. Just briefly today.

So let's start with that particular one, and then we'll go deeper into some other areas.

Statistical data, the screenshot. I have for you on the page is a dashboard from intact set up for an FAQ HC and as you can see at the top.

You see these performance cars of performance cards, this, this looks like a bad month, this must be December or something, some other month when people are not wanting to go to a few agencies. But the fact is this particular

Dashboard shows this statistical data that can be brought into intact.

I'm not going to go in detail today, just because of time, but we can we can meet at another time and and give you a demonstration that will show more detail, but the dashboard that you're seeing here.

Is is totally customizable. As you can see, and I'll just hit on these things, briefly, you have performance cards at the top you have reports here in the middle you have different graphs, also in the reports themselves. You can see these

blue areas and when anytime you blue area and oftentimes it's in the funds themselves. And the reason there's not blue on the, the actual dollar amounts is because there's

Additional accounts underneath each one of these blue ones that would open them up, which in turn would give you access to be able to open up

And drill down into any of these areas. And so right from the dashboard, you're able to go into which is a great feature and intact. But the big thing. I needed to point out here was the fact

That you can pull in statistical data. And as you can see here, for example.

He got dental visits and then revenue per dental visit and you have you're able to mix the statistical with the financial data and get the ratios and the KPIs that you need to keep an eye on to ensure success in your organization.

Intact and also handle multiple locations. As you can see here, these are the various locations.

That are in this particular database and you can have addition, you can have entities you. This is just about unlimited. How many you have in. So if you have multiple entities. These can be handled and so you can handle vendors, from the various locations you can handle.

receipts and revenues and expenditures from the various locations and then because you're able to do that. And you can do that for one location and have a

A top level. As you can see there a top level that can manage each of those, but also individuals and offices within the particular entities can manage their portion of it as well.

But then you're able to bring all that together for consolidation. As you can see in this particular balance sheet.

You have your, your balance sheet.

Accounts down the first column. The left column and then across the top we have the various locations for this particular organization and then a consolidation of all that information they're

Available and so you can pull out any portion of this and and keep an eye on. And so if it's the for example if is the Bethany location.

They may not have they would only have access to their particular information, but the CFO and the Central Office, could be able to look at all this and be able to see as a whole. And so you're able to keep an eye on these various things.

Let's begin to talk about the hearse federal reports. This is just a screenshot from the table a day from the UDS hearse a report and I realize as again as we interviewed various staff members from the Number of What we found was, in fact, one particular CFO said if you can figure out how to to streamline and bring this information.

That is needed, out of the accounting system prepared and ready to go into the hearse a report.

That would be gold and that would be something that that that any FQ he would belong to have. And so what we've done is we've created a database. And we've set up.

Chart of Accounts, and we have set up dimensions in intact. They use a dimensional chart of accounts with not only your GL and your departments in your funds but also additional dimensions that you might want to add to that. And so we have began to create

A reporting and a database a chart of accounts and a reporting system that allows you to mirror the hearse are reporting and so I'm giving a couple of examples of this today.

First of all, in what I'm focusing on are the financial ones for today.

But as you can see here, this is an if you're in if THC. This is probably familiar to you, but in this particular one, you have your financial cost and you have your various cost centers, if you will. And then you have your accrued cost. So your cost in each one of those

cost centers. And then, and I'm not showing the bottom of this report, but as you know at the bottom of this report, they had the facility and non clinical support services in this first accrued cost column. This a call.

The then what the federal government asked you to do is allocate those facility and non clinical support services across all of the various costs other cost centers.

And then a total for that as well. And so this is report you fill out. And so you're pulling this various information you're doing calculations.

And as a former CFO and as I consult and work with various nonprofits. One of my goals in talking to CFO is in trying to serve them better. Is this is that anything that you're doing.

In Excel outside of your software. We need to find a solution to help you do that within your software. And so this is a prime example of that, that you're going to see today. So here's your cursor report.

I may go back and forth here just a bit so you can see this but you have your horse report. And then here is the report directly out of intact.

And as you can see you have these various cost centers down the left column, just like you, as you saw in the original in the previous slide.

You have your accrued costs and you can use any period, you want to use for that monthly, quarterly, set up your own periods annually. And so you have those. And here you have your facility and non clinical

Costs and and there's that total there as well. And then in the next column. The middle column here we have allocated this $63,000 into

The various other cost centers. And so this is with the dynamic allocations that's built that that is a part of and can be part of intact. The ability is there to allocate that for you. And so what you have, if I can go back one slide.

You have a mirror of the actual report that you're going to use for your HRSA Table 8A.

I think that this would get us very close. I understand that the federal government is not too keen on being able to import this data into their systems.

But what you have cut out is any calculations that are done outside of your software and you're able to have this report in this inner this report, the information directly from this

Let me take just a moment and point out some things that that happens here. So you have, again, your crude cost and then you have your of

Your various medical departments and then your facility and non clinical and you have the total amount there. And then what

System has done is aka that and allocates it it's not an allocation that is set up in advance, but it's an allocation based on these amounts right here. And so it's divided appropriately. So let me show you what is done. So here is a

107

00:20:06.000 --> 00:20:13.170

Mark Braisher: Journal entry that shows a portion of that this is just a portion of it. Here is your various medical

108

00:20:13.830 --> 00:20:27.420

Mark Braisher: Departments and and the cost and here is, and this is actual allocation that is done. And here's a journal entry. And so what it has done is taken this $21,000 which originally was in facilities.

And has scattered across the various departments right here. And again, it is not something that is done.

In advance but it is something you could do each time period, whatever reporting period that you want to use monthly, quarterly, however you want to do that.

And it goes back in this particular instance and finds all the information all the data that fell into that facility and non clinical

Support Services and rolls it in there and figures, the actual allocation. And so here's an example of what you may be doing on a spreadsheet right now.

But what it's done is gone in with each of these departments and these departments right here are your medical departments and it's it's calculated the percentage of what is needed of each of this $21,000

And so all that work is done within intact and as something that is that you can do periodically as monthly, quarterly, as you need to do it and provides you this particular report, which then in turn gives you the information the data that you need for the hearse a table, a day.

Let's look at one of the report before we run out of time here. And this is the person 90 which is the revenue side so eight eight is the

cost centers. This is the revenue side. And so what we have here is your various funders, you recognize those I'm sure your Medicaid your Medicare other public self pay, etc.

And so here are the various revenues that have come in and this particular month for these particular funders. As a result of these funders and the revenues coming in from them and then

How much of that revenue was collected and this is what was charged for those funders to pay

This is the map that was collected within the month and this also photoshoot percentage of charges that were actually collected again this mirrors.

The hearse, And 90 for the federal government. It allows you to create this report and once the report is set up there is a significant amount of work on the front end. But what JM t is doing by focusing on

And and finding solutions specifically for you is we're doing this work on the front end and then we come in and implement intact for your particular organization, your particular FQ HC

Those reports can be set up for you and from day one, you're getting the information that you need and you're up and running. So, often with software and we hear this time and time again.

How many times I've heard this. I don't know in the in the few months that I've been at

JMT and that is where we bought software. It may have been a year ago, two years ago, or maybe 10 years ago.

But we bought software and I know it can do a whole lot more than we're doing with it, but we're just not using it at j Mt. We want you to be using that to its to its full capacity.

And this is one of the ways that we can do that because we're going to

Make sure that this report sets up and works for what you're doing. We think that we are we have hit that with these particular reports and there are other reports that you will need.

But in these particular ones for the federal government will be able to install these in in the implementation and you're up and running for those

From day one with that information. Now another piece of the puzzle. It comes in here is that connection to your electronic health records and in the connection to the electronic health records.

There's one thing that intact does well is it plays with other software's as you saw the pie chart from the very beginning.

And when it does that by some when we say it plays well with others. It was designed for the purpose of

The intent of intact was not to be the the everything to everybody software but to be a software that could allow you to find the best in class. So as we did our research and are continuing to do research on SQL sees

We know there are a number of electronic health records software that is being used and so

The, the issue then is, how can intact speak with that electronic health records. We understand that there are all kinds of privacy concerns and so we know that we're not pulling

Personal information from that. But when that electronic health records allows when it when it's able to

Put out exports that will give you the data that you need to create reports that we're talking about, then we can import that and the import

Process for intact is is very good, it's very flexible and will allow you to do some of the things that we're talking about today.

So I hope that that helps. I hope that whet your appetite for what JM can do with intact.

To for your FQ HC I hope that as you struggle with reports and maybe you're one of those who do not, but probably if you're in this particular webinar you do, then we can come along beside you with intact and make

Streamlining a regular part of your day. So were there any questions for us today. We got just a few minutes left.

Kim Fellman @ JMT Consulting: Yep, so thank you Mark. So we're going to open it up to questions from you all. You can submit using the Q AMP a button at the bottom of your control panel. You can also submit a question through the chat as well.

But to get us started, while We did have one question that came through. Can you touch on the topic of like importing from their electronic health records and from the statistics point of view.

Mark Braisher: Yes, let me let me talk a little more like just briefly at the end, but again, as I mentioned earlier in the in the session, Intacct handles statistical data just like it handles financial data.

And so therefore, anything that we can export from your health records, whether it be statistics or whether it be revenue pieces financial pieces.

We can bring that into intacct and then do multiple things with it and the import is a fairly simple process, but we can do multiple things with that we can create statistical reports that are purely statistical or we can recreate reports that are a mix or a ratio between the financial

And the statistical and so It is not a statistical software but it handles statistical data for reporting purposes, mixed with the financial as well as standalone

Kim Fellman @ JMT Consulting: Thank you, Mark. So we don't have any other questions that have come through yet. But if you want to just we can sit here and wait for a minute and see if anyone's typing.

Mark Braisher: And while we're waiting on that. Here's my email on this last slide. And so feel free. If you have questions afterwards. Reach out to be glad to answer them.

Kim Fellman @ JMT Consulting: Yep, and we will you don't don't feel like you need to write that down. We will email you this slideshow with can access his email address.

From your computer. Okay. So that looks like on all the questions we're going to have for today, Mark. So let's just wrap this up now.

So thank you all for joining GMT consulting for this webinar today.

If you'd like to see the intact system more in depth, we would love for you to join on August 27 for a deep dive look into the intacct system.

We will send you a link to register for that in the follow up email with the recording and slides.

And also, Megan Mendiola who couldn't join us today will be following up with you all tomorrow to see your thoughts on today's presentation. So this will conclude our webinar unless you have any final words from Mark

Mark Braisher: No, I'm good, thank you.

Kim Fellman @ JMT Consulting: Okay, thank you all and I hope you have a great day.