![Page 1: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/1.jpg)
I - Strategy Budget ReportsTraining Exercise Presentation
Presented by Teresa James
September 25, 2012
![Page 2: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/2.jpg)
Get started: Click on the I-Strategy Website
https://frweb.usg.edu/pas
![Page 3: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/3.jpg)
Places where the iStrategy link can be foundNote: Remember with i-Strategy will need to use Internet Explorer
![Page 4: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/4.jpg)
Click the iStrategy button to continue to login.
Note: There is no logout in iStrategy.
![Page 5: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/5.jpg)
Enter your user name and password. Click OK.
![Page 6: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/6.jpg)
Click on “Standard Reporting Catalog”
![Page 7: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/7.jpg)
Click on “Budget to Actuals”.
![Page 8: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/8.jpg)
Click on “Expenditures By Dept”
![Page 9: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/9.jpg)
If your departments do not display, click on the “Compatibility View” icon located at the top by the address bar.
![Page 10: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/10.jpg)
Below is our Hierarchy Setup (Division-Department). Highlight the division that your department falls under by simply clicking on it. In the example below we clicked on “Fiscal Affairs”.
There are 4 ways to expand: (1) Select your department name, then click “Drill Down To… click on Department” (2) select the Expand box on left hand side under navigation, (3) select the down arrow by
the Department, or (4) left click on Department -select expand
1
2
3
4
![Page 11: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/11.jpg)
If you have more than one department, you can expand the “Department.” We will use the first way mentioned on expanding: Select your department name, then click “Drill Down To… click on Department” In our example below we will expand the Fiscal Affairs, then expanding the Purchasing Dept and view department numbers listed.
![Page 12: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/12.jpg)
This will list each of your departments (if have multiple). Each manager can drill down into the Budget, Open Encumbrances, and Actual amounts on any of the
departments listed.
![Page 13: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/13.jpg)
Always use the options under ACTIONS (ex: Drill Enhanced Journal)
To drill down on columns: Budget, Open Encumbrance, or Actual simply highlight by clicking the amount under the column you want
Always use the options under ACTIONS (ex: Drill Enhanced Journal)
![Page 14: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/14.jpg)
This is the report that will be generated from the Drill Enchanced Journal function. If the option is available, there are some links (in blue) under “View Sub-ledger” that will provide further details for a particular expense. When finished with this report, just close the screen by clicking the “X” at the top right-hand corner.
First time generating the journal detail you will be asked to login again, use the same iStrategy username and password .
Can drill down on the View Sub-ledger
![Page 15: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/15.jpg)
To look at “Expenditures by Account”, simply go back by clicking on “Budget to Actuals” link in the breadcrumbs (located below the tabs at the top of the page). Then click on “Expenditures by Account” link.
Breadcrumbs
![Page 16: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/16.jpg)
This will show overall budget for each listed category. Remember: If you manage more than one department, each of your
departments will be visible.
![Page 17: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/17.jpg)
Click on “Travel” go to the left, click on the drop down arrow by “Drill Down to”…select “Account – Travel”.
![Page 18: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/18.jpg)
To see more detail regarding an expense type such as Travel, click on “Travel- Employee- Non-Mileage”, then on the left click on the drop
down arrow by “Drill Down to”…select “Account – Travel-Employee – Non-Mileage”.
![Page 19: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/19.jpg)
To review what has been spent for lodging, click on the dollar amount in the “Actual” column for lodging. On the left under “Actions” click on “Drill Enhanced Journal” link.
Always use the options under ACTIONS (ex: Drill Enhanced Journal)
![Page 20: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/20.jpg)
This is the report that will be generated from the Drill Enchanced Journal function. If the option is available, there are some links (in blue) under “View Sub-ledger” that will provide further details for a particular expense. When
finished with this report, just close the screen by clicking the “X” at the top right-hand corner.
Can drill down on the View Sub-ledger, if link exist. This example doesn’t have any further details can drill down on.
![Page 21: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/21.jpg)
What to do if no results are listed on the report?
If no details display see if there is a plus symbol showing by
“Show Accounting Information”, if so click it for the details to
show. Results Displayed
![Page 22: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/22.jpg)
Please remember to always use the “Drill Down to” options on the left-hand side of the screen as well as the Action
options when want to review totals.
![Page 23: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/23.jpg)
![Page 24: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/24.jpg)
Budget Adjustment Form
• Any time an office wishes to make one of the transfers listed below a budget adjustment form will need to be completed and submitted to Teresa James: – Travel funds to their General Operating or Equipment
budget– General Operating funds to their Travel or Equipment
budget– Equipment to their Travel or General Operating budget
![Page 25: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/25.jpg)
Budget Adjustment Form
• During this year, the Office of Accounting and Budget will complete this budget adjustment form for each office and forward to them for their approval.
• A department cannot make any adjustments to their payroll budgets.
![Page 26: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/26.jpg)
![Page 27: I - Strategy Budget Reports Training Exercise Presentation Presented by Teresa James September 25, 2012](https://reader035.vdocuments.us/reader035/viewer/2022062407/56649ca55503460f949662e3/html5/thumbnails/27.jpg)
Expenditure Review/Transfer Form
• It is essential to review your expenditures for any discrepancies on a bi-weekly or monthly basis throughout the year.
• Any discrepancies will need to be noted on the expenditure review form and submitted to Teresa James.