Magtape File Layout Detail Record
Contents
1. 16 In the Deceased Owner field 28 use the dropdown to select Y if the owner is deceased 17 Enter Date of Birth if available 28a using the dropdown calendar Using Command Buttons The Account Owner window also contains a number of command buttons The table below describes their functionality Clicking this Command Does this Button Copy Owner Name 20 Copies owner information to the Account Title field Previous Account Owner 29 Opens the previous Account Owner record Next Account Owner 30 Opens the next Account Owner record Add Account 31 Opens a blank data entry window in which to enter Account Property Owner information Find Record 32 Brings up the Find record box will search within the field in which the cursor is placed Delete Record 33 Deletes the current record from the report Last Record 34 Opens the last record in the report Clicking this Command Does this Button Add Additional Owner to this Creates a blank data entry window in which Account 35 to enter multiple owners to the current account Add Additional Owner and Creates a blank owner data entry window in Copy Address 36 which to enter multiple owners to the current account and copy the address information Exit icon 37 Saves the record and opens the Verification and Checklist window Additional Notes You can only enter account proper2. D IT gem QT Ppa 9 o NEWYORK 12 duo MI WA WO 7 B SIN v s a E 2 gt bi Enter the title of the co Num Lock Filtered Editing Existing Report Contact Information Use these instructions to edit existing report contact information From the Report Contact window 1 In the Select Contact field 1 Pull down the list and select an existing contact The system displays the record Note If you make an incorrect selection you can click Cancel Contact Copy 2 to cancel the transaction 2 Edit the appropriate data entry fields 3 When you have finished editing contact information Click the Exit icon Entering New Report Contact Information Use these instructions to enter new report contact information 4 From the Report Contact window in the Contact Type field 3 Pull down the list and select the appropriate code EXEC Executive RPT Report 5 In the Title field 4 Type the contact s title 6 Use the following table to provide contact name information In this Do this field Prefix 5 e Pull down the list and select the appropriate prefix First Name e Type the contact s first name 6 Middle e Type the contact s middle initial Init Name 7 Last Name e Type the contact s last name 8 Suffix 9 e Pull down the list and select the appropriate suffix 7 In the Send t
3. E Rich Tet Records IL Security Warning Certain content in the database has been disabled Options Date Mod zt dsappvcl pate Created 4 10 2002 11 27 05 Date Modified 3 16 2010 11 24 34 3 Find Contact Query Date Created ile Date Modified 2 2 Open P Find duplicates fi BZ Design View Date Created 3A Export Date Modified 3 n P A T Sch 3 Find duplicates fc Collect and Update Data via E mail Date Created 3 2 Rename Date Modified 3 Hide in this Group 3 Find duplicates fc e Delete Date Created 3 2 Date Modified 3 Cut A x A firstname Ba Copy Date Created 3 1 AF Date Modified 3 A firstnamefix Sf Object Properties x Date Created 10 19 2004 5 07 56 P Date Modified 1 13 2005 10 03 17 AW foc Acctritie Query Date Created 10 29 2001 12 01 57 Date Modified 9 7 2006 11 50 14 Fixcompany1 Query Date Created 6 20 2002 10 49 40 Date Modified 6 21 2005 9 26 18 If you do not have Microsoft Access contact us to arrange to have your database sent to us via email so that we can repair it 53
4. New York State Office of the State Comptroller Handbook for Reporters of Unclaimed Funds NYCD Diskette Installation and User Manual Office of Unclaimed Funds February 2015 Table of Contents RAN 0119 41 E 3 REQUIREMENTS c 4 INSTALLING THE NYCD APPLICATION iiri iedbk icon etebye eire oed pn np rere Pak oo estela ri 5 INTROBUCION agora aa 9 IMPORTANT KEY EUNCTIONS csririzirni eran paranoia pria ina rara 11 PROVIDING REPORT INFORMA TION scssscossssscoseassnscsisuasconosssascnsesosnsovarsnsneicasbeoonseborongasepseonsesesnossspbconnacssecpnasonse 12 IMPORTING REPORTS aggirano a a I ARL 13 ENTERING AND EDITING REPORT INFORMATION eese enses en nts tn stata eee nenereeree nio sesta sione eesnenecere 15 ENTERING AND EDITING REPORT CONTACT INFORMATION erserrerrerrerrceresece serio sioni eeonioneceeo 18 EDITING EXISTING REPORT CONTACT INFORMATION 18 ENTERING NEW REPORT CONTACT INFORMATION 19 ENTERING AND EDITING ACCOUNT PROPERTY AND OWNER INFORMATION eene 21 ENTERING AND EDITING ACCOUNT AND PROPERTY INFORMATION 21 ENTERING AND EDITING OWNER INFORMATION 22 SING WEE NEE 24 ADDITIONAL NOTES EE 25 CHECKS AND BALANCES WINDOW egent er ket ooa Ecke epe rea RESERO RITO EER BRA SE REN Ge NUR RKU GR 25 USING THE CHECKS AND BALANCES WINDOW ee eeeeee esee eese tne ta nea nio stata seta so aeta senese sesta neo ninneonenne
5. Record Position Field Length Remarks 1 Record Identifier 1 Constant D 2 10 FEIN Reporter 9 As used for IRS 11 12 Property Type 2 From Property Type Tables 13 18 Unique Reference 6 For Multiple Owners use same 19 Multiple Owner 1 X if 2 or more Indicator owners 20 39 Last Name 20 Text 40 49 First Name 10 Text 50 Middle Initial 1 Text 51 53 Suffix 3 Text 54 83 Street Address 1 30 Text 84 113 Street Address 2 30 Text 114 133 City 20 Text 134 135 State 2 Text 136 140 Zip Code 5 Text 141 144 Supplemental Zip 4 Text Code 145 154 Country if not 10 Text USA 155 163 SSN 9 Text 164 183 Property ID 20 Text Number 184 253 Account Title 70 Text 254 259 Dormancy Date 6 Numeric MMDDY Y 260 268 Initial Amount 9 Numeric no decimal Position Field Length Remarks 269 277 Escheated 9 Numeric no Amount decimal 278 Removal Indicator 1 Blank P or R 279 348 Description of 70 Text Security Stocks 349 357 CUSIP number 9 Text 358 361 Blank 4 Text 362 374 Number of Shares 13 Numeric no decimal 375 Method of 1 Blank D P or Transfer A 376 384 Blank 9 Text 47 Magtape File Layout Trailer Record Position Field Length Remarks 1 Record Identifier 1 Constant T 2
6. Working with Excel Import Use these instructions to import and use the Excel Import files Before you begin Make sure you know the name of file you want to import 1 Click Import Report Note You need to enter the report s FEIN year and number v E a 2 5 2 gt D Record 4 Form View 2 Click Import Excel External Data Database Tools Add Ins Acrobat Search Num Lock EE d Cl Lg 51 Look in NYSReporting s EI rh ES I Copy of NewHand Inhouse E instalingthenychppication fles Quycpa E _Excellus_07172006 txt amp I2005Dxclo5 xLS amp 2006cppab xls 112906C txt E 112906D txt E ABP90101 TXT E ABPROP2003NY Final xls EI ALABAMAZ006BExchange txt f ALABAMA2006Exchange2 txt My Recent Documents Desktop E ALABAMA2006Exchange txt California txt E CaliforniaReciOld txt CD californiaReciOld zip Bl CASPChecks mdb ZI copy of CASPChecks mdb E DDA SAV 03 01B txt E DENNYS TXT ZI dknaupa mdb S Dxcl95 1 XLS BH pxc195C xls SY pxcl95c xls sda exe AN Exchange mdb GIL ili J 20050 xcl95 XLS x fan Files D v Open as read only Open Cancel File name My Network Files of type Places Open the file you want to import 3 The file will automatically process when completed Click the Exit icon 4 When you return to the Switchboard screen you can Edit the Report and Accounts T
7. 1 4 Enter Edit Executive Contact Total Cash Shares Items and Records are Calculated from the Account Property Totals Total Cash seme Total Shares 8000 Total Items L Total Records 5 4 Enter the reportin Hum Lock Filtered EE dB i 46 ss Use the following table to complete the fields Enter the following do business in NYS In this field Do this Reporting Organization e Type the name of the reporting organization Name Area Division Number e Type the area division number This field is optional Select Report Class e Pull down the list and select a class Incorporation Date e Type the incorporation date MM DD YYY Y Are you authorized to e Pull down the list and select the appropriate code Y is yes and N is no 5 Click Enter Edit Report Contact Information 14 The Contact window appears Contact NYCD External Data Database Tools Add Ins Acrobat 9 amp xX Cancel Contact Copy ACHANDINE JAISINGHANI 610 FIFTH AVENUE SUITE 612 NEW YORK SS UI 2128713301 212 871 3305 CHANDINIJAISINGHANI RYAN COM Navigation Pane Enter the title of the co Num Lock Filtered 6 See Contact Help F1 for further information 7 lf you want to skip this screen enter NY for State and click on the Exit button Entering and Editing Report Contact Information ve Database Tools Add Ins Acrobat
8. Documents library inagis olio m Desktop NYCD l Downloads Naim Date modified S Recent Places i 305787RF bt 11 06 2012 02 45 NYCD accdb 01 31 2014 09 27 Ba nycd ico 02 08 2002 03 45 E NYCD laccdb 01 31 2014 09 23 OUFhand h 01 22 2002 03 15 EP OUFHandbook chm 12 28 2006 11 30 GG Libraries Documents a Music li Pictures B Videos eni en lr L su mg INY251783727201401 bd auc O m Acrobat i i Deleting Reports P ied uoneBineN fala D to delete reports instructions Use these indow tchboard w From the Swi t step ine your nex table to determi ing Use the followi 1 Type o Q D Pa r gos o a S 2 ac D ba 3c LLI E al UN Ki GE eve punt MO i O O2 O az Ay Q0 vE 05 90 cH rar 0 oo oc iam C S LE ped Z0 il e Se e e c o 2 Vv Ke 2 SI 2 el 2 sl 2 5 99 ol Oo nl E ol o DI et Do you want to delete Then Type the report number All reports e Click Clear 2 Click Delete Report A confirmation window appears 3 Click OK Note If you want to cancel the request click Cancel Importing Reports The application allows you to import the following file layouts e New diskette reporting files e NAUPA file layout e Import 389 e Import HDT e Import Excel
9. Import text files Before you begin Make sure you know the name of file you want to import 1 Click Import Report Note You don t need to enter the report s FEIN year and number This information is already in the HDT file 2 Click Import HDT CONES dx Look in c 3 Floppy 4 J eee d History 6 Desktop Mu Documents i eie File name REI00 z Open ec Wel Files of type fan Files j _ Cae My Network P Open as read only 4 3 Open the file you want to import 4 The file will automatically process when completed Click the Exit icon 5 When you return to the Switchboard screen you can Edit the Report and Accounts Magtape File Layout Header Record Positions Field Length Remarks 1 Record Identifier 1 Constant H 2 10 FEIN Reporter 9 As used for IRS 11 40 Name 1 Reporter 30 Text 41 70 Name 2 Reporter 30 Text 71 100 Address 1 30 Text 101 130 Address 2 30 Text 131 150 City 20 Text 151 152 State Text 153 157 Primary Zip Code Text 158 161 Supplemental Zip Text 162 171 Country if not 10 Text USA 172 173 State of 2 Text Incorporation 174 177 Month and Year 4 Numeric MMYY Report is Due 178 183 Date Report 6 Numeric MMDDYY Produced 184 384 Blank 201 Blank Magtape File Layout Detail
10. Use these instructions to import a report From the Switchboard window 1 Click Import Report The Import Files Form window appears Home Create External Data Database Tools Add Ins Acrobat v s a z 2 2 gt amp Record 4 4 10f1 KK No Filter Search Form View Num Lock E 3 dB Le 2 Use the following table to determine your next step Do you want to Do this Import a diskette e Click Import Diskette file Import a NAUPA e Click Import NAUPA file Import a 389 file e Click Import 389 Import HDT e Click Import HDT Import Diskspecs e Import Excel Excel 3 Further instructions are described for each import Note Contact us if you have questions or need a new import for your organization Working with NAUPA Files Use these instructions to import and use the fixed width NAUPA text files Before you begin Make sure you know the name of the file you want to import 1 Click Import Report Note You don t need to enter the report s FEIN year and number This information is already in the NAUPA file External Data Database Tools Add Ins Acrobat G 9 S a z 2 2 gt D z Record 4 Loft Search Form View Num Lock JE E Hb EP M e 2 Click Import NAUPA Look in i 3 Floppy A J cme History Desktop My Documents My Computer 3 i em sl PAGE Fie name REIDO T SR Files of t
11. file type you specify A file can be a NAUPA NYCD Magtape or Upload text file or an Excel spreadsheet Create Export Report 6 The application creates a txt file suitable for exporting Delete Report 7 The application deletes the report you specify Exit icon 8 Closes the window Clear 9 Clears the screen F1 Help 10 Opens the Help Screen The Office of the State Comptroller 11 Opens the State Comptroller Website Important Key Functions Key s Function TAB or RIGHT Moves the cursor to the next field ARROW END Moves the cursor to the last field in the current record in navigation mode SHIFT TAB or Moves the cursor to the previous field LEFT ARROW HOME Moves the cursor to the first field in the current record in navigation mode DOWN ARROW Moves the cursor to the current field in the next record CTRL DOWN Moves the cursor to the current field in the ARROW last record in navigation mode CTRL END Moves the cursor to the last field in the last record in navigation mode UP ARROW Moves the cursor to the current field in the previous record CTRL UP Moves the cursor to the current field in the ARROW first record in navigation mode CTRL HOME Moves the cursor to the first field in the first record in navigation mode Providing Report Information E E H z Use these instructions to provid
12. remittances Use these instructions to create an export file Before you begin Prior to creating an export file you must enter report contact account and owner information From the Switchboard window 1 Use the following table to determine your next step Do you want to create an export file for Then A single report In the Reporter FEIN field 1 Type your FEIN In the Report Year field 2 Type the report year YYYY In the Report Number field 3 Type the report number Multiple reports within the same reporting year In the Reporter FEIN field 1 Type your FEIN In the Report Year field 2 Type the report year YYYY Multiple reports and multiple years In the Reporter FEIN field 1 Type your FEIN Multiple FEINs and or multiple reports for a single reporting year In the Report Year field 2 Type the report year YYYY 2 Click Create Export File a b You can save to any folder on your pc or network drive C d If you do change the filename be sure to add TXT to the end of the file name you e The Save As screen appears The file name is created for you and there is no need to change this enter otherwise an error will occur After you click save the program will automatically create the file where you save it and return to the Switchboard screen PESTO Organize v New folder Fr Favorites
13. 0 ez Ej ws FTP NY020465918200001 E My Documents Type Text Document Size 18 9 KB n Mu SE Nva1142697320001 d A File name NY411426973200001 AL iO Files of type fan Files DI Cancel Mu Network gue a Open as read only 3 The Open file Screen appears 4 Select the file you want to import and click Open 5 After the File is done processing Exit the screen 6 When you return to the Switchboard screen you can Edit the Report and Accounts NYCD Diskette Report Record layout Report Record A REC LENGTH START PO END POS 9o m N E LE D N o State of Incorp a Co a ica e Iniiai Reported cents of sa sso Iniiai Reported Shares tal al ss NYCD Diskette Summary Record layout Summary Record s LENGTH START POS END POS AcctSeq OwnerSeg Property_Type PTinitial Reported Cash ea PTInitial_ Reported Certs Bak NYCD Diskette Contact Record layout Contact Record LENGTH START POS END POS me c o ho LJ a e i Name Sufi Oy lo sco ses eee sal 9 EE NYCD Diskette Account Record layout Bes reci pnto Leer START OS END pos reo lo Fn p ver di Rotiumbe b hxSep kb Op kb sl a San b JL mj o9 psi e y o an a Address 3 444 City State Province Se Country Date of Birth Kee Working with HDT Import Header Detail Trailer or Mag Tape Specs Use these instructions to import and use the HDT
14. 10 FEIN 9 As used for IRS 11 40 Reporter Name 1 30 Text 41 70 Reporter Name 2 30 Text 71 100 Address 1 30 Text 101 130 Address 2 30 Text 131 150 City 20 Text 151 152 State 2 Text 153 157 Zipcode 5 Text 158 161 Supplemental Zip 4 Text Code 162 171 Country if not 10 Text USA 172 173 State of 2 Text Incorporation 174 177 Date Report is 4 Numeric MMYY Due 178 183 Date Report 6 Numeric Produced MMDDYY 184 193 Total Escheated 10 Numeric no Cash in Report decimal 194 200 Total Escheated 7 Numeric Certificates 201 205 Total Items 5 Numeric 206 210 Total Records 5 Numeric 211 384 Blank 174 Blank Spaces 48 1 Note You need to enter the report s FEIN year and number Working with 389 Import Use these instructions to import and use the 389 Import text files Before you begin Make sure you know the name of file you want to import Click Import Report External Data Database Tools Add Ins HDT File Layout z Hi z 3 F1 For Help Record 4 lofi M Click Import 389 x Name Favorites E RE Desktop 3 Downloads L UPLOAD tt T Recent Places a Libraries Open the file you want to import Organize v Include in library Share with Import Naupa Import 389 Unclaimed Funds Reporting Layout Upload Import 389 Import HDT Diskspecs Excel Spreadsh
15. 9 l Downloads i autorun inf 04 22 2008 03 i5 Recent Places TL Diskettelnstall pdf 03 05 2014 08 Important Instructions Before Installing 03 05 2014 08 Libraries 8 setup exe 12 01 2008 09 ES Documents My Documents A Public Documents a Music k 5 items The Welcome window appears id NYS Diskette Reporting Setup P Welcome to the NYS Diskette Reporting Setup Wizard The Setup Wizard will allow you to change the way NYS Diskette Reporting features are installed on your computer or even to remove NYS Diskette Reporting from your Vise Click Next to continue or Cancel to exit the Setup Wizard 2 Click Next The Customer Information window appears i NYS Diskette Reporting Setup Customer Information Please enter your customer information 3 Click Next Choose Setup Type Choose the setup type that best suits your needs Typical Installs the most common program Features Recommended For most users Custom Allows users to choose which program Features will be installed and where they will be installed Recommended for advanced users 4 Click the Typical button then Next H ie NYS Diskette Reporting Setup E Ready to Install The Setup Wizard is ready to begin the Typical installation Click Install to begin the installation If you want to review or change any of your installation settings click Back Click Cancel to exit the wiz
16. Number field 1 When you have completed entering all your data Exit 37 the Account Property Owner Screen Account Owner window 1 In the Reporters Account Number field 2 Type the identifying data by which the reporting organization refers to the property Security Certificate Number Customer Account Number Insurance Policy Number Check Number 2 In the Dormancy Date field 3 Type the date MM DD YYYY by which you have determined that the account is dormant This may be the date of issuance date of exchange or redemption or LAST date of customer contact 3 In the Property Type field 4 Pull down the list and select a property type 4 Inthe Initial Amount field 5 type the amount shown on the books as of the abandonment date 5 In the Escheated Amount Field 6 type the amount you are transferring to New York State This amount may differ from the initial amount due to the addition of interest or the deduction of allowable fees 6 In the Security Description field 7 type the standard description of the issue including type of stock as used by the financial community 7 In the CUSIP field 8 type the nine digit number CUSIP assigned to the issue being reported as listed in Standard amp Poor s CUSIP Directory 8 In the Method of Transfer field 9 pull down the list and select the appropriate code Use the code that reflects the method by which the security was transferred P Physical certific
17. a Ze roma CoTacictemanc innonomani MAAAAAAAAAAAAAAAA y 122228 Zeng an ax ZZZ AIA Sit of Mew York County of d yum ing Testen m a c 1y which ha nar entrati property e musti pue ti xitexdax Lex sed rrt cad diga endi cd hapat osm diyar erg ti cared ot uode Swom t before me fil c day of 20 Motry Fubllo RESERVED FOR USE OF STATE COMPTROLLER Property Type A SAND EPOSI x de de kr ENE SE CN AVES WEN reu GE x U Y Enter Edit P Report Lacer Num e Sr A ADDS BEN v x DAN SN WM f s aros s dat y Vr Een a RATA lg Sa SM Hr PR Ne DIL jf e SL d A 5 VELENI PIT E D s Ge Account Detail Listing Reporter tis Gioi Repeet Ven EO Regent bere pi AcwumtWurbe Moves Maat fie tt eeemovem C Wepreresmeoam urbe scorto DomenyBse memediwieser Property res it Cmp Weetetunts C sayon 5 3 7 Matat Armour 200 Estesa Amount Embeds BEIS smm BEE oweeehem Venter fot Marne Mie irat are Lent Kane Sut lee bom 3j 1 Ames Roncone 0 0 5 5 3 cny swe fr L LI d meam lo 1 Cusio Menoio trons Security Beseription s hestod Amount 12 00 EsehewedShares oml MM Creating Export Files You can export a single report or several reports to a text file which you can then send to the Comptroller s office along with the VCL and any
18. and Editing Account Property and Owner Information ang Account NYCD E Od 2 RK Home Create External Data Database Tools Add Ins Acrobat Reporters Account Number 0543764U201006211 2 Dormancy Date 13 05 2009 4 Property Type 28 27 20 Escheated Amount 27 20 6 Security Description Initial Amount ind CHECKS 7 Cusip a jiethod of Transfer gr Escheated Shares 0 00000 10 Removal Indicator 11 Navigation Pane re BE A eh Find Recor Delete Last Reco Owner Information Owner Sequence 1 SSNIN 4 13 Company Name STARCOM MEDIAVEST GR Ps 4 4 Middle OR dh 19 Account Title 20 ES A fj Name ES Name MARCOM MEDIAVES fl aid MEDIAVEST GR Copy Owner Name og 79 MADISON AVE H FLOOR D S Zipcode NEW YORK NY Le 110016 Province Country Foreign Zipcode o5 25 27 Deceased Owner mmo ener DOB 244 Add Additiod Owner to this Account Add Additional Owne and Copy Address and Copy Address 3G Enter the identifying data by which the reporting organization refers to the property Num Lock Filtered e Entering and Editing Account and Property Information Use these instructions to enter and edit account and property information Note that the system automatically enters a number in the Sequence
19. ard Install Dres m E 5 Click Install The completed window appears Mi Ns piskette Reportingsetup O Completing the NYS Diskette Reporting Setup Wizard Click the Finish button to exit the Setup Wizard Cancel 6 Click Finish 7 Test Desktop Shortcut E z 2 5 A z Introduction When you initiate the NYCD application the first window to appear is the Switchboard window lt has three data entry fields e Enter Report FEIN e Enter Report Year e Enter Report Number You can populate each by pulling down its drop down list and selecting a list item Use them to define which report s with which you want to work The Switchboard window also contains a number of command buttons The table below describes their functionality Clicking this Command Button Does this Enter Edit Report 1 Opens the Verification and Checklist VCL window in which you can provide reporter report and contact information The application calculates amounts Checks and Balances 2 Opens the Check Balance window The application calculates and displays account cash and share amounts Print VCL 3 Prints the VCL Report for the report you specified Print Detail Accounts 4 Opens the Print Preview of the Account Detail Listing You can then print the details for the report you specified Import Report 5 Opens the Import window The application imports the
20. ate DTC transfer D A Account book entry T Sent for registration transfer to be delivered at a later date 9 In the Escheated Shares field 10 enter number of shares or denomination being transferred to New York State For equity issues enter number of shares for debt issues enter dollar equivalent 10 In the Removal Indicator field 11 pull down the list and select the appropriate code If you have paid the owner enter P in Owner Claimed box If Otherwise Reduced to Zero amount originally included in error enter R Entering and Editing Owner Information Use these instructions to enter and edit owner information Note that the system automatically enters a number in the Owner Sequence field 1 11 From the Account Owner window in the SSN TIN field 12 Type the appropriate number If the owner is an individual type the individual s social security number If the owner is a business entity type the entity s Employer Identification Number EIN If the SSN or EIN is unknown leave blank 12 Use the following table to provide name information If the owner Then is A company In the Company Name field 13 e Type the corporate or entity name An individual In the Prefix field 14 e Pull down the list and select the appropriate prefix In the First Name field 15 e Type the owners first name In the Middle Init Name field 16 e Type the owner s
21. cee 26 PRINT VCL VERIFICATION AND CHECKLIST eere censes eese tn seta en aeta so aeta neo rio sens tastes ease tasse tasas eaae 27 PRINT DELXILS iiiter choices db PRU Spe de RM inn Ee 29 CREATING EXPORT FILES 30 DELETING REPORTS ioci etie b OD EPA TE PASE RUP PENUESRA PTT 33 IMPORTING REPORTS refor AIR RI RNA I ERRORI IR e 35 WORKING WITH NAUPA FILES sr LI I GIRI Ia 37 WORKING WITH NEW DISKETTE REPORTING LAYOUT srerrrrrrrrrereeree eee ren sese see eio serio neo nioneonioneseee 38 NYCD DISKETTE REPORT RECORD LAYOUT sccccsscsssoscrssessesenssonseossccsossosenssonsesenesenseesseseascesonseeasenenasense 40 NYCD DISKETTE SUMMARY RECORD LAYOUT e eeeeeeeeee sere rere serio reo ren eee zeneeeereneeo sesto neo neneeoneonecene 41 NYCD DISKETTE CONTACT RECORD LAYOUT oorrrrrrrerrrrreserereereo seo reoeesneneece sesso sonata sees ease tasas tassa ao 42 NYCD DISKETTE ACCOUNT RECORD LA YOVTUT eeeeeeeeposeseno spas netos epson e eth epo the ao e been eee eb eee t0 Pepe Sin tao e pae Ones 43 WORKING WITH HDT IMPORT HEADER DETAIL TRAILER OR MAG TAPE SPECS 44 USE THESE INSTRUCTIONS TO IMPORT AND USE THE HDT IMPORT TEXT FILES 44 WORKING WITH 389 IMPORT init LE VE E ELCHE FALLI LR 49 USE THESE INSTRUCTIONS TO IMPORT AND USE THE 389 IMPORT TEXT FILES 49 WORKING WITH EXCEL IMPORT eniti eene hei nrerebeveso eher pr
22. e report information From the Switchboard window 1 In the Enter Report FEIN field 1 Pull down the list and select the appropriate FEIN This is the reporting organization s nine digit Federal Identification Number 2 In the Enter Report Year field 2 Pull down the list and select the appropriate year This is the four digit report year YYYY 3 In the Enter Report Number field 3 Pull down the list and select the appropriate report number This is a two digit number Importing Reports The application allows you to import the following file layouts e New diskette reporting files e NAUPA file layout e Import 389 e Import HDT e Import Excel Use these instructions to import a report From the Switchboard window Create External Data Database Tools Add Ins Acrobat IT IE J organization Note Paying Agents enter their own tax ID 1 Click Import Report The Import Files Form window appears Home Create External Data Database Tools Add Ins Acrobat v s a z 2 2 gt amp Record 4 4 10f1 KK No Filter Search Form View Num Lock E 3 dB Le 2 Use the following table to determine your next step Do you want to Do this Import a diskette file e Click Import Diskette Import a NAUPA file e Click Import NAUPA Import a 389 file e Click Import 389 Import HDT e Click Import HDT Import Diskspecs Excel e Import Excel 3 Further instruct
23. eet Import Excel Search New folder Date modified Type 02 12 2014 8 32 AM Text Document 4 The file will automatically process when completed Click the Exit icon 5 When you return to the Switchboard screen you can Edit the Report and Accounts 49 UPLOAD TEXT FILE FORMAT All fields are Text fields no numeric currency or date formatting allowed Fields marked in red are mandatory file will not load if left blank Positions Field Length Remarks 1 2 PHOPTYPE 2 NY property type code 3 8 RECCOUNT 6 Repeat for multi owner 9 MULTOWNR 1 Blank or X 10 29 LAST 20 30 39 FIRST 10 40 MID 1 41 43 SUFFIX 3 44 73 ADDRESS1 30 74 103 ADDRESS2 30 104 123 CITY 20 124 125 STATE 2 126 134 ZIP 9 135 144 COUNTRY 10 145 153 SOCSECNO 9 No hyphens 154 173 ACCTID 20 No special characters 174 243 ACCTTITLE 70 No special characters 244 249 ACTIVDATE 6 MMDDYY 250 258 INITAMT 9 No dollar signs 259 267 ESCHAMT 9 HHHHHH ABE 268 REMINDIC 1 blank 269 338 SECDISCR 70 Stock Issue Name 339 347 CUSIPNO 9 348 351 CUSIPEXPAN 4 352 364 NOSHARES 13 Number of shares 365 TRANSFER 1 Stock Transfer Method 366 367 CLASS 2 Blank 368 373 PAY 6 Blank 50 374 375 UNIQUE 2 Blank 376 377 YEAR 2 Blank 378 379 RPTNO 2 Blank 380 RPTTYPE 1 Blank 381 389 FEIN 9 Reporting Organizations FEIN
24. et arizona 51 USE THESE INSTRUCTIONS TO IMPORT AND USE THE EXCEL IMPORT FILES 51 TROUBLESHOOTING ERROR MESSAGES 6 occcisiasessiecescetisssesescossscasasdscecesseuseacieceeteteccoveusissecseeseadecdeastsesednesescees 53 Overview To eliminate paper reporting and simplify the reporting process the New York State Comptroller s Office of Unclaimed Funds has developed an electronic reporting system You can obtain the application on CDROM or you can download a copy from OSC s Unclaimed Funds Internet Site Important features are The application s windows are arranged in a manner that leads you through the reporting procedure correctly The application utilizes Microsoft amp Access a relational database Using a relational database reduces data redundancy You only need to enter account information once when reporting a multiple owner account Each account usually has two kinds of information the account information and the owner information The Account Owner window shows the account information on the left side of the window and the owner information on the right Copy features allow you to copy an account title from the Owner Name field and to copy the address for multiple owners with the same address The application links all owners to an account if the account has more than one owner Online help provides instruction for using the application Whenever you have a question simply press the F1 key to ope
25. he DXCL95 xls spreadsheet is based upon the Upload Format The same column header names should be used in the same order as the Upload Format All columns and cells should be formatted to Text not general currency date or numeric Do not delete or re order any columns within the spreadsheet A copy of the DXCL95 xls spreadsheet is available from our office Contact NYSRPU osc state ny us for a copy of the spreadsheet 32 Troubleshooting Error Messages 1 If you receive a Security Alert VBA Macro Go to Access Access Options Trust Center Settings Enable all macros 2 If you receive the message No current record Add information to Report Contact 3 If you receive the message Object Find Contact already exists You will need to delete the query entitled Find Contact If you have Microsoft Access close out of the database Hold down the Shift Key and reopen the database This will open the database in Edit mode Locate Queries and the query Find Contact Delete the query Find Contact and close the database Home Create External Data Database Tools Add Ins b 2 i ES E 3 a New Totals 21 d 7 Selection Ga EH d Sac S TIER SI Esa Spelling 4l VjAdvanced m View Paste liz iz Refresh a Filter Sizeto Switch Find 7 ai CT Aan X Delete ES More 22 W Toggle Filter Fit Form Windows e R Views Clipboard Sort amp Filter Window Find
26. ions are described for each import Note Contact us if you have questions or need a new import for your organization Entering and Editing Report Information Use these instructions to enter and edit report information From the Switchboard window 1 In the Reporter FEIN field 1 Type your FEIN 2 In the Report Year field 2 Type the report year YYYY This is the year that you are filing the Report 3 In the Report Number field 3 Type the report number If there is only one report type in 01 4 Click Enter Edit Report 4 The VERIFICATION AND CHECKLIST FOR UNCLAIMED PROPERTY window appears ed cM Reporting Organization Name ERRE EER Area Division Number 2 Select Report Class Report Year 201 4 4 H a S Report Number foi 5 Section Article Report Type E D 1 6 Enter Edit Aci ants Di F1 For Help F Home Create External Data Database Tools Add Ins Acrobat AC2709 Rev 3 99 New York State Comptroller OFFICE OF UNCLAIMED FUNDS 110 State Street Albany NY 12236 VERIFICATION AND CHECKLIST FOR UNCLAIMED PROPERTY ALL PROPERTY TYPES Please correct and or fill in all information Verification for Period Ending 12 31 2013 8 Incorporation State pe GH Date 08 05 1985 1 0 Are you authorized to do business in NYS e 1 1 Federal Empl ID No 251783727 12 FTP Date TimeStamp a 1 3 Contact Information dr x Enter Edit Report Contact
27. middle initial In the Last Name field 17 e Type the owners last name In the Suffix field 18 e Pull down the list and select the appropriate suffix 13 In the Account Title field 19 type the names and relationships of all owners and beneficiaries as reflected on the reporting organization s records When the account title and name are the same type the owner s name in the Account Title field or click Copy Owner Name 20 and the system automatically completes the field 14 Use the following table to provide address information In this field Do this Address 21 e Type the owner s last known street address or care of data If unknown leave blank City 22 e Type the owners last known city of residence State 23 e Pull down the list and select the appropriate state code Zip 24 e Enter a five digit zip code You may also include a four digit supplementary zip code If unknown leave blank 15 Use the following table to provide additional address information If the owner s Then last known address is in The United e Leave the Province Country States and Foreign Zip Code fields blank A country other In the Province field 25 than the United e Type the name of the owner s province In the Country field 26 e Type the name of the owner s country In the Foreign Zip Code field 27 e Type the foreign zip code States
28. n the help window and locate the necessary information Requirements The Diskette Reporting Package will run on a Windows Platform computer You ll need about 5 megabytes free disk space to load and run its programs and files It should run well on any computer with at least 32M of RAM and a Pentium processor On newer computers please make sure you have ADMINISTRATOR rights on your own computer before downloading and installing software Please CONTACT your computer department for assistance if you do not have ADMINISTRATOR rights Installing the NYCD application Use these instructions to install the NYCD application 1 Use the following table to determine your first step If you Then Download the NYCD ZIP file Using Windows Explorer or My from the Internet Computer navigate to the NYCD ZIP file you just downloaded then double click on it Using Windows Explorer or My Computer go to the Folder NYCD First read Important Instructions Before Installing New NYCD pdf When previous completed Double Click setup exe Received the application on CD Insert the CD ROM ROM Using Windows Explorer or My Computer go to the Folder NYCD First read Important Instructions Before Installing New NYCD pdf When previous completed Double Click setup exe Organize v Include in library Share with v New folder gv E e Favorites Name BE Desktop dl Files 03 05 2014 0
29. o Attention of field 10 Type the name of the person you want to receive mail 8 Use the following table to provide address information In this field Do this Address 11 e Type the contact s street address City 12 e Type the contact s city State 13 e Pull down the list and select the appropriate state code Zip 14 e Enter a five digit zip code You may also include a four digit supplementary zip code 9 Use the following table to provide additional address information If the contact s Then address is in The United e Leave the Province and Country States fields blank A country other In the Province field 15 than the United e Type the name of the contact s province In the Country field 16 e Type the name of the contact s country States 10 In the Phone Number field 17 Type the contact s telephone number 11 In the Fax Number field 18 Type the contact s Fax number 12 In the E mail Address field 19 Type the contact s e mail address 13 When you have finished providing contact information Click the Exit icon 20 This will save the record and open the VCL window 14 On the VCL Screen click Enter Edit Accounts 15 GF TY 10 uw 11 12 T 4 Enter E dit Report Contact 14 Enter E dit Executive Contact 15 The Account Owner window appears See Account Owner Help F1 for further information Entering
30. ty information for the first owner When you exit the application the system automatically updates all other owner accounts associated with a multiple owner account with this information Once you exit the Accounts Edit screen you will be returned to the VCL screen If you exit the VCL screen 16 you will be returned to the Switchboard The screen will blink three times as the program calculates the account owner property information as well as section article and report totals Using the Checks and Balances Window 8 E amp Accounts The Checks and Balances select Checks and Balances itchboard lays the calculat Sw From the main int on your ions pr These calculati for each report you select IONS isp dow di VCL win k the indow clic k Property Type Totals and the IC cli dual property type totals ivi If you want to close the Checks and Balances w ind dow appears In If you want to determine Totals w Exit icon Print VCL Verification and Checklist e Click Print VCL e You must print the VCL and send it with the report e f you can t print your VCL you may need to enter the appropriate contact data Non fork Stra Canatc u Once OF UNCLAIMED FUNDS 110 STATE STREET port Reference Mo Altuany NY 12296 0001 VEXEFCAT ON AND CHECKLIST PON UNCLAIMED PROPERTY Parm omun and correct an cec aux ny Werer fo Prod Ende dat
31. ype ai Files DI Cancel T Open as read only My Network Ge AL Open the file you want to import The file will automatically process when completed Click the Exit icon From the switchboard you can Edit the Report Contact and Accounts o OO A C You can view the NAUPA File Format here Working with New Diskette Reporting Layout Use these instructions to import and use the new diskette reporting layout Before you begin Make sure you know the name of the file you want to import 1 Click Import Report Note You don t need to enter the report s FEIN year and number This information is already in the diskette file External Data Database Tools Add Ins Acrobat X Import Diskette Import Naupa na Import 389 Unclaimed Funds Reporting Layout Upload Import 389 Import HDT File Layout Import HDT Import Excel Navigation Pane Record 4 lt 10f1 Mi ter Search 2 Click Import Diskette Open BL Look in Ea TESTDATA D e Det NY111111111200101 E NY541229715200101 u CE1065 NY112418191200101 NY541229715200102 History CF1066 NY141338310200101 Nv541229715200103 8 EXT00109 NY141641730200101 Nv580628465200101 NA594 NY146013200200101 E Nv581885168200101 Desktop NC977 E NY361239445200101 S NY953204551200101 Ni NG1067 S NY410879087200001 ia RPTRCYTAP M00000004
Download Pdf Manuals
Related Search