U.S. flag An official website of the United States government.

Dot gov

The .gov means it's official.
Federal government websites always use a .gov or .mil domain. Before sharing sensitive information online, make sure you’re on a .gov or .mil site by inspecting your browser's address (or "location") bar.

SSL

This site is also protected by an SSL (Secure Sockets Layer) certificate that's been signed by the U.S. government. The https:// means all transmitted data is encrypted  — in other words, any information or browsing history that you provide is transmitted securely.

AL W2 Append Report

My Alabama Taxes (MAT) does not allow 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, other income (1099s with Alabama income tax withheld), etc. you must combine your files before uploading. This utility is provided for you to combine multiple files for uploading your W2/1099 information.

Note: This program is ONLY for merging multiple W2/1099 files to upload in MAT.

Download Program

How to Use Program

    1. Download append program (Updated:01/31/2018).
    2. Open AL_W2_Append_Report.xls. A Security Warning will appear.
      Security Warning Image

 

    1. 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, SecuritySecurity Menu

      Select the Security Level tab and click the Medium bullet, then click OK.

      After changing this setting reopen the file and select Enable Macros.

 

    1. You will receive the window below, select “Yes” to open as read-only.

 

    1. Click the “Append Files” button to start the process.BUTTON

 

    1. You will be prompted to either type the path where your “w2report.txt” file will be saved or if it is located in one of the following directories you can use the dropdown box to select the directory:
      • A:\
      • C:\Documents and Settings\……\My Documents\
      • C:\W2report\

 

    1. A menu box will appear.
      Note:  You can select multiple files by holding the CTRL key and selecting each file that you will be appending.

 

    1. If you want to add one file at a time, select your first file then click the “Add Another File” button to select a second file. 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 then click on the “Update Order” button.

 

    1. Select “Continue” to start the process of appending your files.You must click “OK” to append each file.

 

    1. If there are any errors in a file, the files will not be appended. You must correct all errors shown and restart the append process.

 

    1. If your files have no errors, you will receive a message with the location of your appended file. You can then log onto the Department’s website to upload your new w2report.txt file.