Automate Your Budget Process with Microix and Community Brands MIP

Tired of budgeting the old way? Meet Microix: an automated budgeting solution built specifically for use with MIP Fund Accounting that enables every department at your nonprofit to prepare preliminary budgets and submit for approval electronically. Microix’s Budgeting module takes the headache out of trying to share budgets cross-departmentally and allows teams to work on multiple versions of the same budget while seamlessly integrating with MIP.

In this session, we discuss features and functionality of the Budget Module, covering how Microix:

  • Uses Excel formulas to automatically generate next year’s entries
  • Can create multiple versions of same the budget
  • Budgets multi-year grants and programs

Interested in learning more about how your organization can maximize your MIP investment with Microix?

JMT Consulting: Thank you again for joining us, my name is Melissa waters and i'm the manager of events here at JMT consulting and you're joining us today for the automate your budget process with microix and Community brands MIP webinar.

Today we have Rickie George founder and President of Microix and Dan Wharton senior client sales manager at JMT joining us.

today's webinar is sponsored by JMT consulting. We are an ERP and financial management solutions firm with 30 years experience that specializes in nonprofits.

Before I hand it over to ricky and Dan I want to go over a few housekeeping notes and then we'll get started.

First of all, this is being recorded, we will send you a copy of the recording within 24 hours of the webinar will also share a copy of the slides for you.

At any time if you have a question during the webinar there is a Q amp a box in your control panel, you can click on that submit your question and we will answer those at the end.

If we don't get to that question, we will also get that in the follow up email as well with that i'm going to pass it over to Dan to get us started, thank you.

Dan Wharton: cool thanks, Melissa.

All right, let's take a look at the agenda ricky I am super pumped today, this is my first webinar really MC for you and you're so good, with customers, you and I have done plenty of meetings and.

One on one DEMO is, but this is really our first big big show so.

Your customers to understand challenges and help them overcome them it's really amazing what you can do and honestly I know our viewers are going to really respond, the same way, so.

Thanks for joining us rickie our audience is really lucky to have you.

All right, our first a quick round of introductions my name is Dan Wharton and joining me is for each yours is President CEO of Microix, and the reason why so many customers have successfully applied those applications.

So we're going to dig a little deeper into the two companies, then we'll get to the good stuff to migrate advanced budget module, why does janti recommend library over mvp when MIT when it comes to budgeting and forecasting.

I can, I can kind of let the cat out the bag The short answer is the MIP budget module is built to manage grants programs and account segments it even has a solid collaboration platform.

But it doesn't get down into payroll friends other things you can do can include cost centers in your forecast.

Microix does this and rickie's going to show us how here in a few minutes, so it should take us about 45 minutes to deliver today's content and then we'll open things up for Q amp a with the audience right okay.

I looked at a chance to look at the people who registered, the list of.

registrants for today's webinar and I do see a lot of new names names I don't recognize so i'm going to spend a few minutes a few extra minutes.

Talking about JMT and how we're different from the other consultants, you might work with in the past, important.

also want to start by thanking everyone for taking the time to meet us today.

Again, my name is Dan and i'm a customer account manager I work with hundreds of nonprofits across the country and assist them with their day to day, what does that mean.

Well, some examples, you may have a new employee that needs a warm welcome Sean where to go to for answers connect with all the free resources that are available.

You may want to import data from another system or eliminate a manual process, maybe you want to know about my cloud MIT cloud and its benefits.

Other examples you want to expand a grant code, create a new entry merge two entities, how to use or change your fiscal year automate ap.

Really, the list goes on, so i'm your conduit i'm your middleman customers are always looking for free resources tips tricks and how you can better leverage and IP I can be that person you call and.

I can make life.

Welcome, do we do with JMT consulting is the largest MIP reseller, not just in volume, but also in size, we have regional offices in Austin, nashville, paterson New York and staff everywhere in between and around.

We invited Mike ready to talk about their budget management solution, but the truth is, I might be customers do have several options over the years we've observed and learned that there's no such thing as a one size fits all solution.

JMT has vetted hundreds of vendors, to bring you best in class solutions for payroll financial planning analysis cemetery management ap automation document management.

