| Percentage of receivables that are current at the end of each month.FMS-Financial Mgmt Services |
Measure Definition & Importance |
The purpose of this Key Performance Indicator ("KPI") is to measure the effectiveness of the City's ability to collect on amounts due. An effective collections process is vital to ensuring the City receives the revenue that is due in order to fund critical operations.
Analysis | |
Percentage of receivables that are current at the end of each month. |
Service Areas |
-
FMS.1.2 Treasury
FMS-Financial Mgmt Services
Attachments |
Measure Data | Last Calculated 11 days ago |
| Period |  | Status | % of receivables current | $ value of invoices not yet due | Total $ value of recievables | Overall Target | High Variance (FY Target) | Low Variance |
|---|---|---|---|---|---|---|---|---|
| Oct-18 | | Insufficient Progress | 38.02% | $ 735,433.06 | $ 1,934,469.73 | 85.00 | 85.00 | 70.00 |
| Nov-18 | | Insufficient Progress | 23.93% | $ 398,827.98 | $ 1,666,467.59 | 85.00 | 85.00 | 70.00 |
| Dec-18 | | Insufficient Progress | 66.04% | $ 770,469.68 | $ 1,166,623.40 | 85.00 | 85.00 | 70.00 |
| Jan-19 | | Insufficient Progress | 48.51% | $ 393,347.02 | $ 810,885.39 | 85.00 | 85.00 | 70.00 |
| Feb-19 | | Insufficient Progress | 49.65% | $ 433,427.45 | $ 872,933.77 | 85.00 | 85.00 | 70.00 |
| Mar-19 | | Insufficient Progress | 53.09% | $ 419,018.59 | $ 789,300.01 | 85.00 | 85.00 | 70.00 |
| Apr-19 | | Insufficient Progress | 65.08% | $ 2,476,102.09 | $ 3,804,750.77 | 85.00 | 85.00 | 70.00 |
| May-19 | | Insufficient Progress | 37.26% | $ 340,075.93 | $ 912,776.90 | 85.00 | 85.00 | 70.00 |
| Jun-19 | | Insufficient Progress | 53.46% | $ 822,391.51 | $ 1,538,400.12 | 85.00 | 85.00 | 70.00 |
| Jul-19 | | Insufficient Progress | 27.30% | $ 548,342.83 | $ 2,008,496.65 | 85.00 | 85.00 | 70.00 |
| Aug-19 | | Insufficient Progress | 30.57% | $ 307,018.47 | $ 1,004,308.08 | 85.00 | 85.00 | 70.00 |
| Sep-19 | | Insufficient Progress | 43.96% | $ 499,682.84 | $ 1,136,796.92 | 85.00 | 85.00 | 70.00 |
| Oct-19 | | Lagging | 78.46% | $ 2,143,004.80 | $ 2,731,274.62 | 85.00 | 85.00 | 70.00 |
| Nov-19 | | Insufficient Progress | 29.03% | $ 653,181.50 | $ 2,250,368.05 | 85.00 | 85.00 | 70.00 |
| Dec-19 | | Insufficient Progress | 33.97% | $ 693,767.84 | $ 2,042,304.85 | 85.00 | 85.00 | 70.00 |
| Jan-20 | | Insufficient Progress | 53.07% | $ 1,290,969.70 | $ 2,432,396.00 | 85.00 | 85.00 | 70.00 |
| Feb-20 | | Insufficient Progress | 53.21% | $ 1,415,986.00 | $ 2,661,316.00 | 85.00 | 85.00 | 70.00 |
| Mar-20 | | Insufficient Progress | 15.49% | $ 443,675.00 | $ 2,864,689.00 | 85.00 | 85.00 | 70.00 |
| Apr-20 | | Insufficient Progress | 41.80% | $ 788,444.47 | $ 1,886,409.38 | 85.00 | 85.00 | 70.00 |
| May-20 |  | Monitoring/No Info | 85.00 | 85.00 | 70.00 | |||
| Jun-20 | | Insufficient Progress | 67.53% | $ 1,558,244.00 | $ 2,307,383.00 | 85.00 | 85.00 | 70.00 |
| Jul-20 | | Insufficient Progress | 50.66% | $ 1,057,913.01 | $ 2,088,285.21 | 85.00 | 85.00 | 70.00 |
| Aug-20 | | Insufficient Progress | 52.91% | $ 1,148,726.34 | $ 2,170,935.71 | 85.00 | 85.00 | 70.00 |
| Sep-20 |  | On Target | 87.58% | $ 4,896,560.20 | $ 5,590,962.79 | 85.00 | 85.00 | 70.00 |
| Oct-20 | | Insufficient Progress | 39.61% | $ 2,709,428.00 | $ 6,840,799.00 | 85.00 | 85.00 | 70.00 |
| Nov-20 | | Insufficient Progress | 47.83% | $ 4,071,354.97 | $ 8,512,548.65 | 85.00 | 85.00 | 70.00 |
| Dec-20 | | Insufficient Progress | 22.55% | $ 1,572,205.09 | $ 6,971,711.59 | 85.00 | 85.00 | 70.00 |
| Jan-21 | | Insufficient Progress | 20.50% | $ 1,303,068.18 | $ 6,355,588.63 | 85.00 | 85.00 | 70.00 |
| Feb-21 | | Insufficient Progress | 24.89% | $ 1,622,028.38 | $ 6,517,955.30 | 85.00 | 85.00 | 70.00 |
| Mar-21 | | Insufficient Progress | 36.34% | $ 2,711,524.54 | $ 7,462,383.87 | 85.00 | 85.00 | 70.00 |
| Apr-21 | | Insufficient Progress | 26.64% | $ 1,739,859.43 | $ 6,532,093.16 | 85.00 | 85.00 | 70.00 |
| May-21 | | Insufficient Progress | 23.94% | $ 1,343,689.81 | $ 5,613,270.76 | 85.00 | 85.00 | 70.00 |
| Jun-21 | | Insufficient Progress | 14.94% | $ 830,110.29 | $ 5,555,398.33 | 85.00 | 85.00 | 70.00 |
| Jul-21 | | Insufficient Progress | 9.91% | $ 562,941.12 | $ 5,682,389.45 | 85.00 | 85.00 | 70.00 |
| Aug-21 | | Insufficient Progress | 11.92% | $ 669,669.71 | $ 5,616,707.57 | 85.00 | 85.00 | 70.00 |
| Sep-21 | | Insufficient Progress | 0.61% | $ 34,389.42 | $ 5,628,941.94 | 85.00 | 85.00 | 70.00 |
| Oct-21 | | Insufficient Progress | 12.37% | $ 860,113.66 | $ 6,952,280.07 | 85.00 | 85.00 | 70.00 |
| Nov-21 | | Monitoring/No Info | 85.00 | 85.00 | 70.00 | |||
| Dec-21 | | Monitoring/No Info | 85.00 | 85.00 | 70.00 | |||
| Jan-22 | | Monitoring/No Info | ||||||
| Feb-22 | | Monitoring/No Info | ||||||
| Mar-22 | | Monitoring/No Info | ||||||
| Apr-22 | | Monitoring/No Info | ||||||
| May-22 | | Monitoring/No Info | ||||||
| Jun-22 | | Monitoring/No Info | ||||||
| Jul-22 | | Monitoring/No Info | ||||||
| Aug-22 | | Monitoring/No Info | ||||||
| Sep-22 | | Monitoring/No Info |
Data Source Details & Calculation Information |
This measure will be reported in terms of the dollar value of receivables. This data is obtained from the Z_AR_ITEM_DETAILS_ASOF_DATE query. This measure will be limited to the receivables billed and managed in the People Soft AR system excluding Tax Increment Financing Districts. This KPI will be reported one month in arrears.
(Dollar Value of Invoices that are Not Yet Due / Total Dollar Value of Receivables )*100
Performance Liaison |
| CH | Crystal Hinojosa (FMS - Financial Management services) |
Is this measure a KPI? |
Measure Type |
Data Owner |
Measure ID |
714540
Target Type |
Performance Liaison Notes |
Administrator Notes |