An official website of the Alabama State government.
Here's how you know

The .gov means it's official

Government websites often end in .gov or .mil. Before sharing sensitive information, make sure you’re on an official government site.

The site is secure

The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

How to Use Excel Spreadsheet to Create A-1/A-6 File

Income Tax >
  • How to Use Excel Spreadsheet to Create A-1/A-6 File
More In Income Tax
Alabama Accountability Act
Electing Pass Through Entities
Withholding Tax
Corporate Income Tax Audit and Appeals
Online Estimate Payments and Extension Payments
Overtime Pay Exemption – Amended
Individual Income Tax Audit and Appeals
Audit Process – Corporate
Audit Process – Individuals
Software Vendor Information – Paper and MeF
Back To Income Tax Home

An Excel Spreadsheet has been created that has the required fields for the A-1/A-6 Bulk File that is already in the correct File Layout needed to upload the file. Instructions are listed below to show you how to upload this file.

  1. Download and save the A-1/A-6 Bulk Filing Spreadsheet . (Updated: 02/24/2024) (Use for files to upload after January 27, 2024.)
  2. Enter your A-1/A-6 information into the spreadsheet. More information about the various fields on the spreadsheet is available on the A-1/A-6 File Layout Description page. After you finish entering all your information, save your .xls file. NOTE: Please make sure that you have entered information in all the fields that are required. The required fields are noted in the column headings.
  3. Click the red button “Click Here To Export To Text File” to create your A1/A6 file. A menu box will appear. Select a location where you want to save your file.
  4. Please make a note of the name and location of your A1/A6 file.
  5. To upload your file, log in to My Alabama Taxes.
  6. Select the AGT (Agent) account. On the next page, select “Upload Bulk File” from the panel on the left, then select A1/A6 Bulk Return File from the menu on the next page.
  7. On the Bulk A1/A6 Upload page, click Attach File.  Enter a Description of the file, Browse for the file to upload, then click Save. Note: Please make sure you are uploading the .txt file instead of your saved Excel (.xls) spreadsheet. The system cannot process the file if it is saved as an Excel (.xls) worksheet.
  8. To view the results of your file, click on the Valid A1/A6(s) or Invalid A1/A6(s) hyperlink. If the results are Valid, click Submit to process your file. If Results are Partially Rejected with Valid and Invalid accounts, then you can Submit your file, but only Valid accounts will be processed.
  9. If the results are Invalid, you must correct all errors then resubmit your file. Open your original Excel (.xls) version of your A1/A6 Bulk File spreadsheet and make the required changes. Click in the red area to create your new file. Follow the previous steps to upload your new A1/A6 Bulk file.
  10. You will receive a Request Number for your file. Once the accounts in the file have been processed, you will receive a message in the Message Tab with your Bulk Filer Confirmation and request number. Click the Bulk Filer Confirmation hyperlink to view the Tracking (confirmation) Number for each account processed.