{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Fee Bill","Data Source"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":"Instructions","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,5,5,16],[18,2,18,10],[19,3,19,16],[18,11,18,13],[7,2,7,17],[12,3,12,17],[15,3,15,17],[17,2,17,4],[14,2,14,6],[11,2,11,3],[9,2,9,17],[8,7,8,9],[8,3,8,6]]}
[]
[]
[null,null,null,null,null,"Comprehensive Adjusting Services \nCivil Proceeding Preparation and Attendance Fee Bill Instructions"]
[]
[]
[]
[null,null,"Process Description"]
[null,null,"The Civil Proceedings Preparation and Attendance Fee Bill is to request compensation for a deployment of an adjuster whose participation is needed at a civil proceeding. Compensation is paid at a flat fee for the adjuster's time spent for preparation, attendance, or testimony at a proceeding directly related to work they performed on a Citizens' claim. A single non-contingent daily flat fee of $625.00 will be paid for total preparation time, with a separate non-contingent flat fee of $700.00 paid for travel to and attendance at a proceeding. If the preparation meeting with Citizens’ Outside Counsel occurs on the same day as attendance at the civil proceeding, the Preparation Fee will be included within the Attendance Fee, for a total single payment of $700. Invoicing for Commercial civil proceedings will need to be submitted using the Commercial Civil Proceeding Preparation and Attendance Fee Bill. Notice of Deposition must be submitted with all Preparation Fee invoices.\n\nThe Assignment Fee of $75 includes, but is not limited to, all activities related to the following events:\n-receipt of the Fact Witness Assignment and ongoing contact by telephone and email with Citizens and/or Citizens’ Outside Counsel until conclusion of the Fact Witness Assignment;\n-updating Citizens and/or Citizens’ Outside Counsel with all communications, documents, and activities related to the Fact Witness Assignment;\n-scheduling, confirmation, and related correspondence with the subject(s) of the Fact Witness Assignment and/or their representative(s); and,\n-independent review and familiarity with the claim file and related documents by the Adjuster in advance of the preparation meeting with Citizens’ Outside Counsel and attendance at the civil proceeding.\nIn no event shall total compensation exceed $75 for the activities included under the Assignment Fee.\n\nThe Preparation Fee of $625.00 includes, but are not limited to, all activities related with traveling to and participation in a preparation meeting(s) with Citizens’ Outside Counsel in advance of providing testimony at a civil proceeding. A preparation meeting with outside counsel or a civil proceeding cancelled or rescheduled prior to the date scheduled, where no meeting occurs, is not compensable under the Preparation Fee. Further, the Preparation Fee is a single payment and cannot be separately charged for multiple preparations.\n\nThe Attendance Fee of $700.00 includes, but not limited to, all activities related to the following events:\n-traveling to and attendance at the civil proceeding;\n-a brief post testimony consultation, if requested by Citizens and/or Citizens’ Outside Counsel; and, \n-any other tasks not included above directly related to the Fact Witness Assignment.\n\nAlso, an additional Attendance Fee may be provided to accommodate travel and participation if more than one (1) day of attendance is needed, as determined in Citizens’ sole discretion. Further, a civil proceeding cancelled or rescheduled prior to the date scheduled, where no fact witness attendance occurs, is not compensable under the Attendance Fee.\n"]
[null,null,null,"PDF copy of this invoice should be sent to ",null,null,null,"CivilProcedures@citizensfla.com."]
[null,null,"IMPORTANT: Please read these instructions entirely to ensure accuracy of the Civil Proceedings Preparation and Attendance Fee Bill before submitting for reimbursement. Invoices not submitted within 12 months of the services requested are forfeited for failure to submit an invoice in a timely manner."]
[]
[null,null,"Top"]
[null,null,null,"1. Invoice Date - Enter the date the invoice is created.\n2. Invoice # - If applicable, insert invoice number.\n3. Claim # - Enter the Citizens claim number. \n4. Policy # - Enter the Citizens policy number.\n5. Adjuster/Appraiser - Enter legal name of the adjuster/appraiser. \n6. Case Name - Enter the case name (example: Joe Smith vs Citizens)\n7. Insured - Enter the insured's name as it appears on the claim.\n8. Deployed with contracted firm at time of proceeding? - Select Y (Yes) or N (No) based on the status of the adjuster seeking reimbursement at the time of     \n    proceeding. Please see below for additional information on payee:\n   •If adjuster was deployed with Firm A at the time of the civil proceeding but is now deployed with Firm B, Citizens will pay Firm A. \n   •If adjuster was not deployed at the time of the proceeding but is deployed with a firm now, Citizens will pay the adjuster directly.The adjuster will need to complete\n    a W-9 Request for Taxpayer Identification Number and Certification form. The W-9 form can be found at www.citizensfla.com and typing in 'IRS W-9' into \n    the Search field.\n   •If adjuster was deployed with a firm at the time of the civil proceeding but is not with any firm at the time of invoicing/payment, we pay the firm.\n9. Firm Name - If adjuster selected Y to previous question, select firm name at time of civil proceeding from drop down list. If adjuster selected N, proceed to \n    next section."]
[]
[null,null,"Preparation and Attendance Fees"]
[null,null,null,"1. Civil Proceedings Assignment Fee – Enter one under Total Days for assignment fee.\n2. Civil Proceedings Preparation - Enter one under Total Days spent in preparation of the civil proceeding. Only one Preparation Fee per civil proceeding.\n3. Civil Proceedings Attendance - Enter total number of days spent in attendance of the civil proceeding.\n4. Comments - Enter the dates for preparation and/or attendance entries from above. Enter any additional comments applicable to the civil proceeding preparation or attendance."]
[]
[null,null,"Travel Reimbursement"]
[null,null,"Travel reimbursement is subject to vendor travel guidelines and are available online at ",null,null,null,null,null,null,null,null,"https://www.citizensfla.com/b2b."]
[null,null,null,"1. Lodging - Enter the total amount spent for lodging.\n2. Meals -  Enter the total amount spent for meals purchased during onsite preparation and attendance. \n3. Mileage - Enter the total miles traveled for onsite preparation and attendance. A total of $0.445 is paid per mile traveled.  \n4. Parking - Enter the total amount paid for parking.\n5. Tolls - If tolls are incurred during travel for onsite preparation and attendance, enter total amount.\n6. Other Expenses - Enter total amount spent for other expenses incurred during preparation and attendance that were not previously listed. Properly document other expenses in the comments box below.\n7. Comments - If travel reimbursement is applicable for the above categories, please provide a brief detailed description outlining the expenses incurred. Receipt copies are also requested to accompany fee bill. "]

{"sheet":"Fee Bill","index":1,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[41,4,48,10],[17,2,17,3],[20,2,20,4],[40,8,40,10],[27,2,27,3],[17,6,17,7],[18,6,18,7],[20,6,20,7],[18,9,18,10],[20,9,20,10],[30,9,30,10],[28,9,28,10],[29,9,29,10],[28,6,28,7],[30,4,30,5],[29,6,29,7],[4,8,4,9],[12,5,12,6],[21,2,21,10],[6,6,6,7],[4,6,4,7],[6,8,6,9],[10,3,10,5],[8,3,8,5],[13,2,13,4],[8,8,10,10],[8,6,10,7],[1,3,2,11],[31,6,31,7],[32,6,32,7],[39,8,39,9],[31,9,31,10],[32,9,32,10],[33,9,33,10],[33,6,33,7],[36,2,37,10],[34,9,34,10],[30,6,30,7],[19,9,19,10],[19,6,19,7],[14,3,14,6],[24,2,25,10],[23,2,23,8]]}
[]
[null,null,null,"Comprehensive Adjusting Services \nCivil Proceeding Preparation and Attendance Fee Bill"]
[]
[]
[null,null,"Invoice Date:",null,null,null,"Invoice #:"]
[]
[null,null,"Claim #:",null,null,null,"Policy #:"]
[]
[null,null,"Adjuster/Appraiser:",null,null,null,"Case Name:"]
[]
[null,null,"Insured:"]
[]
[null,null,"Deployed with contracted firm at time of proceeding?",null,null,"Select Y/N"]
[]
[null,null,"Firm Name:","Select Firm Name"]
[]
[]
[null,null,"Preparation and Attendance Fees",null,null,null,"Total Days",null,"Fee Amount",null,"Total"]
[null,null,"Civil Proceeding Assignment Fee",null,null,null,null,null,75,{"$f":"G19*I19","v":0}]
[null,null,"Civil Proceeding Preparation",null,null,null,null,null,625,{"$f":"G20*I20","v":0}]
[null,null,"Civil Proceeding Attendance",null,null,null,null,null,700,{"$f":"G21*I21","v":0}]
[null,null,"-Invoices not submitted within 12 months of the services requested are forfeited for failure to submit an invoice in a timely manner.\n-If the preparation meeting occurs on the same day as attendance, the Preparation Fee will be included within the Attendance Fee, for a total single payment of $700."]
[]
[null,null,"Comments:  i.e. Civil proceedings preparation date(s) and/or attendance date(s)."]
[]
[]
[]
[null,null,"Travel Reimbursement*",null,null,null,null,null,"Fee Amount",null,"Total"]
[null,null,"Lodging",null,null,null,null,null,null,{"$f":"I29","v":0}]
[null,null,"Meal(s)",null,null,null,null,null,null,{"$f":"I30","v":0}]
[null,null,"Mileage",null,"Enter Total Miles:",null,null,null,0.44500000000000001,{"$f":"G31*I31","v":0}]
[null,null,"Parking",null,null,null,null,null,null,{"$f":"I32","v":0}]
[null,null,"Tolls",null,null,null,null,null,null,{"$f":"I33","v":0}]
[null,null,"Other Expenses**",null,null,null,null,null,null,{"$f":"I34","v":0}]
[null,null,"*Travel reimbursement is subject to the Vendor Travel Reimbursement Guidelines located on Citizens’ website at:",null,null,null,null,null,null,"https://www.citizensfla.com/b2b"]
[null,null,"**If applicable, explain other expenses in box below:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Invoice Total",null,{"$f":"SUM(J19:K21,J29:K34)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(#REF!=\"yes\",O40=TRUE),\"Minimum Supplement Fee Applies\",\"\"),\"\")","v":""}]
[null,null,null,null,"Alteration of the automatically generated data on this form, before or after printing to Portable Data Format (PDF), is expressly forbidden. Submission of this invoice by the above noted firm, hereafter referred to as \"vendor\", constitutes acknowledgement and confirmation that this invoice includes:\n     1.  Fees and payments for all employees, agents, prior approved subcontractors or other \n          persons in vendor's employment who have performed work contemplated by this agreement. \n     2.  The full amount of all charges known to be owed at the time of submission of this invoice.\n     3.  Vendor will pay all above parties appropriate compensation, wages, payments, benefits or \n          the like (\"Compensation\") due as of the date of this submitted invoice."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version: 02 25 25"]

{"sheet":"Data Source","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Firms",null,null,null,null,null,"Select Y/N",null,"Contract"]
["Select Firm Name","Address 1","Street State Zip","EIN",null,null,"Select Y/N",null,"Select"]
["Accelerated Adjusting LLC",null,null,null,null,null,"Yes",null,"Appraisal"]
["Administrative Strategies LLC",null,null,null,null,null,"No",null,"Comprehensive Adjusting Services"]
["Alacrity Solutions Group, LLC"]
["Allcat Claims Service, LLC"]
["Allied American Adjusting Company LLC"]
["Alternative Claims Services Inc"]
["Barrett Claims Management, Inc"]
["Bradley Stinson and Associates Inc"]
["Burton Claim Service Inc"]
["CNC Catastrophe and National Claims"]
["Compass Adjusting Services, Inc."]
["Crawford and Company"]
["Eberl Claims Service LLC"]
["Evans Claims Service Inc"]
["FKS Insurance Services"]
["Genpact Global Limited"]
["Global Risk Solutions Inc"]
["Inspection Depot"]
["Jimmie Giles Financial LLC"]
["Leading Edge Claims Service"]
["Legacy Claim Services LLC"]
["Lozano Insurance Adjusters Inc"]
["Mid-America Catastrophe Service"]
["Pacesetter Claims Service Inc"]
["Pilot Catastrophe Services, Inc."]
["Quality Assurance Adjusting Services Inc"]
["RYZE Claim Solution LLC"]
["S and S Claims Service Inc"]
["Seibels Claims Solutions, Inc."]
["TSI Adjusters, Inc"]
["Wardlaw Claim Services, LLC"]