BAIRS Report List

Note:  The reports you can subscribe to in BAIRS are determined by the your security setup.  If you are not set up to have access to Payroll detail, for example, you will not see the GL_Customer_Report or the Payroll_Exception_Report.  If you are not set up to have access to Permanent Budget data, you will not see those reports.  If you and your manager agree that your access should be changed, please complete and submit a Userid form.
 

• GL Detail Reports
• GL Summary Reports
• List Reports
• Budget Reports
• Payroll Reports

GL Summary Reports
 

GL Sum by Account L4 BUDSUM	Summarizes the budget, actuals, encumbrances and pre-encumbrances by BUDSUM account for each unique combination of org-fund-project-flexfield-program, with grand totals for the first field in the selected sort order (fund, org, or flex).
GL Sum Flex by Fund or Org	Summarizes the budget, actuals, encumbrances and pre-encumbrances for each flexfield (including blank) within a fund or an org.
GL Sum Full Chartstring by Fund	Summarizes the budget, actuals, encumbrances and pre-encumbrances by full chartstring (BU-acct-fund-org-prog-proj-flex) within a fund.  Used primarily by Budget and General Accounting.
Fund Overdraft	This report lists funds in overdraft.
GL Central Fund Sum	This report compares Tempbudg to Actuals for a given fund's revenue, expenditure and fund balance accounts. Revenues and expenditures are summarized either at the department or org code level. For Plant funds project CIP accounts are included.
GL Central Specific Combos Sum	Summarizes the budget, actuals, encumbrances and pre-encumbrances by account-fund-program or project-fund-account-org-program.  Used primarily by General Accounting.
GL Sum Income & Expense by Org	The report summarizes the income and expenses for each org and compares them with the projected income and expenses (temporary budget). It can be viewed by individual fund or with several funds summed together (these are the 2 sort orders).
GL Sum by Account	Summarizes the budget, actuals, encumbrances and pre-encumbrances by BFS account and BUDSUM rollup account for org, org-fund, fund, flex, project, flex or “all parameters.”  Note that when summarizing for one or two fields (e.g. org or org-fund), this report includes amounts for those fields regardless of any other chartfield (e.g. program).  The “all parameters” option allows you to summarize all together the data you requested from the dashboard.
GL Sum by Five Chartfields	Summarizes the budget, actuals, encumbrances and pre-encumbrances for each unique combination of org-fund-project-flexfield-program, with grand totals for the first field in the selected sort order (fund, org, or flex).
GL Central Matching Fund Balance	Summarizes specific accounts by fund groups for General Accounting.
GL Sum by Org	Summarizes the budget, actuals, encumbrances and pre-encumbrances for each org.  This report should be run for multiple orgs, either by building a value list, entering a range, or selecting an org tree node.
GL Sum Plant Projects	Summarizes the budget, actuals, encumbrances and pre-encumbrances for plant projects by project or by fund within project.  Also has an option to display only those projects which are in deficit.
GL Sum Two Year Actuals Comparison	This report sums up Actual revenues & recharge income and Actual expenses and compares by month and year-to-date between the selected year and the prior year. This is designed to allow units to compare income and/or expenses across fiscal years.

List Reports
 

Five Field Validation	Provides list of values from the Five Field Validation table in BFS.  This report can be run for valid combos, invalid combos or both.
Flexfields by Dept Code	Provides a list of flexfields for a given department.  You enter a departmental prefix (first 2 characters of the processing unit) and receive a list of all flexfields which begin with that prefix.
Job Code List	Provides a list of UC Berkeley Job Codes and their descriptions. Other information includes Representation Unit, Personnel Program, and Provision Level Salary (if budgetable) for each job code.
Master Org Tree	Provides a list of org codes in the requested range or under the requested tree node.
Projects by Dept Code	Provides a list of project codes for a given department.  You enter a departmental prefix (first 2 characters of the processing unit) and receive a list of all projects which begin with that prefix or (for management project codes) have the prefix as the third and fourth character.
Speedtypes by Org Criteria	Provides a list of speedtypes for a given org or orgs.  You enter one or more org codes and receive a list of speedtypes which begin with those org(s).

Permanent Budget Reports
 

