LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default how do I stop payroll tax deductions once FUTA limit is met?

what is the formula required to stop employee and employer paid taxes once a
tax limit criteria has been met? Ex. once 7000.00 in gross wages has been
met, you no longer have to take out FUTA.

It is easy to figure out the formula above and well below 7000.00, the
problem is that one pay period when they finally meet the 7000.00, but it
does not know what to do with the excess amount. Example. pay period 1 -
employee gross wages are 2000. Tax formula works fine. Pay perios 2,
another 2000 in wages, now YTD total is 4000. Still fine. Pay period 3,
another 2000, everything still fine because YTD is now 6000. But now on pay
period 4 - another 2000, but now it jumps to 8000 YTD. But my forumula does
not work, because he went over 7000, but it didn't know how to add just the
1000 difference to cap the FUTA at 7000.

anyone out there that knows what the formula would be, please help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula in a cell to calc FUTA tax 12by8 Excel Worksheet Functions 10 April 24th 23 11:43 AM
Payroll tax deductions jgoblish Excel Discussion (Misc queries) 4 March 2nd 08 07:34 PM
Adding payroll stubs payroll calculator Sable New Users to Excel 2 August 5th 06 05:37 PM
need spreadsheet for the calculation of FUTA & SUTA payroll taxes [email protected] Excel Discussion (Misc queries) 0 December 22nd 05 08:53 PM
How do I setup a formula for payroll deductions in excel Skeeter Excel Worksheet Functions 1 February 6th 05 09:51 PM


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"