Financial Management and Budgeting Practices at AALC

 
AALC Budget and Finance
Q & A
 
 
Office of the Controller/Budget Office
 
Workshop Presenters
 
Debra Glenn
Assistant Vice President for
Business Services/Controller
801-957-4084
 
Travis Kartchner
Associate Controller/Treasurer
801-957-4224
 
Sean Clayton
Assistant Controller
801-957-4676
 
Ben Booth
Assistant Controller
801-957-4223
 
 
Brandon Thomas
Director, Purchasing & Accounts Payable
801-957-4255
 
Michelle Cahoon
Senior Accountant
801-957-4656
 
Brooke Jensen
Internal Controls Analyst
801-957-5837
 
Jillana AhLoe
Budget Director
801-957-4149
 
A Budget Center Manager (BCM) is a special designation that
means acceptance of financial empowerment and accountability.
Generally, only administrator/manager level positions are BCMs.
BCMs act prudently in ALL financial matters to protect College
interests.
BCM accountability cannot be delegated, but Administrative
Assistants assist the BCM in fulfilling their role by performing
financial related tasks.
BCM financial duties and responsibilities (handout).
 
        BCM Basics
Budget and Business Cycle
 
The 
fiscal year generally follows the academic year.
 
College fiscal year is July 1 – June 30
Fiscal year 2023 (FY23): July 1, 2022 through June 30, 2023
 
Summer semester is split between two fiscal years.
 
 
 
Budget
 
and
 Business 
Cycle
 
 
Budget Creation and Disbursement
 
A
p
p
r
o
p
r
i
a
t
e
d
 
F
u
n
d
s
 
Generally ALPHA indexes
Approved by Cabinet
Established by the Budget
Office
 
O
t
h
e
r
 
F
u
n
d
s
 
Generally NUMERIC indexes
Fee based
Sales
Grants
Donations
Departments responsible for
budget set up in August
(yellow form)
 
B
u
d
g
e
t
 
O
f
f
i
c
e
w
e
b
s
i
t
e
 
>
>
 
B
u
d
g
e
t
 
T
r
a
i
n
i
n
g
&
 
R
e
s
o
u
r
c
e
s
 
>
>
 
A
d
d
i
t
i
o
n
a
l
R
e
s
o
u
r
c
e
s
 
>
>
 
H
o
w
 
t
o
 
s
e
t
 
u
p
i
n
i
t
i
a
l
 
b
u
d
g
e
t
 
f
o
r
s
e
l
f
-
s
u
p
p
o
r
t
i
n
d
e
x
e
s
Budget and Finance Best Practices
 
Source and Use of Funds
Why is this important?
 
Journal Entries
Why?
When?
 
Nonsufficient Fund Flag (NSF)
When is it turned on?
 
Controller Memos
 
 
 
 
 
 
 
 
Tools
 
Banner
FGIBAVL
FGIBDST
FGITRND
FGIOENC
FGRODTA
Controller's Office staff
AskAController
@slcc.edu
ServiceNow
 
SLCCBuy
Chrome River
Etrieve
Training materials
Budget Availability Report
Budget Office staff
BudgetOffice@slcc.edu
 
 
 
Checklist Handout
 
Checklist
 
Daily/Weekly
Login to SLCCBuy to submit or approve requisitions.
 
Monthly
Review FGIBAVL or Banner Budget Availability Report
 
 
 
 
Budget Availability Report
Checklist
 
Daily/Weekly
Login to SLCCBuy to submit or approve requisitions
 
Monthly
Review FGIBAVL or Banner Budget Availability Report
Review FGIBDST and FGITRND or FGRODTA
Review open encumbrance list in FGIOENC
Complete p-card expense reports in Chrome River
 
Checklist
 
Yearly
Set up budgets for numeric indexes only
Submit IBP requests to the IBP portal
 
As Needed
Request journal entries from the Controller's Office
 (Can take up to 10 days)
Submit or approve budget transfers in Etrieve
 (Can take up to 10 days)
 
 
 
Financial Data
 
What do the numbers mean?
Index Codes
Alpha (BBBOFF) - E&G Funded
Numeric – Self Sustaining
Account Codes
50000-59999 – Revenue
60000-69999 – Payroll Expenses
70000-79999 – Current Expenses
90000 – Travel Expenses
94000 – Capital Expenses (unit cost of $5,000+)
 
