These templates have been designed to assist filing tobacco reports in My Alabama Taxes. 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 My Alabama Taxes reports.
- Schedule D Template
- Resident Wholesaler Template
- Nonresident Wholesaler Template
- Sales for Resale Report Template
- Manufacturer Report Template
- Sales for Resale Report Template (Effective July 2018)
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 ALDOR has formulas (tax value column).
- Complete the templates by placing all data in the template that you wish to import into My Alabama Taxes before importing.
- If you are using the templates to complete the My Alabama Taxes reports, always import information before keying any information into My Alabama Taxes. The imported data will override what has been keyed or previously imported into My Alabama Taxes.
- If an error is made while copying/pasting, then it cannot be corrected until the report is imported into My Alabama Taxes. 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 My Alabama Taxes.
- After the data from the template is imported, corrections can be made and information added into My Alabama Taxes.
Resident Wholesaler Report
- Beginning inventory figures and stamp purchases are automatically pre-populated into My Alabama Taxes.
- Only lines 8, 9 and 16 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 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 must 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 My Alabama Taxes.
- 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 My Alabama Taxes, you will have to add the county code before submitting the report to ALDOR. 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 ALDOR. 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, the brand will not be uploaded from the template to My Alabama Taxes. You will receive an error message once the data has been uploaded to My Alabama Taxes. 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 My Alabama Taxes. You will receive an error message once the data has been uploaded to My Alabama Taxes. 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 My Alabama Taxes. 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 My Alabama Taxes.
Instructions for Completing the Sales for Resale Report
The Sales for Resale Report must be electronically filed through My Alabama Taxes. If you are reporting activity, use the template to import data into My Alabama Taxes. If you are submitting a “No Activity” return, you must check the designated box.
Using the template
- Download the Sales for Resale Report template from the list above.
- Copy the data from your system into the downloaded template.
- Delete the column headers from Row 1.
- The fields of data from your system must exactly match the fields/columns in the template for it to import correctly.
- Save the template with a file name with a .CSV extension. Example: July 2018 sales.csv.
What to do After Accessing My Alabama Taxes
- From the Account Id listing, click on the STP account link.
- Click on the File Return link for the month or period in which you are filing.
- Click the File Now link next to Tobacco Sales for Resale.
- 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.
- 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.
- Once any errors have been corrected, click Next.
- Click Submit.
- Enter your password and click Yes.
- A confirmation page will appear if the report was successfully submitted.