{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CT-1096","Instructions"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":2,"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":"CT-1096","index":0,"n_rows":3,"n_cols":40,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,4,0,5],[1,1,1,2]]}
["CT-1096","\nFile Creator for CSV Upload",{"$f":"COUNT(J4:J5175)& \"  record(s)\"","v":"0  record(s)"},null,null,null,null,null,null,{"$f":"SUM(J4:J774)","v":0},{"$f":"SUM(K4:K774)","v":0},null,{"$f":"SUM(M4:M774)","v":0},{"$f":"SUM(N4:N774)","v":0},null,{"$f":"SUM(P4:P774)","v":0},{"$f":"SUM(Q4:Q774)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"1099-NEC","1099-Misc","1099-R","W-2G","1099-K",null,null,null,null,"P:\\PerOper\\OperSharedSvcs\\ECU\\Public\\WO#2954\\CTAX\\BulkFiling\\Spreadsheets\\CT1096ct-1096 ABC Plumbing.xlsx"]
[" Enter company name or a unique identifier here ►►","ct-1096 ABC Plumbing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","Y"]
["Taxpayer-Name-This is the Employer Name\noptional  \n50 characters text ","Taxpayer-Employer AddressLine1\noptional\n 30 characters text ","Taxpayer-Employer AddressLine2\noptional \n30 characters text ","Taxpayer-Employer \nCity\noptional \n20 characters text ","Taxpayer-Employer \nState \noptional \n2 char text ","Taxpayer-Employer \nZip Code\noptional \n9 char text","Period End Date\nrequired \nmm/dd/yyyy ","State Tax Registration #\nrequired \n9-13 characters","Form Type\nrequired\n 9 characters","Total CT Tax Withheld\nrequired use whole numbers\n13 characters","Total Wages Paid\nrequired \nuse whole numbers\n13 characters","Total Number of 1099's Submitted\nrequired\nnumeric 7 char","Quarter1  (withholding for 1st quarter of year)\nrequired use whole numbers\n13 characters","Quarter 2 (withholding for 2nd quarter of year)\nrequired use whole numbers\n13 characters","Quarter 3 (withholding for 3rd quarter of year)\nrequired use whole numbers\n13 characters","Quarter 4 \n(withholding for 4th quarter of year)\nrequired use whole numbers\n13 characters","Total\nMust Equal the Sum of the 4 quarters withholding\nrequired use whole numbers\n13 characters","Return Prepared by Paid Preparer? - Y/N\ntext 1 character","PaidPreparerName\ntext\n50 characters","PaidPreparer FirmName\ntext\n50 characters","PaidPreparer FEIN\ntext 9 characters","Is Paid Preparer address a foreign address?\ntext 1 character (N/Y)","PaidPreparerAddressLine1\ntext 30 characters","PaidPreparerAddressLine2\ntext 30 characters","(if paid preparer foreign address = Y the this  field must be completed )\nPaidPreparerAddressLine3 -Foreign Addresses Only\ntext 30 characters","PaidPreparerCity\ntext 20 characters","Paid Preparer State\ntext 2 characters","Paid Preparer Zip Code\ntext 9 characters","Paid Preparer Telephone Number\ntext 15 characters"]

{"sheet":"Instructions","index":1,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[[13,0,14,0]]}
["The below instructions are for creating your file(s) in the required Excel format using the default \"Delimited File\" option."]
[]
["Your 1099, 1099-R W-2G’s should have been successfully uploaded in a previous session."]
[]
["This worksheet takes CT-1096 information you entered and generates a .CSV file.(Comma Separated Value ). This is a file format the Taxpayer Service Center (TSC) understands. "]
[]
["Here is a shortcut key you should find helpful when entering data."]
["Ctrl + j  will give you information for a given cell. It tells how many characters are allowed in a given cell versus how many used and the data type required such as text or numeric data."]
[]
["When entering certain cells an \"informational\" box may pop up. You can click and drag it anywhere the box anywhere on the screen."]
[]
["Avoid using special characters such as commas ( , ) pound signs ( # ) when entering information in the worksheet. "]
[]
["1. ENTER YOUR CT-1096 INFO.  When you are ready to enter your CT-1096 information, simply highlight and delete our sample CT-1096 information and enter your own CT-1096 information."]
[]
["Once you have completed entering all your CT-1096’s into the Excel spreadsheet you will then need to create an up loadable “.CSV” file that the TSC will be able to process.  "]
[]
["2. CREATE A FILE NAME. You will need to name the file.  "]
["On line 1(cell E1) enter a name for your file. Do not use special characters, commas or periods.  This will later be part of the file name when the .CSV file is created."]
[]
["3. CREATE THE FILE. Click the \"create uploadable .CSV\" button. This will automatically create the .CSV file.  Choose a file location in your folders for this file and save. Remember this location so you are able to return to it."]
[]
["IMPORTANT !! Please note two things:"]
[]
["A) Initially you  will be prompted to save the file as an \".xls\" file. CHANGE THIS TO FILE TYPE .CSV by selecting it from the \"Type of files\" drop down box."]
[]
["B) DO NOT change the file name from this \"FILE SAVE\" window. It still will only create the file [CT1096][FileName].[CSV].  (You can still change the location of where the .CSV file is stored from this menu BUT make note and remember where you saved your file.) "]
[]
["If all has gone well you now have file ready to be processed."]