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.

Note: 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.