Profit and Loss Report
The workbook provides year to date detailed fund balances by fund and account category. It also provides inception to date carryover balances for Program Revenue (PR) funds and budget carryover for General Purpose funds (GPR).
|Data Cookbook URL (requires authorization)|
|Specific / Limited Audience|
|Data Source Information|
|Data View Information|
|SFS_PROFIT_LOSS_FACT, SFS_BUSINESS_UNIT_DIM, SFS_DEPT_RPT_HIER_DIM, SFS_FISCAL_PERIOD_DIM, SFS_FUND_DIM, SFS_FUND_RPT_HIER_DIM, SFS_GL_ACCOUNT_DIM, SFS_LEDGER_DIM, SFS_PL_REPORT_HIER_DIM, SFS_PROGRAM_DIM, SFS_PROJECT_DIM, SFS_SCENARIO_DIM|
|Division of Business Services|
Click to see Profit & Loss Report Component Details
|Name||Functional Definition||Data Domains|
A period that an organization uses for accounting purposes and preparing financial statements. For the university, the fiscal year is from July 1 - June 30 (i.e., FY2016 = July 1, 2015 to June 30, 2016). Summer is the first term in the university fiscal year.
Also known as appropriation, this is a 3 digit number set up by the Legislature to define the funding source and transactions that can be attributed to it.
A code assigned to classify each transaction on the general ledger (e.g., asset, liability, revenue, expense).
A code assigned to further specify limitations/classifications on use of funds if needed (e.g., grants).
|Department ID (Accounting)||
A 6 digit code to represent an organizational unit.
|Accounting Period (Accounting)||
Represents a specific time interval (usually a month) for which each transaction is assigned. Possible values are:
Project/grants will typically show Period 13 with Period 1 of the next fiscal year.