Create a Functional Expense Report Format
We are required to submit a functional expense report for our audit that shows how all salaries or other line items are broken between our programs. Right now there is not an option to create separate columns for each program, we have to print our ledger by separating programs in the content section and then use excel to show the data.
Comments: 2
-
29 Sep, '21
Suzanne AdminHello,
The MIP team is actively monitoring this request. Please continue to provide screenshots, comments, and upvotes.
Cheers,
Megh -
24 Feb, '22
Megh Waltimire AdminThank you to all those who provided up votes. We held a focus group on this and found that customers are using various reports available today to create these so MIP will plan to let customers continue in that fashion.
Below are a couple examples:
"We were able to create our own by using the combining R&E report as a basis. We created our functional cost categories (ie wages, benefits, direct costs, etc...) then assigned each object code to those categories. We then moved our fund numbers in the sequence we wanted them and used a subtotal name to gather similar grants together. I then exported this to excel and hid the individual programs to just see the subtotals with their functional expense categories."
"You can "assemble" or group each of you statement of function expense column accounts using the Assign Report Group feature. Use the Combining Statement of Rev &^ Expense report and you can print the statement of functional expenses out with or without grouping by program."