Financial Advisory Services & Training
Financial Services Department
www.finance.utoronto.ca/fast
Last Modified: 18 March 2015 Page 1 / 12
Work Instruction
Budget Movement Report For Fund Centers ZFTR055
When to Use
This report is used to view the budget activity and totals for Funds Centers. Report Functionality
Report can be run for individual or multiple Funds Centers and can be restricted by Funds Center Classification, Commitment Item, fiscal year or budget transaction date.
Provides a summary display of budget activity based on budget transaction type (i.e. Original Budget, Supplements, Returns, Transfers Sent, Transfers Received and Carry Forward) or an optional line item detail display.
Drill down functionality allows users to see budget line items that support the summary total. Report can be sorted, sub-totaled, filtered and downloaded to Excel. Following link details the
Line Item Functionality
http://www.finance.utoronto.ca/Assets/Finance+Digital+Assets/qrg/reporting/common/lifunc.p df
Report Output
Summary View Line item detail View
Funds Center Entry Document
Funds Center Description Line
Commitment Item Year
Commitment Type Budget Type
Original Budget Funds Center
Supplements Commitment Item
Returns Amount
Transfers Sent User
Transfers Received Created on
Carryforward Received/Sent Header Text
Total Budget Text
Menu Path
Accounting >> Funds Management >> Information System >> Funds Management Section (UofT Reports) >> Budget Analysis Reports >> Budget Movement Report for Fund Centers Transaction Code
Helpful Hints
This report is only used to report on Funds Centers (FC’s). To report on funds use the Budget Movement Report for Funds.
The QRG for ZFTR055_Funds can be found at the following link:
http://www.finance.utoronto.ca/Assets/Finance+Digital+Assets/qrg/reporting/budgetanalysis/bdgtm vrptfunds.pdf
Last Modi
Detailed
1. Sta
SAP Eas
2. Do
Budget M
fied: 18 March Procedure art the transac
sy Access
uble-click
Movement R
h 2015
ction using the
University o
Report for F
e menu path
of Toronto M
Fund Cente
Finan
F
or transaction
Menu
ers
ncial Adviso
Financial Se
www.finan
n code.
ory Services
ervices Depa
ce.utoronto.ca
& Training
artment
/fast
Page 3 / 1
g
3. Complete the following as required:
Field Name Required/
Optional/ Conditional
Description
FM Area Required Defaults to UofT.
Fiscal Year Required The UofT fiscal year is May 1st to April 30th and the Year is coded as follows: Year = the "annual" year in effect at April 30th (i.e. May 1st, 2006 to April 30th, 2007 is identified as "2007" fiscal year).
Budget Version Required Version “0” is the current budget version and reflects all processed changes to budget.Version “1” is the original budget version and reflects original operating budgets at the beginning of the fiscal year. If the field is left blank, the report will default to version zero.
Funds Center Classification
Optional FIS code used to distinguish and identify Operating fund versus Ancillary fund accounts.
Funds Center Required A six digit code, starting with “1” or “2” used to record the funding and spending transactions for financial activity reported on a fiscal year basis. (i.e. operating, ancillary, etc.) Include Funds Center
Hierarchy
Optional Checking this box indicates that you want to include all the FC’s that are listed below the parent account.
Last Modi In Ce Ex Ce Co Co H FB BC D Do Se Do M Se Li Su Li
4. Clic Report La
fied: 18 March Field Nam cluding Fund enter xcluding Fund enter ommitment It ommitment It ierarchy BS CS isplay Migrate ocuments eparately o not display igrated Docu eparately
ne item entry
ummary
ne Item
ck ayout Options
h 2015
me Req
Op Con s Op ds Op em Op em Op Con Con ed Con ments Con
y date Op
Con
Con
s: A.) Summa
B.) Line item quired/
tional/ ditional ptional Allow
Cen ptional Allow
Cen ptional An a
sum budg SPE base ptional Che CI’s nditional Form docu mon nditional Bud repo end nditional Sele sepa nditional Sele stan ptional Doc nditional Sele all tr nditional Sele tran ary View m detail View
Finan
F
ws users to s nters to includ ws users to s nters to exclud
alphabetic cod mmary reportin get dollars fo ECIALS, etc. w
ed on G/L acc ecking this box listed below mer Budget S uments proce nth end) budg get Control S orts. This will and onwards ecting this dis arate column
ecting this inc ndard budget
cument entry d This date
the end u ecting this wil ransactions. ecting this wil
sactions. w
ncial Adviso
Financial Se
www.finan Descselect single, m de.
select single, m de.
de used to (1 ng purposes; r special purp within a Fund count used, m x indicates th
this level. System. Sele
essed up to a get details/tota System. This i
l give budget s.
splays the mig (Fiscal Year
cludes the mig columns (Fis
date.
e will override user to specif l provide the
l provide the
ory Services
ervices Depa
ce.utoronto.ca
cription
multiple or a
multiple or a
) group simila i.e. Supplies pose spendin ds Center or F maybe overwr hat you want t
ct if historical nd including O als are requir is the default totals as at O
grated budget 2007 only).
grated budget scal Year 200
e the fiscal ye fy period of an
user with a su
user with a vi
& Training
artment
/fast
Page 5 / 1 range of Fund
range of Fund
ar g/l account and (2) segre g; i.e. EXP-U Fund. Default
ritten. to include all t
l (pre-upgrade October 2006 ed.
selection for October 2006
t documents i
t documents 7 only).
ar entry and a nalysis. ummarized vi
iew of all indiv
g
12 ds ds ts for egate TFA, ts the e, i.e. 6 all month in a in the allows iew of vidualA.) Summary View
Column Description
CFC Commitment Funds Center number
CFC Description Commitment Funds Center description
Com. Item Commitment Item name
C Commitment Item Category.
2 - Revenue 3 - Expense
Original Budget Original Budget entered at the start of the fiscal year.
Supplements Budget supplements.
Returns Budget Returns
Transf. Sent Budget transfers sent
Transf. Rec’d Budget transfers received
CWD Rec/Sen Carryforward budget received or sent
Financial Advisory Services & Training
Financial Services Department
www.finance.utoronto.ca/fast
Last Modified: 18 March 2015 Page 7 / 12
Report can be edited (sorted, sub-totaled, filtered etc.) using the icons on the reporting tool bar at the top of the report. For details on Line Item Functionality click:
Drill Down Functionality
To drill down and see the supporting budget document line items, double click on any budget amount or total.
Example: Double-click
Financial Advisory Services & Training
Financial Services Department
www.finance.utoronto.ca/fast
Last Modified: 18 March 2015 Page 9 / 12
Double click on the Total Budget Amount $2,031.00 to go to Line item detail View directly without exiting the report.
OR
To see the entire report as a line item view initially rather than drilling down, choose Line Item instead of Summary on the initial screen to get the following view:
B.) Line Item View
To drill down and see a specific budget document, single click on the entry document number.
Last Modi
Budget E
To see wh
fied: 18 March
Entry Docu
ho posted the tab
h 2015
ment - Head
e budget docu b.
der
ument and the
Finan
F
e date and tim
ncial Adviso
Financial Se
www.finan
me it was pos
ory Services
ervices Depa
ce.utoronto.ca
ted click on th
& Training
artment
/fast
Page 11 / 1 he
g
Budget E
5. Clic
End of p
Resource Referenc L ht Z ht m Entry Docu
ck .to retu
procedure.
e Information
Contact function ce Guides:
ine Item Func ttp://www.fina
FTR055_FUN ttp://www.fina mvrptfunds.pdf
ment - Add
urn to the pre
n:
your FAST te
. http://www.f
ctionality ance.utoronto
NDS - Budget ance.utoronto f itional Data evious screen eam represen finance.utoron .ca/Assets/Fin t Movement R .ca/Assets/Fin a
.
ntative for add nto.ca/fast/co
nance+Digita Report for Fun
nance+Digita ditional instru ontacts.htm al+Assets/qrg/ nds al+Assets/qrg/
ctions on how
/reporting/com
/reporting/bud
w to use this
mmon/lifunc.p
dgetanalysis/ pdf