Skip to content

Overview of Reports Related to Sales

The report generation function is only available to users with appropriate permissions.

DAILY REPORT

"Daily Report" allows you to generate a report containing data from a selected day and additionally from a specific project. You will find information in the following sections:

New meetings

Meetings on this day - the number of registered (closed) meetings that took place on the searched day.

Meetings this month - the number of registered (closed) meetings that took place in the month of the searched day, so if we search for example May 15, 2023, the system will show all meetings from May 2023.

New clients

Online campaigns (lead) - the number of all clients converted from leads on the searched day. The client creation date is the date of conversion. So if a lead entered the database on May 13 and was converted on May 14, the client creation date will be May 14.
Direct addition to the system - the number of clients added directly to the system on a given day.

Total - the sum of all new clients on a given day.

Apartments statistics

  • Quantity:
    • All apartments - the number of all apartments in the system.
    • Sold apartments - the number of all sold apartments in the system up to the search day, in brackets the system will show the date of the most recently sold apartment up to the search day.
    • Apartments with reservation agreements - the number of all apartments that have a reservation agreement up to the search day, in brackets the system will show the date of the most recently created reservation agreement up to the search day.
  • Area:
    • Total apartment area - the sum of the area of all apartments in the investment. Sum of apartment areas under reservation agreement - the sum of the areas of all apartments with a reservation agreement, in brackets the system will show the percentage of the total apartment area in the investment.
    • Sum of sold apartment areas - the sum of the areas of all sold apartments, in brackets the system will show them as a percentage of the total apartment area in the investment.
    • Net total - the sum of catalog prices of all apartments in the investment net.
    • Gross total - the sum of catalog prices of all apartments in the investment gross.
  • Value of properties with reservation agreement:
    • Net value of apartments with reservation agreement - the sum of apartment prices under reservation agreement net.
    • Gross value of apartments with reservation agreement - the sum of apartment prices under reservation agreement gross.
    • Value of parking spaces with reservation agreement - the sum of prices of all garages under reservation agreement gross.
    • Value of storage units with reservation agreement - the sum of prices of all storage units under reservation agreement.
  • Value of sold properties:
    • Net value of sold apartments - the sum of apartment prices in agreements net (development agreement, notarial deed).
    • Gross value of sold apartments - the sum of apartment prices in agreements gross (development agreement, notarial deed).
    • Value of sold parking spaces - the sum of prices of all garages in agreements gross (development agreement, notarial deed).
    • Value of sold storage units - the sum of prices of all storage units in agreements gross (development agreement, notarial deed).

REPORT RESERVATIONS AND AGREEMENTS

The "Reservations and Agreements Report" provides a summary of concluded agreements and made reservations.

You can filter the generated data according to various criteria, such as selected day, status, project, stage, building, advisor, source of origin, or agreement status.

When selecting the "Status" option in filters, additional fields will appear:

  • "Status set date from"
  • "Status set date to"

However, when status is not selected, these fields will not be visible.

The report presents the following information:

  • Client: First and last name of the client,
  • Contact ID,
  • Investment,
  • Stage,
  • Lead ID from API,
  • Contact creation date,
  • Link date,
  • Reservation set date,
  • Reservation agreement set date,
  • Preliminary agreement set date,
  • Development agreement set date,
  • Authenticated deed set date,
  • Reservation agreement date,
  • Preliminary agreement date,
  • Developer agreement date,
  • Authenticated deed date,
  • Source
  • Contact method,
  • Flat,
  • Floor,
  • Living area,
  • Current price per m2 on the agreement,
  • Current gross price on the agreement,
  • Agent.

By clicking on the client's data, you will be redirected to their card, where detailed information about the client is available.

FORECAST REPORT

The "Reservations and agreements" report allows filtering generated data according to various criteria, such as investment, agreement type, date (month and year), stage, building, and status.

Below the filter panel, there is the gross total of payments made and a quantitative summary of the total agreements.

The presented report is divided into specific investments and months. For each month under each investment, there is information regarding:

  • Quantity of agreements - (reservation, preliminary, development, notarial deeds).
  • Forecast gross - the sum of tranches that should be closed in a given month.
  • Payments gross - the sum of payments to tranches according to the forecast.
  • Left to pay gross - the difference between the forecast and the paid amount.

The first row contains the sum of values for all the presented months.