And more some of the names, you see here listed i'm entre assemble everything we do will lead to better processes and greater efficiency.

here's a handful of the many nonprofits research over the years, take a look and see if there are any names that just jump out at you with do.

You know dropping down get over to us, maybe we can make an introduction.

Maybe we can help make a customer reference.

Whatever whatever you'd like to do networking is very important in the nonprofit world.

Somebody so The point is, is that some of these organizations are very small foundations, some are on the opposite side they have national offices, with hundreds of millions of dollars in annual operating budget.

i'm saying this because JMT is small enough to deliver a personalized experience big enough to handle any large scale project So how do we do it on it's really through the people it's great team professionals.

So i'm in sales and I get to me and travel and meet a lot of customers i'm but i'm really surrounded by a great group of folks the folks that are much smaller and much more knowledgeable on the products than.

than I am and that's kind of why service conduit you have a problem I make the right introduction or bro get that resource.

Many of many of the people you see here have been with jm T for years, and you may have met them water to a matter conference or some other event near you for those who are new to GMT.

The guy in the in the tie a dentist and he's a magician when it comes to data and making things work.

More often than not, you might have encountered him on a phone call just trying to reach out at you, because you call them to support and need help, building a report.

Fixing an error connecting user things like that.

Carol is our chief experience officer she's been with us for a number of years, many of you know we're just giving incredible way of work customers.

Other customers event Dag doesn't paint color when they first implemented MIT she's now had a training here at jm T Lucy.

Pritchard the metal and a few others started as a customer and we learned them over to gnc and now they're helping.

Implement solutions make changes learn things like that anyway it's it's nice to be able to associate a face to the name they all do great work, and we all have a common goal, create a great customer experience.

I call this the what's in it for you slide This is where we talk about other customers and how they love working with us.

These are fresh I pulled these reviews in last night.

They came from G2.com and the testimonial from Helen TAO is directly from like roi.net website.

Another resource, you may or may not be leveraging is the MIT community is an online forum for customers to share ideas and solicit feedback from one another, from other MIT users.

Go to these sites check out what other nonprofits are saying about us and they'll give us a call first thing we're going to do is spend time listening and observing.

i'm going to ask you what prompted you to reach out, what are the problems you're trying to serve as all.

What, what are the requirements, not for you, but really the organizational role what processes and tools you already have in place, and how can we leverage those, how can we build off of them.

Once we have all that information, then we can get someone like like right involved really cool thing about micro is that their software will adopt your car processes and optimize them.

Your staff will now be enabled with the right tools and the right processes you won't have to change who you are more importantly, you won't lose sight of your mission, just to make the software work can I see that time in time out.

In this business and in other places.

Right now, but JP let's turn our attention towards micro library has been a great partner for both GMC and our clients my query workflow modules.

help our clients extend the capability of MIT software as they grow and avoid costly conversion to another platform at different product platform.

The stability and consistency equality, the modules was a jm T recommend these solutions without hesitation.

The micro team responsiveness and commitment of partners like GMT make this a great relationship recognized or walk us through the rest of the presentation remember jot down your questions do it in chat room will definitely have an opportunity to address them at the end of the presentation.

Alright ricky let's see if I can change.

Stop sharing my screen here.

and see if you can do.

Rickie George: Okay, great Thank you Dan can can you hear me okay Dan.

Dan Wharton: Yes.

Rickie George: Okay, great. Thank you i'll go ahead and share my screen now and Thank you everyone for joining the webinar today, my name is ricky George and i'll.

Take you to the Microix budget module.

And of course i'll stay back a little bit after to answer any questions you may have okay.

The one thing I wanted to point out is that this solution is fully integrated with your MIT fund accounting application so there's hardly any.

import, export that is necessary, unless you're not to use imperial detailed module of MIT it does require a little bit of import if you're outsourcing your payroll module okay.

So, just a quick overview of the module the budget modules is a little bit more advanced features than what you may get with MIT it's also part its power is also to be able to decentralize that process to managers and.

program managers, where you will most likely collect budget data, and I know workflow gives you the ability to route those worksheets to an approval process until it gets to the budget meditate and to consolidate them all.

For reporting purposes, and then, once it's finally approved it's allowed you to transfer to MIT again without doing any input exports.

