SCORECARD: 12-month Rolling Status

FMS-Financial Mgmt Services
Divisions Service Areas Measures Reporting Frequency Series Name Series Status Analysis
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21
1. Operational & Transactional
On Target
FMS.1.1 Accounting
Monitoring/No Info
Percent of Capital Asset fund reviews for prior month completed by the 25th day of current month (Reported in Arrears)
Monthly-FY
% of fund reviews completed on time
0%
0%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
Total fund reviews completed on time
0.00
0.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
Total fund reviews
141.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
141.00
On Target
Percent of M&C entries completed within 7 business days of Council meeting in which it was approved
Monthly-FY
% of M&C entries completed on time
100.00%
100.00%
100.00%
100.00%
100.00%
91.67%
92.31%
100.00%
100.00%
100.00%
100.00%
100.00%
# of M&C entries completed on time
9.00
4.00
20.00
18.00
3.00
11.00
12.00
8.00
35.00
0.00
23.00
14.00
Total # of M&C Entries
9.00
4.00
20.00
18.00
3.00
12.00
13.00
8.00
35.00
0.00
23.00
14.00
Monitoring/No Info
Percent of journal entries approved/denied/posted within 3 days of submittal
Monthly-FY
% approved/denied/posted on time
90.40%
91.96%
95.10%
94.68%
95.59%
94.82%
93.93%
97.24%
94.05%
95.15%
89.41%
# approved/denied/posted in 3 days
113.00
263.00
408.00
409.00
499.00
622.00
480.00
529.00
617.00
608.00
515.00
total # journals submitted
125.00
286.00
429.00
432.00
522.00
656.00
511.00
544.00
656.00
639.00
576.00
Lagging
FMS.1.2 Treasury
On Target
Investment portfolios to provide returns in excess of 0.10% of the benchmark (original)
Monthly-FY
Active Return
0.13%
0.08%
0.08%
0.12%
0.20%
0.20%
0.19%
0.19%
0.17%
0.13%
0.14%
0.17%
City Yield
0.27%
0.24%
0.21%
0.23%
0.34%
0.36%
0.35%
0.33%
0.42%
0.32%
0.34%
0.45%
Portfolio Book
$ 845,680,876.30
$ 859,705,762.22
$ 863,294,942.73
$ 863,189,277.58
$ 873,678,657.26
$ 883,365,924.16
$ 883,262,824.49
$ 858,687,925.45
$ 858,651,153.89
$ 858,534,931.64
$ 858,414,787.15
$ 873,067,545.05
Monthly $ Impact
$ 88,796.49
$ 58,388.35
$ 58,991.82
$ 84,160.95
$ 142,700.85
$ 146,123.45
$ 137,273.76
$ 137,390.07
$ 121,642.25
$ 94,081.12
$ 100,148.39
$ 121,138.12
Insufficient Progress
Percent of invoices paid within 30 days from the invoice date.
Monthly-FY
% of invoices paid within 30 days
80.57%
85.43%
79.66%
71.34%
79.60%
82.28%
84.48%
81.88%
80.89%
82.56%
79.85%
73.04%
# of invoices paid within 30 days
4,496.00
4,234.00
4,906.00
4,366.00
3,769.00
4,903.00
5,013.00
4,920.00
5,188.00
5,155.00
4,196.00
5,608.00
Total # of invoices
5,580.00
4,956.00
6,159.00
6,120.00
4,735.00
5,959.00
5,934.00
6,009.00
6,414.00
6,244.00
5,255.00
7,678.00
Insufficient Progress
Percentage of receivables that are current at the end of each month.
Monthly-FY
% of receivables current
39.61%
47.83%
22.55%
20.50%
24.89%
36.34%
26.64%
23.94%
14.94%
9.91%
11.92%
0.61%
$ value of invoices not yet due
$ 2,709,428.00
$ 4,071,354.97
$ 1,572,205.09
$ 1,303,068.18
$ 1,622,028.38
$ 2,711,524.54
$ 1,739,859.43
$ 1,343,689.81
$ 830,110.29
$ 562,941.12
$ 669,669.71
$ 34,389.42
Total $ value of recievables
$ 6,840,799.00
$ 8,512,548.65
$ 6,971,711.59
$ 6,355,588.63
$ 6,517,955.30
$ 7,462,383.87
$ 6,532,093.16
$ 5,613,270.76
$ 5,555,398.33
$ 5,682,389.45
$ 5,616,707.57
$ 5,628,941.94
On Target
FMS.1.3 PIDs
Monitoring/No Info
Percent of monthly reimbursements processed within 15 days
Monthly-FY
% of reimbursements processed within 15 days
# of reimbursements processed on time
# of reimbursements processed
On Target
FMS.1.4 Customer Satisfaction & Support
Monitoring/No Info
Average # of days to close helpdesk tickets (department wide)
Monthly-FY
Average # of days to close helpdesk tickets
# of days open
# of helpdesk tickets
On Target
FMS.1.5 Purchasing
Insufficient Progress
Complete award of new or replacement bids before the current contract agreement expires
Quarterly-FY
Bids Awarded
 
 
89.00
 
 
29.00
 
 
29.00
 
 
68.00
Overall Target
 
 
100.00
 
 
100.00
 
 
100.00
 
 
100.00
High Variance (FY Target)
 
 
85.00
 
 
85.00
 
 
85.00
 
 
85.00
Low Variance
 
 
80.00
 
 
80.00
 
 
80.00
 
 
80.00
Lagging
Complete PeopleSoft contract from City Secretary Contract within 3 business days.
Monthly-FY
Completed Peoplesoft contracts within 3 days
2.00
5.42
6.39
5.50
6.58
6.80
6.61
5.88
7.58
6.30
10.30
5.00
Overall Target
High Variance (FY Target)
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
Low Variance
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
On Target
Reduce the number of expedited requests for Purchasing M&Cs.
Monthly-FY
% of expedited requests
8.00%
25.00%
13.00%
20.00%
0%
20.00%
14.00%
0%
44.00%
0%
17.00%
26.00%
Overall Target
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
High Variance (FY Target)
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
Low Variance
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
Monitoring/No Info
Complete PeopleSoft contract renewals before current agreement expires
Monthly-FY
% Peoplesoft contracts renewed
100.00%
90.00%
85.00%
96.00%
98.00%
95.00%
92.00%
84.00%
Overall Target
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
100.00
High Variance (FY Target)
85.00
85.00
85.00
85.00
85.00
85.00
85.00
85.00
85.00
85.00
85.00
85.00
Low Variance
80.00
80.00
80.00
80.00
80.00
80.00
80.00
80.00
80.00
80.00
80.00
80.00
On Target
FMS.1.6 Vendor Management
On Target
Review all bidder and user requests within 5 business days
Monthly-FY
Bidder and user requests reviewed in 5 days
2.00
2.50
2.00
2.00
2.50
2.00
2.50
2.00
2.50
2.00
2.00
2.50
Overall Target
High Variance (FY Target)
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
3.00
Low Variance
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
5.00
On Target
Complete Assignment of Contract and Name Change requests within 60 days.
Monthly-FY
Completed assignments of contracts and name change
1.00
8.07
11.40
11.40
6.00
8.00
7.00
4.30
10.50
3.50
3.70
3.00
Overall Target
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
30.00
High Variance (FY Target)
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
50.00
Low Variance
60.00
60.00
60.00
60.00
60.00
60.00
60.00
60.00
60.00
60.00
60.00
60.00
2. Regulatory/Reporting
On Target
FMS.2.1 External Audit
Not Defined
Number of external audit findings (Citywide)
Annual-FY
Number of external audit findings
 
 
 
 
 
 
 
 
 
 
 
