Integrate budget into application
We often ask grant applicants to include a copy of their budget. It would be helpful if a budget form could actually be included in the application process, rather than as just a separate file upload.
Thank you for the feedback thus far.
I think we are leaning towards the idea of denotating specific fields to be reportable. Do you have examples of the fields you would most like report on?
As for calculations which ones do you need? we know sum for sure, are there others?
More to come!
Paula Bellemore commented
I've developed a budget template and require applicants to download, complete, and then upload, but that means that those fields aren't reportable, which I would prefer, unless I ask the applicant to double-enter, which I don't want to do. My form is attached. My applicants particularly like the bottom of the form where it tells them if they are meeting all of our requirements.
One note - I would not want a budget to "fail" if anticipated funding exceeded expenses. That's just smart budgeting. So funds must equal or exceed expenses.
Sarah Winig commented
In addition to sum, we need multiplication (e.g. # of units * unit cost = sub-total)
Gloria Dillard commented
In addition to sums, percentage, and multiplication.
Melissa DeLaet commented
I would love to see the percentage/percent of change if applicable.
Percentage - our budget ask for them to add the cost for the whole budget and then what they are requesting from us. having the percentage info help to identify how much of the budget we're being asked to fund.
3. Yes, helpful for easy access to compare expenses vs. budget
Example: "Match Funding must be 20 percent of Total Amount Requested"
3. Yes! When there is a budget being requested in the application.
Lorna Sandberg commented
1. not necessarily
3. Yes, that would be helpful.
Also would be helpful"
- an error if a budget is submitted where expenses and revenue don't balance to zero
- if it auto-populates with their grant request amount in the application, and in the follow up with the granted amount
Hi Sammie - we too use a link to our budget...
1. certain fields
3. Not necessarily
Amy Nossaman commented
1. Denote fields
2. Self calculate would be very nice
3. Share between application and followup only necessary if there is a budget to actual fill-in capability.
Sara Cryan commented
This would also be helpful in the SLM world as some our scholarships require students to complete "College Budget Form" that include sections for the total education costs and sources of funding which then calculates their remaining need. We only use this for the scholarships that require interviews as our committees need to see a a detailed breakdown of this information.
Deanna Poelsma commented
2) Ideally, but if we can download the report in excel that world work too.
3) Would be nice, but not an absolute need.
Alberto Espinoza commented
Sammie, it would be helpful to report on every cell within the budget. Ideally, the budget would self calculate and be shared from application to follow up form. So excited you all are looking at this!
Vonda Carr commented
I agree with Amanda's comments especially transfer to the follow up as a reference column.
1) No you wouldn't need to report every cell within a budget (It would be nice, but not necessary). Certain fields would primarily be the sum totals (In-kind contributions, Cash Partners, Total Ask, Match calculations etc...)
2) Yes, self calculate would assist in human error :)
3) Yes, being able to share the budget from application to follow up form to reduce duplication efforts - or at the very least having it transfer for reference column in a new budget sheet for them to fill out an updated budget
I agree the budget is very important and it is important to incorporate the final budget not the draft or LOI budget if there are different versions of budget submitted during the LOI/application process periods.
I agree too, this would be very helpful
I strongly agree!
YES, please. This would be very helpful!!
Mark Petersen commented
I developed a budget template in Excel and put a link to it in my Budget question so applicants can upload it. It's not perfect - I'd prefer a better integrated solution - but it works in the short run to ensure all of our applicants' budgets have a similar framework. I've used this solution now for about five or six years.