Reconciliation Reports
The reconciliation report reports provide the individual and summary level financial transactions (Daily Revenue and Expense) of the departments, along with their reconciliation status. They are meant for internal use only and are not financial statements. All transactions that do not have the source of "YTD" or "LTD" and do not have a fund code of "8000" are displayed. The departments are grouped under divisions.
Table of Contents | ||
---|---|---|
|
Report Elements Glossary Table
...
Report : |
---|
Reconciled Transactions Report |
Prompts
Fiscal Year -> Division ->Department
Tab 1:
This report
Filters
report provides the individual and summary level financial transactions (Daily Revenue and Expense) of the departments, along with their reconciliation status.
Filters
Report Elements
Anchor | ||||
---|---|---|---|---|
|
The table below lists all the elements used in the Reports.the reports. Detailed glossary entries for these elements can be found in the MetaMart (https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1)
Element | Source (System->Table->Column) | Description | Frequency of Update | ||||||
---|---|---|---|---|---|---|---|---|---|
| |||||||||
| |||||||||
| Sid->Sid_Admissions->termid | Student's Term of Admission | Latest Benchmark|||||||
Fiscal Year | [Finance].[dbo].[REC_DivDepts]->[FiscalYear] | This field holds the fiscal year. | Daily | ||||||
| [Finance].[dbo].[REC_Divisions]->[DivID]/ DivName] | Division is a grouping of multiple departments and is sometimes referred to as the super department. | Daily | ||||||
| [Finance].[dbo].[REC_DivDepts]->[Deptid] [Finance].[dbo].[REC_Rev_Expense]->Dept_DESC | This field holds the department ID and department description. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->REPORTING_PERIOD Calculated | This fields holds the fiscal month. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[REVEXP_TYPE] | Values include Revenue or Expense | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[FUND_CODE] | This field identifies the fund code associated with a record. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[FUND_DESC] | This field holds the fund description. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[TRANS_DESC_RPT] | This field holds the transaction description. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[POSTED_DATE] | This field holds the posted date. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[DOC_NUM_1_RPT] | This field holds the Document Number 1 Report. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[INVOICE] | This field identifies the invoice for Current Month records with a PIDM (P | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[ACTUAL_AMT] | This field contains the actual amount associated with a transaction. For Cash Total records, it is set to "0". | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[Reconciled] | Values are "Reconciled" or "Not Reconciled." | Daily | ||||||
Report Run Date
| |||||||||
Calculated | Date that the report data was refreshed from its source. | Real Time |
...