Export Service Charge Certificates

Exporting a service charge certificate enables you to review how much of the service charge expenses have been paid per schedule and how much of the sales invoices have been paid. You can then perform a reconciliation to print the corresponding invoices/credit notes. For instructions on performing a service charge reconciliation, click here.

From a Property Service Expenditure tab, select a budget and click Edit or double-click the budget to open it.

From the Budget Details window, click Export Certificates.

The service charge certificate exports with the Master Certificate as well as certificates for each tenant and/or landlord including any paid purchase and sales invoices.

Certificates

Master Certificate

Total expenditure for period = the total amount of purchase invoices raised against service charge nominals for the specified budget for all of the units combined

Reserve/Sinking funds = the total amount of reserves collected from all of the tenants and the landlord

Less received on account = the total amount received from all of the tenants and landlord payments combined

OUTSTANDING BALANCE = the total outstanding amount for all of the unpaid tenants and landlord invoices combined

Tenant Certificate without Reserves

Total attributable to unit = the total amount of purchase invoices raised against service charge nominals for the specified budget for this unit

Less received on account = the total amount received from this tenant

OUTSTANDING BALANCE = the total outstanding amount for this tenant

Note: The example below is for a budget with multiple period schedules; therefore, the top portion of the certificate also specifies which schedule date range this certificate is for. The tab below is for the first scheduled period, and the tab to the right of this tab is for the second scheduled period during this budget.

Certificates - 25-12-2018 to 24-12-20191262322242 - Microsoft Excel

Tenant Certificate with Reserves (full period)

Total attributable to unit = the total amount of purchase invoices raised against service charge nominals for the specified budget for this unit

Reserve/Sinking funds for lease = the total amount of reserves collected from this unit

Less received on account = the total amount received from this tenant

OUTSTANDING BALANCE = the total outstanding amount for this tenant

Certificates - 25-12-2018 to 24-12-20191997918475 - Microsoft Excel

Tenant Certificate with Reserves (partial period)

Total attributable to unit = the total amount of purchase invoices raised against service charge nominals for the specified budget for this unit

Total attributable to lease for period occupied = the total amount of purchase invoices raised against service charge nominals for the specified budget for this tenant

Reserve/Sinking funds for lease = the total amount of reserves collected from this unit

Reserve/Sinking funds for period occupied = the total amount of reserves collected from this tenant

Less received on account = the total amount received from this tenant

OUTSTANDING BALANCE = the total outstanding amount for this tenant

Certificates - 25-12-2016 to 24-12-2017619025015 - Microsoft Excel

Tenant Certificate with Reserves (and a cap)

Total attributable to unit = the total amount of purchase invoices raised against service charge nominals for the specified budget for this unit

Reserve/Sinking funds for period occupied = the total amount of reserves collected from this tenant

Reserve/Sinking funds for lease = the total amount of reserves collected from this unit

Reserve/Sinking funds for capped lease = the total amount of reserves collected from this tenant

Service Charge Cap [cap start date] - [cap end date] = the dates of the cap

Less received on account = the total amount received from this tenant

OUTSTANDING BALANCE = the total outstanding amount for this tenant

Certificates - 25-12-2016 to 24-12-2017619025015 - Microsoft Excel

Landlord Certificate

Total attributable to unit = the total amount of purchase invoices raised against service charge nominals for the specified budget for this unit

Reserve/Sinking funds for landlord = the total amount of reserves collected from the landlord for this unit

Less received on account = the total amount received from the landlord for this unit

OUTSTANDING BALANCE = the total outstanding amount for the landlord for this unit

Certificates - 25-12-2016 to 24-12-20171563532518 - Microsoft Excel

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.