Profit and Loss Report
Last Updated |
---|
12/08/2024 |
Description |
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). |
Report URL |
https://tableau.wisconsin.edu/#/views/ProfitandLossReport/HomePage |
Data Cookbook URL (requires authorization) |
https://uwmadison.datacookbook.com/institution/reports/31871/versions/74039 |
Data Domain(s) |
Finance |
Access Restrictions |
Specific / Limited Audience |
Data Source Information |
InfoAccess |
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 |
Update Schedule |
Monthly |
Responsible Office |
Division of Business Services |
Important Notes |
Click to see Profit & Loss Report Component Details |
Definitions
Name | Functional Definition | Data Domains |
---|---|---|
Account Code | A code assigned to classify each transaction on the general ledger (e.g., asset, liability, revenue, expense). |
Finance |
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. |
Finance |
Department ID (Accounting) | A 6 digit code to represent an organizational unit. |
Finance |
Fiscal Year | 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. |
Finance |
Fund (Accounting) | 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. |
Finance |
Project (Accounting) | A code assigned to further specify limitations/classifications on use of funds if needed (e.g., grants). |
Finance |