Summary

The Asset by Fund Report groups and totals the asset transactions by GL fund. The transactions that display on the report will also be grouped by the type of transactions such as Asset, Investment in Fixed Assets, Depreciation Expense and Accumulated Depreciation.

When an asset is installed, there will be an asset and investment in fixed assets transaction. When an asset is depreciated, there will be an accumulated depreciation and a depreciation expense transaction. When an asset is disposed, there will be an asset and a disposal transaction. Since the disposal transaction does not display on the report, only the asset transaction will display on the report.

Step by Step

1     Open the Assets by Fund Report (FA> Reports> Assets by Fund).

2     Configure the report. 

• The Transaction Date From and Transaction Date To fields are used to filter the transactions that will display in the report.
  • You can examine the transaction associated with an asset on the Fixed Asset Maintenance window (FA> Maintenance> Fixed Asset> Transactions tab).
• The Section 1 From and Section 2 To fields are used to filter the transactions that will be included in the report by fund.
  • The report will display the total transactions for each fund included in the report.
  • The Fund fields will not format the value to match the format of the fund.
  • The labels of these fields may be customized by agency.
• Check the Show GL Accounts toggle to include the GL accounts associated with the transactions in the report. If this toggle is not checked, the report will only display the total transactions by fund.
• Check the Show Assets toggle to include the asset number and asset description in the report.
• The report will display the Fund and Description for each transaction. The GL Account and Asset number will also be displayed if the corresponding toggles are checked. A report total will also be provided.

3     Print the report.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button will be displayed by default.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and click SUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button   on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.