All GAAP reports are canned reports and are located under the Reports menu. They are generated in PDF format only. The reports contain separate pages for each fund type (governmental, proprietary, fiduciary).

The GAAP reports exclude:

Items that do not meet capitalization criteria.
Items which have a status of: "disposed of", "inactive", or "old tag item."
Items coded as operating leases.

1 Fixed Asset By Source
- 1.1 Generating a Fixed Asset By Source Report
- 1.2 More Information about the Fixed Assets By Source Report
  - 1.2.1 How amounts are included on the report:
  - 1.2.2 Assets with Unknown Funds
  - 1.2.3 Acquisitions Prior to System Start-Up
2 Fixed Asset by Function/Class
3 Schedule of Change in Fixed Assets
4 Schedule of Change in Depreciation

Fixed Asset By Source

Classic Counterpart: EIS101

The report provides a summary of the original cost of fixed assets by their source. Source means it uses the acquisition method and account code's fund to determine what line the item's amount should be included on in the report. If the GAAP flag is checked in Core>Configuration, this report may be generated in preparation for closing for the fiscal year.

Separate section for each fund type (governmental, proprietary, fiduciary). The fund type is determined by looking up the fund type associated with the "fund" on the item.
Uses the acquisition method and the fund from the account code on the acquisition transaction to determine what line the item should fall on.
- Acquisition methods that include donated, leased, and other will each have their own line.
- Purchased items are listed by the source fund that they were purchased from (fund dimension on the account code from the acquisition transaction).
- More information on how acquisition information is included is detailed under 'More Information about the Fixed Assets by Source Report'.
More information on 'Acquisitions Prior to System Start-up" is detailed under 'More Information about the Fixed Assets by Source Report.'
More information on 'Unknown Funds' is detailed under 'More Information about the Fixed Assets by Source Reports'.

Generating a Fixed Asset By Source Report

The example below contains a sample Schedule of Fixed Assets by Source report and includes a snippet of an acquisition record that contributes to part of the 501 fund amount. Please refer to the "How Amounts are Included on the Report" section under 'More Information about Fixed Assets by Source' for further information on how acquisition amounts are determined on this report.

Field Definitions:

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
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.

More Information about the Fixed Assets By Source Report

How amounts are included on the report:

If the fund dimension of the account code is blank/zeroes (000), it will reference the asset fund’s fund type and include the amount in that fund type section of the report under ‘acquisitions prior to system startup’ amount .

If the fund dimension of the account code is blank/zeroes (000) and the asset's fund is blank as well, it will include the amount in the 'acquisitions prior to system startup' under the unknown fund type section of the report.

If the acquisition contains a fund dimension on the account code, and the fund dimension is listed in Core>Funds, it will display the fund dimension on the report under its associated fund type

If the acquisition contains a fund dimension on the account code but the fund dimension is not listed in Core>Funds, it will display the fund dimension on the report under the associated item's asset fund fund type

Assets with Unknown Funds

If there are amounts in the unknown funds section, it may be due to:

The fund code for an item that does not have a defined "fund type" in Core>Funds
- To locate and correct items with a missing fund type:
  - Locate: Access Core>Funds and ensure all funds listed contain a fund type.
  - Correct: If some don't, edit and add the correct fund type
Tags that have a missing "fund" in Transactions>Items
- To locate and correct items with a missing fund:
  - Locate: Run a Brief Asset Listing of all tags, Active, New, Excess Asset Held for Sale and Excess Asset Not in Use status codes, capitalized only, sorted by fund. Another option is to access the Items grid, filter by active, capitalized assets, and sort by fund (ascending order). Items with a missing fund should be displayed at the top of the grid.
  - Correct: Please review the fund column for missing fund codes and create transfer transactions to add the missing fund codes to the item.

Acquisitions Prior to System Start-Up

If there are amounts under a fund type section listed as 'Acquisitions Prior to System Start-up,' it may be due to:

The tag does not have an associated acquisition, and/or
The fund dimension of the account code on the acquisition record is missing.
To locate and correct items with missing acquisitions
- Locate: Run a Brief Asset Listing for capitalized items with status of Active, New, Excess Asset Held for Sale and, Excess Asset Not in Use, sorted by Tag #. Next, run an Asset Listing by Grant/Source Report for capitalized items with status Active, New, Excess Asset Held for Sale and, Excess Asset Not in Use, and sort by tag #. Compare the reports, looking for tags that appear on the Brief Asset but not on the Asset Listing. (Tag # should have at least one acquisition record on the Asset Listing by Grant/Source report).
- Correct: Add a ‘historical’ acquisition record via Transactions>Acquisitions and leave ‘update original cost’ unchecked. Enter the fund dimensions in the account code (i.e. 001) and the original cost as the acquisition amount. The acquisition date entered must be in an open period.
To locate and correct items with missing fund dimension in the account code
- Locate: Run an Asset Listing by Grant/Source Report for capitalized items with status of Active, New, Excess Asset Held for Sale and, Excess Asset Not in Use, and sorted by Fund and Fund Type. Accounts with missing fund dimensions should appear at the beginning of the report due to the sort in order to easily compare with the acquisitions prior to system start-up totals on the Fixed Assets By Source report.
- Correct: Edit the Acquisition record and add the missing fund dimension in the account code

Fixed Asset by Function/Class

Classic Counterpart: EIS102

The report provides a schedule of fixed assets by function and class. The schedule can be generated by function and class, class, or a summary by function and class. If the GAAP flag is checked in Core>Configuration, this report may be generated in preparation for closing for the fiscal year.

Determines the appropriate line/column on the report by looking at the function/activity code and the asset class code in Transactions>Items.
Separate page for each fund type (governmental, proprietary, fiduciary). The fund type is determined by looking up the fund type associated with the "fund" in Items.
More information on 'Invalid Function or Invalid Class' areas of the report is detailed under 'More Information about the Fixed Assets by Function/Class'
More information on 'Undetermined Amounts' is detailed under 'More Information about the Fixed Assets by Function/Class.

Book Value = Original Cost - Total Depreciation (LTD + YTD)