And post into they might be fun accounting application so it's it's more of a decentralized process.

But you can use it if you just have one budgets administrator and that's doing all of the budget work, you can use it for.

single use as well okay what i'm going to show you today is more of a decentralized process and some of the things that I show you today may not pertain to your specific process.

But i'll be able to help answer some of the questions at the end okay so just a quick overview here on your under screen let's see, let me get rid of this.

Okay, we have what we call a built in workflow and the workflow helps you to decentralize the budgeting process, so you may have different departments or programs.

or locations, that you would like those particular managers to input into the budget, you could set up those groups, and you can also assign.

Who will be responsible for creating those budgets and the approval process what it may look like so when they enter the budget.

It may go to a director for approval before it gets to the budget administrator so you define the process and workflow help you achieve those those routing and approval rules okay.

there's also account restrictions and these account restrictions again.

Work in line with your MIT fund account in where you can restrict certain fund grant program anything that you're trying to restrict that person to maybe view or see.

The workflows will help enforce some of those restrictions for you OK, so the workflow again just the ability to apply rules and route things through the approval process that you defined.

The budget module also allows it integrates with a payroll module of MIT so if there's all of the employees and all of their timesheets with with the benefits and salary information Mike will be able to tap into that and bring them into into the product, where you can then start to.

manage that that personnel information, the personnel can be decentralized as well, most people will centralize it have HR payroll department.

be able to budget personnel information so again two options here for the personnel is you can import it from a csv file if you're using a third party people company.

Or you can import directly from mit's payroll module once it's imported there's a list of staff that you'll be able to work with.

And this example here let's bring in one of them, I have one person particular person it bought into salary information current salary amount hourly rate and so forth, all this information is pulled out of MIT and the salary allocation how the person is.

Current salary is being expense to the different events or programs or departments and a percentage of their salaries and what.

And how it's going to be allocated amount to your your grants there's also the benefit information on the right hand side, which shows you.

The benefits again from the mit's default timesheet brings in those benefit information with the rate and amount that will automatically calculate for you.

All of the benefits will also follow the way that the salaries allocated so if you have help life and so forth again if it's 85% to a specific grant or financials it follows.

Your salary location Okay, you can budget for open position so there's any open and unfilled position that you have to budget for in the new year, you can go ahead and.

enter those as well, you can also change that location so, for example, if this in the coming year, you need to allocate that person's salary to a different event or department, you can go ahead and change that.

percentage allocated differently here 25 and 75 and this allocation will not change the current allocation that that you have set up for that employee in the payroll module.

You only changing it in under budget side, but the actual allocation and percentages stay intact in MIT okay so.

This is just a quick overview of what the personnel worksheet looks like allows you to budget by employee each one of them.

Save the information you can also plan for increases, for example, if you have a 5% or 2% increase for the upcoming year you can.

Go ahead and put in that that percentage, and then, once you enter that percentage Mike was going to allocate now 32,000 instead of 31 and all of the benefits.

will actually calculate off of the 32 if it's based on the percentages, based on a percentage Okay, once you have finished your personnel information again.

This can be centralized.

and your HR payroll department work on this particular budget while your managers input into other expenses and different line items that you may need so it can be a mixture of both.

there's also report for the personnel that's allow you to view all of the data that you've entered into personnel information.

And you can actually summarize this by either department or program or grant and so forth, it gives you a summary.

of everything in this one report, you can also filter just for the category salary or benefits or both so let's say we wanted to filter justin salaries.

It gives you a grand total at the bottom, the total amount of salaries for the entire organization based on the events and, if you want a group by event we can bring the events column up where you can now see the different events.

In detail here okay there's also a column format, where you can see, the data, the salary data in a pivot view so here all of the employees and if you wanted to bring in the events category, we can go ahead and drop in the events and you will be able to see each event and amount.

per employee Okay, so this is just a summary of all of what was entered into personal information.

Now we get to the budget worksheet, then the budget worksheet again allows you to decentralize that process to send it out to managers and they can give input into the budget.

And that starts with the what we call a distributed worksheet in our distribute worksheet, and this is normally done by the budget administrator where they get all the worksheet prepared to be sent out to the managers and this is normally done maybe once a year.

