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

    • 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 ...
    • 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. 
    • Credit Report/Update Legal Name from Business Credit Report

      Overview of testing results: The intent of this feature is to retrieve the Legal Name from the credit report and update the legal name field in ASPIRE when pulling a DNB report from either MicroBilt or Liquid Credit.  It intended to update the Legal ...
    • Global Setting, Credit Reports, Update Legal Name from Secretary of State Report

      The Global Setting, Credit Reports Update Legal Name from Secretary of State Report uses the MicroBilt, Additional Data Services tools to obtain SOS filing information.  This report can be requested manually from either the Contract Explorer or ...
    • Transaction Code Post Date Logic

      When transaction codes are configured an Accounting Method is selected that will determine if general ledger entries are created at the time of invoicing and what post date is used when the entries are posted. Cash Basis - No G/L entries are created ...