Home
FAST User Manual - Carleton University
Contents
1. Fiscal Budget Grigimal Adjusted 14 417 473 14 417 373 107 587 107 587 24 250 24 250 975 604 975 602 181 253 121 869 1 092 992 1 038 992 4 150 4 150 10 586 10 526 12 980 12 920 0 17 238 17 23B 57 920 67 920 249 980 249 980 150 960 150 960 75 760 75 960 29 980 29 950 17 365 525 17 365 520 Actuals 13 895 076 135 225 24 200 O75 Say 181 989 1 040 232 4 150 10 626 12 000 d O25 17 336 63 000 250 000 151 000 76 000 20 000 16 874 855 ncumbered Z073 046 0 0 0 0 0 0 0 0 0 d d 203 046 internet Available Presa 27 637 50 3 363 L20 1 240 D 140 20 1 025 100 B 20 A al 20 693 716 11 The Actual and Budget Tab 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 Budget Tab Screen Used During Budget Development Ty httq orioke ntcarleton ca F ASTI FAST asp A SARE ARF AARC VD ADA EDT BENE a Microsoft Ei Ede yew Favorites Toots Helo EE ndi seh Staater freda 04 28 SE A G re BOTS Pek ED DE POSS BeBe E EE E EE
2. Endowments 0 D 0 Scholar Endowments 0 D 0 63 Bursare Endowments 0 0 0 OETOE Bursary Endowments 0 ES UG amp Prize Endor 0 TOTAL lt 4 72 S41 207 578 6G 415 Click here if you would like t2 return to the Menu Click here to download to Excel for printing Done iB internet 2003 Millennium Computer Systems Ltd Carleton University 17 The 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 drop down selection box The drop down box 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 filter on that selected FOAPAL element Please note that many administrators will only have access to one Fund the Operating Fund As such the view displayed will default to Organization summaries Ehe Ede yew Favortes Tools Hep pe 1 zech peus 3 00 29 Judi SI TEM sM D DE CT De CHE Dee KE Lt a EH Bb RE CLD AR 12 T Carleton uMIVERSIT https nriole nt carietan ca FASTU FAST asp A AE RAHE NEAL TREF AAR EC YED EDA BIT RENE REZREERIM Micr o 1 FAST System ss Support FOR
3. TOTAL af 72 541 207 8576 SB 418 Click bere if you would like to return to the Menu Click here to download to Excel for printing In Fast the reporting period can be selected using a drop down box The box has all available closed and open periods The dates are not dependent or restricted on Fiscal or Calendar Year ends Therefore data from historical and current year ends can be viewed and compared 2003 Millennium Computer Systems Ltd Carleton University Report Selection Fast provides many views of the same data The standard or default view is the Current Year view That view displays year to date data for Base Budget Fiscal Budget Actual and Encumbrances Below is a comparative view of our 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 changed using the Report Selection drop down box Zorte ntc arlotan ca FAST OS FAST asp RF ZEFYIFPI 20033 re BF SAAB APOE hem nM m TM ei sl De ECK gou Fokes Tools Hep EJ Beck s 13 1 od seach Beda 4 m ch md d DANN 2p ee hr Dt SUE UM DTD TS D CG B3 pon Links i J OT FAST Syste
4. f z003 23 J0o7 Jeer LL S sg 10 710000 Office Supplies 200310423 00008 Jeer ___ S S S 11 710000 rs T w 12 710000 Total RES E es 13 70001 Reference Materias f Jaamczlummae exp chargedtowrongate J fJ a 14 710001 ReferenceMateials Je Jzowowzs unonnet JReslocsteempehagedtowengal J LL 15 70001 Reference Materiais JJ Jaguazlumae rests 16 710001 Reference Materiais JJ Jaguazlumae TEST4 17 710001 Reference Materiais JJ J gazlumae rests So Bere j j f m 19 Photocopying Charges amp Supplies 2003040300065 Jsreslo LL a 20 ooo Photocopying Charges Supplies JagaczlLumae testagsin Elmer 2 l j 22 men PrmingCosskSuples fzoxwowzs snonomo JGrpicsPimimgCoss J wl 23 meros LL 5 5 wm 24 Long Distance Charges Je Jaen Luna Testing parking transactions J LL zooo 25 712000 Long Distance Charges 20030901 Luna restreferencenumber J ws 26 2000 IT J 0 27 Telephone Equipment Rentals 200302701 uoooom Testing f sooj po S p p Office Supplies LL 200304923 Jo000163 28 713000 Total PT seen 29 719700 Accountable Travel Adv
5. GR EH Eh S FAST Eens Support foo D UNIVERSITY Current Year sl Period Apr 2003 Gato Fund FORM SUMS Display 0 FAS Actual EO Budget H Chart Last Updated Spr 26 2003 Bast Budget o A O ___ Code Hama Original Adjusted Original djustad Actuals Encumbersd available 10 Reguler Operating Fund 14957 395 13 112 803 ld d17 4173 14 417 473 13 355 076 203 046 12 ancillary Funds 107 677 107 797 107 587 107 557 145 225 0 internally Restricted Funds 4 250 24 250 24 250 24 250 24 300 0 50 20 uc Scholars 375 874 875 223 975 604 975 602 97S 347 0 3 303 zl Grad Scholars 182 049 182 228 161 5693 151 665 181 989 0 12 Ze LG Burzare 1 033 232 1 038 552 1 032 987 1 058 992 1 040 232 0 ol 240 zJ Grad Bursary 4 150 4 150 4 150 4 150 4 250 0 0 UG Prints 10 646 10 726 10 586 10 586 10 526 0 0 zh Grad Preg 13 010 13 050 12 980 12 9 0 13 000 Di 2D 30 Sopnpnenred Dese nrch A 0 D sf O23 0 i023 ell Endowment Investment Holdings 1 388 17 588 17 236 17 258 17 238 0 100 Si LG Scholar Endowment 65 040 amp B 20 57 920 67 920 fe 000 0 B0 ai Grad Scholar Endosarnents 250 010 250 05 249 980 249 160 250 000 0 20 amp 3 Bursary Ende rmnents 151 020 151 100 150 960 150 960 151 000 0 Gi Bucdary Eodoertp etptz 76 020 76 100 75 950 75 960 76 000 0 gll Wis Award amp Prize En
6. RP Micros Internet Esploeer p PTS 10000 1300 Ditze Suppbas 113 D 143 143 373 0 516 7i0001 1300 Reference Mater ale 0 0 H 0 0 n 210012 1300 Other Supplies D D 0 0 D 0 7110200 1300U Photocopying Charges amp Supplies 0 0 0 0 71191 1300 Ponting Coss amp Supplies 0 12000 13010 Lora Distances Charges 0 0 0 0 2 000 0 2 000 212012 1300 Postage Expense 0 D D a 0 D 0 71 3600 1300 Telephone Equipment Rentals 0 0 3 non 3 000 13001 11400 Computer Lease Costs H 0 0 0 0 0 0 i13002 1300 Phone Rental 0 0 0 0 0 0 0 7169500 1300 Stal Ciesetapnment Cose 0 0 0 0 0 0 0 719100 1300 Travel General 0 0 0 719700 1300 Accountable Travel Aeapcez 3 510 3 550 3 420 3 480 3 500 D 20 Tz3000 1300U Equipment Purchases 5 000 0 0 0 0 SubTotal 3 337 3 477 3 337 3 337 8 873 5536 Total Revenue Less Expenditures 3707 KSE K 3 337 3 337 B 873 0 59 956 Click here if you like to return ta the manu Click here to download to Excel ei EMEN TL Clicking here moves you to the screen below Z Main Menu Microsoft Internet Explorer provided by EduNET le xl File Edit Favorites Tools d Back gt d Qsearch 3Favortes B 3 x Address http foriole nt carleton ca FASTO1 Prompts asp FD2MENU amp SDL N amp FR IV amp RN 481 138BV 48BN IE8 52 Y Links Car leton FAST Sy
7. Financial Administration Support Tool Millennium FAST UNIVERSITY User M anual FINANCIAL ADMINISTRATION SUPPORT TOOL User Manual Millennium Computer Systems Ltd 6648 Amwell Drive Brentwood Bay BC Canada V8M 1A3 Phone 250 889 5919 Fax 250 652 4741 www mcsl com Carleton University 1125 Colonel By Drive Ottawa Ontario Canada K1S 5B6 Phone 613 520 2600 E mail Banner _Finance carleton ca www carleton ca 2003 Millennium Computer Systems Ltd Carleton University Table of Contents Table OF e EE 3 EE 4 Product TEE 4 10 4 EE 4 The Financial Administration Support 5 e e EE 5 Maim dee 6 selecting FOAPAL Element iere tti b e 7 R port Period Selection user e ri ar pente 8 Report elec HO 9 EE a ER 10 Navigation Screen eene 11 The Actualanmd Budect Tab eda oc ep p ERE MTS 12 inp n iS 13 1 Bat EE 14 SEIS CHOI ood 15 Sne rage e E 16 The GOTO Drop Down Menu e 18 Doswnloadui 10 EX6el EE 19 Diline Down On vet heads RV de bn 20 Viewing Transaction Level detail over multiple Accounts 21 Adding Subtotals in Excel EEN 22 Getting back
8. 2003402405 00141 TO EC D ET 1237 001 517 50 zin Oiss Supplier 20 Laus ema 2111 220000 Ceca Supplies 2002 40 33 Long TE 123 00 enn Accountable Trowel Advances 2002 1 2021 J0000005 Sullivan travel advance 3 500 00 7 12000 Lang Dirtance Charger 2 36 00114 Keen paking f 2 006 Tel i Testi T paso sone mega tansaetan 8 2 000 00 Raw B BT3 30 Show 200000 Excel Click op any Column heading to Sort by that column Click i QEecontd time to reverse the sort You can change the lines per page by changing the number i the r cerds per page box and Fatting enter Note the records you have page the longer it will take ta display Show Record Once all records are displayed download the detail into an Excel spreadsheet using the process described above Once the Excel spreadsheet has been re executed using Excel the first line of the downloaded data should be deleted as it is just the descriptor of what was downloaded You should then select the entire spreadsheet by clicking on the upper left hand corner cell that resides at the intersection of the Excel Columns and Rows Then follow the steps below to add subtotals 2003 Millennium Computer Systems Ltd Carleton University 21 Adding Subtotals in Exce
9. NM II Following the options above would give a line break at a every change in account with a grand total at the bottom EI Microsoft Excel http oriole nt carleton ca FASTO1 TDOS 2 asp FD TDOS amp NF 2 amp RF 21 amp RL amp C Y amp F TMMMMM amp BES amp A amp P RACSERLSREYT amp 81 x File Edit Yiew Insert Format Tools Data Window Help Acrobat WIES alaslaglelg 2 verdana 75 B z im B http fforiole nt carleton ca FASTO1 TDOS_2 asp FD TDOS amp NF z 2 Y z 710000 1 2 3 B CEU F G H J E allge rz 1 AcctName Actv Locn Document Description Requisition Invoice Cheque Amount 2 n lomcesupies _ 2002norat uooooosr testwithts ooo dt 3 710000 Office Supplies luan Leader ProcurementServicesinc 5 710000 Office Supplies f Jeer Tea l 5 710000 Office Supplies 2003923 J0000063 Realocateemcharedto wong fT l B 710000 Office Supplies 200 00006 expchargedtowrongae ____ J 7_ 710000 Office Supplies f 2 00006 ooo o So B 710000 Office Supplies 20030423 soooos Jet again Ls 9 710000 Office Supplies
10. SUMS Display 0 8002 2003 Actual 3003300 Budgel Chart bt Last Updated Spe 28 2003 Eh Budget Fiscal Budget E 2 Code Name mal Adjusted Original Adjusted Actuals ncumbered Available 10 Reguler Operating Fund 14 39 14 413 903 14 417 473 14417 473 13 895 076 203 045 Iz Ancillar Opersting Funds 107 677 107 797 107 587 107 115 225 d 27 627 Hr Internally Restricted Funds 24 250 24 250 24 250 24 250 24 300 0 50 20 LG Scholars 375 274 76 235 975 604 975 608 975 947 0 3 343 zl Grad Scholars 162 049 182 22 161 369 151 869 181 989 0 120 Ze UG Burzare 1 039 232 1 038 552 1 235 992 1 028 992 1 040 232 0 ol 280 3 Grad Bursary 4 150 4 150 4 250 4 120 4 250 0 UNG Primes 10 556 10 726 10 568 10 5525 10 626 0 zn zh Grad Prazwg 13 010 13 050 12 980 12 960 13 000 0 20 30 Sg0npartd Pasaarch D 0 D 0 1 023 0 ig 60 Investment Holdings 17 388 17 556 17 238 17 238 17 338 d Ano 61 LUG Scholar 63 040 68 200 67 920 47 920 62 000 d B Grad Scholar Endowrnents 290 010 250 050 249 780 249 950 290 000 d 20 63 Bursary 151 020 151 100 150 960 150 960 151 000 0 OSTOF Endawemants 78 020 76 100 75 360 75 865 76 000 d 65 WG Award amp Pring Endow 90 010 30 050 29 980 29 950 20000 d 20 Total 1 a7 2d 17 365 038 17 355 529 17 365 578 15 874 559 203 E 593 716 Click
11. A 1 C arleton FAST System Financial Adminstrator Support Toot UMIVERSITY FORI 2002 2003 O 2003 2004 Budget 1 Chart pd Found 100000 rgn 570 Acct 712002 Last Updated Apr 26 2003 code Name Base Alloc Base Bud Variance Fipcal MewFiscalBud 12002 1800 Postage Expenzel 0 0 D 0 SubTotal Direct Expenditures 0 0 0 0 Total Revenues Less Expenditures 0 0 0 Base Allocation 7 Fiscal Allocation Chek here if sou wid like t return t the menu Chick here ba dewnlaad to Excal ipe memet 2003 Millennium Computer Systems Ltd Carleton University 12 The Message Bar From this Main Navigation screen a user can drill into the data by clicking on numbers that are highlighted in a blue font As the user drills down into the data the message bar indicates the level of data being viewed The message bar displays the Fund Org Account and Program level E http joriak nte arbeton ca FASTI FAGT 09 2 ERL SV TMM Me SBE EIS SBP SPA Ee Mined Internet Explorer x Fie gou Favortes Tools Help o gt E ab Aesch ej Favortes dh cb m G re AE E ET E En E E un Links 7 C arleton FAST System Financia Adusi rakon Support Tool UMIWERSIT YT OS Display 0 F 26 2002
12. BD S20100 Inbernatianal Umfergrad Tukan 400 010 400 050 399 280 399 980 400 000 0 20 S20900 US Exchange Fas Charges D 0 D 0 D 0 0 5021000 Domest Grad Tuiran Kalb 540 527 540 557 540 557 0 597 0 521400 Grad Exchanges Fes Charges D 0 0 0 0 0 0 5201901 Graduate Exchange Fes D 0 D 0 D 0 D S22000 Summer School Tuition Fees 31 435 41 050 41 370 41 370 53 227 11 659 S23000 BS Credit Courses Tuition Fess 0 0 D D D S259000 LGracuate Exonsnge Pees D 0 D 0 D 0 D S2S001 mnibus fee 161 595 161 675 101 515 151 525 101 575 d a0 525002 Deferred Paexmient Fee 50 a 20 20 0 20 525003 Supplement Fee a5 Th 5 5 25 0 20 S2500 Returned Cheque Processing Fee 0 d D 525005 Small Loans Service Fee 12 52 18 18 z n 20 5250065 Late Registration Fee 0 0 xj i Done ap 2003 Millennium Computer Systems Ltd Carleton University 18 Downloading to Excel The FAST reports are very flexible and provide many of the data views required however there are times when downloading data to a spreadsheet 15 required Spreadsheets such as Microsoft Excel provide added functionality such as pivot tables that allows the user to manipulate data in countless ways To download a particular view to Excel simple click on the Click here in the Click here to download to Excel statement located at the bottom of the report This will execute Excel and download your data to the Excel spreadsheet within the Internet Browse
13. Base Budget Fiscal Budget Activity rigipal Adjusted Original adjusted Actuals Encumbersd 210000 1300 9 73 143 143 379 516 2100001 3010 0 0 0 n U n 210012 1300 D A 0 211000 1300 0 0 A D 211001 1300 0 0 0 0 0 0 212000 1300 0 0 0 2 000 0 2 000 12002 1300 D D A D 713000 134300 0 0 3 000 3 000 12001 1100 Computer Lease 0 0 0 213008 1300 Pages Csll Phone Ren 0 0 0 0 0 0 215900 1300 Staff Devgioprment Cost 0 0 0 n 0 n 719100 1300 EINE Travel Gener 0 0 0 719700 1300 Accountable Travel advances 50 3 480 3 500 n z 7z3D000 130 Equipement Purchases 5 000 0 0 0 SubTotal 3 337 8 873 5 536 Total Revenues Less Expenditures 3 337 8 873 0 5 536 Click bere if you woud like to return to the menu The Message bar above indicates we are viewing Chart M Fund 100000 Org 498 and the Account and Program Segments are on in the left column 2003 Millennium Computer Systems Ltd Carleton University 13 The Header Bar Acct Prog 210000 1300 210091 1300 710012 1300 711000 1300 711001 1300 212000 1300 12012 1300 713000 1300 13001 1900 213002 1300 215900 1300 719100 1300 719700 1300 723000 1300 Click here if you MM E 7 Ele Ek ew Fater Inde pen SO E sen Gromer Gren A Ze DRE S Address bon GSlEASTDAIEOST epi DO 2 s BP
14. Ltd Carleton University 24
15. Per Page Transaction Summ wy Microsoft Internet Explorer provided by e gd Mi Tods Holo N fayrevornes Reda 3 Dh Sp ot 23 sep Ga ri eton FAST System Financial Support Too UNIVERSIT Y FORM TOOS Fund 100000 Orgn 198 Last UpdstedQApr 26 2005 Records per page fia cct ame Loon Date Document Description Requisition ID Invoice Cheque Amount Sepplies seg nona Temm CENE ue 1247 00 517 50 1 L 10000 Loes Supplier e 20030205 SST 1217 001 2111 rino Oea Supplies 200a Lena TS 123 00 mimon Accountable Trowel Advances Janoanaed 0000005 tree advance 3 500 00 13000 Long itanes Charger 2036 00114 paking niae f 2 006 Telephone Equipment ona Testirg paking t anzacton 3 0a nn Fanali liti Raw 30 Show Records is 100000 490 Mera S Buel Click op any Column heading to Sort by that calumn Click it second time to reverse the sort You can change the lines per page by changing the number i the ecard p
16. UG Scholer Endowments Ave 62 Grad Scholar Endowments Active Hi 63 Bursary Endowments ul OSTOF Burzary Endowments M 65 UG Award amp Prize Activa G Grad Award Endow Active ul Special Propect Endow M 68 Unrestricted Endow Principal Acta M 70 Restricted Hon Research Grants and Active hi EI Endow Trusts chve M 81 Funds Held in Trust Acta M 20 Provincial Capital Grants Active hi ai Finenced Plant Fund M az Federal Capital Grants Actva M 93 nternally Funded Plant Funds Active HI 94 Donation Funded Construction Active EI General Plant Fund Bank Fund Active H test Active M 162564 WP Research Startup grant Actwve E Dame OD o im trite EF The screen shot above is a drilled down on Fund codes Each available fund has a drill down button 7 Every element with a drill down button will continue drilling down to the next level of detail until the bottom or entry level code of the element has been selected This method of selecting a code is available on all the FOAPAL elements If you have not selected a code on the main menu screen drilling down is still possible from the Navigation Screen 2003 Millennium Computer Systems Ltd Carleton University Report Period Selection From the main menu the desired reporting period can be selected Clicking on the drop down box beside will display the closed and open p
17. ta Excel far peinbng internet The Date Range report is used to view data that is summarized or totaled from transactions between two points in time To view the reports by date range use the Report Selection box to 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 Actual Commitments and Total Activity data between the specified dates is displayed Dates that cross Fiscal or Calendar year ends can be selected 2003 Millennium Computer Systems Ltd Carleton University 16 Date Range Report Report Selection From date selection date selection Sy http oriole ntucariete cay FASTIN FAST asp EIE LM IE SIT ier A JMIVERSITT SUMS Date Range From Feb 2003 Oper el To Mar 2003 pami Goto Fund el n gt Display 0 FAST Syston Finacial amp upport Too Chart Last Updated Ape 26 2003 Code Title dert Commitments Total uec 10 Regular Operstng Fund 518 705 207 578 725 502 12 Ancillary Operating Funds a4 651 0 44 551 L Internally Funds 50 0 50 20 Eeh lars 323 383 zi Grad Scholars 0 D 0 2 Us Bursary 1 080 D 1 080 23 Grad Bursary 0 0 0 24 UG Prizes 0 25 Grad Prizes 0 3 Restncted Sponsored Research 0 H 0 E Endawmant meai Raldings 0 0 0 i LS
18. to the Main men 29 begleet 24 Error 24 Feedback Support Contact Informaton 24 2003 Millennium Computer Systems Ltd Carleton University Introduction Product Overview The Financial Administration Support Tool FAST is a web based reporting tool that allows financial information to be presented in an easy to read understand 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 and produced by Banner Banner is an integrated software solution written by SCT www sct com for student information advancement human resources financial aid faculty and advisors and finances FAST focuses on reporting on data from the finance module of Banner Key Features Web Based Secure Easy to access Cross Platform No client software to install Drill down to transaction level detail Download to excel Multiple Budget Comparative and Date Range views of Data Filter on any combination of FOAPAL elements About This Manual This manual is 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 Technical users and administrators should look at the Technical Overview docum
19. 300 Equipment Purchases 5 000 0 0 0 SubTotal Sart 3 37 3 8937 8 873 5 535 Total Revenues Legs Expenditures 4 497 SE E 3 357 3 387 B 873 5 53b Click here if you would liks to return ta tha manu Click here ta download to Excel ep Period Selection http Zorte nt carleton cayFASTIMA FAS LaspeRP 3kF P TIERE I SIMI Hi jej gk yew Fawkes Tods Hep 8 EJ ck QR S 2 WAsesch went 9 28 15 Gre OLASZ FAN AR rmi La BczwvarFzpEDZHIWSEEHCmNEOZBLIEMEMIDEDETEGRIEOFMEBOHCINDCO TAFEL Lancs liks 7 Carleton UNIVERSITY FORM SUMS Date Range From Feb 2003 el To Mar 2005 Open Got Fund I ml Display 0 FAST Syston Financia Support Tow Chart Last Updated amp pr 26 2003 Code Tale commitments Total activity Regular Operating Fund 518 705 207 878 725 502 12 4nollary Operating Funds 24 651 44 554 18 Internally Restricted Funds 50 D 50 20 Echolars 383 D 383 1 Grad Scholars 0 D 0 23 UAS Bursary 1 080 D 1 000 23 Gred Bursery 0 D 24 Prizes 0 D D 25 Grad Prizes 0 D E Restricted Sponsored Regearch 0 D E nveastement Baldina D D 0 Lu Scholar Endowments 0 0 0 Gred Scholar Endowments 0 D 63 Bursary Endowments 0 0 Bursary Endowments 0 ES UAG Asgard amp Prize Endo
20. 5900 1300 Statt D v ioprment Cozte 0 0 0 0 0 0 0 719100 1300 Conference Travel General 0 o 0 n n RK 1300 Accountable Travel G re 3 510 3 55n 3 480 3 500 0 z 7z3000 130n0 Equipement Purchases 5 000 0 0 0 0 0 SubTotal 3 327 3 477 3 37 3 337 8 873 59 536 Total Revenues Less Expenditures 3 797 A7 3 337 Es fekt 8 073 0 5 536 Click here if you would like to return to the menu Click here to dewnrioad to Excel CH internet 77 Download to Excel Click Once your data has been downloaded you should save this file in a directory and re D j execute the file using Excel to fully utilize Excel s features 2003 Millennium Computer Systems Ltd Carleton University 19 Drilling Down on data There are many layers to Banner data starting from a high level Fund overview down to a specific transaction To drill down from a high level clicking on any of the numbers in a blue font will display that data at the next level down until you get down to the final transaction level At the transaction level clicking on the Header Message Bar will re sort the data based on the column selected The data can be sorted in either ascending or descending order by re clicking on the column If there are a large number of transactions displayed the desired number of transactions displayed per page can be set by the user Transaction level view Clicking on any Column re sorts data Records
21. UA C AF NAAA LS TIMERE YZ MS DEST 880 T SCH Carleton UNIVERSITY Current Year Period Feb 2003 Open 2002720105 Achual Suppbas Reference Materials Other Supplies Photocopying Charges amp Supplies Ponting Costs amp Supplies Lora Oistanes Charges Postage Expense Telephone Equipement Rentals Computer Lease Costs phone Staff Development Coss Canferemcee Travel General Costs Accountable Travel Advances Equipment Purchases 5 000 SubTotesl Revenues Leds Expenditures epad likes bo return to the menu Header Bar ve Chart pn Fund 100000 Regular Opersting Fund Dron 498 Finance Offre Last dates Apr 26 2003 Bud Priginal LL eel 113 23 d 0 0 0 0 0 0 0 0 0 0 0 0 0 9 0 3 510 3 550 0 0 3 337 3 427 3 397 3 477 Click here to dewrilasd to Excal e et Bu Original KE c gt D EN c C LE E S 3 420 3 337 3 397 E http Sorbo nbc are bon cay FASTI FAST asp FD n BRE 21 bt TMM 0 BE SEA BoP BOAT Internet Exploner p Poo Links FAST System Francia Support Too died Actuals i A Wa c OO Ok OO OO OD G6 3 480 3 337 ESSET 3 500 H 8 873 B 073 Act Encumbersd ooo coc Oo De COD OO ODC OH OS Display 0 Avsils ble 516 5 5 36 9 956 As
22. ances LJ 200200001 40000095 T Sulvanwaveladvane ema 30 z19700 rora ITT 31 po rete n n n ra n Lr nr n ra sss 32 Grand Total 18 236 78 33 34 4 MIN TDOS 2 asp FD TDOS amp NF 2 amp RF 21 amp R 14 Draw s AutoShapes N Ne 40 9 2 Ready NUM 2003 Millennium Computer Systems Ltd Carleton University 22 Getting back to the Main menu After drilling down and changing views number times the user may wish to restart the session To get back to the Main Menu click the Click here in the Click here if you would like to return to the menu statement location on the bottom left side of the report you are viewing e emet E ATE Bed gt Q 8 A seh rores Gets A A Cb 2 18 Address ten cal FASTIHIJFAST Sept 206 E E Nr RM Ont KE TEF Si Carleton FAST System Financia kon Support UNIVERSITY OS 5 i D Fi NM T Sale Mme 2002 2003 Actual i pat i Chart bt Fund 100000 Regular Opersting Fund 458 Finance Che Last Updated Apr 26 2003 i Base Budget Fiscal Budget Actieity Acct Prog Original Adjuzted original Adjusted Actuals Encumbersd Available E http arde bon c ay FASTI FAST bk 08 82 2 YRF
23. dow 30 010 30 050 29 280 29 950 90 000 0 20 Total 17 347 324 17 365 038 17 365 525 17 365 528 15 874 853 203 046 693 716 Check hare if pou would like t return t the menu Chick here bo downloaded to Ezcal ET Done This screen has many components that provide the functionality to view FOAPAL elements in many ways The components that will be explored in this document are Message toolbar Header bar Period Selection Report Selection Download to Excel Drill down 2003 Millennium Computer Systems Ltd The Actual and Budget Tabs Element Selection GoTo Moving back to the Main Menu Carleton University 10 Navigation Screen Components 200272005 Actual Chart bi Last Updated Spr 26 2003 Code iu Grad Bursary LUG Prizes Grad Pres Rastricted sponsored Research Blue fant Mare detail available Grad Scholar Endosments Bursary Endoarnents Bursarg LS Award amp Prize Endow Total Chek hare d yay woul like t6 return t menu 2003 Millennium Computer Systems Ltd Base Budget rigimal Adjusted 14 497 248 14 413 903 107 277 107 727 24 250 24 250 375 274 875 224 182 049 152 259 1 079 292 1 038 552 4 150 4 150 10 546 10 726 13 010 13 050 n 17 588 17 55B 65 040 68 200 250 010 250 050 151 000 151 100 76 020 Po 100 30 010 30 050 17 347 324 17 355 038 Chick here to dosniaad ro Excal Carleton University
24. ent 2003 Millennium Computer Systems Ltd Carleton University The Financial Administration Support Tool This section of the User Manual outlines some of the core functionality and navigational structure of FAST Login To login into FAST open your browser and go to http www carleton ca fast The first screen you will see when accessing FAST is the Login Screen This is where you enter your Banner User ID and password Your user ID is your first name concatenated with your last name firsthamelastname Your password can only be changed in Banner using the GUAPSWD screen Please change your password from the default password u pick it if you have not already done so If your would like more information on how to change your password and access banner please refer to Document 3 Accessing Banner amp Changing Your Password in the General Ledger and FAST Reporting Training Documents http www carleton ca banner finance finance htm 4 FAST Login Microsoft Internet Explorer provided by EduNET 4 E x File Edit wiew Favorites Tools Help EI amp a QQsearch Favorites 04 he 28 S Address http oriole nt carleton ca FASTO1 Login asp FD LOGIN amp FR LC amp J5 Y amp BN Microsoft s20Internet 20E xplorer amp BV 48O05 Win328RN 56227 Go uns 3 lt Ce leton FAST System Financial Administration Support Too UNIVERSITY Millennium Please
25. er page and Putting enter Note the records you have per page the longer it will take t display ET Internet 2003 Millennium Computer Systems Ltd Carleton University 20 Viewing Transaction Level detail over multiple Accounts To view all transactions that have been charged to a particular Fund Org combination start by viewing the summary screen as shown on page 19 in the Downloading to Excel section You can select the entire year to date or a particular month by changing the Period selection Clicking on the Actuals will display all transactions that have been charged to the Accounts for the period selected Initially it will display 10 records per page but all records can be displayed by clicking on the Show All Records E Transaction Summary Paged Microsoft Internet Explorer peovided by T 3 E Edt yew Fawkes Tools Help doped 1 ndo Q sewch wote Greda he Sh Address hito oriole nt carleton calFas THITOOS_2 asp sl goo Ca rleton FAST System Financial Adrmeistratior Support Too UNIVERSITY FORM Tors Chart Fund 100000 Dron 198 Last Updeted Apr 25 2003 Records per page 1n AO Loon Date Document Dezscrpton Requisition Is Invoices Cheque Amount V Coen Supplies
26. eriods in Banner Report Period Selection Drop down box Sl Main Menu Microsoft Internet Explorer provided by EduMET _ fle eu F nster Tods m Ei k e A A A eh dyede 0 ra b Eid ee Address beto forte nt carleton calPo5 TOM Prompts ssp FD ENUBSDLS N3ERs RII22117288 EDS zv Do Links 2 Ss rleton FAST System Financial Adrivwetraton Rapport Too UNIVERSITY FORM Please input vol dasred report parameters You can click to lookup a field Chart fel Fund e Dron Acct Frog aF Lorn Period 2003 el Desired Report VE 2 EC e Feb 2003 an 2003 Chased Oec 2002 Closed 2002 Clozed et 2002 Closed Sep 2002 Closed 2002 Closed Jul 2002 Closed 2002 Closed erg Steet The reporting period can also be selected from the Navigation Screen 2003 Millennium Computer Systems Ltd Carleton University 8 Report Selection Using the Drop down box for Desired Report users can select between Balance Sheet accounts and Operating Statement Accounts Most Administrators will be interested in the Operating Statement which contains Expense and Revenue Accounts The Operating Statement is the default view Desired Report Selection Drop Down Box Se Main Menu Microsoft Internet Explorer provide ly EduMET E _ xj view Fawk
27. es Help EI Piek oe Qi bp dpsenh Ggneune uj Address Ficto lforiole nt cariecon caJFASTO4 Prompts ssp FD MENUBSDLSN3ER TURRIM 1172889 AE TERIS iN zl coo P Ca rl cton FAST System Financial Administration Support Too UNIVERSITY FORM MENU Please input your eared repart parameters You can click on tfi to lookup a field Chart 1 Fund Dron 7 Acct Prog e Actv Loin x Period AMOI Open Desired Repart Stetezsenk e rating 1 Led Ens el Balanda Sheet 2003 Millennium Computer Systems Ltd Carleton University 9 Navigation Clicking the ENTER button on the Main Menu screen without entering any parameters will bring up an overview of all top level funds for period specified on the main menu The user can only view the Funds they have been granted view access to in Banner most likely just the Operating Fund or a few Research Funds Access is controlled by the profile in Banner is maintained by the Finance Office 21815 Le BR Las 2 EE ESE ah an beanie Pear Links 2 J http Soriode ntacarieton cay FAST OM FAST asp A RAL ARC NEAL TREE AARC V 0A REN SEF FEM Micrasaft Inbernet EXplorer Ed gen Tods Helo ge ep 2 seh A zx 23 123 ried DOE DE CT Ee GT EXOHC GET D LU ent
28. here if sou woud like to return t th miang Click here bo dowrlgad to Ezcal ET bone Hi 73 View with Account element selected Edt wew Fawkes Tools Help E Bees SI DEER Froe MAM GAB RP Dt S LVESENE HIC RECH BET INE EFT TRAGE m ee CC pun Links dl Carleton umiwERSITTY Chart pn Last Updated amp pr 2 2003 Currant ear Period 2003 Open Gato FAST Syston Financia Support Tow FoRHB SUPE Display 0 Buse Budget Fiscal Budget o Achvty Code Harne Original Adjusted Original Adjusted Actuals ncumbered Available S10000 Operating Installment Grants 8 602 160 8 692 200 8502 130 0 692 Lan 8 602 150 d 26 510102 Ont Grad Scholar im Sci amp Tech 0 0 d 0 510103 Campus Safety Grant D 0 D 0 40 650 D 0 250 sl lo Operating Grant 200 010 200 050 295 980 299 920 300 000 0 20 510108 Excellence Grant Research 0 0 0 D 5101190 Performance Funding 225 010 225 050 224 980 224 950 225 000 0 20 510200 Enralment Accessibiles Grant 300 010 300 050 299 980 295 950 200 000 0 20 510201 Aim for the Top Grant D 0 D 0 D 0 B Sin202 Ontario Graduate Grant D 0 D 0 D 0 D 510203 Bursary D H D 0 D 0 D 1 amp Ontario Wars Bursary D 0 D 0 D 0 D S20000 Domestig Undergrad Tuikigm 1 795 957 1 729 117 1 798 537 1 798 837 1 798 917 0
29. ick on the enter Sea button at this point you will open the Navigation Screen displaying a top level overview of funds for the current period 2003 Millennium Computer Systems Ltd Carleton University 6 Selecting a FOAPAL Element To select on a particular FOAPAL element you can type in the FOAPAL segment number desired in the text box beside the FOAPAL element description or you could use the drill down button 7 Clicking on the Drill down button will open another screen that will let you select the element you wish 5 Microsoft Internet Explorer provided by EduNET ell s ci Aeh raes 8 zk 58 Plaase click on the dezirad Fund code i5 shown vau may click on it ta find Fund cades that report up ta this ane Chart Fund Title Status hi 10 Regular Operating Fund Active M iz Operating Funds M 14 Plant Unrestricted Active 15 Vacation Pay Unrestricted amp ctve M 16 Emp Future Benetite Uneestr fchye 15 nternally Re stricted Funds Actiya 20 UG Scholars Active H 21 Grad Scholars Acbve WG Bursary Aphra Grad Bursary Active HI 24 Prizes M 25 Grad Prizes Ariya M 26 Special Purpose Disburse Active d 28 Development Campaign Molding Funds Active 30 Reslncted Sponsored Research WM 40 Parker Loan Fund active hi Endowment Investment Moldings Active 61
30. l E m Im EL TT Iz Im zm l L ae d 2 d 3 I A i 5 Du CL x m ra ICT T La e E 710000 1 Acct AcctName AN 2 roon orice swpies 10000 Supplies 0000 Office Supplies 0000 Office Supplies 10000 Office Supplies 7100000 Office Supplies Steps to Add Sub 1 Click on the DATA menu 2 Select and Click on Subtotals a Function Box is then displayed 3 Select the options required in the Function box Example a At each change in 1 Acct b Use function Sum Remove Al OK Cancel Add Subtotal to 1 Amount 4 Click the OK Button Id 4 M X TDOS 2 asp FD TDOS amp NF 7 amp RF 71 amp R Draw s 5 AutoShapes w ICH Subtotals Validabion SSS EN SSS ass ion Requisition PO Invoice Cheque Amount Eoo LP LP o l Subtotal L Get Data k Groupeand Outline BE eup charged to wrong arc each change in Een acc J Use Function Sum w ranged bo wrong alc harged t wrong alc Add subtotal to Invoice ransaction ix vw Replace current subtotals ransaction amp tris Page break between groups advance w Summary below data bl C pu P Ready II
31. m Francia Advwystreadianr Support Too NIvVERSITI SUMS Comparstive si Period sr 2Z003 Open Goto Fund Display m E Chart Last Updated Apr 26 2003 20105 2003 2003 2003 20012 2002 Mar 20102 2002 Code Tle Fiscal TD C omami Budget Commit Budget Budget Actual ments Balance Budget Actual ments Balante 10 Regular Operstng Fund 66 051 565 13 921 788 207 078 5413r da 1 13 D 1 113 12 Analar Gaeratog Furds 100 160 363 0 150 453 0 15 Internally Restricted Funds 0 24 300 0 24 300 0 D D zu UG Scholars 077 36 H O77 357 0 0 21 Grad Scholars 0 151 959 il 131 939 0 0 0 0 2 Bursary 0 1 040 232 1 040 232 0 0 0 K Bursary 4130 U 4 150 LU D i U 24 Prizes 10 626 0 10 626 D D 25 Grad Prizes 13 000 0 12 000 0 0 D Restricted Sponsored 10 0 0 LU A Endawment nvestmant A0 17 33 17 338 I E Holdings 338 D U El UG Scholar Endowments 0 68 000 0 6 000 0 0 EZ Grad Scholar Endowments 0 220 000 0 250 000 LU D D 0 Bursare Endowments 151 000 151 000 0 D 0 OSTOF Bursary 0 76 000 n Fe 000 0 D A A 65 Award amp Prize Endor 30 000 0 30 000 0 0 TOTAL 66 051 455 16 926 153 207 678 50 133 178 0 1 133 0 1 133 Click here if sou would like to return to the Menu Click here ta dawnload
32. provide your User ID and Password User ID nirstnamelastname Password After you have keyed in your User ID and Password click the enter amp button The main menu will then appear 2003 Millennium Computer Systems Ltd Carleton University 5 Menu When you have successfully logged in the next screen displayed is the Main Menu This is where detailed account information can be entered and searched for If no values are entered a top level overview of funds will be displayed for the current period This is what the Main Menu would look like assuming the current period was April 2003 Main Menu Microsoft Internet Explorer provided by EduNET E l x File Edit View Favorites Tools Help Back gt amp A A seach xgFavorites 4 bh 28 zl Address http oriole nt carleton ca FASTO1 Prompts asp FD MENU amp SDL N amp FR IV amp RN 481138BV 48 amp BN IE8JS Y 3 leton FAST System Financia Administration Support Tool UNIVERSITY en FORM MENU Please input your desired report parameters You can click on the to lookup a field Chart Fund mE Orgn NEN v Acct Prog Actv Period 2003 Open Desired Report Operating Statement On the main menu you see blank text boxes for each FOAPAL element drop down box for Period and Desired Report selection If your cl
33. r Please note formulas such as totals and sums are downloaded as values not formulas ntucarleton cayFASTOM FAS T a 0p 7 AD S05 ETE UCET Microsoit Internet Esplanar gdt vew Fawkes Tons Helo EJ o gt odo search 4 eh ZA Address L ton calFASTO FOST acp Da OS n DORF n 2 18 R BE SE m BP DAC Lm ent DEn TEEN BC DES TT EL EECH eGo Links Carleton uUMIVERSITIT FAST System Finacial Support Too OS Current Tear Period Feb 2003 Open 0 220 z 2003 Actual m l coos 2004 Budget _ _ Chart bd Fund 100000 Regular Opersting Fund Dron 488 Finance Office Last Updated Apr 26 2002 m z Base Budget _Fiseal Budget EENG Scot Prog Name original Adjusted Original n djusted Actuals ncurnbered Available 2 1 0000 1300 Suppbas 113 73 144 143 323 0 516 210001 1300 Reference Materials 0 0 0 A 0 A 0 710012 1300 Other Supplies 0 n n 711000 1300 Photocopying Charges amp Supplies 0 0 0 0 110091 1300 Pointing Costs amp Supplies 0 0 0 0 0 0 0 212000 1300 Lora Distance Charges 0 0 0 0 2 000 0 2 000 1200913010 Postage Expense D A 0 0 0 D DH 713000 1300 Telephone Equipment Rentals D 0 0 0 3 000 D 3 000 13001 1100 Computer Lease Costs 0 0 0 13002 1300 Phone Aantal 0 0 0 0 0 0 0 21
34. stem Financial Administration Support Too UNIVERSITY FORM MENU Please input your desired report parameters You can click on the to lookup a field Chart Fund 1 Acct e Prog Acty Period 2003 Desired Report operating Statement 2003 Millennium Computer Systems Ltd Carleton University Troubleshooting Error Messages The most common error encountered with FAST is misspelling your user ID or password Please ensure that you have typed both in correctly and that the Caps Lock on your keyboard is off In the unlikely event that you receive an error message please contact your System Administrator on site and or contact the Help Desk You can correspond with the Help Desk By phone 613 520 3830 Email ccs admin it support carleton ca Web http apps carleton ca ccs contact asp Their normal hours of operation are Monday to Friday from 8 00am to 4 30 pm Feedback Support Contact Information Please feel free to contact the Banner Finance Team if you have any suggestions feedback or questions Demonstrations and in depth user training seminars are available by request Please address all correspondence to Jean Charles Cote CGA Banner Finance Project Manager Voice 613 520 2600 ext 8531 Email mailto Banner Finance carleton ca Web http www carleton ca banner finance finance htm 2003 Millennium Computer Systems
35. the views the Navigation Screen change the Header Bar changes to provide descriptions for each column of data being viewed 2003 Millennium Computer Systems Ltd Carleton University 14 Period Selection li htt oricde nt carietan ca FASTI FAST asp FD OSRAE DERE 1 iergert Internet Explorer p 8 x Edt gu Fawkes Tools Helo Pak s 0 P Quee Speer Zeie A cR 3 E Quo Links Carleton FAST System Fische rat Support UNIVERSITY FORM OS Display 0 Acct Prog Name Base Budget Fiscal Budget Griginall djustad Griginall Adjusted Actuals Encumbersd Bysilabls 10000 1300 Ditze Supples 113 73 143 143 373 0 516 210001 1300 Materiale 0 0 0 0 0 0 0 210012 1300 Other Supplies D 0 711000 1200 Photocopying Charges amp Wuppies 0 0 711001 1300 Porting Cost amp Supplies 0 0 0 D 0 D 0 12000 1300 Lora Distans Charges 2 000 0 2 000 212002 1300 Postage Expense 0 0 D 0 D 0 713000 1100 Telephone Equipreent Rental D 0 0 D 3 000 D 3 000 13001 1400 Computer Lease Costs 0 0 0 IW H IW 0 13002 1300 Phone Rental 0 0 0 0 0 D 0 215900 1300 Staff Development Costs 0 D 0 713100 130B MENS Travel gt General n 0 n 0 7137001300 Accountable Travel Advances 3 510 3 550 3 420 3 480 3 500 D 20 23000 12
Download Pdf Manuals
Related Search
Related Contents
Philips SA5000 512MB* Flash audio player Zeus User Manual Cover.indd Samsung WB110 Manual de Usuario Audiovox APS-255CH User's Manual USER`S MANUAL 001 Touch user guide manual_27092011 - Final User`s manual and safety instructions of the unique Lire le contenu de ce numéro cuir 320604ENEU Airgard Runaway Valve Copyright © All rights reserved.
Failed to retrieve file