And the nice thing about this is that information is saved for he after a year, so you don't have to rebuild this information, you may have to change the user, if you know if is there been replaced or not.

For the new year's or someone else will be budgeted for that particular event, so in this example here.

i'm telling the software to go ahead and build some worksheets for event to 111 to one for one.

I can tell it, how much history history, we want to include the budget right now i've asked for three years of historical data which comes from the mit's general ledger.

With a cutoff date of whatever date you specify here, and then we identified the new budget period of where what period where budgeting for the most part.

These works, you will budget based on one fiscal year organization fiscal year, but they are options, where you can budget a grant fiscal year versus your organization fiscal year okay.

So in this example here we can go ahead and have the system produce these worksheets So when I click on the process and I.

click on this gear, the system is going to go out to mit's general ledger pull all of the data for this three year period from 2018 to 2020.

Based on the GL from two and event it pulls that information from your journal edge of MIT and pull it into my coin, where, then it distributes it to the employee that has signed under the username.

an email is sent out to that employee and they'll be able to log into the software navigate to the budget worksheets.

And anything that's pushed to them, they will be able to see here and work with the work and work with that specific worksheet.

they'll only be able to see the worksheet that you've sent to them, they will not be able to see all worksheets in the system okay.

As the budget administrator you will be have access to all worksheet in the system, or if you're a manager approving or Director proven maybe two or three different department, you only access is to those worksheets.

that's assigned to your workflow okay now in this particular example here, I have let's look at event one on one so i'm going to go ahead and.

edit this worksheet, and this is a typical what a typical worksheet looks like these are the different columns that comes over and again the data that you see here comes from the MIT is general ledger in real time.

Now the projected column is optional, this this column is just kind of analyzing your current year.

and telling you what it thinks you're going to it's based on your spending habits, for the current year, what it projects that you would spend by the end of the year.

And this column may be compared to your budget of what you actually budgeted based on what we project you're going to spend based on your.

On your spending habits as of today, as of that cutoff date Okay, so this column is optional, some people may use this column to.

We forecast the current year, so this one worksheet can give you a reef forecast of your current budget.

And then, it can also give you a budget for the new year as well, so these two columns that's the purpose if you do not need this projection than the worksheet can be built without this column OK.

Now, the way that the the worksheets are built again is based on the historical data of MIT anything that you've.

you've have entries or activities and it pulls that into this one worksheet and this manager now will be able to work with this particular worksheet and enter the data that's required of them.

Now there's also salary lines here and the salary lines can be locked out where the managers can see it, but they don't necessarily an input into it.

And the reason for that is the personnel data that's been that HR payroll i've been working on the result of these will will get.

synced through their worksheet when it's synced to their worksheet managers will be able to view it but not make any changes to it, you can lock them out from it.

If you want them to see the detail, it builds the details, so if I click on the plus icon here.

i'll be able to see the different employees that are being charged my department or location and what percent of their salaries being paid by my department.

So this information is there for you now, some people may not like to see this detail there's options, where you can hide this detail.

Or the options, where you can use job titles, instead of the employee names Okay, but by default This shows the employee names and what percent yours your department will pay for that salary overall once everything is bought into the worksheet it puts into total budget amount.

that's computed from the personnel information, it does all of your benefits as well, so all of their lines that are in red, you can drill into it and actually see the detailed narrative that made up that dollar amount okay now for other line items on the worksheet managers can.

For example, if we wanted to budget for utilities and maintenance, we can drop in a number here total amount.

underline.

Or you can force this, you can have it optional or you can force what we call narrative and the narrative simply means that you need explanations.

or detail information of what may make up this line, and you can be selective in which lines be quiet narratives so, for example in this utilities, the maintenance, you may want the managers come in here and say well 18 T bill.

To 12 month contract at 85 882 per month and it's a 12 month contract and toes up to 10,000 and then you may have a utility bill and see what a bill.

that's another 12 month contract at whatever cost to this, so you can have them detail this information out for you, so when you do as an improver or the budget administrator once your your.

You receive this worksheet and you have questions about this particular expense, you can then drill in and see these narrative impersonation and i'll show you that as we get to the approval part, but the idea here is that each manager can.

