#### Payroll Tax Calculation

```All my employees are on salary and have the same paycheck every month with
the exception of the occasional bonus or vacation pay out.   I have one
employee who has received just his regular salary all year until this month.
At the beginning of the month he received a separate bonus check, all of
which went to his 401K except for what came out for Federal and State Taxes.
Now when I run his regular salary check, the federal and state taxes are
different then what they usually are.   I didn't change anything in his tax
deduction records and his 401K deduction records are the same as they were on
all his other salary checks.   The tax amounts are higher than they usually
are.   This happens to the be the boss, how do I explain the difference to
him?
```
 0
11/25/2008 6:57:02 PM
greatplains 29623 articles. 5 followers.

1 Replies
531 Views

Similar Articles

[PageSpeed] 54

```Penny, did he exceed the FICA (SS) threshold for withholding with the
bonus check?  That could be the reason.

You don't specify whether the fed taxes withheld on the bonus payment
are FIT or FICA but I assume FICA because if it all went to 401(k),
that check would be exempt from FIT.

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com

```
 0
fhamelly1 (1404)
11/25/2008 7:44:27 PM

Similar Artilces:

Calculating Time #5
Time is a wonderful thing......only I have spent ages trying to sor this problem out with no success, so would be really grateful for som help from the experts please ... I have a sheet which is designed as a "work timesheet", Column D is a start time Eg 09:00 Column E is the finish time EG 16:45 Column G is is a formula to calculate the number of hours worked =(E1-D1)*24 " which from the above example gives a return of 7.7 Hours. The problem I am having is working out a formula to round the tota minutes worked up to the next half hour eg 7.51 or above rounded up t 8.00, ...

Payroll
Has anyone done a conversion from Achieve Payroll to GP? We have a client that is looking for a reference. ...

Tax-Exempt dividends in a Fidelity Account
I use MSMoney 6.0 and have recently made an investment change that includes a tax-exempt MM fund. I am trying to figure out how to make these dividends show up as tax exempt in the tax section of Money. I have the tax exempt box checked in the details section of the investment. Right now the dividends show up as taxable. Does anyone have a solution? I was up on a chat session with Microsoft yesterday and the tech finally just ended my session and went on to her next customer. Thanks and Merry Christmas to all. Levi In microsoft.public.money, Levi wrote: >I use MSMoney 6.0 ...

Payroll checklist 2008 payroll close
I have a question on the procedures for 2008 payroll close 1. We already created our year end wage file, step 7, step 8 we did our back up, step 9 is in process, on steps 10 and 12 if I do this does this affect the year end wage file already created?? We did not print w2s yet, when i clear in active employees in step 12 does it just affect process going forward and not the wage file I already created, I am new at this and this ism our first gp 10 payroll close. Thanks, Jim ...

a if calculation help
Hi all i have a if calculation which i need to expand but I can't figure it out =IF(AND(D21>=1,D21<=7),"week",IF(AND(D21>=8,D21<=15),"2 wks","3 wks")) I need to expand it if you can help would be much appriciated 1-7 Wk 8 - 15 2 wks 16 - 23 3 wks 24 - 31 1 month 32 - 89 2-3 months 90 - 179 6 months 180 + season I hope you understand that for the numbers i need the result showing in the cell i.e. 1- 7 number showing in cell will answer as week Thankyou for your assistance in advance 360 + season Create a 2 colu...

Using a sql script to retrieve Tax amount detail record from RM
Hi; I have a script below to pull the tax detail amount from table RM10601 and RM00401 and I use query in Excel 2007 to retrieve it to my Excel. However; if a sales document has two tax transaction, HST and GST, it will be listed in 2 lines, such as CUSTNMBR DOCNUMBR DOCDATE ORTOTSLS TAXDTLID ORTAXAMT KEL8768 1234567 8/1/2009 0:00 100 HST 12 KEL8768 1234567 8/1/2009 0:00 100 GST 5 1. How possible to combine two lines of result into a single line with expected result below. expected resul...

