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

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

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
5 26-Nov-2021 10:22 22 KB Meg McFarland to previous
4 26-Nov-2021 10:22 22 KB Meg McFarland to previous | to last
3 26-Nov-2021 10:22 22 KB Meg McFarland to previous | to last
2 26-Nov-2021 10:22 22 KB Meg McFarland to previous | to last
1 26-Nov-2021 10:22 35 KB unknown to last

Page References

Incoming links Outgoing links
Tax Reporting - MN
Tax Reporting - MN

Version management

Difference between version and

At line 73 changed one line
[RPYEU] must be run with the following report parameters and filters defined to generate the Minnesota State file information. RPYEU will generate the Minnesota State W2 EFW2 File Format according to the State specifications
[RPYEU] must be run with the following report parameters and filters defined to generate the Minnesota State file information. \\[RPYEU] will generate the Minnesota State W2 EFW2 File Format according to the State specifications
At line 134 changed one line
[RPYEU] must be run with the following report parameters and filters selected to generate the Minnesota State quarterly file information. \\* RPYEU will generate the Minnesota State Quarterly EFW2 File Format according to the State specifications \\ \\
[RPYEU] must be run with the following report parameters and filters selected to generate the Minnesota State quarterly file information. *[RRPYEU] will generate the Minnesota State Quarterly EFW2 File Format according to the State specifications \\ \\
At line 154 changed 2 lines
|Sort by Level: Must enter ‘DEPT SUI ER Number’ for Minnesota
|Provide Sort Level Totals: Optional. When set to YES, the totals are generated by ‘DEPT SUI ER Number’
|Sort by Level:Must enter ‘DEPT SUI ER Number’ for Minnesota
|Provide Sort Level Totals:Optional. When set to YES, the totals are generated by ‘DEPT SUI ER Number’
At line 183 changed one line
|203-213 MN|State Quarterly Unemployment Insurance Total (gross) Wages|Enter the total State quarterly UI gross wages. \\Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’\\ \\NOTE: The [IDFDV] Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Symmetry during the US Tax calculation, [UPCALC]. For employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. [RPYEU] will then use the State Taxable wages from the ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Identifiers, that are related to the employee's Home GEO and Work GEO code, to report SUI Total Wages
|203-213 MN|State Quarterly Unemployment Insurance Total (gross) Wages|Enter the total State quarterly UI gross wages. \\Derived from [IDFDV] Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’\\ NOTE: The [IDFDV] Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Symmetry during the US Tax calculation, [UPCALC]. For employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. [RPYEU] will then use the State Taxable wages from the ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Identifiers, that are related to the employee's Home GEO and Work GEO code, to report SUI Total Wages
At line 225 changed one line
|SUI Excess of Wage Base\\(Year 2000 Wage Base $7000)|YTD Wages – Wage Base: \\$18000 – $7000, up to max of current quarter Wages\\= $9000|YTD Wages – Wage Base: \\$6000 – $7000, up to max of current quarter wages\\$0|$9000
|SUI Excess of Wage Base\\(Year 2000 Wage Base $7000)|YTD Wages – Wage Base: \\$18000 – $7000, up to max of current quarter Wages\\= $9000|YTD Wages – Wage Base: $6000 – $7000, up to max of current quarter wages\\$0|$9000
At line 230 changed 2 lines
|SUI Excess of Wage Base \\(Year 2000 Wage Base $7000)|YTD Wages – Wage Base: \\$27000 – $7000, up to max of current quarter Wages\\= $9000|YTD Wages – Wage Base:\\$9000 – $7000, up to max of current quarter Wages\\= $2000|$11000
|SUI Taxable Wages|Total Wages – Excess Wage: \\$9000 - $9000\\= $0|Total Wages – Excess Wage\\= $3000 - $2000\\= $1000|$1000
|SUI Excess of Wage Base \\(Year 2000 Wage Base $7000)|YTD Wages – Wage Base: \\$27000 – $7000, up to max of current quarter Wages\\= $9000|YTD Wages – Wage Base: $9000 – $7000, up to max of current quarter Wages\\= $2000|$11000
|SUI Taxable Wages|Total Wages – Excess Wage: \\$9000 - $9000\\= $0|Total Wages – Excess Wage\\= $3000 - $2000\= $1000|$1000
At line 235 changed one line
|SUI Excess of Wage Base\\(Year 2000 Wage Base $7000)|YTD Wages – Wage Base: \\$36000 – $7000 up to max of current quarter Wages\\= $9000|YTD Wages – Wage Base: \\$12000 – $7000, up to max of current quarter Wages\\= $3000|$12000
|SUI Excess of Wage Base\\(Year 2000 Wage Base $7000)|YTD Wages – Wage Base: \\$36000 – $7000 up to max of current quarter Wages\\= $9000|YTD Wages – Wage Base: $12000 – $7000, up to max of current quarter Wages\\= $3000|$12000
At line 241 changed one line
Each Month requires the reporting of the total number of employees, full time and part time, who worked during or received pay subject to UI wages, for the payroll period that includes the 12th day of the first month of the reporting period.
Each Month requires the reporting of the total number of employees, full time and part time, who worked during or received pay subject to UI wages for the payroll period that includes the 12th day of the first month of the reporting period
At line 244 changed 4 lines
*From the user-specified Quarter Ending date, determine the First Month Date that includes the 12th of the month\\ Example: Quarter Ending Date Mar-31-YYYY, then the First Month Date is Jan-12-YYYY
*Determine the Payroll Period that the First Month Date ‘Jan-12-YYYY’ falls within the reporting period Start and End dates\\ Example: For Jan-12-YYYY, falls into Period YYYY02, with Period Start date Dec-30-YYYY and End date Jan-13-YYYY
*For each employee, read the Pay Headers for the First Month Period that have the Pay Stage defined as ‘70’ or ‘80’
*With each Pay Header that qualifies, retrieve the amount according to [IDFDV] ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ values to determine if the employee has wages that are subject to UI
*From the user-specified Quarter Ending date, determines the First Month Date that includes the 12th of the month\\ Example: Quarter Ending Date Mar-31-20YY, then the First Month Date is Jan-12-20YY
*Determine the Payroll Period that the First Month Date ‘Jan-12-2002’ falls within the Period Start and End date\\ Example: For Jan-12-20YY, it falls into Period 20YY02 with Period Start date Dec-30-20YY and End date Jan-13-20YY
*For each employee, reads the Pay Headers for the First Month Period that have the Pay Stage defined as ‘70’ or ‘80’
*With each Pay Header that qualifies, retrieves the amount according to [IDFDV] ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ values to determine if the employee has wages that are subject to UI
This page (revision-5) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop