{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Report Reconciliations","Quarterly Tax Certification","Difference Explanations","Federal to State Taxable Recon","OASDI Tax Reconciliation","HI Tax Reconciliation","tables"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"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":"Report Reconciliations","index":0,"n_rows":53,"n_cols":24,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["Report Reconciliation"]
[]
[{"$f":"agyname","v":{"$error":"#N/A"}},{"$f":"'Quarterly Tax Certification'!I4","v":"00:00:00"}]
[]
[null,"QTR COVA Fed Tax  & State"]
["FIT WH (H) Taxable",null,null,"1) ","Enter amounts from QTR COVA Federal Tax Summary and COVA State Tax Summary Reports"]
["FIT WH (H) Tax"]
["OASDI EE (D) Taxable",null,null,null,"COVA Federal Tax Summary:  Navigator -->  Payroll for North America --> U. S. Quarterly Processing --> Quarterly Reports --> COVA Federal Tax Summary"]
["OASDI EE (D) Tax"]
["Med EE (F) Taxable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE Totals"]
["Med EE (Q) Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Addl Med"]
["ADDL Med EE Taxable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ER Totals"]
["ADDL Med EE Tax"]
["OASDI ER (E) Taxable",null,null,null,"COVA State Tax Summary:  Navigator -->  Payroll for North America --> U. S. Quarterly Processing --> Quarterly Reports --> COVA State Tax Summary"]
["OASDI ER (E) Tax "]
["Med ER (F) Taxable"]
["Med ER (Q) Tax"]
["TOTAL SIT TAXABLE",{"$f":"B53","v":0},null,"TOTAL SIT TAXABLE will populate automatically when state taxable amounts are keyed below"]
["TOTAL SIT TAX ",{"$f":"C53","v":0},null,"TOTAL SIT TAX will populate automatically when state taxable amounts are keyed below"]
["VA SUI GROSS No Limit"]
["VA SUI TAXABLE"]
["VA SUI TAX "]
["EMPLOYEE OASDI TIPS"]
["EMPLOYEE HI TIPS"]
["COMPANY OASDI TIPS"]
["COMPANY Medicare TIPS"]
[]
[]
["State Tax Amounts","Taxable","Taxes"]
[]
[null,null,null,"2)","Choose a state from the drop-down box and key the taxable and tax amount for each state using the COVA State Tax Summary"]
[null,null,null,null,"Enter the State Total for each State"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total State Tax",{"$f":"SUM(B30:B52)","v":0},{"$f":"SUM(C30:C52)","v":0}]

{"sheet":"Quarterly Tax Certification","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,2],[7,8,7,9],[49,3,49,5],[1048047,6,1048047,7],[32,1,33,4],[31,1,31,4],[7,1,7,7],[1,6,1,7]]}
["Quarterly Reconcilation and Certification"]
["Calendar Year:",null,null,null,null,null,"Quarter :"]
[]
["Agency Name:",null,null,{"$f":"VLOOKUP(I4,tables!D2:F197,2)","v":{"$error":"#N/A"}},null,"HCM Ref Code",{"$f":"VLOOKUP(I4,tables!D2:F197,3)","v":{"$error":"#N/A"}},"Agy #:"]
[null,null,null,null,null,null,null,null,null,null,null,"1)  Make sure all FIT/SIT differences are listed and explained on the Differences Explanation tab."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"2)   Make sure all OASDI and Medicare differences are listed and explained on the Differences Explanation"]
[1,"Reconcile Federal Taxable to State Taxable Income.  (Details on Federal to State Taxable Recon Tab)",null,null,null,null,null,null,"Quarterly Control Totals",null,null,"tab."]
[null,"This amount must be zero",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A6","v":"FIT WH (H) Taxable"},{"$f":"'Report Reconciliations'!B6","v":0}]
[null,null,"Unexplained FIT/SIT Differences:",null,null,{"$f":"'Federal to State Taxable Recon'!E10","v":0},null,null,{"$f":"'Report Reconciliations'!A7","v":"FIT WH (H) Tax"},{"$f":"'Report Reconciliations'!B7","v":0},null,"3)  Make sure all balance adjustment forms have been completed correctly."]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A8","v":"OASDI EE (D) Taxable"},{"$f":"'Report Reconciliations'!B8","v":0}]
[2,"All negative YTD deduction balances have been identified from the following data query",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A9","v":"OASDI EE (D) Tax"},{"$f":"'Report Reconciliations'!B9","v":0},null,"4) What to Submit"]
[null,null,"V_PY_NEGATIVE_BAL - WU499-Negative Balances",null,null,null,null,null,{"$f":"'Report Reconciliations'!A10","v":"Med EE (F) Taxable"},{"$f":"'Report Reconciliations'!B10","v":0},null,"a","COVA Federal Tax Summary (Totals page only)"]
[null,"and balance adjusments have been requested to correct pr-tax refunds from prior years",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A11","v":"Med EE (Q) Tax"},{"$f":"'Report Reconciliations'!B11","v":0},null,"b","COVA State Tax Summary (Totals page for each state only) - Do not send all pages of the report"]
[null,"as required.  Negative YTD Deduction Balances have been identified on Difference Explanation tab. ",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A12","v":"ADDL Med EE Taxable"},{"$f":"'Report Reconciliations'!B12","v":0},null,"c","Negative Balances Query"]
[null,null,null,"Total # of balance adjustments required",null,null,null,null,{"$f":"'Report Reconciliations'!A13","v":"ADDL Med EE Tax"},{"$f":"'Report Reconciliations'!B13","v":0},null,null," •    Navigator > Reporting Tools > Query > Query Viewer > V_PY_Negative_Bal"]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A14","v":"OASDI ER (E) Taxable"},{"$f":"'Report Reconciliations'!B14","v":0},null,"d","COVA Error Listing Report"]
[3,"Renconcile OASDI Taxes: (Details on OASDI Tax Reconciliation Tab)",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A15","v":"OASDI ER (E) Tax "},{"$f":"'Report Reconciliations'!B15","v":0},null,null," •   Navigator > Payroll for North America > U.S. Annual Processing > Audit and Errors Report > COVA Error Listing"]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A16","v":"Med ER (F) Taxable"},{"$f":"'Report Reconciliations'!B16","v":0},null,"e","Signed Certification"]
[null,null,"Total Invalid Employee OASDI Tax Differences:",null,null,{"$f":"'OASDI Tax Reconciliation'!D13","v":0},null,null,{"$f":"'Report Reconciliations'!A17","v":"Med ER (Q) Tax"},{"$f":"'Report Reconciliations'!B17","v":0},null,"f","Reports Reconciliations Tab"]
[null,null,"Total Invalid Company OASDI Tax Differences:",null,null,{"$f":"'OASDI Tax Reconciliation'!I13","v":0},null,null,{"$f":"'Report Reconciliations'!A18","v":"TOTAL SIT TAXABLE"},{"$f":"'Report Reconciliations'!B18","v":0},null,"g","Differences Explanations Tab (only if there are differences)"]
[null,null,"Total Difference Employee and Company OASDI Taxable:",null,null,{"$f":"'OASDI Tax Reconciliation'!K3","v":0},null,null,{"$f":"'Report Reconciliations'!A19","v":"TOTAL SIT TAX "},{"$f":"'Report Reconciliations'!B19","v":0},null,"h","Federal to State Taxable Recon Tab"]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A20","v":"VA SUI GROSS No Limit"},{"$f":"'Report Reconciliations'!B20","v":0},null,"i","OASDI Tax Reconciliation Tab"]
[4,"Reconcile MEDICARE Taxes: (Details on MEDICARE Tax Reconciliation Tab)",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A21","v":"VA SUI TAXABLE"},{"$f":"'Report Reconciliations'!B21","v":0},null,"j","HI Tax Reconcilation Tab"]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A22","v":"VA SUI TAX "},{"$f":"'Report Reconciliations'!B22","v":0},null,"k","Balance Adjustments Forms and Balance Review Screens"]
[null,null,"Total Invalid Employee MEDICARE Tax Differences:",null,null,{"$f":"'HI Tax Reconciliation'!D23","v":0},null,null,{"$f":"'Report Reconciliations'!A23","v":"EMPLOYEE OASDI TIPS"},{"$f":"'Report Reconciliations'!B23","v":0},null,"NOTE:","Please try to scan all required documents into one file.  It's not required but will be very helpful to DOA."]
[null,null,"Total Invalid Company MEDICARE Tax Differences:",null,null,{"$f":"'HI Tax Reconciliation'!I23","v":0},null,null,{"$f":"'Report Reconciliations'!A24","v":"EMPLOYEE HI TIPS"},{"$f":"'Report Reconciliations'!B24","v":0}]
[null,null,"Total Difference Employee and Company MEDICARE Taxable:",null,null,{"$f":"'OASDI Tax Reconciliation'!K3","v":0},null,null,{"$f":"'Report Reconciliations'!A25","v":"COMPANY OASDI TIPS"},{"$f":"'Report Reconciliations'!B25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A26","v":"COMPANY Medicare TIPS"},{"$f":"'Report Reconciliations'!B26","v":0}]
[5,"Balance Adjustments (Enter Exceptions on Difference Explanations Tab)"]
[]
[null,"Number of Adjustments Requested:"]
[null,"Number of Adjustments That Will Be Corrected Through Payroll:"]
[]
[]
[6,"AFTER all differences above are accounted for, press the \"Print\" button below."]
[null,"Submit all resulting pages to State Payroll Operations with the first Company Total page of the Report 56"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Agency Fiscal Officer Signature:",null,null,null,null,null,null,"Date:"]
[]
["Printed Name:",null,null,null,null,null,null,"Phone #:"]

{"sheet":"Difference Explanations","index":2,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[53,4,53,8],[54,4,54,8],[55,4,55,8],[40,4,40,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[38,4,38,8],[39,4,39,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[17,4,17,8],[18,4,18,8],[56,4,56,8],[47,4,47,8],[48,4,48,8],[49,4,49,8],[50,4,50,8],[51,4,51,8],[52,4,52,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,4,46,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[11,4,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[15,4,15,8],[16,4,16,8],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[1048125,8,1048125,9],[5,0,5,9],[62,2,62,3],[62,4,62,8],[63,2,63,3],[63,4,63,8],[60,2,60,3],[60,4,60,8],[61,2,61,3],[61,4,61,8],[58,2,58,3],[58,4,58,8],[59,2,59,3],[59,4,59,8],[10,2,10,3],[10,4,10,8],[57,2,57,3],[57,4,57,8],[11,2,11,3],[0,0,0,9],[8,2,8,3],[8,4,8,8],[9,2,9,3],[9,4,9,8],[6,2,6,3],[6,4,6,8],[7,2,7,3],[7,4,7,8],[3,1,3,4]]}
["CIPPS Quarterly Reconcilation and Certification"]
["Calendar Year:",{"$f":"calyear","v":0},null,null,null,null,null,null,"Quarter:",{"$f":"qtrend","v":"00:00:00"}]
[]
["Agency Name:",{"$f":"'Quarterly Tax Certification'!D4","v":{"$error":"#N/A"}},null,null,null,"HCM Ref Code:",{"$f":"'Quarterly Tax Certification'!G4","v":{"$error":"#N/A"}},null,"Agy #:",{"$f":"'Quarterly Tax Certification'!I4","v":"00:00:00"}]
[]
["Please explain invalid exceptions discovered this quarter and how they will be corrected below - include deductions with negative YTD amounts"]
["Employee ID:","Amount of Difference","Correction Method:",null,"Explanation:",null,null,null,null,"Source:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(A8:A64)","v":0},{"$f":"COUNTA(A8:A64)","v":0},null,{"$f":"COUNTA(B8:B64)","v":0}]

{"sheet":"Federal to State Taxable Recon","index":3,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[23,10,23,11],[24,10,24,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[26,2,26,3],[13,2,13,3],[12,2,12,3],[11,2,11,3],[32,2,32,3],[31,2,31,3],[30,2,30,3],[29,2,29,3],[28,2,28,3],[27,2,27,3],[36,2,36,3],[35,2,35,3],[34,2,34,3],[33,2,33,3],[35,0,35,1],[36,0,36,1],[33,0,33,1],[34,0,34,1],[31,0,31,1],[32,0,32,1],[29,0,29,1],[30,0,30,1],[28,0,28,1],[13,0,13,1],[26,0,26,1],[11,0,11,1],[12,0,12,1],[27,0,27,1]]}
[null,{"$f":"agyname","v":{"$error":"#N/A"}},null,{"$f":"'Quarterly Tax Certification'!I4","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,1,"Invalid differences between FIT and SIT Taxable can result when the payroll record is established incorrectly."]
["QTR COVA FED TAX Report - FIT Taxable:",null,null,null,{"$f":"'Report Reconciliations'!B6","v":0},null,null,null,2,"Valid differences occur when the employee lives and works in another state that does not withhold state taxes."]
["QTR COVA STATE TAX Report - SIT Taxable:",null,null,null,{"$f":"'Report Reconciliations'!B18","v":0},null,null,null,3,"Review QTR COVA STATE TAX report to find differences that exist between the FIT and SIT Taxable.  If the employee works in a state"]
[null,null,null,null,null,null,null,null,null,"that is listed in the  in the table below, the difference is valid and can be listed in the table."]
["Difference:",null,null,null,{"$f":"E4-E3","v":0},null,null,null,null,"Enter the validated difference as a positive amount in the table."]
[]
["Total Explained Out of State Differences:",null,null,null,{"$f":"G38","v":0}]
[]
["Unexplained FIT/SIT Differences:",null,null,null,{"$f":"E6-E8","v":0}]
[]
["Employee ID:",null,"State:",null,"Enter Validated Difference As a Positive Amount:"]
[null,null,null,null,null,null,null,null,null,"REMINDER: Alaska, Florida, Nevada, New Hampshire, South Dakota, Tennessee, Texas, Washington and Wyoming have no state"]
[null,null,null,null,null,null,null,null,null,null,"withholding.  Therefore, the difference between the federal and state taxable will be the entire amount of federal"]
[null,null,null,null,null,null,null,null,null,null,"taxable income.  However, in the case of Pennsylvania, there is state withholding but they do not follow the same rules"]
[null,null,null,null,null,null,null,null,null,null,"as the federal income.  See chart below for the differences:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Federal","PA"]
[null,null,null,null,null,null,null,null,null,null,"Imputed Life",null,"taxable","non-taxable"]
[null,null,null,null,null,null,null,null,null,null,"Dependent Care",null,"non-taxable","taxable"]
[null,null,null,null,null,null,null,null,null,null,"Parking",null,"non-taxable","taxable"]
[null,null,null,null,null,null,null,null,null,null,"Transportation",null,"non-taxable","taxable"]
[null,null,null,null,null,null,null,null,null,null,"Retirement",null,"non-taxable","taxable"]
[null,null,null,null,null,null,null,null,null,null,"457 - Deferred Comp",null,"non-taxable","taxable"]
[null,null,null,null,null,null,null,null,null,null,"457 - Hybrid Vol",null,"non-taxable","taxable"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"COUNTA(C13:D37)","v":0},null,{"$f":"SUM(E13:E37)","v":0}]

{"sheet":"OASDI Tax Reconciliation","index":4,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[58,0,58,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[25,0,25,1],[26,0,26,1],[28,4,28,5],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[28,2,28,3],[27,2,27,3],[27,4,27,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[53,2,53,3],[53,4,53,5],[19,0,19,8],[51,2,51,3],[51,4,51,5],[52,2,52,3],[52,4,52,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[35,2,35,3],[36,2,36,3],[37,2,37,3],[29,4,29,5],[30,4,30,5],[49,2,49,3],[49,4,49,5],[50,2,50,3],[50,4,50,5],[34,4,34,5],[35,4,35,5],[48,2,48,3],[48,4,48,5],[18,0,18,8],[21,0,21,1],[21,2,21,3],[21,4,21,5],[20,0,20,1],[20,2,20,3],[20,4,20,5],[39,2,39,3],[43,2,43,3],[43,4,43,5],[41,2,41,3],[41,4,41,5],[42,2,42,3],[42,4,42,5],[22,2,22,3],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[29,2,29,3],[22,0,22,1],[23,0,23,1],[24,0,24,1],[45,2,45,3],[45,4,45,5],[46,2,46,3],[46,4,46,5],[30,2,30,3],[47,2,47,3],[47,4,47,5],[44,2,44,3],[44,4,44,5],[40,2,40,3],[40,4,40,5],[31,2,31,3],[32,2,32,3],[31,4,31,5],[32,4,32,5],[33,2,33,3],[34,2,34,3],[33,4,33,5],[38,2,38,3]]}
[null,{"$f":"agyname","v":{"$error":"#N/A"}},null,{"$f":"'Quarterly Tax Certification'!I4","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"Difference"]
["QTR COVA FED TAX  - EE OASDI Taxable",null,null,{"$f":"'Report Reconciliations'!B8","v":0},null,"AGY QTR ER OASDI Taxable",null,null,{"$f":"'Report Reconciliations'!B14","v":0},null,{"$f":"I3-D3","v":0}]
["Computed EE OASDI Tax (6.2%)",null,null,{"$f":"D3*0.062","v":0},null,"Computed ER OASDI Tax (6.2%)",null,null,{"$f":"I3*0.062","v":0}]
["QTR COVA FED TAX - Actual EE OASDI Tax",null,null,{"$f":"'Report Reconciliations'!B9","v":0},null,"Actual Company OASDI Tax U092",null,null,{"$f":"'Report Reconciliations'!B15","v":0}]
[]
["Difference:",null,null,{"$f":"D4-D5","v":0}]
["Total Valid Employee Uncollected OASDI:",null,null,{"$f":"H60","v":0}]
[]
["OASDI Tax Difference:",null,null,{"$f":"D7-D8","v":0},null,"Company OASDI Tax Difference:",null,null,{"$f":"I4-I5","v":0}]
["Rounding Tolerance:",null,null,0.5,null,"Rounding Tolerance:",null,null,0.5]
[]
["Total Invalid Employee OASDI Differences:",null,null,{"$f":"IF(D11>ABS(D10),0,D10)","v":0},null,"Total Invalid Company OASDI Differences:",null,null,{"$f":"IF(I11>ABS(I10),0,I10)","v":0}]
[]
[]
[]
[]
[]
["Annual Reporting -Error Listing (VPYR0261) - include all entries pertaining to OASDI Calc Tax <> Tax Balance"]
["Amounts Shown As Invalid Uncollected OASDI Must Be Charged to the Agency - Contact payroll@doa.virginia.gov For Assistance"]
["Employee ID:",null,"Name:",null,"Reason For Uncollected FICA:",null,"Amount Uncollected OASDI","Valid Uncollected OASDI - No Correction Needed","Invalid Uncollected OASDI - Correction Required"]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E22,\"Imputed Life\",G22)","v":0},{"$f":"SUMIF(E22,\"other\",G22)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E24,\"Imputed Life\",G24)","v":0},{"$f":"SUMIF(E24,\"other\",G24)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E41,\"Imputed Life\",G41)","v":0},{"$f":"SUMIF(E41,\"other\",G41)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G22:G59)","v":0},{"$f":"SUM(H22:H59)","v":0},{"$f":"SUM(I22:I59)","v":0}]

{"sheet":"HI Tax Reconciliation","index":5,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[32,4,32,5],[31,4,31,5],[30,4,30,5],[29,0,29,8],[28,0,28,8],[32,0,32,1],[32,2,32,3],[34,2,34,3],[35,2,35,3],[31,0,31,1],[31,2,31,3],[30,0,30,1],[30,2,30,3],[34,0,34,1],[35,0,35,1],[38,0,38,1],[33,0,33,1],[33,2,33,3],[58,4,58,5],[57,4,57,5],[56,4,56,5],[55,4,55,5],[54,4,54,5],[53,4,53,5],[52,4,52,5],[33,4,33,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[67,4,67,5],[66,4,66,5],[65,4,65,5],[64,4,64,5],[63,4,63,5],[62,4,62,5],[61,4,61,5],[60,4,60,5],[59,4,59,5],[70,0,70,1],[70,2,70,3],[68,0,68,1],[68,2,68,3],[69,0,69,1],[69,2,69,3],[70,4,70,5],[69,4,69,5],[68,4,68,5],[63,0,63,1],[63,2,63,3],[60,0,60,1],[60,2,60,3],[61,0,61,1],[61,2,61,3],[66,0,66,1],[66,2,66,3],[67,0,67,1],[67,2,67,3],[64,0,64,1],[64,2,64,3],[65,0,65,1],[65,2,65,3],[58,0,58,1],[58,2,58,3],[59,0,59,1],[59,2,59,3],[56,0,56,1],[56,2,56,3],[57,0,57,1],[57,2,57,3],[62,0,62,1],[62,2,62,3],[54,0,54,1],[54,2,54,3],[55,0,55,1],[55,2,55,3],[52,0,52,1],[52,2,52,3],[53,0,53,1],[53,2,53,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[44,2,44,3],[42,0,42,1],[43,0,43,1],[36,0,36,1],[37,0,37,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[39,0,39,1],[40,0,40,1],[41,0,41,1]]}
[null,{"$f":"agyname","v":{"$error":"#N/A"}},null,{"$f":"'Quarterly Tax Certification'!I4","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,"Difference"]
["QTR COVA FED TAX  - EE MED Taxable",null,null,{"$f":"'Report Reconciliations'!B10","v":0},null,"AGY QTR Control Totals  - ER MED Taxable",null,null,{"$f":"'Report Reconciliations'!B16","v":0},null,{"$f":"I3-D3","v":0}]
["Computed EE MED Tax (1.45%)",null,null,{"$f":"D3*0.0145","v":0},null,"Computed ER MED Tax (1.45%)",null,null,{"$f":"I3*0.0145","v":0}]
["QTR COVA FED TAX - Actual EE MED Tax",null,null,{"$f":"'Report Reconciliations'!B11","v":0},null,"QTR COVA FED TAX - Actual ER MED Tax",null,null,{"$f":"'Report Reconciliations'!B17","v":0}]
[null,null,null,{"$f":"D4-D5","v":0},null,null,null,null,{"$f":"I4-I5","v":0}]
[]
["QTR COVA FED TAX - EE ADDL MED Taxable Over 200K",null,null,{"$f":"'Report Reconciliations'!B12","v":0}]
["Computed HI Surtax (.9%)",null,null,{"$f":"D8*0.009","v":0}]
["QTR COVA FED TAX - Actual EE ADDL MED Tax",null,null,{"$f":"'Report Reconciliations'!B13","v":0}]
[null,null,null,{"$f":"D9-D10","v":0}]
[]
["Total Computed Employee HI Tax",null,null,{"$f":"D4+D9","v":0}]
["Actual Employee HI Tax",null,null,{"$f":"D5+D10","v":0}]
[]
[]
["Difference:",null,null,{"$f":"D13-D14","v":0}]
["Total Valid Employee Uncollected HI:",null,null,{"$f":"H72","v":0}]
[]
["Employee MED Tax Difference:",null,null,{"$f":"D17-D18","v":0},null,"Employer MED Tax Difference:",null,null,{"$f":"I4-I5","v":0}]
["Rounding Tolerance:",null,null,0.5,null,"Rounding Tolerance:",null,null,0.5]
[]
["Total Invalid Employee HI Differences:",null,null,{"$f":"IF(D21>ABS(D20),0,D20)","v":0},null,"Total Invalid Company HI Differences:",null,null,{"$f":"IF(I21>ABS(I20),0,I20)","v":0}]
[]
[]
[]
[]
[]
["Annual Reporting -Error Listing (VPYR0261) - include all entries pertaining to Medicare Calc Tax <> Tax Balance"]
["Amounts Shown As Invalid Uncollected OASDI Must Be Charged to the Agency - Contact payroll@doa.virginia.gov For Assistance"]
["Employee ID:",null,"Name:",null,"Reason For Uncollected FICA:",null,"Amount Uncollected HI","Valid Uncollected HI No Correction Needed","Invalid Uncollected HI Correction Required"]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E32,\"Imputed Life\",G32)","v":0},{"$f":"SUMIF(E32,\"other\",G32)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E33,\"Imputed Life\",G33)","v":0},{"$f":"SUMIF(E33,\"other\",G33)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E34,\"Imputed Life\",G34)","v":0},{"$f":"SUMIF(E34,\"other\",G34)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E35,\"Imputed Life\",G35)","v":0},{"$f":"SUMIF(E35,\"other\",G35)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E53,\"Imputed Life\",G53)","v":0},{"$f":"SUMIF(E53,\"other\",G53)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G32:G71)","v":0},{"$f":"SUM(H32:H71)","v":0},{"$f":"SUM(I32:I71)","v":0}]

{"sheet":"tables","index":6,"n_rows":197,"n_cols":13,"rows_kept":197,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Year","Quarter",null,"State"]
[null,null,null,"00100","Senate of Virginia","SOV",null,2022,"1st Quarter",null,"Alabama - AL",null,"Negative  Balances Report"]
[null,null,null,"00101","Virginia House of Delegates","DEL",null,2023,"2nd Quarter",null,"Alaska - AK",null,"COVA Error Listing Report"]
[null,null,null,"00103","Magistrate System","MAG",null,2024,"3rd Quarter",null,"Arizona - AZ",null,"Federal to State Recon"]
[null,null,null,"00107","Division of Legislative Services","DLS",null,2025,"4th Quarter",null,"Arkansas - AK",null,"OASDI Tax Recon"]
[null,null,null,"00109","Division of Legislative Automated Systems","LAS",null,2026,null,null,"California - CA",null,"HI Tax Recon"]
[null,null,null,"00110","Joint Legislative Audit and Review Commission","ARC",null,2027,null,null,"Colorado - CO"]
[null,null,null,"00111","Supreme Court","SUP",null,2028,null,null,"Connecticut - CT"]
[null,null,null,"00112","Judicial Inquiry and Review  Commission","JIR",null,2029,null,null,"Delaware - DE"]
[null,null,null,"00113","Circuit Courts","CCV",null,2030,null,null,"District of Columbia - D.C."]
[null,null,null,"00114","General District Courts","GDC",null,2031,null,null,"Florida - FL"]
[null,null,null,"00115","Juvenile and Domestic Relations District Courts","JDR",null,2032,null,null,"Georgia - GA"]
[null,null,null,"00116","Combined District Courts","CDC",null,2033,null,null,"Hawaii - HI"]
[null,null,null,"00117","Virginia State Bar","VSB",null,2034,null,null,"Idaho - ID"]
[null,null,null,"00119","Office of Lieutenant Governor","LTG",null,2035,null,null,"Illinois - IL"]
[null,null,null,"00121","Office of the Governor","GOV",null,2036,null,null,"Indiana - IN"]
[null,null,null,"00122","Department of Planning and Budget","DPB",null,2037,null,null,"Iowa - IA"]
[null,null,null,"00123","Department of Military Affairs","DMA",null,2038,null,null,"Kansas - KS"]
[null,null,null,"00125","Court of Appeals of Virginia","CAV",null,2039,null,null,"Kentucky - KY"]
[null,null,null,"00127","Department of Emergency Management","DEM",null,2040,null,null,"Louisiana - LA"]
[null,null,null,"00128","Virginia Veterans Care Center","VVC",null,null,null,null,"Maine - ME"]
[null,null,null,"00129","Department of Human Resource Management","HRM",null,null,null,null,"Maryland - MD"]
[null,null,null,"00132","Department of Elections","SBE",null,null,null,null,"Massachusetts - MA"]
[null,null,null,"00133","Auditor of Public Accounts","APA",null,null,null,null,"Michigan - MI"]
[null,null,null,"00136","Virginia Information Technologies Agency","ITA",null,null,null,null,"Minnesota - MN"]
[null,null,null,"00140","Department of Criminal Justice Services","CJS",null,null,null,null,"Mississippi - MS"]
[null,null,null,"00141","Attorney General and Department of Law","OAG",null,null,null,null,"Missouri - MO"]
[null,null,null,"00143","Division of Debt Collection","DDC",null,null,null,null,"Montana - MT"]
[null,null,null,"00146","The Science Museum of Virginia","SMV",null,null,null,null,"Nebraska - NE"]
[null,null,null,"00147","Office of the State Inspector General","OIG",null,null,null,null,"Nevada - NV"]
[null,null,null,"00148","Virginia Commission for the Arts","VCA",null,null,null,null,"New Hampshire - NH"]
[null,null,null,"00151","Department of Accounts","DOA",null,null,null,null,"New Jersey - NJ"]
[null,null,null,"00152","Department of the Treasury","TRD",null,null,null,null,"New Mexico - NM"]
[null,null,null,"00154","Department of Motor Vehicles","DMV",null,null,null,null,"New York - NY"]
[null,null,null,"00156","Department of State Police","DSP",null,null,null,null,"North Carolina - NC"]
[null,null,null,"00157","Compensation Board","CBD",null,null,null,null,"North Dakota - ND"]
[null,null,null,"00158","Virginia Retirement System","VRS",null,null,null,null,"Ohio - OH"]
[null,null,null,"00160","Virginia Criminal Sentencing Commission","CSC",null,null,null,null,"Oklahoma - OK"]
[null,null,null,"00161","Department of Taxation","TAX",null,null,null,null,"Oregon - OR"]
[null,null,null,"00162","Department of Accounts Transfer Payments","ATP",null,null,null,null,"Pennsylvania - PA"]
[null,null,null,"00164","Commonwealth of Virginia - VMFPA","VMF",null,null,null,null,"Rhode Island - RI"]
[null,null,null,"00165","Department of Housing and Community Development","HCD",null,null,null,null,"South Carolina - SC"]
[null,null,null,"00166","Secretary of the Commonwealth","SOC",null,null,null,null,"South Dakota - SD"]
[null,null,null,"00171","State Corporation Commission","SCC",null,null,null,null,"Tennessee - TN"]
[null,null,null,"00172","Virginia Lottery","VAL",null,null,null,null,"Texas - TX"]
[null,null,null,"00174","Virginia College Savings Plan","CSP",null,null,null,null,"Utah - UT"]
[null,null,null,"00180","Secretary of Administration","SOA",null,null,null,null,"Vermont - VT"]
[null,null,null,"00181","Department of Labor and Industry","DLI",null,null,null,null,"Virginia - VA"]
[null,null,null,"00182","Virginia Employment Commission","VEC",null,null,null,null,"Washington - WA"]
[null,null,null,"00183","Secretary of Natural Resources","SNR",null,null,null,null,"West Virginia - WV"]
[null,null,null,"00185","Secretary of Education","SOE",null,null,null,null,"Wisconsin - WI"]
[null,null,null,"00186","Secretary of Transportation","STO",null,null,null,null,"Wyoming - WY"]
[null,null,null,"00187","Secretary of Public Safety and Homeland Security","SPS"]
[null,null,null,"00188","Secretary of Health and Human Resources","HHR"]
[null,null,null,"00190","Secretary of Finance","FIN"]
[null,null,null,"00191","Virginia Workers' Compensation Commission","VWC"]
[null,null,null,"00192","Secretary of Commerce and Trade","SCT"]
[null,null,null,"00193","Secretary of Agriculture and Forestry","SAF"]
[null,null,null,"00194","Department of General Services","DGS"]
[null,null,null,"00195","Secretary of Labor","SOL"]
[null,null,null,"00199","Department of Conservation and Recreation","DCR"]
[null,null,null,"00200","Office of Children's Services","CSA"]
[null,null,null,"00201","Department of Education, Central Office Operations","DOE"]
[null,null,null,"00202","The Library of Virginia","LVA"]
[null,null,null,"00203","Wilson Workforce and Rehabilitation Center","WWR"]
[null,null,null,"00212","Virginia State University","VSU"]
[null,null,null,"00213","Norfolk State University","NSU"]
[null,null,null,"00214","Longwood University","LWU"]
[null,null,null,"00215","University of Mary Washington","UMW"]
[null,null,null,"00218","Virginia School for the Deaf and the Blind","SDB"]
[null,null,null,"00222","Department of Professional  and Occupational Regulation","POR"]
[null,null,null,"00223","Department of Health Professions","DHP"]
[null,null,null,"00226","Board of Accountancy","BOA"]
[null,null,null,"00233","Virginia Board of Bar Examiners","BBE"]
[null,null,null,"00234","Cooperative Extension and Agricultural Research Services","VSC"]
[null,null,null,"00238","Virginia Museum of Fine Arts","MFA"]
[null,null,null,"00239","Frontier Culture Museum of Virginia","FCM"]
[null,null,null,"00241","Richard Bland College","RBC"]
[null,null,null,"00242","Christopher Newport University","CNU"]
[null,null,null,"00245","State Council of Higher Education for Virginia","SCH"]
[null,null,null,"00261","Virginia Community College System","COF"]
[null,null,null,"00262","Department for Aging and Rehabilitative Services","ARS"]
[null,null,null,"00263","Virginia Rehabilitation Center for the Blind and Vision Impaired","RCB"]
[null,null,null,"00270","VCCS - Shared Services Center","SCC"]
[null,null,null,"00275","New River Community College","NRV"]
[null,null,null,"00276","Southside Virginia Community College","SSV"]
[null,null,null,"00277","Paul D. Camp Community College","PDC"]
[null,null,null,"00278","Rappahannock Community College","RAP"]
[null,null,null,"00279","Danville Community College","DAN"]
[null,null,null,"00280","Northern Virginia Community College","NVA"]
[null,null,null,"00282","Piedmont Virginia Community College","PVA"]
[null,null,null,"00283","J. Sargeant Reynolds Community College","JSR"]
[null,null,null,"00284","Eastern Shore Community College","ESC"]
[null,null,null,"00285","Patrick Henry Community College","PHC"]
[null,null,null,"00286","Virginia Western Community College","VAW"]
[null,null,null,"00287","Dabney S. Lancaster Community College","DSL"]
[null,null,null,"00288","Wytheville Community College","WYT"]
[null,null,null,"00290","John Tyler Community College","JTC"]
[null,null,null,"00291","Blue Ridge Community College","BRC"]
[null,null,null,"00292","Central Virginia Community College","CVA"]
[null,null,null,"00293","Thomas Nelson Community College","TNC"]
[null,null,null,"00294","Southwest Virginia Community College","SWV"]
[null,null,null,"00295","Tidewater Community College","TDW"]
[null,null,null,"00296","Virginia Highlands Community College","VAH"]
[null,null,null,"00297","Germanna Community College","GER"]
[null,null,null,"00298","Lord Fairfax Community College","LFF"]
[null,null,null,"00299","Mountain Empire Community College","MTN"]
[null,null,null,"00301","Department of Agriculture and Consumer Services","ACS"]
[null,null,null,"00330","Virginia Israel Advisory Board","VIB"]
[null,null,null,"00350","Department of Small Business and Supplier Diversity (VSBSD)","SBD"]
[null,null,null,"00400","Jamestown-Yorktown Commemorations","JYC"]
[null,null,null,"00402","Marine Resources Commission","MRC"]
[null,null,null,"00403","Department of Wildlife Resources","GIF"]
[null,null,null,"00405","Virginia Racing Commission","VRC"]
[null,null,null,"00409","Department of Mines, Minerals, and Energy","MME"]
[null,null,null,"00411","Department of Forestry","DOF"]
[null,null,null,"00413","Commission on VASAP","ASA"]
[null,null,null,"00417","Gunston Hall","GHL"]
[null,null,null,"00423","Department of Historic Resources","DHR"]
[null,null,null,"00425","Jamestown-Yorktown Foundation","JYF"]
[null,null,null,"00440","Department of Environmental Quality","DEQ"]
[null,null,null,"00454","Secretary of Veterans and Defense Affairs","SVA"]
[null,null,null,"00501","VDOT - Central Office","DOT"]
[null,null,null,"00505","Department of Rail and Public Transportation","RPT"]
[null,null,null,"00506","Motor Vehicle Dealer Board","MVD"]
[null,null,null,"00601","Department of Health","VDH"]
[null,null,null,"00602","Department of Medical Assistance Services","MAS"]
[null,null,null,"00606","Virginia Board for People with Disabilities","BPD"]
[null,null,null,"00701","Department of Corrections, Central Activities","DOC"]
[null,null,null,"00702","Virginia Department for the Blind and Vision Impaired","BVI"]
[null,null,null,"00703","Central State Hospital","CSH"]
[null,null,null,"00704","Eastern State Hospital","ESH"]
[null,null,null,"00705","Southwestern Virginia Mental Health Institute","SWH"]
[null,null,null,"00706","Western State Hospital","WSH"]
[null,null,null,"00707","Central Virginia Training Center","CVT"]
[null,null,null,"00708","Commonwealth Center for Children and Adolescents","CCA"]
[null,null,null,"00711","Virginia Correctional Enterprises","VCE"]
[null,null,null,"00716","Virginia Correctional Center for Women","CCW"]
[null,null,null,"00718","Bland Correction Center","BCC"]
[null,null,null,"00720","Department of Behavioral Health and Developmental Services","BHD"]
[null,null,null,"00723","Southeastern Virginia Training Center","SET"]
[null,null,null,"00724","Catawba Hospital","CAT"]
[null,null,null,"00728","Northern Virginia Mental Health Institute","NVH"]
[null,null,null,"00729","Piedmont Geriatric Hospital","PGH"]
[null,null,null,"00735","Wallens Ridge State Prison","WRP"]
[null,null,null,"00737","St. Brides Correctional Center","SBR"]
[null,null,null,"00739","Southern Virginia Mental Health Institute","SVH"]
[null,null,null,"00741","Red Onion State Prison","ROP"]
[null,null,null,"00742","Employee Relations and Training Division","ERT"]
[null,null,null,"00743","Fluvanna Correctional Center for Women","FWC"]
[null,null,null,"00745","Nottoway Correctional Center","NCC"]
[null,null,null,"00747","Marion Correctional Treatment Center","MAR"]
[null,null,null,"00748","Hiram W. Davis Medical Center","HDM"]
[null,null,null,"00749","Buckingham Correctional Center","BUC"]
[null,null,null,"00751","Department for the Deaf and Hard-of-Hearing","DHH"]
[null,null,null,"00752","State Farm Complex","DMC"]
[null,null,null,"00753","Deerfield Correctional Complex","DFC"]
[null,null,null,"00754","Augusta Correctional Center","ACC"]
[null,null,null,"00756","Division of Institutions","DOI"]
[null,null,null,"00757","Western Region Correctional Field Units","WFU"]
[null,null,null,"00761","Baskerville Correctional Center","EFU"]
[null,null,null,"00765","Department of Social Services","DSS"]
[null,null,null,"00766","Virginia Parole Board","VPB"]
[null,null,null,"00767","Division of Community Corrections","DCC"]
[null,null,null,"00768","Keen Mountain Correctional Center","KMC"]
[null,null,null,"00769","Greensville Correctional Center","GCC"]
[null,null,null,"00770","Dillwyn Correctional Center","DWC"]
[null,null,null,"00771","Indian Creek Correctional Center","ICC"]
[null,null,null,"00772","Haynesville Correctional Center","HCC"]
[null,null,null,"00773","Coffeewood Correctional Center","CCC"]
[null,null,null,"00774","Lunenburg Correctional Center","LCC"]
[null,null,null,"00775","Pocahontas State Correctional Center","PSC"]
[null,null,null,"00776","Greenrock Correctional Center","GRC"]
[null,null,null,"00777","Department of Juvenile Justice","DJJ"]
[null,null,null,"00778","Department of Forensic Science","DFS"]
[null,null,null,"00779","Sussex I and Sussex II Prison Complex","77900"]
[null,null,null,"00785","River North Correctional Center","RNC"]
[null,null,null,"00794","Virginia Center for  Behavioral Rehabilitation","CBR"]
[null,null,null,"00841","Department of Aviation","DAV"]
[null,null,null,"00848","Virginia Indigent Defense Commission","IDC"]
[null,null,null,"00851","Tobacco Region Revitalization Commission","TOB"]
[null,null,null,"00852","Virginia Foundation for Healthy Youth","FHY"]
[null,null,null,"00856","Virginia Opioid Abatement Authority","85600"]
[null,null,null,"00882","Behavioral Health Commission","88200"]
[null,null,null,"00912","Department of Veterans Services","DVS"]
[null,null,null,"00913","Virginia Veterans Services Foundation","VSF"]
[null,null,null,"00922","Sitter-Barfoot Veterans Care Center","SBV"]
[null,null,null,"00937","Southern Virginia Center for Higher Education","SVE"]
[null,null,null,"00938","New College Institute","NCI"]
[null,null,null,"00942","Virginia Museum of Natural History","MNH"]
[null,null,null,"00948","Southwest Virginia Higher Education Center","SWE"]
[null,null,null,"00957","Commonwealth's Attorneys' Services Council","CAS"]
[null,null,null,"00960","Department of Fire Programs","DFP"]
[null,null,null,"00961","Division of Capitol Police","DCP"]
[null,null,null,"00977","Virginia Cannabis Control Authority","VCC"]
[null,null,null,"00997","DOA State Payroll Operations","DOAS"]
[null,null,null,"00999","Department of Alcoholic Beverage Control","ABC"]