Need formula to calculate bi-monthly pay dates
I need to create a list or table that returns all pay dates for the 15th and last day of the month for an entire year. The date must adjust forward when the normal pay date falls on a weekend or holiday, e.g. the 15th is Sunday so pay day is the 12th. My attempts have resulted in excessive formulas and no concrete answer. Do you need to account for holidays? This formula works but I don't account for holidays although it'd be easy enough to do so. I'm thinking some "date wizard" (a person that is good at date formulas, that's not me!) can probably ...

VBA Make calculation on range
Hello, Is there a way i can make calculations on a range of cells without using using a for each.. next loop. I want to add 10 to the values in a range. You can do sheet1.range("A:A") = 10 but you can't do = sheet1.range("A:A") + 10. -- Talk to you later Nathan No loop is needed: Sub dural() Set r1 = Range("B1") Set r2 = Range("A1:A100") r1.Value = 10 r1.Copy r2.PasteSpecial Operation:=xlAdd End Sub -- Gary''s Student - gsnu2007L "Nathan" wrote: > Hello, > > Is there a way i can make calculations on a range of...

Allocating Tips in Payroll
In one of the forums, someone asked me several questions regarding tip allocation using GP Payroll. I posted an article to my blog that goes through the entire calculation, but now I cannot find the thread where the question was posed. So, if you are still out there. . . the article was posted to : http://dynamicsconfessions.blogspot.com/2010/03/allocating-tips-in-payroll-how-and-why.html Kind regards, Leslie ...

PAYROLL TAXES
I have Microsoft Money 2004 and cannot figure out how to enter a payroll expense. I need to have gross pay- taxes and net pay showing as the actual amount of check. Please help- email annfbc@aol.com Thanks, Ann Have you tried the special category Paycheck? Look in the sample file or read in help about Paycheck. <anonymous@discussions.microsoft.com> wrote in message news:05d701c3d65c\$fec03310\$a501280a@phx.gbl... > I have Microsoft Money 2004 and cannot figure out how to > enter a payroll expense. I need to have gross pay- taxes > and net pay showing as the actual amoun...

Calculating age #2
How can I calculate a persons age from a birthdate in excel? This is a quick way but not the best: If you put the birthdate in A1: =(TODAY()-A1)/365 You will need to format the cell with General formatting. Judith >-----Original Message----- >How can I calculate a persons age from a birthdate in excel? >. > HI, =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW (),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" From Chip Pearson's site: http://www.cpearson.com/excel/datedif.ht...

Payables Setup
In the Payables Setup Options window, I use an ALL DETAILS tax schedule for the Tax Schedule IDs as I use a range of tax details. However, this is a bit of a problem as tax details are often added and not assigned to this tax schedule. Is there a way to have all details allowed without creating an ALL DETAILS tax schedule? Thanks, Craig thats the only way I am aware of -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users Get our Free Tips and Tricks Newsletter and check out our books at http://www.AccoladePublications.com "Craig" wrote: > ...

calculation and save
If I have a table with parmeters and formulas when I want to save the worksheet it makes automatically ONE more calculation and then saves. I set it up in the in tools/option/calculation "automatic" and "automatic except tables" but the same result happens, when is set it on "manual" does not save automatically the last result before saving. ...

Payroll corrections after Payroll Year is closed
I have a client who closed their payroll year and issued W2s. Now, they've realized that because the last payroll of 2008 was printed on 12/31 but not distributed until January 2nd, it needs to fall into 2009 for wage reporting purposes. My first thought to correct this was to void the checks from the last payroll and re-issue them but I've discovered GP won't let you do this once the payroll year has been closed. Has anyone ever run into this scenario and if so, how was it corrected? Thx, Frank Hamelly MCP-GP, MCT, MVP East Coast Dynamics www.eastcoast-dynamics.com blog: www....

tax-line manager: 401k transfers on paycheck "before tax" tab
Hi. I'm using Money Plus. When I view the tax-line manager for 2007 transactions I have \$0.00 for "Form 1040 > Your IRA contributions". I currently have the portion of my paycheck that goes to my investment account as a transfer on the "before tax" tab of the paycheck transaction entry form. I believe that since this is a transfer I cannot add this category to the tax-line manager. Is the tax-line manager working as I need it to? I would have thought that I want the "Your IRA contributions" portion to reflect the amount that has gone from my paychec...

