NetAsset - Asset Register

Purpose 

The Asset Register report is a Netgain scripted report that contains a full listing of all assets with other information such as asset type, subsidiary, status, and period beginning and starting balances.

How To

Navigation:

NetAsset > Reports (All or Subledger Reports) > Asset Register > Run

Filtering:

The report search can be narrowed down by adjusting the filters for subsidiary, department, location, accounting period, class, location, or date range. Once filters are set as desired, click the refresh arrow to apply the filters and to view the report.

Results

Upon running the schedule the user will see a summarized detail of the asset register for the selected period, with information such as depreciation, write-downs, true-ups, and transfers.  Select the Export button to download report into Excel.  

Customization

This asset register report can be customized to reorder or add fields not already shown on the report. To do this, navigate to NetAsset > Reports (All or Subledger Reports) > Asset Register > View. Next, click Edit. Once in edit mode, navigate to the tab labeled Advanced Configuration. Once on this screen, you can add any fields desired by adding it to the list of fields on the report. You can also reorder the way the columns are organized by clicking and dragging a field to the desired location. 

Troubleshooting

Is the report missing assets?

1. If desired assets do not appear in the report, check the selected filters to ensure assets are not being restricted from view.

Is the report showing the schedule line dates instead of the actual transaction posting dates?

If you backdated asset activity—by placing an asset in service in the past or running catch-up depreciation—you can change this report to reflect the actual posting dates of transactions rather than the scheduled line dates. 

  1. Navigate to the Asset Register Report (NetAsset > Reports > Subledger Reports > Asset Register Report)
  2. Click 'Edit'
  3. Open the Advanced Configuration subtab
  4. Check the box labeled 'Use Posting Dates When Available'
  5. Click 'Save'
Was this article helpful?