cancel
Showing results for 
Search instead for 
Did you mean: 

total report that shows the Box 12 and Box 14 totals for the company

Former Member
0 Kudos

I want a total report that shows the Box 12 and Box 14 totals for the entire company.

Can anyone advice me on this one please?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can use the payroll reconcilliation report; however, to use it, you'll need to do some upfront configuration (as well know if other wage types are tied to box 12 and 14) to get it to work.

Former Member
0 Kudos

Thanks Kevin

I am a little unclear on how to format it to show what the out put was for various amounts in box 10, 12, and 14.

Thanks

Former Member
0 Kudos

Also what configuration is need to execute payroll reconciliation report?

Thanks

Charlene

Former Member
0 Kudos

Experts-

Please help me on this..this is really urgent..

I am a little unclear on how to format it to show what the out put was for various amounts in box 10, 12, and 14.

Can anyone tell me with standard Tax form groups that are used for reflecting wage types in box 10, 12, 14.

Former Member
0 Kudos

Hi Charlene,

This is really a client specific situation. But I can help you in recognizing these amounts on the Tax form groups. Generally as per IRS regulation following should go in respective boxes:

1. Box 10

This amount is the total dependent care benefits that your employer paid. Tax form group is W227 under Tax form groups for Non Tax wage types.

2. Box 12

This box hold information about different codes. Ask your company as per your regulation which amounts went on the each Box of Box 12. For e.g. Voluntary or Mandatory 457 Deduction which falls under Code G of IRS. Tax form group is W23G

3. Box 14

This box is generally held for any payments which dont fall under the IRS regulation of Each boxes but still EE received it. For E.g. SDI, Medical Reimbursement, Domestic partner. Tax form group starts from W24A to W24J.

So just go ahead and access this Tax form groups and note down all the attached wage types under each Tax form group and run Reconciliation report for all of these Wage types from 01/01/2007 to 12/31/2007.

Hope this helps.

Arti

Former Member
0 Kudos

Thank You very very much Arti.

Full points rewarded to you..

Charlene

Answers (0)