Work on these particular worksheet items if they're in charge of multiple events or multiple departments or programs, most of the time you may have more than one worksheet for that manager.

Now, once you've entered the information and you've your you finalize your information, you can then go ahead and submit for approval.

there's other things that you can do on this particular worksheet, for example, if you wanted to take your current budget and increase it by 5% and make that your new budget.

There is a formula function here that's available for you to use, so I can go ahead and select all of my lines, and I can tell it make my D column equal to my seat column times.

One and a half 1.5% so ultimately what i'm trying to do is take my current budget increase it by 5% and make that my zoom budget.

And that's how I can just do a quick budget if i'm just doing it based on percentage Okay, I can also do the same thing for my actions here to the actual so let's say, for example, i'm six months into my my budget I can go ahead and take that six month number, which is the a column.

divide that by 12 and then divide by six sorry.

And then.

multiply by 12 to get an annual amount based off of what I currently spend so far, and maybe I want to increase that by 5% I can also do that math here as well.

Okay, I can select I can be selective in what you know what who what that formula applies to I can select certain line items Well, I can select all if I need to.

Okay.

Now, once you've entered this worksheet and you're ready to submit for approval there's a ability to submit for approval before you submit for approval, there are times, where we need to allocate this this amount, based on a monthly.

A monthly amount so by default by by default Mike way allocates everything 112 so multi distribution here that it allocates that amount.

By 12 months Okay, but that's by default, but if I needed to make a change to that let's say, for example, I wanted.

I wanted to show these particular expenses in the first quarter of the year, I can go ahead and change that drop down the list and select first quarter second quarter or different.

distributions that a budget administrator can have available to me Okay, if I want it to be unique I can go ahead and add a different.

allocation, so I can go ahead and click on add here, and I can tell it well you know what I want to bet I want to spread this amount based on paying that amount in 50% in March.

And 50% in August and that's where the funds are going to be allocated so when it makes the entry into your MIT general ledger that total amount of 18,000 will be split only in the March and April, the other months will be zero.

Okay, so I can save that.

And if I have another expense that want, I would like to use that same spread I can go ahead and choose that spread for another month for another line item, so if I go ahead and put in 50,000 or 5000 here.

The same 5050 spread will be for this line as well, which is in March and in August okay.

So I don't have to come back in here modify the amount if I change this to 10,000.

It automatically will reallocate it into those two months, based on the new dollar amount is entered okay.

So that's the monthly spread and that's optional if if you wanted to use 12 months is, by default, but if you want it to be unique managers have the ability to make the own allocation if needed.

Okay there's also attachments you if you wanted to attach any backup or any type of information for the approval, you have the ability to attach any word excel PDF documents to it as well.

Now, when i'm ready to submit for approval, I can click on submit for approval, and this will generate an email notification to my approval, where whether it's a director, the CFO whoever needs to go for approval it's going to generate an email.

And that email will be sent to the person who has to approve the document whenever something is sent for approval.

I still have visibility of it, so I will see where it is at any given time so right now, it was sent to level 10 and these two documents are still here available for me to to work on okay.

And that, and this example i'm showing you here i'm i'm working on two or three budgets at one time okay now let's take a look at the reports for at least for the person who's entering the worksheets.

If i'm if I have maybe four or five different grants that i'm working on, I need to see a consolidation or see where.

Where Am I on a budget I can look at the budget worksheet summary, and this will give me a kind of view of all of my different programs.

or events, and I can see the total value for each one of them, so if I go bit by events i'll be able to see here's the event to one.

And a total amount is the event to your one and total amount, I can also see what worksheet it came from as well, this document number tells me what worksheet it comes from and i'll be able to see that information.

With the with the summary report okay let's go ahead and log out and log in as an improver.

Now, once the worksheet assented approval for for the review, this is a process and what it will look like i'm going to go ahead to approve worksheets and i'll see there i'm seeing two worksheets here waiting to be approved if I go ahead and open up one.

As an improver I can go ahead and look at the narrative information that can see what they've entered in the in the detail narrative.

If I want to counter what they have entered, maybe, for example, let's look at.

