Skip to content
logo Knowledgebase

Can I report on my fixed assets?

Created on  | Last modified on 

Summary

In Sage 50 Accounts Professional you can create records for any fixed assets your business owns. This means you can keep track of which assets are bought and sold, and what your assets are currently worth. There are several reports available which provide information about your fixed assets. You can't report on assets that have been disposed of.

Resolution

To view the fixed asset reports, on the navigation bar click Fixed assets, then click Reports. The standard reports are available in the Fixed asset list and Fixed asset valuation folders.

Fixed asset list reports

A Fixed Asset CSV report - FXDASTCSV.report is also available to export fixed asset information to a CSV file. For further information, please refer to Ask Sage article .

Fixed Asset Category List - ASSCATL.report

This report shows each fixed asset category, with the category number and name for each fixed asset category set up in Sage Accounts.

Fixed Asset List - ASSLIST.report

This report shows the details of each fixed asset taken from the details tab of the Fixed Asset Record.

Fixed Asset List By Category - FA_LSTBC.report

This report lists each fixed asset category, then for each asset category it lists the associated assets. For each asset it then displays the following information:

  • Asset reference - The unique reference for the asset.
  • Details - The description of the asset.
  • Cost price - The price at which the asset was purchased.
  • Net book value - The current value of the item, exclusive of VAT.
  • Purchase date - The date on which the asset was purchased, taken from the Details tab of the Fixed Asset Record.
Fixed asset valuation reports

Fixed Asset Valuation - ASSVAL.report

This report shows the valuation of each fixed asset. It also includes the following information:

  • Cat - The fixed asset category to which the item belongs.
  • Ref - The unique reference entered for the item.
  • Description - The additional information entered to describe the asset.
  • Bal N/C - The balance sheet nominal code used to post depreciation.
  • Cost Price - The price at which the asset was purchased.
  • Dep Type - The type of depreciation set for the asset, for example Straight.
  • Dep % - The percentage set as the depreciation rate for the asset.
  • Next Dep - The amount to be posted at the next month end as depreciation.
  • Depreciation To Date - The total amount of depreciation already posted.
  • Total Depreciation - The total depreciation to date, calculated by taking the book value of the item from the original cost price.
  • Book Value - The current value of the item, exclusive of VAT.

Fixed Asset Valuation by Category - FA_VALBC.report

This report shows each asset category, then for each category it displays the associated assets. For each asset it displays the following information:

  • Asset Ref - The unique reference entered for the item.
  • Details - The additional information entered to describe the asset.
  • Cost Price - The price at which the asset was purchased.
  • Depreciation Rate - The percentage set as the depreciation rate for the asset.
  • Depreciation to Date - The total depreciation to date, calculated by taking the book value of the item from the original cost price.
  • Net Book - The current value of the item, exclusive of VAT.

Fixed Asset Valuation by Department - FA_VALBD.report

This report lists each department, then for each department it displays the associated assets. For each asset it displays the following information:

  • Asset Ref - The unique reference entered for the item.
  • Details - The additional information entered to describe the asset.
  • Cost Price - The price at which the asset was purchased.
  • Depreciation Rate - The percentage set as the depreciation rate for the asset.
  • Depreciation to Date - The total depreciation to date, calculated by taking the book value of the item from the original cost price.
  • Net Book - The current value of the item, exclusive of VAT.