Excel help!

Discussion in 'Community Discussion' started by See Post, Jul 20, 2006.

Random Thread
  1. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By TiggerPooh1973

    Anyone here a wiz at Excel formulas??

    I need to create a worksheet to calculate excess wages by quarter. It would make my life a lot easier right now since Quickbooks doesn't calculate local unemployment taxes for me. And I do not really use Excel, so I haven't a clue how to do it myself. Basically I need to enter dollar amounts by quarter and have it track when it goes over the wage limit and give me excess wages. Hope that makes some kind of sense, lol. I can be more specific if someone thinks they can help.

    Thanks!
     
    #1 See Post, Jul 20, 2006
  2. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By Lisann22

    email me...
     
    #2 See Post, Jul 20, 2006
  3. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By TiggerPooh1973

    e-mail sent!
     
    #3 See Post, Jul 20, 2006
  4. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By Lisann22

    Format sent!
     
    #4 See Post, Jul 20, 2006
  5. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By TiggerPooh1973

    OK......not like we didn't already know....but Lisann22 is AWESOME!! She saved me from hitting the bottle at work!!
     
    #5 See Post, Jul 20, 2006
  6. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By Lisann22

    Save the rum for Jack mate! ;>
     
    #6 See Post, Jul 20, 2006
  7. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By TiggerPooh1973

    Hey I would GLADLY share with him!
     
    #7 See Post, Jul 20, 2006
  8. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By DVC_dad

    Yay go Lisann go!!!
     
    #8 See Post, Jul 20, 2006
  9. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By smeeeko

    HURRAY LISANN! (that was pretty darn quick too!) =)
     
    #9 See Post, Jul 20, 2006
  10. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By CrouchingTigger

    "Excess wages"?

    I dunno. I've never had _any_ excess wages. It all seems to get spent somewhere.
     
    #10 See Post, Jul 20, 2006
  11. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By Lisann22

    It's not the best term but she means wages paid beyond their minimum for tax purposes. LOL
     
    #11 See Post, Jul 20, 2006
  12. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By velo

    hey tigger - you can download all payroll info from QB to Excel by going into Reports, Employees and then on the bottom of that list (lol) should be "summarize payroll data in Excel" In addition to wht Lisann might have sent you it might be a good way to collate all your info. It's what I use to show a PIT wagebase for California. It has all the different kinds of earnings data, by employee. (federal too).
     
    #12 See Post, Jul 20, 2006
  13. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By TiggerPooh1973

    Yeah velo, I tried that, but since there is not a "State" option for the V.I. I can't get it to generate anything for me. The federal stuff, FUTA and everything, is fine. It's the local unemployment which has a different wage base that is the problem.
     
    #13 See Post, Jul 20, 2006
  14. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By velo

    so, in addition to paying FUTA, you have to pay a VI unemployement rate? Yikes! What's the percentage?
     
    #14 See Post, Jul 20, 2006
  15. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By velo

    and if you download from QB, at least you don't have to imput lots of figures.
     
    #15 See Post, Jul 20, 2006
  16. See Post

    See Post New Member

    Joined:
    Apr 28, 2016
    Messages:
    5,319
    Likes Received:
    84
    Trophy Points:
    0
    Originally Posted By TiggerPooh1973

    You don't have state unemployment taxes?

    Our local unemployment tax is high too, compared to FUTA. The wage base is $20,000 and a new business starts at a rate of 1%.
     
    #16 See Post, Jul 21, 2006
(You must log in or sign up to post here.)

Share This Page