Detailed Tax Deposit US by Pay

The Detailed Tax Deposit US by Pay report uses the Payroll Register by Pay Run topic to display details about tax amounts such as tax category, tax code, current amount, and disbursement method. Administrators can use this report to view the detailed amounts of taxes for reconciling employee and employer amounts to the impounded total, and for identifying amounts to be remitted.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Pay Period	Yes	A to Z
Legal Entity	Yes	Ascending
Tax Code	Yes	A to Z
Responsible Remitter	Yes
Tax Category	Yes
Cur Amt			Column: Sum
Employee
Funds Disbursed
Disbursement Method

Custom Fields

Responsible Remitter

The Responsible Remitter custom field indicates if the client is responsible for remitting funds to an agency, or if Dayforce impounds the funds to remit on the client's behalf. It uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Tax'
         AND PRPayRunRegister.PayeeDisbursementMethod = 'Cust Resp Taxes' THEN 'Client Responsible'
    ELSE CASE
             WHEN PRPayRunRegister.RecordType = 'Tax'
                  AND PRPayRunRegister.PayeeDisbursementMethod = 'Impound Tax' THEN 'Ceridian Impound'
             ELSE 'Null'
         END
END 

Tax Category

The Tax Category custom field uses the following expression:

CASE
    WHEN PRPayRunRegister.RecordType = 'Tax'
         AND PRPayRunRegister.RecordCategory <> 'Federal'
         AND PRPayRunRegister.RecordCategory <> 'State/Province' THEN 'Local'
    ELSE PRPayRunRegister.RecordCategory
END

Filters

The template includes the following filters: