Fiscal Year 2007-2008 Banner Fixed Assets Reports and Programs
REPORTS:
FWRFAAC - ANNUAL CAPITALIZATION REPORT / PROGRAM ACTIVITY by ACCOUNT WITHIN FUND
Provides a summary of expenditures for selected Accounts (4xxxx) for each Fund within Programs (9000 - Plant Construction, 93000 - Plant Improvement, and 97xxx - Renewal and Replacement) for the selected Fiscal Year and Accounting Period. (Remember to leave the from/to date range parameters blank to include the accrual period.) Report is used to complete the Annual Capitalization forms/reports and identify amounts needed for Fixed Asset adjustments to update Banner FIS fixed asset accounts in the auxiliary enterprise, service department, and/or investment in plant funds for Land, Buildings, Infrastructure, Land Improvements, and IOTBs.
FWRFAAM - NON-EXPENDABLE INVENTORY MISSING REPORT
Provides a list of active non-expendable records, with a Location code of B0MIS. Report is used to identify assets that are coded as missing and need to be reviewed at least annually. Report includes: Asset Tag Number, Responsible Organization (and Title), Description, Title-To, Condition, Adjusted Cost, and totals of records and Adjusted Cost.
FWRFADP - Depreciation Expense Reconciliation Download
Provides tab delimited files for Operation Ledger depreciation expense detail, General ledger accumulated depreciation detail, Fixed Assets Depreciation Adjustment history with master data, Fixed Assets Depreciation history document detail, Reconciliation Exceptions (mismatch lists) and a depreciation expense reconciliation summary page for specified fiscal year.
FWRFADT - NON-EXPENDABLE INVENTORY FILE for MOSS ADAMS
Creates Fixed Assets file for all owned and active records. Selected fields are included in file. Used for Fixed Assets audit. The file produced by this program should be sent (FTPd) to ITS.
FWRFAIA - NON-EXPENDABLE INVENTORY ANNUAL REPORT
Provides a list of assets by Location, within Organization. Totals for records and Adjusted Cost by Location, Organization, and Chart. Report used to take Annual or Bi-Annual inventory. Certification is printed on the last page for each Organization. Parameters include reports for all (A), a range of (R) or specific (S) Organizations.
FWRFAIB - NON-EXPENDABLE INVENTORY REPORT - INDIRECT COST SUMMARIES BY BUILDING REPORT
Same as FWRFAIC except Location is by building.
FWRFAIC - NON-EXPENDABLE INVENTORY - INDIRECT COST SUMMARIES REPORT
Provides a list of owned assets by Acquisition Code by Location for each Functional Use.
FWRFAII - NON-EXPENDABLE INVENTORY INSURANCE REPORT
Provides a list of insured assets by Location, within Organization. Totals for records and Insurance Value by Location, Organization, and Chart. Report used to identify insured inventory.
FWRFAIL - NON-EXPENDABLE INVENTORY LOCATION (By Building) REPORT
Provides a list of assets by Location (2nd level, building) and totals for records, Adjusted Cost and Insurance Value by building Location within Chart. Report used to identify assets within buildings. Parameters include reports for all Locations (A), a range of Locations (R) or specific Locations (S) (up to six). Invalid Locations print first.
FWRFAIM - NON-EXPENDABLE INVENTORY OVER $1 MILLION INSURANCE REPORT
Provides a list of assets over $1 million in Insurance Value by Location within Organization. Totals for records and Insurance Value by Location, Organization, and Chart. Report used to identify high value assets on inventory.
FWRFAIN - NON-EXPENDABLE INVENTORY NON-OWNED INSURANCE REPORT
Provides a list of non-owned insured assets by Location, within Organization. Totals for records and Insurance Value by Location, Organization, and Chart. Report used to identify non-owned insured inventory.
FWRFAIP - NON-EXPENDABLE INVENTORY INVESTMENT IN PLANT REPORT
Provides a list of owned assets and their Adjusted Cost and Accumulated Depreciation. Totals for records can be provided by Location, Organization, or Chart. Report used to identify capital assets included in the General Ledger Investment in Plant Fund, Auxiliary, and Service Department funds. The report will include all current capital assets, and both Real and Personal Property. Chart total for this report plus any assets waiting to be added or deleted on the Fixed Asset Master file should equal the General Ledger. Three selections are available: L (Location), O (Organization), and C (Chart).
FWRFAND - NON-DEPRECIATED ASSET RECORDS REPORT
Provides a list of active depreciable assets that are not fully or in part depreciating. This is a monthly control report. The report should be run, and all problems resolved, prior to running the Banner depreciation process each month. The report identifies depreciable assets that have either a null depreciation post code or null accumulated depreciation amount on any capitalization/depreciation sequence within the maximum change sequence number of an asset. Please note that the report identifies 'problem' records as well as records 'in process'. It also identifies depreciable records prepared for depreciation since the depreciation process was last run and that may actually be okay. The Ptag date and depreciation post code is included in the output to help in the evaluation/problem resolution of identified records.
FWRFAPA - FIXED ASSET POST AUDIT ERROR REPORT
Produces an audit report identifying fixed asset records that fail any of a number of post audit checks. This is a monthly control report. The report should be run, and all problem records resolved, prior to running the Banner depreciation process each month. The report displays the Ptag, Otag, Error messages, Field/(column) Name and current problem data.
FWRFARP - Fixed Asset record funding/capitalization detail report
Provides a report of all owned and active Fixed Asset records similar to the FWRFADT report. However, this report includes additional data and presents asset records with a breakout of their funding & capitalization information along with a funding logic flag for use in F&A calculations.
FWRFASN - NON-EXPENDABLE INVENTORY NON-OWNED REPORT
Same as FWRFAIN except all non-owned assets are selected. Option to select range of Organizations or specific Organizations (up to six).
FWRNIPR - GENERAL LEDGER TO FIXED ASSET SUBSIDIARY RECONCILIATION
This report reconciles the General Ledger Fixed Asset and Accumulated Depreciation values to the Fixed Asset Subsidiary Ledger and reports differences. (After June 30, remember to set the 'Fiscal Year' parameter to '04' and the 'Reconcile Fiscal Year' parameter to 'P' to reconcile FY 05 General Ledger to Fixed Asset.)
PROGRAMS:
FWRFAAX - NON-EXPENDABLE INVENTORY INFLATION PROGRAM
Increases or decreases Insurance and Replacement Value annually by predetermined percent. The percent varies from year to year and is communicated to the Controller's Division by OUS Risk Management.
FFPDEPR - DEPRECIATION PROCESS
This process calculates depreciation and updates the Fixed Asset Subsidiary Detail Records, and posts accounting entries to the General and Operating Ledgers for Accumulated Depreciation and Depreciation expense. The process must be run quarterly but it is recommended that it be run monthly. June depreciation should be processed and recorded in Period 12. (A final run for late entries added during Period 14 can be performed to post to Period 14.)
