Comprehensive Payroll Reporting with SplashBI for Fusion HCM

Explore –

1. Introduction
2. Assignment Setups
3. Payment Register
4. Conclusion

Assignment Setups

Payroll assignment setups link employees to their work structures, compensation, and benefits. These setups are essential for validating timecards, overtime, earnings, deductions, payment methods, salary structures, and elements at the assignment level. Below are some key payroll reports provided by SplashBI that support assignment setups within Fusion HCM Payroll.

1. US – Element Entry Values
2. Negative Entries Report

Audit Reports

Audit reports monitor changes made to payroll data, capturing details such as who made the changes, when they occurred and what was altered. These reports are crucial for helping organizations maintain compliance with legal and regulatory requirements. Below are some key payroll reports provided by SplashBI that support tracking audit changes within Fusion HCM Payroll.

1. Check Register
2. Deductions Not Taken
3. Earnings Not Paid
4. US – Employee Run Results
5. Employees Not Paid
6. Employees Not Processed
7. US – Net Outside the Range Report
8. Payroll Comparison Report

Costing Reports

Payroll costing in Oracle Fusion Payroll helps track and allocate the costs related to employee compensation, including salaries, bonuses, paid leave and employer-paid payroll taxes. It also generates journal entries for payroll run results and payments. Below are some key payroll reports provided by SplashBI that support costing information within Fusion HCM Payroll. 

1. Costing Details
2. Costing Summary
3. US – Costed but not Transferred to GL
4. PAY Assignment Costing Report
5. Payroll to Costing Reconciliation
6. Payroll to GL Reconciliation

Information Reports

Benefits and Pensions Card Information Reports

1. 403B Information (Benefits and Pensions Card)
2. 457 Information (Benefits and Pensions Card)
    

Involuntary Deduction Calculation Card Reports

Wage garnishment is a legal process where an employer is required by court order to withhold a portion of an employee’s earnings to pay off a debt, such as alimony, child support, or education loans. In Oracle Fusion, these garnishments are entered on the Involuntary Deductions Calculation Cards. Below are some key payroll reports provided by SplashBI that support Involuntary Deduction Calculation Card information within Fusion HCM Payroll.

1. Involuntary Deductions Report
2. Involuntary Deductions Card Information – Bankruptcy
3. Involuntary Deductions Card Information – Child Support
4. Involuntary Deductions Card Information – Garnishments
5. Involuntary Deductions Card Information – Tax Levy (Federal and Regional)
6. Involuntary Deductions Report – Bankruptcy
7. Involuntary Deductions Report – Garnishments
8. Involuntary Deductions Report – Child Support
9. Involuntary Deductions Report – Tax Levy (Federal and Regional)
10. Organization Card
11. PA ACT32 Report
12. Retiree Reporting Information
13. Retiree Tax Withholding Information
14. Third-Party Payment Register

Multiple Worksite Reports

The Multiple Worksite Report is designed to collect information showing the distribution of the employment and wages of business establishments by industry and geographic area. Information on the MWR form is used to accurately classify employment and wage data of multiple establishment employers by industry and by location within a State. Below are some key Payroll reports by SplashBI that support Multiple Worksite information defined in Fusion HCM Payroll.

1. MWR All Locations
2. MWR Assignments Location Change
3. MWR Missing Location Information
4. MWR Non-Reporting Locations
5. MWR Reporting Locations Details
6. MWR Work at Home Employee Locations
7. Multiple Worksite Reporting information

Payment Reports

Generate the Payment Register to verify, reconcile and audit payment distributions. This report excludes payments made to third parties. Below is the key payroll report provided by SplashBI that supports Payment Register information within Fusion HCM Payroll.

In addition to reporting, the panelists stressed the importance of holistic benefits as a key to closing the pay gap. From offer negotiation to pension and medical benefits, the gap tends to get wider over time, especially when women may take career breaks to care for children.

On average, women work 19 years longer than men to earn the same pension.

A recommendation discussed as a remedy to this problem was continuing pension contributions during maternity leave. Many women fall behind in retirement savings due to career breaks, and this gap widens over time. Victoria Collier highlighted the urgency of such policies, saying, “If we could change maternity and paternity laws so that when parents take maternity or paternity, their pension contributions continue to get paid, I think that would be a real good step forward.”

The role of legislation in driving change was an important theme during the discussion. The panelists discussed that countries like the U.K. and those in the European Union have taken the lead in mandating pay transparency and reporting requirements, but the U.S. still lags behind. They agreed that there remains a gulf between reporting and enforcement, with regulatory compliance currently viewed as an additional administrative task rather than an exercise with meaningful outcomes.