Financial Data
 
Budget
s
Established on the top level account
60000 – Salaries Budget
65000 – Benefits Budget
70000 – Current Expense Budget
90000 – In State Travel Budget
94000
 – Capital Expenses (unit cost of $5,000+)
 
 
Encumbrances that roll from previous fiscal year show up as budget on
the same account the encumbrance is on.
 
 
 
Budget
Reports
 
F
G
I
B
A
V
L
 
 
s
h
o
w
s
 
b
u
d
g
e
t
a
v
a
i
l
a
b
i
l
i
t
y
 
f
o
r
 
a
n
 
i
n
d
e
x
 
b
y
b
u
d
g
e
t
 
c
a
t
e
g
o
r
i
e
s
 
(
f
o
r
e
x
p
e
n
s
e
s
 
o
n
l
y
)
 
F
G
I
B
D
S
T
 
 
s
h
o
w
s
 
b
u
d
g
e
t
a
v
a
i
l
a
b
i
l
i
t
y
 
f
o
r
 
a
n
 
i
n
d
e
x
 
b
y
a
c
c
o
u
n
t
s
 
(
f
o
r
 
r
e
v
e
n
u
e
 
&
e
x
p
e
n
s
e
s
)
FGIBAVL  vs.  FGIBDST
F
G
I
B
A
V
L
 
Total/Summary by “Budget Roll-Up Category”
(excludes Revenue Budget category)
  
       
 
        
YTD Column
  
60000
  
62000
  
65000
  
70000
  
$ 6,250
  
90000
  
90100
F
G
I
B
D
S
T
 
Total/Summary info by Account #
 
  
      YTD Column
 
70405
  
$    250
 
70445
  
$ 1,500
 
70455
  
$    100
 
70460
  
$ 2,700
 
73070
  
$ 1,000
 
7xxxx etc.
 
$    700
Total of 70000’s
 
$ 6,250
F
G
I
B
D
S
T
F
G
I
B
A
V
L
 
S
a
m
e
 
B
u
d
g
e
t
 
I
n
f
o
r
m
a
t
i
o
n
F
G
I
B
D
S
T
F
G
I
B
A
V
L
S
a
m
e
 
d
a
t
a
 
b
u
t
c
a
t
e
g
o
r
i
z
e
d
 
b
y
 
a
c
c
o
u
n
t
E
x
p
e
n
s
e
s
 
&
c
o
m
m
i
t
m
e
n
t
s
 
b
y
 
b
u
d
g
e
t
c
a
t
e
g
o
r
y
F
G
I
B
D
S
T
F
G
I
B
A
V
L
T
h
e
 
s
u
m
 
o
f
 
e
a
c
h
 
b
u
d
g
e
t
w
i
t
h
 
i
t
s
 
c
o
r
r
e
s
p
o
n
d
i
n
g
a
c
c
o
u
n
t
s
 
e
q
u
a
l
s
 
e
a
c
h
a
v
a
i
l
a
b
l
e
 
b
a
l
a
n
c
e
A
v
a
i
l
a
b
l
e
 
b
a
l
a
n
c
e
s
 
b
y
b
u
d
g
e
t
 
c
a
t
e
g
o
r
y
 
General Accounting and Budget Forms in Banner
 
F
G
I
B
A
V
L
 
(
B
u
d
g
e
t
 
A
v
a
i
l
a
b
i
l
i
t
y
 
S
t
a
t
u
s
 
F
o
r
m
)
Displays the following information by budget category:
Budget amounts (for expense categories only)
YTD activity (posted transactions)
Commitments (unposted transactions)
Available balances
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
 
n
e
e
d
 
a
 
h
i
g
h
-
l
e
v
e
l
 
o
v
e
r
v
i
e
w
 
o
f
 
h
o
w
 
m
u
c
h
 
o
f
 
e
a
c
h
e
x
p
e
n
s
e
 
b
u
d
g
e
t
 
y
o
u
 
h
a
v
e
 
a
v
a
i
l
a
b
l
e
 
t
o
 
s
p
e
n
d
 
f
r
o
m
 
a
n
 
i
n
d
e
x
.
 
