01. Configuration steps/data input MXTS

Owned by Carin van de Velde
Last updated: Jan 03, 2023 by Jochem Hazelaar
3 min read

Before the Energy settlement can be started, some configuration has to be checked/added and data has to be given in:

Step 1: Year round reservation

A Year round reservation should have been created on the object for which the energy settlement has to be done. Energy invoices will be added as sub-reservations (sub-reservations are not visible yet in MXTS) of the Year round reservations and won't be created without having the parent reservation available.

A Year round reservation usually has arrival date 01-01 and departure date 31-12 of a certain year, only when an object is sold during the year, there could be more than one reservation per year.

The status of the Year round (parent) reservation has to be Checked-in to be able to be found during the energy settling process.

The Reservation category used for the Year round reservation needs to have the check box "eligible for energy bill" selected.

Example:

  • Unit = 8p. Villa de Zomertaling nr. 104
  • Arrival =   
  • Departure =  
  • Customer = Owner of the property
  • Status = Checked-in
  • Reservation category = Factuur (eligible for energy bill)

Step 2: Invoice extra's

Per Utility an extra should be created with the valid rates for calculation of the charges.

The charges will be calculated by rate x unit. So when the meter reading for energy will be kWh, the rate should be the price per kWh.

The checkbox "invoice article" should be selected to be able to see the extra's as invoice article in the sub-reservation.

Besides, for the extra to be picked up by the energy settlement, it is important that the rentability rule of the add-on does NOT have an end book date

 

Step 3: Link invoice extra's to Utility bill

In Accommodations types on the tab Utility bill, the configured extra's with the right rates should be linked to the specific Utility types.

The configuration can be done on the highest level, as long as all extra's used for calculation should be the same for the underlying types and units.

The Utility types:

  • Electricity
  • Gas
  • Water

will be used for the calculation per unit based on the meter readings given in on Meter reading tab.

The Utility types:

  • Admincostenergy
  • Admincostgas
  • Admincostwater

will be used for fixed costs.

The Utility type:

  • Admincost

will be used for deposit settlement in combination with an extra where the checkbox "Adjustment invoice extra" has been selected. =>  "Adjustment invoice extra" not available in MXTS yet

The Utility type:

  • Cleansing (Reiniging)

will be used for charging a deposit in combination with an extra where the checkbox "Energy invoice extra" has been selected.

Step 4: Add meter readings

In Accommodations on the tab Energy, the meter readings have to be added.

To be ready to get started, the start value has to be added and marked as start value. Next to that, the checkbox for IsSettled needs to be YES for the start value. Otherwise, it might be that the consumption is not calculated correctly later on.

At the end of a settling period, the actual values have to be added. 

It's also possible to add meter readings on accommodation type level. When a list of meter readings is available, this will work much faster:

  • fill all readings per unit
  • calculate usage, based on the last value which can be found on accommodation level
  • store new readings. After this, the new values are visible on the accommodation energy tab.