Skip to main content

Fixed Asset Reports: Register and Summary

Report and review your fixed assets, including the register for reviewing across a report period

Written by Travis Lander

Overview

The Fixed Assets module includes two subledger reports that always agree with each other:

  • Fixed Asset Register (Fixed Assets > Asset Register) — one row per asset, rolling Cost, Accumulated Depreciation, and Net Book Value forward across the report period.

  • Fixed Asset Summary (Fixed Assets > Asset Summary) — the same rollforward, aggregated by Fixed Asset Type in three stacked sections (Cost, Depreciation, Net Book Value).

Use the Register when you need asset-level detail; use the Summary for the roll-up your auditors and financial statements want.


Running the reports

Both reports take the same configuration:

  1. Location — includes assets at the selected location and every location under it

    1. This is adjusted from the Location Picker in top ribbon of the application

  2. Start Date / End Date — the report period (defaults to the current accounting year through today)

  3. Currency — only assets in this currency are included

Note — single currency: The reports aren't consolidated. Assets in other currencies are left out rather than translated, so if you hold assets in two currencies, run the report once per currency.


How the rollforward reads

Each Register row opens with the asset's beginning balances, shows the period's activity, and closes with ending balances — and every row reads across:

Beginning Net Book Value + Acquisitions + Sale + Disposals + Depreciation + Revaluations = Ending Net Book Value

  • Acquisitions — cost of assets acquired inside the period (the acquisition date is the source bill's posting date)

  • Depreciation — posted schedule lines dated inside the period, shown negative

  • Revaluations — signed write-ups/write-downs inside the period

  • Sale / Disposals — the net book value removed by assets sold or written off inside the period, shown negative. Sale Proceeds are shown informationally but aren't part of the rollforward — the gain or loss was booked by the disposal journal.

An asset sold or written off inside the period ends the period at zero across all three balances. Rows are grouped by Fixed Asset Type with subtotals, and a Total Assets row closes the report.


Which assets appear

An asset is on the report when its status is active, completed, or disposed, its currency and location match, it was acquired on or before the End Date, and it wasn't disposed before the Start Date.

Important — statuses never reported: Draft, cancelled, and voided assets never appear, even though their capitalized cost still sits on the asset account (and, for cancelled assets, their posted depreciation stays on the books too). Treat them as reconciling items when tying the report to the General Ledger — and configure draft assets before period end.


Tying to the General Ledger

For the assets in scope, and provided nothing else posts to these accounts:

  • Ending Depreciation agrees to the Accumulated Depreciation accounts at the End Date.

  • Ending Cost agrees to the Asset accounts plus the Accumulated Revaluation accounts — revaluations post to the accumulated revaluation account and leave the asset account at original cost, so together they carry the current cost.

  • Depreciation for the period agrees to Depreciation Expense posted inside it.

Differences come from manual journals to these accounts, assets excluded by status, assets in other currencies, and assets at other locations.


The Summary's three sections

The Summary runs the identical per-asset calculation, then stacks three sections — Cost, Depreciation, and Net Book Value — with one row per Fixed Asset Type and a total row per section. Every row foots (Beginning + Additions + Sale + Disposals + Revaluations = Ending), and every Net Book Value cell equals the Cost cell minus the Depreciation cell.

One sign convention to know: the Register shows period depreciation as negative (it reduces NBV), while the Summary's Depreciation section shows it as a positive Addition (it grows the accumulated depreciation balance). Sales and disposals are negative everywhere.


Exporting

Both reports export to XLSX from the action bar — title rows with currency, location, and date range, frozen headers, the same grouping and signs as the on-screen report, and (on the Register) every column enabled for your tenant including the ones hidden by default.


Questions about the fixed asset reports? Reach out through the chat bubble or at support@softledger.com — happy to help.

Did this answer your question?