R*STARS Relational Standard Accounting & Reporting System Overview ~ The accounting system of the State Treasurer’s Office ~ R41 = Agency Code for UMBC ~ Only method.

Download Report

Transcript R*STARS Relational Standard Accounting & Reporting System Overview ~ The accounting system of the State Treasurer’s Office ~ R41 = Agency Code for UMBC ~ Only method.

R*STARS
Relational Standard
Accounting & Reporting
System
Overview
~ The accounting system of the State
Treasurer’s Office
~ R41 = Agency Code for UMBC
~ Only method of transferring to/from
other Institutions & Agencies
~ 2 categories of accounts:
§Appropriated & Unappropriated
2
Accounts
B3100
B3120
B3124
B3134
B3199
3
Appropriated Account
~ B3100
~ Is UMBC’s State funded budget
~ Recognition of revenue & charge of
expenditures is applied
Fund 40, 43, 46, 48
~ All R41Transactions
› Deposits, payments, journal entries
› InterAgency transactions “to” other
Universities & Agencies [processed by AP]
~ PeopleSoft GL is reconciled to B3100
4
Unappropriated Accounts
~
~
~
~
~
All Others: B3120, B3124, B3134 & B3199
Are actually clearing accounts
No Fund
Each must be cleared to B3100
Transactions in these accounts do not officially
affect the budget until moved to B3100
~ Via automated offset process or manual journal entry
[Tcode is the catalyst]
5
Unappropriated Accounts
~ B3120 – Payroll
~ B3124 – InterAgency & Pcard
› Transactions initiated at other Institutions &
Agencies, including USM Universities
~ B3134 – Treasury deposits (CCD)
› All cash & credit card transactions
~ B3199 – Chargebacks
› Reversal of cash & credit card transactions
› Treasury office also treats as a default account
6
T - Codes
~ Conveys to R*STARS whether a transaction is an
increase or decrease to revenue/expense
~ Revenue: 410=increase
411=decrease
~ Expenditure: 412=decrease 413=increase
~ Special 4-digit Tcodes are used to clear
unappropriated accounts [utilizes the same codes
above, with an additional digit in the first position]
7
PCA
~ An important code in R*STARS
~ Program Cost Account
~ Indicates “where” a transaction will post
› Appropriated or Unappropriated
8
Object Code
~ Comptroller’s Object Code
~ Another important code in R*STARS
~ Indicates “what” the transaction will
post as:
~ Typical codes:
› 8337 = revenue
› 1537 = expense
9
Translation
PS: UMBC1
R*:
Agency
R41
fund
1111
pr-fin
011
10024
PCA
00140
account
7090900
object
0909
10
UMBC Info for R* Transfer
~ The vital information:
Agency = R41
PCA = 02440 (posts to B3124)
Object Code = 8337 (rev) or 1537 (exp)
~ Non-vital, but very important:
 Description – should be something that will assist in identifying the
transaction. This is a reference field, so make it unique to you, such as
department, a POC, an invoice or reference number, etc.
~ Financial Accounting:
 To assist Financial Accounting with identifying the transfer in R*stars, the
R*STARS Notice Form should be completed and forward to the
department. The form is located on the Financial Services website:
www.umbc.edu\accounting, under Financial Services Forms.
 A sample form is attached
11
12
Available Tools
~ Monitor account activity & balances online
in FMIS
› Able to track daily changes
› Able to drill down to transaction detail
~ DAFR reports
› Daily – shows the latest postings to R41 [all
transactions, including R41 generated], in detail
› Monthly – shows all postings for the month, by date,
without detail
13
FYI
~ USM Agency Codes:
§
§
§
§
§
§
§
R23 – Bowie
R24 – Towson
R26 – Frostburg
R27 – Coppin
R28 – UB
R29 – Salisbury
R31 – UMB
R32 – UMCP
R35 – UMES
R40 – UMUC
R41 – UMBC
R44 – UMCES
R45 – UMBI
R46 – USM Office
14