Finance General Ledger User Guide
Contents
1. 53075 Pay Overtime 53080 Pay Variable Pay M amp P Total Salaries Benefits 55170 Ben Staff Training 56005 Allocated Benefits MAPS 56010 Allocated Benefits AUPE 56015 Allocated Benefits Other Total Benefits Total Salaries and Benefits Non Salary Expenses Materials Supplies and Serv 60035 Miscellaneous Expenses 14 Student Dashboard User Guide 5 6 How to read the report The Variance columns are calculated as follows Variance Budget Actual Variance 96 Variance Budget x 100 signage reversed for Revenue The color of the Variance 96 provides a visual indicator of whether the Variance is within an acceptable range or not For revenues the favorable condition is for Actual to be larger than Budget while the reverse is true for expenses Greater than 2596 gt Excellent Between 25 and 0 gt Good Between 096 and 2596 Fair Less than 2596 Poor A blue underlined value indicates that a drill through to transaction details is available for that item Click on a link to launch the Finance Analysis Detail report in a new browser window It will display all detailed information that composed a particular cell Be careful when attempting to drill through on items that may have large numbers of transactions e g entire years or faculties as this may take a long time to produce 15 Student Dashboard User Guide 6 Fin2. modules e g Procure to Pay are available for certain items Go to Public Folders Enterprise Reporting If you have problems or questions Jan 13 2012 GLR 01 please contact us by logging a ticket Student Dashboard User Guide T OVERVIEW aceite rtr T HE 2 11 Whatis Finance Genet dl ledger osse ata ENEMIES ME dE 2 12 lHow tcurrentis the data iubeo o vo bo v v v db vb VP 2 1 3 MWhatreports are available sisse dd dod a a eo eot pep RS 2 I4 Getting help and IHTOETeEO i esisiini Dota babeo rtad ut oto ats L obe iata bebete tu Pebulats bubeb utetur 2 2 ACCESSING THE FINANCE MAIN PAGE 1 eren nnn 3 2A HOW TO ACCCSS E T nbamndee acca revs neasneubanabna EEE EErEE 3 2 2 W atis this page TOR iion 6 3 FINANCE ANALYSIS SUMMARY 1 eere nnn nnn nnn nnn nnn nnn nnn na 7 3d Whati this Tepr TON oerien siganeen sadunsen sequo ada sEso oss uteso Sas esafusa Sepatu aai 7 22 iMandatory Ddtallie tel Ss a TE EAE OEE A Ma M MID dele 7 A OPONA E es eee a ee UU EDI DAS CUR I EDU CO NICO DN CIRCE UNDAP USD 7 Seb Additions Parameter Ss onp EEE E EERE R EIR E DREPE 7 SEN TR PRESTO MM 8 3 b JHowsto teda tie rE DOL snae xU DE c M C M A EM UN RUN DN PUES 9 4 FINANCE ANALYSIS DET Alb 22 nonna an nun uuu ncn a uunR Si uuuu ru nu uuu una run uan uana 10 AT MhstisthisreDOFt TOI eusaceim vv EVE A 10 4 2 Mandatory pararmiet ers ossbe
3. next sequential number in department s range e 1xxxx Asset e 2XXXX Liability e 3xxxx Net Assets Equity e 4xxxx Revenue e 5xxxx Salary amp Benefit Expenses e 6xxxx Non Salary Expenses e XXXX Internal Transfers conversion e XXXXx where Xxxxx MEMO post conversion e XXXXX where xxxxx next sequential number conversion e aaa0xxxxx where aaa source code amp Xxxxx MEMO post conversion e aaaxxxxxx where aaa source code amp Xxxxxx next sequential number conversion e aaxxyyyy where aa HT PP or PE xx MAJOR yyyy INTER e aazzzzzz where aa OP zzzzzz FEXT project number post conversion e aaxxxxxx aa RT PP OP PE and xxxxxx next sequential number conversion e XXXXX where xxxxx MEMO post conversion e XXXXX XXXXx next sequential number 19
4. ar REPORTING The Finance Reporting suite allows you to explore the General Ledger and related subsystems in a flexible manner High level analytics can be performed with linkages to transaction details on demand These reports are designed primarily for use with operating funds Although it is possible to include research funds project accountability statements cannot be accurately generated Please contact the Research Accounting office for project reporting options currently available to you Finance A is Summa Flexible display of various financial measures view summarized by chartfields and time periods Offers crosstab or graphical chart layouts as well as drill through to transaction details Budget Actual and Variance summarized by View chartfields and time periods Account breakdown by row is the recommended layout for this report i5 Detail Lists transactions for various financial measures view grouped by Fund and Account Drill throughs to other Finance An Finance Journal Detail Lists General Ledger journal entries for a specified View journal ID Only those lines for which you have the appropriate Department ID access are displayed modules e g Procure to Pay are available for certain items Go to Public Folders Enterprise Reporting If you have problems or questions Jan 13 2012 GLR 01 please contact us by logging a ticket 2 2 Whatisthis page for This page is the entry poi
5. Public Folders page select PS General Ledger to bring up the General Ledger Finance page tcveltma Loa On Ei hii Br fy lanh 7 Public Folders gt PS General Ledger Name e M Einance Reports Menu 3 e P e e e gt lal gt al gt e gt al gt lal gt lal gt lal gt Finance Analysis Detail Finance Analysis Summary IG GoOG Finance Facul Finance Journal Detail GL Department Detail Report GL Department Encumbrance Report E GL Department Summary Report GL Faculty Summary Report GL Internal Detail Report Es m m m GL Program Detail Report nit Management Summar GL Department Summary amp Detail Report CB GP ES 5 Ha BM i v5 Oo Entries 1 12 I4 44 M Modified amp actions April 20 2011 11 34 28 AM January 24 2012 10 18 53 AM January 3 2012 5 19 21 PM December 19 2011 10 10 13 AM December 22 2011 10 11 03 AM January 20 2012 3 55 52 PM April 28 2011 4 23 39 PM er 5 2011 11 20 08 AM January 16 2012 2 37 09 PM December 14 2011 5 21 58 PM January 11 2012 9 32 39 AM April 28 2011 4 21 44 PM Student Dashboard User Guide From the General Ledger main page select Finance Reports Menu to bring up the menu of all available reports Cognos Viewer Finance Reports Menu tceveltma Log On pthis version p ici da EA i el E Add this report TET UNIVERSITY OF CALGARY JD ENTERPRISE Finance Reports Menu
6. as bar line or pie graphs using the selected rows and columns as the X and Y axis as shown above Actual and Budget are cumulative across all chartfields and fiscal periods Encumbrance and Pre Encumbrance are monthly snapshots that represent commitment levels at a point in time They can be aggregated by chartfield but not by period A blue underlined value indicates that a drill through to transaction details is available for that item Click on a link to launch the Finance Analysis Detail report in a new browser window It will display all detailed information that composed a particular crosstab cell Charts can also be clicked on to see transaction data for specific bars line points or pie slices Be careful when attempting to drill through on items that may have large numbers of transactions e g entire years or faculties as this may take a long time to produce Student Dashboard User Guide 4 Finance Analysis Detail 4 1 What is this report for This report displays transaction level information for any one of four different financial measures grouped and subtotaled by Fund and Account 4 2 Mandatory parameters Values The financial measure for which to display transactions Subtotals are provided by Fund and Account group Period Select a time frame for the data You can click on a single period in the right hand box or select multiple values by holding down the CTRL or SHIFT key while clicking The default level a
7. IET UNIVERSITY OF CALGARY ENTERPRISE REPORTING Finance General Ledger User Guide Cognos Viewer Finance Reports Menu tcveltma Log On v ff About Keep this version p i Je a v J Add this report Te UNIVERSITY OF Finance Reports Menu The Finance Reporting suite allows you to explore the General Ledger and related subsystems in a flexible manner High level analytics can be performed with linkages to transaction details on demand These reports are designed primarily for use with operating funds Although it is possible to include research funds project accountability statements cannot be accurately generated Please contact the Research Accounting office for project reporting options currently available to you Finance Analysis Summa Flexible display of various financial measures summarized by chartfields and time periods Offers crosstab or graphical chart layouts as well as drill through to transaction details Finance Fact Unit Ma t Summa Budget Actual and Variance summarized by view chartfields and time periods Account breakdown by row is the recommended layout for this report Lists transactions for various financial measures grouped by Fund and Account Drill throughs to other Finance Journal Detail Lists General Ledger journal entries for a specified journal ID Only those lines for which you have the appropriate Department ID access are displayed
8. Or visit us on the 10 floor Earth Sciences at the University of Calgary Student Dashboard User Guide 2 The My UofC screen will appear Type in your elD and your password in the form dil amp https cas ucalgary ca cas login ca ucalgary authent securid true amp service https ereports2 v 4 AA x Snagit EM ey x Convert v PD Select sly Favorites Sig Suggested Sites Web Slice Gallery v e University of Calgary ap de v Pagey Safety Tools v e x 2 evens UofC Access tcveltma password 123456 Disclaimer A Done but with errors on page vf Trusted sites Protected Mode Off The following page the main page will appear IBM COGNOS 8 tcveltma LogOn Loa Off as Query my data Analyze my business N Create professional reports Manage my events Y IBM Cognos content V Show this page in the future The main page displays the various content and actions you can perform from within the Cognos reporting environment Select My home to access the reports Student Dashboard User Guide The resulting page is the Public Folders page ty Public Folders My Folders teveltma oan 7 E Public Folders Name 7 AudiN E G Auditxn 7 G AuditUN 7 PS Accounts Receivable E ei PS General Ledaer GB EP Finance Mart PS Research and Trust Gg Agency Report Gg PS Procure to Pay Contract and B
9. ance Journal Detail 6 1 What is this report for This report shows General Ledger Journal header and line information for a given Journal entry 6 2 Mandatory parameters Journal ID Type a Journal ID in the left hand text box and press the Apply gt gt button Journals are identified by Business Unit ID Date and Unpost Sequence so there may be more than one search result displayed If you do not know the entire Journal ID you can type the first few characters and the Results box will show all matching entries Only those Journals with at least one line to which you have Departmental access are viewable Select one search result from the right hand box and press the Finish button Finance Journal Detail S ENTERPRISE REPORTING Type a Journal ID and choose one search result 123456078 Apply gt 16 Student Dashboard User Guide 6 3 The Results An example of the resulting report is displayed below TETTI UNIVERSITY OF sd Finance Journal Detail REPORTING Journal ID AsatDate Sep 10 07 Report Date Jui 28 08 User Name grey Journal Header Information Business Unit UCALG Journal Header Status P Journal Date Apr 25 07 Description AP Accruals Unpost Sequence 0 Source AP aene re poaren Pavan Diem uet er eat uie sone nen ns adatto 6 4 Howto read the report O 0 w O Ub 4 Q M e eet net O Ni 0 16 The report will display Journal header properties followed by line di
10. at present targeted data in the most consumable format for day to day operations Microstrategy com Who are we Enterprise Reporting ER is a unit within University of Calgary Information Technologies UCIT comprised of a diverse group of specialists from both the business and technology areas The ER team is responsible for defining designing and developing the data architecture for the university In addition we provide an enterprise reporting toolset and strategy which is focused on enabling self service access to information for all faculties and departments with appropriate security and approvals processes in place The ER team has developed an enterprise data warehouse and business intelligence strategy to support the information and decision support needs of the institution We develop standard data structures data integration methods metadata and provide a standard reporting toolset To support this strategy we provide ongoing training report services and data analysis services At the University of Calgary our Business Intelligence environment consists of standard reports dashboards and ad hoc query models which cover a number of diverse subject areas In addition Enterprise Reporting ER supports a set of applications including eFIN Research Reporting eProj Academic Performance Review and Planning Institutional Budget and Forecast Models and reporting Please feel free to contact us by phone 403 220 5555 ext 1
11. d this report 18 Student Dashboard User Guide 8 Appendix PS General Ledger Chartfields Chartfield GL Business Unit Dept ID Program Internal Project Activity Description e 5 characters e Designates a separate legal entity e 2 characters e Segregate financial information to reflect the nature and restrictions of funding e 5 characters e Lowest level of responsibility centre reporting within the university e First two characters in a range will be assigned to a department e 5 characters e Designates balance sheet or income statement account e 5 characters e Activity across faculties or departments such as a building initiative or academic session e 9 characters e Activity specific to one faculty or department e 8 characters e Designates a research amp trust project RT PP or OP ora PER EX project e 5 characters e Represents further subproject detail LETT e ARCTC Arctic Institute of North America e FHOBO Funds Held on Behalf of Others e UCALG University of Calgary e UCFND U of C Foundation e UTECH University Technologies Inc e 10 Central Operating e 20 Other Operating e 30 Carryover Reserves e 40 Board Approved Reserves e 50 Capital e 60 Research e 70 Other Restricted conversion e XXXXO where xxxx faculty INTER e XXXXX no relationship to INTER for non faculty units post conversion e XXXxx where xxxxx
12. e but they can be revealed by selecting ON and pressing the Refresh button Program Type a Program code into the search box and click the Search button Any match found will appear in the left hand Results box highlight it and press the Insert button to filter the report Multiple items can be added to the Choices box by performing additional searches Please note that data security is by Department you will see values for Programs as long as they are within the Department IDs that you have 10 Student Dashboard User Guide access to Filtering by a specific Program will not display all transactions if some are outside your faculty unit Internal The Internal code search prompt works the same way as the Program search If a series of desired Internal codes begin with the same first few characters you can type the beginning of the code and obtain multiple search results In order to filter Internals out of the report type a single space in the search box and click the Search button A Not Assigned to Internal item will appear which can be added to the Choices box Project The Project code search prompt works the same way as the Program search If a series of desired Project codes begin with the same first few characters you can type the beginning of the code and obtain multiple search results In order to filter Projects out of the report type a single space in the search box and click the Search button A Not Assigned to Pro
13. ge 2 1 How to access 1 Go to https ereports2 ucalgary ca and click on Login to Enterprise Reporting in the Quick Links sidebar UOC THIS IS NOW UNIVERSITY OF CALGARY 3 INFORMATION TECHNOLOGIES Ce E Home Reports Application Services Enterprise Reporting 101 Training Request Access Troubleshooting Contact Us Site Map Quick Links m Login to Enterprise Reporting Login to Planning Budget and Variance Forecast m Student Dashboard Human Resources Reports m Graduate Program Advisor Reporting ME A D RgO x e Welcome to Enterprise Rep X _ Students Current Students Alumni Community IT MYUO Finance Human Resources Other zr Student Supply Chain We like to think our work speaks for itself If you need better information then talk to the Enterprise Reporting Team What is Enterprise Reporting Enterprise Reporting involves providing Business Intelligence to the client and or business by delivering detailed information relevant to decision making throughout an organization Enterprise reporting combines many areas of an organization such as Finance Accounting and Operations under a comprehensive reporting system which allows vital information to be shared throughout the organization Individuals at all organizational levels and job functions as well as supply chain partners and customers rely on powerful flexible enterprise reporting systems th
14. gram code into the search box and click the Search button Any match found will appear in the left hand Results box highlight it and press the Insert button to filter the report Multiple items can be added to the Choices box by performing additional searches Please note that data security is by Department you will see values for Programs as long as they are within the Department IDs that you have access to Filtering by a specific Program will not display all transactions if some are outside your faculty unit Internal The Internal code search prompt works the same way as the Program search If a series of desired Internal codes begin with the same first few characters you can type the beginning of the code and obtain multiple search results In order to filter Internals out of the report type a single space in the search box and click the Search button A Not Assigned to Internal item will appear which can be added to the Choices box 5 5 The Results An example of the resulting report is displayed below TEA UNIVERSITY OF CALGARY Finance Faculty Unit Management Summary QW ENTERPRISE Ge REPORTING Modify Report Contents 2007 Revenue Internal Revenue 48005 Internal Rev Operating Funds Total Internal Revenue Total Revenue Salaries and Benefits Salaries 50145 Pay Undergraduate Salaries 53005 Pay Prof Supervis and Manag 53015 Pay Technical 53065 Pay Student Assistance
15. id Management System GJ PS HR Payroll B PS LERS PSPGME PS Student Admissions PS Student Awards PS Student Finance GB PS Student Records Gg PS Student Records History Gg PS Student Weekly Snapshots PS Student Periodic Snapshots GB PS Student LERS Snapshots B USRI Reporting Gg Graduate Student Salary Donor Award High Density Library F3 p0 ES Fs Eg m F9 up up Es p Cs Cup Du ES p DS Cu DC D cf Eb 6 ER g Entries 1 68 4 44 Modified Actions February 17 2011 12 21 58 PM More February 17 2011 12 22 06 PM More February 17 2011 12 22 16 PM More July 29 2011 5 49 59 PM More December 14 2011 8 57 35 AM More January 11 2012 2 44 10 PM Sf More January 26 2012 2 31 42 PM EST More May 30 2011 11 14 29 AM More February 17 2011 4 31 54 PM More February 17 2011 7 06 06 PM More January 19 2012 11 03 30 AM More May 12 2011 11 00 00 AM More August 25 2011 4 00 44 PM More February 17 2011 4 30 16 PM More December 8 2011 12 38 51 PM More November 3 2011 4 12 02 PM Sf More December 15 2011 3 56 45 PM More November 24 2011 4 28 27 PM More September 15 2011 3 22 50 PM More May 26 2011 1 31 38 PM More September 29 2011 3 54 22 PM More January 19 2012 11 51 45 AM More January 13 2011 2 08 40 PM More June 27 2011 2 18 13 PM EST More March 2 2011 9 37 34 AM More From the
16. ilter the report by To quickly scroll to a particular Department highlight any entry in the right hand box and begin typing the first few numbers of the ID You can change the scope of the prompt by selecting a different Department hierarchy level in the left hand box and pressing the Apply gt gt button Please note that even if you select an entire Faculty or VP area you will only receive data for those Department IDs you are authorized to view contact the IT Support Centre if you are unsure about your security settings If nothing is selected the report will run for all Departments that you have access to Fund Click on one or more checkboxes to narrow your search down to specific Fund s If nothing is selected the report will run for all available Funds 3 4 Additional Parameters Less commonly used filters are hidden by default to save space but they can be revealed by selecting ON and pressing the Refresh button Student Dashboard User Guide Program Type a Program code into the search box and click the Search button Any match found will appear in the left hand Results box highlight it and press the Insert button to filter the report Multiple items can be added to the Choices box by performing additional searches Please note that data security is by Department you will see values for Programs as long as they are within the Department IDs that you have access to Filtering by a specific Program will not display all transact
17. ions if some are outside your faculty unit Internal The Internal code search prompt works the same way as the Program search If a series of desired Internal codes begin with the same first few characters you can type the beginning of the code and obtain multiple search results In order to filter Internals out of the report type a single space in the search box and click the Search button A Not Assigned to Internal item will appear which can be added to the Choices box 3 5 The Results An example of the resulting report is displayed below April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 Month Total 10 Central Operating Fund Total Fund 0 April 2006 June 2006 August 2006 October 2006 December 2006 February 2007 May 2006 July 2006 September 2006 November 2006 January 2007 March 2007 Month Student Dashboard User Guide Month Bl April 2006 E May 2006 B June 2006 July 2006 Bl August 2006 IS September 2006 lil October 2006 IS November 2006 lll December 2006 E January 2007 Bl February 2007 E March 2007 3 6 How to read the report This report displays summarized data in a customizable crosstab format The rows and columns of the crosstab can be set to any combination of chartfield or time period with one of four different financial measures as the contents Results can optionally be displayed
18. ject item will appear which can be added to the Choices box This filter is provided for troubleshooting purposes only accurate Project balances cannot be obtained particularly if some transactions are input to the wrong Department 4 5 The Results An example of the resulting report is displayed below ERISA ENTERPRISE Finance Analysis Detail REPORTING Columns A As at Date Sep 10 07 alues NA Report Date 30 28 08 M User Name grgrey Month 2007 ie 3 Program Internal Al Project Al Internal _ Project Activity Journal ID Journal Date Dril Through Fund 10 Central Operating Total 60100 Purch Serv Consultant Total Materials Supplies and Serv Total Non Salary Expenses Total Fund 10 Central Operating Grand Total 4 6 Howto read the report The data is arranged to group by fund and account and to display details about the fund and account across the columns Actual and Budget are cumulative across all chartfields and fiscal periods Encumbrance and Pre Encumbrance are monthly snapshots that represent commitment levels at a point in time They can be aggregated by chartfield but not by period 11 Student Dashboard User Guide A blue underlined value indicates that a drill through to further details is available for that item Click on a Journal ID to launch the Finance Journal Detail report in a new browser window In addition some transaction types have a drill through link to o
19. me for the data You can click on a single period in the right hand box or select multiple values by holding down the CTRL or SHIFT key while clicking The default level applied is Fiscal Year To filter by a different time granularity select a period type in the left hand box and press the Apply button This is the only mandatory filter for the report 5 3 Optional parameters Department Choose one or more Departments to filter the report by To quickly scroll to a particular Department highlight any entry in the right hand box and begin typing the first few numbers of the ID You can change the scope of the prompt by selecting a different Department hierarchy level in the left hand box and pressing the Apply gt gt button Please note that even if you select an entire Faculty or VP area you will only receive data for those Department IDs you are authorized to view contact the IT Support Centre if you are unsure about your security settings If nothing is selected the report will run for all Departments that you have access to Fund Click on one or more checkboxes to narrow your search down to specific Fund s If nothing is selected the report will run for all available Funds 5 4 Additional parameters Less commonly used filters e g Program and Internal are hidden by default to save space but they can be revealed by selecting ON and pressing the Refresh button 13 Student Dashboard User Guide Program Type a Pro
20. n a flexible manner High level analytics can be performed with linkages to transaction details on demand 1 2 How current is the data Report data is updated nightly The numbers shown on a report run today are current as of the previous day 1 3 What reports are available e Finance Analysis Summary o Flexible display of various financial measures summarized by chartfields and time periods Offers crosstab or graphical chart layouts as well as drill through to transaction details e Finance Analysis Detail O Lists transactions for various financial measures grouped by Fund and Account Drill throughs to other modules e g Procure to Pay are available for certain items e Finance Faculty Unit Management Summary o Budget Actual and Variance summarized by chartfields and time periods Account breakdown by row is the recommended layout for this report e Finance Journal Detail o Lists General Ledger journal entries for a specified journal ID Only those lines for which you have the appropriate Department ID access are displayed 1 4 Getting help and information If the user manual does not provide you with the information you need or to request access to Enterprise Reporting contact IT by e Phone 403 220 5555 e Email itsupport 2ucalgary ca e Submit a help ticket Click the help ticket link at the bottom of any report page and follow the instructions Student Dashboard User Guide 2 Accessing the Finance Main Pa
21. nt for viewing all Finance reports All reports can be run from this page Currently there are four reports 1 Finance Analysis Summary 2 Finance Analysis Detail 3 Finance Faculty Unit Management Summary 4 Finance Journal Detail Student Dashboard User Guide 3 Finance Analysis Summary 3 1 What is this report for This report displays various financial measures summarized by chartfields and time periods 3 2 Mandatory parameters Rows Select the item to be displayed along the left side of the crosstab or the Y axis of a chart Columns Select the item to be displayed along the top of the crosstab or the X axis of a chart Values The financial measure to summarize by the selected row and column items Subtotals are displayed along the bottom and right sides of the crosstab except for when time periods are displayed with Encumbrance and Pre Encumbrance Display Choose how the data is to be presented on screen More than one display type can be enabled Period Select a time frame for the data You can click on a single period in the right hand box or select multiple values by holding down the CTRL or SHIFT key while clicking The default level applied is Fiscal Year To filter by a different time granularity select a period type in the left hand box and press the Apply button This is the only mandatory filter for the report 3 3 Optional parameters Department Choose one or more Departments to f
22. odes dodo pao a E o o e d e e NR 10 AS Opionalargmiebels ustestetitutitetitetituiitetitetituti tette itotutebute ibotatobeta ibo tete bota tuta cita Domus 10 AA Agdditlondl paFalIeLtersucsseusdmautecdiadeacite dua deat eut Ua osa d Ua Ie dM Md 10 Er PERO cf URN 11 Ao HOW TO Tete TODO suspi 255035399p2505 38055305250 990 32 028 0000000000800 50 sS eee 11 5 FINANCE FACULTY UNIT MANAGEMENT SUMMARY 13 Did M hatisthis FED ONE TOL T secos ode edam uam condat esas Dess ouod osi Co uud x intus 13 52 Mandatory Dd attis el Roane ee ec ce ee 13 b QOpionalpatarmetefs i515 055 2 5 49 0 8 2 45 A ui Ee bul bub o ub ubul efus 13 b JAdaditoralDaraletesc vau doa cov de ua cus deu ua ao dee a do o E E m E M EU 13 co MEE nS I T T ee en eee 14 Dub HOW EO ee the r6 DOPD us MM M E E E E MM 15 6 FINANCE JOURNAL DETAIL 1er eren nnne nnn 16 5d AWhaEIedhisdebOLE TOR a a ME ED M QE MEM M UR 16 6 2 Mandastolv parameters sce SIEHT PEDE DEM ML M DM E D M DM CPU CDM MD CUM CEN OE VEM 16 63 CI A ITEM 17 od JoW toTteSgdtleqelobludusso mU UE NU MUERE NU RUN M MEME 17 7 VIEWING AND SAVING THE REPORT eere eren nnn nnn nnn 18 8 APPENDIX PS GENERAL LEDGER CHARTFIELDS 19 Student Dashboard User Guide 1 Overview 1 1 What is Finance General Ledger The Finance Reporting suite allows you to explore the General Ledger and related subsystems i
23. pplied is Month To filter by a different time granularity select a period type in the left hand box and press the Apply gt gt button This is the only mandatory filter for the report It is highly recommended that you limit the chosen Period to a few months or less especially for Actuals due to the potentially large number of transactions 4 3 Optional parameters Department Choose one or more Departments to filter the report by To quickly scroll to a particular Department highlight any entry in the right hand box and begin typing the first few numbers of the ID You can change the scope of the prompt by selecting a different Department hierarchy level in the left hand box and pressing the Apply gt gt button Please note that even if you select an entire Faculty or VP area you will only receive data for those Department IDs you are authorized to view contact the IT Support Centre if you are unsure about your security settings If nothing is selected the report will run for all Departments that you have access to It is highly recommended that you choose only a few Departments at most especially for Actuals due to the potentially large number of transactions Fund Click on one or more checkboxes to narrow your search down to specific Fund s If nothing is selected the report will run for all available Funds 4 4 Additional parameters Less commonly used filters e g Program and Internal are hidden by default to save spac
24. stribution information Department security settings are applied on a per line basis If a Journal was input such that every line has a Department ID you have access to the whole entry will be displayed and balance to zero Otherwise the report will list only the portion of the Journal encoded to your unit s A blue underlined value indicates that a drill through to further details is available for that item You must have permission to use the target reporting package for a drill through to work If you need to obtain access to additional packages please contact the IT Support Centre 17 Student Dashboard User Guide 7 Viewing and Saving the Report Description Keep this version Keep This Version keep a copy of the generated report either by emailing it or saving it as a report Email Report Email Repor GU Hg Save as Report View Lo mmm parameters and run a new report Drill Down Drill Up changes the level of detail shown Go To Links identifies any links within the report that can be selected to open a new report Loading View Options exports the report to an HTML PDF XML or Excel view View in HTML Format View in PDF Format bid View in XML Format EE View in Excel Options Add This Report saves a version of the report by adding it to My Folders or My Bookmarks EA Add to My Folders sections in IBM Cognos Connection 3 Add to My Bookmarks ES Ad
25. ther reporting packages outside of PS General Ledger such as Accounts Payable Vouchers Expense Sheets Purchase Orders Requisitions and others which are being continually added to the report You must have permission to use the target reporting package for a drill through to work If you need to obtain access to additional packages please contact the IT Support Centre 12 Student Dashboard User Guide 5 Finance Faculty Unit Management Summary 5 1 What is this report for This report is a specialized version of the Finance Analysis Summary meant for Budget to Actual comparison A Variance calculation is provided as well as a color coded Variance percentage ranging from green healthy to red requires attention 5 2 Mandatory parameters Rows Select the item to be displayed along the left side of the statement Account Mid Level and Detail are rendered in a nested layout All other row types are displayed as a Single level similar to the Finance Analysis Summary report Columns Select the item to be displayed along the top of the statement For each value the columns Budget Actual Variance and Variance 96 are shown Column Totals Optionally display an extra column showing the sum of all other columns For example if the twelve months April 2008 March 2009 are displayed along the top of the report the total Budget Actual Variance and Variance 96 for all months will also be shown Period Select a time fra
Download Pdf Manuals
Related Search