This particular line this this utility's line, and I wanted to counter I did not want to change what they've entered I can go ahead and put in some notes of what I would like them to to do or counter and i'll just say, I want to reduce this by.

500, for whatever reason, I want to go ahead and put in a.

An offset to what they've entered, so I can go ahead and do that leave the original entries here and just enter counter to that which will still reduce that line by 500.

Okay, I can go ahead and do that and I can do it for any line I feel another thing a manager can do, or an improver can do is reroute to document let's say, for example.

There are too many.

Too many things here that needs to be fixed and I want them to go through and make the correction, I can go ahead and we'll have this back to the person who prepared it and say hey I need you to me, to reduce the expenses by.

15,000 and we submit for approval so you're pushing it back to the managers have them make the edit instead of you okay so there's the reroute functionality to that.

If everything looks good and you're you know you want to approve this on to the next approval we can go ahead and click approve and that will move on to the next approval in the chain, again based on your workflow setup okay.

As an improver and as a budget administrator, you have the ability to consolidate and look at all these worksheets who may have 10 2030 worksheets out there.

And each managers are working on those particular worksheets.

You you have at any time, the ability to consolidate and bring it all together to see it in one report, even though they haven't submitted for approval, yet you still have the ability to see it.

In a report, you also have the ability to look at it, even though someone else is working on the worksheet so as an administrator.

If I wanted to if I sent a worksheet out to 10 managers and I wanted to kind of peek and see what they've entered so far.

I do have the ability to do that if to my document search for the approval, I can go ahead and look at managers worksheet I can make any changes, but I can see what they've entered and see what information to enter so far okay.

I can also run a consolidate worksheet report and this one is let's say the vents summary report and this one here i'm showing the GL and the event and i'm showing it in the pivot view.

So when I view this worksheet or when I view this report i'm seeing all of my events.

In a column type with all of my.

Expenses okay and it's also comparing like 2020 budget to whatever entered for 2021 if I just wanted to see one of the budget, which is.

My 2021 budget, I can also do that as well if I wanted to take this out and just look at the event all of my events and a total maybe revenues and expenses I just look at the expenses.

highlight those and chart these out, I can see, based on expenses with event.

52% is done is taken up by the administration.

And then 21%.

or 42% by the program expenses, so I can see a quick chart of expenses just by highlighting those those values okay also have the summary.

So let's take a look at the summary, the summary is basically allowing you to use MIT report groups, so you may have a report group set up in MIT That summarizes.

All of the other expenses salaries federal grant revenues certain things that you may want to categorize and not show the detail information, you can use that summary option as well, which is the group name here that allows you to see the MIT.

Report group names that you've built okay similar to your what you what you create in your financial statement.

So this is what it will look like.

For the budget administrator and who needs to pull all of these multiple worksheets that you have out there together in one report Okay, all of the all of the reports here can be printed and export it to excel So if I wanted to send it into excel I can go ahead and send it into excel.

Oh, I emailed him and said, but let me just show you here, open.

This is what it looks like export it to excel aware, you can work with it.

As its as it looks.

has a number and columns exactly from the reports that you export it out of my coin okay.

Now, once all the worksheets so we talked about the process you decentralize it where managers.

You first send the worksheets out to the managers, the managers give you the input it's gone to approval process and then, when you're ready to transfer this damn IP.

Again there's no important export in that you have to do to get it into MIT all you would have to do is navigate to approve worksheet select the worksheet click approve.

And right now, it will ask you for a budget version, if you want it to the recorded as original revise or any other version that you have set up.

We select that and then you click OK to process when it transfers them IP, this is the end result so here's the worksheet that i've transferred.

i'm it tells you, it was done by the person Annabel Martin click on start, and these are the entries and the document number, so this is the document number that came from my quite a 1009.

It has a description of the document and here all the line items that he created for you, with the effective date okay so again using the.

It breaks it all up into the different months and then your description which are your most likely general ledger description, so this is the completed by jet and you can go ahead and post this into MIT now.

When you post something into MIT and you realize that there is a change that needs to be made, or there was a mistake.

That you didn't realize, you can still fix that even though it's posted in a mighty Mike way allows you to reach transfer worksheet and if it we transfer the same worksheet.

