Exhibit_E-_Armored_Car_Bank_Deposits.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Excess Liability Insurance
- Solicitation number
- 2024-316
- Issued by
- Collin County, Texas
About this file
The document is an Excel spreadsheet titled "Exhibit E - Armored Car Bank Deposits" for Collin County, Texas, tracking monthly cash and check deposits for various county departments from May 2021 to April 2022. The spreadsheet captures deposit data for 15 different county departments and offices, including the Sheriff's Office, Tax Offices (Plano, McKinney, and Frisco), County Clerks, Constables, Justice of the Peace, Community Supervision and Corrections District (CSCD), and Treasury, showing detailed monthly cash and check deposit totals.
The data reveals significant financial activity across county departments, with the Tax offices in McKinney, Plano, and Frisco processing the largest monetary volumes. The Sheriff's Office deposited a total of $6,168,567.22 over the twelve-month period, while the Tax-McKinney office processed the highest total of $97,277,156.87. The spreadsheet provides a comprehensive view of the county's cash and check deposit patterns, which correlates with the county's concurrent excess liability insurance solicitation seeking coverage for various operational risks including law enforcement, armored car operations, and public official liabilities with self-insured retention levels ranging from $1,000,000 to $2,000,000 and coverage limits of $3,000,000 to $5,000,000.
View the file
Other files
Show all 37
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
sent 5-2022
| Exhibit E - Armored Car Bank Deposits | ||||||||||||||||||||||||||||||||||||||||
| Deposits picked up by Brinks | ||||||||||||||||||||||||||||||||||||||||
| May 2021-April 2022 | ||||||||||||||||||||||||||||||||||||||||
| 5/18/2022 | ||||||||||||||||||||||||||||||||||||||||
| May-21 | June-21 | July-21 | August-21 | September-21 | October-21 | November-21 | December-21 | January-22 | February-22 | March-22 | April-22 | |||||||||||||||||||||||||||||
| RDC | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | Cash | Check | Total | |
| Animal Services | no | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
| Constable 1 | no | 151.59 | 10,332.84 | 10,484.43 | 0.03 | 1,924.95 | 1,924.98 | 0.00 | 2,233.57 | 2,233.57 | 75.00 | 232,624.12 | 232,699.12 | 200.00 | 4,700.00 | 4,900.00 | 250.00 | 7,188.45 | 7,438.45 | 75.00 | 4,919.32 | 4,994.32 | 0.00 | 378,549.70 | 378,549.70 | 554.00 | 49,425.00 | 49,979.00 | 225.00 | 1,791.55 | 2,016.55 | 250.00 | 12,993.01 | 13,243.01 | 75.00 | 1,566.88 | 1,641.88 | 1,855.62 | 708,249.39 | 710,105.01 |
| Constable 3 | no | 1,776.49 | 537,950.42 | 539,726.91 | 300.00 | 6,348.00 | 6,648.00 | 4,213.93 | 7,736.50 | 11,950.43 | 994.00 | 372,931.86 | 373,925.86 | 225.00 | 8,950.00 | 9,175.00 | 525.00 | 7,680.05 | 8,205.05 | 450.00 | 10,291.65 | 10,741.65 | 181.25 | 5,225.00 | 5,406.25 | 1,902.43 | 339,003.66 | 340,906.09 | 759.50 | 16,212.29 | 16,971.79 | 523.25 | 8,053.33 | 8,576.58 | 359.50 | 10,323.40 | 10,682.90 | 12,210.35 | 1,330,706.16 | 1,342,916.51 |
| Constable 4 | no | 626.00 | 16,268.36 | 16,894.36 | 500.00 | 9,561.85 | 10,061.85 | 315.54 | 29,213.79 | 29,529.33 | 0.00 | 9,557.69 | 9,557.69 | 0.00 | 9,075.95 | 9,075.95 | 75.00 | 3,975.00 | 4,050.00 | 3,207.50 | 3,672.66 | 6,880.16 | 325.00 | 3,417.00 | 3,742.00 | 150.00 | 3,953.30 | 4,103.30 | 225.00 | 11,968.87 | 12,193.87 | 75.00 | 11,893.36 | 11,968.36 | 625.00 | 5,227.50 | 5,852.50 | 6,124.04 | 117,785.33 | 123,909.37 |
| County Clerk- Mckinney | yes | 18,739.50 | 203.00 | 18,942.50 | 20,713.50 | 1,265.00 | 21,978.50 | 19,024.50 | 1,918.00 | 20,942.50 | 21,961.67 | 338.50 | 22,300.17 | 18,532.50 | 370.00 | 18,902.50 | 16,662.00 | 99.00 | 16,761.00 | 17,782.00 | 1,134.50 | 18,916.50 | 17,369.50 | 200.00 | 17,569.50 | 16,774.50 | 205.50 | 16,980.00 | 14,506.00 | 146.00 | 14,652.00 | 20,395.00 | 1,140.00 | 21,535.00 | 18,337.50 | 256.56 | 18,594.06 | 220,798.17 | 7,276.06 | 228,074.23 |
| County Clerk- Plano | yes | 10,867.00 | 3,384.00 | 14,251.00 | 11,669.00 | 4,731.50 | 16,400.50 | 12,386.50 | 4,402.00 | 16,788.50 | 12,829.50 | 4,364.00 | 17,193.50 | 10,452.00 | 3,040.50 | 13,492.50 | 9,653.50 | 445.50 | 10,099.00 | 10,263.50 | 3,720.50 | 13,984.00 | 9,325.50 | 2,262.50 | 11,588.00 | 7,570.50 | 152.00 | 7,722.50 | 11,350.00 | 320.50 | 11,670.50 | 14,697.50 | 401.00 | 15,098.50 | 13,209.00 | 359.00 | 13,568.00 | 134,273.50 | 27,583.00 | 161,856.50 |
| CSCD-Mckinney (note 1) | yes | 21,782.95 | 37,677.28 | 59,460.23 | 17,443.00 | 42,063.45 | 59,506.45 | 26,935.42 | 81,970.96 | 108,906.38 | 20,367.67 | 35,799.00 | 56,166.67 | 31,064.38 | 185,293.57 | 216,357.95 | 16,436.25 | 54,245.00 | 70,681.25 | 22,786.74 | 121,049.76 | 143,836.50 | 25,575.49 | 90,409.28 | 115,984.77 | 24,592.45 | 35,952.35 | 60,544.80 | 20,769.00 | 52,335.83 | 73,104.83 | 39,255.87 | 43,645.50 | 82,901.37 | 29,266.31 | 27,588.11 | 56,854.42 | 296,275.53 | 808,030.09 | 1,104,305.62 |
| CSCD-Plano | no | 1,851.00 | 13,017.02 | 14,868.02 | 3,421.00 | 19,359.12 | 22,780.12 | 2,932.00 | 13,840.02 | 16,772.02 | 8,456.50 | 16,145.62 | 24,602.12 | 6,384.75 | 18,854.52 | 25,239.27 | 9,602.00 | 13,546.52 | 23,148.52 | 4,189.00 | 12,154.02 | 16,343.02 | 6,266.50 | 14,152.02 | 20,418.52 | 4,084.00 | 15,851.04 | 19,935.04 | 5,585.00 | 18,590.02 | 24,175.02 | 10,983.00 | 36,883.02 | 47,866.02 | 12,200.00 | 18,472.08 | 30,672.08 | 75,954.75 | 210,865.02 | 286,819.77 |
| Dev Svcs (note 2) | no | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
| District Clerk | yes | 15,896.40 | 0.00 | 15,896.40 | 19,677.41 | 0.00 | 19,677.41 | 16,152.50 | 0.00 | 16,152.50 | 12,589.20 | 0.00 | 12,589.20 | 0.00 | 15,125.16 | 0.00 | 15,125.16 | 16,500.82 | 0.00 | 16,500.82 | 0.00 | 17,812.60 | 0.00 | 17,812.60 | 11,353.38 | 0.00 | 11,353.38 | 23,816.53 | 0.00 | 23,816.53 | 16,828.10 | 0.00 | 16,828.10 | 165,752.10 | 0.00 | 165,752.10 | ||||
| Healthcare | no | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
| Justice of the Peace 1 | no | 2,611.10 | 2,649.00 | 5,260.10 | 4,394.00 | 6,239.58 | 10,633.58 | 2,763.50 | 1,879.00 | 4,642.50 | 3,712.00 | 3,476.30 | 7,188.30 | 4,015.00 | 14,951.25 | 18,966.25 | 4,975.00 | 2,843.00 | 7,818.00 | 6,685.00 | 12,919.00 | 19,604.00 | 5,042.00 | 903.00 | 5,945.00 | 4,702.00 | 4,626.13 | 9,328.13 | 4,031.00 | 4,558.00 | 8,589.00 | 5,445.00 | 9,662.50 | 15,107.50 | 4,441.00 | 4,473.34 | 8,914.34 | 52,816.60 | 69,180.10 | 121,996.70 |
| Justice of the Peace 3 | no | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||||||||||||||||
| Justice of the Peace 4 | no | 0.00 | 8,281.35 | 8,281.35 | 0.00 | 7,366.55 | 7,366.55 | 390.00 | 6,717.70 | 7,107.70 | 0.00 | 12,341.35 | 12,341.35 | 0.00 | 5,791.00 | 5,791.00 | 0.00 | 4,368.50 | 0.00 | 4,368.50 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4,758.50 | 40,497.95 | 45,256.45 | ||||||||||||
| Juv Probation-Plano | no | 127.00 | 475.00 | 602.00 | 175.00 | 1,289.01 | 1,464.01 | 550.00 | 1,493.32 | 2,043.32 | 480.00 | 4,833.72 | 5,313.72 | 715.00 | 2,620.00 | 3,335.00 | 248.00 | 200.00 | 448.00 | 615.00 | 735.00 | 1,350.00 | 713.45 | 0.00 | 713.45 | 585.00 | 3,865.00 | 4,450.00 | 623.88 | 1,616.46 | 2,240.34 | 285.00 | 1,827.06 | 2,112.06 | 280.00 | 200.00 | 480.00 | 5,397.33 | 19,154.57 | 24,551.90 |
| Myers Park | no | 3,320.00 | 11,235.00 | 14,555.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 555.00 | 7,440.00 | 7,995.00 | 980.00 | 13,170.00 | 14,150.00 | 3,020.00 | 22,445.00 | 25,465.00 | 5,020.00 | 22,515.00 | 27,535.00 | 1,486.00 | 36,608.00 | 38,094.00 | 4,592.00 | 13,610.00 | 18,202.00 | 18,973.00 | 127,023.00 | 145,996.00 | ||||||||||
| Sheriff's Office | no | 226,531.00 | 219,905.38 | 446,436.38 | 239,627.91 | 272,415.98 | 512,043.89 | 256,700.48 | 195,394.64 | 452,095.12 | 364,636.22 | 229,297.37 | 593,933.59 | 283,021.54 | 217,903.56 | 500,925.10 | 329,664.73 | 171,678.14 | 501,342.87 | 327,749.05 | 205,015.38 | 532,764.43 | 295,514.63 | 186,428.51 | 481,943.14 | 268,695.07 | 231,368.40 | 500,063.47 | 275,144.40 | 157,592.40 | 432,736.80 | 346,323.22 | 215,502.32 | 561,825.54 | 434,700.62 | 217,756.27 | 652,456.89 | 3,648,308.87 | 2,520,258.35 | 6,168,567.22 |
| Substance Abuse | no | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1,171.00 | 40.00 | 1,211.00 | 1,341.00 | 0.00 | 1,341.00 | 1,480.00 | 0.00 | 1,480.00 | 1,860.00 | 0.00 | 1,860.00 | 1,140.00 | 0.00 | 1,140.00 | 2,003.00 | 0.00 | 2,003.00 | 1,850.00 | 0.00 | 1,850.00 | 10,845.00 | 40.00 | 10,885.00 | ||||||||||
| Tax-Plano | yes | 494,430.10 | 2,290,492.78 | 2,784,922.88 | $609,611.60 | 1,630,765.37 | 2,240,376.97 | 540,579.36 | 2,095,240.80 | 2,635,820.16 | 521,545.24 | 2,415,510.55 | 2,937,055.79 | 504,904.81 | 2,202,156.68 | 2,707,061.49 | 663,075.29 | 1,729,749.00 | 2,392,824.29 | 1,177,964.69 | 1,347,125.03 | 2,525,089.72 | 2,427,619.55 | 1,450,202.85 | 3,877,822.40 | 3,993,298.89 | 1,493,393.51 | 5,486,692.40 | 636,910.06 | 1,379,598.23 | 2,016,508.29 | 893,267.35 | 1,752,347.57 | 2,645,614.92 | 461,082.28 | 1,239,852.85 | 1,700,935.13 | 12,924,289.22 | 21,026,435.22 | 33,950,724.44 |
| Tax-Mckinney | yes | 402,362.69 | 4,874,634.71 | 5,276,997.40 | 424,501.17 | 4,768,515.60 | 5,193,016.77 | 392,665.90 | 4,990,178.35 | 5,382,844.25 | 386,995.08 | 6,120,893.60 | 6,507,888.68 | 373,268.77 | 5,148,765.30 | 5,522,034.07 | 592,623.78 | 10,257,269.67 | 10,849,893.45 | 771,646.78 | 20,733,147.69 | 21,504,794.47 | 1,548,979.66 | 6,975,113.99 | 8,524,093.65 | 3,392,894.47 | 7,889,973.63 | 11,282,868.10 | 700,264.33 | 5,127,909.14 | 5,828,173.47 | 950,838.70 | 5,812,757.15 | 6,763,595.85 | 523,302.48 | 4,117,654.23 | 4,640,956.71 | 10,460,343.81 | 86,816,813.06 | 97,277,156.87 |
| Tax-Frisco | yes | 114,321.15 | 277,956.87 | 392,278.02 | 232,454.87 | 312,041.19 | 544,496.06 | 122,223.20 | 424,739.84 | 546,963.04 | 160,206.76 | 436,735.97 | 596,942.73 | 181,414.71 | 568,226.34 | 749,641.05 | 271,951.75 | 594,321.78 | 866,273.53 | 481,967.06 | 400,923.99 | 882,891.05 | 924,681.61 | 660,553.08 | 1,585,234.69 | 1,223,243.62 | 1,007,215.04 | 2,230,458.66 | 247,495.34 | 2,072,620.47 | 2,320,115.81 | 308,384.24 | 1,578,741.92 | 1,887,126.16 | 145,987.01 | 1,311,034.48 | 1,457,021.49 | 4,414,331.32 | 9,645,110.97 | 14,059,442.29 |
| Treasury | yes | 1,280.78 | 3,844.99 | 5,125.77 | 909.57 | 454.50 | 1,364.07 | 1,504.99 | 290.00 | 1,794.99 | 1,074.82 | 4,148.09 | 5,222.91 | 1,663.92 | 564.00 | 2,227.92 | 1,582.50 | 133.00 | 1,715.50 | 1,289.12 | 0.00 | 1,289.12 | 1,886.00 | 360.00 | 2,246.00 | 1,295.27 | 7,000.45 | 8,295.72 | 1,479.10 | 13,609.83 | 15,088.93 | 2,093.51 | 165.00 | 2,258.51 | 3,580.95 | 7,943.98 | 11,524.93 | 19,640.53 | 38,513.84 | 58,154.37 |
| 1,316,674.75 | 8,308,308.00 | 9,624,982.75 | 1,585,398.06 | 7,084,341.65 | 8,669,739.71 | 1,399,337.82 | 7,857,248.49 | 9,256,586.31 | 1,515,923.66 | 9,898,997.74 | 11,414,921.40 | 1,415,862.38 | 8,391,262.67 | 9,807,125.05 | 1,933,620.96 | 12,843,414.11 | 14,777,035.07 | 2,849,435.76 | 22,864,248.50 | 25,713,684.26 | 5,265,940.14 | 9,780,946.93 | 15,046,887.07 | 8,963,034.80 | 11,104,430.01 | 20,067,464.81 | 1,936,880.99 | 8,881,384.59 | 10,818,265.58 | 2,620,122.17 | 9,522,620.74 | 12,142,742.91 | 1,670,716.75 | 6,976,318.68 | 8,647,035.43 | 32,472,948.24 | 123,513,522.11 | 155,986,470.35 | ||
| 20.82% | 79.18% | |||||||||||||||||||||||||||||||||||||||
| note 1 | CSCD Mck also includes District Attorney, County Clerk (Cthse), and Minimum Security | |||||||||||||||||||||||||||||||||||||||
| note 2 | Dev Svcs also includes Fire Marshal and Juv Prob (Mck) | |||||||||||||||||||||||||||||||||||||||
| blank | no records remited from the dept | |||||||||||||||||||||||||||||||||||||||
| JP 3-1 & JP 3-2 combined 1/1/2021 |
File details come from the government source that posted it. Updated .