1. US Payroll Implementation Guide
  2. R07146 - Crosscheck Federal Taxable Wages Between F06146 and F06136 Reports (Release 9.2 Update)

R07146 - Crosscheck Federal Taxable Wages Between F06146 and F06136 Reports (Release 9.2 Update)

The Crosscheck Federal Taxable Wages between F06146 and F06136 Reports (R07146) is an integrity report that identifies the inconsistency between the Employee Transaction History Summary table - F06146 and the Tax History table - F06136 and thereby find any missing wages.

The report lists this information, by employee and displays the out-of-balance amount, if any:

  • PDBA Amount
  • Federal Wages
  • Federal Taxes
  • FICA Wages
  • FICA Taxes
  • Medical Wages
  • Medical Taxes

This report retrieves the PDBA pay type elements and PDBA Amount from the F06146 table. The taxable gross values for Federal tax type A, D, and P is retrieved from the F06136 table into the Federal Wages, FICA Wages, and Medicare Wages sections of the report respectively.

The out-of-balance amount if any between the PDBA amount and the Federal taxable gross amount is specified in the report.

The PDBA details will not appear in the report if:

  • Pay type with effect on gross is blank.
  • Taxable Benefit with Effect on Check is 1 or 4
  • Tax exemption first field is blank
  • US Federal exempt employees with tax method 2

Prerequisite

Before you run the report:

  • The year-end must be processed for accurate W2 information.
  • The processing options for R07146 must be set to specify the data to be used.