June 2022�SUBOA Year-end��IPEDS, URAS, and Cash/Revenue Reporting
Presenters:�Peggy O’Day�Katie Vitello�Stephanie Cronin�Christine Oliver
IPEDS and URAS
IPEDS Finance Survey
IPEDS / Financial Statements /URAS
Question - Why is there a necessity for both cash and accrual basis accounting in URAS?
IPEDS / Financial Statements – Revenues
IPEDS / Financial Statements - Revenues�
IPEDS / Financial Statement Expenses
Thank you!
Questions?
Allocation vs. Cash
Allocation vs. Cash
(with thanks to SUNY Plattsburgh’s Financial Services website)
What is allocation?
Allocation is the authority to spend up the amount indicated and for the purpose stated. Allocation is your budget and does not roll forward from one fiscal year to the next. Allocation is initially requested via the FORM1 process.
What is cash?
Cash is the balance contained within the fund or IFR account that has accumulated over the years as a result of receipts exceeding disbursements. Cash does roll forward from one fiscal year to the next.
It is the allocation balance in your account which allows you to expend funds, not the cash balance. Your account may have plenty of cash, yet purchasing is unable to process an order, due to insufficient available allocation. When purchasing processes a purchase order, contract or requisition, they make an encumbrance against your account’s allocation, not your cash.
Ultimately, you need your allocation to spend your cash, and you need your cash to get your allocation!
Allocation vs. Cash
When does a voucher post to the balances in BI?
Date Notes
4/13/22 (Wed) Voucher created on FMS and transmitted to SFS
4/14/22 (Thu) Pending expenditure and pending encumbrance liquidation post to BI on Account Summary, Transaction Inquiry>Pending Transactions, and Cash by Account>Expenditures
4/18/22 (Mon) Expenditure and encumbrance liquidation are visible in Account Summary and Transaction Inquiry>Transactions (2 business day lag from BI Posted Date)
5/9/22 (Mon) Voucher disbursed (check issued to payee) on SFS
5/11/22 (Wed) Disbursement is included in cash balance of General IFR fund and account 910586 on BI Cash Reporting dashboard (2 business day lag from BI Posted Date). Disbursement transaction is visible in BI. Expenditure is liquidated on Cash by Account.
Note: at any given time, the Expenditure amounts on Cash by Account (highlighted below) represent amounts that have been expended but not yet disbursed.
Cash by Account vs. Cash by Fund
Cash by Account vs Cash by Fund
Revenue Offset*
Dormitory Operations*
Hospital Operations*
Long Island Veterans’ Home
Collection Funds
Res Hall Rehab and Repair Project
Res Hall Rehab and Repair Reserve
STIP Fund*
Hospital STIP Loan*
General IFR*
SUTRA*
Stabilization Fund*
Dormitory Sponsored*
Hospital Sponsored*
Cash by Account vs. Cash by Fund
For the IFR funds, the fund balance should equal the sum of the individual account balances.
Example: SUTRA fund
Cash by Account vs. Cash by Fund
Impact of “SUNY-Only” Journals
SUNY Blue Resources
SUNYBLUE
A lot of other great information!
Navigation:
blue.suny.edu
>Departments
>University Controller’s
Office
Links:
Accounting Journal Module
Accounting Journal Module
Navigation: Employee Services Portal>Finance & Management System>Finance> Accounting Journals
Accounting Journal Module allows for the processing of revenue journals, expense journals and revenue/expense journals among funds, accounts, revenue classes and sub objects.
Transactions can be directly entered into the module or an excel spreadsheet can be uploaded. To upload, click the upload button.
Click the template button to get the excel spreadsheet.
Or click the Select File button to choose a file already saved to your computer.
Then click the Upload button to load the document into the module.
Template contains two tabs, the Journal Template and the Instructions
Transfer Edits in the Accounting Journal Module
-Regular transfers: 12877, 12982, 12989, 12990, 15648, 15848, 15877, 17848, 18177, 18178, 18179, 18189, 18278, 18282, 18378, 18379, 18382, 19377, 19378, 19379, 20976, 24877, 24878
-Reserve transfers (to and from IFR reserve accounts): 18160, 18161, 18162, 18360, 18361, 18362, 19360, 19361, 19362
-Sub Objects: 0799, 2799, 3799, 4799, 5825, 5828, 5829, 7405, 7799
Note: there are additional transfer revenue classes not listed above, that are designated for other uses or are for System Admin use only. See the Job Aid for a full list.
BI Financials Dashboards for Cash/Revenue Reporting
BI Financials Dashboards
For Cash/Revenue Reporting
Dashboard | Data |
Reference | Trainings (basic how to use BI dashboard training video link) Tips and Tricks Transaction Codes Revenue and Expenditure Funds Revenue Classes Sub Object Chart of Accounts |
Cash Reporting | Daily, Monthly, Yearly Cash balance by fund Receipt/Disbursements – listing by transaction Receipts/Disbursements by group Cash by Account IFR Billing Report Notes: IFR Billing Exclusions History link on IFR Billing page and a STIP Interest Rate History link on the introduction page |
URAS | Receipts by Revenue Class URAS reports – Trial balance, etc. Note: there’s a URAS crosswalk link on the introduction page |
Tips and Tricks
Tips and Tricks: Subtotals
To quickly subtotal by any field, move the field to the columns, to sections, or to a pivot table. This can be done by right-clicking on the column header and selecting “Move”, or by dragging the column header to the desired location. This works best when the field in question has only a few different values.
Example: on Cash Reporting>Disbursements, move the Current/Lapsed Indicator to the columns:
Or, move it to a pivot table:
BI Financials Dashboards
Journal Names, Justifications, and Funding Descriptions
Document Numbers
Journals – Input in FMS Start with W, Input in SFS start with 000xxxx
Vouchers – Start with E
Deposits in SFS – Start with RMRxxxx
Refer to the Reference dashboard for more information on the following coding
Revenue Class and Descriptions
Sub Objects and Descriptions
Transaction Codes
Tips for Identifying Transactions
Campuses may have noticed that journals are sometimes taking 3 days to post to BI.
SFS transmitted Journals
Example a journal input on a Monday in FMS and SFS approved
Things to note:
month (impacts the cash balance and account summary balances
for that month), be sure to input the document before the last working day of the month.
Notes on Timing of Journal Processing
Recurring Transactions Processed by System Administration
Revenue Transactions
STIP Interest distribution
IFR Billing
Pooled Offset Transfers
Pooled Offset Overcollections Transfers
State Support
HESC Transfers
Facility Staff to Hard Dollar Capital Transfers
Residence Halls Deposits
Residence Hall Debt Service
Other Recurring Transactions (Non-Revenue Related)
P-Card
Payroll Auto Journals
Payroll Distribution
STIP Interest
Distribution of STIP (Short Term Investment Pool) interest earnings. Interest is earned on the average daily cash balance for the month and is distributed around the 20th of the following month. The interest rate is determined by the Office of the State Comptroller.
12850 STIP Interest (Revenue Offset/Dorm Ops/Sponsored, Stabilization Fund, Rehab and Repair)
15850 STIP Interest (Hospital Ops)
18350 STIP Interest (Hospital Sponsored)
17850 Misc. Interest income (LIVH)
Additional information regarding STIP can be found in the OSC’s Guide to Financial Operations section XIV.3. A link to the STIP Interest Rate History can be found on Cash Reporting > Introduction page.
Fund Interest Earned on | Fund Interest Deposited to |
Collection Fund - Campus | Revenue Offset |
Revenue Offset | Revenue Offset |
General IFR | Revenue Offset |
SUTRA | Revenue Offset |
Stabilization Fund | Stabilization Fund |
Dormitory Operations/Sponsored | Dormitory Operations |
Hospital Operations/Collection Fund - Hospital | Hospital Operations |
Hospital Sponsored | Hospital Sponsored |
Long Island Veterans’ Home/Collection Fund - LIVH | Long Island Veterans’ Home |
Hospital STIP Loan | Hospital STIP Loan |
Res Hall Rehab and Repair Project | Res Hall Rehab and Repair Project |
Res Hall Rehab and Repair Reserve | Res Hall Rehab and Repair Reserve |
STIP Interest
IFR Billing
There is a monthly IFR Billing processed for Fringes (pooled offset), campus Administrative Overhead and campus Maintenance and Operations.
18175 Indirect Costs (General IFR)
19375 Indirect Costs (SUTRA)
18275 Indirect Costs (Dorm Sponsored)
18375 Indirect Costs (Hospital Sponsored)
18171 Campus-Administrative Overhead (account 900760)
18172 Maintenance & Operation (account 910620)
IFR Billing:
Rates for IFR Billings are established at the account level on the FMS Chart of Accounts. Throughout the month qualifying transactions are billed at the current rate and are accrued on pending journals in FMS. The journals are completed and transmitted to SFS on the first Thursday of the following month that is not the 1st day of the month.
Example: May 2022 IFR billings journals will be transmitted to SFS on June 2nd.
Accrued billings for the current month are reported on Cash by Account in the Uncommitted Cash section:
Cash Reporting > IFR Billing page can be used to review the posted transactions that could cause an IFR billing accrual. Some variances between what was actually billed vs. what reports on this page could be due to mid month rate changes or rounding differences.
Some Sub Objects (Fringe Benefits – Regular) and Revenue Classes (Fringe Benefits – Summer SUTRA, Administrative Overhead, and Maintenance Operations) are excluded from the billing process. A link to IFR Billing Exclusion History can be found on Cash Reporting > IFR Billing page.
Pooled Offset Distribution
Through the IFR Billing process (payroll*fringe rate) revenue is transferred from campuses General IFR, SUTRA, Dorm Operations and Sponsored, Hospital Sponsored, and LIVH to the Pooled Offset. Based on the Financial Plan these funds are than distributed to campuses through the distribution of the pooled offset collections ($110.7 million annually).
Pooled Offset Overcollections
Excess pooled offset collected above the campus pooled offset target is returned to the campus.
State Support Transfers
SUNY receives periodic transfers of State Tax dollars and these funds are transferred to campuses per the financial plan. Generally, we receive 5 transfers per year.
Transfers from Higher Education Service Corporation (HESC)
TAP and other scholarship revenue is received via a revenue transfer from HESC. Controller’s Office distributes the revenue to the campus collection fund as it is received.
Facility Staff to Hard Dollar Capital Transfers
The Facility Staff to Hard Dollar Capital Transfer is an expenditure transfer of facilities payroll to a capital appropriation, with a corresponding revenue transfer of the same amount.
12877 Transfer To/From Other Funds (Revenue Offset)
18178 Intra-Fund Trans Ind Cst Neutral (General IFR)
12990 Transfer To/From Dorm Op Misc (Dorm Operations)
19378 Intra-Fund Trans Ind Cst Neutral (SUTRA)
17848 Transfer From Other Funds-LI Vet (LIVH)
Residence Hall Transfers from Tax and Finance (T&F)
Campuses make ACH transfers to T&F Chase bank account for residence hall room rents, etc. Once debt service requirements are reached the excess can be transferred to the campus dormitory operations fund.
Residence Hall Debt Service
Campuses make semiannual debt service payments for DASNY debt service and Revolving Loan (SUNY) debt service. DASNY debt service is paid directly from the campus Tax & Finance accounts. The journals described below are processed to record the payments in the SUNY accounting system.
12902 Room Rent Curr Sch Yr-Gen Stgs
12985 Dorm Debt Service Payment DASNY
12986 DASNY Overhead and Insurance
18285 PG Debt Service Payment DASNY
18286 PG DASNY Overhead
12979 SUNY Loan Repayment-Other
Other Recurring Documents
Non-revenue Related
P-Card Journals
P-Card journals distribute monthly Purchase card swipes to the departmental accounts from the P-Card control account.
Payroll Auto Journals
Payroll Auto Journals are processed to move payroll from the 000Y00 of the incorrect fund that was originally charged to the 000Y00 of the correct fund due to changes in line or distribution. It may also transfer to different sub-objects.
Payroll Distribution
Payroll Distribution journals moves the OSC payroll expense from the 000Y00 account to the departmental accounts that an employee is paid from.
20-Year Trends:
Receipts, Disbursements, and Cash Balances
Amounts are by SUNY 12 Month FY and include all State-operated campuses, statutory colleges, System Admin, and U-Wide Programs
Receipts
Core Operations (Revenue Offset fund)
Excludes State support, transfers, assessments, and scholarship adjustments
(millions)
Direct State Support
Core Operations (Revenue Offset and State Purpose funds)
(millions)
Note: includes State Purpose fund thru FY12-13. Does not include indirect State support (fringe benefits, educational facility debt service, litigation) or Hospital State support.
Receipts
Self-Supporting Programs (General IFR, SUTRA, Stabilization, LIVH)
Excludes State support, transfers, assessments, and scholarship adjustments
(millions)
Receipts
Residence Hall Programs (Dorm Ops, Dorm Spon, Res Hall Rehab, T&F)
Excludes State support, transfers, assessments, and scholarship adjustments
(millions)
Receipts
Hospital Programs (Operations and Sponsored)
Excludes State support, transfers, assessments, and scholarship adjustments
(millions)
Disbursements
Core Operations (Revenue Offset and State Purpose funds)
Excludes transfers and scholarship adjustments
(millions)
Note: includes State Purpose fund thru FY12-13.
Disbursements
Self-Supporting Programs (General IFR, SUTRA, Stabilization, LIVH)
Excludes transfers and scholarship adjustments
(millions)
Disbursements
Residence Hall Programs (Dorm Ops, Dorm Spon, Res Hall Rehab)
Excludes transfers and scholarship adjustments
(millions)
Disbursements
Hospital Programs (Operations and Sponsored)
Excludes transfers and scholarship adjustments
(millions)
Cash Balance
Core Operations (Revenue Offset fund)
(millions)
Cash Balance
Self-Supporting Programs (General IFR, SUTRA, Stabilization, LIVH)
(millions)
Cash Balance
Residence Hall Programs (Dorm Ops, Dorm Spon, Res Hall, Rehab, T&F)
(millions)
Cash Balance
Hospital Programs (Operations and Sponsored)
(millions)
Cash Balance
Total
(millions)
Note: excludes Collection Funds, bank accounts, and Hospital STIP Loan. ‘
Thank you!
Questions?
Fiscal Year End and Lapsing Announcements
Fiscal Year End Announcements – June 2022
Fiscal Year End Announcements – June 2022
Lapsing Announcements – September 2022
Lapsing Announcements – September 2022
Thank you!
Questions?