SALES IN PROGRESS REPORT

The "Sales in Progress Report" presents currently ongoing transactions. It allows filtering generated data according to various criteria, such as date, users, projects, and the source of client origin.

The report presents two summaries in graphical form: the number of clients and the number of client-property connections. In both summaries, the data is divided into categories:

  • Interested,
  • Oral reservation,
  • Reservation agreement,
  • Development agreement.

At the bottom of the report, both summaries are presented in table form, also containing the estimated value of the data.

SALES FINISHED REPORT

The "Sales Finished Report" provides information about clients who have left various stages of the sales process. It also provides a percentage representation of clients in individual sales stages.

Data in the report can be filtered by a specific range of client creation dates, source of origin, and projects. This allows for precise matching of the analysis to the user's needs.

The report shows the number of clients assigned to individual activities, such as "New client," "Interested," "Verbal reservation," "Reservation agreement," "Development/preliminary agreement," and "Reception." The report contains information about the number of clients who have left given sales stages, as well as the percentage value of this number in relation to the total number of clients.

The report also includes a table that presents detailed information about the reasons for refusal along with the quantity. Next to the table is a pie chart that visually presents this data.

The report is a very useful tool for tracking sales conversion, identifying potential problems, and optimizing sales processes. Thanks to it, you can better understand which sales stages are most important and how sales efficiency can be improved.

SALES REPORT

The sales report presents information in a monthly form regarding the number of sold properties in particular investments. It also contains information about the number of available properties for sale in each investment and a summary of the value of sold and unsold properties.

The report allows filtering data using the following filters: investment, building, date range (years), agreement type, and stage.

The amounts given are gross amounts.

The data in the report is divided into individual months and presented in the form of columns, which include the following information:

  • Investment
  • Number of properties in the investment/ their total area in m2
  • Value of apartments and adjacencies (Total)
  • Number of sold properties/ total area in m2
  • Number of properties remaining for sale/ total area in m2
  • Value of properties remaining for sale
  • Number and value of unsold adjacencies
    • Number of parking spaces
    • Value of parking spaces (Total)
    • Storage units, boxes, etc. (number)
    • Value of storage units, boxes, etc. (Total)
  • Number and value of sold adjacencies
    • Number of parking spaces
    • Value of parking spaces (Total)
    • Storage units, boxes, etc. (number)
    • Value of storage units, boxes, etc. (Total)
  • Number of properties sold in a given month
  • Value of sold properties along with associated rights in a given month
  • Total sales value in a given month
  • Value of sales in the entire form in a given month (sum from all investments)
  • Increasing value in a given year (sum from all investments)

In the columns:

  • Number of sold properties/ total area in m2.
  • Number of properties remaining for sale/ total area in m2.

By clicking on the displayed numbers, you have the possibility to obtain more detailed information regarding specific properties.

NET SALES REPORT

The net sales report presents the same information as the sales report, but all values are given in net amounts. This means that the presented numbers reflect values after deducting VAT.

SALES REPORT - DATE OF SUBSEQUENT TRANCHES

The "Sales Report - Date of Subsequent Tranches" provides detailed information on payments related to agreements in specific investments.

The report allows filtering data using the following filters:

  • Flat - text field for entering the main property number associated with the agreement
  • Agreement type - agreement type, options to choose from: "Reservation agreement", "Development agreement", "Preliminary agreement", "Notarial deed"
  • Client - text field to search for a client associated with the agreement
  • Agent - field to select the advisor assigned to the agreement
  • Investment - field to select investments for which the system should search for agreements
  • Date of signing the agreement from and to - date range in which the agreement was signed
  • Realestate type - E.g. apartment, commercial premises, house, plot, garage, etc.
  • Date of payment of subsequent tranches from and to - date range in which subsequent tranches are to be paid

Above the main report table, the system will show summaries:

  • Total agreements value - the sum of all gross amounts from active agreements, the system only sums amounts from searched agreements of the highest type in the property.
  • Paid - the sum of all gross payments from active agreements, the system only sums payments from searched agreements of the highest type in the property.
  • Due for payment - the sum of all remaining gross amounts to be paid from active agreements, the system only sums remaining amounts from searched agreements of the highest type in the property.
  • Not sold realestates value - the sum of catalog prices of all properties without an active agreement in the searched investments.
  • PUM total - total area of properties in the searched investments.
  • PUM sold - total area of sold properties in the searched investments.
  • PUM not sold - total area of properties without an agreement in the searched investments.
  • Total realestates count - total number of properties in the searched investments.
  • Sold - total number of properties with an active agreement in the searched investments.
  • Left - total number of properties without an agreement in the searched investments.
  • Total contiguities count - total number of adjacencies in the searched investments.
  • Sold - total number of adjacencies with an active agreement in the searched investments.
  • Left - total number of adjacencies without an agreement in the searched investments.

