sponsored accounting advanced financial reports
DESCRIPTION
Sponsored Accounting Advanced Financial Reports. Agenda. Repository Reports Recap, Feedback and Adjourn. FAB Reports – Sponsored Repository Reports. Overview. Where do I find the Sponsored Repository Queries How do I run the Sponsored Repository Queries How do I view the results - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/1.jpg)
SPONSORED ACCOUNTING ADVANCED FINANCIAL
REPORTS
![Page 2: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/2.jpg)
AGENDA
Repository Reports
Recap, Feedback and Adjourn
![Page 3: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/3.jpg)
FAB REPORTS – SPONSORED REPOSITORY REPORTS
FAB Reports Use Location
Sponsored Project Payroll Activity Detail Report
List of Sponsored Project Payroll transactions for employees.
FAB Folder Grants Subfolder
Sponsored Projects Payroll Activity FYTD Summary
List of total labor charges and open commitments for each employee for the current fiscal year to date.
FAB Folder Grants Subfolder
Sponsored Payroll Fringe Report
Provides sponsored project information for payroll activity and related fringe and facilities and admin (F&A) costs from July 1, 2005 through the current date.
FAB Folder Grants Subfolder
Project Run Rate Provides information on financial performance of sponsored projects, as well as, six and twelve month average spending by project.
FAB Folder Grants
Subfolder
Grants Available Budget Balance Enhanced
This Query provides Net Budget, Activity Fiscal YTD, Open Commitments, and the Available Budget Balance, by GL account or Budget Account with in an Area, Department or Project based on parameters selected by the end user.
FAB Folder Grants
Subfolder
![Page 4: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/4.jpg)
OVERVIEW
Where do I find the Sponsored Repository Queries How do I run the Sponsored Repository Queries How do I view the results How do I print the results How do I interpret the data
![Page 5: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/5.jpg)
Report Repository
Click on the FAB (Financial, Accounting, and Budget
System) Folder
WHERE DO I FIND THE SPONSORED GRANTS QUERIES?
![Page 6: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/6.jpg)
Report Repository
Click on Grants Link
WHERE DO I FIND THE SPONSORED GRANTS QUERIES?
![Page 7: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/7.jpg)
SPONSORED PROJECT PAYROLL ACTIVITY
DETAIL REPORT
![Page 8: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/8.jpg)
Report Repository
WHERE DO I FIND THE SPONSORED PROJECT PAYROLL ACTIVITY DETAIL REPORT?
Click the file name to View Document.
![Page 9: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/9.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I RUN THE QUERY?
Click Process to limit query
![Page 10: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/10.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I RUN THE QUERY?
1. Enter the Fiscal Year or Ignore to select all.
2. Choose from drop down box to change operator.
3. Click OK.
![Page 11: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/11.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I RUN THE QUERY?
Note: There are currently 9 Limit Boxes available for your use:
1. Fiscal Year
2. Department Id
3. Program Code
4. Project Id
5. Activity Id
6. Account
7. MyCode
8. Journal Date
9. Employee Id
![Page 12: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/12.jpg)
HOW DO I VIEW THE RESULTS?
12
![Page 13: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/13.jpg)
13
HOW DO I VIEW THE RESULTS?
13
Note: You can sort your report by a number of ways:
1. Employee Summary
2. PAD by SUID Number
3. PAD by Project Number
4. PAD by Dept, by Project Number
![Page 14: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/14.jpg)
SPONSORED PROJECT PAYROLL FYTD
SUMMARY
![Page 15: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/15.jpg)
Report Repository
WHERE DO I FIND THE SPONSORED PROJECT PAYROLL ACTIVITY DETAIL REPORT?
Click the file name to View Document.
![Page 16: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/16.jpg)
19
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY
HOW DO I RUN THE QUERY?
Click Process to limit query
![Page 17: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/17.jpg)
20
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY
HOW DO I RUN THE QUERY?
Note: Additional query criteria are available from drop down menu
1. Enter the Fiscal Year or Ignore to select all.
2. Choose from drop down box to change operator.
3. Click OK.
![Page 18: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/18.jpg)
21
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY
HOW DO I RUN THE QUERY?
Note: There are currently 5 Limit Boxes available for your use:
1. Fiscal Year
2. Department Id
3. Project Id
4. Program Code
5. Employee Id
![Page 19: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/19.jpg)
HOW DO I VIEW THE RESULTS?
22
Click Spons Proj Payroll FYTD Summary
![Page 20: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/20.jpg)
HOW DO I VIEW THE REPORTS?
23
![Page 21: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/21.jpg)
SPONSORED PAYROLL FRINGE
![Page 22: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/22.jpg)
WHERE DO I FIND SPONSORED PAYROLL FRINGE?
Click the file name to View Document.
![Page 23: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/23.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY
HOW DO I RUN THE QUERY?
Please note: The From Date must be greater
than or equal to 7/01/2005
Click Process Query.
*Current Date*
![Page 24: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/24.jpg)
27
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE RESULTS?
Choose desired report
*Current Date*
![Page 25: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/25.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE RESULTS? Report by Project, Account
and Name
![Page 26: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/26.jpg)
29
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE RESULTS? Report by Name and Project
![Page 27: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/27.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE RESULTS? Report by Project, Name
and Account
![Page 28: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/28.jpg)
31
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE RESULTS? Report Corrections by Project and Account
![Page 29: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/29.jpg)
PROJECT RUN RATE
![Page 30: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/30.jpg)
WHERE DO I FIND PROJECT RUN RATE?
Click the file name to View Document.
![Page 31: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/31.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I RUN THE QUERY?
Uncheck All Projects and All PI’s if you do not want all projects and
PI’s.
*Current Date*
![Page 32: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/32.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I RUN THE QUERY?
Uncheck All Projects and All PI’s if you do not want all
projects and PI’s.
1. Select a Project 2. Select a PI 3. Click Process
*Current Date*
![Page 33: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/33.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE REPORT?
Click View Report
*Current Date*
![Page 34: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/34.jpg)
37
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE REPORT?
![Page 35: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/35.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
Click back arrow to go back to previous screen
HOW DO I VIEW THE REPORT?
![Page 36: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/36.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I LIMIT THE REPORT?
Select Payroll
*Current Date*
![Page 37: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/37.jpg)
40
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I PRINT THE REPORT?
To print the report Select Print Report
![Page 38: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/38.jpg)
GRANTS AVAILABLE BUDGET BALANCE
ENHANCED
![Page 39: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/39.jpg)
WHERE DO I FIND GRANTS AVAILABLE BUDGET BALANCE?
Click the file name to View Document.
![Page 40: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/40.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I RUN THE QUERY?
1. Enter the Fund Code or Ignore to select all.2. Enter the Area ID (3 digits) or Dept ID (5 digits)3. Enter the Project ID or Ignore to select all4. Enter the CONtract number or Ignore to select all5. Enter the Fiscal Year or Ignore to select all6. Select the reports you would like to view. (The Area
Reports are not available if you enter a Department ID)
7. Click “Process Query” to run
*Please note: If you do not select a Fund you will receive all transactions (including cost-share activity)
![Page 41: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/41.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE RESULTS?
Click desired Report.
![Page 42: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/42.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE REPORT?This report shows Net
Budget, Activity Fiscal YTD, Open Commitments and Available Budget Balance by Area.
![Page 43: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/43.jpg)
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE REPORT?This report shows Net
Budget, Activity Fiscal YTD, Open Commitments and Available Budget Balance by Area.
A Fund other than 13 indicates cost share
![Page 44: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/44.jpg)
47
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE REPORT?This report shows Net Budget,
Activity Fiscal YTD, Open Commitments and Available Budget Balance by Budget and GL account.
![Page 45: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/45.jpg)
48
THE TRANSACTIONS AND AMOUNTS IN THESE MATERIALS ARE FICTITIOUS AND HAVE BEEN CREATED FOR TRAINING PURPOSES ONLY.
HOW DO I VIEW THE REPORT?This report shows Net Budget,
Activity Fiscal YTD, Open Commitments and Available Budget Balance by Budget and GL account.
A Fund other than 13 indicates cost share
![Page 46: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/46.jpg)
NEED ASSISTANCE? General FAB Questions
contact the FAB Service Center: E-mail us at
[email protected] Phone us at 443-8787
For General Ledger Related Assistance contact General Accounting: E-mail us at
[email protected] Phone us at 443-2522
For Specific Project Related Assistance contact Sponsored Accounting: E-mail us at
[email protected] Phone us at 443-2059
For Budget Related Assistance contact The Office of Budget and Planning: E-mail us at
[email protected] Phone us at 443-4214
![Page 47: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/47.jpg)
FAB RECAP, FEEDBACK AND ADJOURN
![Page 48: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/48.jpg)
RECAP
Repository Reports
Recap, Feedback and Adjourn
![Page 49: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/49.jpg)
QUESTIONS?
![Page 50: Sponsored Accounting Advanced Financial Reports](https://reader034.vdocuments.us/reader034/viewer/2022051418/568157c8550346895dc55034/html5/thumbnails/50.jpg)
SPONSORED ACCOUNTING ADVANCED FINANCIAL
REPORTS