Today is Monday, October 20, 2014
Important Notices!
*****  Administrative Law Division Move Effective October 1st, 2014  *****
The Taxpayer Fairness Act transfers Revenue's Administrative Law Division to the newly-created Alabama Tax Tribunal; their website is now http://taxtribunal.alabama.gov/.
 
File Layout Instructions For Filing Alabama Lodgings Tax Returns
File Layout Instructions For Bulk Filing a File Into the State 4% & 5% Lodgings Tax Return

See the General Instructions for additional Bulk Filing information.

FILE LAYOUT:

From the "File Layout" page, define the content and order of your file. NOTE: When setting up your file, you must enter data in all required fields. Use the boxes or the up or down arrows next to the appropriate data fields to specify the order in which your data is contained in your file. If your data is in an order differently than what is displayed on the File Layout page, key that order in the appropriate box or click the up or down arrows to match your file layout, then press the "Refresh" button at the bottom middle of the page. The Fields of data displayed on the screen will then appear in the order you designated. Note also that you can specify that your file contains Filler Fields so that the system will bypass or ignore processing the data in that field.

Example:

Lodgings File Layout image

YOUR FILE SHOULD CONTAIN THE FOLLOWING FIELDS OF DATA FOR EACH RECORD IN YOUR FILE:

Account Number: The maximum size for this field is 10 characters. Please note that if your account number has a space, the space must be included in the field. NOTE: Your file must contain valid, active account numbers.

Period End: The maximum size for this field is 8 characters. The period end field in your record should be in the format of CCYYMMDD.

Frequency: The maximum size for this field is 1 character. The frequency field in your record must be the following frequency code: M = Monthly.

Total Gross Charges*: The maximum size for this field is 13 characters. This amount is the sum of the Gross Charges for all county locations.

Total Deductions Amt*: The maximum size for this field is 13 characters. This amount is the sum of the Deductions for all county locations.

Total Tax Due*: The maximum size for this field is 13 characters. The total tax due is the total tax for all county locations, before any discounts, credit claimed, or penalty and interest.

Credit Claimed*: The maximum size for this field is 13 characters. NOTE: Any credit for prior overpayment must be approved in advance by the ADOR. Credit claimed should not exceed the Total Amount Due. Valid excess credit can be claimed on subsequent returns.

Payment Method: The maximum size for this field is 1 character. The payment method field in your record can be any one of the following payment method codes:
M = Mail by check
E = EFT Debit
V = EFT Credit
Z = Zero Tax Due
X = E-File without payment

Funding Source:  The maximum size for this field is 1 character. This field pertains to whether or not an EFT payment is an International ACH Transaction (IAT). This field can be N (not IAT) or Y (IAT). This is a REQUIRED field if Payment Method is E.

Address:  The maximum size for this field is 35 characters. This is a required field if Funding Source equal Y.

City:  The maximum size for this field is 33 characters. This is a required field if Funding Source equal Y.

State:  The maximum size for this field is 2 characters. This is a required field if Funding Source equal Y.

Zip:  The maximum size for this field is 5 characters. This is a required field if Funding Source equal Y.

Zip +4:  The maximum size for this field is 4 characters. This is a required field if Funding Source equal Y.

Payment Date (CCYYMMDD): The maximum size for this field is 8 characters. The payment date field in your record should be in the format of CCYYMMDD. The Payment Date only applies to current returns filed before the Remit Due Date and cannot be a date beyond the Remit Due Date. This is a REQUIRED field if you are using payment method code E and filing current returns.

Bank Account Type: The maximum size for this field is 1 character. This field is required if payment method E is used. The bank account type field in your record can be either C for checking or S for savings.

Bank Routing Number: The maximum size for this field is 9 characters. This field is required if payment method E is used.

Bank Account Number: The maximum size for this field is 18 characters. This field is required if payment method E is used.

Repeatable Fields: Report state lodgings tax by county business locations. Therefore, these three fields may be repeated at the end of each record for each county location:

  • County Code: The maximum size is 4 characters. This is a required field. For a list of these codes, click here.
  • Gross Charges: The maximum size is 11 characters. This is a required field. This amount is the total gross charges for the county location.
  • Deductions: The maximum size is 11 characters. This is a required field. This amount is the total deductions for the county location.

*FOR ALL DOLLAR FIELDS: You may use implied decimals in your file and if so, select "Implied Decimals" from the drop box on the "File Layout" page. The system defaults to 2 decimal places unless you specify otherwise. Or, you may use decimals in the gross amounts reported in your file. If “Implied Decimals” is chosen, then all fields included in the calculation of the Amount of Tax should be implied, as well as the Amount of Tax field. No field may contain a decimal, including the Amount of Tax field. If using decimals, select "No Implied Decimals" from the drop box.  NOTE: Enter only valid numbers in the dollar amount field of your file. Do not enter alpha characters or symbols of any kind, such as negative numbers. However, you may use the currency style format (i.e. $123,000.00) provided you use a string qualifier. For example: "$123,000.00".  NOTE: If filing a zero-dollar return, you must complete the repeatable fields for each county location and report zero in the gross charges and deductions fields.

Once you have selected your File Layout, press the "Continue" button found at the bottom right portion of the page to select your file to upload.