all data is live and searchable
|
Basic Assignments
|
Options & Settings
|
Main Time Information
|
||||||||||||||||||||||
|
|
|
Yellow
|
|
||||||
|
||||||
|
|
|
Notes:
|
|
Scan: Notes – To-Do - Hard code state initials into Fed State Allowance table - Changed allowed amount in Fed State Allowances – CO 2013, 2014 - When done – we need to get the developer’s fed state allowances & his state tax tables Scan: Payroll Sketch of flow & relationships: Payroll (Please see sketches & flow on scan in photo gallery) Users – department – connects (many) – action Payroll – calculate (giant add form) – action (hits the db) – view or edit – action (hits the db) Has not hit but needed State supplied: Your wage limit is ____, your % is ____ State: employee txs/employer cont Scan: Payroll Working with a developer on payroll & how things work Payroll home (start) – check joiner table & calc – record personal payroll - Department home - Add/edit payee to department - Payroll home - Calculate payroll - Record personal payroll Sketches, examples, & flow – please see scan in photo gallery Scan: Payroll Research Payroll Research: Formula for Computing Tax to be Withheld: LEGEND: - G = Gross pay for pay period - P = Number of pay periods per year - A = Annualized gross pay (G x P) - E1 = Personal and Dependent Exemptions - E2 = Age 65 and Over & Blind Exemptions - T = Annualized taxable income - W = Annualized tax to be withheld - W/H = Tax to be withheld for pay period Formula (Effective January 1, 2008) 1. (G)P – [$3,000 + (E1 x $930) + (E2 x 8000] = T 2. If: a. T is: Not over $3,000 b. W is: 2 % of T c. T is: Over $3,000 But not Over $5,000 d. Then: $60 + (3% of excess over $3,000) e. T is: Over $5,000 But not Over $17,000 f. Then: $120 + (5% of excess over $5,000) g. If Over $17,000 h. Then: $720 + (5.75% of excess over $17,000 3. W + P = W/H Example: John claims exemptions for himself, his wife, and their three children for withholding tax purposes. He is paid on a semimonthly basis, and his gross wages for this pay period were $725. 1. T = (G)P – [3,000 + (930)E1] So T = (725)24 – [3,000 + (930)5] 17,400 – 7.650 = 9,750(T) 2. T is over $5,000, but not over $17,000 So W = $120 + 5% of $4,750 $120 + $237.50 = $357.50 3. W/H = W / P So $357.50 / 24 = $14.90 The tax to be withheld for the current period is $14.90 Pay Period Conversion Table (P) - Annual = 1 - Semiannual = 2 - Quarterly = 4 - Monthly = 12 - Semimonthly = 24 - Bi weekly = 26 - Weekly = 52 - Daily = 300 |