Quarter-End Processing for the US
Quarter-end processing consists of the archival of data and the generation and submission of statutory reports. When you do this during the fourth quarter, you can include them as part of your end-of-year processing.
Performing quarter-end processing involves the interactions of these components.
-
Quarter-to-Date Archive
-
Quarterly Tax Reports
-
Oracle Fusion Third-Party Tax Filing Interface
-
Payroll Balancing
-
Other Quarterly Reports
For further info, see the following sections.
Quarter-to-Date Archive
The Quarter-to-Date Archive is a payroll flow that archives employee, employer, and tax data for a quarterly tax period. Based on the payroll statutory unit (PSU) or tax reporting unit (TRU) you select, it captures data for these payroll actions.
-
R (Run)
-
Q (QuickPay)
-
B (Balance adjustment)
-
I (Balance initialization)
-
V (Reversal)
The Quarter-to-Date Archive uses the US State Quarter-to-Date Archive extract definition to gather this info. When completed, you can generate your reports.
Quarterly Tax Reports
Use either the Quarter-to-Date Archive flow or the Oracle Fusion Third-Party Tax Filing Interface to generate the following tax reports.
Name |
Description |
Quarter-to-Date Archive Support |
Third-Party Quarterly Tax Filing Extract |
Third-Party Monthly Tax Filing Extract |
---|---|---|---|---|
State Quarterly Wage Listing (SQWL) |
Reports an employee's state unemployment info. |
No |
Yes |
No |
Multiple Worksite Report (MWR) |
Provides info to the federal government for distributing federal funds through grant programs. |
Yes |
No |
No |
Federal Form 941 |
Employer's quarterly federal tax return. |
No |
Yes |
No |
Third-Party Tax Filing Interface
Use the Third-Party Tax Filing Interface if you're using a third-party provider to generate and submit your tax reports (such as ADP or MasterTax). This interface extracts your employee, employer, and tax data to an output file. Submit this file to your third-party provider for report processing, generation, and submission.
For further info, see Oracle Cloud Human Capital Management for the United States: Payroll Third-Party Tax Filing Interface (1594079.1) on My Oracle Support.
Running the Quarter-to-Date Archive flow before using this interface isn't required.
Payroll Balancing
Before filing your reports, make sure you have balanced your payrolls for the quarter. For further info, see Oracle Cloud Human Capital Management for the US Payroll Reconciliation (2086251.1) on My Oracle Support.
You might have to perform a balance adjustment. For further info, see the following on My Oracle Support.
-
Oracle Cloud Human Capital Management for the US: Balance Adjustments (1600728.1)
-
Oracle Cloud Human Capital Management for the US: Batch Balance Adjustments (2053488.1)
Other Quarterly Reports
You can run the following reports on a periodic basis, ideally after each payroll run. They aren't dependent on the data gathered by the Quarter-to-Date Archive.
Report name |
What it does |
---|---|
Statutory Deduction Register Report |
Provides info about total amounts paid for the various levels of your organization for each payroll period. Used for payroll verification, validation, and auditing purposes. |
Gross-to-Net Summary |
Provides totals for the results calculated from payroll runs and payroll reversals by elements of pay. Run after each payroll run. |