Standard Book Value Report - Calculations and Logic

Standard Book Value Report - Calculations and Logic

See attachment for details. 

The attached document details the Book Value logic used on the Book Value report in the Dashboard Reports General Ledger folder. 

The document defines the Book Value logic for a Capital (Direct Finance) Lease, Operating Lease, and Loans. 


As noted in the attached document, choosing different parameter values will affect the "Book Value" that the report calculates.

The Book Value report has the ability to exclude by Contract Item type, so if all item types aren't chosen, this could result in a difference from the Accounting screen.

The Book Value report also has an "As of Date" parameter.  In order to match the values on the Aspire Accounting Screen, use the current date to run the report.






    • Related Articles

    • List of Standard ASPIRE Reports

      See attached document for entire list. The attached document lists each standard ASPIRE Dashboard Report with a brief description.

    • Prepaid Invoice Report Logic

      The Prepaid Invoice report (in the Dashboard Reports - Invoicing folder) is limited to invoices where the payment Effective Date is less than the Due Date, the payment has been posted and not returned, and the invoice detail record OpenClosedOid is ...

    • Updating Book Depreciation during Renewal to depreciate the residual

      It is not an uncommon scenario to have an operating lease asset that is set to depreciate down to a residual value. Once the contract matures and it moves into a renewal period you typically want to continue book depreciation to offset the renewal ...

    • ASPIRE Sales Tax Calculations Video

      View the linked video for full details. The linked video walks through the standard ASPIRE sales tax calculations before and at booking, and during invoicing. Click here to view the 24 minute video.

    • IDC Calculations - LP vs ASPIRE

      See the attached document for complete details. The attached document Here is a quick rundown of the differences between IDC calculations as they were handled in LP versus ASPIRE. The ASPIRE v5 IDC items are configured to use the Effective Interest ...