Reports

[HHHMT]

When I run a payroll report for a specific timeframe for Employee Totals it does not match the total when I add it up myself. I put the date range in but it doesn't generate the correct totals for the timeframe I entered. How can I fix this so I can generate an accurate report?

[TheRealChipA]

Hey @HHHMT.  The Employee Totals report does nothing more than summing up all of the checks that were submitted for that employee over the selected reporting period.  In order to help track down the problem, more information is needed;

1. What are you “adding up yourself” to compare to the generated report?  Are you just adding up the individual checks, or something else?
2. Which totals are not adding up?  All of them or just certain ones?

Thanks.

[HHHMT]

I think I have figured it out. I needed my total payroll amount for the second quarter for work comp but I was adding in the totals which included my taxes. I went back and added all the totals for just payroll without employer taxes but it was still $71 difference.

[TheRealChipA]

I’m confused.  You said you had it figured out, but then you said it was still $71 difference.  Does that mean you DON’T have it figured out?  And, if not, please tell me what you are comparing the report totals to.  For example, if you accept tips, then those are also used for workers comp because they are part of gross pay.  Also, any adjustments to gross pay are part of workers comp.  It’s hard to give you any direction without knowing what you are comparing to the Square reporting.  Honestly, after 4+ years of Square Payroll, I can tell you it has always been perfect.  So I need something to go on, IF you still have a discrepancy.

[HHHMT]

My apologies.  I was trying to generate a report for the amount that I need to report for work comp.  Which report do I choose... is it Employee Totals?

[TheRealChipA]

@HHHMT I can only give you general guidelines here, because every state has its own rules about what is subject to workers comp.  In general, the employee totals report should work.  In fact, in my state (Kentucky) the company totals report works since we pay based on total gross weekly payroll and then the end of year audit sorts out any employee-level discrepancies.  So, my advice would be to check with your workers comp company to determine what numbers they require and then choose the appropriate report.  Just remember that hourly pay is NOT usually enough.  If your company accepts and pays tips, as well as certain other adjustments to gross pay, those must usually be included as well.

You didn’t ask for this kind of advice, but this is exactly why I use pay-as-you-go workers comp offered through Square Payroll (and most other payroll services offer this, too).  PAYG workers comp figures it out for you and just does a weekly auto-pay.  I love it and my end of year audit is usually very painless.

Anyway… sorry I can’t be more help, but every state and insurance company is slightly different here.  Let them guide you to the correct report and calculations.