Payment Register

 Payroll Balance Reports

Payroll balance reports in Oracle Fusion provide detailed balance information for an employee over a specified period. These reports can be used to compare current data with archived records to validate and reconcile periodic payroll balances. Below are some key payroll reports provided by SplashBI that support Payroll Balance information within Fusion HCM Payroll. 

1. US – Balance Adjustments
2. US – Deduction Register
3. US – Deduction Register as of Date
4. US – Earning Hours
5. US – Earnings Register
6. US – Earnings Register as of Date
7. Element Balances
8. US – Gross to Net Summary
9. US – Gross and Net balances
10. US – Payroll Balances as Of Date
11. US – Payroll Balances Date Range
12. US – Tax Balance Report as of Date
13. US – Tax Balance Report Date Range
14. US – Tax Deductions
15. US – Tax Liabilities-Deductions as of Date

Reconciliation Reports

In Oracle Fusion, a reconciliation report is a tool used to compare data across different modules to ensure its accuracy and proper representation. Below are some key payroll reports provided by SplashBI that support reconciliation information within Fusion HCM Payroll. 

1. US – Payroll Register
2. US – Payroll Register Summary
3. US – Element Classifications as of Date
4. US – Element Classifications Date Range

Setup Reports

Setup reports in Oracle Fusion HCM validate and provide details on configurations, such as Elements, Element Links and other setup data. These reports are generated each time an export process is run within a specific functional area. Below are some key payroll reports provided by SplashBI that support setup report information within Fusion HCM Payroll. 

1. Element Links
2. Element Types
3. Employee Reporting Information
4. US – TRU Totals

Tax Withholding Information Reports

In Oracle Fusion HCM, Tax Withholding card reports help audit employee tax information. Below are some key payroll reports provided by SplashBI that support Tax Withholding information within Fusion HCM Payroll. 

1. Employee Tax Withholding Information
2. Employee Tax Withholding Overrides Information
3. Employee Tax Withholding Overrides Information – County and City
4. Employee Tax Withholding Overrides Information – Federal and US Taxation
5. Employee Tax Withholding Overrides Information – State

Tax Reports

Oracle Tax Reporting Cloud offers pre-built reports for tax provision, country-by-country reporting and a general framework for enhancing processes within the corporate tax function. Below are some key payroll reports provided by SplashBI that complement the tax report data defined within Fusion HCM Payroll. 

1. US – Quarterly Tax Return 941 Report
2. US – State Quarterly Wage Listing (SQWL)
3. US – Statutory Deduction Register

Tax Summary Reports

Oracle Fusion HCM enables the capture of employees’ periodic, monthly, and quarterly tax summary information. Below are key payroll reports SplashBI provided that support the tax summary data defined in Fusion HCM Payroll. 

1. US Monthly Tax Summary Report
2. US Monthly Tax Summary Report-IL
3. US Monthly Tax Summary Report-PA
4. US Periodic Tax Summary Report
5. US Quarterly Tax Summary Report

Year End Reports

In Oracle Fusion HCM, year-end reports include summary and detailed reports and the end-of-year register. These reports are generated using the “Run End-of-Year Reports” task, which payroll managers and administrators can access from the Regulatory and Tax Reporting section. Below are key payroll reports provided by SplashBI that support the year-end report data defined in Fusion HCM Payroll. 

1. US – W2 Register
2. Employee W4 Information Report
3. End-of-Year Balance Report

Other Reports

In Oracle Fusion HCM, these reports offer a high-level summary of payroll balances across various categories. They are useful for payroll verification, validation and auditing and can be run at any time to reconcile payroll balances with data archived by the periodic payroll archive process. Below are key payroll reports SplashBI provided that support other report information defined in Fusion HCM Payroll.

1. US – Payroll Activity Report
2. Payroll Process Summary
3. Unprocessed Payroll Actions Report

Conclusion

SplashBI HCM Payroll reporting provides comprehensive coverage of all reporting areas within Oracle Fusion HCM Payroll. As a powerful reporting platform, SplashBI supports the entire payroll lifecycle, from payroll setups to transferring data to the General Ledger (GL). It delivers end-to-end reporting solutions tailored to Oracle Fusion HCM Payroll, ensuring seamless management of all payroll processes.

For a deeper dive into streamlining your payroll processes, explore our whitepaper, “Streamlining Payroll Reporting for Oracle Fusion Cloud.“