F
o
r
m
-
s
p
e
c
i
f
i
c
 
t
h
i
n
g
s
 
t
o
 
r
e
m
e
m
b
e
r
:
1.
Enter 60000 in the Account parameter.
2.
Positive available balances are good; Negative available balances are BAD!
3.
Exportable to Excel.
 
FGIBAVL Parameters Example
 
 
 
General Accounting and Budget Forms in Banner
 
 
F
G
I
B
D
S
T
 
(
O
r
g
a
n
i
z
a
t
i
o
n
a
l
 
B
u
d
g
e
t
 
S
t
a
t
u
s
 
F
o
r
m
)
Displays the following information:
Budget category amounts (for revenue & expense categories)
YTD activity (posted transactions) by account
Commitments (unposted transactions) by account
Available balances (by summing the account amounts to their corresponding budget amounts)
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
r
 
B
C
M
 
n
e
e
d
s
 
a
 
h
i
g
h
-
l
e
v
e
l
 
o
v
e
r
v
i
e
w
 
o
f
 
h
o
w
 
m
u
c
h
 
o
f
 
e
a
c
h
r
e
v
e
n
u
e
 
a
n
d
 
e
x
p
e
n
s
e
 
b
u
d
g
e
t
 
y
o
u
 
h
a
v
e
 
a
v
a
i
l
a
b
l
e
 
t
o
 
s
p
e
n
d
 
f
r
o
m
 
a
n
 
i
n
d
e
x
.
 
F
o
r
m
-
s
p
e
c
i
f
i
c
 
t
h
i
n
g
s
 
t
o
 
r
e
m
e
m
b
e
r
:
1.
After you sum the account amounts to their corresponding budget amounts,
positive available balances are good; Negative available balances are BAD!
2.
Exportable to Excel.
FGIBDST Parameters Example
 
 
 
General Accounting and Budget Forms in Banner
 
F
G
I
T
R
N
D
 
(
D
e
t
a
i
l
 
T
r
a
n
s
a
c
t
i
o
n
 
A
c
t
i
v
i
t
y
)
Displays transaction details such as: amount, transaction date, description, etc.
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
 
n
e
e
d
 
m
o
r
e
 
d
e
t
a
i
l
s
 
t
o
 
r
e
s
e
a
r
c
h
 
t
h
e
 
a
m
o
u
n
t
s
 
f
r
o
m
F
G
I
B
D
S
T
 
i
n
 
e
a
c
h
 
a
c
c
o
u
n
t
.
 
F
o
r
m
-
s
p
e
c
i
f
i
c
 
t
h
i
n
g
s
 
t
o
 
r
e
m
e
m
b
e
r
:
1.
Access FGITRND by F3
2.
Transactions that cause revenue or expenses to grow display as increases (+) to their corresponding
accounts. However, an increase in expenses reduces your budgeted expenses.
3.
Field column
YTD = Posted transactions
OBD = Budget carryforwards
ENC = Encumbrances (Unposted transactions)
4.
Exportable to Excel.
 
FGITRND Example
 
 
 
General Accounting and Budget Forms in Banner
 
 
F
G
R
O
D
T
A
 
(
O
r
g
a
n
i
z
a
t
i
o
n
 
D
e
t
a
i
l
 
A
c
t
i
v
i
t
y
)
Displays transaction details such as: amount, transaction date, description, etc. It is the same data
that is shown in FGITRND but in a report-style format.
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
 
w
o
u
l
d
 
l
i
k
e
 
t
o
 
s
e
e
 
t
r
a
n
s
a
c
t
i
o
n
 
d
e
t
a
i
l
s
 
f
o
r
 
e
a
c
h
 
a
c
c
o
u
n
t
 
i
n
 
a
r
e
p
o
r
t
 
f
o
r
m
a
t
.
 
R
e
p
o
r
t
-
s
p
e
c
i
f
i
c
 
t
h
i
n
g
s
 
t
o
 
r
e
m
e
m
b
e
r
:
1.
How to run FGRODTA
2.
Exportable to Word and Excel.
How to export the FGRODTA report to Excel
 
FGRODTA Parameters Example
 
 
General Accounting and Budget Forms in Banner
 
 
B
a
n
n
e
r
 
B
u
d
g
e
t
 
