...

• Report Type Options:
  • Asset Class: Grouped by Asset Class codes defined in Core>Asset Classes
  • Fund: Group by Fund Codes defined in Core>Funds
  • Function: Grouped by Function codes defined in Core>Functions
• Include and/or Exclude Entity IDs: is currently stored on the Item record and is used to identify different entities within the same reporting entity. This ID can be used to exclude all items belonging to a particular entity from the GAAP schedules or to generate schedules for specific entities. You will need to comma separate the ids if you enter more than one or the report will be blank
• Summary

Assets with Unknown Fund Type

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

• there are tags that do not contain a "fund" field in ITMSCN; and, or
• the fund code for a tag does not have a defined "fund type" in Core>FundsTo locate and correct:
• Access Core>Funds and ensure all funds listed contain a fund type.  If some don't, modify and add the correct fund type.
Run an Brief Asset Listing of all tags, A, N, EH, EN status codes, capitalized only.  Please review the columns for missing fund, function or asset class codes and create transfer transactions to add the missing fund codes to the tags. 
• If checked, a summarized report is generated.  Columns on the summary report are explained below. 
  • Beginning Balance - Total original cost amount :  Beginning Balance amount (aka existing original cost) of active, capitalized assets that exist at the beginning of the year
  • Acquisitions - Acquisitions during the fiscal year
  • Dispositions - Dispositions during the fiscal year
  • Transfers In - Amount for items transferred into this code
  • Transfers Out - Amount for items transferred out of this code
  • Adjustments - Includes net amount of any transactions which have the error adjustment flag equal to "Y". Also includes amounts for items which switched capitalization status (see below).
  • Ending Balance - Total original cost amount at the end of the year
• If Summary is left unchecked, a detailed report is generated including the items that make up the amounts in the summary change schedule.
• Show Report Options: includes a printout of the report options selected for the report run.  If selected, it is always the first page of the report.

...

• • • :  May be the entire org cost for a newly created capitalized item or it could be the acquisition amount for an additional acquisition entered for an existing capitalized item (of which the remaining org cost of the existing item would be included in the beginning balance)
      • NOTE: If an existing item has an additional positive acquisition amount entered during the year bringing it over the capitalized threshold thus changing it from non-capitalized to capitalized, the additional acq amount will appear in the acquisition column and the rest of the org cost of the item appears will appear as a positive amount under the adjustment column.  The beginning balance column will NOT be affected.
      • NOTE: If an existing capitalized item has an additional negative acquisition amount entered during the year bringing it under the capitalized threshold thus changing it from capitalized to non-capitalized, the additional negative acquisition amount will appear in the acquisition column and the rest of the org cost of the item appears will appear as a negative amount under the adjustment column.  The beginning balance column will NOT be affected.
    • Dispositions: Original cost amounts of capitalized, active items that are part of the beginning balance but have since been disposed of during the fiscal year
    • Transfers In - Original cost amount for active, capitalized items transferred into this code (fund, function or asset class) during the fiscal year
    • Transfers Out - Original cost amount for active, capitalized items transferred out of this code (fund, function or asset class) during the fiscal year
    • Adjustments - Includes amount for active, capitalized transactions which have the error adjustment flag checked. May also includes amounts for items which changed their capitalization status during the fiscal year (noted above under acquisitions)
    • Ending Balance - Total original cost amount at the end of the year.  This is a calculated figure.
  • If Summary is left unchecked, a detailed report is generated including the items that make up the amounts appearing in the acquisition, disposition, transfer in/out and adjustment columns in the summary change schedule.
• Show Report Options: includes a printout of the report options selected for the report run.  If selected, it is always the first page of the report.

Anchor
103 103

More Information about the Schedule of Changes in Fixed Assets

Capitalization Criteria changes impacts on the Schedule of Change in Fixed Assets

If 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 ENTIRE original cost appears as a positive adjustment under the Adjustments column on the report.  The Beginning Balance column is not affected.  If capitalization criteria was run INCREASING the current threshold so that an item has now changed from capitalized to non-capitalized, the ENTIRE original cost appears as a negative adjustment under the Adjustments column on the report.  The Beginning Balance column is not affected.

Assets with 'Undetermined' Funds

• If generating a Schedule of Change in Fixed Assets by Fund, Function or Asset Class, if there are amounts in the 'Undetermined" area of the report, it could be due to:
  • a related missing fund type under Core>Funds for a capitalized, active item. 
    • In order to find the tag tied to this amount:
      • Under Core>Funds, filter for any funds with a missing or 'undetermined' value in the fund type field.
        • To Fix: Edit the fund in Core>Fund selecting the appropriate Fund type (Governmental, Proprietary or Fiduciary).  The amount will no longer be listed under the 'undetermined' area of the Schedule of Change in Fixed Assets reports.

Image Added

• • or if labeled on the report as 'unknown function' or 'unknown asset class' in the description column, it may be a missing asset class or function on a capitalized, active item. NOTE: Please refer to 'Assets with Unknown Funds' for items with a missing fund.
    • In order to find the tag tied to this amount:
      • If the amount is under the beginning balance, filter the items grid for active, capitalized assets and sort by function and/or asset class in ascending order.  It should display the items with a missing function and/or asset class. 
        • To Fix: Create a transfer transaction for the item to add the missing function and/or asset class to the item and the amount will no longer be listed under the 'unknown' area of the Schedule of Change in Fixed Assets reports.

Image Added

• • • • If the amount is under the acquisition, disposition, transfer in/out or adjustment columns, please generate a Schedule of Change in Fixed Asset detail report for a listing of tags that make up these amounts. 
        • To Fix: Create a transfer transaction for the item to add the missing function or asset class to the item and the amount will no longer be listed under the 'unknown' area of the Schedule of Changed in Fixed Assets reports

Assets with Unknown Funds

• If generating a Schedule of Change in Fixed Assets by Fund, if there are amounts in the "Unknown" area of the report, it could be due to a missing fund on a capitalized, active item. 
• In order to find the tag tied to this amount:
  • If the amount is under the beginning balance, filter the items grid for active, capitalized assets and sort by fund in ascending order.  It should display the items with a missing fund code. 
    • To Fix: Create a transfer transaction for the item to add the missing fund to the item and the amount will no longer be listed under the 'unknown' area of the Schedule of Change in Fixed Assets reports.

Image Added 

• • If the amount is under the acquisition, disposition, transfer in/out or adjustment columns, please generate a Schedule of Change in Fixed Asset detail report for a listing of tags that make up these amounts. 
    • To Fix: Create a transfer transaction for the item to add the missing fund to the item and the amount will no longer be listed under the 'unknown' area of the Schedule of Changed in Fixed Assets reports.

...

Schedule of Change in Depreciation

...