Fixed Asset Register Workbook

Description

Fixed Asset Register Workbook

The Fixed Asset Register Workbook is a comprehensive tool for managing an organisation’s fixed assets throughout their lifecycle. It ensures proper tracking of acquisitions, disposals, depreciation, impairments, revaluations, and maintenance activities, while also providing automated journal entries for accurate posting to the general ledger. This workbook helps organisations stay compliant with accounting policies and tax reporting requirements, while giving management a clear view of asset utilisation and costs.

Purpose & Objectives

• Asset Tracking: Maintain a detailed register of all fixed assets, including acquisition cost, residual value, useful life, and carrying value.
• Depreciation Management: Automate depreciation calculations on a monthly and annual basis, by both asset and asset class.
• Financial Compliance: Produce audit-ready schedules and journals that tie directly to the general ledger.
• Decision Support: Provide insights into maintenance, impairments, and capital planning.

Workbook Structure

• Company Set-up
  • Stores business details (name, reporting dates, tax rate, accounting policy settings).
  • Defines asset classes (Land & Buildings, Plant, Equipment, Vehicles, Furniture, etc.) and asset categories.
  • Includes tax depreciation codes for calculating capital allowances over time (e.g., Buildings at 5%, Motor Vehicles at 20%).
  • Ensures consistency across reporting and calculations.

• Assets Tab
  • Core register listing each asset with details such as:
    • Asset number, description, supplier, purchase date, acquisition cost, residual value, useful life, tax code.
  • Tracks depreciation expense, accumulated depreciation, net book value, and revaluation reserves.
  • Supports impairments and disposals (including proceeds, profit/loss on sale).
  • Links directly to financial reports.

• Transactions Tab
  • Records asset-level movements: acquisitions, disposals, revaluations, impairments, and adjustments.
  • Includes supplier details, document references, transaction dates, and amounts.
  • Feeds updates into the asset register and journals.

• Category & Class Summaries
  • Category Summary: Aggregates balances at category level (e.g., Computer Hardware, Motor Vehicles).
  • Class Summary: Consolidates reporting at class level (e.g., all Plant & Equipment).
  • Both show opening balances, additions, revaluations, depreciation, impairments, and closing balances.
  • Useful for financial statement disclosures and internal reporting.
• Journals Tab
  • Produces accounting entries for posting, covering:
    • Depreciation
    • Revaluation adjustments
    • Disposals (cost, proceeds, accumulated depreciation)
    • Deferred tax effects
  • Streamlines month-end and year-end close processes.
• Asset Maintenance Log
  • Records maintenance events with date, asset code, description, vendor, cost, and notes.
  • Builds a history of upkeep and supports asset replacement decisions.

• CapEx Requests
  • Tracks capital expenditure requests awaiting approval.
  • Fields include request ID, requestor, estimated cost, approval status, and expected purchase date.
  • Helps with budgeting and planning future acquisitions.

Key Benefits

• Integration: Asset records, category summaries, and journal entries are fully linked.
• Accuracy: Automated depreciation ensures consistent and reliable calculations.
• Audit-Ready: Full trail of acquisitions, disposals, revaluations, and impairments.
• Management Insight: Highlights maintenance costs and planned investments to support decision-making.