A
v
a
i
l
a
b
i
l
i
t
y
 
R
e
p
o
r
t
 
(
F
W
R
B
B
A
9
)
Base budget including permanent transfers
Revised budget including temporary transfers
YTD Expenditures
Encumbrances
Available balances
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
 
n
e
e
d
 
a
 
h
i
g
h
-
l
e
v
e
l
 
o
v
e
r
v
i
e
w
 
o
f
 
a
n
 
i
n
d
e
x
s
 
b
u
d
g
e
t
e
d
 
v
s
 
a
c
t
u
a
l
 
r
e
v
e
n
u
e
s
a
n
d
 
e
x
p
e
n
s
e
s
.
 
R
e
p
o
r
t
-
s
p
e
c
i
f
i
c
 
t
h
i
n
g
 
t
o
 
r
e
m
e
m
b
e
r
:
1.
Emailed to BCMs at the beginning of each month
2.
Understanding your Banner Budget Availability Report (FWRBBA9)
 
Encumbrances
 
What is an encumbrance?
Reservation or commitment of funds for future payments
When is an encumbrance created?
SLCCBuy - POs that start with a ‘P’
Non-catalog items and punch-out orders where p-card is not used
P-Card orders create POs that start with a “Q” – Not Encumbered
Payment Requests create POs that are all numbers – Not Encumbered
Chrome River – Travel Pre-Approval – T numbers
When is an encumbrance liquidated/reduced or closed?
As payments are made
EOY Cleanup
Request – Order/item Canceled, final amount less than estimate
purchoff@slcc.edu
 
Encumbrances – Banner - FGITRND
 
 
For each invoice, there are two entries, An ENC entry to reduce the encumbrance and a YTD entry.
 
Encumbrances – Banner FGIOENC
 
 
F
G
I
O
E
N
C
 
(
O
r
g
a
n
i
z
a
t
i
o
n
a
l
 
E
n
c
u
m
b
r
a
n
c
e
 
L
i
s
t
)
Displays open encumbrances on an Index
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
 
n
e
e
d
 
m
o
r
e
 
d
e
t
a
i
l
s
 
r
e
g
a
r
d
i
n
g
 
o
u
t
s
t
a
n
d
i
n
g
 
c
o
m
m
i
t
m
e
n
t
s
 
H
o
w
 
t
o
 
a
c
c
e
s
s
 
i
t
:
 
D
i
r
e
c
t
 
A
c
c
e
s
s
 
o
r
 
t
h
r
o
u
g
h
 
t
h
e
 
O
p
t
i
o
n
s
 
m
e
n
u
 
o
n
 
F
G
I
B
D
S
T
 
H
o
w
 
t
o
 
u
s
e
 
i
t
:
 
I
f
 
u
s
i
n
g
 
D
i
r
e
c
t
 
A
c
c
e
s
s
,
 
e
n
t
e
r
 
I
n
d
e
x
.
 
I
f
 
t
h
r
o
u
g
h
 
F
G
I
B
D
S
T
,
 
n
o
 
i
n
p
u
t
n
e
c
e
s
s
a
r
y
.
 
 
Encumbrances Banner - FGIOENC
 
Types of encumbrances:
P - Purchase Orders. Additional information can be found in SLCCBuy.
T – Travel. Additional information can be found in Chrome River.
PR – Payroll.
 
Encumbrances Banner - FGIENCD
 
Each transaction effecting the encumbrance is listed at the bottom of the form, including adjustments and
invoices/payments. Note there may be multiple lines/items on a single encumbrance. You can scroll through
each item by using the arrow keys on the keyboard.
 
F
G
I
E
N
C
D
 
(
D
e
t
a
i
l
 
E
n
c
u
m
b
r
a
n
c
e
 
A
c
t
i
v
i
t
y
)
Displays encumbrance activity
 
W
h
e
n
 
t
o
 
u
s
e
 
i
t
:
 
W
h
e
n
 
y
o
u
 
n
e
e
d
 
m
o
r
e
 
d
e
t
a
i
l
s
r
e
g
a
r
d
i
n
g
 
a
 
s
p
e
c
i
f
i
c
 
e
n
c
u
m
b
r
a
n
c
e
 
H
o
w
 
t
o
 
a
c
c
e
s
s
 
i
t
:
 
