FDS Reports

The Financial Data Store (FDS) provides acces to financial data from ARC.  Financial data accessed from the FDS will be one day old, with the exception of Budget/COB data which is updated multiple times throughout the day.  Reports run from FDS can be viewed online, downloaded to multiple formats, printed, or saved.

 

There are 14 FDS Report Categories to choose from:

• ChartField Statements

• Claim on Cash Reports

• Consolidated Operating Reports (COB)

• Endowment Reports

• Financial Statements

• Fiscal Year-End Reports

• Fringe Benefit Reports

• Fund Balance/Overdraft Reports

• Payroll Reports

• Payroll Reports/QUARTERLY REPORTS

• Procurement Reports

• Project Lifecycle Reports

• Project Lifecycle Reports/QUARTERLY REPORTS

• Trial Balance Reports

 

Withing each category folder, a number of report options exist.  Select the one appropriate for your task.

 

Three examples of commonly used FDS reports are ChartField Detailed Statements, Sponsored Project Financial Reports, and Payroll Detail Reports:

  • The ChartField Detail Statement provides information on fiscal year-to-date financial activity for budget versus actuals, commitment/encumbrance balances as well as prior fiscal year balances.  The report parameters allow users to run this report at the department, project, initiative, segment, site and function levels (or any combination of these ChartFields).  The entire ChartField is included in the report results. Users are also able to drill down to transaction details for each account in the ChartString from either the “Month” or “Year” column. Actuals are compared to both current budget and prior year amounts, along with information for encumbrances and pre-encumbrances.
  • The Sponsored Project Financial Report (SPFR) tracks spending on specific Projects. PI's, Departments, and Central Offices, including SPA and SPF, may have access to this report. The Sponsored Project Financial Report aggregates financial information by Project, but may include a certain Activity Type or Activity selected when running the report. The user is also able to drill down to transaction level detail.
  • The Payroll Detail Statement enables users to see a variety of salary related amounts for individual employees, including a breakdown of payments and activity ranges per earn code. Use this report to review employee salary payments by Project, Combocode, Account, and Earn code. Period payments also show Transaction Start Date and End Date, Fringe breakouts by type (e.g.. A1 & A2) and Project Activity ranges. This report is particularly useful when processing Cost Transfers in PAC.

 

Here are the most frequently used FDS reports available for fiscal year lifecycle activities:

 

Fiscal Year Process

When

Primary Report to Use

Comparison of budget to actuals to assess account balances and review any anomalie;. also to confirm monthly closing actions

At least monthly and quarterly

ChartField Detail Statement (can also use COB Operating Summary)

Transaction reconciliation and to review all account activity (including Fund Balance accounts)

Weekly and monthly (before end of month so corrections will hit current period)

Trial Balance by Account Detail (can also drilldown in ChartField Detail Statement or ChartField Transaction Statement)

Monitor fund balance activity to check expenditures/revenues against available funding

Monthly, quarterly and yearly

Project Summary Statement

Encumbrance Maintenance

Monthly, quarterly and yearly

Purchase Order Open Commitment (can also use ChartField Detail Statement)

Salary Monitoring

Monthly, quarterly and yearly

Payroll Summary Statement Payroll Detail Statement

 

 

Here are the most used FDS reports providing information on Sponsored, Capital, and other projects that have Project Lifecycle budgets and activity. These projects typically have time periods that span multiple fiscal years.

 

Project Life Cycle Process

When

Primary Report(s) to Use

Comparison of budget to actuals to assess available balances and review any anomalies

Monthly, when Interim or Final Financial Reports are required, and at Project Expiration

Sponsored Project Financial Summary

Non-Sponsored Project Financial Summary

Reviewing appropriateness of transactions

Monthly, when Interim or Final Financial Reports are required, and at Project Expiration

Sponsored Project Financial Detail

Non-Sponsored Project Financial Detail

Encumbrance Maintenance (i.e. Purchase Orders, SAPOs)

Monthly, when Interim or Final Financial Reports are required, and at Project Expiration

Purchase Order Open Commitment

Monitor all Projects at a high level for a Department or  Principal Investigator

Monthly, quarterly and yearly

Project Cost Summary/Overrun

Monitor all Projects in a Cost Overrun (Expense Budget to Expense Actual)

Monthly, quarterly and yearly

Project Cost Summary/Overrun

Monitor F&A Recovery for a Department or Principal Investigator

Monthly, quarterly and yearly

F&A Recovery

Salary Monitoring

Monthly, quarterly and yearly

Payroll Summary Statement Payroll Detail Statement

 

How to run an FDS Report

How to Run FDS Reports

 

Review the FDS On Demand Reporting job aid for guidance on how to access and run a report from the Financial Data Store (FDS).


 

Scheduling an FDS Report

The FDS scheduling functionality enables users to schedule reports to run automatically at specified times.  When a scheduled report runs successfully, an instance of the report is created and the report is delivered to a destination specified by you, e.g. your Business Objects Inbox found on the LaunchPad.  If you are interested in obtaining the ability to schedule reports, please open an Incident in ServiceNow with CUIT, and request FDS report scheduling capabilities.  The request will be routed to the CUIT Enterprise Business Intelligence Solutions (EBIS) team who will respond.   For guidance on scheduling reports once access has been provided, click here.