My Reports - Report Format 2

Only users assigned the ACA attribute see these reports.

Only users assigned the Tax - Funding attribute see these reports.

Only users assigned the Tax - Payment Solutions attribute see these reports.

Note: These reports are referred to as International Money Movement (IMM) reports also.

Only users assigned the Tax - Payroll Processing attribute see these reports.

The Historical PDE reports give users access to payroll processing data produced by Ceridian Payroll Data Exchange (PDE). PDE is being replaced by the new system that produces payroll processing reports. Until PDE is retired, the archived payroll processing data available in the historical reports will not be complete.

These historical reports render data from July 2020 through July 2022.

Only users assigned the Tax - Historical PDE attribute see these reports.

Note: The historical reports may take longer to generate.

The following tables describe the available Tax reports. Only users assigned the Tax Reporting attribute see these reports.

Annual Reports

Name	Description
FUTA Annual Statement	Contains summary reports that you can use to reconcile your company's annual federal unemployment tax liabilities, payments, and other information filed with the Internal Revenue Service (IRS).
FUTA Annual Statement Schedule A	Contains supplemental annual state unemployment data for FUTA credit reduction tax that is filed along with the annual federal unemployment tax return with the IRS.
Local Annual Reconciliation	Contains summary reports that you can use to reconcile your company’s annual local withholding tax (LIT) liabilities, payments, and other information filed with the tax agencies.
State Combined Annual Reconciliation	Contains summary reports that you can use to reconcile your company’s annual state withholding tax (SIT) and unemployment tax (SUI) liabilities, payments, and other information filed with the tax agencies. (Combined state filings are for CA, ME, MT, NJ, NY, OR, and WY).
State SIT Annual Reconciliation	Contains summary reports that you can use to reconcile your company’s annual state withholding tax (SIT) liabilities, payments, and other information filed with the tax agencies.
Year-end W-2 Analysis	Used to identify YTD variances. Produced during year-end processing, this report is the primary balancing report that compares W-2 Totals from your annual/W-2 file to both the YTD totals provided in the customer’s quarterly file and the Ceridian cumulative total of tax returns filed.
Year-end W-2 Variance	Compares W-2 data filed to CTS with the calculated YTD total (quarterly totals) and calls out where the variance between these totals is greater than a selected percentage, from 5% to 25%.

Periodic Reports

Name	Description
Customer Profile Report	Provides an overview of key customer information that includes legal and mailing addresses, contact details, and banking information. The report also includes the tax codes and jurisdictions on the customer’s tax profile.
Funding Activity Report	Provides the customer's funding information.
General Ledger Report	Provides payroll tax liability, deposit, and funding information.
Inquiries and Amendments Report	Provides information on the amendment and inquiry activity.
Jurisdiction Activity Report	Provides payroll tax liability and deposit information for selected tax codes and jurisdictions.
Liabilities and Deposits Report	Provides payroll tax liability and deposit information.
Prepaid Activity Report	Provides payroll tax liability and deposit information for new customers who had prior activity in the same quarter that the Ceridian Tax service began. This information was processed by either the customer or another payroll tax service.
Tax Liability History Report	Provides detailed information on the payroll and tax files received for Tax Filing.

Quarterly Reports

Name	Description
Federal Statement	Contains summary reports that you can use to reconcile your company’s quarterly federal tax liabilities, payments, and other information filed with the tax agencies.
Local Statement	Contains summary reports that you can use to reconcile your company’s quarterly local withholding tax (LIT) liabilities, payments, and other information filed with the tax agencies.
QE Edit Report	The primary balancing report produced during quarter-end tax processing that compares your quarterly transmission to the periodic liabilities that were sent to Ceridian throughout the year.
QE Edit Variance	Compares QTD and YTD data received to the calculated QTD and YTD totals and identifies variances over 5%.
State Combined Statement	Contains summary reports that you can use to reconcile your company’s quarterly state withholding tax (SIT) and unemployment tax (SUI) liabilities, payments, and other information filed with the tax agencies. (Combined state filings are for CA, ME, MT, NJ, NY, OR, and WY).
State SIT Statement	Contains summary reports that you can use to reconcile your company’s quarterly state withholding tax (SIT) liabilities, payments, and other information filed with the tax agencies.
State SUI Statement	Contains summary reports that you can use to reconcile your company’s quarterly state unemployment tax (SUI) liabilities, payments, and other information filed with the tax agencies.

1. To open the report, use one of the methods described in the To access and open reports section.

   Note: If you are running a standard report, depending on the report, one or more parameters are available to help you narrow your search results for specific information.

2. Enter the search criteria and report parameters to find the client and the information you are looking for.

   Based on your selection, additional options and fields may appear.

3. If you plan to export the report data to Microsoft® Excel®, and you want data separated on separate tabs, in Excel Tabs select Yes.

   By default, No is selected.

4. Select or enter information in all other fields as needed.
5. Click View Report.

   Tip: The View Report button is located on the far right side of the page. Depending on your monitor's resolution setting, you may need to scroll to display the button.

Use this procedure to export or save a report to your computer in a different format, such as Excel or PDF.

Warning: If pop-up blockers are turned on, the export will fail. If this happens, turn off pop-up blockers. Then, open and export the report again.

1. To open the report, use one of the methods described in the To access and open reports section.

2. Enter the search criteria and report parameters to find the client and the information you are looking for. Based on your entries, additional options and fields may appear.

3. Enter and select information as needed and click View Report.

   Tip: The View Report button is located on the far right side of the page. Depending on your monitor's resolution setting, you may need to scroll to display the button.

4. When the report appears, at the top of the report, click Export.
5. From the list that appears, select a report format.

   Note: Excel is the recommended format for exporting reports. If you export your reports in Excel format, you can change the exported data as needed.

6. The browser you are using determines the next step in the procedure.

   If you are using ...	Do this ...
   Google® Chrome®	The report is saved to the Downloads folder on your computer. Your browser settings determine if the report automatically opens or if you open the report from the Downloads folder.
   Microsoft® Edge®	The report is saved to the Downloads folder on your computer and appears in the Download list in the tool bar at the top of this page. If the download list doesn't automatically appear, click . To open the report, click Open file.
   Mozilla® Firefox®	On the window that appears, do this:  Click one of the following options: Open with to open the report before you save it to your computer. Note: Click the drop-down arrow to select the program you want to use to open the report. Save File to save the report directly to your computer without opening it. DaaS saves the report to the Downloads folder on your computer. If you want DaaS to use the same option (Open or Save) that you selected for this image on all other reports you export, select Do this automatically for files like this from now on. Click OK.