How to Generate Fixed Asset Three Column

Modified on Tue, Sep 30 at 11:21 AM

Overview:

The Fixed Assets – Three Column Report in QNE AI Cloud Accounting provides a snapshot of asset balances by displaying three key figures: original cost, accumulated depreciation, and net book value. This report helps businesses track asset valuation, manage depreciation schedules, and ensure accurate and transparent financial reporting.


Scenario:

Your finance team is finalizing monthly reports and needs to present an updated snapshot of fixed assets as of September 23, 2025. The report must include all projects, display assets with zero balances, and be exported for audit documentation.


Solution:

  1. Navigate to the Report

  • Go to Reporting > Report Center > General Ledger Tab > Fixed Assets > Fixed Assets (Three Column).
     

  1. Set the Filters:

  • In the Report Criteria window, configure:

    • As of Date – Select the cut-off date (e.g., Sep 23, 2025).

    • Projects – Choose All Projects, No Project, Main Project, or Sub Project depending on reporting needs.

    • Select Options

      • Include Zero – Turn ON to display assets with zero balances (e.g., fully depreciated assets).
         

  1. Generate the Report. Click Preview to generate the report on-screen.
    Note: Select the Inquiry button to quickly view results using your chosen filters, without needing to run the full preview first.
     

  1. Interpret the Columns
     The report provides the following details:

  • Account Code – Unique identifier for each fixed asset.

  • Account Name – Descriptive name of the asset.

  • Cost – Original acquisition cost.

  • Accumulated Depreciation – Total depreciation recorded up to the reporting date.

  • Book Value – Net value (Cost – Accumulated Depreciation).



Application:

  • Audit & Compliance – Provide auditors with a clear breakdown of asset costs, depreciation, and book values.

  • Asset Management – Identify fully depreciated assets still in use, aiding decisions on replacement or disposal.

  • Financial Reporting – Supply management with accurate fixed asset balances for the balance sheet.

  • Project Reporting – Run reports by project to assess which projects hold significant assets.





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article