ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Monthly property maintenance report
2
Enter period movement counts from your records. Keep an independent closing count for reconciliation.
3
4
Reporting period / property
5
6
Opening backlogCounts are movements during the period: opening backlog + new + reopened - completed - cancelled = closing backlog. Reopened requests add to the active queue. A later completion is another removal. Use consistent event records.
7
New requests
8
Reopened requests
9
Completed requests
10
Cancelled requests
11
12
Calculated closing backlogReconciliation difference = independently counted closing backlog - calculated closing backlog. Investigate any nonzero result. Completion share = completed / (opening + new + reopened); it is not an SLA or satisfaction score.
13
Independent closing count
14
Reconciliation difference
15
16
Completion share
17
18
Planned spending
19
Actual spending
20
Spending variance
21
22
23
Outstanding decisions / approver / due date
24
25
26
27
28
29
Recurring issues and supporting references
30
31
32
33
34
35
Next actions / responsible person / next update
36
37
38
39
40
41
42
43
44
Light blue: input. Gray: formula.
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100