Effective January 2009, the online system no longer allows individual filers to upload multiple W2/1099 files. If you have more than one file for the same account number, i.e.: regular payroll, executive payroll, miscellaneous income (1099s with Alabama income tax withheld), etc. you must combine your files before uploading them. A utility is provided for you to combine multiple files for uploading your W2/1099 information. Use the following steps:1) Download AL_W2_Append_Report_Check.xls (Updated: 04/08/2009) (right click on link to save file).
2) Open AL_W2_Append_Report_Check.xls.
A Security Warning will appear.
3) Select Enable Macros. If the Security Warning screen does not appear you will need to change the security setting.To change the Security Settings in either Excel and Word :
From the Menu select Tools, Macro, Security
Select the Security Level tab, then select the Medium option and click OK.
After changing this setting reopen the file and select Enable Macros.4) Select “Check File for Errors and Append Files” to start the process. If any of your files contain errors, you must correct the errors and start this process over.
5) You will be prompted to either type the path where your "W2Report" file will be saved or if it is located in one of the following directories use the dropdown box to select the :A:\
C:\Documents and Settings\......\My Documents\
C:\W2report\
6) A menu box will appear. Select your first file and click on the Selection button. Note: You can select multiple files by holding the CTRL key and selecting each file that you will be appending.
7) If you want to add one file at a time, select your first file, then select “Add Another File” to choose a file to append and continue the process until you have selected all of the files that you need to merge. Note: You can change the order of the files by rearranging the numbers in the “Order” field and selecting “Update Order”.
8) Select “Continue” to start the process of checking and appending your files. You must click “OK” to check and merge each file.
9) If there is an error in a file, the file will not be created and you will need to correct the errors shown on Sheet 1 and rerun the macro.
10) If you have no errors, you will receive a message with the location of your append file. You can now log onto the Department’s website to upload your new W2REPORT.txt file.
