LCSA_Over_the_Counter_Payments_FFY_2014-2015.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Kiosk Payment Services IFB #261
Solicitation number
0000000845
Issued by
California

About this file

This is a financial tracking spreadsheet showing Over the Counter (OTC) collections data for Local Child Support Agencies (LCSAs) across California counties for federal fiscal years 2012-2013, 2013-2014, and 2014-2015. The document tracks payment collections across three payment methods: checks, cash, and money orders, detailing both the count of transactions and dollar amounts for each county. The data shows significant collection activity across California's 58 counties, with total OTC collections reaching approximately $63.6 million in FY 2014-2015.

The collections data shows varying levels of activity across counties, with larger jurisdictions like Los Angeles, Orange, and San Bernardino showing the highest collection volumes. Notable payment methods beyond traditional OTC collections included MoneyGram ($3.6M), TouchPay ($4.7M), and PayNearMe ($175K) in FY 2014-2015. The document also includes county caseload data for FY 2014-2015, showing the relationship between county size and collection volumes, with Los Angeles having the largest caseload at 301,016 cases.

View the file

Other files

File Type Posted
FINAL_IFB___261-_Q___As.docx DOCX document
FINAL_IFB__261-Kiosk_-ADDENDUM.pdf PDF
IFB__261-Kiosk_.doc DOC document

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

2012.2013

Over the Counter LCSA Collections Federal Fiscal Year 2012-2013
LCSACheckCashMoney Order
CountAmountCountAmountCountAmount
Alameda- 0$0.001,214$390,641.02- 0$0.00
Alpine- 0$0.00- 0$0.00- 0$0.00
Amador58$33,775.19545$78,542.1534$6,530.20
Butte144$64,104.632,710$335,748.27154$25,885.29
Calaveras- 0$0.00- 0$0.00- 0$0.00
Colusa8$4,330.00155$46,866.811$200.00
Contra Costa338$635,973.451,390$384,222.90158$38,535.00
Del Norte117$71,316.571,073$146,590.1325$16,066.00
El Dorado455$249,992.082,477$394,166.0685$14,142.55
Fresno- 0$0.00- 0$0.00- 0$0.00
Glenn21$9,546.56- 0$0.008$716.00
Humboldt214$124,319.441,566$386,947.5149$17,079.59
Imperial153$95,516.742,323$472,842.0546$14,940.64
Inyo88$34,216.63415$89,744.2924$5,062.05
Kern- 0$0.009,286$2,097,911.97- 0$0.00
Kings- 0$0.001,892$270,674.38- 0$0.00
Lake51$25,065.66589$132,423.8862$13,544.61
Lassen25$12,523.36175$19,641.0018$2,260.00
Los Angeles1,549$1,059,115.8439,926$9,758,316.62492$287,854.39
Madera- 0$0.002,269$435,289.85- 0$0.00
Marin152$235,244.431,313$425,168.1661$19,498.09
Mariposa- 0$0.00- 0$0.00- 0$0.00
Mendocino- 0$0.001,397$291,367.42- 0$0.00
Merced- 0$0.005,003$763,262.39- 0$0.00
Modoc- 0$0.00- 0$0.00- 0$0.00
Mono- 0$0.00- 0$0.00- 0$0.00
Montery295$264,332.915,444$1,343,947.44126$52,989.70
Napa210$166,039.001,990$467,888.9251$15,445.81
Nevada98$40,628.85736$129,721.1754$6,741.20
Orange5,761$3,788,683.4622,325$6,144,216.271,031$246,698.85
Placer70$66,167.07857$247,097.1779$102,831.40
Plumas12$10,016.62131$20,750.0212$8,002.29
Riverside6$32,944.0714,651$3,764,478.7727$67,015.04
Sacramento1,117$1,323,073.2912,451$2,673,841.94811$123,845.41
San Benito- 0$0.00398$58,925.99- 0$0.00
San Bernardino1,769$1,303,396.4117,647$3,310,467.94673$209,578.91
San Diego759$505,910.8810,924$2,786,172.33448$519,189.05
San Francisco- 0$0.005,096$1,202,174.17- 0$0.00
San Joaquin584$399,933.665,983$1,289,964.35274$56,210.49
San Luis Obispo- 0$0.00825$205,304.21- 0$0.00
San Mateo10$38,991.204,125$1,412,696.1148$24,262.88
Santa Barbara- 0$0.003,379$817,337.77- 0$0.00
Santa Clara- 0$0.00- 0$0.00- 0$0.00
Santa Cruz20$36,317.621,496$289,865.8949$12,691.97
Shasta302$198,888.372,756$430,724.3860$15,619.40
Sierra- 0$0.00- 0$0.00- 0$0.00
Siskiyou- 0$0.00447$39,917.643$0.00
Solano12$114,048.6976$21,342.0033$9,343.94
Sonoma453$441,053.873,916$895,598.17295$54,424.08
Stanislaus448$329,323.435,444$1,020,131.01249$125,096.93
Sutter2$16,650.00212$50,477.021$482.64
Tehama57$66,032.39419$62,098.6580$10,056.92
Trinity31$31,190.1189$8,757.6052$3,237.56
Tulare- 0$0.006,118$1,114,766.32- 0$0.00
Tuolumne1$50.00547$76,268.77- 0$0.00
Ventura573$657,574.275,141$1,222,652.94233$60,946.18
Yolo263$155,336.171,375$242,869.23113$40,783.15
Yuba- 0$0.00655$83,851.2978$11,554.12
OTC Totals16,226$12,641,622.92211,371$48,354,672.346,097$2,239,362.33

