Aging Summary of All Accounts (aragingsum with ARA1.FMX)
Note: This report is only available when the Cashiering>Accounts Receivables application function is set to Y.
The Aging Summary of All Accounts report displays all AR Accounts that have an outstanding balance, or activity on the Account. The output is divided into two sections, the AR ledger and Accruals. The information per Account includes the Account Name, Number, Credit Limit, balance per Aging bucket and the Total balance of each Account. The Contact Information may also be selected to display on the report. Individual Invoice and Folio Amounts that make up the Account or Aging bucket balance may be found on the aragingdet report.
The number of aging level columns displayed depends entirely on the property, as the aging levels are user-definable.
The Total AR Ledger balance will correspond to the AR Ledger Section ‘Balance Today’ line on the Trial Balance report – trial_balance.rep for the selected business date.
The Total per Aging Levels and Total per AR Account may be compared and balanced with the following reports:
Note: When any AR Aging report is run for a date prior to the current Business Date, AR Aging will be calculated and displayed using the ‘Child Invoices’ and not the compressed invoices. Each individual invoice will be displayed in the aging bucket that is applicable for each individual invoice posting date.
When the End of Day>Income Audit application function is set to Y, the Final reports for AR Aging will be run as backdated, if there is any posting action in the Accounts Receivable module. A posting action includes creating new invoices, additions to invoices, adjustments, payments and applying unallocated payments to existing Invoices. Direct Bill settlements for the current day will not be considered as an Accounts Receivable action in this case, as they are not transferred into an AR account until the End of Day process for the current business date is run.
Agent. Available when the AR>AR Account Agent application function is set to Y. Select the down arrow to choose the agent(s) on whose accounts you wish to report.
Business Date. Report output may be for the current business date, any past dates, or for future dates. The default will be the current business date.
Note: For future dates, invoice or payment amounts may move to older aging buckets, depending on the date selected, but the total balance on the report remains the same as if the report was run for current business date. In the example report below where the report is ran for a future date, the 61 days and over bucket combines the totals of the 46-60 day and 61 and over buckets.
Note: When the aging report is run for a previous (past) date, the invoice or payment amounts will be calculated and displayed in the aging buckets according to what the aging levels were as of that previous (past) date. These may or may not match the current date's aging bucket amounts or the current date's balance.
Sort Order. Account Name, Account Number, Account Type.
Owner Flag. Available when the OPV_<version number> Opera Vacation Ownership license is active, select Exclude Owner, Owner Only, or leave the field blank to include both owner and non-owner accounts in the report output.
Contact Information. When selected, the report output will display the Contact Name, Phone number, Fax number and Email Address created for each AR Account. This information can be found in the application in AR>Account Maintenance>Edit.
Age Credits. Displays the value that is defined for the AR>Age Credits application parameter. When the value is set to Y, unallocated credits are aged on an AR account in the same way that debits are aged. But when the value is set to N, unallocated credit totals will always appear in the current bin, no matter how long they have been on the account.
Account Name. Name attached to the AR Account.
Account No. Number assigned to the AR Account.
Credit Limit/LOC. Credit Limit assigned to the AR Account. The credit limit that is displayed in this column is retrieved based on the following steps:
AR Aging Levels. Based on the Aging Levels configured from Configuration>AR>Aging Levels, displays the amount still owed under the aging level for the AR Account.
Total. Displays the total amount owed by the AR Account.
Agent. Agent ID attached to the AR Account.
Contact Information. Available when the Contact Information check box is selected on the report filter, displays the Contact Name, Phone number, Fax number and Email Address created for each AR Account.
Total AR Ledger. Total amount for the AR Ledger portion of the report. Also displayed is the Total number of accounts that make up the AR Ledger portion of the report and the percentages that the Aging Level contributes to the Total AR Ledger amount.
Total Accruals. Total amount for the Accruals portion of the report. Also displayed is the Total number of accounts that make up the Accruals portion of the report and the percentages that the Aging Level contributes to the Total Accruals amount.
Grand Total. Total amount for the AR Ledger and Accruals portions of the report. Also displayed is the Total number of accounts that make up the AR Ledger and Accruals portion of the report and the percentages that the Aging Level contributes to the Total AR Ledgers and Accruals amounts.