FXA - Asset Register
Overview
The Fixed Assets ‘Asset Register’ program generates a report providing asset financial detail as at a nominated period.
This is the main asset ledger financial report and should be used for verifying that the asset ledger is in balance with the various GL control accounts ('Original Cost' and 'Accumulated Depreciation').
For each asset, it displays:
Opening Cost, Accumulated Depreciation and Net Book Value (at period 1) | Additions (during the year) | Transfers (during the year) | Adjustments (during the year) | Depreciation Charge (for the year) | Disposals (during the year) | Closing Cost, Accumulated Depreciation and Net Book Value (as at the period selected) |
This report/export has extensive options that can be selected at run-time. These selections can be saved as your own report 'Configuration' profiles. A report 'Configuration' that you create can't be accessed by another user and vice versa. This is because each 'Configuration' is dependent on the individual user's security permissions that determine the fields that can be included.
To use a previously saved report configuration, select it from the 'Use a Previously Saved Configuration' picklist and click 'Next'.
The 'Use a previously saved configuration' picklist will only be available if a saved configuration exists.
To create a new configuration, click the 'Next' button without selecting an option from the 'Use a Previously Saved Configuration' picklist.
Enter your runtime options for the program.
To save the runtime options that you have entered as a re-usable report configuration, enter a meaningful description into the 'Save this Configuration as' field on the 'Process' or 'Print' tab.
You can delete a report configuration by selecting it from the picklist, clicking the 'Next' button, and then clicking the 'Delete' option.
You can modify an existing configuration by selecting it, making the necessary changes to the run-time options, then clicking 'GO' on the 'Process' or 'Print' tab. You need to ensure the 'Save this Configuration as' field is populated with the report configuration name. This field is populated automatically when an existing configuration is selected.
General Tab
Enter 'Search Criteria' into the 'General' tab to filter the data produced in the report. An accounting 'Year' and 'Period' must be entered to generate the report.
Fields that require detailed explanation | |
|---|---|
Purchase Date | This field allows a date range to be entered. The subsequent report will display only assets that were purchased during the range nominated. |
Category GL Location Physical Location | It is possible to select multiple options in these drop-down lists by using the 'Ctrl' key and right mouse-click in combination. |
Print Tab
Sort By
The default is for the report to sort by 'Asset Code'.
Alternatively, you can elect to sort by 'Asset Description', 'Category', 'GL Location', 'Physical Location', 'Category/GL Location' or 'GL Location/Category'.
Formatting Options
Choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel®, Microsoft Word® or a screen with hyperlinks.
The 'Screen with Hyperlinks' format is best if you need to 'drill-down' to further information.
Use the checkboxes to indicate your preference for displaying 'Alternate Row Colours' and 'Table Borders'. These options can enhance the readability of the report but are not available if the listing destination is Excel®.
There is an option to run this report in 'Detailed' mode or 'Summary Mode'.
'Detailed Report' lists each asset individually based on your selection criteria entered on the 'General Tab'.
'Summary Report' totals each asset based on the sort order entered. The summary option is only available for the following sort orders; 'Category', GL Location', 'Physical Location', 'Category/GL Location' or 'GL Location/Category'.
The logic for the inclusion of disposed assets is controlled by the following radio buttons:
Include current period disposals only | This is the default. It means that assets disposed of in any period prior to the period nominated on the 'General Tab' will not be included in this report. |
Include current year disposals only | It means that assets disposed of in any year prior to the year nominated on the 'General Tab' will not be included in this report. You would use this option to include all assets that have been disposed of this year. |
Include all disposals | This will include all assets that have been disposed of in the nominated and any prior accounting period/year. |
Click 'GO' to generate the report.