Academic Breakdown (3 versions)	Typically used only by the Budget Office.
Equity Adjustments	Provides a listing of the equity salary adjustments that have been processed.
Journal Activity by Account	Lists journal line activity by Fund, Org, Program.  Can be run by month or year-to-date.
Ledger POS Error	For Budget Office use only.  List PRT integrity errors.
Ledger Summary	Summarizes ledger balances for the permanent budget. It includes dollar and FTE values for positions and dollar values for all non-salary chartfield combinations by budget summary (BUDSUM) account.
Position Balance	Provides the ledger value and incumbent status of permanently budgeted positions. It includes dollar and FTE values, by position and title code, and also lists the employee ID number and name, and if the position is linked to an incumbent.
Position History	Shows all year-to-date changes to each position.  Use this report to check that all expected merit, range, reclass, and equity changes for a position have been processed in the permanent budget.  Use this report in conjunction with the TB_Curyr_Position_Funding report to reconcile staffing funding actions between the Permanent and Temporary Budgets.
Position Summary	This is a summary report which summarizes entries for each position by the July Adjusted Budget (period 1) in the first column and displays by transaction code category (FTE/COA changes, Merits/Ranges, Promotions/Regularizations, Reclasses, Equity, and Upgrading/Downgrading) for accounting periods 2-12. It includes three sort orders (Fund, Fund-Org-Prg, Org-Fund-Prg) and can be run for filled, unfilled or all positions.
PRT Error	This report replaces the EDB Audit Rpt in BAIRS 1. It lists employees with "budgeted FTE" in their distribution line that meet one or more of the following criteria: they are not linked to a position, or their chartfield string, FTE amount or salary amount has changed since they were originally linked to a position.The goal is to have a blank report.
PRT Upgrading	Shows incumbent salary values at month end for positions that were unfilled at the close of the prior month. This report compares the dollar amount in the job code table with the salary amount for the position. Allows users to select whether incumbent salary is over, under or equal to mid-range for salary. Has 5 sort orders.Useful for control units to see changes in dollar amounts for positions.
PRT Request Status	This report provides users with a list of PRT requests submitted for approval. Users can prompt by processing unit, org, operator id and request status.
Reclassifications	Lists all reclassed positions, both filled and unfilled, by Fund, Org and Program.  Shows original title code and salary, new title code and salary, and amount of increase for each position.  Primarily designed for Budget Office and Control Unit use.
Sum by Transcode Category	Summarizes permanent budget entries by transaction code category, org, fund, and program.  Use it to review period 0 balances (beginning of the fiscal year balances), July increments, current year salary adjustments, control unit and campus budget allocations (these are transaction code categories in the Budget system).

Temporary Budget
 

Curyr Position Funding	Groups salary funding transactions coming from the Permanent Budget to the Temporary Budget by position, org, and fund.  The position number is picked up from the journal line description in the temporary budget entry.  Use this report to check the temporary budget funding for July Adjusted Budget, merit, range or reclass funding for positions.
Journal Activity by Account	Lists journal line activity by Fund, Org, Program, Project, Flexfield.  Can be run by month or YTD.  Use this report instead of the Standard or Expanded Detail report if you only want to see your Temporary Budget activity (no Actuals Activity included).
Reappropriations	Summarizes temporary budget reappropriations to department (Level 4 node on the Org tree), fund, and program for reporting required as part of the EVCP and Campus Budget call. In the fund category, you can pick a single fund, a range of funds, a fund node, or "Budget Rpt" which will give you the range of funds that the Budget Office has been focusing on for the past several years. This range includes State, Opportunity, Student Fee, Sales & Service, Auxiliary and Reserve funds. If you choose to "ignore" fund, you will see all reappropriations for your unit. (If you choose this option, remember that contract and grant funds are "inception-to-date" funds and do not have reappropriations.) It is used by executive management in the campus and EVCP annual budget processes.
Sum by Transcode Category	Summarizes data by Accounting Period and Transaction code. Results can be viewed by Fund, Org, Account, Program or Fund/Program values and nodes.
TB vs PB July Adj Budget	Compares the July Adjusted Budget entries for the Temporary and Permanent Budgets.  Use this report at the beginning of each fiscal year to check that your July Adjusted Budget funding in the Temporary Budget matches the July Adjusted Budget shown in the Permanent Budget.

Payroll Reports