{"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":2,"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":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"PAT QTRLY CONTROL TOTALS YTD","U092 10/33 RECON SUMMARY - TAX MASTER FILE","Report 56","DIFF QTRLY CNTROL AND U092","DIFF QTRLY CNTROL AND REPORT 56"]
["GROSS PAY",null,null,null,{"$f":"B2-C2","v":0},{"$f":"B2-D2","v":0},null,null,1,"Enter the values from the respective reports in the blue fields on the right."]
["EIC PAYMENT",null,null,null,0,{"$f":"B3-D3","v":0},null,null,2,"Click the Tax Quarterly Certification to view unexplained differences"]
["FIT TAXABLE",null,null,null,0,0,null,null,3,"Click the Difference Explanations tab to enter exceptions"]
["FIT NON TAXABLE",null,null,null,0,0]
["FIT TAX ",null,null,null,0,0]
["EMPLOYEE OASDI TAXABLE",null,null,null,0,0]
["EMPLOYEE OASDI TAX ",null,null,null,0,0,null,null,null,"When there are differences between the PAT QTRLY CONTROL TOTALS and the U092/Report 56"]
["EMPLOYEE HI TAXABLE",null,null,null,0,0,null,null,null,"check for the following:"]
["EMPLOYEE HI TAX ",null,null,null,0,0]
["EMPLOYEE HI >$200K TXB",null,null,null,null,0,null,null,null,"1 - Deleted Manual Paysets during the quarter. "]
["EMPLOYEE HI >$200K TAX",null,null,null,null,0,null,null,null,null,"A - to find deleted manual paysets, review the Change Listings (Report 1006)"]
["EMPLOYEE MEDICARE TXBL",null,null,null,{"$f":"B13-C13","v":0},0,null,null,null,null,"created during the quarter.  If a manual payset shows on the Report 1006, but "]
["EMPLOYEE MEDICARE TAX",null,null,null,0,0,null,null,null,null,"is not found on the final Report 10 for that pay period, it was deleted."]
["COMPANY OASDI TAXABLE",null,null,null,0,0,null,null,null,null,"An adjustment must be entered on the PAT Quarterly Control Totals to balance."]
["COMPANY OASDI TAX ",null,null,null,0,0,null,null,null,"2 - Manual Adjustments keyed by State Payroll Operations during the quarter."]
["COMPANY HI TAXABLE",null,null,null,0,0,null,null,null,null,"A - Review the Adjustment forms submitted by the agency to State Payroll Ops."]
["COMPANY HI TAX ",null,null,null,0,0,null,null,null,null,"These adjustments must be entered in the Quarterly Control Totals to balance."]
["COMPANY MEDICARE TXBL",null,null,null,0,0,null,null,null,"3-Timing Differences for Special Payrolls processed on the last day of the month"]
["COMPANY MEDICARE TAX",null,null,null,0,0,null,null,null,null,"A-It is best to run the Quarterly Control Totals in PAT on the first day of the month."]
["FUTA TAXABLE",null,null,null,0,0,null,null,null,null,"Special Payrolls post to a quarter according to the composite pay period date at the"]
["FUTA TAX ",null,null,null,0,0,null,null,null,null,"top of Report 33. "]
["DI TAXABLE",null,null,null,0,0]
["DI TAX ",null,null,null,0,0]
["COMPANY PAID DI TAX",null,null,null,0,0]
["LOCAL TAXABLE",null,null,null,0,0]
["LOCAL TAX ",null,null,null,0,0]
["SP LOCAL TAXABLE",null,null,null,0,0]
["SP LOCAL TAX ",null,null,null,0,0]
["SIT TAXABLE",null,null,null,0,0]
["SIT TAX ",null,null,null,0,0]
["SUI GROSS",null,null,null,0,0]
["SUI TAXABLE",null,null,null,0,0]
["SUI TAX ",null,null,null,0,0]
["EMPLOYEE OASDI TIPS",null,null,null,0,0]
["EMPLOYEE HI TIPS",null,null,null,0,0]
["COMPANY OASDI TIPS",null,null,null,0,0]
["COMPANY HI TIPS",null,null,null,0,0]
["THIRD PARTY OASDI TXBL",null,null,null,0,0]
["THIRD PARTY OASDI TAX ",null,null,null,0,0]
["THIRD PARTY HI TXBL",null,null,null,0,0]
["THIRD PARTY HI TAX ",null,null,null,0,0]
["THIRD PARTY MED TXBL",null,null,null,0,0]
["THIRD PARTY MED TAX",null,null,null,0,0]
["THIRD PARTY FIT TAX",null,null,null,0,0]
["THIRD PARTY SIT TAX",null,null,null,0,0]
["UNC OASDI"]
["UNC HI"]
[null,{"$f":"SUM(B2:B48)","v":0},{"$f":"SUM(C2:C48)","v":0},{"$f":"SUM(D2:D48)","v":0},{"$f":"SUM(E2:E48)","v":0},{"$f":"SUM(F2:F48)","v":0}]