The report presents data using the following columns:

  • Client - last name and first name of the client(s) associated with the agreement.
  • Investment - investment associated with the main property in the agreement.
  • Agreement type - type of agreement added to the CRM system, e.g., Reservation agreement, Development agreement.
  • Agreement date - date of signing the agreement by the client entered into the agreement in the CRM system.
  • Flat num. - name of the main property associated with the agreement.
  • Area - area of the main property associated with the agreement.
  • PP ground - number of aboveground parking places associated with the agreement.
  • PP underground - number of underground parking places associated with the agreement.
  • Cellar/Cubby - number(s) of storage cellars/cubbies associated with the agreement.
  • Flat price gross (PLN) - gross transaction price of the main property associated with the agreement.
  • Flat price net (PLN) - net transaction price of the main property associated with the agreement.
  • PP Ground price gross (PLN) - sum of gross transaction prices of aboveground parking places associated with the agreement.
  • PP Ground price net (PLN) - sum of net transaction prices of aboveground parking places associated with the agreement.
  • PP Underground price gross (PLN) - sum of gross transaction prices of underground parking places associated with the agreement.
  • PP Underground price net (PLN) - sum of net transaction prices of underground parking places associated with the agreement.
  • Cellar/cubby price gross (PLN) - sum of gross transaction prices of storage cellars and cubbies associated with the agreement.
  • Cellar/cubby price net (PLN) - sum of net transaction prices of storage cellars and cubbies associated with the agreement.
    Already paid gross (PLN) - sum of added payments associated with tranches in the agreement.
  • Amount of debt gross (PLN) - sum of debt in the agreement, i.e., the amount that should have been paid in the agreement in tranches whose deadline has passed.
  • To pay gross (PLN) - sum of payments that should still be added to the agreement for tranches whose deadline has not passed.
  • Dates of subsequent tranches - list of dates of tranches in which payments covering the tranche amounts have not been added. The date in the tranche whose deadline has passed will be shown in red.

AGREEMENTS REPORT FOR BANK

The "Agreements Report for Bank" contains a list of agreements along with all details regarding each agreement. By default, the generated report includes agreements with the following statuses: "Notarial deed", "Development agreement", "Preliminary agreement", and "Reservation agreement".

To generate a report that meets your needs, there is a possibility to use various filters, such as property, agreement type, client, advisor, project, stage, agreement signing date, and agreement status. These filters allow you to customize the report to specific requirements and user preferences.

Below the filters section, there is summarized information contained in the report, such as:

  • Paid - the sum of all amounts that have already been paid under the agreements.
  • Due for payment - the sum of amounts that have not yet been settled under the agreements.
  • PUM sold - the total sum of areas of sold properties in the agreements.
  • PUM total - the total sum of areas of all properties covered by the agreements.

These summarized information allow you to quickly obtain a general overview of the data contained in the report.

Individual columns in the report:

  • Client - last name and first name of the client(s) associated with the agreement.
  • Investment - investment associated with the main property in the agreement.
  • Agreement type - type of agreement added to the CRM system, e.g., Reservation agreement, Development agreement.
  • Date of signing the agreement - date of signing the agreement by the client entered into the agreement in the CRM system.
  • Rep. number.
  • Flat Num. - name of the main property associated with the agreement.
  • AREA - area of the main property associated with the agreement.
  • Usable Area
  • AREA after post-completion settlement - area of the main property associated with the agreement after post-completion settlement.
  • PP Ground 1 - number(s) of aboveground parking places associated with the agreement.
  • PP Ground 2 - number(s) of aboveground parking places associated with the agreement.
  • PP Underground 1 - number(s) of underground parking places associated with the agreement.
  • PP Underground 2 - numbr(s) of underground parking places associated with the agreement.
  • Cellar - number(s) of cellar units associated with the agreement.
  • Cubby - number(s) of cubbies associated with the agreement.
  • Flat price gross (PLN)
  • Flat price net (PLN)
  • PP Ground price no 1 gross (PLN)
  • PP Ground price no 1 net (PLN)
  • PP Ground price no 2 gross (PLN)
  • PP Ground price no 2 net (PLN)
  • PP Underground price no 1 gross (PLN)
  • PP Underground price no 1 net (PLN)
  • PP Underground price no 2 gross (PLN)
  • PP Underground price no 2 net (PLN)
  • Garage price no 1 gross (PLN)
  • Garage price no 1 net (PLN)
  • Cellar price gross (PLN)
  • Cellar price net (PLN)
  • Cubby price gross (PLN)
  • Cubby price net (PLN)
  • Total price gross (PLN)
  • Total price net (PLN)
  • Paid (PLN)
  • Due for payment (PLN)

