Report – Monthly breakdown of the balance of active rents

📊 Monthly transaction summary

The Monthly Transaction Summary report lets you obtain an overall view of active rents for a given period.

The information is presented by property and by unit, with a total by building.

🧾 Report variables

🏠 Unit

Corresponds to the rental unit associated with the rent.

🛏️ Rooms

Indicates the number of rooms in the unit.

💰 Opening balance

The opening balance represents the amount due by the tenant at the beginning of the selected month.

• Past month: based on the amounts billed and the payments collected
• Current month: corresponds to the unpaid amounts from previous months
• Future month: represents the amounts that remain to be collected

🏚️ Vacancy

The vacancy amount represents the estimated income lost when a unit is unoccupied.

This amount is based on the suggested price set up in the unit record.

👉 This is an estimate, not an amount actually billed.

💵 Rents

The Rents column represents the rent amount, with a different logic depending on the period:

• Past month: displays the base rent only
• • Discounts, services, and taxes are displayed separately
• Future month: displays an estimated total amount
• • Includes rents, discounts, services, and taxes
  • The amounts are not broken down

💸 Discounts

Represents the amounts deducted from the rent.

👉 Corresponds to services set up with a negative amount

Examples:

• monthly discount

🛠️ Services

Represents the additional fees related to the unit.

Examples:

• parking
• appliances

👉 Only positive amounts are displayed.

🧾 GST / QST (Taxes)

Taxes are displayed only if:

• taxes are set up in the unit record
• and an invoice has been generated

👉 They reflect the taxes actually applied.

💳 Rent collected

Rent collected represents the amount actually received during the selected month.

👉 Based on the payment date, regardless of the rent month.

May include:

• late payments
• payments in advance

❌ Failed PAD

Represents the amounts associated with failed pre-authorized payments (PAD).

👉 Lets you quickly identify the payments that could not be collected.

📊 Closing balance

The closing balance represents the amount due by the tenant at the end of the month.

👉 The opening balance is added to the amounts of the month, then the payments received reduce this total.

📅 Start and end

The Start and End fields correspond to the dates of the rent period.

👉 A period can represent:

• a lease
• a renewal

💰 Deposit

Represents the security deposit associated with the period.

👉 Displayed only in the period where it was added.

• Not carried forward into the following periods
• For the complete history, consult the security deposits report

Updated on: 13/11/2026