D
i
r
e
c
t
 
A
c
c
e
s
s
 
o
r
 
t
h
r
o
u
g
h
t
h
e
 
O
p
t
i
o
n
s
 
m
e
n
u
 
o
n
 
F
G
I
O
E
N
C
 
H
o
w
 
t
o
 
u
s
e
 
i
t
:
 
I
f
 
u
s
i
n
g
 
D
i
r
e
c
t
 
A
c
c
e
s
s
,
 
e
n
t
e
r
t
h
e
 
e
n
c
u
m
b
r
a
n
c
e
 
n
u
m
b
e
r
.
 
I
f
 
t
h
r
o
u
g
h
F
G
I
O
E
N
C
,
 
n
o
 
i
n
p
u
t
 
n
e
c
e
s
s
a
r
y
.
 
 
Encumbrances Banner – Encumbrance Roll
 
What is the Encumbrance Roll
Encumbrances created in one FY that will not be paid until the next FY.
Both the encumbrance and the budget is rolled.
Occurs around July 15
th
.
 
Details regarding rolled encumbrances can be found on FGIOENC.
 
Encumbrances - SLCCBuy
 
List all Purchase Orders
for department.
 
To list Purchase orders for
a single Index, add Index
as a filter.
 
Encumbrances - SLCCBuy
 
Direct access to a PO
Enter PO number in Quick Search at the
top
All documents related to the PO will be
displayed.
Click on the Purchase Order number.
 
Encumbrances – SLCCBuy
 
Invoice tab will list all invoices entered on the PO.
Under Line Details
Open – amount remaining
Net Invoiced – amount paid
 
Future Trainings
 
Budget & Finance Forum
As needed
 
Biannual BCM and Administrative Assistant Training
Fall and Spring
 
Banner Deep Dive
Spring (Generally April or May)
Questions?
 
Slide Note
Embed
Share

Learn about the financial management practices at AALC, including the roles and responsibilities of key personnel, the Budget Center Manager designation, the budget and business cycle, budget creation and disbursement, and available resources for budget training. Gain insights into how budgets are established, managed, and strategized to align with the academic and fiscal year cycles.


