Percent of Budget used.

Paul Swan
Paul Swan
Eighth Anniversary Facilitator 1 Blackbaud Certified
in Blackbaud Financial Edge NXT® General Discussions

Is there a way to show the percent of budget used on a report? If so, what report would be best to show this? We are wanting to show our Dept. Heads what percentage of their budget they've used for the year each month to give them a better idea of how much they have left in the accounts. We've used the income statement report in the past to show budget to actual, but we didn't know if there was a better report to show budget to actual along with what percentage was available used for the whole FY.

Comments

  • Matt Boose
    Matt Boose Blackbaud Employee
    Tenth Anniversary Name Dropper Participant Facilitator 1

    @Paul Swan Hi Paul, I would suggest the Income Statement that you have used previously. After you have created the 2 columns for Actual and Budget, you can create 2 additional columns to show variance by dollar and variance by percent.

    After adding a new column in the Income Statement, click “Insert Variable”. The variable named “GetFavorableUnfavorable” will display variance by dollar of the 2 columns you select after. The The variable named “GetPercentVariance” will display variance by percent as you are seeking.

  • Siesha Moultrie
    Siesha Moultrie
    Second Anniversary Name Dropper Participant Facilitator 1

    @Paul Swan
    Hey Paul! I agree with the Income Statement using additional columns. We always show % of budget used to date, change from prior year, % of budget variance. When creating the column use the number format to show percentage & even simple division of the columns with insert variable works for us. There are really a lot of options! Good Luck!

Categories