COM Overview, Chart fields and Forms HSC110 - PowerPoint PPT Presentation

Loading...

PPT – COM Overview, Chart fields and Forms HSC110 PowerPoint presentation | free to download - id: 6cc402-ZjdmO



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

COM Overview, Chart fields and Forms HSC110

Description:

COM Overview, Chart fields and Forms HSC110 – PowerPoint PPT presentation

Number of Views:26
Avg rating:3.0/5.0
Slides: 67
Provided by: kherdoci
Learn more at: http://health.usf.edu
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: COM Overview, Chart fields and Forms HSC110


1
COM Overview, Chart fields and FormsHSC110
2
Primary Data Systems
  • Three primary financial data systems
  • OASIS (for student activity)
  • GEMS (for HR activity)
  • FAST (the true accounting/financial application)

3
Module Integration
  • Modules are designed to integrate with other
    modules based on business flow
  • Original entries may be created in one module
  • Posted to another module
  • Then posted to General Ledger all financial
    transactions ultimately post to the General
    Ledger

4
The Data Flow
5
Leading to Chart Field Structure
  • SET ID
  • BUSINESS UNITS
  • CHART OF ACCOUNTS
  • LEDGERS
  • ROSETTA STONE

6
Chart Field Structure
7
USF Chartfield Structure
  • Seven basic chart field values are combined to
    form a chart field string
  • The GL expense account code,
  • Operating Unit,
  • Fund,
  • Department ID,
  • Product,
  • Initiative,
  • and Project ID

8
USF Chart Field Structure
  • A chart field value
  • a combination of numbers and/or letters,
  • identifies the characteristics of an accounting
    transaction,
  • identify the source and purpose of a transaction
    and
  • Identifies how and where it is reported.

9
Chart Field Structure cont.
Operating Unit This is a further breakdown
within one company to show different segments of
the company. At USF, we use the operating unit to
identify campuses and large individual segments
such as USF Health. The operating units are 3
spaces long and currently we only use letters.
(Example HSC) Fund ID This separates funding
sources for reporting purposes. In addition,
specific funds will have specific restrictions on
how they may be used. For instance, the use of
federal research funds (fund ID 20000) must
comply with federal regulations. General revenue
funding from the State of Florida (fund ID 10000)
must be used in compliance with state regulations.
10
Fund Type cont.
  • Common Fund types
  • 00001-09999 Auxiliary (unrestricted)
    identifying a particular Educational Business
    Activity (EBA)
  • 10000 EG
  • 10009 Carry Forward
  • 14XXX Federal Stimulus
  • 18XXX Research Initiative Account
    (RIA)/Internal Award
  • 2XXXX-22XXX Sponsored Projects (Grants and
    Contracts)
  • 28XXX FWSP student worker funds
  • 24XXX Endowment Convenience
  • 940XX 943XX Foundation Convenience AKA Agency
    Funds
  • 945XX 946XX UMSA Convenience AKA Agency Funds

11
Chartfield Structure cont.
Department ID This section of a chart field is
used to define a cost center, one with a budget
for its area, such as a college department. There
are 6 characters, all numbers, in the department
ID. (Example 610100) Department XXXXXX Starts
with 6 USF Health Starts with 60 USF Health
Vice President Administration Starts with
61 USF Health College of Medicine Starts with
62 USF Health College of Nursing Starts with
63 USF Health Institutes Starts with 63 USF
Health College of Pharmacy Starts with 64 USF
Health College of Public Health Starts with
65 USF Health Construction Starts with 66 USF
Health Library Starts with 67 USF Health Medical
Clinics Starts with 68 USF Health Central
Services Starts with 69 USF Health Central
Services
12
Chartfield Structure cont.
Product This is an identifier used to keep
track of the accounting at a certain level in
each department. There are 6 characters in the
product section of a chart field. They may be a
combination of numbers and/or letters. (Example
MEDXXX)   Initiative An initiative is similar
to a product this is a different type of
identifier that allows a department to further
break down funding sources. For example, it is
primarily used for RIA accounts, or to track
internally funded awards. (Example 00XXXXX) last
5 digits of Employee ID.   Projects This is the
only optional section of a chart field. It is
used to track sponsored projects (10 alpha
numeric characters) and construction projects (14
characters). Example 6119112100
13
Funding Sources
14
Funding Sources
  • EG (Educational General)
  • These are funds appropriated by the State
    annually.
  • Example 10000
  • Policies http//usfweb2.usf.edu/purchasing/
  • CF (Carry Forward)
  • Unspent EG budget that rolls over to the new
    fiscal year when REQUESTED AND APPROVED (7/1 to
    6/30)
  • Example 10009
  • Policies http//usfweb2.usf.edu/purchasing/
  • Contracts and Grants
  • 20XXX Federal 21XXX State 22XXX
    Private
  • Example 21000
  • Policies http//usfweb2.usf.edu/uco/research/

