Enhancements to AR Aging Forecast Details Report (Dynamic)

The following enhancements and modifications have been made to the AR Aging Forecast Details report (Dynamic):

  • The Subtotal column has been renamed as Invoiced.

  • The Unapplied column has been moved next to the Uninvoiced column.

  • The Total column has been renamed as Total Balance.

  • The value, 0, is displayed in the following columns when no value is available. Previously, these columns were displayed blank when no value was available.

    • Uninvoiced

    • Unapplied

    • Total Balance

  • The Total Balance column has been modified to calculate the total balance of an A/R account as follows: (Invoiced + Uninvoiced) - (Unapplied Payments).

  • A new report generation parameter, Property, has been added. This is a single-select drop-down list that displays the properties under a tenant. The current logged-in property is selected by default. Users can select the preferred property to generate the report.

  • A new column, Charge Posted Date, has been added. It displays the date when the charges were posted to the reservation. When the charges are transferred from the reservation to an A/R account, this column will continue to display the date when the charges were originally posted to the reservation.

  • A new report generation parameter, Options, has been added. This is a single-select drop-down list that displays the following options:

    • Include Unapplied In Aging Buckets

    • Include Uninvoiced In Aging Buckets

    • Include Unapplied Accounts

    • Include Zero Balance Accounts

The following table describes the calculations that take place for filtered records based on the selected parameter:

Options

Description

Include Unapplied In Aging Buckets

The unapplied payments will be subtracted from the oldest aging buckets.

For example, consider the following values:

  • 61-90 bucket = $250.00 

  • 31-60 bucket = $100.00 

  • The unapplied payment available in the account = $220.00

In this case, the unapplied payment will be subtracted from the 61-90 bucket as follows: $250.00 - $220.00 = $30.00.

Include Uninvoiced In Aging Buckets

The uninvoiced amount will be added to the latest aging buckets. For example, consider the following values:

  • 61-90 bucket = $250.00

  • 31-60 bucket = $100.

  • The un-invoiced amount available in the account = $220.00

In this case, the un-invoiced amount will get added to the 31-60 bucket as follows: $100.00 - $220.00 = $320.00.

Include Unapplied Accounts

AR accounts with only unapplied payments will be displayed once the option is enabled along with the A/R accounts with charges posted to invoices.

Include Zero Balance Accounts

A/R accounts with zero invoice balance, zero un-invoiced amount, and zero unapplied payments will be displayed.

  • When the generated report is exported as a CSV file, the company and invoice details of the A/R account will be displayed. Previously, these details were not displayed.