{"sheet":"Quarterly Tax Certification","index":1,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1048052,6,1048052,7],[7,1,7,7],[9,2,9,5],[6,1,6,7],[8,1,8,7],[37,1,38,4],[36,1,36,4],[12,1,12,7],[10,2,10,5],[1,6,1,7],[0,0,0,9],[1,0,1,2],[5,8,5,9],[54,3,54,5]]}
["CIPPS Quarterly Reconcilation and Certification"]
["Calendar Year:",null,null,null,null,null,"Quarter Ending:",null,"2022-03-31"]
[]
["Agency Name:",null,null,{"$f":"IFERROR(VLOOKUP(I4,agylist2,2,FALSE),\"\")","v":""},null,null,null,"Agy #:"]
[]
[null,null,null,null,null,null,null,null,"Quarterly Control Totals"]
[1,"Reconcile the Quarterly Control Totals (PAT) to the U092 (CIPPS Year-To-Date 10/33 Reconciliation),",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A2","v":"GROSS PAY"},{"$f":"'Report Reconciliations'!B2","v":0}]
[null,"Report 880/881 and Report 56. ",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A4","v":"FIT TAXABLE"},{"$f":"'Report Reconciliations'!B4","v":0}]
[null,"BOTH OF THESE ITEMS MUST BE ZERO BEFORE SUBMITTING THE QUARTERLY CERTIFICATION!",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A5","v":"FIT NON TAXABLE"},{"$f":"'Report Reconciliations'!B5","v":0}]
[null,null,"Total Differences (Quarterly Control Totals to U092)",null,null,null,{"$f":"'Report Reconciliations'!E49","v":0},null,{"$f":"'Report Reconciliations'!A6","v":"FIT TAX "},{"$f":"'Report Reconciliations'!B6","v":0}]
[null,null,"Total Differences (Quarterly Control Totals to Report 56)",null,null,null,{"$f":"'Report Reconciliations'!F49","v":0},null,{"$f":"'Report Reconciliations'!A7","v":"EMPLOYEE OASDI TAXABLE"},{"$f":"'Report Reconciliations'!B7","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A8","v":"EMPLOYEE OASDI TAX "},{"$f":"'Report Reconciliations'!B8","v":0}]
[2,"Reconcile Federal Taxable to State Taxable Income.  (Details on Federal to State Taxable Recon Tab)",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A9","v":"EMPLOYEE HI TAXABLE"},{"$f":"'Report Reconciliations'!B9","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A10","v":"EMPLOYEE HI TAX "},{"$f":"'Report Reconciliations'!B10","v":0}]
[null,null,"Unexplained FIT/SIT Differences:",null,null,{"$f":"'Federal to State Taxable Recon'!E10","v":0},null,null,{"$f":"'Report Reconciliations'!A11","v":"EMPLOYEE HI >$200K TXB"},{"$f":"'Report Reconciliations'!B11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A12","v":"EMPLOYEE HI >$200K TAX"},{"$f":"'Report Reconciliations'!B12","v":0}]
[3,"Reconcile FIT Non Taxable.",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A13","v":"EMPLOYEE MEDICARE TXBL"},{"$f":"'Report Reconciliations'!B13","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A14","v":"EMPLOYEE MEDICARE TAX"},{"$f":"'Report Reconciliations'!B14","v":0}]
[null,null,"Total FIT Non-Taxable U092",null,null,{"$f":"'Report Reconciliations'!C5","v":0},null,null,{"$f":"'Report Reconciliations'!A15","v":"COMPANY OASDI TAXABLE"},{"$f":"'Report Reconciliations'!B15","v":0}]
[null,null,"Enter Total Deceased Pay SP 054 YTD:",null,null,null,null,null,{"$f":"'Report Reconciliations'!A16","v":"COMPANY OASDI TAX "},{"$f":"'Report Reconciliations'!B16","v":0}]
[null,null,"Invalid FIT Non-Taxable Amounts:",null,null,{"$f":"F19-F20","v":0},null,null,{"$f":"'Report Reconciliations'!A17","v":"COMPANY HI TAXABLE"},{"$f":"'Report Reconciliations'!B17","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A18","v":"COMPANY HI TAX "},{"$f":"'Report Reconciliations'!B18","v":0}]
[4,"Renconcile OASDI Taxes: (Details on OASDI Tax Reconciliation Tab)",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A19","v":"COMPANY MEDICARE TXBL"},{"$f":"'Report Reconciliations'!B19","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A20","v":"COMPANY MEDICARE TAX"},{"$f":"'Report Reconciliations'!B20","v":0}]
[null,null,"Total Invalid Employee OASDI Tax Differences:",null,null,{"$f":"'OASDI Tax Reconciliation'!D13","v":0},null,null,{"$f":"'Report Reconciliations'!A21","v":"FUTA TAXABLE"},{"$f":"'Report Reconciliations'!B21","v":0}]
[null,null,"Total Invalid Company OASDI Tax Differences:",null,null,{"$f":"'OASDI Tax Reconciliation'!I10","v":0},null,null,{"$f":"'Report Reconciliations'!A22","v":"FUTA TAX "},{"$f":"'Report Reconciliations'!B22","v":0}]
[null,null,"Total Difference Employee and Company OASDI Taxable:",null,null,{"$f":"'OASDI Tax Reconciliation'!K3","v":0},null,null,{"$f":"'Report Reconciliations'!A23","v":"DI TAXABLE"},{"$f":"'Report Reconciliations'!B23","v":0}]
[null,null,"Incorrectly Reported as Uncollected OASDI on H0BTT:",null,null,{"$f":"'OASDI Tax Reconciliation'!D17","v":0},null,null,{"$f":"'Report Reconciliations'!A24","v":"DI TAX "},{"$f":"'Report Reconciliations'!B24","v":0}]
[5,"Reconcile HI Taxes: (Details on HI Tax Reconciliation Tab)",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A25","v":"COMPANY PAID DI TAX"},{"$f":"'Report Reconciliations'!B25","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A26","v":"LOCAL TAXABLE"},{"$f":"'Report Reconciliations'!B26","v":0}]
[null,null,"Total Invalid Employee HI Tax Differences:",null,null,{"$f":"'HI Tax Reconciliation'!D23","v":0},null,null,{"$f":"'Report Reconciliations'!A27","v":"LOCAL TAX "},{"$f":"'Report Reconciliations'!B27","v":0}]
[null,null,"Total Invalid Company HI Tax Differences:",null,null,{"$f":"'HI Tax Reconciliation'!I16","v":0},null,null,{"$f":"'Report Reconciliations'!A28","v":"SP LOCAL TAXABLE"},{"$f":"'Report Reconciliations'!B28","v":0}]
[null,null,"Total Difference Employee and Company HI Taxable:",null,null,{"$f":"'OASDI Tax Reconciliation'!K3","v":0},null,null,{"$f":"'Report Reconciliations'!A29","v":"SP LOCAL TAX "},{"$f":"'Report Reconciliations'!B29","v":0}]
[null,null,"Incorrectly Reported as Uncollected HI on H0BTT:",null,null,{"$f":"'HI Tax Reconciliation'!D27","v":0},null,null,{"$f":"'Report Reconciliations'!A30","v":"SIT TAXABLE"},{"$f":"'Report Reconciliations'!B30","v":0}]
[6,"U093 10/33 Recon Review (Enter Exceptions on Difference Explanations Tab)",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A31","v":"SIT TAX "},{"$f":"'Report Reconciliations'!B31","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A32","v":"SUI GROSS"},{"$f":"'Report Reconciliations'!B32","v":0}]
[null,"Number of Adjustments Requested:",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A33","v":"SUI TAXABLE"},{"$f":"'Report Reconciliations'!B33","v":0}]
[null,"Number of Adjustments That Will Be Corrected Through Payroll:",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A34","v":"SUI TAX "},{"$f":"'Report Reconciliations'!B34","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A35","v":"EMPLOYEE OASDI TIPS"},{"$f":"'Report Reconciliations'!B35","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A36","v":"EMPLOYEE HI TIPS"},{"$f":"'Report Reconciliations'!B36","v":0}]
[7,"AFTER all differences above are accounted for, press the \"Print\" button below.",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A37","v":"COMPANY OASDI TIPS"},{"$f":"'Report Reconciliations'!B37","v":0}]
[null,"Submit all resulting pages to State Payroll Operations with the first Company Total page of the Report 56",null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A38","v":"COMPANY HI TIPS"},{"$f":"'Report Reconciliations'!B38","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A47","v":"UNC OASDI"},{"$f":"'Report Reconciliations'!B47","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"'Report Reconciliations'!A48","v":"UNC HI"},{"$f":"'Report Reconciliations'!B48","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["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":[[11,2,11,3],[4,0,4,9],[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,6],[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],[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],[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],[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],[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],[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]]}
["CIPPS Quarterly Reconcilation and Certification"]
["Calendar Year:",{"$f":"calyear","v":0},null,null,null,null,null,null,"Quarter:",{"$f":"qtrend","v":"2022-03-31"}]
[]
["Agency Name:",{"$f":"'Quarterly Tax Certification'!D4","v":""},null,null,null,null,null,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:"]
["(Don't include adjustments entered in the PAT Quarterly Control Totals to balance on the Report Reconciliation tab.)"]
["Employee ID:","Amount of Difference","Correction Method:",null,"Explanation:",null,null,null,null,"Select Error 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":[[13,0,13,1],[26,0,26,1],[11,0,11,1],[12,0,12,1],[27,0,27,1],[31,0,31,1],[32,0,32,1],[29,0,29,1],[30,0,30,1],[28,0,28,1],[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],[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],[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]]}
[]
[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."]
["Report U092 FIT Taxable:",null,null,null,{"$f":"'Report Reconciliations'!C4","v":0},null,null,null,2,"Valid differences occur when the employee lives and works in another state that does not withhold state taxes."]
["Report U092 SIT Taxable:",null,null,null,{"$f":"'Report Reconciliations'!C30","v":0},null,null,null,3,"Review Report U093 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 drop down box in the table below, the difference is valid and can be listed in the table."]
["Difference:",null,null,null,{"$f":"E3-E4","v":0},null,null,null,null,"Enter the validated difference as a positive amount in the table."]
[null,null,null,null,null,null,null,null,4,"Other differences are probably caused by a FIT or SIT status of \"1\" on H0BAD or H0ATX.  If the employee is \"Exempt\""]
["Total Explained Out of State Differences:",null,null,null,{"$f":"G38","v":0},null,null,null,null,"a value of \"A\" should exist on those screens.  Even though the employee claims \"Exempt\" and is not withholding taxes, taxable income"]
[null,null,null,null,null,null,null,null,null,"should accumulate and is reportable on the W-2."]
["Unexplained FIT/SIT Differences:",null,null,null,{"$f":"E6-E8","v":0},null,null,null,5,"Differences between FIT and SIT Taxable can also be caused by an incorrect utility field on the H0ZDC screen for a nontaxable deduction."]
[]
["Employee ID:",null,"State:",null,"Enter Validated Difference From U093 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":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[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],[23,2,23,3],[23,4,23,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],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[33,2,33,3],[34,2,34,3],[33,4,33,5],[29,2,29,3],[38,2,38,3],[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],[45,2,45,3],[45,4,45,5],[18,0,18,8],[22,0,22,1],[22,2,22,3],[22,4,22,5],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,5],[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],[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],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,4,28,5],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[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],[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],[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]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:"]
[null,null,null,null,null,null,null,null,null,null,"Difference",null,1,"Use Report 844 to find employees that don't have matching employee and employer OASDI taxes."]
["Report U092 Employee OASDI Taxable",null,null,{"$f":"'Report Reconciliations'!C7","v":0},null,"Report U092 Company OASDI Taxable",null,null,{"$f":"'Report Reconciliations'!C15","v":0},null,{"$f":"I3-D3","v":0},null,2,"Uncollected OASDI is only valid if occurred as a result of Imputed Life that accumulated while the employee was on LWOP."]
["Computed Employee OASDI Tax (6.2%)",null,null,{"$f":"D3*0.062","v":0},null,"Computed Company OASDI Tax (6.2%)",null,null,{"$f":"I3*0.062","v":0},null,null,null,3,"If the employee has uncollected OASDI as a result of a non-cash fringe benefit (gift cards, company car, etc), it is not valid."]
["Actual Employee OASDI Tax U092",null,null,{"$f":"'Report Reconciliations'!B8","v":0},null,"Actual Company OASDI Tax U092",null,null,{"$f":"'Report Reconciliations'!C16","v":0},null,null,null,null,"In this case, the agency must pay the employee's portion.  The employee still owes the agency for the amount paid on their behalf!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Agencies must perform due diligence to collect the amount from the employee.  If the amount is not recovered, taxes paid on the employee's"]
["Difference:",null,null,{"$f":"D4-D5","v":0},null,"Company OASDI Tax Difference:",null,null,{"$f":"I4-I5","v":0},null,null,null,null,"behalf becomes taxable income to the employee.   Please refer to the Advanced Masterfile Maintenance Handout found on our website"]
["Total Valid Employee Uncollected OASDI:",null,null,{"$f":"H60","v":0},null,"Rounding Tolerance:",null,null,0.5,null,null,null,null,"at https://www.doa.virginia.gov/reference/payroll/CIPPS_Intro_Training/Manual_Pays_Advanced_Masterfile_Maintenance_Handout.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"for instructions on determining the full amount of OASDI Tax to withhold and how to use a manual payset to pay the employee's portion."]
["OASDI Tax Difference:",null,null,{"$f":"D7-D8","v":0},null,"Total Invalid Company OASDI Differences:",null,null,{"$f":"IF(I8>ABS(I7),0,I7)","v":0},null,null,null,4,"Invalid uncollected OASDI can also occur if a refund of a non-taxable deduction (premium conversion) is processed for a terminated employee"]
["Rounding Tolerance:",null,null,0.5,null,null,null,null,null,null,null,null,null,"Please refer to the Advanced Masterfile Maintenance Handout mentioned in Step 3 to review the proper way to refund non-taxable deductions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"to terminated employees."]
["Total Invalid Employee OASDI Differences:",null,null,{"$f":"IF(D11>ABS(D10),0,D10)","v":0},null,null,null,null,null,null,null,null,5,"When the employee OASDI tax withheld is greater than the employer OASDI tax withheld, it usually means that the employee is due a refund"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"of OASDI.  The system self adjusts FICA.  NEVER PROCESS A MANUAL PAYSET TO REFUND FICA TO AN EMPLOYEE.  If the employee is due a refund:"]
["Total Valid Employee Uncollected OASDI:",null,null,{"$f":"H60","v":0},null,null,null,null,null,null,null,null,null,"A","Make sure the employee is active on H0BES"]
["Total Uncollected OASDI U092:",null,null,{"$f":"'Report Reconciliations'!C47","v":0},null,null,null,null,null,null,null,null,null,"B ","If the employee is not receiving any REGULAR pay, use HUA03 to pay a penny.  (If the employee is receiving special pay only (HUE01)"]
["Total Incorrect Uncollected OASDI H0BTT:",null,null,{"$f":"D15-D16","v":0},null,null,null,null,null,null,null,null,null,null,"the refund will not process"]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"If the employee and employer OASDI tax is incorrect, Report 844 will not reveal the exception.  Use the PAT Queries to download the OASDI Taxable"]
["Report 858 Uncollected FICA",null,null,null,null,null,null,null,null,null,null,null,null,"amounts for the agency and multipy by 6.2%.  Compare the calculated amount to the amount of OASDI tax to find the difference."]
["Amounts Shown As Invalid Uncollected OASDI Must Be Charged to the Agency - Contact payroll@doa.virginia.gov For Assistance",null,null,null,null,null,null,null,null,null,null,null,7,"If you have a difference in cell K3 above, it means that the Employee and Employer OASDI amounts do not agree.  Use Report 846 to locate the difference."]
["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,{"$f":"SUMIF(E23,\"Imputed Life\",G23)","v":0},{"$f":"SUMIF(E23,\"other\",G23)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUMIF(E25,\"Imputed Life\",G25)","v":0},{"$f":"SUMIF(E25,\"other\",G25)","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,{"$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},0]

{"sheet":"HI Tax Reconciliation","index":5,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions:"]
[null,null,null,null,null,null,null,null,null,null,"Difference",null,1,"Use Report 848 to find employees that don't have matching employee and employer HI taxes.  There will be a valid difference "]
["Report U092 Employee HI Taxable",null,null,{"$f":"'Report Reconciliations'!C9","v":0},null,"Report U092 Company HI Taxable",null,null,{"$f":"'Report Reconciliations'!C17","v":0},null,{"$f":"I3-D3","v":0},null,null,"between the employee HI tax and the employer HI tax if the employee has more than 200,000 of HI Taxable income."]
["Report U092 Employee Medicare Taxable",null,null,{"$f":"'Report Reconciliations'!C13","v":0},null,"Report U092 Company Medicare Taxable",null,null,{"$f":"'Report Reconciliations'!C19","v":0},null,null,null,2,"Uncollected HI is only valid if occurred as a result of Imputed Life that accumulated while the employee was on LWOP."]
["Total HI Taxable  ",null,null,{"$f":"D3+D4","v":0},null,"Total HI Taxable  ",null,null,{"$f":"I3+I4","v":0},null,null,null,3,"If the employee has uncollected HI as a result of a non-cash fringe benefit (gift cards, company car, etc), it is not valid."]
["Computed Base Employee HI Tax (1.45%)",null,null,{"$f":"D5*0.0145","v":0},null,"Computed Base Company HI Tax (1.45%)",null,null,{"$f":"I5*0.0145","v":0},null,null,null,null,"In this case, the agency must pay the employee's portion.  The employee still owes the agency for the amount paid on their behalf!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Agencies must perform due diligence to collect the amount from the employee.  If the amount is not recovered, taxes paid on the employee's"]
["Total Hi Taxable Over 200K",null,null,{"$f":"'Report Reconciliations'!D11","v":0},null,"Actual Company HI Tax U092",null,null,{"$f":"'Report Reconciliations'!C18","v":0},null,null,null,null,"behalf becomes taxable income to the employee.   Please refer to the Advanced Masterfile Maintenance Handout found on our website"]
["Computed HI Surtax (.9%)",null,null,{"$f":"D8*0.009","v":0},null,"Actual Company Medicare Tax U092",null,null,{"$f":"'Report Reconciliations'!C20","v":0},null,null,null,null,"at https://www.doa.virginia.gov/reference/payroll/CIPPS_Intro_Training/Manual_Pays_Advanced_Masterfile_Maintenance_Handout.pdf"]
[]
[]
[null,null,null,null,null,"Company HI Tax Difference:",null,null,{"$f":"I6-(I8+I9)","v":0},null,null,null,null,"for instructions on determining the full amount of HI Tax to withhold and how to use a manual payset to pay the employee's portion."]
["Total Computed Employee HI Tax",null,null,{"$f":"D9+D6","v":0},null,"Rounding Tolerance:",null,null,0.5,null,null,null,4,"Invalid uncollected HI can also occur if a refund of a non-taxable deduction (premium conversion) is processed for a terminated employee"]
["Actual Employee HI Tax U092",null,null,{"$f":"'Report Reconciliations'!C10","v":0},null,null,null,null,null,null,null,null,null,"Please refer to the Advanced Masterfile Maintenance Handout mentioned in Step 3 to review the proper way to refund non-taxable deductions"]
["Actual Employee Medicare Tax U092",null,null,{"$f":"'Report Reconciliations'!C14","v":0}]
[null,null,null,null,null,"Total Invalid Company HI Differences:",null,null,{"$f":"IF(I13>ABS(I12),0,I12)","v":0},null,null,null,null,"to terminated employees."]
["Difference:",null,null,{"$f":"(D13-(D14+D15))","v":0},null,null,null,null,null,null,null,null,5,"When the employee HI tax withheld is greater than the employer HI tax withheld, it usually means that the employee is due a refund"]
["Total Valid Employee Uncollected HI:",null,null,{"$f":"H72","v":0},null,null,null,null,null,null,null,null,null,"of HI.  The system self adjusts FICA.  NEVER PROCESS A MANUAL PAYSET TO REFUND FICA TO AN EMPLOYEE.  If the employee is due a refund:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Make sure the employee is active on H0BES"]
["Employee HI Tax Difference:",null,null,{"$f":"D17-D18","v":0},null,null,null,null,null,null,null,null,null,"B ","If the employee is not receiving any REGULAR pay, use HUA03 to pay a penny.  (If the employee is receiving special pay only (HUE01)"]
["Rounding Tolerance:",null,null,0.5,null,null,null,null,null,null,null,null,null,null,"the refund will not process"]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"If the employee and employer HI tax is incorrect, Report 848 will not reveal the exception.  Use the PAT Queries to download the HI Taxable"]
["Total Invalid Employee HI Differences:",null,null,{"$f":"IF(D21>ABS(D20),0,D20)","v":0},null,null,null,null,null,null,null,null,null,"amounts for the agency and multipy by 1.45%.  Compare the calculated amount to the amount of HI tax to find the difference."]
[null,null,null,null,null,null,null,null,null,null,null,null,7,"If you have a difference in cell K3 above, it means that the Employee and Employer HI Taxable amounts do not agree. "]
["Total Valid Employee Uncollected HI:",null,null,{"$f":"H72","v":0},null,null,null,null,null,null,null,null,null," Use Report 850 to locate the difference.  The HI Taxable should be the same even if the employee has an amount greater than 200,000."]
["Total Uncollected HI Tax - Report U092",null,null,{"$f":"'Report Reconciliations'!C48","v":0}]
["Total Incorrect Uncollected HI H0BTT:",null,null,{"$f":"D25-D26","v":0}]
[]
["Report 858 Uncollected FICA"]
["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":212,"n_cols":5,"rows_kept":212,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"00100","Senate of Virginia"]
[null,null,null,"00101","Virginia House of Delegates"]
[null,null,null,"00103","Magistrate System"]
[null,null,null,"00107","Division of Legislative Services"]
[null,null,null,"00109","Division of Legislative Automated Systems"]
[null,null,null,"00110","Joint Legislative Audit and Review Commission"]
[null,null,null,"00111","Supreme Court"]
[null,null,null,"00112","Judicial Inquiry and Review  Commission"]
[null,null,null,"00113","Circuit Courts"]
[null,null,null,"00114","General District Courts"]
[null,null,null,"00115","Juvenile and Domestic Relations District Courts"]
[null,null,null,"00116","Combined District Courts"]
[null,null,null,"00117","Virginia State Bar"]
[null,null,null,"00119","Office of Lieutenant Governor"]
[null,null,null,"00121","Office of the Governor"]
[null,null,null,"00122","Department of Planning and Budget"]
[null,null,null,"00123","Department of Military Affairs"]
[null,null,null,"00125","Court of Appeals of Virginia"]
[null,null,null,"00127","Department of Emergency Management"]
[null,null,null,"00128","Virginia Veterans Care Center"]
[null,null,null,"00129","Department of Human Resource Management"]
[null,null,null,"00132","Department of Elections"]
[null,null,null,"00133","Auditor of Public Accounts"]
[null,null,null,"00136","Virginia Information Technologies Agency"]
[null,null,null,"00140","Department of Criminal Justice Services"]
[null,null,null,"00141","Attorney General and Department of Law"]
[null,null,null,"00143","Division of Debt Collection"]
[null,null,null,"00146","The Science Museum of Virginia"]
[null,null,null,"00147","Office of the State Inspector General"]
[null,null,null,"00148","Virginia Commission for the Arts"]
[null,null,null,"00151","Department of Accounts"]
[null,null,null,"00152","Department of the Treasury"]
[null,null,null,"00154","Department of Motor Vehicles"]
[null,null,null,"00156","Department of State Police"]
[null,null,null,"00157","Compensation Board"]
[null,null,null,"00158","Virginia Retirement System"]
[null,null,null,"00160","Virginia Criminal Sentencing Commission"]
[null,null,null,"00161","Department of Taxation"]
[null,null,null,"00162","Department of Accounts Transfer Payments"]
[null,null,null,"00164","Commonwealth of Virginia - VMFPA"]
[null,null,null,"00165","Department of Housing and Community Development"]
[null,null,null,"00166","Secretary of the Commonwealth"]
[null,null,null,"00171","State Corporation Commission"]
[null,null,null,"00172","Virginia Lottery"]
[null,null,null,"00174","Virginia College Savings Plan"]
[null,null,null,"00180","Secretary of Administration"]
[null,null,null,"00181","Department of Labor and Industry"]
[null,null,null,"00182","Virginia Employment Commission"]
[null,null,null,"00183","Secretary of Natural Resources"]
[null,null,null,"00184","Secretary of Technology"]
[null,null,null,"00185","Secretary of Education"]
[null,null,null,"00186","Secretary of Transportation"]
[null,null,null,"00187","Secretary of Public Safety and Homeland Security"]
[null,null,null,"00188","Secretary of Health and Human Resources"]
[null,null,null,"00190","Secretary of Finance"]
[null,null,null,"00191","Virginia Workers' Compensation Commission"]
[null,null,null,"00192","Secretary of Commerce and Trade"]
[null,null,null,"00193","Secretary of Agriculture and Forestry"]
[null,null,null,"00194","Department of General Services"]
[null,null,null,"00195","Secretary of Labor"]
[null,null,null,"00199","Department of Conservation and Recreation"]
[null,null,null,"00200","Office of Children's Services"]
[null,null,null,"00201","Department of Education, Central Office Operations"]
[null,null,null,"00202","The Library of Virginia"]
[null,null,null,"00203","Wilson Workforce and Rehabilitation Center"]
[null,null,null,"00212","Virginia State University"]
[null,null,null,"00213","Norfolk State University"]
[null,null,null,"00214","Longwood University"]
[null,null,null,"00215","University of Mary Washington"]
[null,null,null,"00217","Radford University"]
[null,null,null,"00218","Virginia School for the Deaf and the Blind"]
[null,null,null,"00222","Department of Professional  and Occupational Regulation"]
[null,null,null,"00223","Department of Health Professions"]
[null,null,null,"00226","Board of Accountancy"]
[null,null,null,"00233","Virginia Board of Bar Examiners"]
[null,null,null,"00234","Cooperative Extension and Agricultural Research Services"]
[null,null,null,"00238","Virginia Museum of Fine Arts"]
[null,null,null,"00239","Frontier Culture Museum of Virginia"]
[null,null,null,"00241","Richard Bland College"]
[null,null,null,"00242","Christopher Newport University"]
[null,null,null,"00245","State Council of Higher Education for Virginia"]
[null,null,null,"00261","Virginia Community College System"]
[null,null,null,"00262","Department for Aging and Rehabilitative Services"]
[null,null,null,"00263","Virginia Rehabilitation Center for the Blind and Vision Impaired"]
[null,null,null,"00270","VCCS - Shared Services Center"]
[null,null,null,"00275","New River Community College"]
[null,null,null,"00276","Southside Virginia Community College"]
[null,null,null,"00277","Paul D. Camp Community College"]
[null,null,null,"00278","Rappahannock Community College"]
[null,null,null,"00279","Danville Community College"]
[null,null,null,"00280","Northern Virginia Community College"]
[null,null,null,"00282","Piedmont Virginia Community College"]
[null,null,null,"00283","J. Sargeant Reynolds Community College"]
[null,null,null,"00284","Eastern Shore Community College"]
[null,null,null,"00285","Patrick Henry Community College"]
[null,null,null,"00286","Virginia Western Community College"]
[null,null,null,"00287","Dabney S. Lancaster Community College"]
[null,null,null,"00288","Wytheville Community College"]
[null,null,null,"00290","John Tyler Community College"]
[null,null,null,"00291","Blue Ridge Community College"]
[null,null,null,"00292","Central Virginia Community College"]
[null,null,null,"00293","Thomas Nelson Community College"]
[null,null,null,"00294","Southwest Virginia Community College"]
[null,null,null,"00295","Tidewater Community College"]
[null,null,null,"00296","Virginia Highlands Community College"]
[null,null,null,"00297","Germanna Community College"]
[null,null,null,"00298","Lord Fairfax Community College"]
[null,null,null,"00299","Mountain Empire Community College"]
[null,null,null,"00301","Department of Agriculture and Consumer Services"]
[null,null,null,"00330","Virginia Israel Advisory Board"]
[null,null,null,"00350","Department of Small Business and Supplier Diversity (VSBSD)"]
[null,null,null,"00400","Jamestown-Yorktown Commemorations"]
[null,null,null,"00402","Marine Resources Commission"]
[null,null,null,"00403","Department of Game and Inland Fisheries"]
[null,null,null,"00405","Virginia Racing Commission"]
[null,null,null,"00409","Department of Mines, Minerals, and Energy"]
[null,null,null,"00411","Department of Forestry"]
[null,null,null,"00413","Commission on VASAP"]
[null,null,null,"00417","Gunston Hall"]
[null,null,null,"00423","Department of Historic Resources"]
[null,null,null,"00425","Jamestown-Yorktown Foundation"]
[null,null,null,"00440","Department of Environmental Quality"]
[null,null,null,"00454","Secretary of Veterans and Defense Affairs"]
[null,null,null,"00505","Department of Rail and Public Transportation"]
[null,null,null,"00506","Motor Vehicle Dealer Board"]
[null,null,null,"00510","VDOT - Central Office"]
[null,null,null,"00511","VDOT - Bristol Office"]
[null,null,null,"00512","VDOT - Salem District"]
[null,null,null,"00513","VDOT - Lynchburg District"]
[null,null,null,"00514","VDOT - Richmond District"]
[null,null,null,"00515","VDOT - Hampton Roads District"]
[null,null,null,"00516","VDOT - Fredericksburg District"]
[null,null,null,"00517","VDOT - Culpeper District"]
[null,null,null,"00518","VDOT - Staunton District"]
[null,null,null,"00519","VDOT - Northern Virginia District"]
[null,null,null,"00601","Department of Health"]
[null,null,null,"00602","Department of Medical Assistance Services"]
[null,null,null,"00606","Virginia Board for People with Disabilities"]
[null,null,null,"00701","Department of Corrections, Central Activities"]
[null,null,null,"00702","Virginia Department for the Blind and Vision Impaired"]
[null,null,null,"00703","Central State Hospital"]
[null,null,null,"00704","Eastern State Hospital"]
[null,null,null,"00705","Southwestern Virginia Mental Health Institute"]
[null,null,null,"00706","Western State Hospital"]
[null,null,null,"00707","Central Virginia Training Center"]
[null,null,null,"00708","Commonwealth Center for Children and Adolescents"]
[null,null,null,"00711","Virginia Correctional Enterprises"]
[null,null,null,"00716","Virginia Correctional Center for Women"]
[null,null,null,"00718","Bland Correction Center"]
[null,null,null,"00720","Department of Behavioral Health and Developmental Services"]
[null,null,null,"00723","Southeastern Virginia Training Center"]
[null,null,null,"00724","Catawba Hospital"]
[null,null,null,"00728","Northern Virginia Mental Health Institute"]
[null,null,null,"00729","Piedmont Geriatric Hospital"]
[null,null,null,"00733","Sussex 1 State Prison"]
[null,null,null,"00734","Sussex II State Prison"]
[null,null,null,"00735","Wallens Ridge State Prison"]
[null,null,null,"00737","St. Brides Correctional Center"]
[null,null,null,"00738","Southwestern Virginia Training Center"]
[null,null,null,"00739","Southern Virginia Mental Health Institute"]
[null,null,null,"00741","Red Onion State Prison"]
[null,null,null,"00742","Employee Relations and Training Division"]
[null,null,null,"00743","Fluvanna Correctional Center for Women"]
[null,null,null,"00745","Nottoway Correctional Center"]
[null,null,null,"00747","Marion Correctional Treatment Center"]
[null,null,null,"00748","Hiram W. Davis Medical Center"]
[null,null,null,"00749","Buckingham Correctional Center"]
[null,null,null,"00751","Department for the Deaf and Hard-of-Hearing"]
[null,null,null,"00752","STATE FARM COMPLEX"]
[null,null,null,"00753","Deerfield Correctional Center"]
[null,null,null,"00754","Augusta Correctional Center"]
[null,null,null,"00756","Division of Institutions"]
[null,null,null,"00757","Western Region Correctional Field Units"]
[null,null,null,"00761","Eastern Region Correctional Field Units"]
[null,null,null,"00765","Department of Social Services"]
[null,null,null,"00766","Virginia Parole Board"]
[null,null,null,"00767","Division of Community Corrections"]
[null,null,null,"00768","Keen Mountain Correctional Center"]
[null,null,null,"00769","Greensville Correctional Center"]
[null,null,null,"00770","Dillwyn Correctional Center"]
[null,null,null,"00771","Indian Creek Correctional Center"]
[null,null,null,"00772","Haynesville Correctional Center"]
[null,null,null,"00773","Coffeewood Correctional Center"]
[null,null,null,"00774","Lunenburg Correctional Center"]
[null,null,null,"00775","Pocahontas State Correctional Center"]
[null,null,null,"00776","Greenrock Correctional Center"]
[null,null,null,"00777","Department of Juvenile Justice"]
[null,null,null,"00778","Department of Forensic Science"]
[null,null,null,"00779","Sussex I and Sussex II Prison Complex"]
[null,null,null,"00785","River North Correctional Center"]
[null,null,null,"00794","Virginia Center for  Behavioral Rehabilitation"]
[null,null,null,"00841","Department of Aviation"]
[null,null,null,"00848","Virginia Indigent Defense Commission"]
[null,null,null,"00851","Tobacco Region Revitalization Commission"]
[null,null,null,"00852","Virginia Foundation for Healthy Youth"]
[null,null,null,"00856","Virginia Opiod Abatement Authority"]
[null,null,null,"00882","Behavioral Health Commission"]
[null,null,null,"00888","Test Agency "]
[null,null,null,"00912","Department of Veterans Services"]
[null,null,null,"00913","Virginia Veterans Services Foundation"]
[null,null,null,"00922","Sitter-Barfoot Veterans Care Center"]
[null,null,null,"00937","Southern Virginia Center for Higher Education"]
[null,null,null,"00938","New College Institute"]
[null,null,null,"00942","Virginia Museum of Natural History"]
[null,null,null,"00948","Southwest Virginia Higher Education Center"]
[null,null,null,"00957","Commonwealth's Attorneys' Services Council"]
[null,null,null,"00960","Department of Fire Programs"]
[null,null,null,"00961","Division of Capitol Police"]
[null,null,null,"00977","Virginia Cannabis Control Authority"]
[null,null,null,"00997","DOA State Payroll Operations"]
[null,null,null,"00999","Department of Alcoholic Beverage Control"]