15
Funding Sources
  • RIA (Research Initiative Account) Internal
    Award
  • RIA Distribution183XX
  • Fixed Price Residuals 18370
  • Policies http//www.research.usf.edu/files/sr/All
    owableExpenses.pdf
  • Auxiliary
  • 0XXXX
  • Policies http//compass.custhelp.com ( type in
    Auxiliary in search box)

16
Funding Sources
  • Convenience
  • Foundation Endowed Chair 24xxx
  • Foundation 940xx 943xx
  • UMSA 945xx 946xxx
  • Policies http//compass.custhelp.com (Search by
    category Foundation)

17
New Chartfield Setup
  • Request for New Chartfield form Request for
    Chartfield
  • GEMS combo codes (payroll)
  • Request to Establish a New GEMS Combination Code
    Form
  • Workflow form (used to set up purchasing process)
  • FAST Workflow Request Form

18
Convenience Account Set up
  • USF salaries cannot be paid directly from
    Foundation or UMSA accounts, therefore, USF
    Foundation/UMSA Convenience accounts are created
    to transfer money from Foundation/UMSA to USF, so
    that salaries can be paid.

19
  • The following apply to convenience accounts only
  • Memo requesting establishment of chartfield
  • Internal form
  • Foundation(USF) Check/Transfer request or UMSA PO
  • Budget

20
Convenience Account Set up
  • All forms must be sent to the Division of
    Sponsored Research, 30338 USF Holly Dr..
  • Once you receive a new chart field, you must then
    submit the Foundation Check Request Form or UMSA
    Funding Packets with new chart field information
    so that money can be transferred.

21
?
22
(No Transcript)
23
College of Medicine Commonly Used
Forms University of South Florida Tampa, FL
24
USF HEALTH Human Resources
  • Human Resource services for all USF Health
    employees and departments are provided by HR
    Service Center D.  The service center model is a
    team approach, providing excellent customer
    service through centralized, dedicated resources
    for HR actions.
  • Service Center D is staffed by the following six
    HR professionals
  • HR Service Consultant
  • Employment Center Representative
  • Employment Specialist
  • Benefits Representative
  • Employee Relations Consultant
  • Learning Development Facilitator

25
USF HEALTH Human Resources
  • Contact List for Service Center D

26
Commonly Used HR Forms
  • Appointment Status Form (ASF) (completed on line)
  • GEMS gt USF Menu Itemsgt Inquiregt ASF
  • Have the accountable officer sign the ASF and
    send to our HR Representative, SVC 2172
  • Request to Establish New GEMS Account Codes
  • GEMS Combo Codes can be found in GEMS
  • Path is Gems ? Set Up HRMS ? Product Related ?
    Commitment Accounting ? Budget Information ?
    Chartfield Transaction Table
  • GEMS access Form
  • Payroll Distribution Form
  • Completed form to be sent to paydist_at_health.usf.ed
    u

27
Commonly Used HR Forms
  • Payroll Distributions must be completed
  • every time you hire a new employee,
  • every time an employee's record changes, and
  • anytime an employees funding source changes
  • If you are changing an employees effort on a
    sponsored award, you must submit a new pay
    distribution AND the PI must approve.
  • Note If the employee is over the NIH salary cap,
    you must submit an NIH Salary Cap Worksheet
  • The pay distribution percentages must equal 100,
    regardless of the employees FTE.
  • Once the form is complete, send to
    paydist_at_health.usf.edu or deliver to the Business
    Office, MDC 66

28
How to Check Pay Distribution
  • Path is Set up HRMS ? Product Related ?
    Commitment Accounting ? Budget Information ?
    Department Budget Table USA
  • You can look up the pay distribution
  • - for an entire department,
  • - for an individual,
  • - for the current Fiscal Year

29
Commonly Used HR Forms
  • Hiring and Personnel Action Freeze Exception Form
  • Retroactive Expenditure Transfer (RET)