It will ask you to go ahead and replace it if it's see that it was posted already in MIT so so you don't have to do reversal in MIT to reverse that budget Michael will handle all that for you will take it out of MIT and go ahead and push the new entries that you've corrected okay.

Now.

Any um anytime the budgets are posted in MIT and you wanted your managers to kind of look throughout the years and see.

Where they stand as far as activities against that budget there's the display account balance so let's say, for example, you've approved the 2021 or 2022 budget it's all posted in my P, and you want managers to come in here on a monthly.

basis to kind of see where they stand, what they've spent so far, what they have balance in each one of their account.

Without giving them access to MIT you can go ahead and control that to what we call the display account balance reports so in this display commands report.

They put into period put into workflow that they belong to click on view and it's going to go ahead and automatically pull the data, and this is coming from your general ledger in real time.

Okay, so, for example, it shows the budget column of what you've actually posted in my P, as far as the budget what you've spent so far, if you don't use in comments will be zero, and then the balance for each one of your account so, for example, if I am looking at.

office supplies, I have a total expense of 1965 I can also drill into that so without again without giving them access damn IP I can drill into this and see all of the ap invoices all of the different.

jb entries that affected that account, I can see that in in real time here and in under display, on balance, if you go into MIT and you post something.

It will show up here and we thought, if you created something and it's on posted you will still see it as well, so if you have a batch sitting out there, that you haven't.

process ap invoices for the managers will still be able to see that but it'll be under the on posted just like how we have here.

Okay.

So I hope I hope i've given you a quick I know a want to leave some room for any question and answers here so i'll kind of wrap things up now, but I hope I have given you enough.

Information to kind of give you an idea of what the budget module can help you do and give you a kind of quick overview of the process okay so unless I believe it's 15 Minutes that we reserved for any question and answer.

JMT Consulting: yeah this is perfect Thank you ricky we do have a few questions that i'll read out to you.

First question that came in, is one of you have a budget module and MIT.

Rickie George: If you have the budget module in am IP, then you can still use, but the budget module in MIT if needed, but for most people.

They may stop using the MIT budget module start using the micro module only because they may find more value in it.

JMT Consulting: All right next question, how does the salary budgeting work if you are using an outside payroll service like pay COM, instead of using the MIT modular.

Rickie George: Okay, so for anyone who's doing outside pill.

When there's there's an import process that allows you to import from MIT, which is the default.

But for anyone who's doing outside pill you'll have to do an import to a csv file and the csv file, it allows you to create an import template and i'll show you what that template looks like so it will produce a template for you.

Actually, let me show you what some data.

So this is what the.

The worksheet or the spreadsheet looks like it shows you what information Michael needs to import into the system, you would just have to get your third party or information into this format and then you'll be able to import it into my coin.

So it has you know the different salary amount it has the GL accounts they has.

percent increase if you want to increase their salary and so forth, all of the information hourly rate current salary, so I has all the information you, you would need to import that into my coin.

Now just personnel just just to just to be clear personal information is optional, you don't have to use the personal information if you wanted to.

If you have a spreadsheet that you're you're generating salaries farm and you just want to plug in those numbers or import those numbers, you can import those directly into a budget worksheet if needed.

Okay, so again, if you have the total salary by employee and allocation of each you do have the option to just create a worksheet and import all the salaries into that worksheet if needed.

All right next question can you use the system per position control by position name and number track all activity of a position and the personnel and budgets assigned to it.

It is difficult, unless you have a segment to to to track those position if you have a segment in MIT know my quick and do it, and by position, but when it sends it over time IP and you need to be able to track.

To that level MIT would require some sort of segment to identify those position, so you can track expenses and everything to that position.

If, if I understood the question, hopefully, I didn't understand the question, but you can ask a follow up if I did not answer it clearly for you.

But again, my my definition or our understanding of the position is that there's a segment here that's called position so whenever your budget in that person person.

You put your budget position that is sent into MIT and posted into the down ledger and you can then run reports, you can run and tie expenses to those position and look at not just salaries, but other expenses that are tied to that position.

JMT Consulting: right next question can you exclude test and the line items on the managers working budget and just show the salary line on the final budget, we do not want managers to see detail of salaries and benefits.