The "Bank agreements" report provides comprehensive information for bank-related needs.

AGREEMENTS SUMMARY REPORT

The "Agreement Summary Report" displays all concluded agreements, even those that have been canceled. If a property had several agreements assigned, the report will include all of them.

Available filters allow selecting a specific investment, building, year (from-to), month, agreement type, advisor, and agreement status.

The generated data is presented in the form of columns, which contain the following information:

  • Agreement number
  • Agreement date
  • Agreement type (reservation, development, preliminary, notarial deed)
  • Client
  • Real estate number
  • Area in square meters
  • Investment
  • Agent
  • Flat discount (in percent)
  • Agreement discount (in percent)
  • Net value
  • Gross value

The report also contains values from individual quarters.

Agreements that have been canceled are marked in red.

FINAL AGREEMENTS REPORT

The "Final Agreements Report" contains a summary of preliminary, development, and final agreements in a given year. The data is divided into quarters (I, II, III, IV).

It is possible to filter the generated data using various filters, such as investment, year (from-to), agreement type, stage, and buildings. Thanks to these filters, we can precisely adapt the report to our needs.

The report is divided into sections, where each shows a different quarter. In each quarter, there is a list of agreements and a general sum of agreement values for the given quarter. At the bottom of the report, there is also information about the general annual sum.

Agreements that have been canceled are marked in red, so they can be easily identified.

The report contains the following columns:

  • Mark: agreement name in the system
  • Real estate number
  • Sign date: agreement signing date
  • Agent: assigned advisor responsible for the agreement
  • Client: client assigned to the agreement
  • Status: (Canceled, in progress, signed)
  • Dissolve date: cancellation date of the canceled agreement
  • Initial Net Value
  • Final Net Value

SOLD AND NOT SOLD REPORT

The "Sold and Not Sold Report" presents data regarding the area and value of sold and unsold properties and adjacencies.

The report allows filtering data using the following filters: investment, agreement type, stage, buildings, agreement status, and agreement signing date.

The first part of the report presents information regarding sold properties and adjacencies. The columns contain the following data:

  • Total sales (net)
  • Total sales (gross)
  • Amount
  • Percentage share of the total
  • Total area in square meters
  • Percentage share of the total
  • Minimum price per square meter (net)
  • Minimum price per square meter (gross)
  • Average price per square meter (net)
  • Average price per square meter (gross)
  • Maximum price per square meter (net)
  • Maximum price per square meter (gross)

The next part of the report contains identical information, but regarding unsold properties.

At the bottom of the report, there is a summary, which contains summed data from both sections.

AGREEMENTS - PAYMENTS REPORT

The "Agreements - Payments Report" contains information regarding payments made for individual agreements. It allows tracking payments related to agreements and analyzing financial data.

To generate the report, we have available filters, such as property, agreement type, client, advisor, project, and agreement signing date. Thanks to these filters, we can precisely adapt the report to our needs.

The first section of the report presents the sum of payments broken down into individual quarters and months. Each month is divided into rows, containing information such as:

  • Sum of monthly gross payments
  • Sum of monthly net payments
  • Planned monthly gross payments
  • Planned monthly net payments
  • Planned cumulative gross inflows
  • Made cumulative gross inflows
  • Made cumulative net inflows
  • Planned cumulative inflows in quarters gross
  • Planned cumulative inflows in quarters net
  • Made cumulative inflows in quarters gross
  • Made cumulative inflows in quarters net

