Reconciliation Reports
The reconciliation reports provide the individual and summary level financial transactions (Daily Revenue and Expense) of the departments. They are meant for internal use only and are not financial statements. All transactions that don't have the source of 'YTD', 'LTD' andf not having a fund code of '8000' are displayed. The departments are grouped under divisions.
Report Elements Glossary Table
Report : Reconciled Transactions Report |
---|
Prompts
Fiscal Year -> Division ->Department
Tab 1:
This report
Filters
Report Elements
The table below lists all the elements used in the Reports.
Element | Source (System->Table->Column) | Description | Frequency of Update |
---|---|---|---|
Fiscal Year | [Finance].[dbo].[REC_DivDepts]->[FiscalYear] | ||
Division | [Finance].[dbo].[REC_Divisions]->[DivID]/ DivName] | ||
Department | [Finance].[dbo].[REC_DivDepts]->[Deptid] [Finance].[dbo].[REC_Rev_Expense]->Dept_DESC | ||
Reporting Month | [Finance].[dbo].[REC_Rev_Expense]->REPORTING_PERIOD Calculated | ||
Type | [Finance].[dbo].[REC_Rev_Expense]->[REVEXP_TYPE] | Values include Revenue or Expense | |
Fund Code | [Finance].[dbo].[REC_Rev_Expense]->[FUND_CODE] | ||
Fund Description | [Finance].[dbo].[REC_Rev_Expense]->[FUND_DESC] | ||
Trans Description Report | [Finance].[dbo].[REC_Rev_Expense]->[TRANS_DESC_RPT] | ||
Posted | [Finance].[dbo].[REC_Rev_Expense]->[POSTED_DATE] | ||
Doc Num 1 Report | [Finance].[dbo].[REC_Rev_Expense]->[DOC_NUM_1_RPT] | ||
Invoice | [Finance].[dbo].[REC_Rev_Expense]->[INVOICE] | ||
Actual Amount | [Finance].[dbo].[REC_Rev_Expense]->[ACTUAL_AMT] | ||
Reconciled | [Finance].[dbo].[REC_Rev_Expense]->[Reconciled] | ||
Report Run Date | Date that the report data was refreshed from source | Real Time |