Using Budget Overview for Project Budgets in NUFinancials
This guide explains several common scenarios for using the Budget Overview feature in NUFinancials to find project budgets and actuals.
Navigate to the Budget Overview Search
- Login to NUFinancials: nufin.northwestern.edu.
- From the Main Menu, click on the Navigator compass > Navigator > Commitment Control > Review Budget Activities > Budget Overview.
Create a new Budget Overview Search
- Click the Add a New Value tab.
- Each subsequent time you return to the Budget Overview, you can find the searches that you created with the Find an Existing Value tab.
- Type an Inquiry Name.
- There are 10 characters maximum.
- Do not use spaces in the name. You may use the underscore _ instead (shown above).
- Do not use symbols.
- Click Add. Result: the Budget Inquiry Criteria page appears.
Complete the Budget Inquiry Criteria page in seven steps that vary per your search scenario. Explanations follow below.
Search 1: Grant Project Actuals by Account Code
This search answers the question "What were the expenses for an account code on a grant?" Beginning on the Budget Inquiry Criteria page, complete the following steps.
# |
Field / Function |
Step |
---|---|---|
1 |
Description |
Enter a description to help you recognize the search in the future. |
2 |
Ledger Group |
Type or select KK_DETAIL. |
3 |
Type of Calendar |
Select Detail Accounting Period to enter a customized date range (grant budget year), or select Detail Budget Period to search by fiscal year. |
4 |
Budget Period |
Enter a date range corresponding to the Type of Calendar.
|
5 |
ChartFields |
Enter your chart string search criteria.
|
6 |
Save |
Click Save. NUFinancials validates the search criteria. |
7 |
Search |
Click Search. All budgets that meet your search criteria appear. If you do not see all your budgets, enter a higher number in the Max Rows field and then click Update. At the bottom of the page, click Return to Criteria to go back to the search criteria page. Click any hyperlink to see what transactions make up that total. |
"Why should I use this search instead of running a Cognos report?"
This search is useful because Cognos does not currently have a report that limits expenses by account code. You can also use this search to limit the data to a specific timeframe within a single grant activity period.
Search 2: Grant Project with a Custom Date Range
This search answers the question "What were the expenditures for a specific period of time?" Beginning on the Budget Inquiry Criteria page, complete the following steps.
# |
Field / Function |
Step |
---|---|---|
1 |
Description |
Enter a description to help you recognize the search in the future. |
2 |
Ledger Group |
Type or select KK_PRJ_DT. |
3 |
Type of Calendar |
Select Detail Accounting Period. |
4 |
From / To Year / Period |
Enter a date range corresponding to the Type of Calendar.
|
5 |
ChartFields |
Enter chart string search criteria.
|
6 |
Save |
Click Save. NUFinancials validates the search criteria. |
7 |
Search |
Click Search. All budgets that meet your search criteria appear.
|
"Why should I use this search instead of running a Cognos report?"
- The Cognos GM045 provides data summarized by inception-to-date, fiscal year, or activity period. However, it cannot limit the data to a specific time period within a single activity period for sponsored projects.
- Note that the Budget Overview data does not include F&A on encumbrances. It must be manually calculated.
Search 3: Grant Project and Activity Period
This search answers the question "What are the expenditures during an activity period of the grant?" Beginning on the Budget Inquiry Criteria page, complete the following steps.
# |
Field / Function |
Step |
---|---|---|
1 |
Description |
Enter a description to help you recognize the search in the future. |
2 |
Ledger Group |
Type or select KK_PRJ_DT. |
3 |
Type of Calendar |
Select Detail Budget Period. |
4 |
Budget Period |
Don't change anything in this area. The values are auto-populated. |
5 |
ChartFields |
Enter your chart string search criteria. Only those budgets you have permission to view appear.
|
6 |
Save |
Click Save. NUFinancials validates the search criteria. |
7 |
Search |
Click Search. All budgets that meet your search criteria appear.
|
"What is the difference between this search and Cognos report GM045?"
- Budget Overview data does not include F&A on encumbrances. This data is current as of the moment you search.
- The Cognos GM045 does calculate F&A on encumbrances. This data is current as of the night before.
Search 4: Designated Projects and Associated Revenue
Designated projects without revenue budgets may occasionally bring in revenue. With this search, you can see Associated Revenue and check balances on designated project budgets. Beginning on the Budget Inquiry Criteria page, complete the following steps.
# |
Field / Function |
Step |
---|---|---|
1 |
Description |
Enter a description to help you recognize the search in the future. |
2 |
Ledger Group/Set |
Select Ledger Inquiry Set from drop-down menu then click magnifying glass next to Ledger Inquiry set field. Choose EXP_REV_DT for detail level inquiries or EXP_REV_PR for summary level inquiries. Associated Revenue is represented in the Recognized Revenue field on Inquiry Results page |
3 |
Type of Calendar |
Select Detail Budget Period. |
4 |
Budget Period |
Don't change anything in this area. The values are auto-populated. |
5 |
ChartFields |
Enter your chart string search criteria. You can search for projects using Department IDs, Project IDs, or both. Only project budgets included in your row level security will appear.
|
6 |
Save |
Click Save. NUFinancials validates the search criteria. |
7 |
Search |
Click Search. All budgets that meet your search criteria appear.
|
Ledger Inquiry Sets allow Expense and Revenue data to be viewed in parallel within same search. All details about the revenue transactions that comprise Associated (Recognized) Revenue are accessible in search results.
Appendix A: Totaling Budget Categories in Excel
The Budget Overview enables you to export data to Excel and manipulate the data just as you would any spreadsheet.
In order to see totals by budget category, export the result of your search to Excel. Then sort the data by the Account column. Total the Budget, Expense, Encumbrance, Pre-Encumbrance, and Available Budget columns.
A sample is shown below.
Fund |
Dept |
Project |
Activity |
Account |
Fiscal Year |
Period |
Budget |
Expense |
Encum |
Pre-Encum |
Available Budget* |
% |
---|---|---|---|---|---|---|---|---|---|---|---|---|
610 |
8237100 |
60014626 |
01 |
60010 |
2008 |
12 |
0.00 |
165284.56 |
0.00 |
0.00 |
-165284.56 |
0 |
610 |
8237100 |
60014626 |
01 |
60010 |
2009 |
4 |
752591.00 |
95594.94 |
0.00 |
0.00 |
538938.68 |
71.61 |
610 |
8237100 |
60014626 |
01 |
60010 |
2009 |
5 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0 |
752,591.00 |
260,879.5 |
0.00 |
0.00 |
373,654.12 |
||||||||
610 |
8237100 |
60014626 |
01 |
60180 |
2008 |
7 |
0 |
3,426.36 |
0 |
0 |
-3,426.36 |
0 |
610 |
8237100 |
60014626 |
01 |
60180 |
2009 |
4 |
90,160.00 |
11,149.46 |
2,006.97 |
0 |
77,003.57 |
85.41 |
610 |
8237100 |
60014626 |
01 |
60180 |
2009 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
90,160 |
14,575.82 |
2,006.97 |
0.00 |
73,577.21 |
||||||||
610 |
8237100 |
60014626 |
01 |
73000 |
2009 |
3 |
1,190,328.00 |
13,842.48 |
11,692.62 |
0 |
1,164,792.90 |
97.85 |
610 |
8237100 |
60014626 |
01 |
73000 |
2009 |
5 |
0 |
17,843.58 |
6,487.80 |
0 |
-24,331.38 |
0 |
1,190,328 |
31,686.06 |
18,180.42 |
0.00 |
1,140,461.52 |
||||||||
610 |
8237100 |
60014626 |
01 |
75000 |
2008 |
7 |
0 |
3,542.40 |
0 |
0 |
-3,542.40 |
0 |
610 |
8237100 |
60014626 |
01 |
75000 |
2009 |
3 |
408,000.00 |
13,452.00 |
0 |
0 |
394,548.00 |
96.7 |
408,000 |
16,994.40 |
0 |
0.00 |
391,005.60 |