The next section of the report is a list of agreements. For each agreement, there is information such as property number, buyer/agreement number/conclusion date, area/agreement type/agreement value (net/gross).

Then, for each quarter, individual months are broken down. In the months in which payments were made on these agreements, there is information about the payment amount, payment date, and VAT percentage rate.

SALES SUMMARY REPORT

The sales summary report provides you with information about sold properties in the time period selected by you.

To generate the report, you have available filters such as specific project, agreement status, building, or creation date.

The first section of the report presents information divided into specific investments. Columns contain agreement types such as reservation agreement, development, preliminary, notarial deed, and total. Each column is divided into additional sections such as: sold area in m2, sold area in %, average net price per square meter, and gross sales price.

Then we have a list of individual months. Each month is assigned the number of sold properties, percentage of the total sold properties, Number of properties sold in general, and percentage of the total properties sold in general.

Then we will find a list of agreements with their details such as client data, property area, agreement signing date, apartment price, information about adjacency, and possible description. The first row contains the sum of values of all columns.

FORECAST PAYMENTS REPORT

The forecasted payments report is a summary of monthly forecasted payments and their current values in the current or previous months.

To generate this report, you have access to various filters, such as specific investment, stage, building, date range, and agreement type.

The report is divided into individual months. For each month, forecasts of expected amounts are given (net, VAT, and gross). Additionally, the report contains information about payments already made (net and gross) and about debt (net and gross).

REMAINING TO BE PAID PAYMENTS REPORT

The report of remaining payments to be made is a summary of payment forecasts and the remaining amount to be paid.

To generate this report, you have access to various filters, such as specific investment, stage, building, date range, and agreement type.

The report is divided into individual months. For each month, forecasts of expected amounts are given (net, VAT, and gross). Additionally, the report contains information about remaining amounts to be paid (Net, Gross).

DEBTORS REPORT

The debtors report is a list of agreements that have payment arrears, along with the remaining amount to be settled.

To generate this report, you have the possibility to apply various filters, such as specific investment, agreement, client, stage, building, agreement type, and status.

The report generated by the system will contain a table with columns such as:

  • Agreement - agreement number in the CRM system,
  • Flat - property for which the agreement was created,
  • Contiguities - storage units, garages, etc. properties associated with the agreement,
  • Financial advisor - financial advisor assigned to the agreement,
  • Shareholders - clients (last name and first name) assigned to the agreement,
  • Phone - phone numbers of clients assigned to the agreement,
  • Agreement signing date,
  • Gross value,
  • Already paid - sum of gross payments in the agreement,
  • Amount of debt - sum of overdue gross payments in the agreement,
  • Days - number of days from the oldest tranche deadline for settlement.

AGREEMENTS REPORT

The agreements report is a summary of all signed agreements that are in the system.

To generate this report, you have the possibility to use various filters, such as agreement type, status, signing date, project, building.

The generated report in the form of a table contains the following columns:

  • Client - last name and first name of the client(s) associated with the agreement
  • Agreement number - unique identification number of the agreement in the CRM system
  • Date of signing the agreement - date on which the agreement was signed
  • Building
  • Flat
  • Area in m2
  • Net price
  • VAT
  • Gross price
  • Garage unit
    • Area in m2
    • Net price
    • VAT
    • Gross price
  • Total price net (PLN)
  • Total price gross (PLN)
  • Realestate account number
  • PIN - (Personal ID Number)
  • Agent

CANCELED RESERVATION REPORT

The canceled reservations report is a list of reservations that have been canceled.

To generate this report, you have the possibility to use various filters, such as reservation validity date, specific project, or reason for cancellation.

The generated report contains the following information:

  • Client name - identification data (first and last name) of the client who made the reservation.
  • Local - number or designation of the property that the client reserved.
  • From - time in which the reservation started.
  • To - time in which the reservation was canceled
  • Reason and cause for which the reservation was canceled.
  • Cancellation date
  • Full advisor name - identification data (first and last name) of the advisor who handled the reservation.

Thanks to this information, the report allows easy identification of clients, properties, and reasons for cancellation of reservations.

SALES DYNAMICS REPORT

The sales dynamics report contains a summary of investments along with information regarding sales.

The report can be filtered by specific investment and date.

