Depreciation Schedule Report (older version)

Access the older version of the Depreciation Schedule. You'll need to use this older version of the report if you want to run estimated depreciation.

The Depreciation Schedule shows actual or estimated depreciation against assets in the asset register (only registered assets can be depreciated).

This report is also available as part of the management reports which you can access if you have the Advisor user role.
Management style reporting packages for month or year end

Your user role will determine whether you can see this report, and whether you can save and publish or just view it.
Reports and budget role comparison

Depreciation Schedule screen can be wide and requires a scroll bar to view the entire width of it.

What can you do with the Depreciation Schedule?

Other things you can do with this report:

Generate the Depreciation Schedule

To access the older version of the Depreciation Schedule:

  1. On the Reports menu, click All Reports.
  2. Under Fixed Assets, click Depreciation Schedule.

The Depreciation Schedule report is generated for a year. The first month that you can run the Depreciation Schedule from is your fixed asset start date.

Report options

Choose options by which to re-run the report:

Fields

Date

The month you want to use as the point to report back from the depreciation on assets in that month and back will be included e.g. April 2008 depreciation date will show the depreciation on assets in April and before. The default is the current month.

Show Depreciation as

Choose either Actual or Estimated to see actual depreciation in the months shown or estimated depreciation. The default is Actual.

Note: if you choose estimated depreciation then depreciation will be calculated on each asset from the start of the financial year or the purchase date for the period of the report (depending on the purchase date of each asset) and will be calculated up to end date of the report or the disposal date. 

Update

rep - button - update.png

Whenever the date range is updated, click Update to generate the report using the new dates.

If you are viewing a report produced by someone with the Advisor user role, you may see notes or a summary on the report. You may be able to export, archive or edit the report, depending on your user role.
Reports and budget role comparison

Filter by other options

Click the 'More options' link to unravel more options to allow you to filter the report.

More fields

Click the 'Fewer Options' link if you want to close this option.

Filter by

If you have set up tracking categories additional fields will display that match the categories set up so that you can filter the report by one or all of the options for each category.

Tracking options

  • Either one or both of the tracking categories you have set up will display.
  • By default, the report will not be filtered so all the transactions coded to each account listed for the dates of the report will be included.
  • For each tracking category displayed, you can choose to view the report with no filter (i.e. all the transactions in each account), one option or all options.

Set up tracking categories to monitor different areas of your business

Update

rep - button - update.png

Whenever filter options are chosen or updated, click Update to re-generate the report.

View depreciation on current assets

The report will display depreciation on current assets (those in the asset register as registered items) for the period selected.

Your report might look different each time depending on whether you have filtered the report, sorted it differently or changed the date.

Depreciation Schedule details screen.

  • Assets are shown by the asset name and grouped into the fixed asset account they have been coded to from the chart of accounts.
  • The asset Number is the unique number of the asset.
  • The asset Type is the asset type assigned to that asset.
  • The Cost is the purchase price of the asset.
  • Rate shows the current depreciation rate as a percentage.
  • The next column shows the method of depreciation. This will either be Declining Balance (DB) or Straight Line (SL).
  • Purchased is the date when the asset was purchased.
  • Disposed is the disposal date of the asset if it has been sold or disposed.
  • The first month shows the opening book value as at the start of the financial year.
  • Purchases show the purchase price of the asset item. If it was not purchased in the period of the report this figure will be zero.
  • Depreciation shows the actual or estimated depreciation for the period.
  • Accum Dep shows the accumulated depreciation at the end of the report period.
  • The Closing book value shows the book value as at the report date.
  • If you choose to filter the report by one option, the report will only show depreciation tracked to this option for the period of the report.

Depreciation Schedule filtered by Consulting Expenses.

View individual asset details

Click on the asset name or number to view details for that asset.

Click on the detail to view the asset.

Export your report

To export the report:

  1. Click Export, then select your preferred export option:

    • Excel
    • PDF (printable format)
    • Google Sheets
  2. Open, save or print the file as you need.