Fixed asset register template

Every asset the business owns on one sheet: what it cost, when it was bought, how it is depreciated, what has been charged and what is left. The totals agree to the trial balance.

Excel, Word and PDF, free, in Arabic and English.

Preview with sample figures

The preview is the file as it downloads in this language; the figures are samples to replace with your own.

Fixed Asset Register

Company name
Al Noor Trading Est.
As at
2026-10-31
Reference
FAR-2026-10
Asset no.DescriptionAcquiredCostLife (years)MethodAnnual depreciationAccumulated depreciationNet book value
FA-0001Delivery van2025-01-0160,000.005Straight line12,000.0022,000.0038,000.00
FA-0002Forklift, 2.5 t2026-03-0136,000.004Straight line9,000.006,000.0030,000.00
FA-0003Laptops and server2026-09-0118,000.003Straight line6,000.001,000.0017,000.00
FA-0004Mobile phones, 62026-07-016,000.002Straight line3,000.001,000.005,000.00
Total120,000.0030,000.0030,000.0090,000.00
Prepared byApproved by

One line per asset: what it cost, when it was bought, its useful life and method, the depreciation charged to date and what remains. The totals agree to the fixed-asset and accumulated-depreciation accounts in the trial balance. The sample charges a straight line with no residual value, from the month each asset was bought.

Every asset, what it cost and what is left of it

A fixed asset register (سجل الأصول الثابتة) lists each asset the business owns and uses for more than a year: what it is, when it was bought, what it cost, its useful life and depreciation method, the depreciation charged so far and the net book value. It is the subsidiary ledger behind the fixed-asset and accumulated-depreciation accounts, so its totals must agree to them in the trial balance.

  • The company, the date the register is stated at, and a reference.
  • Per asset: a number, a description and the date it was bought.
  • Its cost, useful life in years and depreciation method.
  • The annual depreciation, the accumulated depreciation to date and the net book value.
  • Totals of every money column, and who prepared and approved the register.

The sample's arithmetic

Four assets on a straight line with no residual value, each charged from the month it was bought. A van of 60,000.00 over five years is 12,000.00 a year, 1,000.00 a month; bought in January 2025, it has carried 22 months by 31 October 2026, 22,000.00, leaving 38,000.00.

Together the four cost 120,000.00, carry 30,000.00 of accumulated depreciation and a net book value of 90,000.00, the equipment figures of the sample trial balance. Their monthly charge is 2,500.00, the sample journal entry's October depreciation.

Van: 60,000 ÷ 5 = 12,000 a year, 22 months22,000.00
Forklift: 36,000 ÷ 4 = 9,000 a year, 8 months6,000.00
Laptops and server: 18,000 ÷ 3 = 6,000 a year, 2 months1,000.00
Mobile phones: 6,000 ÷ 2 = 3,000 a year, 4 months1,000.00
Accumulated depreciation30,000.00
Net book value: 120,000 − 30,00090,000.00

Choosing a method and a life

Under IFRS, which Saudi Arabia applies through SOCPA, the method should follow how the asset's benefit is used up, and the useful life and salvage value are estimates the business reviews each year. Straight line is the common choice where use is even. What the books use and what is allowed for tax are separate questions: the zakat and income tax rules set their own depreciation for the return.

Questions

How is straight-line depreciation calculated?

(Cost − salvage value) ÷ useful life in years. The sample's forklift, 36,000.00 with no salvage value over four years, is depreciated 9,000.00 a year, 750.00 a month.

Does an asset bought mid-year get a full year's depreciation?

In the books it is usually charged from the month it is ready for use, as the sample does. Aqid ERP's fixed-asset register charges by month.

Is land depreciated?

No. Land has no limited useful life, so it is carried at cost. A building on the land is depreciated.

What is net book value?

Cost less the depreciation charged so far. It is the asset's value in the balance sheet, not what it would sell for.

Your first compliant invoice is minutes away

Start now for free No credit card needed — invoice in minutes