The generated report will be in the form of a table and will contain the following columns:

  • Status - defines the current sales status for a given investment. This may be a reservation agreement, development, preliminary, notarial deed, lease agreement, or availability.
  • Flats - number and total area of properties available under a given status.
  • Cellars - number and total area of storage units available under a given status.
  • Parking places - number of parking spaces available under a given status.

OMNIBUS REPORT

You will find a detailed description of the report under the link Overview of Omnibus Report

SALES STATISTICS REPORT

The "Sales Statistics Report" contains a summary of sold investments, reservation agreements, and verbal reservations.

You can generate the report for a specific investment, stage, and selected period in which agreements were signed.

The first section of the report concerns sales and contains data presented in the following columns:

  • Type - (Apartments, Garages, Storage units, etc.)
  • Count - number of sold apartments in the specified date range.
  • Part - count - Quotient of the value from the "Number" column by the total number of apartments in the project/stage (the value for the entire project will be substituted when no stage is selected in the filters) in the specified date range.
  • Total area of sold realestate - sum of the areas of sold apartments in the specified date range.
  • Part - total area of sold realestate - Quotient of the value from the "PUM" column by the total sum of apartment areas in the project/stage (the value for the entire project will be substituted when no stage is selected in the filters) in the specified date range.
  • Avg. sale net price m2 - average net price per m2 from all found apartments in the specified date range.

In the "Sales - detailed" table, the system will show data for properties of type "Apartment", broken down by rooms, which have an active development agreement or preliminary agreement or notarial deed (sales agreement).

For the "Sales - detailed" table, the system will generate a row for each number of rooms in the apartment. So if there are properties from one-room to five-room in the searched data range, the system will generate five rows with names: "Apartment - rooms:1", "Apartment - rooms:2", "Apartment - rooms:3", etc.

The "Reservation agreements" section contains the same data as the "Sales" section, but refers to reservation agreements, not sold properties.

The "Oral reservations forecast" section contains information such as type, number, share - number, PUM.

At the end of the report, there is a summary of the entire project, which contains property types along with their number in the project and the project's PUM.

AGREEMENTS REPORT - PAYMENTS SUMMARY

The report contains information regarding all payments assigned to a given property in the system. To facilitate data viewing, filters such as: project, agreement type, stage, buildings, and agreement status are available.

The generated data is presented in a table, which contains the following columns:

  • Investment: Name of the investment to which a given property is assigned.
  • Flat: Designation or number of the property for which the agreement was created.
  • Customer: Client associated with the agreement.
  • Agreement price gross
  • Total Gross Payments To The Escrow Account
  • Total Gross Payments To The Company Account
  • Total Gross Payments To The Developer's Account
  • Total Funds Released By Bank Gross
  • Amount Left After Release By Bank Gross

Thanks to this information, the report allows easy tracking of payments associated with a given property.

FUNDS TO BE RELEASED BY BANK REPORT

On the subpage of the report of remaining funds to be released from the bank, it will be possible to search for agreements using the following filters:

  • Listing - property number by which the system can search for agreements.
  • Client - text field by which it will be possible to search for a client associated with the agreement (by first name or last name).
  • Agent - multiple choice field that allows searching for agreements where the marked user is assigned.
  • Investment - multiple choice field for searching data from marked investments.
  • Date of signing agreement from - to - period for which the system will search for agreements signed in the searched period.
  • Advancement of the investment - text field in which it will be possible to enter a value from 1 to 100.

Each row in the generated report will show data from the searched agreements, divided into columns:

  • Client name - list of clients associated with the agreement,
  • Flat - name of the main property assigned to the agreement,
  • Contiguity - numbers of adjacencies linked to the agreement,
  • Escrow account number,
  • Agreement number,
  • Agreement date,
  • Agreement value - gross amount,
  • Sum of escrow account payments,
  • Released payments schedule - section with information about the scheduled payment schedule divided into three columns:
    • Tranche num. - name of the tranche from the "Schedule of released funds" section in the investment card,
    • Tranche percentage - percentage of released funds,
    • Tranche amount - tranche value.
  • Funds released by bank so far - section with information about funds already released by the bank, divided by tranches, divided into two columns:
    • Overall - sum of all funds released in the agreement,
    • Divided into tranches - breakdown of the amount released by the bank into tranches from the payment schedule.
  • Funds remaining on escrow account - amount remaining to be released by the bank in the agreement. Calculated based on the difference between the amount from the columns "Sum of payments to the escrow account" and "Funds previously released by the bank".
  • Division of funds remaining on escrow account into tranches - breakdown of funds remaining to be released by the bank into tranches from the schedule of released funds, taking into account already paid out funds.
  • Agreement value to investment advancement amount - value of the amount that the bank should release based on the percentage of completion of the investment. The percentage value of investment progress will be set manually in the "Investment progress" filter.
  • To pay - breakdown of the amount that the bank should pay out, divided by tranches in the schedule of released funds.

