The procedure to export the calculated service charge cost element results is as follows:
- Navigate to Quick Menu > Service Charges > Management > Calculations. The Service Charge Calculation window is displayed.
- Expand a calculation type subheading from within the nested calendar period and select an associated calculation scenario, or enter its name into the Search Calculations field. By default the list is filtered to show All calculation scenarios. An alternative filter can be applied using the Select view drop-down field: In Progress, Under Consultation, Applied, Invoiced, Cancelled or Adjustment Applied to Rent Accounts
1.
- Click on Cost Element Results. The Cost Element Results tab is activated, revealing the proposed service charge values in the Cost Element Results summary table, specific to the calculation type in operation.
- Optionally, where a Model calculation method is in operation, select an alternative model from the corresponding field, in which uplift parameters have been calculated for the elemental components 2.
- Click on Export Results 3. The service charge cost element calculations are exported to an output file, ready for analysis and manipulation.
- Click on Open to view the exported data instantly, or Save to store the file in a custom folder for subsequent retrieval 4.
Note
1 The Search Calculations field will match against any component of the calculation scenario description.
2 For Manual and Import calculation methods, the proposed service charge values are displayed instantly, using the manually input or imported figures.
3 Prior to cascading the cost element results to the relevant asset records, there is no limit to the number of times that a calculation scenario export file can be generated.
4 The standard file format is CSV (Comma Separated Variable), which can be opened up directly in Microsoft Excel, or similar.
See related topics...
Data export management overview
To export the calculated service charges for asset records
Service charge results management overview