2013.2014

Over the Counter LCSA Collections Federal Fiscal Year 2013-2014
LCSACheckCashMoney Order
CountAmountCountAmountCountAmount
Alameda- 0$0.001,557$470,298.17- 0$0.00
Alpine- 0$0.001$100.002$330.00
Amador31$23,996.91486$51,208.2530$4,553.92
Butte136$122,547.142,595$318,774.13105$12,434.78
Calaveras- 0$0.00- 0$0.00- 0$0.00
Colusa14$3,245.54163$40,329.242$135.00
Contra Costa337$525,248.451,826$506,089.09160$37,602.92
Del Norte134$100,217.831,071$121,000.0121$15,455.00
El Dorado387$408,721.072,126$376,536.0156$10,519.21
Fresno- 0$0.00- 0$0.00- 0$0.00
Glenn27$19,128.34- 0$0.009$698.00
Humboldt212$165,875.201,815$382,632.1347$9,583.78
Imperial152$100,079.472,477$463,509.1274$18,387.36
Inyo71$47,823.40443$83,894.0725$4,385.66
Kern- 0$0.0010,120$2,398,244.11- 0$0.00
Kings- 0$0.002,139$323,529.572$168.00
Lake59$37,831.91603$122,135.3331$13,269.97
Lassen19$13,823.11280$26,556.6124$2,504.00
Los Angeles3,430$18,062,636.6845,540$10,597,383.88723$252,162.51
Madera- 0$0.002,589$491,573.08- 0$0.00
Marin105$72,684.141,208$375,420.6266$21,631.00
Mariposa- 0$0.00- 0$0.00- 0$0.00
Mendocino- 0$0.001,372$270,170.48- 0$0.00
Merced- 0$0.005,170$767,286.61- 0$0.00
Moduc- 0$0.00- 0$0.00- 0$0.00
Mono- 0$0.00- 0$0.00- 0$0.00
Monterey313$275,562.345,718$1,468,293.75124$24,524.41
Napa144$265,760.071,780$453,246.6028$6,504.00
Nevada118$64,984.13810$119,932.6369$17,437.98
Orange5,881$3,236,090.4323,769$6,660,007.201,059$256,047.64
Placer115$246,055.07910$266,208.9356$18,891.70
Plumas7$7,116.0046$6,949.033$150.00
Riverside12$29,939.8216,095$4,077,479.9130$15,393.48
Sacramento1,119$1,132,610.0913,299$2,820,383.28731$117,727.33
San Benito- 0$0.00- 0$0.00- 0$0.00
San Bernardino1,745$1,313,658.0920,185$3,912,244.99630$318,281.16
San Diego676$590,510.8810,731$2,631,283.12335$599,949.53
San Francisco- 0$0.005,335$1,302,960.28- 0$0.00
San Joaquin496$320,438.276,119$1,270,380.30300$65,503.40
San Luis Obispo- 0$0.00871$216,540.82- 0$0.00
San Mateo6$27,771.004,313$1,490,180.9346$18,434.21
Santa Barbara- 0$0.004,085$899,016.50- 0$0.00
Santa Clara- 0$0.0010,547$3,370,155.00- 0$0.00
Santa Cruz12$30,301.071,430$316,235.7740$17,766.60
Shasta347$254,721.712,855$452,566.8561$39,226.14
Sierra- 0$0.00- 0$0.00- 0$0.00
Siskiyou- 0$0.00486$39,653.97- 0$0.00
Solano19$46,554.5174$27,101.9738$25,949.77
Sonoma447$292,466.454,385$1,061,618.79236$43,749.76
Stanislaus273$182,573.775,242$970,359.42151$70,645.09
Sutter61$52,300.98456$77,789.2270$11,316.81
Tehama51$26,782.80600$77,518.0253$30,849.51
Trinity39$19,684.0068$9,195.3643$2,669.41
Tulare- 0$0.005,517$1,039,985.85- 0$0.00
Tuolumne21$19,679.43738$84,323.1219$5,700.00
Ventura466$666,514.115,988$1,392,612.02201$55,110.26
Yolo282$140,022.081,594$252,814.13107$21,389.15
Yuba- 0$0.00741$128,205.5351$5,575.84
OTC Totals17,764$28,945,956.29238,368$55,081,913.805,858$2,192,614.2955,081,914

