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.

Tobacco Wholesaler, Schedule D, Sales for Resale and Manufacturer Reports

These templates have been designed to assist filing tobacco reports in MAT. If you have a large volume of information that is needed to complete your tobacco reports, the templates can be a helpful tool to import data into your MAT reports.

Go to MAT

General Directions

  • When copying and pasting columns from your spreadsheet into the template you can choose to copy one column or several columns at a time. You are not allowed to copy and paste into cells where the Department has formulas (tax value column).
  • Complete the templates by placing all data in the template that you wish to import into MAT before importing.
  • If you are using the templates to complete the MAT reports, always import information before keying any information into MAT. The imported data will override what has been keyed or previously imported into MAT.
  • If an error is made while copying/pasting it cannot be corrected until the report is imported into MAT. Otherwise, you must start a new template.
  • The copied information must be in the same format of the template or the import will not be successful.
  • The template must be saved before it can be imported into MAT.
  • After the data from the template is imported, corrections can be made and information added into MAT.

Resident Wholesaler Report

  • Beginning inventory figures and stamp purchases are automatically pre-populated into MAT.
  • Only lines 8, 9 and 16 needs to be completed on Part I. All other lines in Part I will prepopulate from the information stored in our system or upon completion of Parts II, III, IV, V and Schedule C.
  • You may elect to copy and paste information into the different parts and the Schedule C. This information has to line up in the columns in the exact same format as the template.
  • The maximum number of rows that can be imported on the Schedule C table is 32,046. If you have data that exceeds this number of rows, the template also includes three additional overflow tables (Schedule C Overflow, Schedule C Overflow 2 and Schedule C Overflow 3.) Please use these overflow tables to include additional sales. The tables must be used in consecutive order for the data to be submitted correctly.

Nonresident Wholesaler Report

  • Beginning inventory figures and stamp purchases are automatically pre-populated into MAT.
  • Only lines 2, 4 and 11 need to be completed on Part I. All other lines in Part I will prepopulate from the information stored in our system or upon completion of Schedule A. Only line 11 of Part II needs to be completed. All other lines will prepopulate from our system. All information for Part III will populate upon completion of Schedules C, D and E.
  • If using the Schedule A template, the correct county code must be put in the county code column. Otherwise, after importing the report into MAT, you will have to add the county code before submitting the report to the Department. This code can be obtained from the top of the Schedule A or the last tab in the template. Even though the counties may be copied in the county column, the county code is still required to import the data. The county code can be programmed into your system from the listing provided by the department. A drop down box is also included for your convenience.

Frequent Schedule D Template Errors

  • If a brand name is not typed exactly as it appears in the drop down listing in My Alabama Taxes (MAT), the brand will not be uploaded from the template to MAT. You will receive an error message once the data has been uploaded to MAT. The cell will be highlighted and will not have any data. You will have to choose the correct brand name from the drop down listing.
  • If a roll-your-own brand does not have (RYO) typed behind the brand name, it will not be uploaded from the template to MAT. You will receive an error message once the data has been uploaded to MAT. The cell will be highlighted and will not have any data. You will have to choose the correct brand name with (RYO) typed behind the brand name from the drop down listing.
  • If you enter values for cigarettes and (RYO) for a brand on the same line, these values will not be uploaded to MAT. You will receive an error message and both cells will be highlighted. You will have to enter either a cigarette or (RYO) value and enter another line entry for the other related cigarette or (RYO) sales.
  • Any information copied from your computer generated printout cannot be edited in the template once it has been copied. You will either have to start a new template or upload the template and make corrections once the data has been uploaded into MAT.

Instructions for Completing the Sales for Resale Report

The Sales for Resale Report must be electronically filed via My Alabama Taxes (MAT). If you are reporting activity, use the template to import data into the MAT screen. If you are submitting a “No Activity” return, you must check the designated box.

Using the template

  1. Download the Sales for Resale Report template from the list above.
  2. Copy the data from your system into the downloaded template.
  3. Delete the column headers from Row 1.
  4. The fields of data from your system must exactly match the fields/columns in the template for it to import correctly.
  5. Save the template with a file name with a .CSV extension.  Example: July 2018 sales.csv.

What to do After Accessing MAT

  1. From the Account Id listing, click on the STP account link.
  2. Click on the File Return link for the month or period in which you are filing.
  3. Click the File Now link next to Tobacco Sales for Resale.
  4. Import the completed template.
    • Click File Upload.
    • Click Attach File.
    • Enter a Description in the Description Box.
    • Click Choose File or Browse, locate the file on your computer and then click Open. Note: Make sure the selected file does not contain column headings and is saved as a .CSV file prior to attaching or it will not import.
    • Then click Save.
  5. Verify that the template imports correctly and that there are no errors. Errors will be listed on the Invalid Records tab. The report cannot be submitted if it contains errors.
  6. Once any errors have been corrected, click Next.
  7. Click Submit.
  8. Enter your password and click Yes.
  9. A confirmation page will appear if the report was successfully submitted.

Questions

Tobacco Tax Section
P: 334-242-9627