30
RET Form
  • RETs are used to transfer salaries between
    funding sources
  • Transfers should be made promptly after the error
    occurs, but no later than 90 days following the
    date of occurrence unless removing salary from a
    sponsored award
  • Queries for pulling the RET information can be
    found in GEMS
  • Do not modify the queries. Only input salaries
    (not fringes) on the MOVE column.
  • The subject line of the RET must include
  • EMPLID, RCD, Last Name, From (project and fund
    code), to (project and fund code), PPE-PPE
  • For RETS including sponsored research, RIA
    accounts or convenience accounts, send the RET to
    RFMRETNotify_at_research.usf.edu
  • For RETS including non grant related funds, send
    the RET to UPRRETNotify_at_admin.usf.edu

31
RET Form
32
Purchasing Forms
  • Purchase Order Request
  • Purchase Order Change
  • Payment Request
  • Purchase order Close Form

33
Purchase Order Request
34
Purchase Order Request
  • Purchase Order Requests are used to document
    orders that you wish to purchase using state
    dollars.
  • Make sure the information is as detailed as
    possible.
  • Make sure the necessary quotes are attached or
    documented
  • Less than 5000 only need a verbal quote
  • Greater than or equal to 5000 and less than
    25,000 you must have 2 quotes. They can either
    be verbal or written
  • Greater than or equal to 25,000 and less than
    75,000 you must have 3 written quotes
  • Greater than or equal to 75,000 must be sent for
    competitive bids
  • Once an accountable officer signs the PO request
    form, submit to the designated individual who
    enters POs into the FAST system
  • Note This form is internal to the COM and should
    not be sent to Purchasing

35
Purchase Order Change Form
36
Purchase Order Change Form
  • PO change forms are used to make changes on POs
    that have already been approved by the Purchasing
    Department
  • You can change multiple items on the PO
  • Cancel every line item
  • Close the remainder of the PO
  • Change the chartfield for the entire PO or single
    lines
  • Increase or decrease quantity
  • Increase or decrease dollar amount
  • Add items to the Purchase Order form
  • Once the PO change form has been approved, send
    to the COM purchasing agent and they will make
    the changes (email Mark Lillquist or send to
    AOC200)

37
Payment Request Form
38
Payment Request Form
  • Payment Request forms are used to pay for
    purchase that a department is not able to pay for
    using a P-card or purchase order.
  • For the most part, payment request forms are
    being phased out
  • The most common use of this form is for
    conference registration fees if you dont have a
    P-card or will not pay using personal credit card
  • Also used to pay expenses on grants that have a
    project end date that has already passed.
  • Once the form is signed by an accountable
    officer, send to Purchasing, AOC 100
  • Note Include original receipts/invoices

39
Purchase Order Close Form
40
Financial Forms
  • Journal Entry (expenditure transfers, internal
    billing, etc.)
  • Budget Transfer (non research related)

41
Journal Entry Form
42
Journal Entry Form
  • The JET form can be used for Expenditure
    transfers and/or interdepartmental charges cash
    transfers for convenience accounts.
  • If the JET is for any interdepartmental charges,
    they must be sent to rnsinterdept_at_usf.edu
  • If the JET is for any expense transfers, they
    must be sent to rnsexpt_at_admin.usf.edu. Must be
    accompanied by the invoice and ledger.
  • The subject line of the email must include
  • ETR from FUND to FUND (project) (explanation of
    transfer)

43
Journal Entry Transfer Form
  • Expenditure Transfers
  • If completing an expenditure transfer, use the
    account code that the charge was originally
    charged to.
  • Charges to expenses should be entered as positive
    numbers.
  • Credits to revenue should be entered as negative
    numbers.
  • Debits and credits must net to zero.
  • All correcting entries must reference the Journal
    ID being corrected and the posted date of this
    journal.
  • Interdepartmental Transfers
  • If completing an interdepartmental transfer, use
    the revenue account code that the charge is
    associated with (code should start with a 7XXXX).
  • Be sure to include a brief description of what
    the transfer is for.
  • Journal Entry Transfer

44
Budget Transfer
45
Budget Transfer fund 183XX Research
Initiative Account (RIA)
  • List both the chartfield (s) you are transferring
    from and the chartfield(s) you are transferring
    to.
  • The budget amounts for these chart fields must
    net zero.
  • Once completed, the form should be sent to Karen
    Haubenstock, karenh_at_usf.edu.
  • Note For sponsored award transfers, you must use
    a Budget Transfer Form found on Sponsored
    Research Website.

46
Budget Transfer Funds 10000 and 10009
  • If transferring non-salary budget, send an email
    to Tabitha Laidler tlaidler_at_health.usf.edu
  • If transferring salary budget, send an email to
    Andrea Rudon arudon_at_health.usf.edu
  • The email must state which budget codes you will
    be transferring between.
  • Be sure to include the amounts you will transfer.
  • If you want to transfer between chartfields, be
    sure to include the account codes for each
    chartfield and the total amount.