Calculate due date 1 or 2 years ahead to the first of the followi.
Issue date is June 12,2004. Certificate is valid ( 24 months ) to July 01, 2006. How do I create this is XL? Hi =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) -- Regards Frank Kabel Frankfurt, Germany Wayne wrote: > Issue date is June 12,2004. Certificate is valid ( 24 months ) to > July 01, 2006. How do I create this is XL? I modified your's ... does this make sence..seem's to work =DATE(YEAR(B2)+2,MONTH(B2)+1,DAY(B2)-DAY(B2)+1) "Frank Kabel" wrote: > Hi > =DATE(YEAR(A1)+2,MONTH(A1),DAY(A1)) > > -- > Regards > Frank Kabel > Frankfurt, Germany >...

Calculation Order
Hi I have heard two conflicting stories: 1) Excel calculates worksheets from left to right in the workbook. 2) Excel calculates worksheets in alphabetical order (based on the worksheet name). Does anyone know which is correct? Thanks in advance for your assistance. Hi Kerri, Excel 5 and Excel 95 calculate worksheets in the order they are defined. Excel 97 and 2000 repetitively calculate worksheets in alpahabetic name sequence until all dependencies are resolved. Excel2002 and 2003 still calculate worksheets in alphabetic name sequence but use a global depency table rather than sheet ...

Round a Calculations
For labor, we add \$50 to our cost and then round to the next highest \$25 increment. So if the cost was \$124, we add \$50 using an Iif Statement (iif"laborcost>0, laborcost+50,0), we would want to round it to the next highest \$25 increment so instead of being \$174 it would be \$175. How can I do this in a formula or event procedure? On parts, we like to round to the next highest .99 so if the part was \$7.23, we would want to round that to \$7.99. Can that be done very easily? serviceenvoy@gmail.com wrote: >For labor, we add \$50 to our cost and then round to the next highest >\$...

How to reference main report field in subreport calculation
My main report will populate a field X, but int he sub report, I need to reference that X value in order to do a calculation. How do I do this and where? rickr wrote: >My main report will populate a field X, but int he sub report, I need to >reference that X value in order to do a calculation. How do I do this and >where? Try using Parent.[field x] in VBA code or in a text box expression. -- Marsh MVP [MS Access] ...

Payroll Error
My client's payroll hung up when doing a build, she isn't sure why as she had run one earlier in the day and it was fine. We deleted all the files listed in the knowledgebase article, and did check links. She can now build the batch but when she tries to calculate it she gets and error "UPR Temp Post 1 failed, path does not exist", then an "incorrect record length error". I can't find anything on either of these other than deleting the activity files and work files of the company database and system. Any other ideas? There were none of the temp files ...

Estimated Taxes not quite right with Business Income
I am new to using Schedule C and I have plugged in my gross receipts and = expenses and I have it so that the Software Report correctly shows the = numbers; however I see that in Money Plus Deluxe, the numbers don't show = up correctly. Is this because I need the Premium or Home and Business = Version. It is really no big deal as I can override the numbers. I am = new to doing business receipts and expenses so I hadn't bought the small = business version and will probably just hold off until the next upgrade. ...

No Distribution for Payroll Check
My company just started using GP 10 after the first of the year. I have one employee whose check distribution did not balance. Their deductions and unemployment taxes were deducted from their check but it was not distributioned to a G/L account. What should I be looking at to correct this so that it doesn't happen again? ...

Removing tax on an old invoice
I invoiced a customer and they mailed me a check minus sales tax along with a note reminding me they are tax exempt. (We just switched to RMS and I failed to flag them as exempt when I created them in the system). How should I handle this? Our old system was more basic and allowed me to open past invoices and edit them to fix things like this. I'm having a hard time transitioning into this new way where things are more set in stone. I wish I could edit their invoice and remove the tax but I have a hunch I can't. Do I need to void the invoice and make a new one? Or adjust their a...