Account Analysis Detailed

Office > Reporting > Invoice > Account Analysis Detailed

The report lists all outstanding accounts receivable including the name of the account, guest's first and last names, invoice number, and outstanding amount based on due date.

Create this report to get a detailed overview of all outstanding accounts receivable.

Filters

You can create the report based on various criteria. The criteria can be setup by means of the filters. The following filters are available:

Filter

Description

Date

Select a date as "deadline" and the report will provide you with the desired information.

Date type

You can access the report by posting date or value date.

The Posting date is the day on which a posting is registered in protel Air.

The Value date is the day of value.

Profile type

You can call up the report for certain profile types (e.g., company, private, ...), or for all of them.

AR Account Name

Here you can enter one or more account names (separated by commas) to evaluate only these accounts.

AR No.

Here you can enter one or more account numbers (separated by commas). The report is generated only for the account numbers entered.

Contents of the report

Each A/R Ledger contains a separate section under which all payments and postings that are part of the account are displayed in descending order by date. For each account, the open amount (subtotal) is displayed for the day the report has been executed.

Offsetting or reversal postings are displayed as negative postings and reduce the outstanding amount accordingly.

Column

Description

AR Account, Account name  

For each account, the first row displays the account number and the name of the account.

For credit card accounts, the name of the respective credit card appears here.

Last Name / First Name

From the second line of the account, postings belonging to the account are displayed, including the last name and first name of the corresponding profile.

Invoice Number

Invoice number for which a receivable exists or a payment has been posted.

Date

Posting date / Value date

<30; 31-60; 61-90; 91-120; >120

In these columns, the individual receivables or postings are displayed in the hotel’s currency. Each column is for a certain time period. If the receivable or posting is less than 30 days in the past, it appears below the < 30 days column, if the receivable or posting is 31-60 days in the past, it appears below the 31-60 days column, and so on.

Subtotal

If there are several postings/receivables, these are added to a subtotal for each receivables account.

The report is grouped by

Credit card accounts are displayed in a separate section as collective accounts. All receivables from the corresponding reservations are displayed collectively here (a batched credit card account is automatically created for credit card payments if the credit card payment type has been marked as debtor in the system data).

Sorting within an account takes place in ascending order by date.

The accounts within the reports are sorted in ascending order by the account numbers.

Example

Reports to balance against

Available User rights