A/R Aging Report

OVERVIEW

The A/R Aging Report is generally used by the Finance, Accounting, Revenue and Front Office Departments to monitor the progress of payment for outstanding bills by the entities where the hotel has extended credit (also known as Direct Bill or Accounts Receivable). This report normally gives a summary of the total outstanding balances by each A/R account, grouped by aging period—those that are (based on the report run date) current (less than 30 days old), 30 to 59 days old, 60 to 89 days old, 90 to 119 days old, and 120 or more days old. There are also totals for each aging milestone and their percentage of the total amount outstanding (i.e., 65% current, 20% 30 days, 10% 60 days, 5% 90 days, and 0% 120 days or more).

Below is an explanation of what is shown in the report header and the report body.

Report Header

Totals recorded at the top of the report
Total A/R summary (Total A/R balance)
Total unallocated payments to balance with the A/R summary

Report Body

The report shows total balances per account
The total column is the total aging summary minus unallocated payments for each account
Payments show the actual amount paid
Cells with no outstanding amount show as 0.00
Displays accounts that have either an outstanding balance or unallocated payments

REPORT FILTERS

DATE RANGE (FROM/TO)	The amount corresponding to the different aging levels. Payments and balances can be viewed for the selected date range.
AGING BALANCE	View all aging levels or selected aging levels.
ACCOUNT NAME	Selected accounts can be viewed by setting the Account Name filter.
SORT BY	Sort by Account Name or A/R Number.

REPORT OUTPUT

The A/R Aging Report can be exported via CSV file or printed, and it will appear in the Reports Inbox as pictured below. You will see the following fields on the report:

PAYMENTS: Total outstanding credit amount in all A/R accounts
TOTAL OPEN BALANCE: Sum of outstanding balances in all aging levels of all A/R accounts
0 - 30 DAYS: Displays the total unpaid balances of all A/R accounts that are 30 days old or less
31 - 60 DAYS: Displays the total unpaid balances of all A/R accounts that are 31-60 days old
61 - 90 DAYS: Displays the total unpaid balances of all A/R accounts that are 61-90 days old
91 - 120 DAYS: Displays the total unpaid balances of all A/R accounts that are 91-120 days old
120+ DAYS: Displays the total unpaid balances of all A/R accounts that are older than 120 days
ACCOUNT NAME: Name of the Company or Travel Agent
A/R NUMBER: A/R number for the Company or Travel Agent
0 - 30 DAYS: Displays the total unpaid balances of the A/R account that are 30 days old or less
31 - 60 DAYS: Displays the total unpaid balances of the A/R account that are 31-60 days old
61 - 90 DAYS: Displays the total unpaid balances of the A/R account that are 61-90 days old
91 - 120 DAYS: Displays the total unpaid balances of the A/R account that are 91-120 days old
120+ DAYS: Displays the total unpaid balances of the A/R account that are older than 120 days
PAYMENTS: Total outstanding credit amount in the A/R account
BALANCE: Sum of outstanding balances in all aging levels of the A/R account

REPORTS INBOX

PRINT REPORT

CSV EXPORT