Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

State specific payroll information

Minnesota withholding worksheets file formats

For payroll compliance (annually licensed)
The files for the Minnesota withholding worksheets (MW-1, MW-6, and MW-1A) are created using very specific formats and you must ensure that your format selections match those listed in the following tables.

MW-1 Worksheet format requirements

Order
Field Description
Length
Format
Field
1
Minnesota tax ID number
7
Text
Required
2
Tax period
10
Text
Required
3
Wages paid
14
Text
Required
4
Number of employees
5
Text
Required
5
Deposit amount
14
Text
Required
6
Amount due overpaid
14
Text
Required
7
Credit refund indicator
1
Text
Required
8
Date tax withheld 1, month 1
10
Text
Required
9
Amount withheld 1, month 1
14
Text
Required
10
Date tax withheld 2, month 1
10
Text
Not Required
11
Amount withheld 2, month 1
14
Text
Not Required
12
Date tax withheld 3, month 1
10
Text
Not Required
13
Amount withheld 3, month 1
14
Text
Not Required
14
Date tax withheld 4, month 1
10
Text
Not Required
15
Amount withheld 4, month 1
14
Text
Not Required
16
Date tax withheld 5, month 1
10
Text
Not Required
17
Amount withheld 5, month 1
14
Text
Not Required
18
Date tax withheld 6, month 1
10
Text
Not Required
19
Amount withheld 6, month 1
14
Text
Not Required
20
Date tax withheld 7, month 1
10
Text
Not Required
21
Amount withheld 7, month 1
14
Text
Not Required
22
Date tax withheld 8, month 1
10
Text
Not Required
23
Amount withheld 8, month 1
14
Text
Not Required
24
Date tax withheld 1, month 2
10
Text
Required
25
Amount withheld 1, month 2
14
Text
Required
26
Date tax withheld 2, month 2
10
Text
Not Required
27
Amount withheld 2, month 2
14
Text
Not Required
28
Date tax withheld 3, month 2
10
Text
Not Required
29
Amount withheld 3, month 2
14
Text
Not Required
30
Date tax withheld 4, month 2
10
Text
Not Required
31
Amount withheld 4, month 2
14
Text
Not Required
32
Date tax withheld 5, month 2
10
Text
Not Required
33
Amount withheld 5, month 2
14
Text
Not Required
34
Date tax withheld 6, month 2
10
Text
Not Required
35
Amount withheld 6, month 2
14
Text
Not Required
36
Date tax withheld 7, month 2
10
Text
Not Required
37
Amount withheld 7, month 2
14
Text
Not Required
38
Date tax withheld 8, month 2
10
Text
Not Required
39
Amount withheld 8, month 2
14
Text
Not Required
40
Date tax withheld 1, month 3
10
Text
Required
41
Amount withheld 1, month 3
14
Text
Required
42
Date tax withheld 2, month 3
10
Text
Not Required
43
Amount withheld 2, month 3
14
Text
Not Required
44
Date tax withheld 3, month 3
10
Text
Not Required
45
Amount withheld 3, month 3
14
Text
Not Required
46
Date tax withheld 4, month 3
10
Text
Not Required
47
Amount withheld 4, month 3
14
Text
Not Required
48
Date tax withheld 5, month 3
10
Text
Not Required
49
Amount withheld 5, month 3
14
Text
Not Required
50
Date tax withheld 6, month 3
10
Text
Not Required
51
Amount withheld  6, month 3
14
Text
Not Required
52
Date tax withheld 7, month 3
10
Text
Not Required
53
Amount withheld 7, month 3
14
Text
Not Required
54
Date tax withheld 8, month 3
10
Text
Not Required
55
Amount withheld 8, month 3
14
Text
Not Required
If the filing method is Internet with payment, the following rows must be included.
Order
Field Description
Length
Format
Field
56
Bank Type Indicator
1
Text
Not Required
57
Bank Routing Number
9
Text
Not Required
58
Bank Account Number
17
Text
Not Required
59
Payment Date
10
Text
Not Required
60
Recent Deposit
14
Text
Not Required
61
Recent Deposit Date
10
Text
Not Required

MW-6 Worksheet format requirements

Order
Field Description
Length
Format
Field
1
Minnesota tax ID number
7
Text
Required
2
Tax period
10
Text
Required
3
Wages paid
14
Text
Required
4
Number of employees
5
Text
Required
5
W-2 total
14
Text
Required
6
Tax reported 3/31
14
Text
Required
7
Tax reported 6/30
14
Text
Required
8
Tax reported 9/30
14
Text
Required
9
Deposit amount
14
Text
Required
10
Tax due or overpaid
14
Text
Required
11
Credit / Refund Indicator
1
Text
Required
12
Construction Contractor Tax Withheld
14
Text
Not Required
If the filing method is Internet with payment, the following rows must be included.
Order
Field Description
Length
Format
Field
13
Bank Type Indicator
1
Text
Not Required
14
Bank Routing Number
9
Text
Not Required
15
Bank Account Number
17
Text
Not Required
16
Payment Date
10
Text
Not Required
17
Recent Deposit
14
Text
Not Required
18
Recent Deposit Date
10
Text
Not Required

MW-1A Worksheet format requirements

Order
Field Description
Length
Format
Field
1
Minnesota tax ID number
7
Text
Required
2
Tax period
10
Text
Required
3
Wages paid
14
Text
Required
4
Number of employees
5
Text
Required
5
W-2 total
14
Text
Required
6
Deposit amount
14
Text
Required
7
Tax due or overpaid
14
Text
Required
8
Construction Contractor Tax Withheld
14
Text
Not Required
If the filing method is Internet with payment, the following rows must be included.
Order
Field Description
Length
Format
Field
9
Bank Type Indicator
1
Text
Not Required
10
Bank Routing Number
9
Text
Not Required
11
Bank Account Number
17
Text
Not Required
12
Payment Date
10
Text
Not Required
13
Recent Deposit
14
Text
Not Required
14
Recent Deposit Date
10
Text
Not Required

This article applies to:

  • Product: Accounting CS
  • State: Minnesota
  • Subject: Payroll checks,Payroll tax forms

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close