Fixed asset reports
See each asset's cost, depreciation and net book value, the assets you disposed of with their gain or loss, and next months' depreciation.
Before you start
- Set up fixed assetsAsset classes, categories and fixed asset posting groups decide which accounts each asset posts to and how it depreciates.
- Register a fixed assetOnly registered assets appear in the register and the schedule.
- Dispose of a fixed assetThe Disposal Report lists posted disposals.
- Close a periodThe Depreciation Schedule uses your fiscal months.
In this article
Three reports:
| Report | Where | Answers |
|---|---|---|
| Asset Report | Reports › Asset Report | What do we hold, what did it cost, how much has it depreciated, and what is it worth now? |
| Disposal Report | Reports › Disposal Report | Which assets did we sell or scrap, and at what gain or loss? |
| Depreciation Schedule | Reports › Management Reports › Depreciation Schedule | How much depreciation has posted each month, and how much will post in the coming months? |
The Asset Report and Disposal Report need the fixed asset report permission.
Steps
Run the Asset Report
Select Reports › Asset Report. It opens for This Month.
- Date: Today, This Week, This Month, This Year (1 January to 31 December) or Custom Range.
- Apply.
- Search by asset or category.
- Export saves the table to Excel.
- The columns, explained below.
- Total of every column.
Run the Disposal Report
Select Reports › Disposal Report, choose the Date and select Apply. You get Asset Name, Category, Disposal Date, Cost, Accum. Dep., Net Book Value, Sales (the price) and Profit / Loss. With no disposals in the range you see "No data available".
Run the Depreciation Schedule
Select Reports › Management Reports › Depreciation Schedule. Choose the Period (usually Fiscal year), a date in it, and one Asset category or All categories, then select Run.
- Period.
- A date in the period.
- Asset category.
- Run.
- The date from which months are projected.
- Projected months are shaded and in italics: what the monthly depreciation job will post if nothing changes.
Each asset shows Cost, Monthly charge, one column per month, Total for period and Net book value at end.
How the figures are worked out
Asset Report
| Column | How it's worked out |
|---|---|
| Which assets | Every asset bought or put in service on or before the end date and still held then. An asset disposed of by the end date moves to the Disposal Report. |
| Cost | The asset's cost. |
| Accum. Dep. B/F | Depreciation posted for the asset before the start date. Reversals cancel their originals. |
| Dep. for Year | Depreciation posted from the start date to the end date (the range you chose, not necessarily a year). |
| Accum. Dep. C/F | Brought forward + the period's depreciation. |
| Net Book Value | Cost less accumulated depreciation carried forward. |
Disposal Report: posted disposals with a disposal date in the range (drafts are left out). Accum. Dep. is the depreciation the asset had on its disposal date, Net Book Value is cost less that, and Profit / Loss is the price less the net book value: positive is a gain, negative a loss. These are the figures the disposal posted.
Depreciation Schedule: months up to the current month come from the ledger; later months are projected from each asset's monthly charge. Nothing is posted by this report.