Overview

The Appraisals module stores the appraisals of each building: date, appraiser, market values HD and DI, valuation methods, rental assumptions and documents.

What this operating guide covers

  • The list of a building's appraisals, the creation of an appraisal and its fields.

  • The active appraisal: what it feeds in Soneka and where an appraisal is chosen.

  • The versioning: working versions under each appraisal (the expert's initial report, counter-proposals…), of which only one is retained.

  • The validation workflow, with or without an approval matrix, with or without versioning.

  • The consolidated view: all appraisals and their versions across a scope of buildings, with mass submission, validation and rejection.

The appraisals list

The list is available in the building's tab Appraisals, under the title Appraisals list: one row per appraisal.

The columns

Column

Content

State

Radio button: indicates the active appraisal of the building.

Date

Appraisal date, with its type and reason; Partial if the scope is partial.

Net value

Market value excluding transfer costs.

Expert

Expert, and second expert if the second appraiser is used.

Method

Valuation method used (with versioning).

Status

In progress, Submitted, Validated or Rejected (with the workflow).

The actions

  • Add an appraisal: creates a new appraisal (not a version). The button is hidden from external users and experts.

  • Eye icon View: opens the appraisal sheet.

  • Menu ⋮: Edit, Duplicate and Delete. With versioning, Duplicate adds a version to the appraisal; without versioning, it directly creates a copy of the appraisal (message “The appraisal has been duplicated”).

  • Delete is greyed out on the active appraisal when the building has other appraisals: a deleted appraisal takes all its versions with it, and the active appraisal indicator moves to the most recent appraisal. Deletion is also refused (Deletion impossible) if the appraisal is used as the building's entry value, as the basis of a sale, or if valuations or frozen projections use it.

With versioning (Image 2)

  • A chevron and a badge showing the number of versions appear in front of the date of appraisals that have versions; a click expands the Versions table (Date, Net value, Expert, Second expert, Method, Status).

  • The Net value column of an appraisal that has a validated version shows its figure, with Vn validated below it.

  • As long as no version is validated, the value displayed is “—”, followed by In progress: amount (Vn) for the latest version.

  • Each version has its Duplicate and Delete buttons (trash icon).

Create an appraisal

1. Click Add an appraisal.

2. Step Information: enter the appraisal date (required), the type (Appraisal or Update), the appraiser and the expert, the second appraiser and the second expert, the reason, and the scope (total or partial appraisal).

3. Step Appraisal: fill in the blocks.

Block

Content

Data chosen by the expert

Gross rent, net rent, rent-free periods, areas (total, vacant, weighted, land), parking, ERV, potential rent, future CAPEX.

Values used

Used method, appraisal value (HD), appraisal value including TT (DI), transfer tax (in %), empty value. The notary fees amount (DI − HD) and the gross and potential yields (calculated on the DI value) are not entered.

Capitalization

Cap rate, capitalized cashflow, net value per capitalization.

DCF

Discount rate, exit yield, net value per DCF.

Comparison

Occupation rebate, bulk sale rebate, net value per comparison, net value per m² used.

Rental assumptions

One row per unit type: area, ERV, metric ratio, rate. ERV and area are optional.

Other

Breakdown of the value by unit type, other values, additional fields, documents.

The used method can combine several methods: one block per method.

On the sheet

  • Six summary indicators, each with its variance.

  • The variance vs selector compares the sheet with another appraisal or version of the building: in basis points for rates, in amount for values. By default, the sheet is compared with the most recent appraisal or version of the building that is not the active appraisal, whatever its original appraisal.

  • The comments (Add a comment) and the posts (Add a post) are attached to the appraisal.

  • The external ID of the appraisal is displayed on the sheet when it is filled in.

The active appraisal and its uses

Only one appraisal per building is active: it is the one read by the building's calculations.

It is chosen with the radio button in the State column, on appraisals only (never on a version).

What the active appraisal feeds

Item

Value used

Building indicators

Appraisal value HD and DI, HD value/m², appraisal ERV, capital gains or losses (HD − VNC), LTV.

Immediate and potential yields

Rent / DI value of the active appraisal, failing that its HD value, failing that the acquisition price.

Future IRR

Initial value = max(DI, HD) of the active appraisal.

Cashflow Yield line

Without an entry value: DI market value of the latest active appraisal.

Charges as % of the value

Value of the appraisal; they are recalculated at each validation.

Portfolio

Sum of the HD market values of the active appraisals at the chosen date.

Becoming the active appraisal

  • Creation: without workflow, a new appraisal becomes the active appraisal; with workflow, only the building's first appraisal is.

  • Without versioning: a validated (non-partial) appraisal becomes the active appraisal.

  • With versioning: validation does not remove the indicator from any other appraisal; it only takes it if the building has none. Otherwise, the user chooses with the radio button.

  • With the workflow, the radio button is only offered on a validated appraisal.

Choosing an appraisal elsewhere in Soneka

  • Entry value of the cashflow: in the building edit window, Initial cash-flow list (HD or DI values of the appraisals and of the acquisition). With versioning, the list offers the retained appraisals (not the working versions); the HD value only appears if it differs from the DI value.

  • Sale: frame Appraisal applicable to the sale, which lists the building's retained appraisals (not the working versions) and the one already linked to the sale. With the Appraisal price method, the HD sale price is taken from the selected appraisal. For a partial sale, the % of VNC allocated to the sale follows the appraisals ratio, unless a % is entered.

  • Valuation: the market value projection can start from a chosen appraisal.

With versioning: versions and statuses

With the preference versioningAppraisalYN, an appraisal contains working versions numbered V1, V2… Only one is retained: its figures are those of the appraisal, read by the indicators and the reports. The other versions remain viewable with their figures.

The sheet of an appraisal with versions

  • Identity banner: with the workflow, Initial appraisal as long as no version is validated, Retained appraisal afterwards; without workflow, always Retained appraisal; Version n for a version; date, appraiser, status badge, mention Being edited.

  • Key points: Expert, Scope (Total / Partial), Versions (number) and Validated version (Vn).

  • Field Version label: free text that names the version (for example “expert's initial version”, “manager's proposal”). It is entered in the edit screen.

  • Side panel Appraisal versions: timeline of the versions (title, label, date and expert, HD value, status badge, padlock if the version is locked; the mention No validated version under the label of the original appraisal as long as no version is validated, and Being entered under the open version), + button and ⋮ (Duplicate, Delete).

  • Block Submissions: history of the submissions (with the workflow).

The statuses

Status

Meaning

In progress

Working version; Being edited on the one that is open.

Submitted

Awaiting the approvers: nothing can be modified.

Validated

Retained version: its figures become those of the appraisal.

Rejected

Changes required or validation cancelled: the version is locked, duplicate it to start again.

The padlocks

  • “Submitted version, cannot be modified”.

  • “Validated version, cannot be modified”.

  • “Rejected version, duplicate it to start from a new version”.

  • “Validated appraisal, cancel the validation to reopen it”.

  • “Only the latest sub-version can be modified”.

With versioning: creating and deleting a version

Creating a version

  • On the sheet: + button of the Appraisal versions panel (tooltip “New version”), or ⋮ > Duplicate.

  • In the list: Duplicate button of the version.

  • The + does not ask for a label: it duplicates the displayed version, after the confirmation “Are you sure you want to duplicate this version?”.

  • The copy takes over the values, the methods and the rental assumptions of the copied version and takes the next number; posts, comments and submissions are not copied. Its label is entered in Version label.

Comments

With versioning, each version has its own comments. Without versioning, they belong to the appraisal.

Deleting a version

  • Trash icon of the version in the list, or menu ⋮ of the panel.

  • Only a non-validated version can be deleted, and only if more than one version remains.

  • Confirmation: “Are you sure you want to delete this version? This action is irreversible.”.

  • If the version is used elsewhere: Deletion impossible, you must first change the appraisal used by the listed items.

  • Numbers are not reassigned: deleting a version leaves a gap in the numbering (V1, V3…).

Appraisal used elsewhere

An appraisal is used elsewhere when one of its versions serves as the building's entry value (cashflow, IRR) or as the basis of a sale price with the Appraisal method. Soneka flags it at three moments:

Moment

What is displayed

Modification of the version in use

Orange banner “This appraisal is used by the following items. Your changes will modify their calculations”, with the list and a link to each item. Saving remains possible.

Creation of a version (without workflow)

Window Appraisal used elsewhere: the new version becomes the retained appraisal as soon as it is created. Buttons Continue without switching and Continue and switch.

Deletion of the version in use

Window Deletion impossible.

  • Continue and switch: the entry value and the sales move to the new version and follow its changes (sale price and projected IRR recalculated).

  • Continue without switching: the entry value and the sales stay on the previous version, with its figures.

  • Continue and switch is reserved for administrators and staff with edit permission on the module; other users only see Continue without switching.

  • No window appears when the appraisal is not used anywhere.

With versioning: retained version and comparison

The retained version

  • The validated version becomes the Retained appraisal: the sheet shows “Validated version: Vn”, the list “Vn validated”.

  • With the workflow, the original appraisal carries the label Initial appraisal as long as no version is validated; without workflow, it always carries the label Retained appraisal.

  • A validated Partial validated appraisal does not become the building's active appraisal.

  • Validation recalculates the charges expressed as a % of the value of the building.

  • The items that used the previous appraisal (entry value, sales) keep calculating with the figures of the previous version until they have been switched (see the workflow).

The comparator

  • At the bottom of the tab Appraisals: Manage comparator, tick at least two appraisals or versions, then Compare.

  • The maximum is three appraisals or versions: “Max 3 appraisals to be compared”; fewer than two: “Please select at least two appraisals”.

  • The Appraisal data change chart shows the HD value as bars and the cap rate as a line, one colour per appraiser.

  • Additional fields are included in the comparison.

The variance vs

On the sheet, the variance vs selector compares the displayed appraisal or version with any other version or appraisal of the building.

Key points

  • A version is created by duplication: it takes over the values of the copied version.

  • The validated version is the only one whose figures feed the appraisal.

  • The version label is free; numbering is automatic (V1, V2…).

  • A version used elsewhere cannot be deleted.

The validation workflow

Submitting and validating an appraisal or a version require the preference appraisalWorkflowYN. The process then depends on the building's approval matrix.

The sheet buttons

Button

Effect

Submit appraisal

The window shows the HD value, the appraisal date, the matrix and the calculated approvals number; the comment is optional (and so is the submission type if the setup offers one). The button is greyed out (“A version is already submitted for this appraisal”) if another version is submitted.

Approve appraisal

The approver of the current level approves. At the last level, the version is Validated. The window offers to specify a date.

Request changes

The window is titled “Request modifications” and its button “Reject”; it offers “Send back appraisal” (return level) when the matrix has several levels. The version becomes Rejected: it is duplicated to start again.

Cancel validation

With versioning, on a validated version: the version and the appraisal become Rejected. Offered to administrators and to approvers who approved the submission; without confirmation.

The four configurations

Configuration

How it works

Workflow, building linked to an Appraisal matrix

Submitting sets the version to Submitted; the approvers approve level by level or request changes. Only the latest version can be modified and submitted.

Workflow, building without an Appraisal matrix

Submitting validates immediately (“Calculated approvals number: 0”).

Workflow, without versioning

The appraisal itself is submitted then validated, with the buttons Submit appraisal, Approve appraisal and Request changes; on validation it becomes the active appraisal. There is no Cancel validation button, and no lock is placed on the validated appraisal. A rejected appraisal goes back to In progress and can be submitted again.

Without workflow, with versioning

No Submit: every appraisal and every version is Validated as soon as it is created. Each new version immediately becomes the retained appraisal and the previous one goes back to In progress. No lock: all versions remain editable.

Submission rules

  • With versioning: only one version can be submitted at a time.

  • With versioning: an already validated version cannot be resubmitted; cancel the validation then create a new version.

  • With versioning: a rejected version cannot be resubmitted; duplicate it.

  • A scenario or snapshot appraisal cannot be submitted.

Validating, rejecting and switching items

The approval matrix

The matrix of type Appraisal is configured in Admin > Approvals; the criterion of its rules is the Net value. The required number of approvals is calculated at submission.

The Submissions block

The Submissions block of the sheet keeps the history: submitted on, submitted by, status, validated or rejected on and by, comments, as well as the DI value, the gross yield, the used method and the scope at the time of submission.

Notifications

Submission and validation send an email to the author of the submission, to the following approvers and to the subscribers.

Switching the items that use the previous appraisal

After a validation with workflow, if items used the replaced appraisal (entry value, sales), the window Appraisal used elsewhere states: “This version replaces the appraisal used by the following items. They still calculate with the figures of the previous version”.

  • Keep the previous version: the items stay on the old version.

  • Switch to the new version: the items move to the validated version.

  • A user who is not an administrator reads: “Only an administrator can switch them to the new version.”

Key points

  • Without an Appraisal matrix, submission validates immediately.

  • With a matrix, each level approves or requests changes.

  • Only an administrator or staff can switch the items to the new version.

  • Validation recalculates the charges as a % of the building's value.

The appraisals consolidated view

The consolidated view displays in a single table the appraisals, and their versions, of a set of buildings. It is reserved for internal users with the permission to view the module appraisal_conso.

1. Top menu Consolidated view > Appraisals conso. (under Other when the menu is collapsed).

2. Fill in the building filters (same filters as the other consolidated views) then click Search. A banner of badges recalls the filters and reopens the panel.

The columns visible by default

Columns

Content

Building

Building and external ID of the building.

Type, Parent, Version, Version label

With versioning only: Appraisal or Sub-version, link to the parent appraisal, number and label of the version.

Identity

Appraisal date, appraisal type, expert.

State

In progress, Submitted, Validated, Rejected.

Values

Scope (Total / Partial), appraisal value HD and DI, cap rate, gross yield, used method.

Active

Green tick on the active appraisal.

Indicators

Rent excl. taxes and charges, total area, net value per m² used.

The table

  • Cogwheel: around sixty additional columns (contacts, currency, submission date, comments, values per method, rebates…) and the personal views or administrator views.

  • Eye icon View appraisal: opens the sheet. Bubble View comments: opens the comments window.

  • Excel export, filters and sorting by column; default sort by building, then most recent appraisal first (date of the retained appraisal), each appraisal followed by its versions by number.

  • Cells can be edited in the table by users who have edit permission on the module appraisal_conso.

  • Row Total filtered: sum of the HD and DI values, one sum per currency.

Submitting, validating and rejecting in bulk

The mass actions of the consolidated view require the preference appraisalWorkflowYN. Submit for validation requires a staff or administrator user with edit permission on the Appraisals module and on the conso; Validate and Reject are offered to any approver who has at least one selected row awaiting at their level. Selecting rows is mandatory.

Submit for validation

  • Tick the rows then click Submit for validation; confirmation “Submit N appraisal(s) for validation?”.

  • Limit: 50 appraisals at a time (“Submission limited to 50 appraisals at a time (N selected).”).

  • Each row follows the same rules as on the sheet and sends its own notification email.

  • For several versions of the same appraisal, only the latest is submitted.

  • A partial result is accepted: green message “N appraisal(s) submitted for validation.” and orange message “N appraisal(s) not submitted” with the reasons.

Validating or rejecting

  • Buttons Validate (green) and Reject (red), visible to an approver who has at least one row awaiting at their level.

  • Window Validate appraisals or Reject appraisals: the window asks “Validate N appraisal(s)?” or “Reject N appraisal(s) and request changes?” and, if selected rows are not awaiting at your level, warns: “N selected appraisal(s) are not awaiting your validation and will be ignored.” Comment and date are optional; limit of 50 appraisals.

  • Results: “N appraisal(s) validated” or “rejected”; “N approval(s) recorded, awaiting the next level”.

Switching the items

After a validation, the window Appraisals used elsewhere lists the items that still use the previous appraisal: Switch per row, Switch all, or Keep the previous versions.

Reasons for rejecting a row

Message

Cause

Only the latest version of this appraisal can be submitted

A more recent version exists.

Another sub-version of this appraisal is already submitted

Only one submission at a time per appraisal.

Version already validated, cancel the validation then create a new sub-version

Validated version.

Rejected version, duplicate it to start from a new version

Rejected version.

You do not have permissions on this appraisal

Missing permission.

Cannot submit the appraisal of a scenario or snapshot

Scenario or snapshot building.

You are not an approver of this appraisal at this level

Validate or Reject, wrong level.

The validation level has changed, reload the page

Concurrent validation.

Settings summary

These settings are made by the Soneka teams, at the client level.

Setting

Effect

versioningAppraisalYN

Preference, disabled by default. Enables versions: expandable list, redesigned sheet, Appraisal versions panel, version label, numbering, Type, Parent, Version and Version label columns in the conso.

appraisalWorkflowYN

Enables submission and validation (the building's Appraisal matrix), the Status column, edit locks with versioning and the consolidated view buttons. Without it: no Submit button, no lock.

appraisalConsoModuleYN

Preference, disabled by default. Enables the Appraisals conso. menu entry and the page.

Permission appraisal_conso

View the consolidated view (staff or administrator); editing its cells and acting in bulk also requires the edit permission.

Appraisal approval matrix

Admin > Approvals, criterion Net value. Without a matrix on the building: submission validates immediately.

Effect depending on the configuration

Versioning

Workflow

Result

No

No

Simple appraisals: list, sheet, active appraisal, comparator. No Status column, no Submit: an appraisal is validated as soon as it is created.

No

Yes

The appraisal is submitted and validated; on validation it becomes the active appraisal.

Yes

No

Each new version is immediately retained; no lock; “Appraisal used elsewhere” window at creation.

Yes

Yes

Versions locked by status; only the latest can be modified and submitted; validation through the matrix; switching of the items after validation.

Permissions

  • Edit or duplicate: staff with edit permission on the Appraisals module, or administrator.

  • Mass submission: staff or administrator with edit permission on Appraisals and on the conso; mass validation or rejection: approver with a row awaiting at their level.

  • An external expert can only modify a version while it is In progress.

  • Cancelling a validation: administrator, or approver who approved the submission, with versioning.

  • Switching the items that use the previous appraisal: administrator or staff.

  • Add an appraisal: hidden from external users and experts.

The fields of an appraisal

Correspondence between the screen labels and the technical fields of the appraisal (table Appraisal, except the rental assumptions). Useful for imports, interfaces and the table generator.

Label

Field

Appraisal date

date

Appraisal type

appraisalType

Appraisal reason

reason

Appraisal: Total / Partial

partialYN

Appraiser, Expert

company, contact

Appraiser 2, Expert 2

secondCompany, secondContact

Gross rent (excl. taxes and charges), Net rent, Rent-free periods

hthcRent, noi, franchise

Total area, vacant, weighted, land

totalArea, vacantArea, weightedArea, terrainArea

Occupation rate, Notary fees amount, gross and potential yields

(calculated)

Used method

valorisationMethod

Appraisal value (HD), Appraisal value including TT (DI) (“Market value” with the mention “Transfer costs included” at entry)

netValue, grossValue

Transfer tax (%), Empty value

transferFees, appraisalEmptyValue

Cap rate, Capitalized cashflow, Net value per capitalization

appraisalYield, capiFlow, capiValue

Discount rate, Exit yield, Net value per DCF

discountRate, dcfAppraisalYield, dcfValue

Occupation rebate, Bulk sale rebate

abatementOccupation, abatementBlocSale

Net value per comparison, Net value per m² used

comparaisonValue, comparaisonMetricValue

Primary, secondary, tertiary unit types (%)

primaryPart, secondaryPart, tertiaryPart

Active appraisal (radio button of the State column)

activeAppraisalYN

Version no., Version label, Status

versionNumber, label, state

Rental assumptions (table AppraisalDetail): Name → appraisalDetailsName, Unit type → appraisalDetailsType, Area → appraisalDetailsArea, ERV → appraisalDetailsRent, Metric ratio → appraisalDetailsMetricRatio, Rate → appraisalDetailsRate.