47
Travel Forms
  1. Travel Delegate Form
  2. Non Employee Profile Creation Request
  3. FAST

48
(No Transcript)
49
Travel Delegate From
  • This form is used to assign delegates for the
    FAST Travel Module if you already have FAST
    travel Module access
  • A delegate is an employee who is able to create
    and enter TAR and TER submissions
  • An employee is automatically a delegate for
    themselves, so they just need to make sure they
    have FAST access in order to enter travel.
  • If another individual will be entering travel on
    behalf of someone else, you will need to fill out
    the delegate request form.
  • Once completed, send the form to
    travelhelp_at_admin.usf.edu. They will send and
    email confirmation once it has been processed.

50
Non Employee Profile Creation Form
51
Non Employee Profile Creation Form
  • This form is used to create Employee records for
    people outside of the University who will be
    traveling using State dollars.
  • ex Faculty candidates and consultants
  • Employees must have an active GEMS record in
    order to be reimbursed for travel.
  • This form must be completed and submitted for
    Travel prior to entering a TAR and incurring any
    travel expenses.
  • It generally takes 3-5 Business days for Travel
    to process this, so plan accordingly.
  • Once this form is completed, send to
    travelhelp_at_admin.usf.edu

52
Travel Access Form
53
Travel Access Form
  • Use this form to
  • Request delegate access to the travel module
    within FAST
  • Set up budget approvers for travel
  • Set up approval role for supervisors (tied to
    GEMS)
  • Set up approval role for Principal Investigators
  • If you are adding a budget approver to another
    chartfield, be sure to include a list of all
    chartfields they approve. Otherwise, the new
    request will override previous approval authority
  • Budget approvers are only tied to the Operating
    Unit and Department
  • All travel on a grant will automatically need to
    be budget approved by the PI

54
Miscellaneous Forms
  • Billing Contact Form
  • Deposit Data Form
  • FAST
  • Foundation
  • FAST Workflow

55
Billing Contact Form
56
Billing Contact Form
  • This form is used to add or remove billing
    contacts for FAST chartfields.
  • Being a billing contact allows you to review the
    Telephone billing transaction details for your
    department.
  • The telephone bills can be viewed through the IT
    Communications Mart in the Data Marts section in
    the Admin Portal
  • Once the accountable officer has signed, the form
    should be sent to telebill_at_adminu.usf.edu.

57
Deposit Data Form
58
Deposit Data Form
  • This form is used to tell the Cashiers Office
    which chartfield a check should be deposited
    into.
  • Make sure you provide as much detail as possible
    in regards to the vendor, check number and
    description.
  • Include the account code that the money should be
    deposited into
  • Once the form is complete, either send to the
    lock box with the check attached or hand deliver
    to the Cashiers Office.

59
FAST Access Form
60
FAST Access Form
  • This form is used to request access to USFs
    Financial System, FAST
  • You can request access to various modules within
    FAST
  • Requisitions
  • Receiving
  • P-Cards
  • Travel
  • Accountable Officer
  • Inquirer
  • Be sure to completely fill out each section for
    which you need access to.
  • The accountable officer must sign this form. They
    will not accept an accountable officer designee.
  • Once completed, send the form to FAST Security,
    AOC 200

61
Foundation Access Form
62
Foundation Code of Ethics Form
63
Foundation Access Form
  • This form is used to request to your departments
    Foundation accounts.
  • You will only need to check the box for USF
    Foundation Finance Read.
  • Have an accountable officer sign the form.
  • Send via campus mail to at ALC 100.
  • You must also fill out the Code of Ethics form
    and send along with your access form.
  • Once you get an email with your username, you
    must request access to your departments funds.
  • Send Jean Nixon a list of the funds in your
    department and she will approve and forward to
    Foundation.

64
FAST Workflow
65
FAST Workflow
  • This form is used to setup workflow for your
    departments chartfields.
  • Workflow needs to be set up for the following
    roles
  • Requisition Approver
  • Requisition Manager
  • Accountable Officer
  • Accountable Officer Designee
  • It is a good idea to have backup individuals for
    each role.
  • This form must be filled out if your department
    intends on processing Purchase Orders, P-cards,
    Payment Requests, etc.
  • Completed form must be signed by accountable
    office and sent to FAST Security, Nancy
    DellaPorte, AOC 200

66
(No Transcript)
About PowerShow.com