ࡱ> <>;_ *bjbjPP 4.y:<\y:<\*&&4$4 j     $!T$      $Eg  04 $$6$4 $&> d: DETAIL SHEET INSTRUCTIONS The divisions will have approximately 10 days to complete their management reports and submit them to the Budget Office after month end reports post. Financial Systems will distribute to all ϰϲʿ¼ Banner Finance users the following reports on approximately the 10th of each month; you will be specifically notified if a management report submittal is required. Level 5 expense summary lv5exp = Report lists all expense budget, year to date activity and encumbrances Level 5 revenue summary lv5rev = Report lists all revenue budget and year to date activity The first step at the department level is to review these reports for accuracy and reconcile to the departments soft ledgers. Also look for fund/org mismatches. (ϰϲʿ¼ fund with another campus or dept org) Detail tab entry instructions: Date: Enter the day, month and year for the reporting month on the extreme upper right section of the Detail Sheet (Example "For the period ending 31-Jan-15 ") Below the Expenditure heading column: Enter the department organization number, fund and account title. (Sample denotes Org/Object & Description) Expenditure section Columns C, E & F: Adjusted Budget, Year to Date Activity and Budget reservations The data for these columns can be updated using the macro installed in the management report template and should balance with the Web Expense Summary totals. Column D: Budget Revision This column is solely for budget transfers between or within your departmental accounts for revisions not yet posted in Banner. If you are moving budget that requires increases in total revenue, or transfer between NCHEMS (program code categories IN/RR/PS), you must reflect the revision in both the expenditure & revenue sections. Budget revisions must be equal amounts on the revenue and expense totals. Column G: Expenditure Adjustment Enter only expenditure corrections for charges to the account in error (journal vouchers or labor transfers in process to other accounts such as restricted accounts). Column H: Projected Exp to Year End Personal services and benefits will transfer automatically from the payroll tab. No entry is required in the personal services or benefits cells. Project by object code, all future expenditure commitments: travel, contractual, commodities, resale (auxiliary accts only), equipment, financial aid, overhead and miscellaneous expenditures. Columns I & J: Total YTD & Projections, and Projected Balance at Year End These columns have formulas and entry is not required. Revenue Section Columns N & P: Adjusted Budget, Year to Date Activity The data for these columns is updated using the macro installed in the management report, it feeds from Web Revenue Summary data. Column O: Budget Revision This column is solely for budget transfers between or within your departmental accounts for revisions not yet posted in Banner. If you are moving budget that requires increases in total, or transfer between NCHEMS (program code categories IN/RR/PS), you must reflect the revision in both the expenditure & revenue sections. Budget revisions must be equal amounts on the revenue and expense totals. Column Q: Revenue Adjustment Enter only corrections for revenue to the account processed in error (journal vouchers or labor transfers in process, to other accounts such as restricted accounts). Column R: Projected to Year End Enter projected additional revenue expected to be received, by revenue source. (Revenue source means if you project revenue from a miscellaneous category, enter the projection on the Detail sheet under Other 93/94/95/98. If your revenue projection is from indirect/overhead recovery enter under Overhead 9802) Columns S & T: Total YTD & Projections, and Projected Balance at Year End: These columns have formulas and entry is not required. Column V: Net Under/Over Budget: This column has a formula and entry is not required. This total identifies the overall picture of how your account stands. If the amount is negative, you projecting a deficit If the amount is positive, you are projecting unspent/unencumbered funds (AHlmnqw} !   ѹѹѪzh[zhhACJOJQJ\aJ"hJ`{hL5CJOJQJ\aJ"hJ`{h>T[5CJOJQJ\aJh??h??CJOJQJaJhJ`{h>T[CJOJQJaJhJ`{hLCJOJQJaJh$ ,CJOJQJaJhw|aCJOJQJaJh??hw|aCJOJQJaJhJ`{h??CJOJQJaJ hJ`{hL0JCJOJQJaJ O P   > D  t u x $[$\$a$gd?? [$\$gd>T[ [$\$gd?? [$\$gdw|a$[$\$a$gd>T[    P    < = > C  0 6 r t u ҷåғҷҷ҄҄ғqbP"hJ`{h#=w5CJOJQJ\aJh?5CJOJQJ\aJ%hJ`{hL5>*CJOJQJ\aJhJ`{h#=wCJOJQJaJ"hJ`{hL5CJOJQJ\aJ"hJ`{h>T[5CJOJQJ\aJhACJOJQJaJhJ`{h>T[CJOJQJaJhJ`{hLCJOJQJaJhACJOJQJ\aJ"hJ`{h??5CJOJQJ\aJ ? w y  <Olrt{-./068PοwwwgXwh$ ,hLCJOJQJaJh$ ,h$ ,CJOJQJ\aJh$ ,CJOJQJaJhJ`{h??CJOJQJaJhACJOJQJaJhJ`{hLCJOJQJaJ"hJ`{h#=w5CJOJQJ\aJhJ`{h#=wCJOJQJaJhJ`{h??CJOJQJ\aJhJ`{h#=wCJOJQJ\aJ"hJ`{hL5CJOJQJ\aJ"x y .0Qqr@ [$\$^@ `gd??$[$\$a$gdw|a [$\$gdw|a [$\$gd>հ&/4ӣӯ%󴳸5>*䴳ϴa󴳸䴳ϴ[䴳ϴɴ䴳ϴ䴳ϴ䴳ϴ"󴳸5Cϴa"󴳸#=5Cϴa󴳸#=䴳ϴ󴳸??䴳ϴ󴳸䴳ϴ<=XZ@XYZ\#ݼݼtteYeYeYeh$ ,CJOJQJaJhJ`{h$ ,CJOJQJaJhACJOJQJaJhJ`{h#=wCJOJQJaJhJ`{h??CJOJQJ\aJhACJOJQJ\aJhJ`{h#=wCJOJQJ\aJhJ`{hLCJOJQJaJ"hJ`{h#=w5CJOJQJ\aJ"hJ`{hL5CJOJQJ\aJhJ`{h??>*CJOJQJaJ=Z\#mn23S1 /e [$\$gd?? [$\$gd$ , [$\$gd#=w [$\$gd>T[#lmntv39;R"01   .de()*ѿwshM2h$ ,CJOJQJaJh}CJOJQJaJhJ`{h??CJOJQJaJhJ`{hLCJOJQJaJ"hJ`{h??5CJOJQJ\aJ"hJ`{hL5CJOJQJ\aJhJ`{h#=wCJOJQJaJh$ ,h$ ,CJOJQJaJh$ ,h$ ,CJOJQJ\aJ-)*gd>T[[$\$`gd}21h:p??/ =!"#$% s2&6FVfv2(&6FVfv&6FVfv&6FVfv&6FVfv&6FVfv&6FVfv8XV~ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@ 0@_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH DA D Default Paragraph FontRiR  Table Normal4 l4a (k (No List B^@B L Normal (Web)dd[$\$*W`* LStrong5\HH [h Balloon TextCJOJQJ^JaJN/!N [hBalloon Text CharCJOJQJ^JaJPK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VvnB`2ǃ,!"E3p#9GQd; H xuv 0F[,F᚜K sO'3w #vfSVbsؠyX p5veuw 1z@ l,i!b I jZ2|9L$Z15xl.(zm${d:\@'23œln$^-@^i?D&|#td!6lġB"&63yy@t!HjpU*yeXry3~{s:FXI O5Y[Y!}S˪.7bd|n]671. tn/w/+[t6}PsںsL. J;̊iN $AI)t2 Lmx:(}\-i*xQCJuWl'QyI@ھ m2DBAR4 w¢naQ`ԲɁ W=0#xBdT/.3-F>bYL%׭˓KK 6HhfPQ=h)GBms]_Ԡ'CZѨys v@c])h7Jهic?FS.NP$ e&\Ӏ+I "'%QÕ@c![paAV.9Hd<ӮHVX*%A{Yr Aբ pxSL9":3U5U NC(p%u@;[d`4)]t#9M4W=P5*f̰lk<_X-C wT%Ժ}B% Y,] A̠&oʰŨ; \lc`|,bUvPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!R%theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] *. #* x *8@0(  B S  ?,,uu<Olrtt{/mnp p q q   X Z @ X Y Z \ m "((),uu<Olrtt{/mnp p q q   X Z @ X Y Z \ m "((,\g|\gdd0/fk)6K8c i Ha # Ui ES p ( W, iTC13g]&iK}V:{chX_,HFAS8j~#%: <u{Ta)VXl|@ ^!K"7#dt#]$%v%-)&Y'EE(P(N)[*5+$ , d.si.Gs012L2.3?:3ff35Z<5#]5w5 6v6Q7Ws9R&<M=fb= >@(@M@P2ArNAQBHCsOC D#qE(FkFJG}GmJNKQMF?MNSNwN5OSq U U?VW0WjLXYLYeJZ[>T[#U[`y[S-]w|aLcdWdje7h[hSVi[id`i{kFmdmQ/nqKn+oDojoqo pbpnUrE\rE2sD/tctdltLptQuuW+uv%w#=wxNxHzozL{J`{8c{z{kU|n| }??0uD`/@YI 0B3VJ"? ^6PoB'<9hR#vY9a%]7?J^Hkc  mH?'rvwiF?6(=Puhx+I70X `f49eM2LRi EV bEg'<2@FBu3+Nk)V5H KSasyAPp fQl]kWPa}x. ^'a|Dt/ ")'DIs 3w>N|`x~(Z d@?\cLSR \V*,@*@UnknownG*Ax Times New Roman5Symbol3. *Cx Arial7.@Calibri9. ")Segoe UIA$BCambria Math"h(g8G8Gi i !r4""3QHP ?L2!xx DETAIL SHEET INSTRUCTIONS Brian deZeeuw Rhoda A BrownOh+'0 (4 T ` l xDETAIL SHEET INSTRUCTIONSBrian deZeeuwNormalRhoda A Brown7Microsoft Office Word@b@̚J@e E@fgi ՜.+,0 hp   ϰϲʿ¼" DETAIL SHEET INSTRUCTIONS Title  !"#$%&'()*,-./012456789:=Root Entry FVg?1Table$WordDocument4.SummaryInformation(+DocumentSummaryInformation83CompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q