Depreciation & Fully Depreciated Reports
Depreciation is one of the most important aspects of asset management from a financial perspective. AccuArk provides three dedicated reports that help you review historical depreciation, plan for future depreciation expense, and identify assets that have reached the end of their depreciable life. This guide covers each report in detail.
Depreciation Schedule Report
The Depreciation Schedule Report (FrmDepreciationScheduleReport) shows a month-by-month breakdown of depreciation for each asset. This is the most detailed depreciation report and serves as the primary audit trail for depreciation calculations.
Purpose
This report provides a period-by-period history of depreciation entries. Each row represents one depreciation period for one asset, showing the beginning book value, the depreciation amount recorded for that period, and the resulting ending book value. Accountants and auditors use this report to verify that depreciation has been calculated correctly and consistently.
Columns
| Column | Description |
|---|---|
| Asset # | The unique asset identification number |
| Name | The descriptive name of the asset |
| Period | The month and year of the depreciation entry (e.g., Jan 2026) |
| Depreciation Method | The method used for this asset (Straight-Line, Declining Balance, Double Declining Balance, Sum-of-Years-Digits, or Units of Production) |
| Beginning Book Value | The book value of the asset at the start of this period |
| Period Depreciation | The amount of depreciation recorded during this period |
| Ending Book Value | The book value of the asset at the end of this period (Beginning Book Value minus Period Depreciation) |
Filters
- Location — Filter by a specific location or All Locations.
- Date Range — The From and To dates control which depreciation periods are included. For example, setting the range to January 2025 through December 2025 shows only the depreciation entries recorded during that calendar year.
Common Use Cases
- Verifying depreciation calculations — Review individual asset entries to confirm the depreciation amounts are correct. Compare the Period Depreciation amounts against your expected values based on the depreciation method and useful life.
- Audit support — Provide this report to auditors as documentation of your depreciation methodology and calculations. Export to PDF for formal documentation.
- Accounting reconciliation — Compare the total depreciation amounts in this report against the depreciation expense recorded in your general ledger to ensure they match.
Tips
- Set the date range to match your fiscal year when preparing year-end reports.
- If an asset shows unexpected depreciation amounts, check the asset's depreciation settings (method, useful life, salvage value) in the asset detail form.
- Use the CSV export to create a spreadsheet that you can sort and subtotal by category, location, or depreciation method.
Depreciation Forecast Report
The Depreciation Forecast Report (FrmDepreciationForecastReport) projects future depreciation amounts based on each asset's current depreciation method and remaining useful life. This is a forward-looking report designed for budgeting and planning.
Purpose
While the Depreciation Schedule shows what has already happened, the Depreciation Forecast shows what will happen. It calculates how much depreciation each asset will generate over the next 6 and 12 months, helping you plan for future expense impact and budget accordingly.
Columns
| Column | Description |
|---|---|
| Asset # | The unique asset identification number |
| Name | The descriptive name of the asset |
| Method | The depreciation method assigned to this asset |
| Current Book Value | The asset's book value as of today |
| Monthly Depreciation | The estimated monthly depreciation amount based on the current method and remaining useful life |
| Projected 6-Month Depreciation | The total projected depreciation over the next 6 months |
| Projected 12-Month Depreciation | The total projected depreciation over the next 12 months |
| Projected Book Value at End of Period | The estimated book value at the end of the 12-month projection period |
How It Works
The forecast calculation takes each asset's current book value, depreciation method, useful life remaining, and salvage value, then projects forward. The calculation floors at the salvage value, meaning that once an asset's projected book value reaches the salvage value, no additional depreciation is projected. For assets using accelerated methods (Declining Balance, Double Declining Balance), the projected amounts decrease over time as the book value decreases.
Filters
- Location — Filter by a specific location or All Locations.
Common Use Cases
- Budget planning — Use the Projected 12-Month Depreciation column to estimate next year's depreciation expense for budgeting purposes.
- Cash flow forecasting — Although depreciation is a non-cash expense, it affects your tax liability. Projected depreciation helps estimate future tax deductions.
- Understanding future expense impact — Identify which assets will generate the most depreciation expense in upcoming periods. This information is valuable when deciding whether to acquire new assets or delay purchases.
Tips
- Compare the forecast to actual depreciation runs periodically to verify accuracy.
- Assets that are already fully depreciated will show $0 across all projection columns.
- If you are considering changing an asset's depreciation method, run the forecast before and after the change to understand the impact on future periods.
Fully Depreciated Assets Report
The Fully Depreciated Assets Report (FrmFullyDepreciatedReport) identifies active assets that have been fully depreciated. These are assets where the accumulated depreciation has reached the depreciable base (total cost minus salvage value) but the asset is still in service.
Purpose
Fully depreciated assets deserve special attention. They are still in use but carry no remaining book value beyond their salvage value. This report helps you identify these assets so you can make informed decisions about replacement, disposal, or continued use.
Columns
| Column | Description |
|---|---|
| Asset # | The unique asset identification number |
| Name | The descriptive name of the asset |
| Category | The asset category |
| Location | The current location of the asset |
| Total Cost | The total capitalized cost of the asset |
| Salvage Value | The estimated residual value |
| Accumulated Depreciation | The total depreciation recorded (equals Total Cost minus Salvage Value for fully depreciated assets) |
| Age (Months) | The number of months since the asset was acquired |
| Status | The current status of the asset (always Active for this report) |
Filter Criteria
This report automatically filters to show only assets where the accumulated depreciation is greater than or equal to the depreciable base (total cost minus salvage value) and the asset status is Active. This means you see only assets that are fully depreciated but still in service.
Filters
- Location — Filter by a specific location or All Locations.
Common Use Cases
- Replacement planning — Fully depreciated assets have reached the end of their accounting useful life. Review this list regularly to identify assets that may need replacement due to wear, obsolescence, or reduced efficiency. The Age (Months) column helps you see how long the asset has been in service beyond its expected useful life.
- Identifying disposal candidates — Assets on this list that are no longer needed or functional are good candidates for disposal. Disposing of fully depreciated assets simplifies your asset register and can generate proceeds if the asset still has market value.
- Reviewing salvage value accuracy — If an asset is fully depreciated but still has significant market value, the original salvage value may have been set too low. Reviewing these assets helps you improve salvage value estimates for similar future acquisitions.
Tips
- A long list of fully depreciated assets may indicate that your replacement cycle is too slow or that useful life estimates are too conservative.
- Consider the Age (Months) column relative to the original useful life. An asset that was set to a 60-month useful life but is now 120 months old has been in service twice as long as originally expected.
- Cross-reference this report with the Maintenance Cost Report. Fully depreciated assets with high maintenance costs are strong candidates for replacement.
What to Read Next
- Asset Reports Overview — Summary of all reports and common features
- Asset Register & Valuation Reports — Financial snapshot reports
- Operations Reports — Transfer, disposal, and maintenance reports
- Coverage & Warranty Reports — Insurance, lease, warranty, and audit reports