Extract data from fixed asset registers

A fixed asset register is the subledger behind the property, plant, and equipment line on the balance sheet. Where the balance sheet shows one net figure for PP&E, the register lists every capitalized asset behind it: the machine, the vehicle, the fit-out, each with an asset ID, an acquisition date and cost, the depreciation method and useful life, the accumulated depreciation to date, and the net book value that carries forward. Under IAS 16, Property, Plant and Equipment, and its US-GAAP counterpart in ASC 360, an entity depreciates each asset over its useful life and tests it for impairment, and the register is the working record that supports both. A fixed-asset accountant closing the year, and an external auditor sampling additions and disposals, read the same schedule. Every column in the register carries accounting meaning. Acquisition cost less accumulated depreciation must equal the net book value on each row: a $180,000 machine depreciated straight-line over ten years to a zero salvage value writes off $18,000 a year, so its net book value after four years reads $108,000. The annual depreciation has to follow the stated method, whether straight-line, declining-balance, or units-of-production, over the useful life in years down to the salvage value. Disposals add their own columns: a disposal date, the proceeds, and the gain or loss against the remaining book value. An asset held under a finance lease is flagged separately from one owned outright, an impairment writes the carrying amount down, and an entity on the revaluation model carries a revaluation date and amount. Categories such as land, buildings, machinery, vehicles, and leasehold improvements group the rows, and land does not depreciate at all. Feed the register to Talonic and the entity, the reporting period and currency, and the summary figures come back as header fields, then every asset returns as a row carrying its ID, description, category, acquisition date and cost, accumulated depreciation, net book value, method, useful life, salvage value, and status. The cost-less-depreciation arithmetic is checked against the stated book value per row, disposals and impairments stay in their own fields, and finance-leased assets are flagged. A register as of 2026-03-31 for Northwind Manufacturing, reporting $2,480,000 of PP&E net in USD, loads into an accounting or audit workpaper as a structured schedule the accountant can foot and the auditor can sample rather than re-key from a printout.

What gets extracted from fixed asset registers

How extraction works for fixed asset registers

Fixed asset registers are exported from asset accounting modules such as SAP FI-AA, Oracle Fixed Assets, and Sage, and from spreadsheets, so the column set and the way disposals are shown vary from one entity to the next. Talonic classifies the register and maps it to the fixed-asset model in the Field Registry, which keeps the summary header and the per-asset rows as a linked structure rather than a flat dump. Acquisition cost less accumulated depreciation is reconciled against the stated net book value on each row so a mistyped figure is flagged, the depreciation method and useful life are read as stated, and disposal, impairment, and revaluation columns are kept in their own fields. Finance-leased assets are flagged distinctly from owned ones, and categories such as land that do not depreciate are preserved. Each value returns with a confidence score and a pixel-region pointer under DIN SPEC 91491, so an accountant or an auditor can check a net book value or a disposal against the source register before it feeds the balance sheet.

Sample extraction

A fixed asset register extract as of 2026-03-31

{
  "entity_name": "Northwind Manufacturing Inc.",
  "document_date": "2026-03-31",
  "fiscal_year": 2026,
  "reporting_currency": "USD",
  "property_plant_equipment_net": 2480000,
  "fixed_assets": [
    {
      "asset_id": "FA-10422",
      "asset_description": "CNC milling machine, Haas VF-2",
      "asset_category": "machinery",
      "acquisition_date": "2022-04-01",
      "acquisition_cost": 180000,
      "accumulated_depreciation": 72000,
      "book_value": 108000,
      "depreciation_method": "straight_line",
      "useful_life_years": 10,
      "annual_depreciation": 18000,
      "salvage_value": 0,
      "asset_status": "active"
    },
    {
      "asset_id": "FA-10588",
      "asset_description": "Delivery van, Ford Transit",
      "asset_category": "vehicles",
      "acquisition_date": "2023-04-01",
      "acquisition_cost": 48000,
      "accumulated_depreciation": 18000,
      "book_value": 30000,
      "depreciation_method": "straight_line",
      "useful_life_years": 8,
      "annual_depreciation": 6000,
      "salvage_value": 0,
      "asset_status": "active"
    }
  ]
}

Frequently asked