{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","CWA Contingency procedure","Latest submission(s)","Previous submissions","Q&A","File name"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":"Introduction","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,6,1,15],[11,0,11,4],[12,0,12,4],[0,0,0,4],[10,0,10,4],[8,0,8,4],[2,0,2,4],[3,0,3,1],[3,3,3,4],[4,0,4,1],[4,3,4,4],[6,0,6,4]]}
["① INTRODUCTION",null,null,null,null,null,"If when you open this form your spreadsheet presents a warning about having disabled editing, please select the option to Enable editing so that your spreadsheet will let you enter information in this spreadsheet and save it at the end to send to the Legal Aid Agency."]
[]
["Step 1: Please enter the Legal Aid Account Number and the Submission Period you want to report below:"]
["Legal Aid Account Number",null,null,{"$f":"IF(AND(LEN(TRIM(laa_acc_no))<>6,LEN(TRIM(laa_acc_no))<>0),\"An Account Number must consist of six characters\",\"\")","v":""}]
["Submission period",null,null,{"$f":"IF(ISNUMBER($C$5),TEXT($C$5,\"mmmm yyyy\"),\"\")","v":""}]
[]
["NB: If you have multiple account numbers to report, you'll need to complete multiple copies of this form."]
[]
["Step 2: Please read the CWA Contingency Procedure and the Q&A documents before you enter any data on the Latest submission(s) page."]
[]
["Step 3: Tell us your latest submission values in the Latest Submission(s) page"]
["Step 4: If you have Previous Submissions to report (see the notes at the top of the Previous Submissions page) complete the Previous Submssions page."]
["Step 5: Follow the email instructions listed under the heading 'Where do I send this form?' at the top of the Q&A page."]

{"sheet":"CWA Contingency procedure","index":1,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["② CWA CONTINGENCY PROCEDURE"]
[]
["CWA Contingency Procedure"]
["To ensure you receive your monthly payment we have invoked the following "]
["contingency procedure."]
[]
[]
["Due to the current unavailability of LAA online which is used to make monthly "]
["contract submissions, we are asking contract holders to complete and return this "]
["spreadsheet each month to summarise the Total Submission Value you would "]
["normally generate via LAA Online. A summary of your firm’s reported work for a "]
["given month must be reported to the Reconciliation Team before 23:59:59 on the "]
["20th of the following month (This is no different to the pattern of deadlines that "]
["applied when using LAA Online)."]
[]
["Please complete the table within the ‘Latest Submission(s)’ tab with the requested "]
["details in relation to the latest submission period. Please do not try to list individual "]
["outcome details. We require you to supply a total figure representing all of the "]
["outcomes you are reporting under a particular contract/account number in a particular "]
["month. Once LAA Online is available for use, you will need to report your submission "]
["there also as normal. This is so we can calculate the change in contract balance as a "]
["consequence of this period of reporting submissions via contingency arrangement."]
[]
["Please enter a separate line for each monthly CIVIL, CRIME LOWER or "]
["MEDIATION submission. If you have fallen behind in making submissions and your "]
["intention was to make multiple monthly submissions, please complete the relevant "]
["number of rows – please do not add multiple months together."]
[]
["Once you have completed this form save a copy of the completed spreadsheet on "]
["your computer. You must save the spreadsheet with the name ‘CMCS 0N123C "]
["2025-06’ but please replace ‘0N123C’ with your account number and replace "]
["‘2025-06’ with the year and month you are submitting for."]
[]
["Once the spreadsheet is saved, create an email with the subject line being the name "]
["of the saved spreadsheet as requested above. You can then attach a copy of the "]
["spreadsheet and email to CWASubmissions@justice.gov.uk to be processed. "]

{"sheet":"Latest submission(s)","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,0,9,6],[0,0,0,6],[2,0,2,6],[1,0,1,6]]}
[{"$f":"UPPER(_xlfn.CONCAT(\"③ \",TEXT(Introduction!$D$5,\"MMMM YYYY \"),\"contract submission(s)\"))","v":"③ CONTRACT SUBMISSION(S)"}]
[]
[{"$f":"IF(Introduction!$C$5=0,\"Latest Monthly Contract Submissions\",TEXT(Introduction!$C$5,\"MMM YYYY\") & \" Monthly Contract Submissions\")","v":"Latest Monthly Contract Submissions"}]
["Account Number","Contract Type","Total Submission Value","Submission Period","Sender Name","Sender email","Sender phone"]
[null,"Complete a total submission figure in the next column for the appropriate contract categories.","This is the total aggregate figure for the submitted Fixed Fees, Standard Fees, Hourly Rates cases including any disbursements. This figure should include VAT where applicable."]
[{"$f":"IF(Introduction!$C$4=0,\"\",laa_acc_no)","v":""},"Crime Lower",null,{"$f":"IF(LEN($B6)=0,\"\",IF(LEN(Introduction!$D$5)>0,Introduction!$D$5,\"\"))","v":""}]
[{"$f":"IF(Introduction!$C$4=0,\"\",laa_acc_no)","v":""},"Legal Help",null,{"$f":"IF(LEN($B7)=0,\"\",IF(LEN(Introduction!$D$5)>0,Introduction!$D$5,\"\"))","v":""}]
[{"$f":"IF(Introduction!$C$4=0,\"\",laa_acc_no)","v":""},"Mediation",null,{"$f":"IF(LEN($B8)=0,\"\",IF(LEN(Introduction!$D$5)>0,Introduction!$D$5,\"\"))","v":""}]
[]
["Please submit a separate submission  form in respect of each account number, rather than one submission form for  every individual contract type. Only complete for the contract type(s) your firm holds."]

{"sheet":"Previous submissions","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[3,0,3,5],[5,0,5,5]]}
["④ PREVIOUS SUBMISSIONS"]
[]
["Only complete this section if you are missing previous submission months : please contact the Reconciliation Team to confirm whether such details are required. ."]
["For the majority of submissions, completion of this page will not be required."]
[]
["Submissions for previous months (if needed)"]
["Account Number","Contract Type","Total Submission Value","Submission Period","Sender email","Sender phone"]
[null,"i.e. Legal Help or Crime Lower or Mediation. Select a type from the drop-down menu in each cell. (No need to enter the null option for blank rows.)","This is the total aggregate figure for the submitted Fixed Fees, Standard Fees, Hourly Rates cases including any disbursements. This figure should include VAT where applicable.","Enter month name in 'MM/yy' format.\n\ne.g. to enter May 2025, enter\n\n'5/2025'\n\n(without the quotation marks.)"]
[{"$f":"IF(LEN(laa_acc_no)=6,laa_acc_no,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Q&A","index":4,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,1,3,4],[45,1,45,5],[5,1,5,5],[7,1,7,5],[9,1,9,5],[37,1,37,5],[43,1,43,5],[15,1,15,4],[11,1,11,5]]}
["⑤ Q & A"]
["CMCS Version:","0.8 beta 3e (2025-06-03 / 02)"]
[]
[null,"Where do I send this form?"]
[]
[null,"Save a copy of the completed form on your machine under the name'CMCS 0N123C 2025-06' "]
[]
[null,"(Change '0N123C' and '2025-06' in the file name you use to reflect the contract number you are reporting and the submission period you are reporting.)"]
[]
[null,"Email the completed form to CWASubmissions@justice.gov.uk."]
[]
[null,"(If you have multiple copies of this form to send us because you have reports to send for multiple account numbers, it does not matter whether you attach multiple copies of this spreadsheet to the same email or send them attached to separate emails.)"]
[]
[null,"Where can I download another copy of this form?"]
[]
[null,"https://www.gov.uk/guidance/legal-aid-agency-cyber-security-incident"]
[]
[null,"Can I tell you about all my accounts on one form? "]
[]
[null,"No – please use a different form for each account number "]
[]
[null,"Should I include the values of my CRM7s? "]
[]
[null,"No - the total submission value should only include work normally billed on CWA. "]
[]
[null,"Should I include VAT? "]
[]
[null,"Yes – include VAT where applicable "]
[]
[null,"Is the deadline still 20th of each month? "]
[]
[null,"Yes "]
[]
[null,"Will I have to upload the claim to CWA when it is back up and running? "]
[]
[null,"Yes – all submissions will need to be uploaded to CWA. "]
[]
[null,"What if the total submission value I provide you is different to the value in CWA is uploaded? "]
[]
[null,"We will use the values in CWA and your payments will be adjusted accordingly. "]
[]
[null,"Which is the correct submission month? "]
[]
[null,"Submissions are made one month in arrears; your May 2025 submissions are due by the 20th June deadline. "]
[]
[null,"The Legal Aid Account Number for a Solicitor account must be entered in the format 1 digit, 1 letter, 3 digits and 1 letter. For example, 4M836T. (Please do not enter 4M836T in this form. That is not a real Account Number.)"]

{"sheet":"File name","index":5,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["RawDataFromLatestSubmission"]
[null,"AcccNumber","SubPeriod","Crime","Legal Help","Mediation"]
[null,{"$f":"IF(LEN(laa_acc_no)=0,\"Null\",laa_acc_no)","v":"Null"},"`",{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Crime Lower\")","v":1},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Legal Help\")","v":1},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Mediation\")","v":1}]
[null,{"$f":"IF(LEN(laa_acc_no)=0,\"Null\",laa_acc_no)","v":"Null"},{"$f":"IF(latest_submission_period<45804,latest_submission_period,\"Null\")","v":"00:00:00"},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Crime Lower\")","v":1},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Legal Help\")","v":1},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Mediation\")","v":1}]
[null,{"$f":"IF(LEN(laa_acc_no)=0,\"Null\",laa_acc_no)","v":"Null"},{"$f":"IF(latest_submission_period<45804,latest_submission_period,\"Null\")","v":"00:00:00"},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Crime Lower\")","v":1},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Legal Help\")","v":1},{"$f":"COUNTIFS('Latest submission(s)'!$B$6:$B$8,\"Mediation\")","v":1}]