W-3 does not agree with Payroll Summary

Any non-Tax accounting topics go here.
#1
juro  
Posts:
919
Joined:
18-Oct-2015 9:11am
Location:
USA
Gross Pay per W3: $975,360.29. Agrees with the 941s.
Paychex prepared this.
How did they do it?
when i add together Regular and Salary = $880,363.23 + 90,623.02 = $970,986.25

per W3: $975,360.29
per Payroll Summary: $970,986.25
diff $4,374.04


https://imgur.com/7DMlmEU
https://imgur.com/BCufuFL
 

#2
sjrcpa  
Posts:
6563
Joined:
23-Apr-2014 5:27pm
Location:
Maryland
What Box on W-3 are you attempting to reconcile to?
Are there taxable fringe benefits- personal use of auto, group term life. >2% shareholder health insurance, etc?
 

#3
juro  
Posts:
919
Joined:
18-Oct-2015 9:11am
Location:
USA
don't know anymore
 

#4
Joan TB  
Posts:
1908
Joined:
21-Apr-2014 9:08am
Location:
Texas
First, I think you should be including both of the o/time pay, hrly2 and holiday pay for your W-3 total. Which then gives you a number that is too big, as it were. So we have to keep digging.

So my next question is - who actually cuts the PR - Paychex (and entries into QB are after the fact) or QB (and Paychex info is after the fact). That will help us know who "might" be wrong so we know where to look next for the discrepancy.

From the W-3 copy provided, it appears that there are no fringe benefits because boxes 1,3,5 are all the same and boxes 4 & 6 calculate to boxes 3 & 5.
 

#5
juro  
Posts:
919
Joined:
18-Oct-2015 9:11am
Location:
USA
https://www.surepayroll.com/get-started-b?title=Easy%20Online%20Payroll%20Services&adgroup=www%20surepayroll%20com%20EXACT&msclkid=a37b25f492f61d691cb4784073af580a

SurePayroll does it.

don't even think about our G/L in QB, it is a mess.
The only data inputted is for the bank rec, so only bank debits have ever been inputted.
A single lump sum for every paycheck event, so net pay & tax is all put into wages expense.

All the W-2s show zero in box #12 & #14.

The 1099 value of $227,468.93 is contract or outside labor.
How to account for the reimbursements? I took them to other expenses, like travel, meals, etc
 

#6
juro  
Posts:
919
Joined:
18-Oct-2015 9:11am
Location:
USA
The pretax items of BCN, Health Insurance and disability are included in the total.
 

#7
juro  
Posts:
919
Joined:
18-Oct-2015 9:11am
Location:
USA
This company does not pay overtime. Instead, it pays straight rate for all hours over forty per week.
And this is called "reimbursements" on the Payroll Summary which is prepared by SurePayroll.

How to classify this on the chart of accounts? I can't just call it "reimbursements." total of $51k for the year to date.

My Salary & Wage expense balance agrees with the forms 941. But the "reimbursements" are not included. Also not included are the normal employee reimbursements such as travel and expenses. Right now i have dumped these "reimbursements" into Uncategorized Expenses.
 


Return to General Accounting



Who is online

Users browsing this forum: No registered users and 4 guests