BILLING PLAN REPORT

The report allows you to generate a billing plan for a specific investment or stage.

Description of individual report columns:

  • Customer - list of clients associated with the agreement.
  • Developer agreement number.
  • MRP account - section with information regarding the escrow account, divided into five columns:
    • Account number - number of the individual escrow account assigned to the client.
    • Total payments on account - sum of client's payments to the individual escrow account under a given agreement; retrieved as the sum of values from the Gross amount fields, payment type - To the escrow account in the form of adding a payment in the payment schedule.
    • Total withdrawals from account - sum of withdrawals from the individual escrow account; data retrieved as the sum of values from the Payment amount fields for a given development agreement from the view List of funds released by the bank.
    • Last withdrawal amount.
    • Last withdrawal time.
  • Total amount gross.
  • Transaction price gross - section with information regarding the gross transaction price, divided by property types:
    • Primary flat on agreement - gross transaction price of the main property (Apartment, Commercial premises, House, Office premises.
    • Place garage - sum of gross transaction prices of all garage spaces associated with the agreement (property types: garage, underground parking space).
    • Place outdoor - sum of gross transaction prices of all external spaces.
    • Cubby - sum of gross transaction prices of all storage units associated with the agreement (property types: basement, box, storage unit).
    • Contiguity package - sum of prices of adjacencies assigned to the property.
  • Transaction price net - section with information regarding the net transaction price, divided by property types:
    • Primary flat on agreement,
    • Place garage,
    • Place outdoor,
    • Cubby,
    • Contiguity package.
  • Number - section with information regarding the numbering of individual property types:
    • Primary flat on agreement - main property number.
    • Place garage - numbers of garage spaces (property types: garage, underground parking space).
    • Place outdoor - numbers of external spaces (property types: aboveground parking space).
    • Cubby - numbers of storage units (property types: basement, box, storage unit) on a given agreement, separated by commas; data retrieved from the Name field from property editing.
    • Contiguity package - numbers of adjacencies assigned to the property.

AGREEMENT PAYMENT REPORT

A report that provides you with information on whether a client has paid the required percentage value in the system under an agreement.

To generate the report, you have available filters such as:

  • Local - text field allowing to search for a specific property.
  • Agreement type - multiple choice field allowing to mark a specific agreement type.
  • Client - text field allowing to search for a specific client.
  • Assigned to - choice of a specific advisor.
  • Investment - searching for properties only from a selected investment.
  • Stage - choice of a specific stage.
  • Building - choice of a specific building.
  • Agreement signing date from and to: marking a specific time period.

The report presents data using the following columns:

  • Investment - name of the investment to which the property is assigned in the system.
  • Local No. - number of the main property for which the agreement is created in the system.
  • Client name - first and last name of the main client assigned to the highest agreement with the property (data is shown if the property has an agreement).
  • Agent - advisor assigned to the agreement.
  • Client classification - values from the "Classification" field.
  • Agreement number,
  • Agreement type - the system will show the highest type of agreement that is active on the main property (Reservation agreement, Development agreement, Preliminary agreement, Notarial deed).
  • Agreement signing date.
  • Realestate offer price gross.
  • Realestate offer price net.
  • Realestate transaction price gross.
  • Realestate transaction price net.
  • Payment amount 5% - the system will show one of two activities: paid or unpaid. The value paid will be shown when the sum of payments added to the agreement exceeds or equals 5% of the value of the price for the entire agreement.
  • Agreement paid sum.
  • Agreement paid sum %.
  • Agreement net amount.
  • Agreement gross amount.

INVESTMENT REPORT

The "Investment Report" contains information about all properties present in the system. To generate the report, you can use various filters, such as specific investment, stage, buildings, and property type.

The generated report presents data in a table, and available filters allow precise limitation of results to the desired criteria.
The report presents data using the following columns:

  • Realestate type - (e.g., Apartment, Basement, Parking space),
  • Stage,
  • Building Number,
  • Floor,
  • Local - Information about the property:
    • Administrative Number,
    • Name,
    • Rooms (Number),
    • Area (M2),
    • Total external area,
    • VAT,
    • Gross Price,
    • Price net,
    • Price m2 net,
    • Sales with storage room,
    • Sales with parking,
    • Sales with parking with cubby,
    • Status,
  • Number of the related real estate.
  • Client / Company - client's / company data.
  • Transaction price:
    • Price gross,
    • Price net.
  • Letter of intent:
    • Price gross,
    • Price net,
    • Date of signing,
    • Rep number.
  • Preliminary agreement:
    • Price gross,
    • Price net,
    • Date of signing,
    • Rep number.
  • Developer agreement:
    • Price gross,
    • Price net,
    • Date of signing,
    • Rep number.
  • Final agreement:
    • Price gross,
    • Price net,
    • Date of signing,
    • Rep number.
  • Annex:
    • Rep number.
    • Date of signing,
    • Description.
  • Tenant change.
  • Cession:
    • Rep. number.
    • Date of signing,
  • The date of receipt protocol.

Thanks to this report, you can obtain a complete summary of all properties that are in the system, adapted to the selected filters.

REALESTATE SALES SUMMARY REPORT

The report presents a summary of properties that have been sold.

You can generate the needed data using the following filters:

  • Investment,
  • Stage,
  • Buildings - selection of specific buildings within a given investment,
  • Realestate type - filter allowing to select property types that are to be displayed in the report. It will be possible to display the report for a single property type (for example, only for apartments, commercial premises, parking spaces, or storage units) as well as for all selected in the filter.

The report will consist of two sections:

  • Summary table,
  • Proper report.

Each row in the generated report will show data from the searched agreements, divided into columns:

  • Client - list of clients associated with the agreement,
  • Agreement type,
  • Agreement date,
  • Agreement number,
  • SAP number,
  • Realestate account number,
  • Local - section with information regarding information about the main property assigned to the agreement:
    • Number,
    • Area - (m2),
    • Gross catalog price,
    • Gross price after measurement - price calculated based on the gross m2 price of the property and the post-completion area filled in in the agreement view, the post-completion area can be edited in the Area Settlement section in the agreement view. The displayed value in the "Gross apartment price" position is already the gross price after measurement.
  • Parking lots - section with information regarding all types of parking spaces assigned to the main property (covered parking space, garage, parking space, dependent double parking space, single-track vehicle parking space, aboveground parking space, underground parking space, parking space with box):
    • Number,
    • Price gross.
  • Storage unit - section with information regarding all types of associated spaces assigned to the main property (property types: basement, bicycle box, box, storage unit):
    • Number,
    • Price gross.
  • Contiguities package - section with information regarding all types of adjacencies assigned to the main property:
    • Number,
    • Price gross.
  • Net amount of signed agreements
  • Gross value of signed agreements - displays the sum of amounts of all agreements in the report.
  • Payment schedule - section with information regarding amounts, payments, and tranche deadlines retrieved from the Schedule - Payments table from the agreement view.
    • Tranche amount - gross amount of the given tranche,
    • Due date - date of the planned payment of the given tranche,
    • Payment to a trust account - value of the made gross payment within the given tranche paid to the escrow account,
    • Payment to a company account - value of the payment made to the company account
    • Payment to a company account to return,
    • Payment to cession account - value of the payment made to the assignment account for agreements included in the report,
    • Return to the customer,
    • Cash,
    • Payment date,
    • Delay on days - difference in the deadline of the given tranche and the actual date of its payment expressed in the number of days displayed in case the payment deadline of the given tranche has been exceeded. Displayed in negative values. The delay is counted until the entire amount within the given tranche is paid. Partial payment of the tranche still accrues delay.
  • Gross arrears amount - difference in gross amount of the given tranche and the payment made for the given tranche. Amount calculated from the fields tranche list Tranche amount and Paid. The value is displayed in a situation where the payment deadline of the given tranche has passed, i.e., if the date displayed in the payment deadline column is a date older than the date of generating the report,
  • Gross amount remained - difference between payments made to escrow and company accounts and the value of signed agreements.

The first row of the report will contain information regarding the sum of values of selected columns.