Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Separate page for each fund type (governmental, proprietary, fiduciary). Fund type is determined by looking up the fund type associated with the "current fund" on Transactions>Items.
  • A separate detail report may be created showing all acquisitions, dispositions, transfers, and adjustments by tag number to back up the figures on the summary report.
  • More information on items affected by a change in their capitalization status during the year is detailed under 'More Information about the Schedule of Change in Fixed Assets' 
  • More information on areas of the report listed as 'unknown' or 'unclassified' is detailed under 'More Information about the Schedule of Change in Fixed Assets' 
  • The column totals on the detail report should match the corresponding totals on the summary report.

  • The grand totals for the Fixed Asset By Source, Fixed Assets by Function/Class, and the Schedule of Change in Fixed Assets should match since they all deal with original cost amount.    More detailed information is provided under 'More Information about the Schedule of Change in Fixed Assets'.  

Generating a Summary Schedule of Change in Fixed Assets Report 

...

  • Separate page for each fund type (governmental, proprietary, fiduciary). Fund type is determined by looking up the fund type associated with the "current fund" on Transactions>Items.
  • A separate detail report (default option) may be created showing all acquisitions, dispositions, transfers, and adjustments by tag number to back up the figures on the summary report.
  • More information on the depreciation of items affected by a change in their capitalization status during the year is detailed under 'More Information about the Schedule of Change in Depreciation' 
  • More information on areas of the report listed as 'unknown' or 'unclassified' is detailed under 'More Information about the Schedule of Change in Depreciation 
  • The column totals on the detail report should match the corresponding totals on the summary report.

  • The totals for the ending depreciation on the summary should match the total accumulated depreciation (LTD + FTD) on the Book Value report, provided capitalized and , active status (Active, New, Excess Asset Held for Sale and, Excess Asset Not in Use) are selected for the Book Value.  More detailed information is provided under 'More Information about the Schedule of Change in Depreciation'.

Generating a Summary Schedule of Change in Depreciation Report

...

More Information about the Schedule of Changes in Depreciation

Capitalization Criteria changes impacts on the Schedule of Change in Depreciation

For those items tracking depreciation:

  • If the capitalization criteria was run during the fiscal year DECREASING the current threshold so that an item has now changed from non-capitalized to capitalized, the LTD + FTD depreciation appears as a positive adjustment under the Adjustments column on the report.  The Beginning Depreciation column is not affected. 
  • If the capitalization criteria was run during the fiscal year INCREASING the current threshold so that an item has now changed from capitalized to non-capitalized, the LTD + FTD depreciation appears as a negative adjustment under the Adjustments column on the report.  The Beginning Depreciation column is not affected.

Assets labeled Undetermined or Unknown

Undetermined amounts are from capitalized items containing a fund with an invalid (missing or undetermined) fund type.

  • Locate: Run the report by fund.  It will display the fund codes under 'Undetermined'. View the fund under in Core>Funds to determine if the fund contains a missing (or undetermined) fund type. 
  • Correct: If the fund is missing a fund type or it states 'undetermined', edit in Core>Fund selecting the appropriate Fund type (Governmental, Proprietary or Fiduciary).  The amount will move from the 'undetermined' area to the appropriate fund type area on the report. 

Assets labeled as 'unknown' fund, function or asset class may be a missing a fund, function or asset class on a capitalized, active item. 

  • Locate:
    • If the unknown amount in under the Beginning Value, filter the items grid for active, capitalized assets and sort by function, function and/or asset class in ascending order.  It should display the items with a missing fund, function and/or asset class at the top of the grid. 
    • If the unknown amount is under the acquisition, disposition, transfer in/out or adjustment columns, generate a Schedule of Change in Fixed Asset detail report for a listing of tags that make up these amounts.
  • Correct: Create a transfer transaction for the item to add the missing fund, function and/or asset class and the amount will move from the 'unknown' area to the proper fund, function or asset class area depending on the report type generated. 

If there are amounts in the unknown fund type section of the summary report, it's because

...