This page (revision-15) was last changed on 26-Nov-2021 10:22 by rforbes

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
15 26-Nov-2021 10:22 2 KB rforbes to previous
14 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
13 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
12 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
11 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
10 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
9 26-Nov-2021 10:22 2 KB rmorrell to previous | to last
8 26-Nov-2021 10:22 1 KB rmorrell to previous | to last
7 26-Nov-2021 10:22 1 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last Federal Quarterly Reporting - Form 941 ==> FEDERAL_ QUARTERLY_ REPORTING_FORM_941
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last Federal Quarterly Reporting ==> Federal Quarterly Reporting - Form 941
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
FEDERAL_ QUARTERLY_ REPORTING_FORM_941
FEDERAL_ QUARTERLY_ REPORTING_FORM_941

Version management

Difference between version and

At line 6 removed 2 lines
!!View Pay Run Information
At line 9 removed 5 lines
!Line 1 - # of Employees
Use the total of the ‘Employees’ field on [IPVP] from all of the pay runs that qualify for the data on the F941 to be completed. \\ \\
[F941_01.JPG]
At line 8 added one line
At line 10 added 21 lines
\\ \\
||Description||PC Usage|| PC Code|| 941 Line
|Fed Taxable Wages|6004| |2
|Fed Supp Wages |6005| |2
|Fed Tax|6001| |3
|Add. Fed Tax |6002| |3
|Supp Fed Tax |6003| |3
|FICA Wages |6202| |6
|Medicare Wages|6502| |7
|FICA Tax EE|6201| |8
|FICA Tax ER |6210| |8
|Medicare Tax EE|6501| |8
|Medicare Tax ER|6503| |8
|EIC PC|6101| |12
Line 2 – Total Wages \\
Line 3 – Total Tax \\
Line 6 – SS (FICA) Wages \\
Line 7 – Medicare Wages \\
Line 8 – Total SS and Medicare \\
Line 12 - EIC \\ \\
At line 17 removed 3 lines
!Line 2 – Total Wages
|Fed Taxable Wages|PC Usage |6004
|Fed Supp Wages |PC Usage |6005
At line 21 changed 16 lines
!Line 3 – Total Tax
|Fed Tax|PC Usage |6001
|Add. Fed Tax | PC Usage |6002
|Supp Fed Tax |PC Usage |6003
!Line 6 – SS Wages
|FICA Wages |PC Usage |6202
!Line 7 – Medicare Wages
|Medicare Wages| PC Usage| 6502
!Line 8 – Total SS and Medicare
|FICA Tax EE| PC Usage| 6201
|FICA Tax ER |PC Usage| 6210
|Medicare Tax EE| PC Usage |6501
|Medicare Tax ER|PC Usage |6503
!!View Pay Run Information
At line 38 changed 2 lines
!Line 12 - EIC
|EIC PC| Usage| 6101
!Line 1 - # of Employees
For the quarterly report, there is a requirement to count the number of employees in the pay period that contains the 12th. (i.e. MArch 12 for the first quarter). \\ \\
At line 38 added 7 lines
* Open IPVT
* Enter Query Mode
* Select "Closed" for the Stage and enter the pay period that includes March 12 into the Period field.
* Execute the query
* The number of employees processed will be displayed in the Employees field. \\ Use this number for line 1
\\
At line 42 changed one line
User may now run [RPREGT] using the element created to obtain information to aid in completing the F941 form.
!Lines 2, 3, 6, 7, 8 and 12
Run RPREGT for the current quarter using the parameters below.
\\ \\
__Todate Type:__ Quarter – this will select the quarter-to-date totals. \\
__Starting and Ending Dates:__ Use the first and last day of the reporting quarter. \\
__Register Sort Element:__ ‘941 REPORT’ to only select the amounts required. \\
__Filters:__ Do not use any filters for 941 purposes.
\\ \\
RPREGT is the ‘todates’ register that can report the month-to-dates, quarter-to-dates, and year-to-date totals. The 941 REPORT element was defined to sort the register to the required amounts.
\\
\\
At line 44 changed 2 lines
%%information Run [RPREGT] for the current quarter to obtain information for Lines, 2, 3, 6, 7, 8, and 12. Run [RPREGT] for the previous quarter and compare it to what was submitted on the F941 for the previous quarter to obtain information for lines 4 and 5.%%
The report will print the details for each employee, this is for balancing purposes if required. The data for the 941 form will come from the totals page.
\\
\\
!Balancing
;:%%information It is recommended that you run this report to a file and save it.
At the time of completing the current quarter, run the RPGEGT for the previous quarter and compare it to what was submitted on the 941 form for the previous quarter to obtain the data required for the Adjustment lines (4 and 5) for the current quarter.
\\
These adjustments could be for previous quarter payrolls processed after the 941 was completed.
This page (revision-15) was last changed on 26-Nov-2021 10:22 by rforbesTop