2014.2015

Over the Counter LCSA Collections Federal Fiscal Year 2014-2015
LCSACheckCashMoney Order
CountAmountCountAmountCountAmount
Alameda1,822$565,054.98
Alpine7$402.00
Amador51$18,574.41561$59,140.5814$23,098.40
Butte75$96,980.172,621$350,704.88106$17,739.82
Calaveras
Colusa12$8,703.61171$44,862.183$75.00
Contra Costa53$576,495.192,204$679,448.5784$16,598.00
Del Norte109$71,316.051,266$153,139.5042$7,231.00
El Dorado335$342,719.431,991$382,900.9376$27,566.77
Fresno$0.00
Glenn19$11,080.061$45.465$481.00
Humboldt225$104,817.951,751$375,392.9885$22,795.00
Imperial174$83,443.882,712$483,627.13109$19,875.31
Inyo79$48,116.62464$94,451.2054$21,804.00
Kern10,332$2,466,878.33
Kings2,246$401,896.74
Lake44$14,417.79557$95,014.1311$1,430.93
Lassen37$15,303.18330$46,527.2613$3,329.29
Los Angeles2,412$1,755,974.4956,225$13,156,848.55594$316,362.02
Madera2,832$487,166.37
Marin51$110,784.771,854$667,042.5254$40,707.65
Mariposa
Mendocino1,371$282,111.521$0.00
Merced4,620$734,637.89
Modoc
Mono
Monterey312$282,303.126,281$1,619,391.27140$33,051.50
Napa1$10,000.001,471$385,828.97
Nevada68$108,566.02943$165,690.7652$7,097.14
Orange6,342$2,872,020.7524,533$6,953,059.241,091$277,505.66
Placer116$301,225.09913$275,554.3465$20,627.04
Plumas1$900.005$1,253.004$1,085.00
Riverside6$51,631.1616,753$4,455,438.4911$11,095.00
Sacramento991$1,198,934.9912,845$2,739,626.20578$108,146.84
San Benito
San Bernardino1,657$1,428,282.2920,699$4,184,388.47612$256,282.85
San Diego473$279,464.639,616$2,396,504.01296$339,373.50
San Francisco5,159$1,353,400.23
San Joaquin452$331,354.106,383$1,383,911.79288$85,164.73
San Luis Obispo945$245,061.01
San Mateo12$124,482.004,351$1,551,658.2421$96,309.48
Santa Barbara4,258$1,000,461.17
Santa Clara10,845$3,500,000.00
Santa Cruz9$19,411.091,144$320,237.854$380.36
Shasta309$187,848.963,237$552,159.0765$66,900.46
Sierra
Siskiyou1$0.00594$72,707.081$0.00
Solano74$130,243.4568$25,123.77154$29,299.09
Sonoma424$326,869.234,161$1,022,824.04229$41,436.91
Stanislaus233$258,920.285,233$1,005,367.09160$76,995.52
Sutter58$59,465.04727$131,440.63179$36,994.98
Tehama71$55,732.59722$93,185.4042$3,242.00
Trinity25$12,908.05111$14,108.1651$5,284.33
Tulare5,828$1,135,865.14
Tuolumne39$24,844.49755$73,160.2630$13,966.90
Ventura444$512,648.455,314$1,281,955.70177$46,028.63
Yolo215$141,367.621,716$256,736.6283$14,854.70
Yuba1$2,767.37846$134,728.6770$24,894.82
OTC Totals16,010$11,980,918.37252,394$59,858,120.375,654$2,115,111.63
MoneyGram$3,608,653.70
TouchPay55,081,9144,776,206.57$59,867,444.80
PayNearMe$175,996.66108.7%1.0868802601
TOTAL CASH$63,642,770.73

