Profit and Loss Report

Last Updated
08/12/2022
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/52510
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
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
Account Code

A code assigned to classify each transaction on the general ledger (e.g., asset, liability, revenue, expense).

Finance
Project (Accounting)

A code assigned to further specify limitations/classifications on use of funds if needed (e.g., grants).

Finance
Department ID (Accounting)

A 6 digit code to represent an organizational unit.

Finance
Accounting Period (Accounting)

Represents a specific time interval (usually a month) for which each transaction is assigned. Possible values are:

  • 1 (Jul)
  • 2 (Aug)
  • 3 (Sep)
  • 4 (Oct)
  • 5 (Nov)
  • 6 (Dec)
  • 7 (Jan)
  • 8 (Feb)
  • 9 (Mar)
  • 10 (Apr)
  • 11 (May)
  • 12 (Jun)
  • 13 (Close)
  • 998 (Year End Adjustments)

Project/grants will typically show Period 13 with Period 1 of the next fiscal year.

Finance