{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data","Contact and Other Information ","Program","Performance","Annual Financial Report","Categories","Quality Checklist ","Sheet2","Code2","Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Quarter",1,2]
["Court/County",{"$f":"INDEX(Code!A1:A59,C2)","v":"Not Selected"},1,{"$f":"INDEX(Code!B1:B59,C2)","v":"Select court/county (see Contact Information worksheet #1)"}]
["Court Contact",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Court Telephone",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Court E-mail Address",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["County Contact",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["County Telephone",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["County E-mail Address",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Private Collection Agency 1",{"$f":"#REF!","v":{"$error":"#REF!"}},1]
["Private Collection Agency 2",{"$f":"#REF!","v":{"$error":"#REF!"}},1]
["Private Collection Agency 3",{"$f":"#REF!","v":{"$error":"#REF!"}},1]
["Comprehensive Program",{"$f":"IF(C12=2,\"Y\",IF(C12=3,\"N\",\"Not Selected\"))","v":"Not Selected"},1]
["Component A",true,{"$f":"IF(B13=TRUE,1,0)","v":1}]
["Component B",false,{"$f":"IF(B14=TRUE,1,0)","v":0}]
["Component C",false,0]
["Component D",false,0]
["Component E",false,0]
["Component F",false,0]
["Component G",false,0]
["Component H",false,0]
["Component I",false,0]
["Component J",false,0]
["Component K",false,0]
["Component L",false,0]
["Component M",false,0]
["Component N",false,0]
["Total # of Components",false]
["Debit",false,1]
["Internet payment",true,1]
["Fee waiver",{"$f":"IF(C30=2,\"Y\",IF(C30=3,\"N\",\"Not Selected\"))","v":"Not Selected"},1]
["NSF checks",{"$f":"IF(C31=2,\"Y\",IF(C31=3,\"N\",\"Not Selected\"))","v":"N"},3]
[null,null,2]
[null,null,1]
[null,null,1]
[null,null,2]
[null,null,1]
[null,null,1]
[null,null,1]

{"sheet":"Contact and Other Information ","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[24,8,27,8],[19,8,20,8],[33,6,33,9],[32,1,32,3],[33,1,33,3],[28,6,28,9],[23,6,23,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[29,1,29,3],[30,1,30,3],[31,1,31,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[0,1,0,7],[11,1,13,2],[18,0,18,3],[17,1,17,3],[11,0,13,0],[19,1,19,3],[3,0,5,0],[7,0,9,0],[22,1,22,3],[23,1,23,3],[20,1,20,3],[21,1,21,3],[52,0,52,1],[49,0,49,3],[50,0,50,1],[51,0,51,1],[37,1,37,6],[39,1,39,6],[41,1,41,6],[43,1,43,6],[36,1,36,3],[47,1,47,6],[34,6,34,9],[45,1,45,6],[34,1,34,3],[35,1,35,3]]}
[]
[1,"Court/County"]
[]
[2,"Court Contact:"]
[null,"Telephone Number:"]
[null,"E-mail Address:"]
[null,null,null," "]
[3,"County Contact:"]
[null,"Telephone Number:"]
[null,"E-mail Address:"]
[]
[4,"List collection agencies or programs used by order in which debt is referred:",null,"1."]
[null,null,null,2]
[null,null,null,"3."]
[null,null,null,"4."]
[null,null,null,"5."]
[]
[5,null,null,null,"     Item 4",null,"Item 5","Item 6a ","Item 6b","Item 7"]
["Below is a description of the collections components (activities) authorized by Penal Code section 1463.007.  As required by Government Code section 68514, for Items 4, 5, 6a, 6b and 7, input the requested information for each collection activity  that the court/county program currently uses:  ",null,null,null,"Check each collections activity performed by program ","Category","Total amount collected per collection activity","Total number of cases by activity ","Total number of individuals associated with those cases","Total administrative cost per collection activity"]
[6,"a. Attempts telephone contact with delinquent debtors for whom the program has a telephone number to inform them of their delinquent status and payment options.",null,null,null,1,null,null,"Enter data as part of Category 3, (activity c)"]
[7,"b. Notifies delinquent debtors for whom the program has an address in writing of their outstanding obligation within 95 days of delinquency.",null,null,null,2]
[8,"c. Generates internal monthly reports to track collections data, such as age of debt and delinquent amounts outstanding.",null,null,null,3]
[9,"d. Uses Department of Motor Vehicles information to locate delinquent debtors.",null,null,null,4]
[10,"e. Accepts payment of delinquent debt by credit card.",null,null,null,3,"Enter data as part of Category 3, (activity c), Row 8 above. "]
[11,"a. Sends delinquent debt to the Franchise Tax Board's Court-Ordered Debt Collections Program.",null,null,null,5]
[12,"b. Sends delinquent debt to the Franchise Tax Board's Interagency Intercept Collections Program.",null,null,null,6]
[13,"c. Initiates driver's license suspension or hold actions when appropriate for a failure to appear in court.",null,null,null,7]
[14,"d. Contracts with one or more private debt collectors to collect delinquent debt.",null,null,null,8]
[15,"e. Sends monthly bills or account statements to all delinquent debtors.",null,null,null,2,"Enter data as part of Category 2 (activity b), Row 7 above."]
[16,"f. Contracts with local, regional, state, or national skip tracing or locator resources or services to locate delinquent debtors.",null,null,null,4,"Enter data as part of Category 4, (activity d) in Row 9 above."]
[17,"g. Coordinates with the probation department to locate debtors who may be on formal or informal probation.",null,null,null,4,"Enter data as part of Category 4, (activity d)  in Row 9 above. "]
[18,"h. Uses Employment Development Department employment and wage information to collect delinquent debt.",null,null,null,4,"Enter data part of Category 4, (activity d) Row 9 above. "]
[19,"i. Establishes wage and bank account garnishments where appropriate.",null,null,null,9]
[20,"j. Places liens on real property owned by delinquent debtors when appropriate.",null,null,null,9,"Enter data as part of Category 9, (activity i) Row 19 above. "]
[21,"k. Uses an automated dialer or automatic call distribution system to manage telephone calls.",null,null,null,1,"Enter data as part of Category 1, (activity a) Row 6 above. "]
[22,"TOTAL:",null,null,null,null,{"$f":"SUM(G20+G21+G22+G23+G25+G26+G27+G28+G33)","v":0},{"$f":"SUM(H20+H21+H22+H23+H25+H26+H27+H28+H33)","v":0},{"$f":"I22","v":0},{"$f":"SUM(J20+J21+J22+J23+J25+J26+J27+J28+J33)","v":0}]
[]
[23,"Does the court impose a civil assessment for failure to appear on infraction cases?"]
[]
[24,"Does the court impose civil assessment for failure to pay on infraction cases?"]
[]
[25,"Does the court impose a civil assessment for failure to pay on misdemeanor cases? "]
[]
[26,"Does the court impose a civil assessment for failure to pay on felony cases?"]
[]
[27,"Does the court impose a civil assessment on any other case type? If yes, explain in the Program Report worksheet. "]
[]
[28,"Collection program to which the majority of delinquent debt is initially referred."]
[]
["Category Key: (See Category tab for task/activities list)"]
["1= Telephone Contact",null,"4= Skip tracing","7= DL Hold"]
["2= Written Notice(s)",null,"5= FTB-COD","8= Private agency"]
["3= Lobby/counter",null,"6= FTB-IIC","9= Wage/bank garnishments and Liens"]

{"sheet":"Program","index":2,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[[35,0,46,0]]}
[{"$f":"IF(TRIM(Data!D2)=\"SELECT COURT/COUNTY\",\"Select court/county (see Contact Information worksheet #1)\",Data!D2)","v":"Select court/county (see Contact Information worksheet #1)"}]
["Use the space below to describe your collection program."]
[]
["Describe the extent to which your collection program is meeting the Judicial Council approved Collections Best Practices and identify any obstacles or problems that prevent the collections program from meeting those objectives. Of the  twenty-five (25) Best Practices listed below please check those which your collection program has implemented. Provide an explanation for the best practices currently not being met, below. Also, identify any new or additional practices that have improved your collections program. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please identify areas in collections or distribution (check all that apply) in which program staff would like to receive training, assistance, or additional information.  "]
[]
[]
[]
[]
["Comments or explanations:"]

{"sheet":"Performance","index":3,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[[17,0,31,0],[33,0,55,0],[4,0,15,0]]}
[{"$f":"IF(TRIM(Data!D2)=\"SELECT COURT/COUNTY\",\"Select court/county (see Contact Information worksheet #1)\",Data!D2)","v":"Select court/county (see Contact Information worksheet #1)"}]
["Use the space below to discuss your collection program."]
[]
["Please provide any comments on your Gross Recovery Rate or Success Rate for the reporting period, by Current Period, Prior Periods Inventory, and Combined."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please explain the extent of your reporting capabilities in terms of providing the new information required by GC68514.  If data cannot be provided at this time or if the reported data differs from the Instructions, please describe the submitted data and any plans for providing this information in the future."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional operational information about your collections program for the reporting period."]

{"sheet":"Annual Financial Report","index":4,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[43,0,43,12],[62,0,62,1],[62,7,62,8],[40,5,40,6],[40,7,40,12],[41,5,41,6],[41,7,41,12],[42,5,42,6],[42,7,42,12],[39,5,39,6],[39,7,39,12],[28,11,28,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,0,38,12],[29,11,29,12],[27,0,27,12],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,0,5,12],[16,0,16,12]]}
[null,{"$f":"IF(TRIM(Data!D2)=\"SELECT COURT/COUNTY\",\"Select court/county (see Contact Information worksheet #1)\",Data!D2)","v":"Select court/county (see Contact Information worksheet #1)"}]
[]
[null,"REPORTING PERIOD",null,"Col. A"]
[1,"Beginning Date-First day of Reporting Period",null,"2017-07-01"]
[2,"Ending Date-Last day of Reporting Period",null,"2018-06-30"]
["CURRENT PERIOD: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,null,"Number of Cases Established/ Referred/Transferred ","Value of Cases Established/ Referred/Transferred ","Number of Cases with Payment(s) Received                             (Items 1 and 2)      ","Gross Revenue Collected            ","Cost of Collections        (Penal Code 1463.007)","Adjustment: Amount satisfied by Court-ordered Suspension, Dismissal or Alternative Sentence (Item 3)","Discharge from Accountability     \n(Item 3)","Change in Value \n(Col. C- E - G - H) ","Value of Cases on Installment Agreement                 (Item 8)","Default Balance Installment Agreement        \n(Item 8)","Percentage of Debt Defaulted On (Installment Agmt.)                    (Col. K / Col. J) "]
["Row","Program","Col. B","Col. C","Col. D","Col. E","Col. F","Col. G","Col. H","Col. I","Col. J","Col. K","Col. L"]
[3,"Non-Delinquent Collections"]
[{"$f":"A9+1","v":4},"Court Collection Program",null,null,null,null,null,null,null,{"$f":"SUM(D10-F10-H10-I10)","v":0},null,null,{"$f":"IFERROR(L10/K10,\"\")","v":""}]
[5,"County Collection Program",null,null,null,null,null,null,null,0,null,null,{"$f":"IFERROR(L11/K11,\"\")","v":""}]
[6,"Private Agency",null,null,null,null,null,null,null,0,null,null,""]
[7,"FTB Court-Ordered Debt",null,null,null,null,null,null,null,0,null,null,""]
[8,"Intra-Branch Program",null,null,null,null,null,null,null,0,null,null,""]
[9,"Other",null,null,null,null,null,null,null,0,null,null,""]
[10,"Sub-total Delinquent ",{"$f":"SUM(C10:C15)","v":0},0,0,0,0,0,{"$f":"SUM(I10:I15)","v":0},{"$f":"SUM(J10:J15)","v":0},{"$f":"SUM(K10:K15)","v":0},{"$f":"SUM(L10:L15)","v":0}]
["PRIOR PERIODS INVENTORY: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,null,"Number of Cases Referred/Transferred (Ending Balance from Prior Year)","Value of Cases Referred/Transferred \n(Ending Balance from Prior Year)","Number of Cases with Payment(s) Received   ","Gross Revenue Collected     ","Cost of Collections \n(Penal Code 1463.007)","Adjustment: Amount satisfied by Court-ordered Suspension, Dismissal or Alternative Sentence","Discharge from Accountability ","Change in Value \n(Col. N- P -R - S) ","Value of Cases on Installment Agmt. (Ending Balance from Prior Year) ","Default Balance   Installment Agreement         ","Percentage of Debt Defaulted On (Installment Agmt.)                  (Col. V / Col. U) "]
["Row","Program","Col.M","Col. N","Col. O","Col. P","Col. Q","Col. R","Col. S","Col. T","Col. U","Col. V","Col. W"]
[11,"Non-Delinquent Collections"]
[12,"Court Collection Program",null,null,null,null,null,null,null,{"$f":"SUM(D21-F21-H21-I21)","v":0},null,null,{"$f":"IFERROR(L21/K21,\"\")","v":""}]
[13,"County Collection Program",null,null,null,null,null,null,null,{"$f":"SUM(D22-F22-H22-I22)","v":0},null,null,{"$f":"IFERROR(L22/K22,\"\")","v":""}]
[14,"Private Agency",null,null,null,null,null,null,null,{"$f":"SUM(D23-F23-H23-I23)","v":0},null,null,""]
[{"$f":"A23+1","v":15},"FTB Court-Ordered Debt",null,null,null,null,null,null,null,{"$f":"SUM(D24-F24-H24-I24)","v":0},null,null,""]
[{"$f":"A24+1","v":16},"Intra-Branch Program",null,null,null,null,null,null,null,0,null,null,""]
[{"$f":"A25+1","v":17},"Other",null,null,null,null,null,null,null,0,null,null,""]
[{"$f":"A26+1","v":18},"Sub-total Delinquent ",{"$f":"SUM(C21:C26)","v":0},{"$f":"SUM(D21:D26)","v":0},{"$f":"SUM(E21:E26)","v":0},{"$f":"SUM(F21:F26)","v":0},{"$f":"SUM(G21:G26)","v":0},0,0,0,0,0]
["COMBINED: BEGINNING AND ENDING BALANCES; FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,null," Number of Cases Beginning Balance  "," Value of Cases Beginning Balance  ","Gross Revenue Collected                   ","Cost of Collections (Penal Code 1463.007)  ","Adjustments        ","Discharge from Accountability             "," Change in Value          ","Number of Cases - Ending Balance","Value of Cases-Ending Balance    ","Error Messages"]
["Row","Program","Col.X","Col. Y","Col. Z","Col. AA","Col. AB","Col. AC","Col. AD","Col. AE","Col. AF","Col. AG"]
[19,"Non-Delinquent Collections",null,null,{"$f":"F9+F20","v":0}]
[20,"Court Collection Program",{"$f":"C10+C21","v":0},{"$f":"D10+D21","v":0},{"$f":"F10+F21","v":0},{"$f":"G10+G21","v":0},{"$f":"H10+H21","v":0},{"$f":"I10+I21","v":0},{"$f":"SUM(E32+G32+H32)","v":0},null,{"$f":"D32-I32","v":0},{"$f":"IF(D32-I32=K32,\" \",\"Out of Balance\")","v":" "},{"$f":"IF(H32+J32=L32,\" \",\"Out of Balance\")","v":"Out of Balance"}]
[21,"County Collection Program",{"$f":"C11+C22","v":0},0,0,0,0,0,{"$f":"SUM(E33+G33+H33)","v":0},null,null,{"$f":"IF(D33-I33=K33,\" \",\"Out of Balance\")","v":" "},"Out of Balance"]
[22,"Private Agency",0,{"$f":"D12+D23","v":0},{"$f":"F12+F23","v":0},{"$f":"G12+G23","v":0},0,0,0,null,{"$f":"D34-I34","v":0}," ","Out of Balance"]
[23,"FTB Court-Ordered Debt",0,0,{"$f":"F13+F24","v":0},0,0,0,{"$f":"SUM(E35+G35+H35)","v":0},null,0," ","Out of Balance"]
[24,"Intra-Branch Program",0,0,0,0,0,0,0,null,null," ","Out of Balance"]
[25,"Other",0,0,0,0,0,0,0,null,null," ","Out of Balance"]
[26,"Total Delinquent",{"$f":"SUM(C32:C37)","v":0},{"$f":"SUM(D32:D37)","v":0},0,0,0,0,0,{"$f":"SUM(J32:J37)","v":0},{"$f":"SUM(K32:K37)","v":0}]
["COLLECTIONS METRICS FOR FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[null,"Metric","Current Period","Prior Inventory","Combined","Formula",null,"Definition"]
["Row","Col. AH","Col. AI","Col. AJ","Col. AK","Col. AL",null,"Col. AM"]
[27,"Gross Recovery Rate",{"$f":"IF((D16)>0,SUM((F16+H16+I16)/(D16)),\"\")","v":""},{"$f":"IF((D27)>0,SUM((F27+H27+I27)/(D27)),\"\")","v":""},{"$f":"IF((D38)>0,SUM((E38+G38+H38)/(D38)),\"\")","v":""}," (Collections + Adjustments + Discharges)\n     Referrals\n",null,"Measures a collection program’s ability to resolve delinquent court-ordered debt, including alternative sentences, community service, suspended sentences and discharges. "]
[28,"Success Rate",{"$f":"IF((D16-H16-I16)>0,SUM((F16)/(D16-H16-I16)),\"\")","v":""},{"$f":"IF((D27-H27-I27)>0,SUM((F27)/(D27-H27-I27)),\"\")","v":""},{"$f":"IF((D38-G38-H38)>0,SUM((E38)/(D38-G38-H38)),\"\")","v":""},"                       Collections__________\n (Referrals - Adjustments - Discharges)\n",null,"Measures the amount of revenue collected on delinquent court-ordered debt based on total delinquent accounts referred after adjustments and discharges, including NSF checks. "]
[" VICTIM RESTITUTION AND OTHER JUSTICE RELATED REIMBURSEMENTS "]
[null,null,"Number of Cases - (Ending Balance from Prior Year)","Value of Cases - \n(Ending Balance from Prior Year) "," Number of Cases Established/ Referred/ Transferred in  Period","Value of Cases Established/ Referred/ Transferred in  Period","Gross Revenue Collected","Adjustments","Gross Revenue Collected: Victim Restitution       (PC1202.4 (f)) Only ","Change in Value","Number of Cases - Ending Balance","Value of Cases - Ending Balance","Error Messages"]
["Row","Program","Col. AN","Col. AO","Col. AP","Col. AQ","Col. AR","Col. AS","Col.AT","Col. AU","Col. AV","Col. AW","Col. AX"]
[29,"Non-Delinquent Collections",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D47+J47=L47,\" \",\"Out of Balance\")","v":" "}]
[30,"Court Collection Program",null,null,null,null,null,null,null,{"$f":"F48-G48-H48-I48","v":0},null,null,{"$f":"IF(D48+J48=L48,\" \",\"Out of Balance\")","v":" "}]
[{"$f":"A48+1","v":31},"County Collection Program",null,null,null,null,null,null,null,{"$f":"F49-G49-H49-I49","v":0},null,null,{"$f":"IF(D49+J49=L49,\" \",\"Out of Balance\")","v":" "}]
[32,"Private Agency",null,null,null,null,null,null,null,{"$f":"F50-G50-H50-I50","v":0},null,null,{"$f":"IF(D50+J50=L50,\" \",\"Out of Balance\")","v":" "}]
[33,"FTB Court-Ordered Debt",null,null,null,null,null,null,null,{"$f":"F51-G51-H51-I51","v":0},null,null,{"$f":"IF(D51+J51=L51,\" \",\"Out of Balance\")","v":" "}]
[34,"Intra-branch Program",null,null,null,null,null,null,null,0,null,null," "]
[35,"Other",null,null,null,null,null,null,null,0,null,null," "]
[36,"Total Delinquent ",{"$f":"SUM(C48:C53)","v":0},0,0,0,{"$f":"SUM(G48:G53)","v":0},0,{"$f":"SUM(I48:I53)","v":0},{"$f":"SUM(J48:J53)","v":0},{"$f":"SUM(K48:K53)","v":0},{"$f":"SUM(L48:L53)","v":0}]
[]
["Reviewed by Court",null,null,null,null,null,null,"Reviewed by County"]
[]
[]
[]
["Printed Name",null,null,"Signature",null,null,null,"Printed Name",null,null,"Signature"]
[]
[]
["Date",null,null,"Title (Court Executive or Presiding Judge)",null,null,null,"Date",null,null,"Title (County Auditor-Controller or other)"]

{"sheet":"Categories","index":5,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,2],[22,1,23,1]]}
[]
["PC 1463.007 Collections Activity","Category"," Task/Activity "]
[]
["3a. Attempts telephone contact with delinquent debtors for whom the program has a telephone number ",null," \n\nOutbound Call\nInbound Call "]
[null,"1= Telephone Contact"]
["k. Uses an automated dialer or automatic call distribution system to manage telephone calls.",null,"Dialer blast messaging "]
["3b. Notifies delinquent debtors for whom the program has an address in writing of their outstanding obligation within 95 days of delinquency. ",null,"Delinquent Notice (Failure to Appear, Failure to Pay, Civil Assessment) \nHandle all collections-related mail correspondence                                        \nE-mail received  \nEmail sent                                     "]
[null,"2=Written Notice(s)"]
["4e. Sends monthly bills or account statements to all delinquent debtors."]
["3c. Generates internal monthly reports to track collections data, such as age of debt and delinquent  amounts outstanding.  ","3= Lobby/Counter","Receive/post cash, check and credit card payments   \nProvide case  information to individuals\nEstablish payment plan agreements including amendments to existing plan  \nSchedule walk-in arraignment, upon individual's request to go before a judge\nUpdate DMV, if needed \nEnter notes on the case, etc. \nWork the Out of Court--Collection Queue (Judge orders case be handled in collections)   \nProcess all criminal and juvenile probation orders; update financials and establish payment plans. \nProcess all criminal and juvenile DA forms; update financials and establish payment plans\nProcess payments from Intra-branch, generate weekly payment report \nProcess payments and commission credit adjustments from private agency. Assist vendor w/case info., account balances, email them any directives from Judge on case and prepare commission checks at the end of month. \nProcess all payments and commission credit adjustments from FTB-COD. Contact FTB-COD for additional information such as account balances, levy actions, etc.   "]
[]
["3e. Accepts payment of delinquent debt by credit card. "]
["3d. Uses Department of Motor Vehicles information to locate delinquent debtors."]
["4f. Contracts with local, regional, state, or national skip tracing or locator resources or services to locate delinquent debtors.",null,"Perform skip tracing (DMV, internet, third party vendors)"]
[null,"4=Skip Tracing"]
["4g. Coordinates with the probation department to locate debtors who may be on formal or informal probation.  ",null,"Obtain debtor information from probation and/or EDD"]
["4h. Uses Employment Development Department employment and wage information to collect delinquent debt."]
["4a. Sends delinquent debt to the Franchise Tax Board’s Court-Ordered Debt Collections Program. ","5=FTB-COD ","Refer case to FTB-COD"]
[]
["4b.Sends delinquent debt to the Franchise Tax Board’s Interagency Intercept Collections Program.","6= FTB-IIC","Refer case to FTB-IIC"]
["4c. Initiates driver’s license suspension or hold actions when appropriate for a failure to appear in court.","7=DL Hold/Suspension","Send abstract to DMV for Failure to Appear driver's license hold/suspension"]
["4d. Contracts with one or more private debt collectors to collect delinquent debt.","8= Private Agency","Refer case to private collection agency"]
["4i. Establishes wage and bank account garnishments where appropriate.","9= Wage/bank Garnishments and Liens","Wage and/or bank accounts are garnished"]
["4k. Places liens on real property owned by delinquent debtors when appropriate.",null,"Place liens"]
["Sample list of activities/tasks to be used to report activities utilized in the collection of delinquent court-ordered debt. See corresponding \"Category\"  on the Contact and Other Information Sheet, Items 5, 6 and 7. "]

{"sheet":"Quality Checklist ","index":6,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,2,43,13],[44,2,44,13],[15,0,15,13],[28,0,28,13],[35,0,35,13],[22,2,22,13],[21,2,21,13],[20,2,20,13],[41,2,41,13],[42,2,42,13],[27,2,27,13],[30,2,30,13],[40,2,40,13],[39,2,39,13],[38,2,38,13],[34,2,34,13],[37,2,37,13],[0,2,0,13],[32,2,32,13],[33,2,33,13],[25,2,25,13],[2,2,2,13],[3,2,3,13],[1,2,1,13],[24,2,24,13],[23,2,23,13],[26,2,26,13],[29,2,29,13],[4,2,4,13],[31,2,31,13],[6,2,6,13],[5,2,5,13],[7,2,7,13],[14,2,14,13],[10,2,10,13],[36,2,36,13],[18,2,18,13],[19,2,19,13],[8,2,8,13],[9,2,9,13],[16,2,16,13],[11,2,11,13],[12,2,12,13],[13,2,13,13],[17,2,17,13]]}
["Row","Quality Checklist","CURRENT PERIOD: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[1,null,"Row 3, Column D, includes revenues collected for non-delinquent infraction, misdemeanor, and felony cases that were paid in full on or before the due date, or current installment or accounts receivable (A/R) payment plan. Row 3, Column E includes the number of cases associated with non-delinquent revenue collections reported in Row 3, Column D.",null,null,null,null,null,null,null,null,null,null,null,false]
[2,null,"Rows 4-9 include all fines, fees, forfeitures, penalties, and assessments on traffic, criminal, and juvenile delinquency case types (infraction, misdemeanor and felonies), except victim restitution and other justice related fees (see Rows 29-35 for more information).",null,null,null,null,null,null,null,null,null,null,null,false]
[3,null,"Rows 4-9, include newly established/referred/transferred cases, gross revenue collected, adjustments, or discharges posted during the reporting period. ",null,null,null,null,null,null,null,null,null,null,null,false]
[5,null,"Rows 4-9, Column B, include the total number of new cases established, referred, or transferred within the reporting period. Any cases that were previously established, but never referred or transferred to collections, are considered new cases and should be reported in this column (the corresponding value of these cases should be reported in Column C). If multiple cases were bundled into one case, only one (1) case should be reported in Column B.",null,null,null,null,null,null,null,null,null,null,null,false]
[6,null,"Rows 4-9, Column C, include the total NET value of the corresponding cases in Column B, that were established, referred, or transferred during the reporting period only.         ",null,null,null,null,null,null,null,null,null,null,null,false]
[7,null,"Rows 4-9, Column D, include the number of cases with payment(s) received during the reporting period. The number of cases reported may be equal to but not greater than the number of cases established in Column B. ",null,null,null,null,null,null,null,null,null,null,null,false]
[8,null,"Rows 4-9, Column E, include all monies received towards the satisfaction of delinquent court-ordered debt, including installment payments. ",null,null,null,null,null,null,null,null,null,null,null,false]
[9,null,"Rows 4-9, Column F, include the cost of collections that, pursuant to PC 1463.007, is allowable to offset revenue prior to distribution to other governmental entities. Cost of collections is entered in Column F as a negative number unless posting a reversal.",null,null,null,null,null,null,null,null,null,null,null,false]
[10,null,"Value reported in Column G includes the total value of court-ordered debt satisfied by court-ordered dismissal, suspension, or by means other than payment. An amount satisfied by means other than payment includes alternative sentences or non-cash adjustment that decreases or increases the amount outstanding for individual debt items. ",null,null,null,null,null,null,null,null,null,null,null,false]
[11,null,"Value reported in Column H includes all debt deemed uncollectible that has been discharged, per Government Code section 25257-25259.95.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[12,null,"Column I is the change in value of Cases Referred/Established/Transferred minus (-) Gross Collections, Adjustments, and Discharged debt. (Column C - E - G - H). ",null,null,null,null,null,null,null,null,null,null,null,false]
[13,null,"Rows 4-9, Column J, includes the value of all cases set-up on an installment agreement (A/R or monthly installment payment plan) by the court or collecting entity.",null,null,null,null,null,null,null,null,null,null,null,false]
[14,null,"Rows 4-9, Column K, include the balances from delinquent cases where the individual is non-compliant with the terms of the agreement (i.e., payments have not been received) and the plan was not reinstated at the end of the fiscal year.",null,null,null,null,null,null,null,null,null,null,null,false]
[15,null,"Column L is formula driven and calculates the percentage of fines and fees defaulted on by dividing the installment agreement balance (amount defaulted on) by the initial value of court-ordered debt set-up on payment plan (Col. K/ Col. J ) ",null,null,null,null,null,null,null,null,null,null,null,false]
["PRIOR PERIODS INVENTORY: FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[16,null,"Row 11, Column O, includes revenues collected for non-delinquent infraction, misdemeanor and felony cases that were paid in full on or before the due date, or current installment or accounts receivable (A/R) payment plan. Row 11, Column P includes the number of cases associated with non-delinquent revenue collections reported in Row 11, Column O. ",null,null,null,null,null,null,null,null,null,null,null,false]
[17,null,"Rows 12-17 include all fines, fees, forfeitures, penalties, and assessments on traffic, criminal, and juvenile delinquency case types (infraction, misdemeanor and felonies), except victim restitution and other justice related fees (see Row 29-35 for more information).",null,null,null,null,null,null,null,null,null,null,null,false]
[18,null,"Rows 12-17 include all cases in inventory referred or transferred to a collections program in a prior period, and gross revenue collected, court-ordered adjustments, or discharges that were received and posted during the current reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[19,null,"Rows 12-17, Column O, include the number of cases with payments received during the reporting period. Note: any late posting from prior year should be reported in Column M, and the case value should be reported in Column N as part of the ending balance from prior year. ",null,null,null,null,null,null,null,null,null,null,null,false]
[20,null,"Rows 12-17, Column P, include all monies received towards the satisfaction of delinquent court-ordered debt. ",null,null,null,null,null,null,null,null,null,null,null,false]
[21,null,"Rows 12-17, Column Q, include the cost of collections that, pursuant to PC 1463.007, is allowable to offset revenue prior to distribution to other governmental entities. Cost of collections is entered in Column Q as a negative number unless posting a reversal.",null,null,null,null,null,null,null,null,null,null,null,false]
[22,null,"Rows 12-17, Column R, include the total value of court-ordered debt satisfied by court-ordered dismissal, suspension or by means other than payment. An amount satisfied by means other than payment includes alternative sentences or non-cash adjustment that decreases or increases the amount outstanding for individual debt items. For example, community service, or post sentence service of time in custody in lieu of fine.",null,null,null,null,null,null,null,null,null,null,null,false]
[23,null,"Value reported in Column S includes all debt deemed uncollectible that has been discharged, per Government Code section 25257-25259.95.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A24+1","v":24},null,"Value reported in Column T is the change in Value of Cases (Ending Balance from Prior Year) minus (-) Gross Collections, Adjustments, and Discharged debt. (Column N - P - R - S). ",null,null,null,null,null,null,null,null,null,null,null,false]
[25,null,"Column U is the ending value carried over from the prior year for all cases on an installment agreement that were defaulted on. ",null,null,null,null,null,null,null,null,null,null,null,false]
[26,null,"Column V include the balance from all cases on an installment agreement where payment(s) were not received in the reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A27+1","v":27},null,"Column W captures the percentage of delinquent fines and fees payable in installments that were defaulted on. The cell is formula driven and calculates a percentage by dividing the rolling balance by the value of cases (carried over) on installment agreements. (Column V/Column U) ",null,null,null,null,null,null,null,null,null,null,null,false]
["COMBINED: ENDING BALANCE FINES, FEES, FORFEITURES, PENALTIES AND ASSESSMENTS"]
[28,null,"Row 19, Column Z, includes the combined total of non-delinquent gross revenue collected.  ",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A30+1","v":29},null,"Rows 20-25, Columns X, Y, Z, AA, AB, AC and AD include the combined case number and value of new and prior period inventory, change in value, gross revenues, cost of collections, and adjustments, and discharge from accountability.",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A31+1","v":30},null,"Rows 20-25, Columns X, Y, Z, AA, AB, AC and AD are formula driven, no input required. Value of Cases reported in Columns Y and AF reconcile to figures reported from underlying systems and vendors. ",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A32+1","v":31},null,"Value reported in Column AE includes the total number of cases at the end of the reporting period for each program.",null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"A33+1","v":32},null,"Values reported in Column AF balance to value of cases at beginning of period (Col. Y), minus the change in value reported in Col. AD (which is the sum of the amounts shown in Col. Z, AB and AC. ) ",null,null,null,null,null,null,null,null,null,null,null,false]
[33,null,"An Error Message in Column AG indicates that the beginning balance in Column Y, minus the value of transactions reported in Column AD does not equal the ending balance reported in Column AF. ",null,null,null,null,null,null,null,null,null,null,null,false]
["VICTIM RESTITUTION AND OTHER JUSTICE RELATED REIMBURSEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"i"]
[34,null,"Row 29 includes only non-delinquent cases referred/established, revenue collected, or adjustment posted during the reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[35,null,"Rows 30-35 include victim restitution and other justice related fees owed to other entities that were not included in Rows 3-9 or 11-17",null,null,null,null,null,null,null,null,null,null,null,false]
[36,null,"Rows 30-35, include cases referred/established, revenue collected, or adjustments posted during the reporting period.",null,null,null,null,null,null,null,null,null,null,null,false]
[37,null,"Column AR includes gross revenue collected on other justice related fees and should be entered as a positive number unless posting reversal. Column AS are adjustments that decrease or increase the amount outstanding for individual debt items.",null,null,null,null,null,null,null,null,null,null,null,false]
[38,null,"Column AT includes the total amount of restitution owed to a victim by court order under Penal Code section 1202.4(f) collected by each collections program during the reporting period. Row 29 includes non-delinquent restitution collections.",null,null,null,null,null,null,null,null,null,null,null,false]
[39,null,"\nColumn AU includes the value of Col. AQ less the amounts shown in columns AR, AS, and AT (this field is formula-driven, so no separate calculation or entry is required).",null,null,null,null,null,null,null,null,null,null,null,false]
[40,null,"\nColumn AV includes the number of cases of all delinquent outstanding debt (new and inventory). In addition to restitution, debt balances may include other criminal justice–related fees not reported in rows 3-9 and 12–17.",null,null,null,null,null,null,null,null,null,null,null,false]
[41,null,"Column AW should equal the beginning balance in Column AO plus the sum of transactions for the period, as shown in Col. AU (AU =A Q - AR −AS −AT).",null,null,null,null,null,null,null,null,null,null,null,false]
[42,null,"Column AX is blank unless errors or potential errors are detected in the worksheet. If error messages are present, please correct the identified error or explain in Performance Report.",null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Sheet2","index":7,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["County"]
["Court"]
["Private Agency"]
["FTB-COD"]
["Intra-branch"]
["None"]

{"sheet":"Code2","index":8,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
["Select Primary Program"]
["County",null,null,1]
["Court"]
["Private Agency"]
["Hybrid "]
[]
[]
[]
["Select System Used",null,null,1]
["Case Management System"]
["Accounts Receivable System"]
["CUBS"]
["Other"]
[]
["Select Programs That Apply"]
["Court"]
["County"]
["Count and County"]
["None"]

{"sheet":"Code","index":9,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Not Selected","Select court/county (see Contact Information worksheet #1)",null,null,"Select Y or N",null,null,"1st and 2nd Quarter",1]
["C010000","Court/County - Alameda",null,1,"Yes",null,null,"3rd and 4th Quarter",2]
["C020000","Court/County - Alpine",null,2,"No"]
["C030000","Court/County - Amador"]
["C040000","Court/County - Butte"]
["C050000","Court/County - Calaveras"]
["C060000","Court/County - Colusa"]
["C070000","Court/County - Contra Costa"]
["C080000","Court/County - Del Norte"]
["C090000","Court/County - El Dorado"]
["C100000","Court/County - Fresno"]
["C110000","Court/County - Glenn"]
["C120000","Court/County - Humboldt"]
["C130000","Court/County - Imperial"]
["C140000","Court/County - Inyo"]
["C150000","Court/County - Kern"]
["C160000","Court/County - Kings"]
["C170000","Court/County - Lake"]
["C180000","Court/County - Lassen"]
["C190000","Court/County - Los Angeles"]
["C200000","Court/County - Madera"]
["C210000","Court/County - Marin"]
["C220000","Court/County - Mariposa"]
["C230000","Court/County - Mendocino"]
["C240000","Court/County - Merced"]
["C250000","Court/County - Modoc"]
["C260000","Court/County - Mono"]
["C270000","Court/County - Monterey"]
["C280000","Court/County - Napa"]
["C290000","Court/County - Nevada"]
["C300000","Court/County - Orange"]
["C310000","Court/County - Placer"]
["C320000","Court/County - Plumas"]
["C330000","Court/County - Riverside"]
["C340000","Court/County - Sacramento"]
["C350000","Court/County - San Benito"]
["C360000","Court/County - San Bernardino"]
["C370000","Court/County - San Diego"]
["C380000","Court/County - San Francisco"]
["C390000","Court/County - San Joaquin"]
["C400000","Court/County - San Luis Obispo"]
["C410000","Court/County - San Mateo"]
["C420000","Court/County - Santa Barbara"]
["C430000","Court/County - Santa Clara"]
["C440000","Court/County - Santa Cruz"]
["C450000","Court/County - Shasta"]
["C460000","Court/County - Sierra"]
["C470000","Court/County - Siskiyou"]
["C480000","Court/County - Solano"]
["C490000","Court/County - Sonoma"]
["C500000","Court/County - Stanislaus"]
["C510000","Court/County - Sutter"]
["C520000","Court/County - Tehama"]
["C530000","Court/County - Trinity"]
["C540000","Court/County - Tulare"]
["C550000","Court/County - Tuolumne"]
["C560000","Court/County - Ventura"]
["C570000","Court/County - Yolo"]
["C580000","Court/County - Yuba"]