RFB

Over the Counter LCSA Collections Federal Fiscal Year 2014-2015
LCSACASELOADCheckCash
CountAmountCountAmount
Alameda34,0671,822$565,054.98
Alpine597$402.00
Amador1,40851$18,574.41561$59,140.58
Butte11,94175$96,980.172,621$350,704.88
Calaveras1,809
Colusa79312$8,703.61171$44,862.18
Contra Costa30,58253$576,495.192,204$679,448.57
Del Norte2,939109$71,316.051,266$153,139.50
El Dorado6,277335$342,719.431,991$382,900.93
Fresno60,423$0.00
Glenn1,77619$11,080.061$45.46
Humboldt6,793225$104,817.951,751$375,392.98
Imperial11,530174$83,443.882,712$483,627.13
Inyo1,27179$48,116.62464$94,451.20
Kern54,85610,332$2,466,878.33
Kings10,0722,246$401,896.74
Lake2,89544$14,417.79557$95,014.13
Lassen1,74437$15,303.18330$46,527.26
Los Angeles301,0162,412$1,755,974.4956,225$13,156,848.55
Madera6,5462,832$487,166.37
Marin3,03851$110,784.771,854$667,042.52
Mariposa708
Mendocino4,9181,371$282,111.52
Merced17,6794,620$734,637.89
Modoc456
Mono304
Monterey17,391312$282,303.126,281$1,619,391.27
Napa4,1091$10,000.001,471$385,828.97
Nevada3,77868$108,566.02943$165,690.76
Orange71,2016,342$2,872,020.7524,533$6,953,059.24
Placer9,303116$301,225.09913$275,554.34
Plumas1,0221$900.005$1,253.00
Riverside88,8376$51,631.1616,753$4,455,438.49
Sacramento80,616991$1,198,934.9912,845$2,739,626.20
San Benito2,396
San Bernardino116,3951,657$1,428,282.2920,699$4,184,388.47
San Diego79,931473$279,464.639,616$2,396,504.01
San Francisco14,2495,159$1,353,400.23
San Joaquin35,251452$331,354.106,383$1,383,911.79
San Luis Obispo4,457945$245,061.01
San Mateo11,57612$124,482.004,351$1,551,658.24
Santa Barbara14,1894,258$1,000,461.17
Santa Clara40,96110,845$3,500,000.00
Santa Cruz6,4379$19,411.091,144$320,237.85
Shasta12,993309$187,848.963,237$552,159.07
Sierra140
Siskiyou3,3071$0.00594$72,707.08
Solano18,39974$130,243.4568$25,123.77
Sonoma13,188424$326,869.234,161$1,022,824.04
Stanislaus30,615233$258,920.285,233$1,005,367.09
Sutter5,23658$59,465.04727$131,440.63
Tehama4,37571$55,732.59722$93,185.40
Trinity79825$12,908.05111$14,108.16
Tulare28,5795,828$1,135,865.14
Tuolumne3,01639$24,844.49755$73,160.26
Ventura21,089444$512,648.455,314$1,281,955.70
Yolo8,334215$141,367.621,716$256,736.62
Yuba4,6121$2,767.37846$134,728.67
TOTALS16,010$11,980,918.37252,394$59,858,120.37

File details come from the government source that posted it. Updated .