# SAP Fixed Asset Depreciation Schedule Worksheet

> Source: https://netray.co/tools/sap-fixed-asset-depreciation-schedule-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Editable asset list with straight line depreciation per asset and totals, useful for planning, migration checks and sanity checks of AFAB output.

## Category

sap

## Erp

SAP ECC / S/4HANA

## Audience

- Fixed asset accountant
- SAP FICO consultant
- Controller

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Asset number

**Key:** asset

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### Asset class

**Key:** aclass

**Type:** select

**Options:**

- Machinery
- Buildings
- Vehicles
- IT equipment
- Furniture
- Tooling

#### Capitalization date

**Key:** cap_date

**Type:** date

#### Acquisition cost

**Key:** cost

**Type:** number

**Format:** currency

#### Salvage value

**Key:** salvage

**Type:** number

**Format:** currency

#### Useful life

**Key:** life

**Type:** number

**Unit:** years

#### Annual depreciation

**Key:** annual

**Type:** number

**Expr:** (cost - salvage) / life

**Format:** currency

#### Monthly depreciation

**Key:** monthly

**Type:** number

**Expr:** (cost - salvage) / life / 12

**Format:** currency

#### Depreciation rate

**Key:** rate

**Type:** number

**Expr:** 100 / life

**Format:** percent

**Rows:**

**Asset:** 100000101

**Desc:** CNC machining center 5-axis

**Aclass:** Machinery

**Cap date:** 2026-01-15

**Cost:** 420000

**Salvage:** 20000

**Life:** 10

**Asset:** 100000102

**Desc:** Coordinate measuring machine

**Aclass:** Machinery

**Cap date:** 2026-03-01

**Cost:** 185000

**Salvage:** 10000

**Life:** 8

**Asset:** 100000240

**Desc:** Delivery van

**Aclass:** Vehicles

**Cap date:** 2026-05-10

**Cost:** 46000

**Salvage:** 6000

**Life:** 5

**Asset:** 100000311

**Desc:** ERP application server

**Aclass:** IT equipment

**Cap date:** 2026-06-01

**Cost:** 38000

**Salvage:** 0

**Life:** 4

**Asset:** 100000412

**Desc:** Injection mold tool set

**Aclass:** Tooling

**Cap date:** 2026-07-20

**Cost:** 72000

**Salvage:** 0

**Life:** 6

**Totals:**

#### Total acquisition cost

**Key:** cost

**Agg:** sum

**Format:** currency

#### Total annual depreciation

**Key:** annual

**Agg:** sum

**Format:** currency

#### Total monthly depreciation

**Key:** monthly

**Agg:** sum

**Format:** currency

**Summary:**

#### Blended depreciation rate

**Key:** blend

**Expr:** sum_annual / sum_cost * 100

**Format:** percent

**Primary:** true

**Description:** Total annual depreciation divided by total acquisition cost.

**Notes:** Straight line, whole years, no partial period. SAP depreciation keys can start in the period of capitalization, pro rata by month, or by mid period convention, so a first year figure from AFAB may differ. Use this to check order of magnitude and migration loads, not to replace the depreciation run.

## Content

**Intro:** Asset accountants often keep a side spreadsheet to sanity check what the SAP depreciation run will do, and to prepare asset loads for a migration. This worksheet gives a clean straight line schedule per asset with totals, ready to export to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Edit the rows or add your assets with number, class, capitalization date, acquisition cost, salvage value and useful life. Annual and monthly depreciation calculate for each row, and the totals show the full portfolio. Export to Excel to continue with period phasing, or paste the figures into a reconciliation against the planned depreciation report. Keep one worksheet per depreciation area if your company runs book and tax areas.

#### The formula and how SAP differs

**Body:** Straight line annual depreciation is acquisition cost less salvage value, divided by useful life. SAP FI-AA calculates this through a depreciation key, which holds calculation methods, a base value, and a period control that decides when depreciation starts. Common period controls begin in the month of capitalization, the following month, or a half year convention. The AFAB run posts planned depreciation per period. So compare yearly totals with this sheet and expect a difference in the first and last year of each asset.

#### Reading the totals

**Body:** The blended rate is total annual depreciation divided by total cost. A machinery heavy list with ten year lives should sit near ten percent, an IT heavy list near twenty five percent. If the blended rate is far from your policy, one or more assets probably have the wrong useful life or class. Check large assets first, since they dominate the total, then check low value items that should have been expensed under your capitalization threshold.

#### Common mistakes

**Body:** Frequent mistakes are mixing months and years in the life column, ignoring salvage value where the depreciation key uses it, running depreciation for assets still under construction, and loading historic assets without the accumulated depreciation to date. Migration loads must carry cost, accumulated depreciation and the posted depreciation for the current year, otherwise the first AFAB run double counts or skips periods.

**Cta:** Preparing an asset migration or checking depreciation after an upgrade? We can help with extraction and reconciliation using your own ERP data.

**Faq:**

#### Does this match the AFAB depreciation run exactly?

**Answer:** Not exactly. It is a straight line approximation by full years. The AFAB run follows your depreciation key, period control, rounding and any parallel areas, so first and last years often differ.

#### Which SAP transaction shows planned depreciation?

**Answer:** In ECC, reports such as S_ALR_87011963 (asset history sheet) and S_ALR_87012936 (depreciation forecast) are commonly used. S/4HANA offers asset accounting Fiori apps. Check which are enabled in your system.

#### How do I handle declining balance assets?

**Answer:** This sheet is straight line only. For declining balance, use the rate column as a starting point and compute each year on the opening net book value, or build a separate sheet by year.

#### Can I use this for tax depreciation?

**Answer:** You can model it if the tax rules use straight line, but many jurisdictions prescribe fixed rates or accelerated methods. Treat your local tax rules as the authority, and keep tax in its own depreciation area.

## Search terms

sap asset depreciation worksheet, fi-aa depreciation schedule excel, straight line depreciation schedule template, sap afab check worksheet, fixed asset register template excel, sap asset migration depreciation check, sap asset class useful life, annual depreciation calculator by asset

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json