r*stars relational standard accounting & reporting system
TRANSCRIPT
![Page 1: R*STARS Relational Standard Accounting & Reporting System](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/1.jpg)
R*STARS
Relational Standard Accounting & Reporting
System
![Page 2: R*STARS Relational Standard Accounting & Reporting System](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/2.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/3.jpg)
3
A c c o u n t s
B3100
B3120
B3124
B3134
B3199
![Page 4: R*STARS Relational Standard Accounting & Reporting System](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/4.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/5.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/6.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/7.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/8.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/9.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/10.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/11.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/12.jpg)
12
![Page 13: R*STARS Relational Standard Accounting & Reporting System](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/13.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082817/56649e435503460f94b36ef8/html5/thumbnails/14.jpg)
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