r*stars relational standard accounting & reporting system

14
R*STARS Relational Standard Accounting & Reporting System

Upload: deirdre-clark

Post on 27-Dec-2015

214 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: R*STARS Relational Standard Accounting & Reporting System

R*STARS

Relational Standard Accounting & Reporting

System

Page 2: R*STARS Relational Standard Accounting & Reporting System

2

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

Page 3: R*STARS Relational Standard Accounting & Reporting System

3

A c c o u n t s

B3100

B3120

B3124

B3134

B3199

Page 4: R*STARS Relational Standard Accounting & Reporting System

4

Appropriated Account

~ B3100~ Is UMBC’s State funded budget~ Recognition of revenue & charge of

expenditures is appliedFund 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

Page 5: R*STARS Relational Standard Accounting & Reporting System

5

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]

Page 6: R*STARS Relational Standard Accounting & Reporting System

6

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

Page 7: R*STARS Relational Standard Accounting & Reporting System

7

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]

Page 8: R*STARS Relational Standard Accounting & Reporting System

8

P C A

~ An important code in R*STARS

~ Program Cost Account

~ Indicates “where” a transaction will post

› Appropriated or Unappropriated

Page 9: R*STARS Relational Standard Accounting & Reporting System

9

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

Page 10: R*STARS Relational Standard Accounting & Reporting System

10

Translation

fund pr-fin account

PS: UMBC1 1111 011 10024 7090900

Agency PCA object

R*: R41 00140 0909

Page 11: R*STARS Relational Standard Accounting & Reporting System

11

UMBC Info for R* Transfer~ The vital information:

Agency = R41PCA = 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

Page 12: R*STARS Relational Standard Accounting & Reporting System

12

Page 13: R*STARS Relational Standard Accounting & Reporting System

13

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

Page 14: R*STARS Relational Standard Accounting & Reporting System

14

F Y I

~ USM Agency Codes:§ R23 – Bowie R32 – UMCP § R24 – Towson R35 – UMES § R26 – Frostburg R40 – UMUC § R27 – Coppin R41 – UMBC § R28 – UB R44 – UMCES§ R29 – Salisbury R45 – UMBI § R31 – UMB R46 – USM Office