Home

SIS User Guide - Carleton University

1. TOTAL 66 051 455 16 926 153 207 878 50 133 179 a 1 1133 iy i eh Click here if you would like to return to the Menu Click here to download to Excel for printing Notice the Column Headings in the Header Bar have changed This is displaying a comparison for the month of March for 2003 vs 2002 Page 33 of 52 Introduction to FAST Budgeting Date Range Report The Date Range report is used to view data between two points in time Select Date Range then select a From date and a To date using the period selection drop boxes The columns in the Header Message bar will change and the Period Actual Commitments and Period Total Activity data between the specified dates is displayed Dates that cross Fiscal or Calendar year ends can be selected Sd http roriobe ntcarieban ca F AST FAIT asp RF 38FYIFPITZ003108FY2FP2 200311858 28BF AAZNF DEF Microsoft Inbernet Enpara p 2 8 x File Edi Ww Favortes Tools Help EJ Hik t EO Aseh rH ie uj Address Ae OOF LESB Ze s AAL EAR Dus Bu A A ESA C eL eple TSR ELO He S TRE BPLEIMXRIS LOGS phon Links Carleton FAST System Firancud Ademeasstration Support Too WW UNIVERSITY FORHBM SUMS Cate Range From Feb 2003 Open To Mas 2003 Open Goto Fund o Display Chart fd Last Updated amp pz 26 2003 Parsad Period Code Tele lichual Commitment s Total Activity 10 Regular Operating Fund 516 705 207 876 726 562 Le Ansllary Qpe
2. Acct Prog Actv Locn Apr 2003 Open Operating Statement Period Desired Report A Financial Administration Support Tool FORM MENU Page 44 of 52 Introduction to FAST Budgeting APPENDIX A BANNER FORMS NAMING CONVENTION Position 1 identifies the primary X Records Indexing se W Reserved for client DNE Me Y applications that co eae Z exist with Banner 2000 Popor TASIE General G E Event Management J Job Submission L Letter Generation O Overall Position 2 identifies the module owning the form report job or table Student S A Admissions C Catalog E Support Services F Registration Fee Assessment Finance F A Accounts Payable B Budget Development C Cost Accounting E Electronic Data Interchange F Fixed Assets G General Ledger I Investment Management O Operations P Purchasing Procurement R Research Accounting S Stores Inventory G General Student H Grades Academic History I Faculty Load K Reserved for SCT Intl UK L Location Management M CAPP O Overall P Purge S Security T Validation form table U Utility X Cross product Accounts Receivable T F Finance Accounts Receivable G General Accounts Receivable O Overall S Student Accounts Receivable T Validation form table U Utility Financial Aid R P Person T Validation form table U Utility X Archive Purge R Recruiting S Schedule T Validat
3. Main Screen with Org code Selection d Main Menu Microsoft Internet Explorer provided by EduNET File Edit View Favorites Tools Help Back gt amp A Qsearch Gyravorites Meda C4 E 5 3 m4 Address http wren nt carleton ca FASTbudtest Prompts asp FD MENU amp SDL N amp FR lVaRN 313028BY 48BN 0T amp IS Car leton FAST System Financial Administration Support Too UNIVERSITY FORM MENU Please input your desired report parameters You can click on the to lookup a field Chart M Fund v Orgn 499 Acct Prog Actv X Period Mar 2004 Open Desired Report Budget System ENTER If you prefer you can also just leave all the input boxes blank and click the ENTER button This will produce a report summarizing all of your accounts Click here if you would like to change your password Note this will change your Banner password as well Click here to access the online documentation Don E D enee Then the next screen will start at the Org level A http wren nt carleton ca FASTbudtest FAST asp A amp AC amp AHC N amp AL 1 amp BF AA amp C Y amp D amp DA amp DT amp ENC amp F amp Microsoft Internet Explorer p File Edit View Favorites Tools Help Back gt amp i Search amp jFavorites Media e D amp a y Xe ee Car leton FAST System Financial Administration Support Too W UNIVERSITY FORM 2003 2004Acual 2004 2005 Bud
4. 7oriole nt carleton ca FAST2 7FAST asp 2A amp AC amp AHC N amp AL 1 amp BF AA amp C Y amp D amp DA amp DT amp ENC amp F TMM Microsoft Internet Explorer File Edit View Favorites Tools Help e g a au s wee 35 35 32 Back Forverd Stop Refresh Home Search Favorites History Mail Size Print Edit Discuss Fealcom Messenger Address amp TV2 amp L amp LD amp NF 08 amp 0 288H amp O0L 28 amp 0FM z amp 0HCZN amp OT amp P amp PED z amp PED2 2 amp PHC amp PL M amp POSN z amp Rz amp RF2218RG2 amp RL Z amp RN 255534 amp 5B 3 amp SBL amp SDL 2 amp T 2 amp TD amp YMDs Go Links m X C ee sar eton FAST System Financial Administration Support Too ap NIVERSITY Current Year Period Sep 2003 Open f Gotd FORM SUMS Display o Chart MC Fund 100000 Regular Operating Fund Orgn 557 CCS ypplication Development Last Updated Nov 14 2003 Base Budget Fiscal Budget Activity EER Code Name Original Adjusted Original Adjusted Actuals Encumbered Available 557 CCS Application Development 163 278 160 505 163 278 278 902 462 133 132 400 315 531 Total 163 278 160 505 163 278 278 902 462 133 132 400 315 631 Click here if you would like to return to the menu Click here to download to Excel E Done I5 Internet Now you get the Organization summary for that Fund Note the Goto above has changed from Fund to Orgn Method 2 Use the drill down button Go back to the Main Menu an
5. and navigate interface FAST can be accessed through any modern web browser such as Netscape or Internet Explorer version 4 or higher FAST provides easy access to the financial data collected in Banner and other Financial Systems Banner is an integrated software application for Student information Advancement Human Resources Financial Aid Faculty and Advisors and Finance FAST focuses on reporting and Budgeting on data from the Finance Systems Key Features Web Based Secure Easy to access Cross Platform No client software to install Drill down to transaction level detail Document Search and Query Download to excel Multiple Budget Comparative and Date Range views of Data Filter on any combination of FOAPAL elements This manual 1s intended as a brief introduction for new users of FAST Used as a training and reference manual the information contained herein offers instructions on how to access information and perform functions in FAST Page 5 of 52 Introduction to FAST Budgeting 2 0 Logging In To login to FAST go to http www carleton ca fast The first screen you will see is the Login Screen Enter your Banner User ID and Password You userid is your first name and last name no spaces and your password is the Banner Password Changing the password may be done in Banner or in FAST After you log in with u pick it the next screen the Main Menu contains instructions on how to change the password If you have no
6. 1 e All Degrees amp Certificates EXCH GR Graduate Exchange EXCH UG Undergraduate Exchange LOP Undergraduate Letter of Permission Query Form Quick Flow A technique that lets you access a set of forms in a specified sequence Determines Student Fees 1 e D Domestic Fee Rate I International Fee Rate confirming or assigning the appropriate FOAPALs Record determining student and course status Status does not control any processing and is used for display only Rollback A standard button and appears on most forms From an application or inquiry form clears all information and returns to the first enterable field in the key information area From a validation form returns to the first enterable field on the form From a query form returns to the first enterable field on the calling form Save scroll Down Moves down repeating records or lists of information that cannot be displayed in one window select Chooses an item by highlighting it or clicking it with a mouse Rate Field Show Keys Displays the list of keyboard options single Term Course Indicates a course that begins and ends within a single term Status Field Indicates the current standing of a course 1 e AS Active IS Inactive IG Inactive Graduated Required student System Used for tape load processing and rule creation Management Module student Type Field Identifies whether the student is new or returning 1 6 N Ne
7. 380 255 5950 300 000 g 20 510108 Excellence Grant Research n D D D D 510110 Performance Funding 225 010 225 050 24 580 224 50 225 000 n 20 510200 Enralment Accessibiler Grant 300 010 300 050 299 980 295 920 300 000 n 20 Si0201 Aim for the Top Grant D oO D oO n 510202 Ontario Graduate Grant oO D Oo D Oo n Sin203 Disehled Bursary n n Si z05 Ontario Work Bursary 0 0 0 Drilling Down on Data There are many layers to Banner data starting from a high level Fund overview down to a specific transaction Drill down on any number in blue to view the lowest transaction level Click on the Actuals in blue column circled above This information can also be displayed at a high level If you input the Fund and Organization you would like to view on the Main Menu selecting the Account view will summarize the data as follows S https oriole nt carleton ca FAS T02 FAST asp RF 21 amp FY1FP1 200407 amp FY 2FP2 amp 5B 48BF AA amp NF 08FR fr Microsoft Internet Explorer File Edit View Favorites Tools Help a C B E P San BD 22 3 6 3 58 35 Back FGrard Stop Refresh Home Search Favorites History Mail Size Print Edit Discuss Fealcom Messenger Address amp B24 amp BFzA amp A amp NFZ SFR2frmM e amp A 2 amp 5C 2 amp HC2N amp AL218C2Y amp FzTMMMMMS amp FD25UMS amp FHCSN8 amp O 288H amp L2 amp FFM z amp FLz288 amp GR2 amp 0FM z8 amp 0HC2N amp OLZ88 amp P28 amp PLzZM amp RNz233155 e Go Links n
8. Rule table R Rule table R Rule table Repeating table Repeating table Repeating table Report process Report process Report process V Validation form table V Validation form table Temporary table View View View Accounts Receivable T rs A Application form I Inquiry form Q Query form V Validation form table Financial Aid R HR Payroll Personnel P Alumni Development A Position Control N B Base table B Base table B Base table Batch COBOL process I Inquiry form I Inquiry form C Called list form P Process report I Inquiry form R Rule table Repeating R Rule table P Process report rules table Report Repeating table Report process T Temporary table V Validation form table R Repeating rules table V Validation form table T Temporary table View A Application form A Application form A Application form LG V Validation form table View IHmformaionAccess o RReprt Positions 4 5 6 and 7 uniquely identify the form report job or table Examples GUAIDEN GJRRPTS GTVZIPC G General G General G General U Utility J Job Submission T Validation form table A Application R Report V Validation form table IDEN Identification RPTS Report and Parameter ZIPC ZIP Postal Code Information Page 46 of 52 Introduction to FAST Budgeting APPENDIX B GLOSSARY OF BANNER TERMS Banner Term Definition Academic History Maintains grades and grading policies and processes and re
9. below will open E Document Lookup Results Microsoft Internet Explorer provided by EduNET File Edk View Favorites Tools Help dupak Ge search amp jFavorites ij Media 3 ET a z B Address 438 https Joricle ni carleton ca FASTO1 DOCLU ssp 5DL N Carleton FAST System Financial Administration Support Too UNIVERSITY FORM OLR Records per page 20 Document Lookup Results Number of Records Found 2 Docurnent FSYR Period Date Description DocRefNum Encumbrance Chart FUND lonGN ACCT IPRoG acTv LOCM Debit Credit J 010186 2004 jos 128 2003 4 12 33 PM PAPER cBnn3329 M 100000 4s8 710000 1300 80 00 0 J0D10186 2004 joe 12 15 2003 4 12 33 PM PAPER CB003328 hd 120400 871 710100 3020 ol 80 00 Previous Next Show All Records Return ta Document Look Up Return ta Menu Download ta Excel Click on any column heading to sort by that column Click it a second time to reverse the sort You can change the lines per page by changing the number in the records per page box and hitting enter Note the more records you have per page the longer it will take to display Clicking on the blue titles in the Title Bar will re sort the query based on the column title selected Page 41 of 52 Introduction to FAST Budgeting 9 0 Downloading to Excel There are times when you need to manipulate the data in ways other than what is presented in FAST You can download to Excel by clicking on th
10. http nriokentcarietan ca F AST FAST asp 7A E AC AAH NEAL DBF AARC Y RED DA REUDT GENE EF a RM Hicropal alt nbs i TEN jer xi Fle Ede wew Faves Tools Helo Ea hune RE fat t sud Hansusk asit eae lcd EE Annes AE SUR C Dus MF ss DEC n OL TROP eOHC SHOT i EPPNPED s LPE D PHI MP a POS i EF ae zrzDDEBRGZASBL ZXBMIGBSDIBSESZBROELESSODIZATZEEDDIASAOGPMpDo DU Links za Carleton UMIWERSITT FAST System Fineecia Adcdenavstrati on Support Toor Current Year Period upr 2009 Open Gata Fund mE a ZBUZ 20U Actual 200W20M Budget 1 o Lhart d Last Updated Spr 26 2003 Pa BaseBudget Fiscal Budget ES Code Hame Original Adjusted Grigimall Adjusted Actuals ncumbered available il Reguler Opersting Fund 14 357 225 13 412 803 14 417 473 14 417 473 13 595 076 203 046 25 422 Az Ancillar Opersting Funds 107 677 107 727 107 587 107 587 135 225 27 G37 iB internally Restricted Furds 24 250 24 250 24 250 24 250 24 200 n 5n 20 UG Scholars 275 274 76 234 975 604 75 602 975 S57 223 zl Grad Scholars 182 033 122 229 181 269 121 869 1Hi 3BH2 a E20 zg LUG Burzarw 1 033 237 1 038 557 1 032 987 1 O36 992 1040 232 n 2 240 z3 Grad Bursary 4250 4 120 4250 4 120 4 250 Dn 0 24 UG Prises 10 238 10 726 10 586 10 586 10 636 T zh Grad Prizes 13 010 13 050 1z 9B0 12 921 13 000 Di 20 B esbrirtad Spongoanzd Pesaarcl 0 fi 0 D sf
11. target Some examples of adjustments to the on going base include adding deleting changing salary positions salary step increases changes in long term planned expenditures or funding or meeting new organizational objectives The most important function of the base budget relates to on going faculty and staff positions These can only be created if the base budget dollars are available Term appointments do not require a base component By comparison the Fiscal Budget represents the short term one year commitment of the University In many cases the fiscal budget will be equal to the base budget The fiscal budget will differ from the base budget when circumstances exist in the budget year that differs from those in place under the presumptions of the base budget To continue the first base budget example of the full time faculty position assume the professor is on an unpaid leave for six months His fiscal budget for salary will be reduced to 5096 base budget will still be 100 because the University must only pay out 50 of his annual salary expense This frees up the remaining 50 of his salary for the department to spend perhaps on hiring replacements but only for the current fiscal year Assuming he is returning to full time work in the following year both his base and fiscal salary budgets would be 100 at that time In the second base budget example of 5 000 for upgrades assume that the department wants to purchase an a
12. to be stored differently Co requisite Field Identifies a course that must be taken simultaneously with another Count Hits In Query mode counts the number of records that meet the search criteria and displays that number in the Auto Help Line To retrieve records select the Execute Query function Count Query Hits In query mode counts the number of records that meet the search criteria and displays that number in the Auto Help Line To retrieve records select the Execute Query Function Contains the institution s courses and relevant details including pre requisites and rules for a particular term Attributes Page 47 of 52 Introduction to FAST Budgeting Banner Term Definition Course Field Used to specify the course number There is no Validation of und course numbers It is a required item in the Key Information Required Used to maintain the title of the course in effect for the term specified by the From and To terms Crosswalk codes and their Banner FAST counterparts A collection of data organized to serve many applications at the same time by storing and managing data for easy retrieval Degree Field Identifies the Degree usually the degree major details or No Degree Required Department Field Identifies the Department that offers the course A box containing information Requires you to respond before continuing Shows three or more values for a field Any field with a down a
13. 0 Postage Ezpense i g i FLIMOO 1200 Telephone Equipement Rentals 3 000 3 000 713001 1 Computer Lease Costs i u u i LU 2130 02 1304 Pages Csll Phane Rental i i 0 7159001300 Staff Development Coste i 0 n n 0 n 713100 1300 a Trwenl General 0 o o i 713700 123200 Accountable Travel advances 3 510 3 550 3 430 3480 3 500 D 20 7z3B800 130U Equipement Purchases 5 000 0 D SubTotal 3 327 3 477 3 337 3 337 8 873 5 536 Total Revered Leds Expenditures 3 337 A347 3 337 3 337 B 873 0 5 535 Page 32 of 52 Introduction to FAST Budgeting 8 5 Report Selection FAST provides many views of the same data The standard or default view is Current Year That view displays year to date data for Base Budget Fiscal Budget Actual and Encumbrances Below is a comparative view of the data That is the period selected versus the same period in the previous year The columns in the Header Bar have changed and a comparison can be made from any date to the same date from the previous year The date is selected using the period selection drop down box described above The report is selected using the Report Selection drop down box i http oriolent carietan ca FASTIH FAST asp RF ZEFYIFP1 2D031 18 FYZFP2 amp 5E 2 amp BF AAENF UBFR frm Microsoft Inbermet Explorer p Ml Fle Edt yew Favokes Tools Hep dopa 3 8 Pysewch a Favorites EMedia a he c m E Adress FP2
14. 0 2 240 0 713001 1300 Computer Lease Costs N 18000 18 000 0 18000 18 000 0 713002 1300 Pager Cell Phone Rental N 500 500 0 500 500 0 716900 1300 Staff Development Costs N 3500 3 500 0 3500 3 500 D 719100 1300 ehh tala Travel General N 9000 9 000 o 9000 9 000 o 723nnn 13nn Fouinment Purchases lt 5 nnn N snnn 5 nnn n snan 5 nnn n fd Es Tn nuo Internet You will need to continue moving adding removing amounts until you have completed all the accounts and the Difference message box is zero like the example below Page 22 of 52 Introduction to FAST Budgeting E http wren nt carleton ca FASTbudtest FAST asp FD BOS amp C Y amp F TMMMMM amp UO BES amp FL amp OL amp FY 1 NMMB amp FP 1 Microsoft Internet Explorer p File Edit View Favorites Tools Help Bak gt amp At Search Favorites Gmeda lt 4 S 3 A xj Address http wren nt carleton ca FASTbudtest FAST asp FD BOS amp C Y amp F TMMMMMBO BES amp FL amp OL amp FY 1 2NIMMB amp FP1 8V03 SAVED amp RN 11440 Car leton FAST System Financial Administration Support Foo UNIVERSITY FORM 2003 200 Actual 2004 2005 Budget EE Chart Fund 100000 Orgn 498 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance 711000 1300 Photocopying Charges amp Supplies N 0 1 500 0 1500 1 500 o 711001 1300 Printing Costs amp Supp
15. 0 500000 5000000 Allocated sooo 7530352 Difference o 2530352 SAVE YOUR WORK Save Click here if you would like to return to the menu Click here to download to Excel b ome Zero Difference All amounts allocated Once all the budgets have been allocated and balanced and the Departments have completed their work the Budgeting system will be locked by finance The system can be locked by Org code so it is not necessary to wait until all the work by all the departments has been completed Once you have completed the allocation you must click the SAVE button If this is not done all your work will be lost Page 26 of 52 Introduction to FAST Budgeting 7 0 Selecting FOAPAL Elements There are several ways to select a FOAPAL element 1 Type the FOAPAL directly in the field 2 Use the drill down feature 3 Leave the FOAPAL fields blank click on ENTER Example View only the total spent to date for your Fund no details We will try all 3 methods above Method 1 Type in your Fund number 100000 is for Operating Note You don t need Organization because you only want to see totals You don t need Account because you don t need the details You don t need Program because that is defaulted in The Period will automatically be the most recent month The Desired Report will be the Operating Statement Click on ENTER A screen will appear with the Fund summary 3 https 7 7oriole nt carleton ca FAS
16. 13060 Staff Development Costs Page 31 of 52 Introduction to FAST Budgeting 8 4 Period Selection The Reporting Period can be selected here using the drop down box The box has all available closed and open periods The dates are not restricted or dependent on Fiscal or Calendar Year ends Therefore data from historical and current year ends can be viewed and compared E http Fig d DL Carte ca FAST FAS Teepe DSITE DEEE ZIERL BL TEE TETEE KP EAC E Microsoft Internet Explorer p AF 21ERL 18 xl Fic Edt wew Favorkes Tods Help E pak gt OD A seh Girvan Gute GS C mi S ten ca AAS TARAS sprFDisOSXHEZDOCFz21XBLEXCIWAFzTWddHHEBOZBEESEAIEPEIBUCs EF NARO eT hence T TEF LEs pR C d Que Links gt FAST System Fence Admuwstretiar Support Toa FORM C Display 0 Ehart Fund 100000 Regular Operating Fund rgn 438 Finance cCdfipe Last Updated apr 26 2003 Base Budget Fiscal Budget Actieity Acct Prog Name Original Adjusted Original Adjusted Actuals Encumbersd Available 10000 1300 Ofta Suppbas 113 213 143 143 373 515 710001 1300 Reference Materials i 0 n 0 n 0 n z 105012 130n Other Supplies n D 711000 1300 Photocopying Charges amp Supplies 0 D 71101 1300 Printing Costs amp Suoplies il 712000 1300 Long Distance Charges n 2 000 0 2 000 z12z002 13
17. 23 n i023 amp Endowrnent Investment Holdings 17 388 17 558 17 738 17 238 17 338 100 i uri Scholar Endowment 63 040 66 200 F 920 67 920 6S 000 n B 2 Grad Scholar Endesments 250 010 250 050 249 980 249 950 250 000 20 3 Bursary Endoarnenks 151 020 151 100 150 260 150 960 151 000 41 gd STOF Bursarg Endorenents 76 020 76 100 275 960 75 960 76 000 al 65 Wis Award amp Prize Endow 30 010 30 050 29 980 29 950 30 000 20 Total 17 347 324 17 365 038 17 365 529 17 365 529 16 574 659 203 146 503 716 Chek here if you eemuld like te return bo tha mena Chek hare to diwrlage ty Exeal ni Bj a Intenet Page 29 of 52 Introduction to FAST Budgeting 8 0 Navigation Screen This screen has many components that provide the functionality to navigate and view FOAPAL elements in many ways The components that will be explored are The Actual and Budget Tabs Message Toolbar Header Bar Period Selection Report Selection Element Selection GoTo Transaction Level View Download to Excel Go back to the Main Menu and type 100000 in the Fund box 8 1 Actual and Budget Tabs When the Navigation Screen is first opened the default view will be the Actual Tab This is where data can be explored and viewed The Budget Tab will be used during Budget Development and the functionality behind that tab will be explained in the upcoming Budget Development User Manual and training sessions E https 77oriole nt carleton ca F
18. 4 Appendix A Banner Forms Naming Convention sese 45 Appendix B Glossary of Banner Terms sssssss eere 47 Appendix C Main Account Codes Summary ssssueeessssssssssssee eee 52 Page 2 of 52 Introduction to FAST Budgeting A INSTALLATION AND SUPPORT Installing FAST Reporting amp Budgeting Tool 1 Goto www carleton ca fast 2 Login screen will appear Create Shortcut on your desktop Go to File Send Shortcut to Desktop Page 3 of 52 Introduction to FAST Budgeting support Technical Problems New Accounts Password Reset E Mail Address Phone Hours of Operation STAFF ccs admin it support carleton ca 613 520 3830 8 00 am 4 30 pm Monday Friday FACULTY ccs campus help gycarleton ca 613 520 3700 8 30 am 10 30 pm Monday Friday 12 00 pm 8 00 pm saturday amp Sunday Functional Support First Level of Support Training Manual The latest version of any training manual is posted on the Administrative Systems Web Site at www carleton ca banner Finance System Specific banner finance a carleton ca or Jean Charles Cote at 613 520 2600 x8531 Page 4 of 52 Introduction to FAST Budgeting B FINANCIAL ADMINISTRATION SUPPORT TOOL FAST 1 0 Introduction The Financial Administration Support Tool FAST is a web based reporting and Budgeting tool that allows financial information to be presented in an easy to read understand
19. 5 960 76 000 AD 0 010 30 050 29 9380 29 9850 30 000 e 17 547 324 17 365 038 17 355 523 17 365 528 16 874 855 203 046 693 716 Click here to download to Excal This screen shot shows many funds That is because this particular user has access to multiple funds If you only have one fund ie 100000 you will go right to your Organization s Page 35 of 52 Introduction to FAST Budgeting View with Account Element E http nriole nb carleEan cayr FAST FAST aen RF 2 La FY EFP L 20031 EREYZFPZ E SE 42 BF SAAB D8 FR Sem Microsott Inbermet Esploner p aj Be E yew Faves Tods Help a pak GD D SO sewch woes Greda C y Sb Sy Je Address Ebibi AABAF SDEFRafrmHe 374v e EVAHC aLe LOC BF FD SUME HCR NE Cus sF MA TRGR OF OH CE NMOLSTBPaP BR H4 EL 14 ui Carleton FAST Syston Finacial Admanstnator Support Toor UNIVERSITY Goto Acct Pm u FOAR SUMS Display 0 Period Mar 2005 Open 2002 2003 Actual Chart lM Last Updated amp pr 26 2003 EE Base Budget Fiscal Budget Activ Code Name Original Adjusted Original Adjusted mcumbered Available Current Year 510000 QOpersbng Installment Grants 8 582 160 0 682 200 8 582 230 0 692 130 8 602 150 20 510107 Ont Grad Scholar in Sci amp Tech D 0 0 510103 Campus Safety Grant D D 40 550 o 40 550 510107 ATOP Operating erant 300 010 300 050 255
20. 85T I8RFRM form01 amp RFLD A amp RI 28RN 18555 o lj Internet You will need to clicking on the arrows until you get to the bottom level of the code hierarchy Page 18 of 52 File Edit View Favorites Tools Help Back gt amp A Search yFavorites Gmeda 4 D Sp m4 x Introduction to FAST Budgeting E http wren nt carleton ca FASTbudtest FAST asp FD BudDev amp t amp F TMMMMM amp 0 BE9 amp A HTMMMM amp P TEMM amp TA Microsoft Internet Explorer p Once you have selected your account your screen should be like the one below Batch Fund roo000 100000 190000 190000 190000 AddLines Acct 710000 710003 710000 710000 710000 Click here to return to 100000 498 Prog 1300 1300 1300 1300 1300 FAST System Financial Administration Support Tool Chart M Fund 100000 Regular Operating Fund Orgn 498 Finance Office Acct 710000 Prog 1300 Last Updated Mar 27 2004 To delete a line set both dollar amounts to zero not blanks Description Name References Budget Roll Click here if you would like to return to the Menu be sure to save first Position Employee Adjusted ID ID Base Adjusted Fiscal TY fi mem Now add the amounts and continue until you have reallocated the desired account like in the example below Page 19 of 52 Introduction to FAST Budgeting On the screen shot below you can see
21. AST2 7FAST asp 2A amp AC amp AHC N amp AL 1 amp BF AA amp C Y amp D amp DA amp DT amp ENC amp F TMM Microsoft Internet Explorer File Edit View Favorites Tools Help 2 9 a S3 n 3S Hu x9 9 5 Back FGTUWaTd Stop Refresh Home Search Favorites History Mail Size Print E dit Discuss Real com Messenger 8o Links 3M Carl t JEN JC e O b System Financial Administration Support Too s FORM SUMS Display o EE zen 2003 2004 Ac 2004 2005 Budget Wy Chart v Fund 100000 Regular Operating Fund Last Updated Nov 27 200 base PIE Fiscal Budget Activity Code Name Original Adjusted Original Adjusted Actuals Encumbered Available 100000 Regular Operating Fund 163 278 173 505 163 278 1 220 188 324 869 179 541 715 777 Total 163 278 173 505 163 278 1 220 188 324 869 179 541 WB TL Viewing the Actual and Budget numbers tells you whether you are over spent or under spent on your Budget You can see the numbers for the whole department or for one specific expense 8 2 Message Bar The message bar displays the Fund and Last Update in the above example Page 30 of 52 Introduction to FAST Budgeting If you drill down to Orgn in the Goto box the Message Bar will add the main or high level Organization CCS in the display The Org to which you have access is in the first column on the left 3 https oriole nt carleton ca FAS RU A ESSE E Rd
22. Introduction to FAST Budgeting 1 0 Carleton UNIVERSIT Y Finance Administrative Systems Introduction to FAST Budgeting Version 1 0 Carleton University Introduction to FAST Budgeting Table of Contents Page A INSTALLATION AND SUPPORT Iustalng FAST Reporting Tool 1ueossvs eise drar3ga ERA FSI S iiion risista 3 gg T 4 B FINANCIAL ADMINISTRATION SUPPORT TOOL FAST 10 uro NRTITES 5 RO E 6 3 0 FAST Main Menu ssesseeseee RR IRI RII ehe eere rere 7 40 F OAPALS 9 201128 qv 11 6 0 Budget for the RPC Administrator 0 ccc cece ence ee eeeeeenes 24 7 0 Selecting FOAPAL Elements 0 eee e cece cece e 24 S0 Navigation et ee narii aara arn dU 30 8 1 Actual and Budget Tabs euetecteseszeseeeuuwectetes tasse teta ibt a dies 30 8 2 Mesa Jo o HMM 30 89 Hener Dii en tones ewes ene eee rn Cee ee eee rn Tee 3 Ot Pernod Selecon oiueossasxcistorPeS Ea vbi vro s WESS PU REUESN IT PP FERVe RES PUE 32 Oo Kepo CECO uescsexexenctitesietetsnizeseniyes ati vas Subrva EEEa 33 8 6 Goto Drop Down Menu 0 ccc eee cc cee ence emere 35 5 7 Pama LOVOL VI oerien ere EAEEREN 37 8 8 Document Query and Document Lookup eeesss 39 90 Suo onus i nn ee ee eee 4 10 0 Back to the Main Menu ousccesezetevatene be DIR Or ELE PRESE EID RRC ierni 4
23. L amp C Y amp F TMMMMM amp U BES amp FY 1 NMM Microsoft Internet Explorer p File Edit Bak gt amp At Search Favorites Smeda lt 4 D 3 m4 x Address http wren nt carleton ca FASTbudtest FAST asp FD BOS amp NF O0 amp RF 18RL 8C Y amp F TMMMMM amp O BESSFY 1 NMMBSFP 1 TT amp FY2 8FP2 85B 28RN 94884 Carleton UNIVERSITY View Favorites Tools Help FAST System Financial Administration Support Tool FORM Actual 2004 2005 Budget ee Chart Fund 100000 Orgn 498 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance 610601 1300 ee URE ede N 441504 441 504 o 441504 441 504 0 610606 1300 Admin Management F T Salaries WN 262618 262 618 0 262618 262 618 0 610800 1300 Overtime Paid to F T Employees WN 1510 1 510 0 1510 1 510 0 620000 1300 Internal Phys Plant Labour N 200 200 0 200 200 0 Charges SubTotal Labor 705 832 705 832 0 705 832 705 832 Zero amount 710000 1300 Office Supplies N 6980 0 710002 1300 Subscriptions N 0 5 980 710003 1300 Computer Supplies N 0 1 000 5 e allocations 711000 1300 Photocopying Charges amp Supplies N 1500 1 500 711001 1300 Printing Costs amp Supplies N 1300 1 300 712000 1300 Long Distance Charges N 200 200 712002 1300 Postage Expense N 300 300 712010 1300 Edunet N 1000 1 000 0 1000 1 000 0 713000 1300 Telephone Equipment Rentals N 2240 2 240 0 224
24. L Elements Period apr 2003 Open Desired R port Operating Statement If you prefer you can also just leave all the input boxes blank and click the ENTER button This will produce a eport summarizing all of your accounts Change our password here Click here you would like to change your password bi Note thisAvill change your Banner password as well to access the online documentation Includes this Manual and other Finance Documentation zl iB 0 Menu and Tool Bar The FAST Menu and Tool Bars are the standard Internet Explorer drop down menu and tool bar FOAPAL Elements This will be discussed 1n more detail in Section 5 0 Period The month you wish to see If it is still open monthly financial transactions are not necessarily complete Usually changes can be made in an account up to 4 business days after the end of the month Currently one prior month is kept open to accommodate cancelled cheques but this should not impact your departmental accounts Page 7 of 52 Introduction to FAST Budgeting Desired Report There are two types of Reports and two query Tools e Operating Statement Summarizes revenues and expenses the majority will use this e Balance Sheet Used for activities related to assets and liabilities administrators that monitor Deposit Funds will use this e Document Query A document search tool e Document Lookup A tool which looks up the details of the d
25. MEO IMMMEA amp Microsoft Internet Explorer p File Edit View Favorites Tools Help Bak gt amp A Search yFavorites Gmeda lt 4 D Sp m4 xj Carleton FAST System Financial Administration Support Too UNIVERSITY FORM 2003 2004 Actual 2004 2005 Budget ne Chart Fund 100000 Orgn 1000 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance 1100 Faculty of Arts amp Social Sciences N 500000 28 793 421 28 293 421 5000000 28 887 304 23 887 304 N 0 0 0 0 0 D Total 500000 28 793 421 28 293 421 5000000 28 887 304 23 887 304 Base Fiscal To Allocate From Chart M Fund 100000 Orgn 1000 500000 500000 Allocated 500000 5000000 Difference 0 4500000 Save Click here if you would like to return to the menu Click here to download to Excel bone Page 25 of 52 Introduction to FAST Budgeting Once the Administrator is at the lowest level of the Organization all the departments will appear Now amounts can be moved from department to department until the Difference Message box is 0 E http wren nt carleton ca FASTbudtest FAST asp FD BSUMS amp NF O amp RF 21 amp RL amp C Y amp F TMMMMM amp O TTTM amp A amp Microsoft Internet Explorer p File Edit View Favorites Tools Help Bak 9 2 Z Qsearch Favorites Gmedia C4 B amp 9 Ed H Address http fwren nt carleton ca FASTbud
26. MM B Car leton FAST System Financial Administration Support Too t ap NIVERSITY Current Year Period Nov 2003 Open v Goto Acct FORM SUMS Display o 2003 2004 Actual 2004 2005 Budget aa Sa ES Chart M Fund 100000 Regular Operating Fund Orgn 557 CCS Application Development Last Updated Nov 26 2003 o o o Base Budget FiscalBudgt Activity Code Name Original Adjusted Original Adjusted Actuals Encumbered Available Labor 611 Part time Salaries 6 573 6 573 6 573 18 221 51 216 o 32 995 620 Internal Lab r amp Salary Redistrib n 63 295 86 068 83 295 65 870 50 258 0 35 612 Subtotal 76 722 79 495 76 722 67 649 958 Direct Expenditures 710 Materials amp Supplies 6 000 1 000 6 000 1 000 263 339 399 711 Printing amp Duplicating 0 0 0 0 150 0 150 712 Communications 0 0 0 0 374 0 374 716 Other Operational Expenditures 229 000 229 000 229 000 301 129 73 453 720 226 956 719 Travel 5 000 5 000 5 000 5 000 4 094 0 906 720 Professional Fees 0 D 0 29 422 170 568 98 208 239 354 723 Equipment amp Furniture Purchases 5 000 5 000 3 392 1 608 Subtotal 240 000 240 000 240 000 341 551 252 294 99 266 Total 163 278 160 505 163 278 273 902 253 252 99 266 78 617 Click here if you would like to return to the menu Click here to download to Excel Page 36 of 52 Introduction to FAST Budgeting 8 7 Transaction Level View This view gives all the details of the
27. N 18000 18 000 0 18000 18 000 0 713002 1300 Pager Cell Phone Rental N 500 500 0 500 500 0 716900 1300 Staff Development Costs N 3500 3 500 0 3500 3 500 0 719100 1300 ch el Travel General N 9000 9 000 o 9000 9 000 o 723000 132300 Equipment Purchases lt 5 000 N 5000 5 000 0 5000 5 000 0 SubTotal Direct Expenditures 49520 49 520 0 49520 49 520 0 Total Revenues Less Expenditures 755352 755 952 0 755352 795 0992 0 Base Fiscal To Allocate From Chart M Orgn 498 SY Allocated 755352 X 755352 Difference a Save Click here if you would like to return to the menu Click here to download to Excel lt E ae At this point you can move budget amounts from account to account by clicking into the box and changing the amount The To Allocate and Difference will not change until you click the Save Button Budgeting in FAST is the only part of FAST that actual updates data Click on the blue amounts will bring you do another level in the account Here you will able to reallocate amounts to accounts that do not appear on the original screen It can also be used to zero out accounts Please refer to the next screen Page 16 of 52 Introduction to FAST Budgeting Account level screen Sd http wren nt carleton ca FASTbudtest FAST asp FD BudDev amp C Y amp F TMMMMM amp 0 BE9 amp 4 HTMMMM amp P TCMM amp IA Microsoft Internet Explorer p 8 x File Edit view Favori
28. Oj xj Please click on the desired Acct code If a v is shown you may click on it to find Acct codes that report to this one Chart Acct Title Status FAST Sys m 510 Government Grants Active Chart M Fund 100000 Regular Operating Fund Orgn m 520 Central Tuition Fees Active M 525 Other Student Fees Active M 530 v Sales of Goods amp Services Active M 531 v Sundry Income Active M 540 w Recovery of Salary Benefit amp Other Active M 550 vw Endowment amp Investment Revenue Active Batch M 560 vw Donations Revenue Active Fund Orgn Acct Prog M 570 Jv Research Revenue Active Adjusted M 610 v Full time Salaries Active Fiscal 100000 v 498 v 710000 1300 M 611 v Part time Salaries Active 100000 ase 710000 1300 M 612 v Research Salaries E Active M 620 v Internal Lab r amp Salary Redistrib n Active 100000 Y ace 710000 v 1300 M 630 v Univ amp Gov t Benefit Plans Active 100000 498 710000 1300 M 639 v Internal Cost Alloc Benefits Active M 710 v Materials amp Supplies Active 100000 d 48 li 10000 v 1300 M 711 v Printing amp Duplicating Active M 712 Communications Active M 713 v Equipment Rental amp Maintenance Active M 714 v Principal Debt Repayment Active d AddLines dep Internet Z To delete a line set both dollar amounts to zero not blanks Click here to return to 100000 498 Click here if you would like to return to the Menu be sure to save first javascript fieldsearch BSearch asp X 9
29. PET TA EI DEAE AER ESIERIL RRET CAEN Microsoft Internet Explorer Ele Edit View Favorites Tools Help e228 B 29 2 Sie e 3 2 9 Back Forward Stop Refresh Home Search Favorites History Mail Size Print E dit Discuss Realcom Messenger Address S amp NF 08RF 21 amp AL amp C V amp F TMMMMM amp 0 HM1T8A amp P 8AC 8L amp FY 1 NMMB amp FP1 MH amp FY2 NMMB amp FP2 MH amp FL 8 amp 0L B amp AL 1 amp FHC N amp OHC Y8SB 38RN 15353 v Go Links 3e C a NIVERSITY Message Bar Current Year Period Nov 2003 Open Goto orgn B 2004 udgewi 2003 2004 Actual 200 Chart M Fund 100000 Regular Operating Fund Orgn 7061 Computing amp Communication Services Last Updated Nov 27 2003 AST System Financial Administration Support Too FORM SUMS Display O Base Budget Fiscal Budget Activity Code Name Original Adjusted Original Adjusted Actuals Encumbered Available c CCS Application Development 163 278 160 505 163 278 273 902 251 419 99 301 76 818 Total 163 278 160 505 163 278 273 902 251 419 99 301 76 818 8 3 Header Bar As the views in the Navigation Screen change the Header Bar changes to provide descriptions for each column of data being viewed In this view they are Base Budget Fiscal Budget Activity From this Main Navigation screen a user can drill into the data by clicking on numbers that are highlighted in blue As the user drills down into the data
30. T SuNiwan iael advance 3 500 00 T0xEG me Dirtance Charger eee J t beri paking kunsaan f a mm E 2 000 00 E Telephone Equipment zonaczm lunga P Testiney paking tunsactan 4 3 00 00 i Faw Lass Exp 8 873 30 Show All Records Click ad any column heading to sort by that calumn Click it a second time to reverse the sort You can change the lines per page by changing the nurnber in the records per page box and hutting enter Note the more records you have per page the longer it will take te display Show A Razordi i LO0G0R s Aam H Relu Ner wilo b ggal Return to Fund Org FI o ode meret Once all records are displayed download the detail into an Excel spreadsheet by clicking on Download to Excel Page 38 of 52 Introduction to FAST Budgeting 8 8 Document Query and Document Look up The Document Query and Lookup features on the Main Menu under Desired Report allow you to search for documents e Document Query allows you to search by selecting certain criteria like document type account ranges amount ranges when you do not know the exact Banner document number or other reference number e Document Lookup allows you to specify the exact Banner document number or other reference number e g ICB Journal or Invoice No to find where a document has been charged e Main Menu Microsoft Internet Explorer File Edit View Favorites To
31. TO2 7FAST asp 2A amp AC amp AHC N amp AL 1 amp BF AA amp C Y amp D amp DA amp DT amp ENC amp F THMM Microsoft Internet Explorer File Edit View Favorites Tools Help 8 259 a d n 3 mg 9 2 Back FGTWAard Stop Refresh Home Search Favorites History Mail Size Print Edit Discuss Fealcom Messenger Go Links 3M C ee sar eton FAST System Financial Administration Support Too oY NIVERSITY Current Year f Period Sep 2003 Open Go 30377004 Actus psu 2004 2005 Budget T LEN Chart Fund 100000 Regular Operating Fund Nast Updated Nov 14 2003 Base Budget Fiscal Budget Activity Code Name Original Adjusted Original Adjusted Actuals Encumbered Available 100000 Regular Operating Fund 163 278 160 505 163 278 278 902 462 133 132 400 315 631 Total 163 278 160 505 163 278 278 902 462 133 132 400 315 631 Click here if you would like to return to the menu Click here to download to Excel Most of the screens will have the 2 options at the end e Download to Excel for Printing e Return to the Menu If you wish to view the year to date activity for a prior month select that month in the Period Field The FORM SUMS Display at the top right hand side can display the amounts with cents 0 00 or dollars only 0 Page 27 of 52 Introduction to FAST Budgeting Go back to the Main Menu and type in the Organization and hit ENTER 3 https
32. U money instead of having a deposit Page 52 of 52
33. Your list of accounts maybe very long In this case use the scroll bar on the side to scroll to the bottom of the screen At the bottom of the window you will screen six boxes to help you balance you budget Please refer to the example below Page 15 of 52 Introduction to FAST Budgeting E http wren nt carleton ca FASTbudtest FAST asp FD BOS amp NF O amp RF 21 amp RL amp C Y amp F amp BE9S amp A amp P amp AC amp L Microsoft Internet Explorer p File Edit View Favorites Tools Help Back 9 e fa A Search Favorites ir Media x Sh e EM Address http fwren nt carleton ca FASTbudtest FAST asp FD BOS amp NF OBRF 218RL amp C YBF BO BEOBA BP BAC BL amp FY NMMB amp FP1 TTAFY2 8FP2 8FL TROL BaFHC v Go Links X Car leton FAST System Financial Administration Support Tool UNIVERSITY 18 x FORM 2 a 2004 2005 Budget Chart Orgn 498 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance 31555 sl 711000 1300 Photocopying Charges amp Supplies N 1500 1 500 0 1500 1 500 0 711001 1300 Printing Costs amp Supplies N 1300 1 300 0 1300 1 300 0 712000 1300 Long Distance Charges N 200 200 0 200 200 0 712002 1300 Postage Expense N 300 300 0 300 300 0 712010 1300 Edunet N 1000 1 000 0 1000 1 000 0 713000 1300 Telephone Equipment Rentals N 2240 2 240 0 2240 2 240 0 713001 1300 Computer Lease Costs
34. aBSBzBEF AABAF S EFR afr 2347 SRG eh ALS LIC e BF a FC SUMSIFHCR NEU MaL TRG S BOR OH CE NO L TP P ENBRN S 169 i pon urbs X pM l m Carleton FAST System Financia Adrimistration Sunport Toot FORE SUMS Comparative Period Mar 200 3 pend Goto Fund Chart M Last Updated Apr 26 2003 Display z Haragi Mar 2003 Mar 2003 Mar 2003 Mar 2002 Mar 2002 Mar 2002 Mar 2002 Code Tele Fiscal 1T C ornmi Budget faecal Commit Budget Budget Actual merits Balance Budget Actual ments Balance 10 Regular Operating Fund 66 051 555 13 921 788 207 07H 53 197 644 0 1 143 1 113 1z ncllary Qoerating Funds 100 160 363 D 160 463 0 13 Internally Restricted Funds 24 300 D 24 300 iu zu Lua Eemolars 077 367 fl 573 383 n 0 0 Oo 21 Grad Scholars 181 959 151 935 0 0 ez Ls Bursary 1 040 232 1 040 232 0 4 Grad Gursery 4 150 3 150 zu us Prizes 10 626 0 10 626 p 25 Grad Prizes 13 000 D 13 000 0 Restricted Sponsored zu Racearch 0 D 0 0 r Endowment nvesteant e Holdings 17 328 17 338 0 0 0 amp l US Scholar Endowments 68 000 D 568 000 0 EZ Grad Scholar Endowments 250 000 D 750 000 BS Bursare Endowments 151 000 i 151 000 0 n o rs OSTOF Bursary Endowments 76 000 n re ggi D 0 0 0 65 Ls Award amp Prize Endon an n0 30 000
35. bas 113 73 143 143 373 5ib 21001 13014 Reference Materials n g n n n z10012 1300 Other Supplies n D 711000 1300 Photocopying Charges amp Supplies 0 711091 1300 Ponting Costs amp Supplies il i 2120060 13040 Long Distanca Charges 0 2 000 2 000 712002 1300 Postage Expense o i n n 713000 1300 Telephone Equipment Rentals D 3 000 3 000 71301 1730 Computer lease Costs 0 0 ii 213002 1300 Pages Csll Phone Rental 2155060 13010 Staff Development Costs 718100 1300 a Travel General 0 oO i 7197001300 Accountable Travel Advances 3 51 3 550 3 430 3480 3 500 z 723000 1300 Equipment Purchases 5 000 0 0 amp ubTotsl 3 327 3 477 3 337 AMT 8 873 5 535 Total Bey anes Less Expenditures 3 337 DAT 3 337 aad B 873 0 935 Click here if you woud like to return to the menu Click here to download to Excel E Main Menu Microsoft Internet Explorer provided by EduNET e x File Edit wiew Favorites Tools Help Bak amp At Qusearch Favorites media C B 3 m4 H Address http oriole nt carleton ca FASTO1 Prompts asp FD MENU amp SDLSN amp FR IV amp RN 481138BV 48BN IE amp JS Y Go Links Carleton UNIVERSITY FAST System Please input your desired report parameters You can click on the to lookup a field Chart Mo Fund n
36. cords Module transfer articulation and Graduation information Part of the Banner Chart of Accounts See FOAPAL Accounts Receivable Record of student account information Module Maintains details of admission applications and provides a means to track required document submissions A Dialog box that pops notifying you on what or how to enter information Requires you to respond before continuing Billing Hours Field Tuition assessments are based on billing hours per course The billing hours are equivalent to our credit values An information area on a form separated by a solid line Calling Form Form from which you click a button and access another form Used to identify the campus which offers a course or with which a student 1s affiliated Default Main Exits from an Option List List of Values Editor Window or Dynamic Help Classification of Instructional Program an optional field which identifies the primary content of the course For information only Class Schedule Module Stores the data required to build and print a course schedule together with times dates room allocations and academic staff assignments Clears all the information and returns you to the first enterable field in the key information area The Faculty that offers the course Required saves all the changes entered since the last time you saved Conversion Converting the data stored 1n the legacy system to the new environment Often requires data
37. d use the drill down button next to the Fund cell A screen will appear with a list of all the Funds you have access to Some will have another drill down button and some will be in blue If there is no drill down button click on the Fund number in blue and that will populate the field in the Main Menu If there is a drill down button continue drilling down to the level of detail that is required Once you have reached the desired element click on it and that will populate the field in the Main Menu Click on ENTER Page 28 of 52 Introduction to FAST Budgeting The same screen s appears as in Method 1 the Fund summary A simple rule to follow in FAST If a text or number is in BLUE or if there is a drill down arrow next to a box there is still a level below with a more detailed description Repeat this method for Orgn in the Main Menu You will get the Orgn summary Method 3 Hit the ENTER button on the Main Menu screen without entering any parameters The same screen will appear as with the Fund summary but this time it will display an overview of all your top level funds for the period specified You can only view the Funds you have been granted view access to in Banner most likely the Operating Fund or a few Research Funds Access is controlled by the user s profile in Banner and is maintained by the Finance Office The example below shows many funds because it is with Finance or Business Office access Sl
38. dditional computer this year at a cost of 3 000 The total fiscal budget would then be 8 000 The additional 3 000 in fiscal budget still has to be found e g from other fiscal Adjustments can be to both or either base and fiscal budgets The Finance Office will enter budget allocations both base and fiscal for each RPC Each RPC distributes these allocations to their departments Then the departmental budgets are prepared to meet the allocation targets Page 11 of 52 Introduction to FAST Budgeting Method one is to simply select the Budget System from the Desired Report drop down selecting box and click the enter button Method two 1s to leave the default Operating Statement in the Desired Report then click the enter button and select the Budget System Tab on the next screen that opens E Main Menu Microsoft Internet Explorer provided by EduNET File Edit view Favorites Tools Help 4a Back gt fx a A Search amp Favorites PMedia Sh i B Address http iwren nt carleton ca FASTbudtest Prompts asp FD MENU amp SDL N amp FR IVaRN 449728BY 48BN IERIS Car leton FAST System Financial Administration Support Too UNIVERSITY FORM MENU Please input your desired report parameters You can click on the to lookup a field Chart M Fund Orgn Acct X Prog Actv Period Mar 2004 Open Desired Report operating Statement Operating Stateme
39. e 000 00 00 oo internet Once complete you must click the save button If you the save button is not clicked before you leave the screen all your changes will be lost Once you click on the save button the screen will change and a vacant message will appear on the zero account E FAST Microsoft Internet Explorer provided by EduNET File Edit View Favorites Tools Help SBak Q A Qsearch Favorites Meda lt 4 Fhe S m4 E FAST System Financial Administration Support Too Chart M Fund 100000 Regular Operating Fund Orgn 498 Finance Office Acct 710000 Prog 1300 Last Updated Apr 08 2004 Batch Fund Orgn Acct Prog Acty Description Name Reference an pee a i r Delete Clicking on the Ga X will remove 100000 v 498 710000 v 1300 Budget Roll o o 6980 6980 an account The 100000 498 710000 1300 o D amounts can be 100000 ass 7110000 1300 o 0 allocated to 100000 fass 710000 1300 o D other account s 100000 14 8 7110000 1300 o 0 TOTAL 6980 6980 AddLines Click here to return to 100000 498 Click here if you would like to return to the Menu be sure to save first Done 8 ap Internet Page 20 of 52 Introduction to FAST Budgeting Example of Screen with a zero Vacant line E http wren nt carleton ca FASTbudtest FAST asp FD BudDev amp t amp F TMMMMM amp 0 BE9 amp A HTMMMN amp FY 1 l
40. e Click here to download to Excel located at the bottom of most forms This will execute Excel and download your data However formulas such as sub totals totals are downloaded as values not formulas These can be restored in Excel Save the file in a directory and re open it using Excel Select the entire spreadsheet by clicking on the upper left hand corner cell at the intersection of the Columns and Rows Follow the steps below to add subtotals Adding Subtotals in Excel N 18 x File Edit View Insert Format Tools Data Window Help Acrobat 8 x MR o z f I 2 i 2 24 sot ana 75 B7 8229 WMG E 2 07 Ime ipi l FASTO1 TDOS 2 asp FD TDOSBNF z orm A2 M 710000 pou m EIDEM AL as Tn Eee a EC 1 p p 2 zo000 orfice suppiies Group and Outline li PivotTable and PivotChart Report exp charged to wrong ak G External Data b E E AL each change I SS Acct B 710000 oficeSuppies 2003023 uoooowe test again 9 710000 OfieSuppies J zoowowes omowz rEsT3 10 710000 OficeSuppies zo0wowes onos rEsT4 Use Function 11 710000 orice Supplies 2003704123 luoooo1ga test 5 12 roo nd 2um E 43 v0 pd Steps to Add Subtotals 14 710001 Fd 4dd subtotal to 15 710001 re 16 710001 Fi Click on the DATA menu Invoice H
41. e allocating amounts at the Org level is similar to re allocating amounts at the account level In this case when you enter into the system you should see all the high level Orgs for which you have been given access You see a screen similar to the screen below Again we must remember that all the codes at part ofa hierarchy So you will have to allocate at every level E http wren nt carleton ca FASTbudtest FAST asp FD BSUMS amp NF amp RF 21 amp RL amp C Y amp F TMMMMM amp U M amp A amp P amp Microsoft Internet Explorer p File Edit view Favorites Tools Help gt Q A Qusearch Favorites meda lt 4 D 3 AW xj Address http wren nt carleton ca FASTbudtest FAST asp FD BSUMS amp MF amp RF 218 amp RL 8C Y amp F TMMMIMM amp O M8A amp P amp AC amp L 8FY1 NMMBSFP1 TT amp FY2 8FP2 8FL 88C Y Carleton UNIVERSITY FAST System Financial Administration Support Tool FORM 2004 2005 Budget p Chart M Fund 100000 Orgn O0 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance S Faculty of Arts amp Social Sciences sooo00 28 793 421 28 293 421 500000 28 887 304 28 387 304 10000 Central 350000 181 502 289 181 852 289 66000000 181 502 289 115 502 289 2000 Fac of Public Affairs amp Managment 500000 22 119 230 21 619 230 5000000 22 119 230 17 119 230 3000 Faculty of Scie
42. er account and then place funds into the Base and Fiscal When you click on the selection arrow the screen will below will appear Page 17 of 52 Introduction to FAST Budgeting Selection Screen E FAST Microsoft Internet Explorer provided by EduNET dm Bark b fx fa d Search s Favorites eMedia ca ET 6 UE Please click on the desired Acct code If aw is shown wou may click an it ta find Acct codes that report to this one Chart Acct Title Status m 210 Government Grants Active M S20 Central Tuition Fees Active M 525 Other Student Fees Active M 530 Sales of Goods amp Services Active M 531 Sundry Income Active M 540 Recovery of Salary Benefit amp Other Active M 550 Endowment amp Investment Revenue Active M 560 Donations Revenue Active M S70 Research Revenue Active M 610 Full time Salaries Active M 611 Part time Salaries Active M 612 Research Salaries Active n 620 Internal Lab r amp Salary Redistrib n Active M 630 Univ amp Gov t Benefit Plans Active M 639 Internal Cost Alloc Benefits Active n 710 Materials amp Supplies Active M Fil Printing amp Duplicating Active M F120 Communications Active M 713 Equipment Rental amp Maintenance Active Ml 71d Principal Debt Repayment Active i E j Done EN NF EN r3 Internet a ES laj x File Edit View Favorites Tools Help E FAST Microsoft Internet Explorer provided by EduNET
43. expense Account and Name Date of Purchase Description PO Invoice Cheque Amount Paid Clicking on any Column re sorts Data Records per Page E MILLE PEDI MPOSHT IneernEE EANG provid Dy EduMET E i 14 x Fle Edt yew Fawkes Tods Help Pa L M a search ejFavortes frida Ans ito foriale nt careton csJFASTO4 TDOS 2 asp Ca rleton FAST System Financial Adrmistratior Support Too UNIVERSITY FORM TOOS Chart h Fund 100000 rngn 38 Last Updated Apr J5 2003 Records per page 1n Teslirg paking 1unsaeton A s 2 000 00 i zya Teleahone Equipment 7 osea joo Fatali Show A Racardi A cct AcctHame Actv Loch Date Dacurnent Description Requisition P Invaice Cheque Amount rtoco Cien Sep plies S 00302 poniai sate ee 4247 004 517 50 f TH EE Sspplier z 203 0705 cpntat GET 1217 0031 21713 710000 Otia Supplies aonana oona biith TE 50 T4070 Accountable Trawel Advances jamaa JOO00005 T Sullivan iael advance 3 500 00 712000 Long birance Charger 20 36c n ae PF cag 2 000 00 Fae Lass Exes 8 873 30 lonono aen AM Piera ts Excel Click pm any column heading ta sort by that calumn Click it a second time to reverse the sort You can change the lines per page by changing the number in the ecard per page bax and miling enter Note the more
44. f lt List gt appears in the status line List Serve An email site that enables users to exchange 1deas propose solutions and ask for help Location Code Location Management Maintains information about the institution s building and room Module facilities Housing Major Field A record of the declared Major Required Menu A list of options you can access with the mouse or keyboard More Appears in the lower right corner of each window for a series of Level Field List of Values LOV relate forms It tells you that there are additional forms that can be accessed to complete a process Object An object can be a form job menu or quick flow used in Banner Option List Dialog box displaying two or more items to choose from Organization Code Part of the Banner Chart of Accounts See FOAPAL window eligibility for enrollment in subsequent courses Identifies who is authorized to waive a prerequisite requirement Prerequisite Waiver Page 49 of 52 Introduction to FAST Budgeting Banner Term Definition Field Pcard Procurement Card or Card for low value purchases assigned to authorized staff for goods and services up to specified amounts Pcard Administrators The group which approves Pcard applications monitors all Pcard usage and which may revoke the Card privilege of Cardholders in the event of misuse Program Code Program Field Identifies the goal or credential the student is working towards
45. finer detail on the 175 Math area of spending 1 lab course activities L Location Physical N A at this point in Optional Location time FOAPAL elements are hierarchical that is expenses or revenues at the lowest detail 1e Office Supplies are rolled up to a more general description which is in turn rolled up into a higher level category The following are examples of the element hierarchies FUNDS are at different levels 10 100 1000 or 100000 For regular operating accounts the fund is 100000 For Athletics it is 120000 For Parking it is 120600 etc You only need to know your fund number and it does not change Page 9 of 52 Introduction to FAST Budgeting ORGANIZATIONS are at different levels For example Faculty of Public Affairs amp Management PAM is 2000 The different departments in PAM are a subset of 2000 Some of you may be responsible for more than one department For Journalism it is 031 For Business it is 091 For Economics it 1s 094 etc You only need to know your organization number s and that does not change ACCOUNTS are divided into categories or types of expenses and revenues and also are in levels For example for the main Operating Expenditures type of expense the Account is 710 Expenses falling into that category may be Materials amp Supplies 7100 Printing amp Duplicating 7110 Communication 7120 More detailed descriptions of the expense are available for
46. get p 7 Chart Orgn 498 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance 498 Finance Office N 0 755 352 755 352 0 755 352 755 352 Total 0 755952 755 352 0 755 352 755 352 Base Allocation 0 Fiscal Allocation 0 Click here if you would like to return to the menu Click here to download to Excel Dome ep internet o Page 14 of 52 Introduction to FAST Budgeting All the FOAPAL codes in Banner have a hierarchical structure Therefore you will have to click on or drill through the structure until you get to the account level This is done click in the blue code number In the example above that would be the 498 Once at the lowest level your screen will look like the example below 34 http wren nt carleton ca FASTbudtest FAST asp FD BOS amp NF O amp RF 21 amp RL amp C Y amp F amp BE9 amp A amp P amp AC amp L Microsoft Internet Explorer p File Edit View Favorites Back gt e Za A Search 4 Favorites jr Media 4 Sh e i Address http wren nt carleton ca FASTbudtest FAST asp FD BOS amp MF O amp RF 218 amp RL 8C Y amp F amp O BE9 amp A amp P 8AC 8I amp FY1 NMMB amp FP1 TT amp FY2 amp FP2 8 amp FL T amp OL 8 amp FHC Y Tools Go Links Carleton UNIVERSITY FAST System Financial Administration Support Tool FORM 2002005 Budge
47. ies f f 200023 yoooes B 70000 fottice supplies f f 20030423 gonootee 9 70000 omeesupies f f 20004423 yooooie 10 710000 JOriesupies f 2004723 Joonotee 11 70000 Joreesupies f 200023 yooomes AZ z0000 roa 13 710001 Reference Materias f 2003704223 sooonres 14 zwom Reference Materiais f 20030423 Joontes 15 710001 Reference Materias 200370223 yoooo1e AG 710001 Reference Materias 200304723 sooooies AF 710001 Reference Materias f 200370723 yooooies AB roots 19 roo Photocopying Charges amp Supplies _ 2003704723 Jnonote5 testreslloc 20 rm Photocopying Charges amp Supplies 1 2003704723 uooo0r6 ftestagain 21 gmeeroa 5 5 22 mmo Printing Costs amp Suppies f 200304723 uooooro Graphics Printing Costs 23 moortort 24 rzo00 LongDistance Charges 2003702701 uoooom Testing parking transaction amp uts 25 712000 LongDistance Charges f 2003703721 uoooorss testreferencenumber 26 72000701 S 27 73000 Telephone Equipment Rentals 2003702701 uoooom Testina parking transaction amp uts 328 Toa PE n ux X 3 500 00 3 BNNNENENI 9 118 39 Grand Total 18 236 78 3 o c test with TS a pwi e Leader Procurement Services Inc Gs Reallocate exp charged
48. ion form table U Utility HR Payroll Personnel P Position Control N A Application B Budget C COBRA Alumni Development A A Membership D Designation E Event Management B Budgeting C Record Creation E Electronic Data Exchange F Funds Management H History and Transcripts J Student Employment L Logging N Need Analysis O Common Functions P Packaging amp Disbursements R Requirements Tracking S Student System Shared Data T Validation form table U Utility D Benefit Deductions E Employee H Time Reporting History O Overall P General Person R Electronic Approvals S Security F Campaign G Pledge and Gift Pledge Payment M Prospect Management O Organization P Constituent Person S Solicitor Organization T Validation form table U Utility T Validation rule table U Utility X Tax Administration X Expected Matching Gift Information Access I S Student R Financial Aid All Products Reserved for client forms or modules used within a Banner2000 application character in position 1 does not equal W Y or Z Page 45 of 52 Introduction to FAST Budgeting Position 3 General G Student S Finance F identifies the A Application form A Application form A Application form type of form B Base table B Base table B Base table report job or Batch COBOL process table I Inquiry form I Inquiry form I Inquiry form O Online COBOL process Q Query form Q Query form Q Query form R
49. ired on most forms as the system will provide it Some examples of Program Codes CCS 1400 Food Services 3000 Bookstore 3040 Instruction General 1100 Page 10 of 52 Introduction to FAST Budgeting 5 0 Budgets The Base Budget represents the on going or long term commitment by the University It is carried forward each year and is the foundation for developing the fiscal budget A good example would be the salary of one continuing full time faculty member The base budget for their salary will be 10095 regardless of whether they are working are on sabbatical or other leave as this is the University s long term commitment until the individual is no longer an employee A second example would be a department s anticipated need for 5 000 per year in computer upgrades over the long term A base budget would be established for equipment purchases to include this amount The base budget is not static and as long term goals and commitments are revised so are the base budgets As base budget requests were processed in 2003 2004 the original base that was established through the 2003 2004 budget process was updated as the on going base When the 2004 05 detailed budget submission processes begin in March April At the start of the budgeting process the base is rolled into the base budgets for 2004 05 There will be some modifications to base budgets at the RPC level for planned budget increases and decreases as part of the RPC
50. lies N o 1 300 1 180 1300 1 300 0 712000 1300 Long Distance Charges N o 200 200 200 200 o 712002 1300 Postage Expense N o 300 300 300 300 0 712010 1300 Edunet N o 1 000 1 000 1000 1 000 o 713000 1300 Telephone Equipment Rentals N o 2 240 2 240 2240 2 240 o 713001 1300 Computer Lease Costs N s000 18 000 3 000 18000 18 000 o 713002 1300 Pager Cell Phone Rental N 500 500 500 500 500 0 716900 1300 Staff Development Costs N 3500 3 500 3 500 3500 3 500 o visi rspg CGOTTACenes Troxel oenerey oN e000 9 000 7 600 9000 9 000 0 723000 1300 Equipment Purchases lt 5 000 N 5000 5 000 5 000 5000 5 000 0 SubTotal Direct Expenditures 25000 49 520 24 520 56500 49 520 6 980 Total Revenues Less Expenditures 25000 755 352 730 352 56500 755 352 698 852 Base Fiscal To Allocate From Chart M Fund 100000 Orgn 498 25000 Oo Allocated 2sooof 6500 Difference 3 o sesoo Red Saved Save Click here if you would like to return to the menu Click here to download to Excel i93 re en Internet Difference message box will all amounts allocated Once you have saved your completed budget contact your RPC Administrator Finance will then be contacted and the N in the Locked column will be changed to Y Yes by Finance Once the system is locked changes to budgets can only be done by Finance Page 23 of 52 Introduction to FAST Budgeting 6 0 Budget For the RPC Administrator R
51. ministration Support Tool integrates with Banner for financial data budgeting and reporting F P Field Indicates full or part time status of the student for the term Page 48 of 52 Introduction to FAST Budgeting Banner Term Definition Field Area in a form where data can be entered queried or displayed Banner describes the field as either enabled disabled enterable or display only File Represents the elements of Carleton s Accounting Distribution in Banner Banner Chart of Accounts F Fund source of the money O Organization department admin unit responsible for the fund FOAPAL A Account type of expense or revenue P Program tracks functional area for which the funds are used A Activity additional details of the expense L Location location of capital assets Form Window containing enterable fields for a process From Term Field Indicates the term in which the course was first approved Required Full Credit Course Course that spans more than one term Fund Code General Person Module General Student Module Help Inquiry Form Used to look up existing information on the databases Allows you to view but not update Legacy System Older computer system usually running on a mainframe computer CP 6 is an example Identifies the level of study 1 e UG Undergraduate SP Special GR Graduate Displays a list of values for the current field 1
52. mp pr 28 2003 Code Name i Regular Operating Fund 12 Ancillary Gpsrsting Funds 1H Internally Restricted Funds 20 UG Scholars Fl Grad Scholars zz UG Bursary z3 Grad Bursary z4 WG Prizes zh Grad Prizes i Besbicted Sponeared Paesaarch amp ll Endowment Investment Holdings amp 1 LUG Scholar Endowment Grad Scholar Endesrments 63 Bursary Endesrments ea OSTOF Bursary Endoeenents 65 Uis Award amp Prize Endow Total Chek hare if yay vou like ta return be th menu FAST System Firancud Administration Support Toor Display B FORM SUMS Current Tear Period Apr 2003 Openi Goto Fund n x mmo T eS DT HiMIEUM o oo A o mall Adjusted Original Adjusted Actuals ncumbered Available 14 357 225 14 112 803 14 117 173 14 317 373 13 995 076 20 046 P25 da2 10r erT 107 727 107 587 107 587 135 225 0 27 637 24 250 24 250 24 250 24 250 24 300 i1 50 375 974 575 234 975 604 575 608 378 937 a 3 343 162 049 182 289 181 569 131 865 181 989 i 12D 1 033 232 1 038 552 1 032 98z 1 038 932 1 040 232 a 1 240 4 050 4 150 4 250 4 150 4 250 i 0 10 646 10 726 10 586 10 526 1o 626 i 0 13 010 13 050 Lz 280 i 9 amp 0 13 000 D 20 0 n 0 n sf eS n 1 023 17 388 17 55 17 238 17 23B 17 538 100 bo 040 68 200 67 920 67 920 ha 000 i Bib 50 010 250 050 249 980 249 98 250 000 e 151 020 151 100 150 960 150 960 151 000 40 76 020 Ph 100 75 950 7
53. nce soo000 14 495 469 13 995 469 3000000 14 495 469 11 495 469 4000 Fac of Engineering amp Design X sooo00 16 324 374 15 824 374 2000000 16 324 374 14 324 374 5000 Academic Admin amp Student Services soo000 23 249 405 22 749 405 15000000 23 249 405 8 249 405 5500 Library 50000 10 580 164 10 530 164 5000000 10 580 164 5 580 164 6000 Research sooo00 12 482 722 11 982 722 10000000 12 482 722 2 482 722 7000 Finance amp Administration sooo00 32 625 935 32 125 935 17000000 32 625 935 15 625 935 8000 Advancement 50000 3 111 511 3 061 511 2000000 3 111 511 1 111 511 9000 President 50000 2 175 076 2 125 076 1000000 2 175 076 1 175 076 o 0 ofl oa o 0 Total 4000000 15 544 982 19 544 982 5500000 15 451 099 9 951 099 Base Fiscal To Allocate From Chart M Fund 100000 Orgn 0 1000001 6666666 Allocated X 4000000 ssooo00 Difference so00001 12166666 i H http wren nt carleton ca FASTbudtest FAST asp FD BSUMS amp NF O BRF 218RL amp C Y amp F TMMMMM amp O TMMM amp A SP B amp AC BL BFYI NMMB amp FPi TT amp FY2 g Internet Page 24 of 52 Introduction to FAST Budgeting Here the example shows an allocation of 500 000 to the Faculty of Arts amp Social Science At this point the Administrator must click on the 1100 to move down to the next level 3 http wren nt carleton ca FASTbudtest FAST asp FD BSUMS amp NF O amp RF 21 amp RL amp C amp F TMMMM
54. nt Balance Sheet ENTER Budget S If you prefer YOU Can dad et Adjustments put boxes blank and click the ENTIDocument Query Dduce a report summarizing all o Document Lookup Click here if you would like to change your password Note this will change your Banner password as well Click here to access the online documentation Done nk 4D Internet If you chose method one a screen similar to the one below will come up Please note that due to the differences in Fund Org security setup the screen will be different The basic layout will be the same Please do not compare your screens with someone else Your view of the data will be unique to you Page 12 of 52 Introduction to FAST Budgeting http wren nt carleton ca FASTbudtest FAST asp 4 amp AC amp AHC N amp AL 1 amp BF AAKC amp D amp DA KDT KENC amp F amp Microsoft Internet Explorer p 18 x File Edit view Favorites Tools Help 4a Back gt e aa A Search Favorites F Media N eh EJ E a Address http wren nt carleton ca FASTbudtest FAST asp A 8AC amp AHC N amp AL 1 amp 8BF AABC Y amp D amp DA amp DT amp EMC amp F amp FFM B amp FL T amp FHC N amp FD BSUMM amp FP1 TT amp FP2 8F Y Carleton UNIVERSITY Go Links FAST System Financial Administration Support Tool FORM 2003 2004 Actual 2004 2005 Budget SSS ee ae eee Chart M Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Ba
55. ocument e Budget System Notes The first note tells you that it is not necessary to fill in the FOAPAL elements on the main menu screen The second note gives you another place where you can change your Banner Password if you have not already done so by clicking on the Blue Click here The third note provides you with access to all Finance documentation including this Manual by clicking on the Red Click here All documentation on the web is the latest version Page 8 of 52 Introduction to FAST Budgeting 4 0 FOAPALs FOAPALs are the new Chart of Account COA elements What an account was to CP 6 a FOAPAL is to Banner The following is a table defining the FOAPAL concept FOAPAL Expense Detail F Fund Source of How is the funding e Operating Fund 100000 Mandatory Funding provided which pot e Athletics Fund for regular of money is it coming Research Fund operating fund from O Organization Department Who is spending the Math Dept 175 Mandatory for money Engineering D175 in CP 6 Revenue amp CCS Expense A Account Nature or What is the spending P T Salary 611200 Mandatory Type of on Tuition Fees Expense Office Supplies P Program Functional Where are the funds Instructional Required for Use of Funds being used which Administration Revenue amp functional area External Relations Expense but Defaults in A Activity User Defined Why are the funds Defined by User for 1751 Optional Reporting being spent
56. ols Help gt 90f 4 u 9 8 9 s Back Forverd Stop Refresh Home Search Favorites History Mail Print Edit Address amp https oriole nt carleton ca FASttest Prompts asp FD zMENLI amp SDLSN amp FRZIV amp RN2614508BV 24 amp BN zIE J5 Y Gar leton FAST System Financial Administration Support Tool UNIVERSITY FORM MENU Please input your desired report parameters You can click on the to lookup a field Chart M Fund Orgn rls Acct e Prog ils Acty lm Period Dec 2003 Open Desired Report Operating Statement Operating Statement Balance Sheet Document Query If you prefer you can i blank and click the ENT produce a report summarizing all of your accounts Click here if you would like to change your password Note this will change your Banner password as well Click here to access the online documentation gi Dome p L B neme Page 39 of 52 Introduction to FAST Budgeting Document Query Go to the Main Menu Desired Report and select Document Query The screen below will open 3 Document Query Microsoft Internet Explorer File Edit View Favorites Tools Help e gt 0 A Aaa BIB 5S s Back Forward Stop Refresh Home Search Favorites History Mail Print Edit Address a https oriole nt carleton ca FASttest DOCQ asp FD DO amp SDL N Y e Go Links sar le
57. r 710000 in both fields only documents that were posted to 710000 will be searched If left blank all combinations of Account codes will be searched e Dollar Value Searches by dollar amount If you do not know the exact amount Equal To you can search by Less Than or Equal To and Greater Than Page 40 of 52 Introduction to FAST Budgeting Document Lookup Once a document or reference number has been found using Document Query the debits and credits that make up the transaction can be displayed using Document Lookup From the Main Menu select Document Lookup from the Desired Report box The following screen will open 3 Document Query Microsoft Internet Explorer provided by EduNET inl xl File Edit View Favorites Tools Help da Back wb fx uH EA search s Favorites g Media x E c E hi Address https foriole nt carleton cafFASTO1 DOCLU asp FD DL amp SDL N Go Links Car leton FAST System Financial Administration Sunnort Foo UNIVERSITY n FORM DL Document Look Up Enter Document Reference Number s do not use spaces separate document numbers with 3 SUBMIT Clear Form Return to Main Menu Enter Document Reference Number s in the entry box You can enter multiple documents by using a semicolon to separate the document numbers The note on the screen tells you not to use spaces Click the SUBMIT button to execute the query A screen similar to the one
58. rating Furds a4 651 0 44 654 13 Internally Psteictuid Funds ET D ET eu Uf amp eholars 323 383 l Grad Scholars c LS Bursary 1 080 1 080 23 Gred Bursary 0 24 UAG Prizes 25 Grad Prizes 2 Restncted Sponsored Research il 0 Bu Endowment nvesteivent Haldimgs i 0 Gl Us Scholar Endowments be Grad Scholar Endowments i 0 i 63 Bursar Endowment 0 Ed OSTOF Bursary Endowments ES US Asgard amp Prize Endow n TOTAL 472 541 z 7 8578 AB 415 Click here if you would like to return to the Menu Click here to download to Excel for printing If you wish to view by month the from and to will be the same Page 34 of 52 Introduction to FAST Budgeting 8 6 Goto Drop Down Menu If a FOAPAL element was not selected in the main menu the default view in the Navigation Screen will display data by Fund This can be changed using the Goto drop down selection box This will display a menu of the FOAPAL elements Fund Org Account Program Activity and Location Selecting one of the FOAPAL element options will change the view to the selected element Because most administrators will only have access to one Fund the Operating Fund the view displayed will default to Organization summaries Be EK yew Favotes Tods Heb ee O A db Quer Girone den qii dci gi omo UNIVERSITY 2002 2005 Actual Lhart d Last Updated a
59. records you have per page the longer it will take t display Previous 10 and Next 10 Records x intemet Sorting To sort the data click on the column you wish to sort The data can be sorted in either ascending or descending order by re clicking on the column Records per Page You can set the number of transaction displayed per page in the Records per page box on the right hand side of the screen Page 37 of 52 Introduction to FAST Budgeting Viewing All Transaction Records The default display is 10 records per page but all records can be displayed by clicking on the Show All Records Transaction Summary Paged Microsoft Internet Esploeer provided by EduNET Fie Edt yew Favortes Tools Hep bik Qo EO erh ajes eda G A mm amp Address E tktotiforiole nt carleton calPasTO4 TOOS_2 asp qe Links re Carleton FAST System Financial Adrmstration Suppart Toa UNIVERSITY FORM TDOS Chart Fund 100000 Orgn 98 Last Updated Apr 26 20053 Records per page 1n cct uoctName Acty Lncn Date Document Description Requisition po Invaice Cheque Amount rroxce oss Supplies esosecame contat rdi d jiao 517 50 i 100 Oies Sspplier z0n30205 iecontat ORT pee 21 I 23 00 710000 asica Ew lc ie zz Jo0000d7 tate TR T4DTOD Acountable Traeel Adwances zoznam vooD00Ds
60. rrow icon contains a drop down list Displays a window you can use to add change or delete text especially useful in entering data in Dynamic Help Puts the form into query mode and lets you enter search criteria to retrieve information already in the database ERP Enterprise A software system designed to support and automate the business Resource Planner processes of companies and institutions An ERP does this by integrating departments and functions to create a single software program that runs off one database Banner 1s the Enterprise Resource Planner for educational institutions Indicates courses that are regarded as equivalent across all Faculties In query mode searches the database and displays any records that match the search criteria Exit From Forms and Windows exits out of the form or window From Menus exists out of the Banner system From Query cancels the query and takes the form out of query mode Exit with Value From a called form returns to the calling form and enters the highlighted value into the field that called the form From a List of Values LOV returns to the calling form and enters the highlighted values into the field in that called form Exit without Value From Forms and Windows exits out of the form or window From Menus exits out of the Banner system From Query cancels the query and takes the form out of query mode FAST Financial Ad
61. se Variance Fiscal Alloc New Fiscal Bud Fisc Variance Fund 100000 Regular Operating Fund 541 Physical Plant Administration N 0 5 979 891 5 979 891 0 5 979 891 5 979 891 542 Physical Plant Maintenance N 0 3 030 735 3 030 735 0 3 030 735 3 030 735 543 Physical Plant Technical Services N 0 5 407 100 5 407 100 0 5 407 100 5 407 100 544 Physical Plant Space Administration N 0 8 000 8 000 0 8 000 8 000 7070 Physical Plant N 50 000 0 50 000 0 0 0 Subtotal 50 000 14 425 726 14 375 726 0 14 425 726 14 425 726 Fund 101025 WO 59693 Classroom upgrades 2003 541 Physical Plant Administration N 378 823 378 823 378 823 378 823 545 Construction Services N 378 823 378 823 378 823 378 823 Subtotal 0 0 0 0 Fund 102005 W059089 PA Renov to Rm 132 541 Physical Plant Administration N 2 000 2 000 0 2 000 2 000 Subtotal 0 2 000 2 000 0 2 000 2 000 Fund 102010 W060372 Tory Level 4 Renovations 545 Construction Services N 0 45 000 45 000 0 45 000 45 000 Subtotal 0 45 000 45 000 0 45 000 45 000 Fund 102013 W060827 MC Renovations to Room 2050 545 Construction Services N 36 000 36 000 36 000 36 000 Suhtatal n aRn nnn 3 amp nnn n an nnn a amp nnn X Done a r Internet Like in FAST Reporting the Funds and Org codes that you have access to will appear To start budgeting you may want to start with an Org code in the Main Menu Screen The example below uses org code 498 Page 13 of 52 Introduction to FAST Budgeting
62. t NMMB amp Microsoft Internet Explorer p File Edit View Favorites Tools Help Back amp At Qsearch Favorites Ghmeda lt 4 D Sp m4 S Address http wren nt carleton ca FASTbudtest FAST asp FD BudDev amp C V8F TMMMMM amp 0 BE9 amp 4 HTMMMN amp FY 1 NMMB amp FP 1 TTaRN 26819 Go Links gt Carleton UNIVERSITY FAST System Financial Administration Support Tool Chart M Fund 100000 Regular Operating Fund Orgn 498 Finance Office Acct 710002 Last Updated Mar 27 2004 Batch Fund Acct Prog Actv Description Name References Position Employee Adjusted Adjusted ID ID Base Fiscal 100000 Y 98 Y 710002 v 1300 v J 5980 5980 100000 Y Y 710002 TY Orgn IN Ce t acant 498 CO 100000 fase iow PE OE E EO 100000 fase noo 100000 498 710002 AddLines i To delete a line set both dollar amounts to zero not blanks Click here to return to 100000 498 Click here if you would like to return to the Menu be sure to save first start 3 REEL OO Connection Complete J MSN Messenger M Fast bud scree jhtep wren Leds 0 a FFAGL 07 19 AM If you now click on the Click here to return to FFFFFF OOO you will see the account is zero and you new accounts have been added Page 21 of 52 Introduction to FAST Budgeting E http wren nt carleton ca FASTbudtest FAST asp FD BOS amp NF amp RF 1 amp R
63. t OZ C NS Chart QOrgn 498 Last Updated Mar 27 2004 Code Name Locked Base Alloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance P 610601 1300 cee CUPE 2424 N 441504 441 504 o 441504 441 504 o 610606 1300 Admin Management F T Salaries N 262618 262 618 o 262618 262 618 o 610800 1300 Overtime Paid to F T Employees N i510 1 510 o 1s0 1 510 o 620000 1300 ae Plant Labour N 200 200 0 200 200 0 SubTotal Labor 705 832 705 832 0 705 832 705 832 0 710000 1300 Office Supplies N 6980 6 980 o 6980 6 980 0 711000 1300 Photocopying Charges amp Supplies N 1500 1 500 o 1500 1 500 0 711001 1300 Printing Costs amp Supplies N 1300 1 300 o 1300 1 300 o 712000 1300 Long Distance Charges N 200 200 0 200 200 0 712002 1300 Postage Expense N 300 300 0 300 300 0 712010 1300 Edunet N 1000 1 000 o 1000 1 000 o 713000 1300 Telephone Equipment Rentals N 2240 2 240 o 2240 2 240 o 713001 1300 Computer Lease Costs N 18000 18 000 o 18000 18 000 o 713002 1300 Pager Cell Phone Rental N 500 500 0 500 500 o 716900 1300 Staff Development Costs N 3500 3 500 o 3500 3 500 0 719100 1300 eens Travel General N 9000 9 000 o 9000 9 000 0 723000 1300 Equipment Purchases 5 000 N S000 5 000 o sooo 5 000 0 SubTotal Direct Expenditures 49520 49 520 o 49520 49 520 o Total Reveniies ess Fxnenditiires 75535 755 352 n 75535 755 352 n z E interne
64. t yet done so in Banner you must do that now 3 FAST Login Microsoft Internet Explorer File Edit View Favorites Tools Help lt 2 9 a E 3 2 a A H 9 2 Back Forward Stop Refresh Home Search Favorites History Mail Size Print Edit Discuss Fealcom Messenger Address amp https oriole nt carleton ca FAST 2 Login asp FD 2LOGINSFR 2LC amp JS Y amp BN 2Microsoftzz20Internetzz20E plorer amp BV 24805 2win328RN 273271 e Go Links Car leton FAST System Financial Administration Support Foo UNIVERSITY Millennium Please provide your User ID and Password User ID firstnamelastname Password u m E fe Internet Hit the ENTER button The Main Menu will appear Page 6 of 52 Introduction to FAST Budgeting 3 0 FAST Main Menu Internet Explorer Menu amp Tool Bar c Main Menu Microsoft Internet Explorer Ele Edit View Favorites Tools Help 2 282 BD 2 8 S9 n e 3 m5 s gt 2 Back Forverd Stop Refresh Home Search Favorites History Mail Size Print Edit iscuss Realcom Messenger Go Links Address amp https oriole nt carleton ca FAST 2 Prompts asp FDZMENU amp SDLZN amp FRZIV amp RNz2328838BV 24 amp BN2IE amp 8J5 Y Car leton FAST System Financial Administration Support Too UNIVERSITY FORM MENU Please input your desired report parameters You can click on the to lookup a field Chart FOAPA
65. tes Tools Help Back amp A Qsearch Favorites Pmedia 04 D 3 EJ x Address http fwren nt carleton ca FASTbudtest FAST asp FD BudDev amp C Y amp F TMMMMM amp O BE98A HTMMMM amp P TCMM amp IA HMBRN 49808FY 1 NMMSBFP1 TT amp RN 77872 Go Links Carleton UNIVERSITY FAST System Financial Administration Support Tool M Fund 100000 Regular Operating Fund n daa Fi ice Acct 710000 Prog 1300 Last Updated Mar 27 2004 Selection Activity Code Arrows Batch Fund Org Acct Prog Description Name Reference rosam EC ee so dee 100000 v 498 710000 v 1300 Budget Roll o o 6980 6980 100000 v 498 Y 710000 v 1300 0 0 100000 v 498 Y 710000 v 1300 0 0 100000 v ace Y 710000 v 1300 0 0 100000 v 498 Y 710000 v 1300 0 0 TOTAL 6980 6980 AddLines To delete a line set both dollar amounts to zero not blanks Click here to return to 100000 498 Click here if you would like to return to the Menu be sure to save first Done MM fg internet This screen is at the lowest level of the FOAPAL hierarchy You will notice that the Activity code is now available This is not a required field and is only provided to help departments that chose to account at that level On this screen you will also notice some drop down arrows for selecting code elements On this screen you can use the selection arrow to select anoth
66. test FAST asp FD BSUMS amp NF OBRF 218RL amp C Y amp F TMMMMM amp O TTTM amp A BP B amp AC BL 8FY1 NMMBBFPI TT amp FY2 8FP2 8FL v Go Links Car leton FAST System Financial Administration Support Too UNIVERSITY FORM 2003 2004 Actual 2004 205Budget l SES Chart Fund 100000 Orgn 1110 Last Updated Mar 27 2004 Code Name locked BaseAlloc New Base Bud Base Variance Fiscal Alloc New Fiscal Bud Fisc Variance 081 Art Gallery N 5000 261 781 256 781 200000 261 781 61 781 4 087 Office of the Dean of Art amp Soc Sci N 5o00 563 153 558 153 200000 563 153 363 153 089 Arts amp Social Science General N s0000 1 133 199 1 083 199 200000 1 133 199 933 199 097 Geography N 11000 2 284 514 2 273 514 2 284 514 2 284 514 098 Environmental Studies N 2220 7 561 5341 Oo 7 561 7 561 112 Sociology amp Anthropology N 10000 3 229 442 3 219 442 200000 3 229 442 3 029 442 118 Psychology N 100000 3 764 108 3 664 108 200000 3 764 108 3 564 108 124 Women s Studies N 100000 357 663 257 663 100000 357 663 257 663 216 Life Sciences N 1o000b 205 454 105 454 soooo 205 454 155 454 396 Centre for Initiatives in Education N 66780 340 999 o 340999 340 999 0 N 6 0 o fo 0 0 Total 500000 28 793 421 23 440 678 7530352 28 887 304 21 356 952 500 000 from previous 1100 level Base Fiscal To Allocate From Chart M Fund 100000 Orgn 111
67. that to accounts were added and the amounts from account 71000 were moved to 710003 and 710002 The original amount in this case has a been set to zero 3 http wren nt carleton ca FAS Tbudtest FAST asp FD BudDey amp C amp F TMMMMM amp 0 BE9 amp 4 HTMMMM amp P TCMM amp TA Microsoft Internet Explorer p File Edit View Favorites Tools Help Back gt amp At Qsearch Favorites Gmeda 4 D 3 EJ xj Address http wren nt carleton ca FASTbudtest FAST asp FD BudDev amp cC Y amp F TMMMIMM amp O BE98 A HTMMMM amp P TCMM amp IA HM amp RN 49808FY 1 2NMMS amp FP1 TT amp RN 77872 Go Links 9 Carleton Batch Fund 100000 100000 190000 100000 100000 UNIVERSITY Chart M Fund 100000 Regular Operating Fund Orgn 498 Finance Office Acct 710000 Prog 1300 Last Updated Mar 27 2004 Acct 710000 710003 710002 710000 710000 FAST System Financial Administration Support Tool Prog Actv Description Name References 1300 Ce unger OO 1300 ee Dp 7 1300 ee p 1300 a a 1300 ee p Position Employee Adjusted Adjusted ID ID Base Fiscal o o 0 0 1000 1000 5980 5980 E ef P i p o oe la xi TOTAL esso 6980 AddLines To delete a line set both dollar amounts to zero not blanks Click here to return to 100000 498 Click here if you would like to return to the Menu be sure to save first po
68. the main account For example under Materials amp Supplies some detailed codes are Office Supplies 710000 Computer Supplies 710003 Sports Supplies 710011 The same applies to all other expense categories It is at this level that all transactions must be coded summary information can be viewed at the higher level but cannot be coded to those numbers You will notice that the number of Account Codes has multiplied since the migration to Banner This is because the Accounts are stored centrally so that all areas can access them While operating departments do not normally need to segregate computer supplies from office supplies Research Accounting does To assist Administrators with managing the number of accounts within their Operating Department Organization it is recommended that only 1 or 2 account codes be used under each major category For example e Materials amp Supplies just use the Office Supply code of 710000 e Travel just stick to the 719100 for General Costs Associated with Travel There may be certain additional codes that will be used by charging department such as Physical Plant Labour but for the most part this should simplify the number of account codes used This is only a recommendation however additional account codes may be used if required by the Department PROGRAMS describe where the funds are being used The code defaults by a combination of the Fund Organization code and is not requ
69. the message bar indicates the level of data being viewed The Account and Program Segments are in the left hand column E Lu EL af FAST asp UR z T arp Pid gt d A CHO Aeh Foes Geda 3 GL Sb m Adress 2 tcn ca FASTOA4 FAST sop PF DOS HF a COT a2 1 R Lec ad a H SEES BA Pa AC iM a AFYL a NHRCRFPLSTMBFTZaNIMCBEPZRTTEFLaEDOLaBSRINaSa257 qon urbs 4 Carleton FAST System Financud Aademewstrat on Support Toa UNIVERSITY Fab 2003 Open FORM 25 2002 2003 Actual Display fo Header Bar Chart Fund 100000 Regular Opersting Fund Orgn 498 Finance Offise La Base Budget Fiscal Budget Activity ame Original Adjusted Original Adjusted Actusls ncumbered Available PD ANF SAF LARL SR VF TMM MMM 0 RES AB RAC Microsoft Internet Espl Current Tear Period 2z10000 13010 Diha Supphes 113 23 143 143 373 B1 Fi0001 1300 Reference Materials 710012 134300 Cher Supplies D 711000 1300 Photocopying Charges amp Supplies 0 0 0 11001 1300 Ponting Costs amp Supplies 0 iz n0 1300 Long Distance Charges 2 000 2000 2120021301 Postage Expense n oO i oO 713000 1300 Telephone Equiprmeent Rentals 0 3 000 3 000 J L30801 1300 Computer Lease Costs i lij 13002 1300 Pager Csll Phone Rental 716900
70. to wrong afc 123 4 Reallocate exp charged to wrong afc test realloc test again TEST 3 TEST4 738 38 Reallocate exp charged to wrong afc Reallocate exp charged to wrong afc TEST 3 TEST4 2 000 00 3 000 00 3 000 00 3 500 00 a a a a a a l 34 I4 4 gt M TDOS_2 asp FD TDOS amp NF 2 amp RF 21 amp R la Draw gt 5 AutoShapess N w OOB4ABR o 2 A zeg Ready IF d NM f Page 43 of 52 Introduction to FAST Budgeting 10 0 Back to the Main Menu After drilling down and changing views a number of times the user may wish to restart the session To get back to the Main Menu click on Click here if you would like to return to the menu located on the bottom left hand side of the report E ID Aor bode nt x arleban c LU FAST I FAS Tap im OS BFF DERF ZLERL RL Ya TM MMMM 0 SRE 9 A RP SPA Pr Microsoft Internet Explorer P 181 xl Fle Ede Wee Faber Tods Hep 7 ema QE A sen Groom Gee GB D i S Quo inks Carleton UNIVERSITY Current Yesr Period Feb 2003 nen FAST System Financia admansinatior Support Toor FORHB OS Dizplay 0 2002 2003 Actual 13 iudget J Chart Fund poe Regular Operating Fund T 488 Finance oifice Last Undated a Apr 26 2002 Base Budget Fiscal Budget Actiwit Acct Preg iss Original Adjusted Original Adjusted Actuals ncumbered Available 2 100060 1304 Diha Supp
71. tor FAST System Financial Administration Support Tool UNIVERSITY FORM DQ Document Query Search Field Search Criteria Type Actuals Required Source Income Statement Required Document Type Cheque s Required Fiscal Year 2004 IRequired Fiscal Period Range o1 o1 Required Fund Range Optional Orgn Range Optional Acct Range Optional Dollar Value Less Than or Equal to Optional Submit Clear Form Please type in your search criteria and click the submit button to do a search for related documents PLEASE NOTE The ORGN filter range will not be used when a Balance Sheet search is being done Return to Menu Doe 1B gp Intenet Fill in the Required criteria as indicated on the screen e Type Actual or Budget e Source Income Statement or Balance Sheet e Document Type Cheque Invoice Journal includes ICBs P cards any feed document from the Student Alumni or HR systems PO or Requisition e Fiscal Year 2004 would indicate the entire 2003 2004 year e Fiscal Period Range May is period 01 April is period 12 Fill in Optional fields to narrow the search e Fund Range The Fund codes that may have been charged on the document e Orgn Range Your Orgn code if you have multiple Orgns enter a from and to codes and the system will search within that range e Acct Range Search within a range or single account code such as 710000 supplies If you ente
72. ur Select and Click on Subtotals 711000 BE an A box is then displayed 3 Select the options required in the box Example M Replace current subtotals a At each pps Page break between groups mm i cct first column 25 vw Summary below data 26 b Use function 27 28 i Sum Remove All Cancel 59 c Add Subtotal to 30 i Amount 31 39 4 Click the OK Button 33 34 gt bl TDOS 2 asp FD TDOS amp NF 2 amp RF 21 amp R 4 mla _2 asp IET Draws y 5 AutoShapes N OOB 4G 9 4Z A S32 LQ Ready NUM E Page 42 of 52 Introduction to FAST Budgeting Following the options above would give a line break at every change in account with a grand total at the bottom B9 File Edit View Insert Format Tools Data Window Help Acrobat JM o r amp i jaa n e ale L E n Ww P cT ua LI 2o Es o o E nd e tv T cr a E e tu E P un a e o i ps tu ui B L E I ll e Q e hn Il wi 4 H E Requisition EARE Iz NNI A2 fn ae a EPIRI E ELT ee ERU RI G 1 Acct jAcctName Actv Locn Date L2 roo oweesupies 2002norst 0000047 3 zooo oWeesupies f f 2003025 iononist 4 70000 ottice supplies f 2003 2105 i0000 5 70000 fottice supplies f 20004423 yooooes B o office Supplies f f2009423 Jno0ntes Z moo fottice suppl
73. ver 5 000 non instructional 723102 Computer Equip over 5 000 non instructional 723103 Computer Software over 5 000 Budget Allocations BARs 726100 Unallocated Budgets 726101 Salary Savings Deficits only no other transactions 726102 Prior year budget carry forward For P T salary unless you require the detail just use 611200 The other salary codes you may see appearing in your accounts are from internal depts that charge out their salary costs as a normal course of their business most notably Physical Plant 620000 Document Numbering Transactions are numbered sequentially by the system but the lead character will tell you F afeed document from another system usually a cash receipt or Student or Alumni items J a journal document or internal chargeback ICB will show paper doc in the reference I an invoice paid FC feed from the copy card system FP feed from legacy payroll system future Banner HR feeds will be just with an F FT feed from the telephone system PC P card transactions Fund Numbers the initial numbers mean the following 187 Internally Restricted Research Fund 188 Internally Restricted Enterprise Fund 26 Special Purpose 3 Sponsored Research Restricted 8 Funds in Trust deposits with CU you may use only the one acct code given to you upon set up generally 2280000 if it s a deposit 121420 would be the other if the fund owes C
74. w to Carleton R Returning to Carleton T Transferred to Carleton Page 50 of 52 Introduction to FAST Budgeting Banner Term Definition V Visiting exchange or LOP C Continuing in Program X Old Records Subject Field Specified the Subject Code of the course Required Table A collection of logically related fields such as student s biographic information Term Field Specifies the effective term of the course 1 e Year 4 characters 2003 Session Winter 10 Summer 20 Fall 30 To Term Field Indicates the last term up to which the data being displayed was valid application forms Allows the user to tailor Banner to their needs by providing lists of allowable values for specific fields Wildcard 9o The character that is used in search criteria to represent other unknown characters e g J will search for everything ending in J Displays an information area Page 51 of 52 Introduction to FAST Budgeting APPENDIX C MAIN ACCOUNT CODES SUMMARY INFORMATION Revenues all codes start with 5 Sundry income 533013 Salary recovery 540000 Salary Benefits all codes start with 6 P T salary 611200 Expenses all codes start with 7 Office supplies 710000 Travel 719100 simplify use only a few account codes within each major category of expense Equipment Purchases 723000 any equip computer furniture under 5 000 723100 Equipment Furniture o

SIS User Guide - Carleton University

Contents

Download Pdf Manuals

Related Search

Related Contents