This page (revision-20) was last changed on 26-Nov-2021 10:22 by Meg McFarland

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
20 26-Nov-2021 10:22 18 KB Meg McFarland to previous
19 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
18 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
17 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
16 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
15 26-Nov-2021 10:22 17 KB Meg McFarland to previous | to last
14 26-Nov-2021 10:22 3 KB kparrott to previous | to last
13 26-Nov-2021 10:22 4 KB kparrott to previous | to last
12 26-Nov-2021 10:22 4 KB eyeung to previous | to last
11 26-Nov-2021 10:22 4 KB eyeung to previous | to last
10 26-Nov-2021 10:22 4 KB kparrott to previous | to last US_Annual_Qtrly_Reporting_GEN ==> Tax Reporting - US General
9 26-Nov-2021 10:22 4 KB jmyers to previous | to last
8 26-Nov-2021 10:22 4 KB jmyers to previous | to last
7 26-Nov-2021 10:22 4 KB jmyers to previous | to last
6 26-Nov-2021 10:22 4 KB jmyers to previous | to last
5 26-Nov-2021 10:22 4 KB jmyers to previous | to last
4 26-Nov-2021 10:22 5 KB jmyers to previous | to last
3 26-Nov-2021 10:22 7 KB jmyers to previous | to last
2 26-Nov-2021 10:22 8 KB jmyers to previous | to last
1 26-Nov-2021 10:22 39 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 4 removed 3 lines
!!What's New for Tax Year 2011
There are no file format changes in wage reporting for the state of Montana in tax year 2011.
At line 8 removed one line
However, the following file format changes in the standard EFW2 file are noted in the SSA bulletin which may affect clients using the standard EFW2 format to report wages to the state:
At line 10 removed 4 lines
*(W2 File) A new field, 'Kind of Employer' has been added to the RE Employer Record (position 174). This is a required field.
*(W2 File) A new field, 'Cost of Employer-Sponsored Health Coverage' has been added to the RW Employee Record (positions 463-473) and the RT Total Record (positions 295-309).
*(W2 File) A new field, 'Designated Roth Contributions Under a Governmental Section 457(b) Plan' has been added to the RO Employee Record (positions 111-121) and the RU Total Record (positions 145-159)
At line 15 changed one line
This document contains abbreviated set up requirement for the state of Montana only, please refer to the general document ([US_Annual_Qtrly_Reporting_GEN]) for other setup procedure that may also be required.
This document contains abbreviated set up requirements for the State of Montana only. Please refer to the general document ([Tax Reporting - US General]) for other setup procedures that may also be required.
At line 18 changed one line
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up for ‘State Registration’ for State/Province: Montana.
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up for ‘State Registration’ for State/Province: Montana.
At line 23 changed one line
*The [IDGV Definition|IDGV#DefinitionTab]tab must be set up with ‘State SUI Registration’ for State/Province: Montana.
*The [IDGV Definition|IDGV#DefinitionTab] tab must be set up with ‘State SUI Registration’ for State/Province: Montana.
At line 27 changed one line
!!State File Procedures
!State File Procedures
At line 29 changed one line
*Records required for the W2 reporting are: Codes RA,RE,RW,RS,RT,RF; and for the UI wage reporting: Code A,B,E,S,T,F.
*Records required for the W2 reporting are: Codes RA, RE, RW, RS, RT and RF
*Records required for the UI wage reporting: Codes A, B, E, S, T and F.
At line 34 changed 7 lines
!Annual W2 Wage Reporting – EFW2 File Format
[RPYEU] must be run and the following selected to generate Montana state file information:
|Report List Filters, Select State:|Montana, USA
|Parameters, Annual Form Code:|(example: use standard form code‘HL$US-W2-2012’)
|Parameters, Period Type:|Year
|Parameters, Period End Date:|Year End Date (i.e. 31-Dec-2011)
|Parameters, Media Format:|State File Format
!!Annual W2 Wage Reporting – EFW2 File Format
[RPYEU] must be run with the following report parameters and filters selected to generate the Montana State file information: \\ \\
At line 42 changed one line
The Directory and Media File Name parameters must be populated or an output file will not be produced.
__RPYEU Report Parameters__
|Annual Form Code|Use standard form code, such as 'HL$US-W2-YYYY'
|Period Type|Mandatory. Defines the period type. Enter "Year" for Annual reporting and "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period. Enter in DD-MM-YYY format
|Media Format|Mandatory. Set to State File Format \\Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
|Media File Name|Mandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced
At line 38 added 4 lines
__RPYEU Report Filters__
|Select State: Montana, USA
At line 45 changed one line
;Record name:Code RA - Transmitter Record (same as the federal code RA)
\\
!Record Name: Code RA – Submitter Record (Same as the Federal Code RA)
[{InsertPage page='W2_EFW2_RECORD_RA'}]
\\
!Record Name: Code RE – Employer Record (Same as the Federal Code RE)
[{InsertPage page='W2_EFW2_RECORD_RE'}]
At line 47 changed 12 lines
!Quarterly UI Wage Reporting – ICESA Format
[RPYEU] must be run and the following selected to generate Montana state file information:
|Media Format:|State SUI File Format
|Select State:|Montana, USA
* The state of Montana must be selected in the ‘Report List Filters’.
*Annual Form Code – Use the standard supplied form code HL$US-W2-2012. The Variables need to be entered in this form code for specific use in the installation.
*The ‘Quarterly Form Code’ must be entered in order to produce the UI wage file in [ICESA] format.
*Use the supplied form code ‘HL$US-QTR-2012’. The Variables need to be entered in this form code for specific use in the installation.
*Period Type:Quarter
*Period End Date:Enter the quarter end date, i.e. 30-Jun-2011
*Media File Type:State SUI File Format\\ \\
*If the Directory Name/Media File Name is not supplied, an output file will not be produced.
\\
!Record Name: Code RW – Employee Wage Record (Same as the Federal Code RW)
[{InsertPage page='W2_EFW2_RECORD_RW'}]
At line 60 changed 2 lines
!!Quarterly UI Wage Magnetic Media Reporting - ICESA Format
;Record name: Code A - Transmitter Record
!Record Name: Code RS - State Wage Record (Same as the Federal Code RS)
[{InsertPage page='W2_EFW2_RECORD_RS'}]
At line 63 changed 3 lines
!!ICESA for the State of Montana
* The format details are found at the [State of Montana Department of Labor and Industry|
http://uid.dli.mt.gov/tax/forms/magneticmediahandbook.pdf] website.
\\
!Record Name: Code RT - State Total Record (Same as the Federal Code RT)
[{InsertPage page='W2_EFW2_RECORD_RT'}]
\\
!Record Name: Code RF - Final Record (Same as the Federal Code RF)
[{InsertPage page='W2_EFW2_RECORD_RF'}]
!!Quarterly UI Magnetic Media Wage Reporting – ICESA Format
[RPYEU] must be run with the following report parameters and filters selected to generate the Montana State file information: \\ \\
__RPYEU Report Parameters__
|Annual Form Code|Use standard form code, such as 'HL$US-W2-YYYY' \\The Variables will need to be entered in this form code for specific use in the installation.
|Quarterly Form Code|Required. Use the supplied form code ‘HL$US-QTR-2012’. \\The Variables need to be entered in this form code for specific use in the installation.
|Period Type|Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the reporting period.
|Media Format|Mandatory. Set to State SUI File Format \\Defines the Federal file format for SSA reporting (includes 'RW' and 'RS' records).
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file. Must be defined or an output file will not be produced
|Media File Name|Mandatory. Defines the media file name of the data being uploaded. Must be defined or an output file will not be produced
__RPYEU Report Filters__
|Select State: Montana, USA
!ICESA Repoting for the State of Montana
The format details are found at the State of Montana Department of Labor and Industry website at \\
[http://uid.dli.mt.gov/Portals/55/Documents/Contributions-Bureau/dli-uid-ui009.pdf] . \\
!Record Name: Code A - Transmitter Record
||Column||Description||Source
|1| Record Identifier|Constant “A”
|2-5|Year|Enter the year this report is prepared for
|6-14|Transmitter’s Federal Employer Identification Number (FEIN)|Enter the transmitter’s Federal Employer ID number. \\Enter only numeric characters. Omit hyphen, prefixes & suffixes.
|15-18|Taxing Entity Code|Constant “UTAX”
|19-23|Blank|Fill with blanks
|24-73|Transmitter Name|Enter the name of the organization submitting the file. \\Enter the name exactly as the Employer is registered with the state Unemployment Insurance agency.
|74-113|Transmitter Street|Enter the street address of the organizationsubmitting the file.
|114-138|Transmitter City|Enter the city of the organization submitting the file.
|139-140|Transmitter State|Enter the standard two character FIPS postal abbreviation.
|141-153|Blank|Fill with blanks
|154-158|Transmitter Zip Code|Enter a valid zip code
|159-163|Transmitter Zip Code Extension|Use this field as necessary for the four digit extension of the zip code. \\Include hyphen in position 159. \\If unknown, fill with blanks.
|164-193|Transmitter Contact|Enter the title of individual from transmitter's organization who is responsible for the accuracy and completeness of the wage report.
|194-203|Transmitter Contact Telephone Number|Enter the telephone number where the transmitter's contact can be reached
|204-207|Telephone Extension/Box|Enter transmitter's telephone extension or message box.
|208-213|Tape Transmitter/Authorization Number|Not required by the State of Montana. Fill with blanks
|214|C-3 Data|Not required by the State of Montana. Fill with blanks
|215-219|Suffix Code|Not required by the State of Montana. Fill with blanks
|220|Allocation Lists|Not required by the State of Montana. Fill with blanks
|221-229|Service Agent ID|Not required by the State of Montana. Fill with blanks
|230-242|Total Remittance Amount|Not required by the State of Montana. Fill with blanks
|243-248|Media Creation Date|Enter date in MMDDYY format
|249-275|Blank|Will with blanks
!Record Name: Code B - Authorization Record
||Column||Description||Source
|1|Record Identifier|Constant “B”.
|2-5|Payment Year|Enter the year this report is being prepared for.
|6-14|Transmitter’s Federal EIN|Enter the transmitter’s Federal Employer ID number. \\Enter only numeric characters. Omit hyphens, prefixes & suffixes.
|15-22|Computer|Enter the manufacturer’s name.
|23-24|Internal Label|Not required by the State of Montana. Fill with blanks
|25|Blank|Fill with blanks
|26-27|Density|Not required by the State of Montana. Fill with blanks
|28-30|Recording Code (Character Set)|Constant "ASC"
|31-32|Number of Tracks|Not required by the State of Montana. Fill with blanks
|33-34|Blocking Factor|Not required by the State of Montana. Fill with blanks
|35-38|Taxing Entity Code|Constant “UTAX”
|39-146|Blank|Fill with blanks
|147-190|Organization Name|Not required by the State of Montana. Fill with blanks
|191-225|Street Address|Not required by the State of Montana. Fill with blanks
|226-245|City|Not required by the State of Montana. Fill with blanks
|246-247|State|Not required by the State of Montana. Fill with blanks
|248-252|Blank|Enter blanks
|253-257|Zip Code|Not required by the State of Montana. Fill with blanks
|258-262|Zip Code Extension|Not required by the State of Montana. Fill with blanks
|263-275|Blank|Fill with blanks
!Record Name: Code E - Employer Record
||Column||Description||Source
|1|Record Identifier|Constant “E”
|2-5|Year|Enter the year this report is being prepared for.
|6-14|Employer’s Federal EIN|Enter the employer’s Federal Employer ID number. \\Enter only numeric characters. Omit hyphens, prefixes & suffixes.
|15-23|Blank|Fill with blanks
|24-73|Employer Name|Enter the name of the Employer reporting wage and tax data. Enter the name Exactly as the employer is registered with the state Unemployment Insurance agency.
|74-113|Employer Street Address|Enter the street address of the Employer
|114-138|Employer City|Enter the city of the Employer’s mailing address.
|139-140|Employer State|Enter the standard two character FIPS postal abbreviation.
|141-148|Blank|Fill with blanks
|149-153|Employer Zip Code Extension|Enter four-digit extension of zip code. Include the hyphen in position 149. \\If unknown, fill with blanks.
|154-158|Employer Zip Code|Enter a valid zip code
|159|Name Code|Not required by the State of Montana. Fill with blanks
|160|Type of Employment|Not required by the State of Montana. Fill with blanks
|161-162|Blocking Factor|Not required by the State of Montana. Fill with blanks
|163-166|Establishment Number or coverage Group/PRU|Not required by Montana.
|167-170|Taxing Entity Code|Constant “UTAX”
|171-172|State Identifier Code|Enter the state FIPS postal numeric code for the State the wages are being reported for. Montana is "30".
|173-187|State UI Employer Account Number|Enter the State UI employer account number
|188-189|Reporting Period|Enter the last month of the calendar quarter the report applies to. \\Enter “03”= 1st Quarter, “06”= 2nd Quarter, “09”= 3rd Quarter or “12”= 4th Quarter
|190|No Workers/No Wages|Enter '0' to indicate that the E record will not be followed by S records (employee records). \\Enter '1' to Indicate that the E record will be followed by S records (employee records).
|191|Tax Type Code|Not required by the State of Montana. Fill with blanks
|192-196|Taxing Entity Code|Not required by the State of Montana. Fill with blanks
|197-203|State Control Number|Not required by the State of Montana. Fill with blanks
|204-208|Unit Number|Not required by the State of Montana. Fill with blanks
|209-255|Blank|Not required by the State of Montana. Fill with blanks
|256|Foreign Indicator|Not required by the State of Montana. Fill with blanks \\If data in positions 74-158 is for a foreign address, enter the letter “X”. Otherwise, fill with a blank. \\
|257|Type of Information|If file contains only tax information, enter a “T”. \\If file contains both wage and tax information, enter a “B”.
|258-266|Other EIN|Not required by the State of Montana. Fill with blanks
|267-275|Blank|Fill with blanks
!Record Name: Code S - Employee Record
||Column||Description||Source
|1|Record Identifier|Constant “S”.
|2-10|Social Security Number|Enter the employee’s Social Security number. \\If not known, enter “I” in position 2 and blanks in positions 3-10. \\If an invalid SSN is encountered, this field is filled with zeroes
|11-30|Employee Last Name|Enter the employee’s last name.
|31-42|Employee First Name|Enter the employee’s first name
|43|Employee Middle Initial|Enter the employee’s middle initial. If no middle initial, enter a blank.
|44-45|State Code|Enter the state FIPS postal numeric code for the State the wages are being reported for. \\Montana is "30"
|46-49|Reporting Quarter and Year|Enter the last month and year for the quarter this report applies to. Example “03YY” Jan-March of 20YY.
|50-63|State Quarter Total Gross Wages|Not required by the State of Montana. Fill with blanks
|64-77|State Quarter UI Total Gross Wages|Enter the total quarterly gross wages subject to Unemployment taxes. \\Include all tip income. \\Right justify and zero fill all money fields.
|78-91|State Quarter UI Excess Wages|Enter the Quarterly wages in excess of the State UI taxable wage base. \\For Governmental or Reimbursable accounts, excess must be zeros. \\Right justify and zero fill all money fields.
|92-105|State Quarter UI Taxable Wages|Enter the State quarterly UI total wages minus State quarterly UI excess wages. \\For Governmental and Reimbursable employers, must be equal to the “State Quarter UI Total Gross Wages”. \\Right justify and zero fill all money fields.
|106-142|Not Required|Not required by the State of Montana. Fill with blanks
|143-146|Taxing Entity Code|Constant “UTAX”
|147-161|State UI Employer Account Number|Enter the State account number assigned for unemployment insurance reporting purposes.
|162-211|Not Required|Not required by the State of Montana. Fill with blanks
|212|Month 1 Employment|Enter “1” if employee covered by UI worked during or received pay for the pay period including the 12th day of the 1st month of the reporting period. \\Enter “0” if employee covered by UI did not work and received no pay for the pay period including the 12th day of the 1st month of the reporting period. \\Enter blanks if not available.
|213|Month 2 Employment|Enter “1” if employee covered by UI worked during or received pay for the pay period including the 12th day of the 2nd month of the reporting period. \\Enter “0” if employee covered by UI did not work and received no pay for the pay period including the 12th day of the 2nd month of the reporting period. \\Enter blanks if not available.
|214| Month 3 Employment|Enter “1” if employee covered by UI worked during or received pay for the pay period including the 12th day of the 3rd month of the reporting period. \\Enter “0” if employee covered by UI did not work and received no pay for the pay period including the 12th day of the 3rd month of the reporting period. \\Enter blanks if not available.
|215-220|Blanks|Fill with blanks
|221-232|Not Required|Not required by the State of Montana. Fill with blanks
|233-275|Blank|Fill with blanks
!Record Name: Code T - Total Record
||Column||Description||Source
|1|Record Identifier|Constant “T”
|2-8|Total Number of Employees|Enter the total number of “S” records reported since the last “E” record. \\Right justify and zero fill.
|9-12|Taxing Entity Code|Constant “UTAX”
|13-26|State Quarter Total Gross Wages for Employer|Not required by Montana.
|27-40|State Quarter UI Total Gross Wages for Employer|Enter the Quarterly Gross Wages subject to State UI Tax. \\Include all tip income. \\Total of this field on all “S” records since the last “E” record. \\Right justify and zero fill all money fields.
|41-54|State Quarter UI Excess Wages for Employer|Enter the Quarterly Wages in excess of the state UI Taxable wage base. \\ Total of this field on all “S” records since the last “E” record. \\For Governmental or Reimbursable Employers, excess must be zeros. \\Right justify and zero fill all money fields.
|55-68|State Quarterly UI Taxable Wages for Employer|Enter the State quarterly UI Total Gross Wages minus State quarterly UI Excess Wages. \\Total of this field on all “S” records since the last “E” record. \\For Governmental and Reimbursable Employers, must be equal to “State Quarter UI Total Gross Wages”. \\Right justify and zero fill all money fields.
|69-81|Quarterly Tip Wages for Employer|Not required by the State of Montana. Fill with blanks
|82-87|Total UI Tax Rate this Quarter|Enter the employer’s Total UI Tax rate for this reporting period. \\Decimal point followed by 5 digits. \\Example: 3.1% = .03100. \\For Regular and Governmental employers it is equal to the UI Contribution Rate plus the Administrative Fund Tax Rate as shown on the yearly rate notice covering this reporting period.
|88-100|State Quarterly UI Taxes Due|Enter the UI taxes due. \\Quarterly state UI taxable wages multiplied by the total UI tax rate. \\Right justify and zero fill all money fields.
|101-111|Previous Quarter(s) Adjustments|Enter any adjustments or amendments to previous quarter reports. \\Enter zeros if not applicable. \\Right justify and zero fill all money fields.
|112-122|Interest on Late Payments|Interest is computed at the rate of 1.5% per month or 18% per year of the amount in “State Quarterly UI Taxes Due” field. \\Enter zeros if not applicable. \\Right justify and zero fill all money fields.
|123-133|Penalty|The penalty for being late is $25.00. \\Enter zeroes if not applicable. \\Right justify and zero fill all money fields.
|134-144|Credit\Overpayment|Enter any overpayment existing on your account on the date this report was generated. \\Overpayments (credits) are subject to prior usage. \\Enter zeros if not applicable. \\Right justify and zero fill all money fields.
|145-174|Not Required|Not required by the State of Montana. Fill with blanks
|175-185|Total Payment Due|Enter the total of “State Quarterly UI Taxes Due” plus “Previous Quarter(s) Adjustments” plus “Interest” plus “Penalty”, minus any amount in “Credit/Overpayment”. \\Enter zeros if not applicable. \\Right justify and zero fill all money fields.
|186-226|Not Required|Not required by the State of Montana. Fill with blanks
|227-233|Month 1 Employment|Total number of employees covered by UI who worked on or received pay for the pay period including the 12th day of the first month of the reporting period. \\Enter blanks if not available.
|234-240|Month 2 Employment|Total number of employees covered by UI who worked on or received pay for the pay period including the 12th day of the second month of the reporting period. \\Enter blanks if not available.
|241-247|Month 3 Employment|Total number of employees covered by UI who worked on or received pay for the pay period including the 12th day of the third month of the reporting period. \\Enter blanks if not available.
|248-267|Not Required|Not required by the State of Montana. Fill with blanks
|268-275|Blanks|Fll with blanks
At line 216 added 9 lines
!Record Name: Code F - Final Record
||Column||Description||Source
|1|Record Identifier|Constant “F”
|2-139|Not Required|Not required by the State of Montana. Fill with blanks
|140-275|Blank|Fill with blanks