In this guide:
Introduction
This report is tailored for accounting and financial controllers. It provides a detailed overview of open receivables and liabilities per reservation, including gross receivables and liabilities categorized by VAT Type. The report can be filtered by property and transaction date, offering a precise financial snapshot for informed decision-making.
Report Parameters
The report includes a list of filters that can be used to refine the results, which are:
- Property*: Specifies the property transactions that will be filtered.
- Date range*: Specifies start & end date to filter transactions by business date. (If you would like to pull data from the beginning of time (auf Stichtag), please always use the date of the very first reservation creation in Apaleo)
- Previous Datasheet: Specifies the Sheet name of a previously generated report to include its data in the newly generated report without recalculating the data each time.
- Line # of last entry: Specifies the line number of the last entry (not the total line) in the previous datasheet to use it. (fill this only if you entered the previous datasheet field).
Please note that the filters marked with an asterisk (*) are mandatory fields that need to be filled out.
Correct Generation of the Report
The first time you run the report, it is important that you start the date range from the date of the first transaction in Apaleo (select the date of the first reservation creation).
For each subsequent report:
- Always run each new report in a new tab. We recommend that you select a recurring date range as needed (e.g. monthly, daily, etc.)
- Ensure that you fill out the fields "Previous Datasheet" and "Line # of last entry" accurately to include the data of the previously generated report without recalculating the data.