Depreciation Schedule
A Depreciation Schedule is a report that shows how an asset’s cost is allocated over its useful life through depreciation.
It provides a structured view of:
- an asset’s original cost,
- depreciation method,
- accumulated depreciation,
- current depreciation expense,
- and remaining book value.
The report is commonly used for:
- financial reporting,
- budgeting,
- audit support,
- and long-term asset planning.
Depending on configuration, the schedule may also show:
- Acquisition date
- In-service date
- Salvage value
- Remaining life
- Depreciation method
- (Straight-Line, Declining Balance, etc.)
- Fund or department
- Monthly or annual depreciation amounts
Organizations use the Depreciation Schedule to:
- Calculate and verify depreciation expense
- Support annual audits
- Reconcile accumulated depreciation
- Forecast future depreciation
- Prepare financial statements under GASB standards
In government accounting, this report is especially important because depreciation affects:
- government-wide financial statements,
- capital asset reporting,
- and long-term financial planning.
Compared to other reports:
- Transaction Register: Detailed asset activity
- Schedule of Changes in Assets: Overall asset balance changes
- GL Reconciliation Summary: Reconcile assets to the General Ledger
- Depreciation Schedule: Detailed depreciation calculations and balances
In simple terms:
- A Depreciation Schedule shows how each asset loses value over time for accounting purposes.
Printing a Depreciation Schedule
1. Open Connect Asset Management > Reports > Depreciation Schedule.
2. Select a report title.
For example, Depreciation Schedule - By Department and Classification. This report will usually provide the totals broken down by classification in a given department.
3. Select the Report Dates.
4. Do you want include report only transactions?
A report only transaction is recorded and will be updated to the General Ledger as a report only transaction.
-
Yes, I want to include report only transactions. Select the Include Report-Only Transactions checkbox.
-
No, I do not want to include report only transactions. Deselect the Include Report-Only Transactions checkbox.
5. Click Print (CTRL+P).
The report prints.
Using a Depreciation Schedule to update to the general ledger
If you're not using Update General Ledger to update asset management transactions to the Caselle General Ledger, you can use the totals on the depreciation schedule to post asset transaction totals.
Related Articles
Schedule of Changes in Assets
A Schedule of Changes in Assets is a report that tracks how an asset’s value or status changes over a period of time. It’s commonly used for financial reporting, audits, and reconciliation of fixed assets. The report typically summarizes: Beginning ...When was depreciation last calculated?
The last date when depreciation was calculated in the Asset Management application is stored in the Organization table. This MM/DD/YYYY updates every time a user runs the Depreciate Assets routine. Important! Do NOT modify this field. Viewing last ...What's the difference between depreciation methods?
Declining balance depreciation method The declining balance depreciation method applies the declining balance rate to the remaining book value (cost minus the accumulated depreciation). The system ignores the salvage value when the declining balance ...How do I recalculate asset depreciation?
If you depreciate assets the first time and you realize it doesn't look right, and now you need to recalculate depreciation. You can run Depreciate Assets with the option to replace previously calculated depreciation. When this option is selected, ...How do I change the depreciation settings?
Depreciation is the amount of expense charged against earnings by an organization to write off the cost of an asset over the asset's life. The depreciation defaults save the settings for how often an asset is depreciated, which depreciation method to ...