Skip to main content

Fixed Asset Reports

Learn about the Movement Schedule and Reconciliation reports for fixed assets, what they show, and how to use them for auditing and compliance.

Written by Christopher Dosin
Updated this week

Overview

Cybooks has two reports for fixed assets, both in the Reports section of the sidebar:

  • Fixed Asset Movement Schedule – shows how your asset values changed over a period

  • Fixed Asset Reconciliation – checks that your asset register matches your accounting records

Movement Schedule

This report shows what happened to your fixed assets during a date range. Auditors and tax authorities often ask for it.

How to use it

Go to Reports and select Fixed Asset Movement Schedule. Pick your date range.

Screenshot needed: The Movement Schedule report showing the date range picker and the three sections (Cost, Accumulated Depreciation, Net Book Value) with columns per asset type. Navigate to Reports > Fixed Asset Movement Schedule and select a date range that has activity.

What it shows

The report has three sections, with a column for each asset type:

1. Cost

  • Opening balance – total cost of assets at the start of the period

  • Additions – new assets registered during the period

  • Disposals – assets removed during the period

  • Closing balance – total cost at the end

2. Accumulated Depreciation

  • Opening balance – total depreciation at the start

  • Charge for the period – depreciation recorded during the period

  • Disposals – depreciation removed for disposed assets

  • Closing balance – total depreciation at the end

3. Net Book Value

  • Opening – what the assets were worth at the start

  • Closing – what the assets are worth at the end

Export

You can export to Excel, CSV, or PDF. You can also print directly from the page.

Reconciliation Report

This report compares two different sources to make sure they agree:

  • Asset Register – values from the fixed assets and depreciation records

  • General Ledger – values from the journal entries in your Chart of Accounts

If everything is correct, both sources should show the same numbers.

How to use it

Go to Reports and select Fixed Asset Reconciliation. Pick your date range.

Screenshot needed: The Reconciliation report showing the comparison table with Balance Sheet (GL) row, Asset Register row, and Difference row for each asset type. Navigate to Reports > Fixed Asset Reconciliation and select a date range.

What it shows

For each asset type, you see three rows:

  • Balance Sheet (GL) – the balance from your accounting journals

  • Asset Register – the balance from the fixed assets records

  • Difference – the gap between the two (should be zero)

When the values match, the difference row shows zero. When there is a discrepancy, the difference is highlighted in red so you can spot it quickly.

Common reasons for differences

  • Someone posted a journal entry directly to a fixed asset account without using the Fixed Assets module

  • A depreciation journal entry was manually deleted

  • The report dates do not match when the entries were posted

Tip: If you find a difference, check the journal entries for the affected accounts. Look for manual entries that bypass the Fixed Assets module.

Export

Same options as the Movement Schedule: Excel, CSV, PDF, and print.

Year-end checklist

At year-end or during an audit:

  1. Run the Movement Schedule for the full financial year and give it to your auditor

  2. Run the Reconciliation for the same period to check for differences

  3. Fix any differences that show up

  4. Export both reports for your records

Did this answer your question?