|
Post by anneinwa on Jul 27, 2016 16:31:39 GMT
Hoping someone here can help. We currently have the online version of quick books essential. We just hired our first employee and due to the nature of the work he will be doing, we need the ability to add in different class codes each pay period, possibly multiple in a day.
I set up payroll yesterday and do not see anyway of doing this with the level we have.
I called quick books and they said the only way they think I can do this is with a desktop version? Can anyone verify this?
There is one more level above essentials that I can upgrade to, and it opens up more options for the business and I have a hunch that it might do what I need it to, but according to the agent I spoke to, it's not a quick downgrade, so I need to make sure before I upgrade.
One option I do have, if I can't find an answer, is to try a free trial of the next level but I won't be able to do that for a day or so.
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 27, 2016 18:26:21 GMT
I do use QB and do all the WC setups and audits for multiple companies. In every payroll estimate and audit (multiple insurers over 11 years with over 8 companies), each employee is only assigned 1 WC code overall and that is the one with the highest risk rating. There is no way on the WC side to split payroll out by person by job type. For example, we have an employee who is our IT person but is also a Real Estate Broker. His REB WC code has a much higher rating than is IT (admin) code, but because he goes out and shows lease spaces to potential tenants, we must put ALL his income into the REB WC code.
So the question you might need to be asking is to your WC carrier to make sure you are getting correct coverage.
We have QB Enterprise Solutions (one of the highest levels) and the only place to put the WC code is on the employee record and there is only one spot to put one code.
But we don't do the autobill with our WC carrier...instead we do an estimated payroll at the beginning of the covered year and then do a trueup/audit at the end of the covered year. We don't like giving them access to our bank account every payroll period.
eta: I am not in your state and do know that WC laws can vary by state, so yours might allow what you are trying to do. That said, I don't think QB can handle what you are trying to do. I think you would have to setup different paycodes/types such that your payroll reports split out the income by type and then match that back to the WC code for each paycode/type. You could probably run an EE Earnings Summary or Payroll summary to get the totals or by employee and paycode/types and then total by those.
|
|
|
Post by anneinwa on Jul 27, 2016 18:29:30 GMT
Reason I want to split is we have about a $5 difference per hour between our highest and lowest. So trying to figure out how to do it if a guy is doing floors and roofs in same week without having to pay the $5 difference for the full week?
|
|
|
Post by anneinwa on Jul 27, 2016 18:30:33 GMT
Will be looking more at what you said when I get home ... That was just quick update as I walk into the market lol
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 27, 2016 18:37:13 GMT
Added an edit.....about a possibility..... Generally in my state you can pay him lower for the different payrates based on the work he did but overall he has one WC code for all that income. For example a Group Fitness Exercise Instructor ($20 per hour) who also works front desk ($9 per hour) has to be rated at the higher Fitness code.
For example : 20 hours at $15 per hour for roofing = $300 that week; 20 hours at $10 per hour for flooring that week = $200. So his WC wages for that week would be $500. Say the WC rate is 1.25 for roofing and .5 for flooring, you would have to pay 1.25 for all $500. And the way we report, those numbers would be annual. I don't know if you had a week where he did NO roofing whether you could change his code mid-year. In my state, if he works one day roofing, he should be under the roofing code for all.
but in the end without using some separate paycodes to split out his wages by job type and manually attaching those to WC codes, I don't see where QB can do it automatically.
|
|
|
Post by anneinwa on Jul 27, 2016 21:25:54 GMT
So have talked to WC rep and she says that I can split based on hours. On phone with QB again because online chat told me it was possible (I refuse to give up on the very slim chance there is a work around). So upgraded and trying different things. She just came back and said no, which is what I was expecting.
I ran a scenario on paper that shows our issue with running through QB. We are a small company that could easily have 4-5 codes for our one employee each week... If I had him painting for 32 and working on a roof for 8, according to the limitations of QB I would need to run at the higher rate which for the total hourly rate would be $307 vs just running it for 8 hrs which would be $61.40.
|
|
|
Post by mlynn on Jul 27, 2016 21:37:22 GMT
I used to do payroll for a farm labor contractor. I think I was using QB 2003. We entered hours by the job worked. In deductions, we created a code for each WC class. Then when entering the payroll, we would enter the hours for the different classes for the payroll deduction. If there was more than one class for a job, the hours were separated in the hours section. When it came time to do the quarterly reports, I would do a printout by job. The printout would show the total for each class within the job.
This was a system I jerry-rigged myself using the reports and capabilities of the program to create what I needed.
Clear as mud?
|
|
|
Post by anneinwa on Jul 27, 2016 22:02:48 GMT
I used to do payroll for a farm labor contractor. I think I was using QB 2003. We entered hours by the job worked. In deductions, we created a code for each WC class. Then when entering the payroll, we would enter the hours for the different classes for the payroll deduction. If there was more than one class for a job, the hours were separated in the hours section. When it came time to do the quarterly reports, I would do a printout by job. The printout would show the total for each class within the job. This was a system I jerry-rigged myself using the reports and capabilities of the program to create what I needed. Clear as mud? Totally understand! I have spent abut 4 hours today between research and on the phone/chat with QB and WC... latest is they tell me the desktop version will do what I want it to do. We shall see when I order it tomorrow. At least there is a 60 day return policy. We will see if that applies to my upgrades this week too for online version. I was getting ready to go to a weekly pay schedule if I had to go by highest class code... I don't think I am asking for that much! I get it may not be typical for most businesses but its not untypical either.
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 27, 2016 22:46:03 GMT
While I don't use codes to split for WC, I do have some employees that make up to 4 different payrates depending on what they are doing so I just have the different paytypes or payroll items as I think they are actually called in QB. I do have to punch in how many hours/classes that they are paid at each rate, but I would think that could work for you for what you are trying to accomplish. Each payrate/item would be assigned a different WC code vs each employee having a different WC code. And each would print on a separate line on the paystub. Honestly if I were an employee who worked differing hours at different rates, it would be nice to see that split out rather than one amount.
And that way if and when you hire more people, you already have those types/classes setup and you can sum by either employee or by types. In my example, I have one rate for teaching fitness classes, one rate for group pilates, one rate for private pilates and one rate for semi-private pilates. In the end I want to know for our financial budget how much payroll there was for pilates versus fitness classes, so having the different paytypes helps. (there are times where an employee is paid the same amount per class but I want to split their payroll into different groups. This accomplishes that purpose too -- which it sounds like what your end goal is)
I've not done job classing, but know it is possible in our version. mlynn is calling them deductions where I use them as different types of income/wages. To me, deductions are things that the employee pays for out of income/wages and in my state the employee pays no part of WC, so it wouldn't be a deduction. But maybe I am misunderstanding since I don't use job classing.
Does your version allow you to have more than one payrate per employee? (it should because at minimum you have regular rate and OT rates). The only conundrum with multiple payrates is if that employee works overtime and you have to figure regular rate of pay and how to calculate OT. If you get to that point and need help, let me know. Luckily my employees that work at multiple payrates don't go over 15 or so hours per week. It's not a hard calculation, but QB doesn't do it for you.
|
|
|
Post by anneinwa on Jul 27, 2016 22:51:11 GMT
While I don't use codes to split for WC, I do have some employees that make up to 4 different payrates depending on what they are doing so I just have the different paytypes or payroll items as I think they are actually called in QB. I do have to punch in how many hours/classes that they are paid at each rate, but I would think that could work for you for what you are trying to accomplish. Each payrate/item would be assigned a different WC code vs each employee having a different WC code. And each would print on a separate line on the paystub. Honestly if I were an employee who worked differing hours at different rates, it would be nice to see that split out rather than one amount. And that way if and when you hire more people, you already have those types/classes setup and you can sum by either employee or by types. In my example, I have one rate for teaching fitness classes, one rate for group pilates, one rate for private pilates and one rate for semi-private pilates. In the end I want to know for our financial budget how much payroll there was for pilates versus fitness classes, so having the different paytypes helps. (there are times where an employee is paid the same amount per class but I want to split their payroll into different groups. This accomplishes that purpose too -- which it sounds like what your end goal is) I've not done job classing, but know it is possible in our version. mlynn is calling them deductions where I use them as different types of income/wages. To me, deductions are things that the employee pays for out of income/wages and in my state the employee pays no part of WC, so it wouldn't be a deduction. But maybe I am misunderstanding since I don't use job classing. Does your version allow you to have more than one payrate per employee? (it should because at minimum you have regular rate and OT rates). The only conundrum with multiple payrates is if that employee works overtime and you have to figure regular rate of pay and how to calculate OT. If you get to that point and need help, let me know. Luckily my employees that work at multiple payrates don't go over 15 or so hours per week. It's not a hard calculation, but QB doesn't do it for you. which version are you using? Online or desktop? I was able to set differently hourly wages but could not set more than one code for our employee even though all 7 are entered in on QB for the company.
|
|
|
Post by anneinwa on Jul 27, 2016 22:52:31 GMT
I thought about setting an hourly wage based on hour wage - his withholding for each class, but that wouldn't help on the company end for the employee contribution and probably cause a lot of extra work for me.
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 27, 2016 23:10:17 GMT
Your state requires an employee contribution to WC premiums? Wow! I must say I have never heard that before so can't help there. Our employees would scream! I guess I should count my blessings that ours is 100% paid for by the employer based on employee wages.
So you would have to set up an hourly wage rate with a matching deduction % for each wage? Ouch....I can see where that would get overwhelming! And the paystub would be a nightmare! You'd have to have a chart for each hourly wage rate and what WC code it matched back to....(and yes, in the end I think it gets back to one WC code per employee since it is on the employee main record.... my work around would get complicated if you had too many different WC codes at your company too)
We use the desktop version Enterprise with Payroll, but I just pull QB reports to get the #s I need for our carrier to calculate our premium annually and then the audit annually.
eta: you might ask this question out at payrolltalk.com. I am not sure how many QB users there are though!
|
|
|
Post by anneinwa on Jul 27, 2016 23:15:34 GMT
Your state requires an employee contribution to WC premiums? Wow! I must say I have never heard that before so can't help there. Our employees would scream! I guess I should count my blessings that ours is 100% paid for by the employer based on employee wages.
So you would have to set up an hourly wage rate with a matching deduction % for each wage? Ouch....I can see where that would get overwhelming! And the paystub would be a nightmare! You'd have to have a chart for each hourly wage rate and what WC code it matched back to....(and yes, in the end I think it gets back to one WC code per employee since it is on the employee main record.... my work around would get complicated if you had too many different WC codes at your company too)
We use the desktop version Enterprise with Payroll, but I just pull QB reports to get the #s I need for our carrier to calculate our premium annually and then the audit annually.
eta: you might ask this question out at payrolltalk.com. I am not sure how many QB users there are though! If nothing else, maybe they can tell me what I can use. I would rather have something that QB can work with... I really hope going to desktop is the key... Just need to figure out what version... Washington state shows on hourly employee contribution on what I got from Labor and Industries... its only a fraction of the total.. for instance one has employee at .26 and employer at 1.04. Another reason I want to be able to file it correctly at each pay period... high end has me withholding 1.47/hr from the employee...
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 28, 2016 0:32:45 GMT
Those are high rates OUCH! I have been very lucky that we have stayed relatively claim free so our rates are pretty low across the board. It is interesting that there is a statewide rate per WC category that doesn't take into account your personal employer history/claim rate.
You could also ask out at thelaw.com HR forum....I know they also have a WC forum, because this is a combination of issues (payroll software and knowledge of WA's WC system) I wish I could solve it (I am a problem solver by nature, but this one has me stumped too!)
|
|
|
Post by anneinwa on Jul 28, 2016 0:49:54 GMT
Those are high rates OUCH! I have been very lucky that we have stayed relatively claim free so our rates are pretty low across the board. It is interesting that there is a statewide rate per WC category that doesn't take into account your personal employer history/claim rate. You could also ask out at thelaw.com HR forum....I know they also have a WC forum, because this is a combination of issues (payroll software and knowledge of WA's WC system) I wish I could solve it (I am a problem solver by nature, but this one has me stumped too!) I'll know tomorrow when I try it on the desktop! If not I'll be doing this week's payroll on a spreadsheet. Thanks for trying to help! The rates are high but we also have no history with WC to bring them down. We did not claim on my husband (owner) and our first employee is only on the job two days. Hopefully they will come down but I have a feeling it will take a while.
|
|
|
Post by anneinwa on Jul 30, 2016 1:16:44 GMT
So along with a massive headache I may be a little farther along but still not sure I will be able to work it out. Have been on the phone at least 6 hrs with QB this week and researching/Installing/etc about the same.
I can not do multiple codes on a paycheck... However the rate is figured per $100... WA figures per hour. There is a way to set it up for WA, but so far as I can tell, I can only set up one code this way. For our one employee I can do a work around... If we add a second at a different wage, my workaround will no longer work.
So now to see what's best... Find new software all around or maybe do spreadsheet for WC and input into QB...
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 30, 2016 2:51:31 GMT
I suspect you are going to have to pull hours and rates off of QB and do a WC spreadsheet unfortunately.
I have 4 WC policies currently and finally have 3 on end of quarter dates (instead of mid-quarter weird payroll reconciliations), so I've done lots of WC spreadsheets from QB data. Hopefully in the future my audits will be much easier since QB reports will match back exactly to the time period.
I wish I were in your state and close by because honestly I love solving problems like this --systems/programming/calculators.
|
|
|
Post by anneinwa on Jul 30, 2016 3:17:16 GMT
Thank you for reassuring what I am thinking. Might be going back to online version if that ends up being the case. Hoping by starting desktop didn't stop the online yet...
|
|
|
Post by anneinwa on Jul 30, 2016 3:23:10 GMT
I suspect you are going to have to pull hours and rates off of QB and do a WC spreadsheet unfortunately. I have 4 WC policies currently and finally have 3 on end of quarter dates (instead of mid-quarter weird payroll reconciliations), so I've done lots of WC spreadsheets from QB data. Hopefully in the future my audits will be much easier since QB reports will match back exactly to the time period. I wish I were in your state and close by because honestly I love solving problems like this --systems/programming/calculators. When you bring back into QB, how do you show the deduction? Would I just show the total deduction for that week to show up on their timecard and then I would use the spreadsheets at the time I need to file quarterly with L&I? My plan this weekend is to go in and play around with a few scenarios. I know I can make this work with desktop (working WC on spreadsheet), not sure about online (Husband would prefer that, and honestly I would too because I prefer my MAC to his PC laptop lol)...
|
|
Deleted
Posts: 0
May 8, 2024 11:55:20 GMT
|
Post by Deleted on Jul 30, 2016 14:33:21 GMT
Yes, I would think you would have to calculate the deduction outside of QB and manually input it on each employee as you go per paycheck. That way you can set up just one deduction code. I have one location where the manager calculates all the commissions on a separate spreadsheet and gives me a number that I input directly. On deductions, I used to have some taxable fringe benefits that were outside the system (and different each time for each employee)...on those I had to put them in as wages and then subtract them out as a deduction to get them taxed correctly.
You might be able to sum that deduction for L&I, But yes, you would need then to use the worksheets to back up the details of what you send to L&I.
eta: I also have to this type of workaround when I have an employee who works OT and has commission due. I have to calculate that outside of QB and manually input it. Unfortunately some of the more complicated issues QB just can't do. But it has worked for use pretty well for 11+ years and I love that it auto-integrates with Accounting since they use QB too.
|
|