Not Defined
Number of external audit findings (Component Unit/Other)
Annual-FY
External audit findings (component unit/other)
 
 
 
 
 
 
 
 
 
 
 
Not Defined
FMS.2.2 Compliance
Not Defined
# of days to produce the CAFR
Annual-FY
# of days to produce the CAFR
 
 
 
 
 
 
 
 
 
 
 
Not Defined
Percent of funds compliant with reserve policy
Annual-FY
% of funds in compliance
 
 
 
 
 
 
 
 
 
 
 
# of funds in reserve compliance
 
 
 
 
 
 
 
 
 
 
 
# of funds
 
 
 
 
 
 
 
 
 
 
 
Monitoring/No Info
FMS.2.3 Ratings
Not Defined
GFOA award for CAFR
Annual-FY
Actual
 
 
 
 
 
 
 
 
 
 
 
Not Defined
Bond Ratings-General Obligation
Annual-FY
Moody's
 
 
 
 
 
 
 
 
 
 
 
S&P
 
 
 
 
 
 
 
 
 
 
 
Fitch
 
 
 
 
 
 
 
 
 
 
 
Kroll
 
 
 
 
 
 
 
 
 
 
 
Not Defined
Bond Ratings-Special Tax
Annual-FY
Moody's
 
 
 
 
 
 
 
 
 
 
 
Fitch
 
 
 
 
 
 
 
 
 
 
 
S&P
 
 
 
 
 
 
 
 
 
 
 
Kroll
 
 
 
 
 
 
 
 
 
 
 
Not Defined
Bond Ratings-Stormwater/ Drainage
Annual-FY
Standard & Poor's
 
 
 
 
 
 
 
 
 
 
 
Fitch
 
 
 
 
 
 
 
 
 
 
 
Not Defined
Bond Ratings-Water/Sewer
Annual-FY
Moody's
 
 
 
 
 
 
 
 
 
 
 
Standard & Poor's
 
 
 
 
 
 
 
 
 
 
 
Fitch