Uploaded on Jul 15, 2024 | 0 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript


  1. AALC Budget and Finance Q & A Office of the Controller/Budget Office

  2. Workshop Presenters Debra Glenn Assistant Vice President for Business Services/Controller 801-957-4084 Debra.Glenn@slcc.edu Brandon Thomas Director, Purchasing & Accounts Payable 801-957-4255 Brandon.Thomas@slcc.edu Michelle Cahoon Senior Accountant 801-957-4656 Michelle.Cahoon@slcc.edu Travis Kartchner Associate Controller/Treasurer 801-957-4224 Travis.Kartchner@slcc.edu Brooke Jensen Internal Controls Analyst 801-957-5837 Brooke.Jensen@slcc.edu Sean Clayton Assistant Controller 801-957-4676 Sean.Clayton@slcc.edu Jillana AhLoe Budget Director 801-957-4149 jillana.ahloe@slcc.edu Ben Booth Assistant Controller 801-957-4223 bbooth7@slcc.edu

  3. BCM Basics A Budget Center Manager (BCM) is a special designation that means acceptance of financial empowerment and accountability. Generally, only administrator/manager level positions are BCMs. BCMs act prudently in ALL financial matters to protect College interests. BCM accountability cannot be delegated, but Administrative Assistants assist the BCM in fulfilling their role by performing financial related tasks. BCM financial duties and responsibilities (handout).

  4. Budget and Business Cycle The fiscal year generally follows the academic year. College fiscal year is July 1 June 30 Fiscal year 2023 (FY23): July 1, 2022 through June 30, 2023 Summer semester is split between two fiscal years.

  5. Budget and Business Cycle July Establish New Year Budgets (alpha indexes) Close Prior Fiscal Year June August - December Year-End Clean Up Establish Numeric Index Budgets Deficit Remediation Strategic Planning and Prioritization New Year Preparation April May January - March IBP Executive Cabinet Review and Final Decisions Legislative Session & Tuition Hearings Informed Budget Process (IBP) Purchasing Deadline

  6. Budget Creation and Disbursement Other Funds Generally NUMERIC indexes Fee based Sales Grants Donations Departments responsible for budget set up in August (yellow form) Appropriated Funds Generally ALPHA indexes Approved by Cabinet Established by the Budget Office

  7. Budget Office website >> Budget Training & Resources >> Additional Resources >> How to set up initial budget for self-support indexes

  8. Budget and Finance Best Practices Source and Use of Funds Why is this important? Journal Entries Why? When? Nonsufficient Fund Flag (NSF) When is it turned on? Controller Memos

  9. Tools Banner FGIBAVL FGIBDST FGITRND FGIOENC FGRODTA Controller's Office staff AskAController@slcc.edu ServiceNow SLCCBuy Chrome River Etrieve Training materials Budget Availability Report Budget Office staff BudgetOffice@slcc.edu

  10. Checklist Handout

  11. Checklist Daily/Weekly Login to SLCCBuy to submit or approve requisitions. Monthly Review FGIBAVL or Banner Budget Availability Report

  12. Budget Availability Report

  13. Checklist Daily/Weekly Login to SLCCBuy to submit or approve requisitions Monthly Review FGIBAVL or Banner Budget Availability Report Review FGIBDST and FGITRND or FGRODTA Review open encumbrance list in FGIOENC Complete p-card expense reports in Chrome River

  14. Checklist Yearly Set up budgets for numeric indexes only Submit IBP requests to the IBP portal As Needed Request journal entries from the Controller's Office (Can take up to 10 days) Submit or approve budget transfers in Etrieve (Can take up to 10 days)

  15. Financial Data What do the numbers mean? Index Codes Alpha (BBBOFF) - E&G Funded Numeric Self Sustaining Account Codes 50000-59999 Revenue 60000-69999 Payroll Expenses 70000-79999 Current Expenses 90000 Travel Expenses 94000 Capital Expenses (unit cost of $5,000+)

  16. Financial Data Budgets Established on the top level account 60000 Salaries Budget 65000 Benefits Budget 70000 Current Expense Budget 90000 In State Travel Budget 94000 Capital Expenses (unit cost of $5,000+) Encumbrances that roll from previous fiscal year show up as budget on the same account the encumbrance is on.

  17. FGIBAVL shows budget availability for an index by budget categories (for expenses only) Budget Reports FGIBDST shows budget availability for an index by accounts (for revenue & expenses)

  18. FGIBAVL vs. FGIBDST FGIBAVL Total/Summary by Budget Roll-Up Category FGIBDST Total/Summary info by Account # (excludes Revenue Budget category) YTD Column Total of 70000 s 70405 70445 70455 70460 73070 7xxxx etc. YTD Column $ 250 $ 1,500 $ 100 $ 2,700 $ 1,000 $ 700 $ 6,250 60000 62000 65000 70000 90000 90100 $ 6,250

  19. F G I B A V L Same Budget Information F G I B D S T

  20. F G I B A V L Expenses & commitments by budget category F G I B D S T Same data but categorized by account

  21. F G I B A V L Available balances by budget category F G I B D S T The sum of each budget with its corresponding accounts equals each available balance

  22. General Accounting and Budget Forms in Banner FGIBAVL (Budget Availability Status Form) Displays the following information by budget category: Budget amounts (for expense categories only) YTD activity (posted transactions) Commitments (unposted transactions) Available balances When to use it: When you need a high-level overview of how much of each expense budget you have available to spend from an index. Form-specific things to remember: 1. Enter 60000 in the Account parameter. 2. Positive available balances are good; Negative available balances are BAD! 3. Exportable to Excel.

  23. FGIBAVL Parameters Example

  24. General Accounting and Budget Forms in Banner FGIBDST (Organizational Budget Status Form) Displays the following information: Budget category amounts (for revenue & expense categories) YTD activity (posted transactions) by account Commitments (unposted transactions) by account Available balances (by summing the account amounts to their corresponding budget amounts) When to use it: When your BCM needs a high-level overview of how much of each revenue and expense budget you have available to spend from an index. Form-specific things to remember: 1. After you sum the account amounts to their corresponding budget amounts, positive available balances are good; Negative available balances are BAD! 2. Exportable to Excel.

  25. FGIBDST Parameters Example

  26. General Accounting and Budget Forms in Banner FGITRND (Detail Transaction Activity) Displays transaction details such as: amount, transaction date, description, etc. When to use it: When you need more details to research the amounts from FGIBDST in each account. Form-specific things to remember: 1. Access FGITRND by F3 2. Transactions that cause revenue or expenses to grow display as increases (+) to their corresponding accounts. However, an increase in expenses reduces your budgeted expenses. 3. Field column YTD = Posted transactions OBD = Budget carryforwards ENC = Encumbrances (Unposted transactions) 4. Exportable to Excel.

  27. FGITRND Example

  28. General Accounting and Budget Forms in Banner FGRODTA (Organization Detail Activity) Displays transaction details such as: amount, transaction date, description, etc. It is the same data that is shown in FGITRND but in a report-style format. When to use it: When you would like to see transaction details for each account in a report format. Report-specific things to remember: 1. How to run FGRODTA 2. Exportable to Word and Excel. How to export the FGRODTA report to Excel

  29. FGRODTA Parameters Example

  30. General Accounting and Budget Forms in Banner Banner Budget Availability Report (FWRBBA9) Base budget including permanent transfers Revised budget including temporary transfers YTD Expenditures Encumbrances Available balances When to use it: When you need a high-level overview of an index s budgeted vs actual revenues and expenses. Report-specific thing to remember: 1. Emailed to BCMs at the beginning of each month 2. Understanding your Banner Budget Availability Report (FWRBBA9)

  31. Encumbrances What is an encumbrance? Reservation or commitment of funds for future payments When is an encumbrance created? SLCCBuy - POs that start with a P Non-catalog items and punch-out orders where p-card is not used P-Card orders create POs that start with a Q Not Encumbered Payment Requests create POs that are all numbers Not Encumbered Chrome River Travel Pre-Approval T numbers When is an encumbrance liquidated/reduced or closed? As payments are made EOY Cleanup Request Order/item Canceled, final amount less than estimate purchoff@slcc.edu

  32. Encumbrances Banner - FGITRND Field ENC Type E100 Establish Travel Encumbrance PORD Establish Purchase Order INEI Invoice liquidation E032 Final liquidation INEI Invoice against Encumbrance YTD For each invoice, there are two entries, An ENC entry to reduce the encumbrance and a YTD entry.

  33. Encumbrances Banner FGIOENC FGIOENC (Organizational Encumbrance List) Displays open encumbrances on an Index When to use it: When you need more details regarding outstanding commitments How to access it: Direct Access or through the Options menu on FGIBDST How to use it: If using Direct Access, enter Index. If through FGIBDST, no input necessary.

  34. Encumbrances Banner - FGIOENC Types of encumbrances: P - Purchase Orders. Additional information can be found in SLCCBuy. T Travel. Additional information can be found in Chrome River. PR Payroll.

  35. Encumbrances Banner - FGIENCD FGIENCD (Detail Encumbrance Activity) Displays encumbrance activity When to use it: When you need more details regarding a specific encumbrance How to access it: Direct Access or through the Options menu on FGIOENC How to use it: If using Direct Access, enter the encumbrance number. If through FGIOENC, no input necessary. Each transaction effecting the encumbrance is listed at the bottom of the form, including adjustments and invoices/payments. Note there may be multiple lines/items on a single encumbrance. You can scroll through each item by using the arrow keys on the keyboard.

  36. Encumbrances Banner Encumbrance Roll What is the Encumbrance Roll Encumbrances created in one FY that will not be paid until the next FY. Both the encumbrance and the budget is rolled. Occurs around July 15th. Details regarding rolled encumbrances can be found on FGIOENC.

  37. Encumbrances - SLCCBuy List all Purchase Orders for department. To list Purchase orders for a single Index, add Index as a filter.

  38. Encumbrances - SLCCBuy Direct access to a PO Enter PO number in Quick Search at the top All documents related to the PO will be displayed. Click on the Purchase Order number.

  39. Encumbrances SLCCBuy Invoice tab will list all invoices entered on the PO. Under Line Details Open amount remaining Net Invoiced amount paid

  40. Future Trainings Budget & Finance Forum As needed Biannual BCM and Administrative Assistant Training Fall and Spring Banner Deep Dive Spring (Generally April or May)

  41. Questions?

Related


More Related Content

giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#