Discover How to Use a Progress Billing Sample for Nonprofit Effectively

Progress billing sample for Nonprofit

hi my name is dave abel and i'm a senior solution consultant at sagentac specializing in nfp governmental and ngo requirements sage intact's grant tracking and billing module helps organizations ensure compliance with grant requirements by maintaining efficient and accurate grant tracking reporting and reimbursement processes mission success becomes much more attainable today we're going to take a look at sagentech's feature set surrounding grant tracking and billing and differentiate between the two options available implementing just the grant dimension for tracking and reporting purposes or the full grant tracking and billing module the latter will provide extended functionality in the areas of automated reimbursement billing organizational requirements will drive if the system is set up to track grants with a dimension alone or extended to include reimbursement invoice generation by leveraging the grant billing capabilities included in the grant module as well if grant tracking is started using only a dimension scaling into using the extended functionality by subscribing to the full application is always a future option as the needs for grant tracking grow sage intact can be configured to simply track grant activity using a dimension by itself while this method satisfies the basic grant tracking requirements and is easy to use the process of gathering your grants and deciding which are billable is more manual and is reliant on externally enforced business process controls furthermore it provides a less detailed trail for historical purposes with this method of tracking you simply add the grant dimension at the line level of transactions that relate to your grant then when you want reimbursement you drive the process through reporting which will provide both the backup detail as well as the amounts needed for a reimbursement request conversely you can automate the grant tracking and reimbursement request process through the full module this path offers more precision and system control and more importantly allows you to identify which expenses are eligible for settlement therefore maximizing your reimbursement by dynamically gathering all amounts not previously built by establishing the grant dimension as billable through the selection of a billing type and using it on transactions the generate invoice process will automate reimbursement billing to each grantor by dynamically gathering transactions that have been marked as billable but not yet invoiced you can flag the following transactions as billable ap bills purchase orders general ledger journal entries employee expenses and timesheet entries let's take a closer look at how all this works inside of sage intact okay so here we are inside of sage intact and we're going to take a look at the differences between just using the grant dimension or the full grant module so where we are right now is on a dashboard that i'm calling my grant manager dashboard and it's showing us a variety of information [Music] against a grant or several grants we have several components here with different reports and performance cards and as you can see here we're showing our grant activity as rows on this particular report and the way we were able to accommodate this was to code the transactions to an actual grant dimension so for instance for the community development block grant you see that we have some budget activity some revenue that's booked a remaining draw and some expenditures the expenditures were entered into the system through bills or journal entries by coding those transactions to the grant dimension so let's go ahead and drill into this amount here and it'll bring up the general ledger report and this is what's going to drive your billing now okay like i mentioned earlier it's more of a manual process you're going to be able to to get to your activity through running a report and then placing it onto an invoice to send to your grantor if we scroll down here you'll see that we have an office supply section and a variety of different bills that were coded to the community block grant dimension let's drill into one of them here this 125 and this will bring up the bill and then on the bill line the entry line you'll see that we coded it to the grant dimension so this would be the same for any other type of transaction in the system whether it was a time entry an employee expense entry maybe a purchase order you'll be able to code the transactions to a dimension that's representing the grant and then you'll be able to report against it to generate your billings your reimbursements uh back to the grantor okay so a different approach might be following that same process where you're gonna put bills in and using the grant to mention but now we're going to automate the creation of the invoice back to the grantor so let's take a look at a couple more transactions that i have in the system here first of all i have an ap bill that i've set up to sam's club and then down here on the line you'll see that i coded it to the grant community development block grant and it's for fifteen hundred dollars and fifty cents okay and also on this line if i show the details you'll see that it was a billable transaction okay also i have some time that i've put into the system here in a time sheet and on the timesheet i have coded it to again the block grant and also made this time billable so through configuration you'll be able to set up uh that time will be coded against maybe a particular billing rate and then it will accumulate all that time multiply it against the billing rate and come up with a billable dollar amount back to your grantor the way that you're able to accommodate this is over here under generate invoices so when you go to the grant module off the main menu and click on generate invoices this form will pop up and what you're able to do is generate invoices in a variety of different ways for today's example we're just going to focus on one grant however you could run them all in unison you can generate invoices all at once and it'll cue them up for you however we're going to focus on just a grant notice also that you can generate invoices by funder right so maybe even a funder that's granting you or giving you multiple grants and you can go ahead and invoice them by the funder instead of just the individual grants so here i'm going to click on grant and we're going to do a drop down and select that that block grant that we've been coding transactions to okay so at this point i can fiddle around with my invoice date my posting date i'm going to keep it at in fact let me make this 10 31 i can generate an invoice at the end of october and i'm going to click on preview here which is going to go fetch all of the transactions that are currently in the system as unbilled okay now you'll see here that i have a form that pops up it shows me all the time that was entered into the system okay and also i have an invoice here that 1500 dollars and 50 cents so at this point i can toggle off those items that i do not want to build this point and maybe i want to leave off the time that was put in for 11 1 and leave all the other october time in there and i'm going to uh for now let's just leave off this invoice again because it's a november bill so you can see here you'll have the different sections employee expenses purchasing transactions even order entry transactions and gen journal transactions if i want to bring journal entries in for instance maybe you're bringing payroll into your system uh through an outside vendor and you want to mark that as billable all right and so instead of putting it as time right you want to bring it in as just regular payroll and the market is billable that you can build back to the to the grantor so let's go ahead and leave this as such and we're going to click on create invoice and as the system processes uh eventually it'll come up with a a message here that tells us that the invoice was generated uh successfully and you can see here that it's invoice number zero zero five five so let me go ahead and copy that number and i'm going to click cancel here and now i'm going to go back out into my order entry area and bring up ar invoices okay and i'm going to put a filter there and it brings up the invoices that was just generated the invoice that was just generated and by viewing that invoice we'll be able to see the detail inside of it which is all the time basically that was multiplied by a price of a hundred dollars so for all that time that we booked to that community development block grant for the california uh and this could be any funder you want to be right so it would basically send the california endowment this uh this uh invoice and it would be for seven thousand two hundred dollars uh because it was all that time multiplied by a hundred okay and of course within sage intact you can create uh the invoices that you want to send to the uh to the to the grantor um you'll have full control over what you want those invoices to look like before you actually email or mail them out so i hope this was helpful in making sense uh about the differences between just conducting your grant activity or grant tracking through just a grant dimension and then bringing in the full grant module where you can in addition to do your grant tracking actually automate the process of creating your grantor invoices your time and material reimbursable invoices okay if you have any other questions you can contact your customer account manager and they'll be able to help you thank you