RSCCC FINANCE

1
RSCCC FINANCE REQUISITIONAPPLICATION
DO YOU KNOW?
2
RSCCC Do You Know? - Introduction

• The RSCCC Business Systems are designed to
  provide accuracy, consistency and ease of use - a
  system that meets all of the users needs.
• This objective is accomplished when the user
  discovers and uses a feature in the system that
  eases their daily workload.
• For instance

3
RSCCC Do You Know?

• Finance gt Tables gt Finance Options gt Clearing
  Fund Maintenance Tab
• When the All Computer Checks to Finance Clearing
  Fund in Bank Recon field is selected, all
  computer checks will display on the Bank
  Reconciliation screen for the bank account linked
  to the clearing fund.
• If this field is left blank, computer checks are
  filtered by bank account group linked to the
  account code chosen when posting the entry.

4
RSCCC Do You Know?
5
RSCCC Do You Know?

• Finance gt Tables gt Account Codes gt Fund gt Fund
  Type Field
• The Fund Type field has a drop down list that is
  used to identify the fund according to the FAR
  Guide.
• This field is used for the Working Trial Balance
  (FIN3200), Working Trial Balance using
  Transactions (FIN3220), and Trial Balance
  (FIN3250) reports.

6
RSCCC Do You Know?
7
RSCCC Do You Know?

• Finance gt Tables gt User Profiles gt Accounts
• The accounts on this table for each User ID
  influence the data that can be accessed in
• Maintenance gt Postings
• Inquiry gt General Ledger Inquiry
• New Feature All listed reports in Reports
  gt Finance Reports gt Journals, Checks, Detail
  Ledgers

8
RSCCC Do You Know?
9
RSCCC Do You Know?

• Finance gt Tables gt Bank Account Fund Groups gt
  Bank Account Group
• Bank Account Nbr field is used in conjunction
  with Auto Bank Reconciliation which imports bank
  information and produces a Bank Statement Import
  report.
• The system automatically matches the districts
  bank account number to the Bank Account Nbr field
  associated with the Bank Account Group Code to be
  reconciled when using Auto Bank Reconciliation.

10
RSCCC Do You Know?
11
RSCCC Do You Know?

• Finance gt Inquiry gt General Ledger Inquiry gt Over
  Expended Account Summary Tab
• This tab displays over-expended amounts for each
  account.
• You can use the Minimum Over Expended Amount
  field to filter accounts by over-expended amount.

12
RSCCC Do You Know?
13
RSCCC Do You Know?

• Finance gt Maintenance gt Bank Reconciliation gt
  Positive Pay Export Tab
• The Positive Pay Export creates a list of
  district payments. Banks validate all checks
  against this list.
• This is an internal control mechanism to prevent
  theft.

14
RSCCC Do You Know?
15
RSCCC Do You Know?

• Finance gt Maintenance gt Bank Reconciliation gt
  Auto Bank Reconciliation Tab
• Banks can prepare a list of cleared checks to be
  imported into RSCCC.
• Checks are cleared by bank account and are saved
  as pending on the Bank Reconciliation tab. This
  allows the user to review them before
  reconciling.

16
RSCCC Do You Know?
17
RSCCC Do You Know?
18
RSCCC Do You Know?

• Finance gt Utilities gt Extract MACM
• The Extract MACM feature allows users to create
  quarterly finance and human resources reports
  required by the Texas Department of Human
  Services for reimbursement of medical case
  management and Medicaid outreach activity
  expenses.
• The reports are saved in Excel format.

19
RSCCC Do You Know?
20
RSCCC Do You Know?

• Finance gt Utilities gt Fiscal Year Processing gt
  Mass Change Bank Account Group by Fund
• When preparing for end of year processing, the
  user can mass update fund years for bank account
  groups.
• Accounts must exist in the Account Codes table,
  and the 1XXX cash account must be in the Chart of
  Accounts.

21
RSCCC Do You Know?
The year automatically increments when the fund
is selected and moved to the right side.
22
RSCCC Do You Know?

• Finance gt Maintenance gt Check Processing gt Print
  Checks Tab
• By populating the Fund field, users may process
  checks by fund(s).

23
RSCCC Do You Know?
24
RSCCC Do You Know?
Bank account group 0001 LM includes fund
864/7. If the All Computer Checks to Finance
Clearing Fund in Bank Recon Field is checked,
all computer checks are displayed under bank
account 0001 - LM.
25
RSCCC Do You Know?
As the Recon boxes get checked, the amounts are
included in the Cleared Deposits/Cleared Checks
fields, and they are removed from the system
Outstanding Deposits/Checks fields.
26
RSCCC Do You Know?

• Finance gt Reports gt Summary and Miscellaneous
  Reports gt Finance 85 Compliance Worksheet
• Users can use this report to get a snapshot
  comparison of direct costs vs. indirect costs.

27
RSCCC Do You Know?
Expenditures are sorted by PIC.
Direct and Indirect Costs are sorted by function.
28
RSCCC Do You Know?

• Finance gt Maintenance gt Postings gt Check
  Processing PA and PO Tabs gt Separate Check Field
• This is a new field that allows users to print a
  separate check to the same vendor for each item
  on a PA or a PO.
• If this field is not checked, the items will be
  grouped by vendor number when processing checks.

29
RSCCC Do You Know?
30
RSCCC Do You Know?

• Finance gt CYR Amendment gt Amendment Budget
  Maintenance gt Amendment Nbr Field
• When an amendment is posted to the general
  ledger, the amendment number will become the JV
  number. If the user tries to use an existing JV
  number for the amendment number, they be prompted
  to use a different number.

31
RSCCC Do You Know?
32
RSCCC Do You Know?

• Finance gt Tables gt District Finance Options gt
  Change PO Created in Requisition
• New Feature Users now will have the option
  to edit a PO created in Requisition through the
  Finance application.
• Users have the option to edit the vendor,
  add/insert account codes, and modify encumbrance
  amounts.

33
RSCCC Do You Know?

• Finance gt Tables gt District Finance Options gt
  Change PO Created in Requisition (contd)
• When saved, the system will create a line item on
  the requisition, and account codes are created as
  needed.

34
RSCCC Do You Know?
35
RSCCC Do You Know?
By clicking on the right mouse button, the
options are presented to the user.
36
RSCCC Do You Know?
If a change is made in Finance, the Requisition
Status Inquiry will display Changed in Finance.
37
RSCCC Do You Know?

• Requisition gt Tables gt Requisition Options gt
  Cutoff Date Field
• The system will allow for a Cutoff Date, the
  point at which no more requisitions may be
  submitted.
• If this field is left blank, there is no cutoff
  date.

38
RSCCC Do You Know?
39
RSCCC Do You Know?

• Requisition gt Maintenance gt Create/Modify
  Requisition
• If todays date is greater than the Cutoff Date,
  creation of new requisitions will not be
  permitted.
• The New button is disabled.
• When the user right-clicks the mouse, the Add and
  Insert options are ghosted so the user cannot
  select them.
• The Ctrl-Q hotkey is disabled.

40
RSCCC Do You Know?
41
RSCCC Now You Know

• Now you knowThat RSCCC Finance and Requisition
  are applications which are only a part of the
  RSCCC System that meets all of the users needs.
• Now you knowThe RSCCC System is easy and user
  friendly.
• Now you knowThe RSCCC System provides an
  accurate and consistent method of maintaining
  district data.
• Now you knowThe RSCCC objective is met when the
  user implements features in the system that ease
  their daily workload.

42
RSCCCFINANCEAPPLICATION

• Now You Know