Page Comparison

...

• Separate section for each fund type (governmental, proprietary, fiduciary). The fund type is determined by looking up the fund type associated with the "fund" in Itemson the item.
• Uses acquisition method and fund from the account code on the acquisition transaction to determine what line the item should fall on.
  • Acquisition methods donated, leased, and other 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).
• Line "Acquisitions Prior to System Start-up" contains amounts for items with no acquisition records or blank fund on the account code used in the acquisition.
• Possible 'unknown fund type' section may appear at the end of the report if the 'fund' in Items is missing   
  • Please refer to the "More Information about the Fixed Asset by Source" section on how to locate and correct items contributing to the 'acquisitions prior to system start-up' or 'unknown fund type' amounts.

Generating a Fixed Asset By Source ReportSource 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. 

Anchor
101 101

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 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 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 fund type funds section, it's because:

• there are tags that do not contain a "fund" field in Transactions>Items; and, or
• the fund code for a tag an item does not have a defined "fund type" in Core>Funds
• To locate and correct:
  • Access Core>Funds and ensure all funds listed contain a fund type.  If some don't, modify edit and add the correct fund type.
  • Run a Brief Asset Listing of all tags, A, N, EH, EN status codes, capitalized only sorted by fund.  Please review the fund column for missing fund codes and creating transfer transactions to add the missing fund codes to the tags.

Image Added

Acquisitions Prior to System Start-Up

If there are amounts under each fund type section listed under 'Acquisitions Prior to System Start-up',  it's because:

• the tag does not have an associated acquisition; and, or
• the fund dimension of the USAS Account 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 A, N, EH, EN, sorted by Tag #.  Next, run an Asset Listing by Grant/Source Report for capitalized items with status A, N, EH, EN 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’ as “N”.  Enter TI and the fund dimensions in the account code (i.e. 05 001) and the original cost as the acquisition amount.  The acquisition date can be set to the date recorded in Items for this tag #entered must be in an open period.
• To locate and correct items with missing fund dimension in USAS Account the account code
  • Locate: Run an Asset Listing by Grant/Source Report for capitalized items with status of A, N, EH & EN and sorted by FO,FTFund and Fund Type.  Accounts with missing fund dimensions should appear at the beginning of the report due to the sort FO,FT in order to easily compare with the acquisitions prior to system start-up totals on the Fixed Assets By Source report.
  • Correct: Modify Edit the Acquisition record and add a the missing fund dimension in the account code

...