Home

Simpler 3.0 Reporting - Pepperdine Community

1. E Qu Code 510500 5107 5110 Code Title I a Expenses Account is a classification of m Depreciation each transaction Assets i _ PEE Liabilities Equity Fund Balance B es i F3 teres Revenues Expenditures FRS EN interest 510700 FINANCE EXPENSE INTEREST subcodes and account controls aa fae oOo 6 Travel and staff development Travel e 511000 TRAVEL amp FCLTY STF DEVELOP POOL 511001 TRAVEL T AND E CARD DEFAULT X 511005 TRAVEL LODGING 511010 TRAVEL MEALS 511015 TRAVEL MILEAGE 511020 TRAVEL PARKING 511025 TRAVEL AIRFARE 511030 TRAVEL RENTAL CAR 511035 TRAVEL GROUND TRANSPORT OTHER 511040 TRAVEL RELATED SUPPLY SERVICES 511045 TRAVEL TIPS AMD GRATUITIES Rev Jan 22r4 2013 511050 TRAVEL FACULTY STAFF CNVRSN Simpler 3 0 Reporting t 9 gan and 24 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership Home TY Accounts Accounts Code p TRAVEL MILEAGE Rev Jan 22 2013 Simpler 3 0 Reporting 25 PEPPERDINE UNIVERSITY ocn ADM Information Technology up Ge vel Eu Chart of Accounts Programs PEPPERDINE UNIVERSITY 5trenthening Lives for Purpose Service and Leadership Home Program is the academic B Programs activities for which costs must nr Codes x Code Title be tracked within the q BLANK Blank educational departments f esem 60100 B GENERAL A 60102 B ALL P
2. 88 DMI DE B 25 2010 APVO042110 PUNIV UONDA 11250 515001 ISGEM 1 807 89 OMF DE B 25 2010 APVO042110 PUNIV UONDA 112540 515001 ISGEN 1 284 41 DMI DE o ez8 2010 PAY 00418582 PUNIV UONDA 11190 502015 ISGEN 40 882 88 PS Payr S202010 PAYOO41962 PUNIV UONDA 11190 502018 ISGEN 17 40 PS Payr sez8 2010 PAYOO41962 PUNIV UONDA 11190 504020 ISGEN 2 498 01 PS Payr x 8 28 2010 PAYOO41962 PUNIV UONDA 11190 504025 ISGEN 584272 PS Payr 8 28 2010 PA YO0041982 PUNIV UONDA 11190 504080 ISGEN 44 97 PS Payr 8 28 2010 PAY0041962 PUNIV UONDA 11190 504085 ISGEN 104 27 PS Payr 8 28 2010 PAY0041562 PUNIV UONDA 11190 504090 ISGEN 122 58 PS Payr 8 28 2010 PAY0041562 PUNIV UONDA 11190 5040985 ISGEM 12 25 PS Payr S202010 PAYOO41962 PUNIV UONDA 11190 504155 ISGEN 233 81 PS Payr S202010 PAYOO41962 PUNIV UONDA 11190 504173 ISGEN 383 33 PS Payr S202010 PAYOO41 962 PUNIV UONDA 11190 504200 ISGEN 3 663 64 PS Payr 26 2010 PAYOO41 962 PUNIV UONDA 11190 504205 ISGEN 408 38 PS Payr s 28 2010 PAYOO41 S62 PUNIV UONDA 11190 504210 ISGEN 4088 34 PS Payr 8 28 2010 PAY0041562 PUNIV UONDA 11250 502015 ISGEN 21 164 99 PS Payr 8 28 2010 PAY0041562 PUNIV UONDA 11250 502018 ISGEN 135 00 PS Payr 8 28 2010 PAY0041562 PUNIV UONDA 11250 504020 ISGEN 1 930 84 PS Payr S202010 PAYOO41962 PUNIV UONDA 11250 504025 ISGEM 451 58 FS Payr 8 28 2010 PA YO0041982 PUNIV UONDA 11250 504080 ISGEN 27 79 PS Payr 8 28 2010 PAYOO41962 PUNIV UONDA 11250 504085 ISGEN 80 93 PS Payr S202010 PAYOO41 S62 PUNIV
3. DEPARTMENT Business Unit Account UNE TEM FUNCTNLCAT E Fund Revenue and Expenditure Balances YTD Department As Of Today By Fund F at VALUES H Department gt DEPARTMENT gt P Selection Criteria Project PROJDETAIL EL Business Unit VALUES DEPARTMENT PROJDETAIL Create a shortcut for 1 the query results and 2 the query and save them both to your Simpler account and to another Simpler acct Try Account with LINE ITEM DETLITEM1 Or LINE ITEM VALUES la PEPPERDINE UNIVERSITY Ew e Information Technology Contact Info Len Krukowski x6807 o PeopleSoft Simpler Training e Tim Bodden x7368 o Simpler system usage or issue e Finance Abrash Khanmalek x4042 o Finance business issues related to Simpler Rev Jan 22 2013 Simpler 3 0 Reporting 49 PEPPERDINE UNIVERSITY Information Technology M wall Credit Card Re digaas Rev Sept 20 2012 http wavenettraining pepperdine edu Feedback PEPPERDINE UNIVERSITY Strengthening Lives for Purpose Service and Leadership TRAINING FEEDBACK Class Title Travel amp Expense Requisition Credit Card Reallocation 2 Simpler Other Overall would rate this class as a positive experience The training presentation was well organized and clear Class Date d Required Entries Strongly cuz tele Agr
4. EDUCATION SVCS INC PUNIV 0000000010 UNITED STATES TREASURY PUNIV 0000000011 SCS FLOORING SYSTEMS o PUNIV 0000000012 ZHONE TECHNOLOGIES INC Q PUNIV 0000000013 BIO REV ENVIRONMENTAL ENGINEERING PUNIV 0000000014 ADVANCED SEWER TECHNOLOGIES x PUNIV 0000000015 CONTAINER OUTLET Rev Jan 22 2013 Simpler 3 0 Reporting BU a k CONCRETE Silius IN 36 PEPPERDINE UNIVERSITY Information Technology uery Results View Strenthening Lives for Purpose Service and Leadership The order of the return ed Sea rch IS based on the Summarize By order selected on the criteria page 100334495 Sign Out i Revenue and Expenditure Balances YTD I lt lt Page 1 of 1 gt gt I E Criteria As Of 10 30 2012 Original Adjusted Month To Date Year To Date Year To Date Year To q VALUES Title Budget Budget Actual Actual Fre Encumb Encumbi E e VALUES UPPRJ UNRESTR PLANT FOR PROJECTS Note that Some data may be out of view use VALUES 11190 IT ERP the horizontal scroll arrows to view all fields Expenses B 515001 SUPPLES PURCH CARD DEFAULT 6 90 x 515040 SUPPLIES BOTTLED WATER amp RELATE 9 58 T 515060 SUPPLIES COMPUTER ACCESSORIE 1 04 126 16 515130 SUPPLIES OFFICE 103 41 P 516705 TELEPHONE EXP LOCAL amp LONG DIST 1 073 75 0 516710 TELEPHOME EXPEMSE CELLULAR 375 00 Total Expenses 5 86 1 688 00 Q Total IT ERP 5 86 1 588 00 Total UNRE
5. Program Title 9 Product SC Orchestra 0 XK i SC Fine Arts Productions or x Project Sa Only the percent and SEDAN i SC Drama Scholarship SC Music Scholarship kh a F Run 10 30 2012 2 19 PM 1 154 rows in 0 4 seconds asterisk can be entered in the Builder search field for a wildcard match Close Rev Jan 22 2013 M Simpler 3 0 Reporting o dla 16 PEPPERDINE UNIVERSITY Information Technology The exclamation mark signifies not or exclude not or notin and can be used to exclude items Search Criteria amp Wildcard characters i enables the user to request a wide S variety of information from accounting segments that filter refine the search used to narrow down the query results to specific values within each segment i Of Either a percent sign 96 or the Or O asterisk is used to replace or wildcard match match one or more characters in an alpha or numeric string E The comma is used to separate Selection Criteria Business Unit M r 2 sepa rate data two or more different Items for a non sequential list Fund Fint Department 11190 11250 11125 T Two dots are used for Account 511 ee sequential sequential data between two Class 5 x ass data values For example Program 512000 513000 all values Product 3000 4000 including 513000 will be Pupa x provided Also may be used lt Oper Unit 8 for greater than an
6. UWONDA 11250 504090 ISGEN 72 98 PS Payr se 2z8 2010 PAYOO41962 PUNIV UONDA 11250 5040985 ISGEN 7 30 PS Pay Re g 28 2n10 PAYDDA188 P INI LONE 112510 n a 20m I amp S 3EN LOTEI PS Pawi Criteria Business Unit PUNIV Fund UONDA Department 11190 17250 Transaction Type Actual Accounting Period 1 12 i Em Si Rum 4umH12418PM Dai Last Updated 44 2011 24004 PM Sra rows In 06 seconds PEPPERDINE UNIVERSITY Information Technology General Ledger Balances Query PEPPERDINE UNIVERSITY Query Strenthenimg Lives for Purpose Service and Leadership Accounting Period 5 General Ledger Balances 0 pulling the balance forward 1 12 current fiscal year As OF 998 used for adjusting entries Summarize By Page Break Accounting Period Accounting Period i rg Mippitet Hi Wu Account Class Program X Product Project Oper Unit Rev Jan 22 2013 Simpler 3 0 Reporting PEPPERDINE UNIVERSITY Information Technology 5irenihemng Lives for Purpose Service and Leadership ft General Ledger Balances I lt lt Page 10f1 gt 5l IE Criteria As Of ds ms Beginning Year To Date Year To Date Ending FN VALUES Title Balance Debits Credits Balance f Unrestricted MAJOR AREA 11140KK Vice Provost 11185 IT Connections 2 Community W tt T3 11190 IT ERP 26 01 rer m
7. ar ee es Sere ee Tax Asset information Statuses Cur cv GL Unit Account L urrency at UNIT ACCOUNT 23 80 USD PUNY 515001 Class Product sGEN a Ql a Fund Dept Q UONDA Q 10040 Oper Unit 1 100 0000 a Business Unit Fund codes 160 major division Department codes 1100 pe SR sete Account codes 1600 Account Code Program codes 140 4xxxxx Revenue Project codes 1600 2XXXXx Expenses Class codes 150 Operating Units 1800 Operating Unit user defined 1000 9999 non designated endow all date back to FY 2004 DAF09175 END00090 Class why dept is incurring expense Fund ISGEN AEGEN etc Project only for defined projects 1OERP PSLIC etc type amp source of money UONDA UGFED etc Department Program Rev Jan 22 4 2013 who expense rev Academics only 11190 11250 etc 60345 80105 etc 3 Simpler 3 0 Reporting PEPPERDINE UNIVERSITY Information Technology Using Simpler Reporting EJ FINANCE CENTER Requisitions D Travel and Expense F3 Create Modify Requisitions E Travel and Expense Center Copy Requisitions Expense Rpt by Submitter ID F Requisition Inquiry Expense Report Approver by Rpt E Req Workflow Status All Regs E Expense Report Detail by Rpt Review Requisitions E Expense Report needs Approval Your session is about to be timed out As a security precaution sessions end after 30 minutes of ina
8. i 4 Page 1of1 gt M 1 25 2011 APV0048354 PUNIV UPPRJ 11190 511025 ISGEN 4300 10ERP MTGS 471 30 USAIRWAYS 03777583188 re 1 25 2041 APV0048354 PUNIV UPPRJ 11190 511025 ISGEN 4300 10ERP MTGS 363 40 AMERICAN Al 00179491245 P 1 25 2011 APV0046354 PUNIV UPPRJ 11190 511025 ISGEN 4300 10ERP MTGS 363 40 AMERICAN Al 00179491245 1 25 2011 APV0048354 PUNIV UPPRJ 11190 511025 ISGEN 4300 10ERP MTGS 363 40 AMERICAN Al 00179491245 e 3 25 2041 APV0048186 PUNIV UPPRJ 11190 511025 ISGEN 10ERP PRJ 1 028 19 VIRGIN AMER 3 25 2041 APV0048186 PUNIV UPPRJ 11190 511025 ISGEN 10ERP PSCONF 384 40 SOUTHWESTAIR526216070 Total TRAVEL AIRFARE 2 974 098 Rev Ja x Total Connectns to Community Summary 2974 08 Simpler 4 Total i gt 3167 49 PEPPERDINE UNIVERSITY Information Technology Transactions Query PEPPERDINE UNIVERSITY Strenihenme Lives for Purpose Service and Leadership Query The Summarize By Query Builder works the same as in the Budget Balances Query f Revenue and Expenditure Transactions From To a Summarize By om Page Break fg Pa Transaction Type Budget Org Budget Actual COPre Encumbrance Encumbrance rH un e Accounting Period 42 1a r revenue and E iture Transactions x Selection Criteria From To HH Business Unit E Summarize By Fund p Page Break hi Department Transactio
9. 010 ARMORED CAR SERVICES ART EQ amp SU 5000 ART EQ amp SUP ART EQUIP 5200 ART EQUIP i R5 i ja vn Lu EL Aj RC Rev Jan 22 2013 Simpler 3 0 Reporting 34 PEPPERDINE UNIVERSITY Information Technology Rev Jan 22 2013 Simpler 3 0 Reporting PEPPERDINE UNIVERSITY 5trenthening Lives for Purpose Service and Leadership 1 Home Products Code 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 E q e Cor BND 1013 Chart of Accounts Products Title USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED USER DEFINED ISER DEFINED im E Product is a set of sequential values intended for departmental use 35 PEPPERDINE UNIVERSITY ons ne Information Technology Chart of Accounts Vendors Strenthenine Lives for Purpose Service and Leadership Home E Vendors Vendor is a set of a Bus Unit Code Title merc h ant co d es PUNIV 0000000001 INTERNAL REVENUE SERVICE a PUNIV 0000000002 FRANCHISE TAX BOARD intended for General PUNIV 0000000003 BAKER MARY BETH Led ger transaction use fy PUNIV 0000000004 IPARADIGMS LLC PUNIV 0000000005 STYLUS WRITING amp EDITING TA PUNIV 0000000006 SPINELLI WILLIAM fe PUNIV 0000000007 DEPT OF CHILD SUPPORT SVCS CNTY SB PUNIV 0000000008 DIVISION OF CHILD SUPPORT u PUNIV 0000000009 OSI
10. 11185 Expenditur 517005 TRAVEL L Pre ery 51185 ConnectnsExpenses 311185 Expenditur 517015 TRAVEL ly 31118 Connectns Expenses 511185 Expenditure 511025 TRAVEL A 311185 W qnnectnsExpenses 311185 Expenditure 511035 TRAVEL C 211185 hnectns Expenses 511185 Expenditur 517220 STAFF DE 311185 ConnectnsExpenses 511165 Expenditur 517260 STAFF DE je mn 311250 Data Ctr In Expenses 317250 Expenditur 517000 TRAVEL amp I 311250 Data Ctr In Expenses 511250 Expenditur 511001 TRAVEL 311250 Data Ctr In Expenses 511250 Expenditur 517015 TRAVEL ly 311250 Data Ctr In Expenses 317250 Expenditur 517025 TRAVEL A 12 Rev Jan 2 CSV Comma Separated Value files are unformatted text documents 2 Simpler 3 0 Reporting h mk mk ala 99 wN eon l l PEPPERDINE UNIVERSITY Information Technology Other Taskbar Functions E3 i n3 Setup Page for Admin use only Help Page opens up the Simpler 3 0 User Manual About Page displays the Simpler copyright rx QOO v Logout of Simpler 3 0 vestre Sign Out i Page 1 of 1 gt Rev Jan 22 2013 Simpler 3 0 Reporting 41 PEPPERDINE UNIVE Information Technology The blue entries are available for drill down by selecting the transaction value links to the i i transaction report Clicking on the entry will open f Revenue and Expenditure Balances YTD the Transactions view for that entry PEPPERDINE UNIVERSITY Strenthenmg Liv
11. 11195 IT Legacy Applications aii din ml 11200 IT Portal ES 11210 IT Advancement Technical Svcs Ha P we 11250 IT Info Seraces amp Program Mgt kde on od s Aeon p 11255 IT Data Center Operations m T P 11260 IT Card Services od y Bb M 11265 IT Systems amp Metworking od d e a 4 11270 IT Information Security o e 4 Ae e Q Total Vice Provost u b dide ibd Vili a ai Total Unrestricted p i die ich aide a i x Total s Ty ii Mie b d d u o Criteria Accounting Period 1 12 888 Run 4 27 2011 2 42 PM Data Last Updated 4 27 2011 2 37 33 PM 13 rows in 1 8 seconds Done Rev Jan 22 2013 Simpler 3 0 Reporting 46 PEPPERDINE UNIVERSITY Information Technology Simpler Tips and Tricks 5trenthenine Lives for Purpose Service and Leadership Home Use Open Link in New Tab so that additional queries can be displayed in other web browser tabs allowing query results to be easily compared A Welcome Leonard Krukowski Recent News Manage Shortcuts Manage 1OERP PRJ pdf xls csv 11140KK Rev amp Ex pdf xls csv ACCOUNTS pdf xls csv Acct Dept Fund pdf xls csv Adv amp PA Area Summary UONDA pdf BASIC Eri MDI E mdf I sele aru t Open Link in New Window Budget E uk i F Budget E Bookmark This Link Budget E Save Link As 0 Budget E Copy Link Location gt The query UR
12. AEA Page Break None PE PPERDI N E UNIVE Rol TY EEN M Strenthenine Lives for Purpose Service and Leadership Selection Criteria TEENS Business Unit fi Revenue and Expenditure Balances YTD PINME en FH Criteria As Of 10 30 2012 Department Original Adjusted Month TAR qQ VALUES Title Budget Budget Actual Pp Mi ALL BUDGETS KK SUMMARY NODE Class f Unrestricted e Unrestricted Operating 9 Program Unrestricted Nondesig General Product UONDA UNRESTR OPER NONDESIG ACTIV ad Total Unrestricted Nondesig General X Project i5 Total Unrestricted Operating Oper Unit Total Unrestricted Total ALL BUDGETS KK SUMMARY NODE PF o Total pietat 4 M a Rev Jan 22 2013 Simpler 3 0 Reporting 15 PEPPERDINE UNIVERSITY Information Technology Selection Criteria Builder PEPPERDINE UNIVERSITY Sirenthenmme Lies for Purpose Service ond Leadership Revenue and Expenditure Balances YTD B n Use the Lookup As OF Today Query Builder to Summarize By ALL CATEGORY DETAILITEM DETLVALUE VALUES help look up the Page Break Non iiki E codes for that MN o E eee oe nE Selection Criteria criteria Busingssgit F Any of the above Fund characters can used as Department part of a search string Account K lt Page 7 ot 12 gt 5l to be entered into the Pp SPOT ES Page joti2 0 90 Class Selection Criteria fields o r
13. DEPTSUMM DEPARTMENT DEPTDETL2 DEPTDETIL3 VALUES The Summarize By Query Builder is the function which allows the summarization of data at various chart of account levels Fields can reordered automatically by using or v Usex to remove Additional Pull Down boxes are available automatically 11 PEPPERDINE UNIVERSITY Information Technology Report Options Page Break PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadership Page Break allows the user to tailor the reports for presentations or distribution By selecting a Page Break at element that is included as one of the Summarize By options the printed report can be tailored well enough to be ready to hand out or email to others Home A Revenue and Expenditure Balances YTD As Of Today Summarize By VALUES DEPARTMENT LINE ITEM VALUES Page Break Selection Criteria Business Unit Fund Department Account Class This report can be page Program divided by any of these lt Product items when printed x ecN Project Oper Unit Rev Jan 22 2013 Simpler 3 0 Reporting 12 PEPPERDINE UNIVERSITY PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadership Strenthening Lives for Purpose Service and Leadership Home ome A Revenue and Expenditure Balances YTD gt G T Revenue and Expenditure Balances YTD E As Of Toda
14. E Programs Summary e AREASUMM 510890 GSBM Fully Employd Pgm Summary x DEPTSUMM 310890 GSBM Fully Employd Pgm Summary DEPARTMENT 310890 GSBM Fully Employd Pgm Summary DEPTDETL1 510890 GSBM Fully Employd Pgm Summary 510890 GSBM Fully Employd Pgm Summary 510890 GSBM Fully Employd Pgm Summary DEPTSUMM 310893 GSBM BSM Summary DEPARTMENT S10B9354GSBM RSM Summary PEPPERDINE UNIVERSITY Information Technology naret ET ae pe T Eu m w LE e Department Hierarchy Example PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership f Departments Departments E ion VALUES gt M rm pom Pepperdine University summarize By VICE PRES dS Executive Vice President COO Code MAJOR AREA MAJOR AREA 10405KK Chief Business Officer e aisa az DIVISNSUM 510401 Chief Business Office Summary SOC Tille dois c AREASUMM 510405 Campus Ops Bus Svc Summary DEPARTMENT MN DEPTSUMM 510440 Fac Mgmt and Planng Summary DEPTDETL1 leet DEPARTMENT 510490 Facility Svcs Summary DEPTDEIL2 BE DEPTDETL1 510495 Mechanical Svc Summary DEFTDENLS 10505 CamOps Plumbing VALUES Rev Jan 22 2013 Simpler 3 0 Reporting 23 PEPPERDINE UNIVERSITY Se Information Technology m o du M SLE Chart of Accounts Accounting Codes PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadership Home A Accounts
15. L may be copied and pasted ae ren into another browser window or into an _ Outlook email to send for analysis Budget F Inspect Element Q paid acd ias P Fu o iii dav phe https psdw pepperdine edu compose p E amp AsOf Date Today 28 29 amp Group Report Project4 Account2 Accou nt3 Account2 Account7 Department3 Department11 amp AccountingPeriod 0 999 amp Project 10ERP PRJ amp Requery query revexpbalances html RevExp 3dE amp _Shortcut 10ERP PRJ Rev Jan 22 2013 re MEM Simpler 3 0 Reporting 47 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service Home A Revenue and Expenditure Balances YTD As Of Today Summarize By Page Break By Fund El at VALUES gt Selection Criteria Business Unit Fund Department Rev Jan 22 2013 Simpler 3 0 Reporting and Leadership Budget Balances Exercise Create one or more Query Results using the Summarize By Builder examples Use one or more Selection Criteria fields exclude any internal funds Select an appropriate page break Department DEPARTMENT Account x LINE TEM FUNCTNLCAT I m in in E o Revenue and Expenditure Balances YTD Today VALUES VALUES DEPARTMENT LINE TEM VALUES By Fund at VALUES Operating Unit VALUES 2 Selection Criteria Department
16. NSTRUCTN NON MATRIC CRS CUSTM INSTRUCTN NON MATRIC CRS OPEN Instruction Institutional Support INST SUPPT EXECUTIVE MGMT INST SUPPT FISCAL OPERATIONS INST SUPPT GENERAL INST SUPPT ADMINISTRATIVE IT INST SUPPT PUB RELATIONS DVPMT 30 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership Home T Classes Level Summarize By Code fy itle Rev Jan 22 2013 Simpler 3 0 Reporting Classes VALUES Code All Class Management amp General VALUES Institutional Support ISGEN INST SUPPT GENERAL 31 Information Technology PEPPERDINE UNIVERSITY NM PEPPERDINE UNIVERSITY Strenthenimg Lives for Purpose Service and Leadership Operating Unit is the individual fi Operating Units non grant values within restricted Bo Code Title funds endowments loans etc c OpU Agency ft OpU Agency AGC80003 CAMPUS PROGRESS mn AGC80004 GERMAN CLUB E AGC80005 HOMECOMING HOSTS AGCS80006 INVESTMENT amp FINANCE CLUB t AGCB0007 JAPANESE ANIME amp CULTURE SOC AGC80008 MODEL UNITED NATIONS AGC80009 SERVICE FOR LIFE o AGC80010 SIDELINE Q AGC80011 SWING DANCE CLUB AGC80012 GSEP PHI DELTA KAPPA x AGC80013 PI MU EPISILON AGCS80014 PRSSA STUDENT ORGANIZATION AGC80015 FACE OF MICROFINANCE CLUB AGCS80016 TENNIS CLUB SPORT OPU AGENCY OpU Agency Conversion Only Conversion Only CNVO00000 Value for conversio
17. PEPPERDINE UNIVERSITY Information Technology Simpler 3 0 Reporting Update 10 26 2012 Len Krukowski x6807 Information Technology Team Leader Technical Trainer PEPPERDINE UNIVERSITY Information Technology e Simpler Reports is a management information system which is designed to allow a wide range of users to retrieve financial information in a user friendly and easy to read format using a query application that s not much different than a web browser search engine The user query s the application using chartfield elements for capturing budget balances transactions or general ledger information This is accomplished through one or more report options using multiple selection criteria and quickly obtains a report customized to your specific inquiry and your given authorization level Simpler Reports is used in conjunction with the PeopleSoft ERP system and receives data securely from PeopleSoft posts the transactions and then synchronizes every 10 minutes with PeopleSoft by automatically checking to ensure both systems are reporting the same results Rev Jan 22 4 2013 Simpler 3 0 Reporting 2 PEPPERDINE UNIVERSITY Information Technology Pepperdine uses an accounting method commonly referred to as fund accounting A chartfield which is an important element of reporting is the basis of fund accounting and describes what is occurring in an accounting transaction Distributions aay
18. R t5 516725 TELEPHONE EXPENSE NETWORK 517000 PRINTING POOL Pa 517020 PRINTING BROCHURES 60 517045 PRINTING FORMS 517095 PRINTING POSTERS 9 518000 PHOTO FAX WORD POG 518005 PHOTOCOPY EXPENSE X 518010 FAX 5 AVICE EXPENSE Original budget approved by the board Any budget adjustments are shown here Current month expenses or revenue shown here Rev Jan 22 2013 Simpler 3 0 Reporting Query Results View Note that Page Breaks will cause the report to be divided rather than one long contiguous page 100334495 Sign Og I Page 4 of 9 gt N Original Adjusted Month To Date Year To Date Year To Date Year To Date T amp E Bdgt to Act Budget Budget Actual Actual Pre Encumb Encumbrances Encumbrances Variance 5 50 5 500 0 ae A purchase order has been issued the item ordered has not yet been received or recorded but a hold is placed on the department s budget Budget to Actual variance Intent to purchase Red submitted Submitted Travel Expense Point to date expenses or Reimbursement revenue shown here 14 PEPPERDINE UNIVERSITY Information Technology Strenthenime Lives for Purpose Service and Leadersinp Summarize By combined with the Selection Criteria filter will produce a Home Ti Revenue and Expenditure Balances YTD ww Today more specific Query result Summarize By ALL CATEGORY DETAILITEM DETLVALUEJ
19. R Y 280 BED DORMITORY PLANT 56 PRINCES GATE o ADMIN BUILDING ACADEMIC COMPLEX e ACAD PKING LOT GCP 10ACCESSCTIRL CAMPUS WIDE ACCESS CONTROL x 10ADMIN HSG ADMIN HOUSING 10ADMSYS RPL ADM SYSTEM REPLACEMT 10AHMSON CTR AHMANSON F A CTR Rev Jan 22r4 2013 10APPLE DORM APPLE DORM PROJECT Simpler 3 0 Reporting P mua m adi Saal o aene 5 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthenime Lives for Purpose Service and Leadership Home A Projects Projects Level Code All values Capital Projects PROJDETAIL CAPITAL PROJECTS Capital Projects 1 ERP PSLIC ERP PS SFIWR LICENSE Summarize By n VALUES fy Title Rev Jan 22 2013 Simpler 3 0 Reporting 29 PEPPERDINE UNIVERSITY Information Technology Chart of Accounts Classes 5trenthemne Lives for Purpose Service and Leadership Hame Classes r Code FF x Class is what kind of money that is All Class used for research instruction aiako S a scholarships operations etc Instruction amp Research INSTRUCT RESEARCH Instruction INCOM INGEN INITS INMAT INNMC INNMO INSTRUCTION Management amp General Institutional Support INSTIT SUPP ISEXE ISFIS ISGEN ISITS ISPRD Rev Jan 22 2013 Simpler 3 0 Reporting Title Instruction amp Research INSTRUCTN COMMUNITY EDUCATION INSTRUCTN GENERAL INSTRUCTN IT INSTRUCTN MATRIC COURSES I
20. ROGRAM EXPENSE x 50105 BE FULLY EMPLOYED PROGRAMS 50110 BE FULLY EMPLOYED MBA t 50120 BE BACHELOR OF SCIENCE IN MGMT 60205 BF FULL TIME PROGRAMS d 50210 BF RESIDENTIAL MBA 0 50220 BF MASTER OF INTL BUSINESS Q9 50305 BX EXECUTIVE PROGRAMS 50310 BX EXECUTIVE MBA x 50320 BX MBA PRESIDENTS AND KEY EXEC 50330 BX MASTER SCI ORGANIZTN DVPMT 50340 BX MBA TECH MGMT FOR EXECUTIV 60345 GSBM Executive Education 50350 GSBM Prep MBA 50400 GSBM ONLINE EDUCATION GSEP 80100 G GENERAL Rey Jan 22 d 2013 80102 G ALL PROGRAM EXPENSE G Be Qik OG ISO RAMS go d 26 Simpler 3 0 Reporting PEPPERDINE UNIVERSITY Information Technology Strenthenine Lives for Purpose Service and Leadership Home T Programs Programs Level VALUES i UM i ALL All values Summarize By SCHOOL GSEP Code VALUES 80210 GE MA IN EDUCATION fg Title Rev Jan 22 4 2013 27 Simpler 3 0 Reporting PEPPERDINE UNIVERSITY Information Technology Chart of Accounts Projects PEPPERDINE UNIVERSITY 5trenthenine Lives for Purpose Service and Leadership Home A Projects Apu i E ar Project is the individual projects a that have a defined lifetime or Q All values activities for which activity is tracked within or across E ALL All values departments e l l Capital Projects x PROJDETAIL CAPITAL PROJECTS Capital Projects Tl 101CARD SYS ONE CARD SYSTEM 10280DORMT
21. STR PLANT FOR PROJECTS 5 86 1 588 00 X Total 19 042 00 19 042 00 5 86 2 341 74 rw 4 hr Criteria Fund Mint Department 11190 11250 Account 515 529 Accounting Period 10 1999 Run 10 30 2012 3 58 PM Data Last Updated 10 30 2012 1 40 42 AM 11 rows in 124 7 seconds The criteria selected for the search when the search was run is shown here in the Rev Jan 22 2013 bottom left corner Simpler 3 0 Reporting 37 PEPPERDINE UNIVERSITY Information Technology E e m i mi TM yn Eni ie as a P oS ee eT i hii C aem Ix Query Save gt Create Shortcut amp Users Strenthening Lives for Purpose Service and Leadership Strenthening Lives for Purpose Service and Leadership Home Home i Hevenue and Expenditure Balances YTD By se ecti ng one or more names E Criteria As Of 10 30 2012 e MEE in the User s list you can Save the E x Query result by creating a Ju VALUES UPINT UNRESTR PLANT INTERNAL User s Leila T Salisbury Ej shortcut for yourself as well as for Lela P L piara 11190 IT ERP mrima AUN other users 1 J values ls FRE gy Expenses fs venire NOTE press the Ctrl key to select 515040 SUPPLIES BOTTLED WATER amp RELAT m ncm P or deselect multiple Users Total Expenses Leonard Krukowski t Total All values Total IT ERP gt NIE Pisis mj seer PEPPERDINE UNIVERSI
22. TY P Total UNRESTR PLANT INTERNAL a M o i Strenthenine Lives for Purpose Service and Leadership VALUES UPPRJ UNRESTR PLANT FOR PROJECTS Home VALUES 11190 IT ERP x AH values T Create Shortcut cxpewses z Shortcut Name My Saved Shortcut 515001 SUPPLES PURCH CARD DEFAULT i 515040 SUPPLIES BOTTLED WATER amp RELATE User s Leila T Salisbury BI 515060 SUPPLIES COMPUTER ACCESSORIE quem om vem 515130 PECES NE f Lena C Stoops Leon R Martinez Leonard H Rushfield Leonard Hill Leonard Krukowski Rev Jan 22 2013 parum Simpler 3 0 Reporting gr 38 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadership Home a Welcome Leonard Krukowski Recent News Manage Shortcuts Manage 1OERP PRJ pdf xls csv f 11140KK Rev amp Ex pdf xls csv ACCOUNTS pdf xls csv AV 7 m v 3 PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadership Home T X Edit Shortcut H Shortcut Mame BASIC EXAMPLE Update Delete fi Rev Jan 22 2013 Simpler 3 0 Reporting Manage Shortcuts Note that any Shortcut that you create and send to another user belongs to them They may delete it or rename and update it If you delete your shared shortcut it will not affect any other user PEPPERDINE UNIVERSITY Strenthening Lives for Purpo
23. UGFED UNRESTRICTED GRANT COUNT Y CITY UNRESTR FEDERAL GRANT 20 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY 5trenthenine Lives for Purpose Service and Leadership Home Funds A Funds Q Code UO x E Look Code Title gt All values Unrestricted Code Unrestricted Operating Unrestricted Designated UODNS UNRESTR OPR DESIG NONSCH UODSC UNRESTR OPER DESIG SCHOLARSP Summarize By Unrestricted Internal UOINT UNRESTR OPERATING INTERNAL TRA Rev Jan 22 2013 Simpler 3 0 Reporting 21 PEPPERDINE UNIVERSITY Information Technology Department is a academic area research units admin offices with an appointed manager that have a programmatic operational fiscal and or budgetary responsibility for a specific set of activities Rev Jan 22 2013 Simpler 3 0 Reporting Chart of Accounts Departments PEPPERDINE UNIVERSITY m re T khJUE eam e Strenthening Lives for Purpose Service and Leadership Home fi Departments Code Title Q Pepperdine University Provost ft MAJOR AREA 10710KK GSBM DIVISNSUM 510820 GSBM Academic Programs Summary mm AREASUMM 810820 GSBM Academic Programs Summary E DEPTSUMM 310820 GSBM Academic Programs Summary DEPARTMENT 310820 GSBM Academic Programs Summary t DEPTDETL1 3510820 GSBM Academic Programs Summary 10925 GSBM FE Recruitment 310820 GSBM Academic Programs Summary o 510820 GSBM F
24. ctivity Click OK to continue your current session E Requisition Status E ER Level 1 Approvers by Dept Ej Reg Lvl 1 Approvers by Departs Login into your WaveNet rch d e pde con iia account and from the Finance SM ia Se Center locate the Reporting amp ok Purchase Order Inquiry N FE Purchase Order Status Queries section ORACLE Category Codes Query Ans Click on Simpler Systems to poe navigate to the Simpler POs That Do Not Need Receiving Systems Home Page eS Note WaveNet will ES Voucher Regular Entry m ee automatically log you out after E voucher Status Ledger E Payment Inquiry Validate Chartfield Combo 30 minutes of inactivity 1 View Chartfields 7 EE A E however Simpler will continue to remain active m rea I Requisition Approval History Budget Overview E User Approver List E Budget Details E vendor Address F Query Viewer Rev Ja E Simpler Systems Simpler bomasin p and d 4 PEPPERDINE UNIVERSITY Information Technology Strenthening Lives for Purpose Service and Leadership f Home fi Welcome Leonard Krukowski Recent News Manage Shortcuts Manage e Len pdf xls csv Shortcuts are actions saved by either the individual user or by someone else The Manage link is where you Q will change names or delete Q reports x Rev Jan 22 2013 Simpler 3 0 Reporting Simple
25. d less than 5 greater than 5 5 less than 5 Using blank in the Selection Rev Jan 22 2013 Criteria field will include all of Simpler 3 0 Reporting the requested data PEPPERDINE UNIVERSITY Information Technology Search Re query lt Strenthening Lives for Purpose Service and Leadersh 4 Home Search allows the user to BASIC EXAMPLE modify re query the Criteria As Of 10 30 2012 report criteria without Starting over Product Title VALUES UODNS UNRESTR OPR DEE MAJOR AREA 10680KK President VALUES 11385 Center for the A All values Revenues VALUES 406005 REVENUE 0 b VALUES FDRSG FUNDRAISIN 4300 USER DEFIN Jotal EUNDRAISING Go E3 ix nj Rev Jan 22 2013 Simpler 3 0 Reporting 18 PEPPERDINE UNIVERSITY Information Technology Strenthenine Lives for Purpose Service and Leadership Home gt Query f Select an option from the choices below Budget Balances YTD Departmental Revenues Expenses Combined p Budget Balances LTD Grants amp Projects Hevenues Expenses Combined Transactions Revenues Expenses Combined General Ledger x OOY Balances Balances User Defined Time Span Transactions Rev Jan 22 2013 Simpler 3 0 Reporting Query Page Chart of Account Tables Transaction Details Requisitions Purchase Orders Vouchers Checks Chart of Accounts Tables Business Units Funds Depar
26. ee or test DRUMS Agree Disagree Disagree WaveMet Faculty Staff Directory d Not SE Comments ja Applicable EN 4 i k a 50
27. es for Purpose Service and Leadership El Criteria As Of 4 22 2011 Original Adjusted Month To Date Year To Date Year To Date Year To Date Bdagt to A gt VALUES Budget Budget Actual Actual Pre Encumb Encumbrances Variance TRAVEL MILEAGE 0 00 0 00 0 00 112 00 0 00 0 00 1 m TRAVEL AIRFARE 0 00 0 00 0 00 29 408 0 00 0 00 29 TRAVEL GROUND TRANSPORT OTH 0 00 0 00 0 00 88 00 0 00 0 00 i A ges al ase ow apo mmm ra tit tte aL ee ama 5 00 0 00 mn Pere _JPPUe BOTTLED We RARE Al u ul uil dtd T Wu b J x 515060 SUPPLIES COMPUTER ACCESSORIE 0 00 0 00 0 00 150 22 0 00 0 00 516705 TELEPHONE EXP LOCAL amp LONG DIS 0 00 0 00 0 00 157287 0 00 0 00 7 5 511 51 LE PLED L LAT TY I Strenthening Lives for Purpose Service and Leadership The drill down allows the user to m B ERR TE view the details of the transaction Tot Criteria Post On 8 1 2010 3 22 2011 Tran Jaurnal Doc Date Journal ID Type m Department Account Class Program Product Project Oper Unit Amount Description NIME M Seesaw LE DE DEM eS ee T 60 DEPTDETL2 511250 Data Ctr Info Securi E f VALUES 511025 TRAVEL AIRFARE Criteria W25 2010 APY0042110 PUNIV UONDA 11250 511025 ISGEN 4300 193 40 SOUTHWESTAJR526211933 Rur WZ Total TRAVEL AIRFARE 193 40 T Total Data Ctr Info Security Summary 193 40 DEPTDETL 2 511195 Connectns to Community Summary Hf VALUES 511025 TRAVEL AIRFARE
28. ing Lives for Purpose Service and Leadership T Revenue and Expenditure Balane month month end figures are normally the most reliable The current open month is also reported as a year to date or month to date amount As of Today is the default Summarize By Page Break This Month End Last Month End This Fiscal Year End Last Fiscal Year End 8 31 2013 7 31 2013 6 30 2013 Yers B 5 31 2013 Quarters Months For 6 12 31 2012 11 30 2012 10 31 2012 9 30 2012 8 31 2012 7 31 2012 Rev Jan 22 2013 Simpler 3 0 Reporting 10 PEPPERDINE UNIVERSITY Information Technology mm PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadership Home A Revenue and Expenditure Balances YTD As OF Today Summarize By Page Break By Fund at VALUES fi Perret tre ttre tre tree reer cee eee ree re Department gt MAJOR AREA Selection Criteria Business Unit Business Unit Fund N Department NT Account E Program Department Project Account cuit Operating Unit Class Product All G Klo men By Fund Product Department x Project Oper Unit The order that you pick the items will be the top to bottom order reflected in the returned search Rev Jan 22 2013 Simpler 3 0 Reporting MENEN OK Cance at VALUES MAJOR AREA gn VICE PRES MAJOR AREA DIVISNSUM AREASUMM
29. ler 3 0 Reporting PEPPERDINE UNIVERSITY Information Technology ada AA bs T uery Builder amp the Chartfields Y Details Tax Y Asset Information Y Statuses FSH cy GL Unit Account Oper Unit Fund Dept Program Class Distributions T ds L martr Product Project af lal Ja PUNY Q Strenthening Lives for Purpose Service and Leadership Home Use the Go button or Enter A Revenue and Expenditure Balances YTD Go to start the query As Of Today Builder Summarize By Section E iz E E Use the ellipses button gt selection criteria E em _ to open query builder Business Unit em n selections Account Fund Program Project Department Class MM Operating Unit The Query Builder allows Criteria n am Summarize by single or multiple chartfields Section o Selection Criteria for distinct chartfield data Program using either specific or ranges of data Use of wildcards to refine filter searches Product Project Oper Unit Rev Jan 227 20 MEM S alf i ma x m aa ql Simpler 3 0 Reporting 9 PEPPERDINE UNIVERSITY Information Technology As Of dates can be specified as the current date a month end of a previous period or a specific date in the past Since financial information within a month can change throughout that PEPPERDINE UNIVERSITY Strenthen
30. n Type Account ype 9 sc EON HT Macc NE Selection Criteria Product e X Project Oper Unit The From To Builder provides for Journal ID selected date ranges e Vendor Criteria Business Unit The same Search Criteria amp Wildcard characters used in Budget Balances apply here as well Vendor ID Voucher Criteria Business Unit Voucher ID Rev Jan 22 Simpler 3 0 Fr 43 PEPPERDINE UNIVE Information Technology Transactions Results PEPPERDINE UNIVERSITY Query Strenthenine Lipes for Purpose Sermice and Leadership f TEE and Expenditure Transactions 8 1 2010 4 4 2011 Doc Business c Journal ID Type Document ID Unit Fund Department Account Class Program Product Project Oper Unit Amount Desai g i cd Unrestricted Nondesig General f 8 1 2010 PAYO0041146 PUNIV UONDA 11250 503005 ISGEN 27 14 PS Payr 8 11 2010 AP Vv0041381 PUNIV UONDA 11250 513760 ISGEN 4200 14 438 82 FY11 Ar T3 8 12 2010 EXACCA1725 PUNIV UONDA 11250 511015 ISGEN 53 00 xl 8 17 2010 APV0041580 PUNIV UONDA 11250 513780 ISGEN 4200 11 311 85 FY11 Ar 8 25 2010 APVO042110 PUNIV UONDA 11250 511001 ISGEM 118 34 CAFE HF Hz 8 25 2010 APwv0042110 PUNIV UONDA 11250 511001 ISGEM 97 55 BUDGET 8 25 2010 APVO042110 PUNIV UONDA 11250 511025 ISGEN 4300 193 40 SOUTHV pe S202010 APVO042110 PUNIV UONDA 11250 515001 ISGEN 778 37 DMI DE P S252010 APV0042110 PUNIV UONDA 11250 515001 ISGEM 1 807
31. n only OPU CONVERSION Conversion Only OpU Deferred gifts OpU Deferred gifts DAFO9100 BIGGERS DONOR ADVISED FUND Rev Jan 22 ae 2013 DAFO9150 B JOSEPH AND TARI FRAHM ROKUS Simpler 3 0 Reporting uELA uu P VM 32 PEPPERDINE UNIVERSITY Information Technology Operating Units Hierarchy Example PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership A Operating Units Operating Units Code All Operating Units OpU Operational Funds Ed prgs support Level ALL OP UN ALL OP UNI Summarize By Code FOSTER GRANDPARENTS PROGRAM fy Title Rev Jan 22 2013 Simpler 3 0 Reporting 33 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership A Categories a Code ID Title 1ST AID E 34500 FIRST AID SAFETYEQUIP SUPPLIES Catego ries are used for further a aa ADVERTISE 91501 ADVERTISING AGENCY SERVICES defining and grouping of General fi AERALPHO 3577 PHOTOGRAPHS AERIAL Ledger subaccounts for reporting EE Me EAE i 7 AIRFARE 00003 TRAVEL AIRFARE purposes in a Balance Sheet TEE EIE EIE AN FEED E 32500 ANIMALS FEED BEDDING SUPLEMNT t ANIMALS L 4000 ANIMALS LIVE BEES FISH ETC ANTFRZ RE 6099 ANTIFREEZE RECYCLED ANTIFREEZ 6003 ANTIFREEZE o APPLIANCES 99841 APPLIANCES oO APPRAISFEE 99814 APPRAISAL FEE ARCH PROF 90600 ARCHITECTURAL SRVS PROF DESIGN x ARMOREDCA 99
32. nerally relate to P Revenues DUNS information on the balance sheet ae Projects Transaction Details are used for purchasing 9 e and accounts payable information e ask d Payroll Expenses provide for only authorized Ggpetal Ledger Products users a summary or detail report for payroll Vendors Balances User Defined Time Span Transactions Chart of Accounts Tables provides detailed accounting codes Rev Jan 22 2013 Simpler 3 0 Reporting a PEPPERDINE UNIVERSITY Information Technology Query Page Budget Balances Transactions GL Budget Balances can be reported on a fiscal year basis for current operations or for longer periods for projects and grants Strenthening Lives for Purpose Service and Leadership Click on any of the blue links to start a query builder Home gt Query fi Select an option from the choices perf 2 7 E Budget Balances YTD Departmental ransaction Details Transaction Details this re port lists Revenues Requisitions the PO s generated invoices entered Ekpenses A payments made and checks issued Combined Vouchers t Checks Note Transaction detail can also be Budget Balances LTD Grants amp Projects reached by d rilling down from TM Chart of Accounts Tables balance reports Expenses Business Units ean Transactions can be reported for Departments T Acii revenues expenses or combined on F Reven
33. r Home Page AW miei E Each page is bordered with a navigational task bar on the left of the screen The task bar is available at all times from all pages The body of the page will list the available searches or tasks relevant for the particular page that the user is on To go from page to page the appropriate icon on the task bar should be selected A user will know which page they are on by the title on the top left of each page PEPPERDINE UNIVERSITY Information Technology The Query page is divided into several areas Budget Balance reports for revenues expenses and combined Year to date YTD for departmental repo rtin g T Select an option fram the choices below Life to date LTD for grants and projects HER The Revenue and Expenditure pages PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership Home gt Query Budget Balances YTD Departmental Transaction Details Revenues Requisitions generally relate to income statement Expenses Purchase Orders information Combined Vouchers i fz Checks Combined refers to reports that include Budget Balances LTD Grants amp Projects both Revenues and Expenses l u nndis Chart of Accounts Tables Transactions are reports that list the specific eod Business Units revenue or expense postings that have been Combined Funds entered during a specified period ike amme Accounts General Ledger pages ge
34. se Service and Leadership Manage Shortcuts Shortcut 1 ERP PR 11140KK Rev amp Ex ACCOUNTS Acct Dept Fund Adv amp P Area Summary UONDA BASIC EXAMPLE BASIC EX gd PL Save to a new Shortcut name by changing the name and selecting Update Or select Delete to delete the Shortcut 39 PEPPERDINE UNIVER SITY In jorma tion Technology 7 eye es combinedbalances L xls Read Only Microsoft Excel Home Insert Page Layout Formulas Data Review View Add Ins R1 fe e d A B C D E F G H J EJ Revenue and Expenditure Balances YTD F E33 Criteria As Of Original Adjusted Month To Year To Date Year To Date Year To Date Bdot ta Act 3 VALUES Title Budget Budget Date Actual Pre Encumb Encumbrance Variance DEPTDETL2 511185 Connectns to Community Summary Q Expenses F 6 511005 TRAVEL LODGING i vero i a ve ou 7511015 TRAVEL MILEAGE d 8 511025 TRAVEL AIRFARE 9 7511035 TRAVEL GROUND TRANSPORT OT E 511220 STAFF DEVELOP CONFERENCE F 1 1511260 STAFF DEVELOP TRAINING 4 T Total Expenses Total Connectns to Community Summary a JT z combinedbalances csy Read Only Microsoft Excel Home Insert Page Layout Formulas Data Review View Add Ins 617 fe A B C D E F H J K L M N O Departmer Title LINE ITEM Departmer DataSet Account Title YTDAdoBi Y TDBudge MTDActua Y TDActual Y TDPreEn Y TDEncun BdgtActVariance1 1165 ConnectnsExpenses 3
35. tments Accounts Programs Projects Classes Operating Units Categories Products Vendors igru LET LC E tu e F E a The Chart of Accounts Tables display the detailed accounting codes used in the University accounting system Each table is useful in looking up a specific code or title name of an accounting segment or helpful in narrowing a query Each accounting segment can be queried by an accounting level and summarized by a list builder 19 PEPPERDINE UNIVERSITY Information Technology Chart of Accounts Business Unit PEPPERDINE UNIVERSITY Strenthenine Lives for Purpose Service and Leadership PEPPERDINE UNIV Strenthenine Lives for Purpose Service Fund is the Source Home SE Funds of Funding Business Units Business Unit is the FH Code Us x p Code University Entity Code Title ELIMS M All values MRHGP Unrestricted PUARG fs Unrestricted ft PUEMP S Unrestricted UNRESTRICTED Unrestricted PUITA Be pa PULAW Unrestricted Deferred Gifts fx PULON t Unrestricted Deferred Gifts PUNIV UDDAF UNRESTRICTED DAF t PUPAY UR DEFERRED GIFTS Unrestricted Deferred Gifts PUSRF Unrestricted Endowments PUSTU e Unrestricted Endowments o PUWEI y UEQUA UNRESTR QUASI ENDOWMENT o PUWPI UETEN UNRESTRICTED TRUE ENDOWMENT UR ENDOWMENTS Unrestricted Endowments Rev Jan 22 2013 Simpler 3 0 Reporting PUWSI Unrestricted Grants Unrestricted Grants UGCTY
36. ues Programs i one report Projects 0 Expenses BE Classes Combined Q9 Operating Units General Ledger pages generally Categories General Ledger ee relate to balance sheet information X Balances Vendors Balances User Defined Time Span Transactions Rev Jan 22 4 2013 Simpler 3 0 Reporting 7 PEPPERDINE UNIVERSITY Information Technology Report Option Fields As Of specifies a date Summarized By shows that PEPPERDINE UNIVERSITY Shosthening Lives for Purpose Service and Leadership expenses and revenues can be Home reported at different levels for fi Revenue and Expenditure Balances YTD B Go each of the chart of account fields E i As OF Today Page Break creates a designated summarize By page break in the report A P Break None Selection Criteria makes each Ed MALLA B O resulting report somewhat unique gt Selection Criteria Hide by specifying Chartfield values ay Business Unit using the Simpler Wildcard Fund options Department Account PEPPERDINE UNIVERSITY EM uu Strenthening Lives for Purpose Service and Lead ship 0 Program 9 Product Transaction Details x Project Requisitions Purchase Orders z Oper Unit Vouchers Checks Budget Balances LTD Grants amp Projects Chart of Accounts Table Revenues Business Units 7 Jana 2013 Simp
37. y E Criteria As Of 10 30 2012 Summarize By VALUES MAJOR AREA VALUES CATEGORY LINE ITEM VALUE Year To Date Page Break By Fund at VALUES EH a Product Title Actual Py uuncduu dE eMe EIE LEE D rt t MAJOR AREA fi NM gt VALUES UPPRJ UNRESTR PLANT FOR PROJECTS Selection Criteria Department VALUES i Tiar hit p e CATEGORY aa r MAJOR AREA 11140KK Vice Provost for Research T Account x uNE4JTEM m VALUES 11190 IT ERP Class values mE All values t snes Product Product EE E Account gt ips A a p VALUES 515130 SUPPLIES OFFICE CI i E a a OK VALUES ISGEN INST SUPPT GENERAL o 3005 USER DEFINED 103 41 Product 3005 PF Total INST SUPPT GENERAL 103 41 p Project a Total SUPPLIES OFFICE 103 41 Total Expenses 103 41 Total All values 103 41 x Total IT ERP 103 41 Total Vice Provost for Research 103 41 Total UNRESTR PLANT FOR PROJECTS 103 41 Total 103 41 Rev Jan 22 2013 Simpler 3 0 Reporting 13 PEPPERDINE UNIVERSITY Information Technology PEPPERDINE UNIVERSITY Strenthening Lives for Purpose Service and Leadersinp Home fi Revenue and Expenditure Balances YTD E Criteria As Of 10 30 2012 q VALUES Title VALUES UONDA UNRESTR OPER NONDESIG ACTIV fi DEPARTMENT 510115 Athletic Extnl Relatns Summary Expenses T 516700 TELEPHONE EXPENSE POOL 516705 TELEPHONE EXP LOCAL amp I ONG DIST Ei 516710 TELEPHONE EXPENSE CELLULA

Simpler 3.0 Reporting - Pepperdine Community

Contents

Download Pdf Manuals

Related Search

Related Contents