Rickie George: Yes, so in this example we showed I showed here, where you do not want to see these detail so if you do not want to see these detail when you set up the system, so when we go into the workflow.

I can check this option that says, do not include salary narrative on worksheet So when I check this option.

If I go ahead and push the worksheet information again with the salary data so i'm just going to refresh it here so notice before I refresh I can see that salary detail, but I can go ahead and refresh that.

Once I'm finished there the salary data comes over still the 55,000 but the narrative is not there to detail that makes up to 55 is no longer there okay.

So you have option to include it or not included.

JMT Consulting: One other questions so far and then we'll see if anything else comes in says, does the system have the ability to assist and building the revenue more detailed worksheets building to the revenue, for instance, can you put in how many expected ticket sales to go to an event revenue.

Rickie George: Okay that's a great question and may need to we may need to.

follow up with some of those whenever you deal with revenue.

What we find with.

web new we don't have specifically one that actually works, specifically for revenue, but what we've retrofitted kind of edge fit is the ability to use the personal information for that so.

revenues, we set up, we set up revenue, we set up a revenue account here use a revenue GL and then we use the same formulas so, for example, the number of classroom or the number of.

Events time so certain rate, so we use the same features of a personnel, which does a lot of the multiplication for us to come up with our revenue so number of patients times, an hour rate or number of days time, some sort of.

rate will get us to that revenue amount so for the personal information is similar but we use this for those purposes as well if you needed to come up with a calculation for your revenues based on participants and the rates and so forth.

So you won't use the benefit side, but more so.

The salary information and we don't the software does not care that you set up a revenue account on here, even though it's expecting salaries, it still will allow you to do that.

To to enter any type of GL account here we're on a not just tied to salaries.

But again it's it's it's simple, it may be just too simple for you and we may need to do a follow up to kind of get into some of the calculations you're doing under revenues to see if this really can handle that specific need.

And the good thing about it is that if you do let's say if we, we were able to to find out that a personal information can handle those type of calculations when it transfers to the worksheet.

When it do transfers to the worksheet if they if it's been allocated to different cost Center department grants and so forth.

It works, the same way as a personnel where that portion of the revenue will just be sent into this one worksheet so if 10% of those that overall revenue goes to this event, then only 10% will show on this worksheet.

any other questions or any follow up from the question that was answered.

JMT Consulting: Not as of yet so we'll give it just a minute to see if anybody else has any questions and, if not all that Dan wrap it up for us but.

we'll wait for just a second, if anything, comes in.

And just so you all know, we will be following up with you, after the webinars of the want to go more in depth with the questions that were asked we're happy to do that.

Dan Wharton: In a follow up as well.

JMT Consulting: Right I don't see anything else coming in, so Dan i'm going to let you take it away and ricky I appreciate it.

Rickie George: Thank you very much.

Dan Wharton: Can you let me share my screen, yes, I went ahead and stop sharing now.

Dan Wharton: Okay, so last couple slides here folks and thank you very much for for an awesome presentation rookie year i'd love the relationship between internal IP.

and microix and that's something I probably didn't spend enough time on but you know the benefit of the relationship that we have with you is is that you only produce solutions for my P customers.

which really means there's no there's no manual process you're reading the GL you're reading a P you're reading everything that the customer has already built without having to do any sort of extra steps, just to make things work it's it's truly magical.

Okay, so if anyone wants to see additional information might be entertaining the notion of looking at like Roi either for this year or next year, I encourage you to book a demonstration.

for doing so will give you a starbucks gift card, one of my personal favorites all you gotta do is just go to GMT consulting.com slash book and you are good to go.

take us up on an offer.

Alright what's up next, so this is part two of an ongoing series with micro part three, is on may 19 and we are going to cover timesheets.

Software time sheets, how do we link biometric hardware with those software time sheets, how do we connect local users remote users, how do we cover all of those things.

And this is great for MIT payroll customers, as well as non payroll customers, so you just have to have them IP and we can talk about how to automate the time sheets system, especially in this.

New world we live in, after that we'll wrap things up with inventory and on in June and what for registration links to follow.

that's it I think we're good.

JMT Consulting: Thank you all for joining us and have a great day.

Thanks everyone.

powered by